-- Loader Utility for loading into
-- table EUC.PMSNA_SAP_SVC_ACTIVITY
--
-- History:
-- -------
--
-- When Who What
-- ---- --- ----
--
-- 30SEP03 jjm SIR 13637 (adds 10 columns)
-- changed location of infile
--
-- $Log$
--
options (errors=0, silent=discards, direct=true)
load data
infile '/nfs/rum/usr/sap/tmp/outbound/svcactivity.dat'
-- infile '/nfs/rum/usr/sap/tmp/outbound/svcactivity.dat'
--infile '/nfs/uspmsh50/usr/sap/tmp/outbound/svcactivity.dat'
badfile '/oracle/EUC/scripts/oracle/logs/svcactivity.bad'
discardfile '/oracle/EUC/scripts/oracle/logs/svcactivity.dsc'
replace
into table euc.pmsna_sap_svc_activity (
SALES_OFF_CODE CHAR(004),
SALES_OFF_NAME CHAR(020),
SALES_GRP_CODE CHAR(003),
SALES_GRP_NAME CHAR(020),
DISTRICT_CODE CHAR(006),
DISTRICT_NAME CHAR(020),
BUS_GROUP_CODE CHAR(004),
BUS_GROUP_NAME CHAR(030),
BUS_UNIT_CODE CHAR(004),
BUS_UNIT_NAME CHAR(030),
MAIN_ART_GRP_CODE CHAR(003),
MAIN_ART_GRP_NAME CHAR(030),
ARTICLE_GRP_CODE CHAR(004),
ARTICLE_GRP_NAME CHAR(030),
UPC_NUMBER CHAR(007),
BILL_TO_CUST_NUM CHAR(010),
BILL_TO_NAME CHAR(035),
BILL_TO_CITY CHAR(035),
BILL_TO_STATE CHAR(003),
SITE_NUMBER CHAR(018),
SITE_NAME CHAR(040),
ACTIVITY_STATUS CHAR(040),
ORDER_STATUS_HOLD CHAR(004),
ORDER_STATUS_HOLD_TEXT CHAR(030),
ORDER_STATUS_HPMM CHAR(004),
ORDER_STATUS_HPMM_TEXT CHAR(030),
ORDER_STATUS_MOBL CHAR(004),
ORDER_STATUS_MOBL_TEXT CHAR(030),
ORDER_STATUS_PTCL CHAR(004),
ORDER_STATUS_PTCL_TEXT CHAR(030),
ORDER_STATUS_PTMD CHAR(004),
ORDER_STATUS_PTMD_TEXT CHAR(030),
SALES_ORDER_NUMBER CHAR(012),
SALES_ORDER_LINE CHAR(006),
CONTRACT_NUMBER CHAR(010),
CONTRACT_LINE CHAR(006),
CONTRACT_KEY CHAR(017),
CONTRACT_TYPE CHAR(018),
CONTRACT_VENDOR CHAR(012),
PHILIPS_OEM CHAR(011),
NOTIFICATION CHAR(012),
WORKORDER CHAR(012),
OPERATION CHAR(004),
OPERATION_DESC CHAR(040),
OPERATION_PLANNED_WORK CHAR(007),
CALL_NUMBER CHAR(016),
CONTROL_KEY_CODE CHAR(004),
CONTROL_KEY_DESC CHAR(040),
ORDER_TYPE_CODE CHAR(004),
ORDER_TYPE_DESC CHAR(030),
CALL_TYPE_CODE CHAR(004),
CALL_TYPE_DESC CHAR(030),
PRIORITY_CODE CHAR(001),
PRIORITY_DESC CHAR(025),
CAUSE_CODE CHAR(004),
CAUSE_DESC CHAR(020),
DAMAGE_CODE CHAR(004),
DAMAGE_DESC CHAR(040),
ACTIVITY_CODE CHAR(004),
ACTIVITY_DESC CHAR(035),
LABOR_ACTIVITY_CODE CHAR(006),
LABOR_ACTIVITY_DESC CHAR(020),
REPORTED_PROBLEM CHAR(040),
ORIG_MANU_DESC CHAR(030),
MODEL CHAR(020),
SERIAL_NUMBER CHAR(018),
SYSTEM_NO CHAR(018),
SYSTEM_DESC CHAR(030),
OPERATING_SYSTEM CHAR(018),
CUSTOMER_CONTACT CHAR(040),
CONTACT_PHONE_NO CHAR(020),
CALL_INITIATOR CHAR(012),
CUSTOMER_PUR_ORD CHAR(035),
DISPATCHER_NUMBER CHAR(012),
SERVICEMAN_NUMBER CHAR(012),
SERVICEMAN_NAME CHAR(040),
CONTACT_DATE DATE(008) 'YYYYMMDD' nullif CONTACT_DATE = blanks,
CONTACT_TIME CHAR(005),
EFFECT_DATE DATE(008) 'YYYYMMDD' nullif EFFECT_DATE = blanks,
EFFECT_TIME CHAR(005),
COMMIT_DATE DATE(008) 'YYYYMMDD' nullif COMMIT_DATE = blanks,
COMMIT_TIME CHAR(005),
ARRIVE_DATE DATE(008) 'YYYYMMDD' nullif ARRIVE_DATE = blanks,
ARRIVE_TIME CHAR(005),
COMPLETE_DATE DATE(008) 'YYYYMMDD' nullif COMPLETE_DATE = blanks,
COMPLETE_TIME CHAR(005),
WORK_HOURS_REG CHAR(007),
TRAVEL_HOURS_REG CHAR(007),
WAIT_HOURS_REG CHAR(007),
TOTAL_REG_HOURS CHAR(007),
AB_WORK_HOURS CHAR(007),
SUNDAY_OR_HOLIDAY CHAR(001),
WORK_HOURS_OT CHAR(007),
TRAVEL_HOURS_OT CHAR(007),
WAIT_HOURS_OT CHAR(007),
TOTAL_OT_HOURS CHAR(008),
TOT_LABOR_HOURS CHAR(008),
DUR_CONTACT_COMMIT CHAR(013),
DUR_EFFECT_ARRIVE CHAR(013),
DUR_EFFECT_CLOSED CHAR(013),
TOT_OPEN_TIME CHAR(013),
CONTRACT_EXP_DT DATE(008) 'YYYYMMDD' nullif CONTRACT_EXP_DT = blanks,
JOB_GRADE_DESC CHAR(030),
METER_READING CHAR(016),
FCO_NUMBER CHAR(008),
RTAC_CAPABLE CHAR(001),
RTAC_ENTITLED CHAR(001),
SERVICE_CONTROLLER CHAR(020),
LAST_SERVICE_DATE DATE(008) 'YYYYMMDD' nullif LAST_SERVICE_DATE = blanks,
IN_PROCESS_STATUS CHAR(006),
CLOSED_STATUS_DESC CHAR(040),
LEAD_INSTALLER_NUM CHAR(008),
LEAD_INSTALLER_NAME CHAR(040),
REFRESH_DATE CHAR(008),
REFRESH_TIME CHAR(005),
WORK_HOURS_THIRDS CHAR(007),
CONFIRMED_DATE DATE(008) 'YYYYMMDD' NULLIF CONFIRMED_DATE = BLANKS,
CONFIRMED_TIME CHAR(005),
ACTUAL_START_DATE DATE(008) 'YYYYMMDD' NULLIF ACTUAL_START_DATE = BLANKS,
ACTUAL_START_TIME CHAR(005),
ACTUAL_FIN_DATE DATE(008) 'YYYYMMDD' NULLIF ACTUAL_FIN_DATE = BLANKS,
ACTUAL_FIN_TIME CHAR(005),
OPER_ACTIVITY_STATUS CHAR(015),
USER_STATUS CHAR(010),
REPAIR_TEXT CHAR(255),
PROFIT_CENTER CHAR(10),
PROFIT_CTR_DESC CHAR(20),
WORK_CENTER CHAR(10),
WORK_CTR_DESC CHAR(20),
COST_CENTER CHAR(10),
COST_CTR_DESC CHAR(20),
SHIP_TO_CUST_NUM CHAR(10),
SHIP_TO_NAME CHAR(35),
FUNC_LOC CHAR(30),
FUNC_LOC_DESC CHAR(40)
)