This page (revision-16) was last changed on 26-Nov-2021 10:22 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
16 26-Nov-2021 10:22 5 KB Karen Parrott to previous
15 26-Nov-2021 10:22 5 KB Kevin Higgs to previous | to last
14 26-Nov-2021 10:22 5 KB Kevin Higgs to previous | to last
13 26-Nov-2021 10:22 5 KB Kevin Higgs to previous | to last
12 26-Nov-2021 10:22 5 KB Kevin Higgs to previous | to last
11 26-Nov-2021 10:22 4 KB Kevin Higgs to previous | to last
10 26-Nov-2021 10:22 4 KB rforbes to previous | to last
9 26-Nov-2021 10:22 4 KB JMyers to previous | to last
8 26-Nov-2021 10:22 7 KB JEscott to previous | to last
7 26-Nov-2021 10:22 7 KB RForbes to previous | to last
6 26-Nov-2021 10:22 7 KB JEscott to previous | to last
5 26-Nov-2021 10:22 7 KB JEscott to previous | to last
4 26-Nov-2021 10:22 7 KB JEscott to previous | to last
3 26-Nov-2021 10:22 7 KB JEscott to previous | to last
2 26-Nov-2021 10:22 7 KB JEscott to previous | to last
1 26-Nov-2021 10:22 7 KB JEscott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 4 changed one line
Pay lines loaded through SqlLoader may be sourced from the Time Scheduling applications or come from an external source such as another system. e.g. a time clock or PC application
Pay lines loaded through LMTD may be sourced from the Time Scheduling applications or come from an external source such as another system. e.g. a time clock or PC application
At line 9 changed one line
;[Row|DRV_ID]:Column ID, ID is a mandatory 10-character numeric mandatory field that is assigned by eP when a row added.
;[Row|DRV_ID]:DRV_ID is a mandatory 10-character numeric mandatory field that is assigned by eP when a row added.
At line 20 changed 2 lines
;[Basis|RATE_BASIS]:This field shows the rate basis of the wage for the pay line being loaded. Rate_Basis is a mandatory field with a fixed lexicon (X_RATE_BASIS) that you may use to look up the value.
;[Employment Type|EMPLOYMENT_TYPE]:Employment Type of the employee for the pay line being loaded is indicated here. Employment_Type is a mandatory field with a fixed lexicon (X_EMPLOYMENT_TYPE) that you may use to look up the value.
;[Basis|RATE_BASIS]:This field shows the rate basis of the wage for the pay line being loaded. Rate_Basis is a mandatory field with a fixed lexicon ([X_RATE_BASIS]) that you may use to look up the value.
;[Employment Type|EMPLOYMENT_TYPE]:Employment Type of the employee for the pay line being loaded is indicated here. Employment_Type is a mandatory field with a fixed lexicon ([X_EMPLOYMENT_TYPE]) that you may use to look up the value.
At line 23 changed one line
;[Destination|DESTINATION_TYPEA]: This field indicates if the lines are to be loaded into a Pay Line, Pay Transaction or Leave Line. Do not use Destination ‘UFLOAD’. It is handled by a different function. Destination_Type is an optional field you may fill with the fixed lexicon (X_DESTINATION_TYPE) provided.
;[Destination|DESTINATION_TYPE]: This field indicates if the lines are to be loaded into a Pay Line, Pay Transaction or Leave Line. Do not use Destination ‘UFLOAD’. It is handled by a different function. Destination_Type is an optional field you may fill with the fixed lexicon ([X_DESTINATION_TYPE]) provided.
At line 25 changed 2 lines
;[UPTL Status|UPTL_STATUS]: This field shows the status of Loaded Pay Line. UPTL_Status is an optional field you may fill with the fixed lexicon (X_UPTL_STATUS) provided.
;[Assignment|ASSIGNMENT_CODE]: This field displays the employee’s assigment. Assignment_Code is an optional 16-character alphanumeric field you may fill manually.
;[UPTL Status|UPTL_STATUS]: This field shows the status of Loaded Pay Line. UPTL_Status is an optional field you may fill with the fixed lexicon ([X_UPTL_STATUS]) provided.
;[Assignment|ASSIGNMENT_CODE]: This field displays the employee’s assignment. Assignment_Code is an optional 16-character alphanumeric field you may fill manually.
At line 40 changed 2 lines
;[Reason for Time|REASON_FOR_TIME]: If a reason for the time is required it may be indicated here. Reason_for_Time is an optional field you may fill from the user-defined lexicon (X_REASON_FOR_TIME) provided.
;[Leave Reason|LEAVE_REASON]: If the line is going to a leave line, a leave reason may be indicated. Leave_Reason is an optional field you may fill with the fixed lexicon (LEAVE_REASON) provided.
;[Reason for Time|REASON_FOR_TIME]: If a reason for the time is required it may be indicated here. Reason_for_Time is an optional field you may fill from the user-defined lexicon ([X_REASON_FOR_TIME]) provided.
;[Leave Reason|LEAVE_REASON]: If the line is going to a leave line, a leave reason may be indicated. Leave_Reason is an optional field you may fill with the fixed lexicon ([X_LEAVE_REASON]) provided.