LOAD DATA
   TRUNCATE 
   INTO TABLE LICS_STG_FILE 
   (
       RECORD_NO					"LICS_RECORD_NO.NEXTVAL", 	
       MEME_HICN                         	position(1:12),
       CONTRACT_NO		                position(13:17),
       PBP_ID			        position(18:20),
       SEGMENT_NO		                position(21:23),
       RUN_DATE			        position(24:31) "to_timestamp(:RUN_DATE,'YYYYMMDD')",
       SBSDY_EFF_DT		        	position(32:39) "to_timestamp(:SBSDY_EFF_DT,'YYYYMMDD')",
       SBSDY_TERM_DT		        	position(40:47) "NVL2(TRIM(:SBSDY_TERM_DT),to_timestamp(: SBSDY_TERM_DT,'YYYYMMDD'),to_timestamp('12/31/9999','MM/DD/YYYY'))",
       PARTD_SBSDY_PERC		        position(48:50),
       LIS_COPAY_LVL		            	position(51:51),
       ENR_EFF_DT		        	position(52:59) "to_timestamp(:ENR_EFF_DT,'YYYYMMDD')",
       ENR_TERM_DT		                position(60:67) "to_timestamp(:ENR_TERM_DT,'YYYYMMDD')",
       PRTC_PREM		            	position(68:75) "to_number(:PRTC_PREM)",
       PRTD_PREM		            	position(76:83) "to_number(:PRTD_PREM)",
       LATE_PENALTY		    		position(84:91) "to_number(:LATE_PENALTY)",
       MEMD_LICS_SBSDY		        position(92:99) "to_number(:MEMD_LICS_SBSDY)",
       LIS_PENALTY		        	position(100:107) "to_number(:LIS_PENALTY)",
       MEMD_LATE_WAIV_AMT	            	position(108:115) "to_number(:MEMD_LATE_WAIV_AMT)",
       MEMD_TOTAL_PREM        		        position(116:123) "to_number(:MEMD_TOTAL_PREM)" 
   )