Uploading Leave Details

Leave tables to be Uploaded --"HS_HR_LEAVE-DETAIL",
"HS_HR_LDETAIL_BREAKDOWN"


Step1 : Open a New Excel Sheet and Format the Following mandatory fields.
EMP_NUMBER ::'Text'
LD_FROM_DATE::'Date'-*14/03/2001-English(United States)
LD_To_DATE :: 'Date'-*14/03/2001-English(United States)
LD_DAYS ::'Text'
LD_APP_ID ::'General'
LD_APPROVED ::'General'
LEV_TYPE_CODE::'Text'-'000000'



Step2: After arranging the above formats for the respective fields,
upload the data using Access or through Enterprise manager.

Step3: After Uploading/Appending check for the tables whether the Corresponding tables are updated.

Step4: After the tables got uploaded,update the following flags to complete the whole process.

UPDATE HS_HR_LEAVE_DETAIL SET LD_APP_STATUS='1'
UPDATE HS_HR_LEAVE_DETAIL SET LD_APPROVED='1'
UPDATE HS_HR_LEAVE_DETAIL SET LD_APP_APPROVED='1'
UPDATE HS_HR_LEAVE_DETAIL SET APP_APPROVED='1'
UPDATE HS_HR_LEAVE_DETAIL SET LD_APPLICATION_TYPE='0'
UPDATE HS_HR_LEAVE_DETAIL SET CANCEL_APPROVED='0'

Step5: After finishing all steps in database,Now open the Attendance System,Go to MOVEMENT-->Process-->
and process the data for the corresponding month,we have uploaded.

Step6: After processing the Attendance,go for TIMESHEET.

In TimeSheet the LOP values should be '0' for corresponding Employee on respective dates.

These are the steps to be followed regularly during Leave Data Upload.