Controll file to upload employee data

-- File Name         : XXARJ_HR_CNV_PEOPLE_TMP.ctl
-- File Type         : SQL*Loader Control file.
-- RICEW Object id   : HR_CNV_01
-- Description       : This SQL*Loader file is used to load  data
--                     from flat file to the staging table XXPLL_HR_CNV_PEOPLE_TMP
-- Maintenance History:
LOAD DATA
INFILE '/genhor12app/hc12u/uat/apps/apps_st/appl/XXARJ/12.0.0/data/XXARJ_HR_CNV_PEOPLE_TMP.csv'
APPEND
INTO TABLE  XXPLL_HR_CNV_PEOPLE_TMP
TRUNCATE
FIELDS TERMINATED BY "," optionally enclosed by '"'
TRAILING NULLCOLS
(  "EMPLOYEE_NUMBER",
    "GENDER",
    "TITLE",
    "FIRST_NAME",
    "MIDDLE_NAME",
    "LAST_NAME",
    "USER_PERSON_TYPE",
    "MARITAL_STATUS",
    "DATE_OF_BIRTH",
    "HIRE_DATE",
    "NATIONALITY",
    "COUNTRY_OF_BIRTH",
    "BLOOD_TYPE",
    "PAN_NUMBER",
    "PAN_APPLIED_FOR",
    "PAN_REFERENCE_NUMBER",
    "RESIDENTIAL_STATUS",
    "PF_NUMBER",
    "ESI_NUMBER",
    "SUPERANNUATION_NUMBER",
    "GROUP_INSURANCE_NUMBER",
    "NSSN",
    "PENSION_FUND_NUMBER",
    "BGC_CONDUCTED",
    "BGC_STATUS",
    "BGC_CONDUCTED_ON",
    "EMPLOYEMENT_STATUS",
    "DISABILTY",
    "CONTRACT_END_DATE",
    "ROLE_IF_ANY",
    "PRESENT_POSITION_TITLE",
    "SUPERVISOR_NUMBER",
    "FULL_NAME_SUPER",
    "EFFECTIVE_START_DATE",
    "EFFECTIVE_END_DATE",
    "EMAIL_ADDRESS",
    "LOCATION_CODE",
    "JOB_NAME",
    "GRADE",
    "ORGANIZATION_NAME_ORG",
    "LEGACY_EMPLOYEE_ID",
    "TOWN_OF_BIRTH",
    "REGION_OF_BIRTH",
    "GRATUITY_NUMBER",
    "ASSIGN_STATUS_TYPE",
    "PROBATION_PERIOD",
    "PROBATION_UNIT",
    "ASSIGNMENT_CATEGORY",
    "EMPLOYEE_CATEGORY",
    "GREORLEGALENTITY",
    "PFORGANIZATION",
    "PROFESSIONALTAXORGANISATION",
    "ESIORGANIZATION",
    "FACTORY",
    "ESTABLISHMENT",
    "COVERED_BY_GRATUITY_ACT",
    "HAVING_SUBSTANTIAL_INTEREST",
    "DIRECTOR",
    "SPECIFIED_EMPLOYEE",
    "PFEPSCONTRIBUTION",
    "LEGAL_NAME",
    "PASSPORT_NUMBER",
    "PASSPORT_COUNTRY_OF_ISSUE",
    "CPF_CATEOGRY",
    "RACE",
    "COMUNITY_FUND_CATEOGRY",
    "PAYESS_ID",
    "NRICFN",
    "PERMIT_TYPE",
    "PERMIT_NUMBER",
    "PERMIT_CATEGORY",
    "PERMIT_DATE_ISSUE",
    "PERMIT_EXPIRY_DATE",
    "INCOME_TAX_NUMBER",
    "CPFACCNUMBER",
    "CPF_CATEGORY",
    "INOME_TAX_NUMBER_SPOUSE",
    "PASSPORT_DATE_ISSUED",
    "PASSPORT_DATE_EXPIRY",
    "SYSTEM_PERSON_TYPE",
    "NEW_EMPLOYEE_NUMBER",
    "PAYROLL_NAME",
    "FUNCTIONAL_MGR",
    "EX_SERVICEMAN",
    "GROUP_NAME",
    "SUBGROUP_NAME",
    "PROCESS_FLAG" CONSTANT 'N',
    "ERROR_MESSAGE",
    "CREATION_DATE" SYSDATE,
    "CREATED_BY" "FND_GLOBAL.USER_ID",
    "LAST_UPDATE_DATE" SYSDATE,
    "LAST_UPDATED_BY" "FND_GLOBAL.USER_ID",
    "LAST_UPDATE_LOGIN" "FND_GLOBAL.LOGIN_ID",
    "REQUEST_ID"
 )