Importing Leave Codes
The following tables show examples of data fields used in the Leave Codes section of the MasterPR.DEF file:
Header
| Table: tblPRLeaveCode | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,LEAVECODE,HEADER,HLEAVE | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
PR_LV_CODE |
Y |
User Defined |
Leave Code ID |
|
|
PR_LV_STATUS |
N |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
PR_LV_TITLE |
Y |
User Defined |
Leave Code Title |
|
|
PR_LV_MAX_ |
N |
Single |
9999.9900 |
If line is not included in *.DEF file, it defaults to 9999.99. If item is included with no value, it defaults to 0.00. |
|
PR_LV_MAX_ |
N |
Single |
9999.9900 |
Must be greater than or equal to PR_LV_MAX_ |
|
PR_LV_CALC_MAX_ |
Y |
Single |
0.0000 |
Required if calculation method of FP. |
|
PR_LV_CALC_METHOD |
Y |
2 |
FN |
Valid Calculation Methods: FN, AT, FP, or PT. See Table 3. |
|
PR_LV_CALC_HOURS |
Y |
Rate |
0.0000 |
Required if calculation method of FN. |
|
PR_LV_CALC_PERCENT |
Y |
Rate |
000.0000 |
Required if calculation method of FP. Enter 5% as 05 or 5. |
|
PR_LV_CALC_MAX_ |
N |
8 |
000.0000 |
Maximum percentage allowed on timesheet for PT. Enter 5% as 05 or 5. |
Detail
| Table: tblPRLeaveCodeEarning | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,LEAVECODE,DETAIL,DLEAVE | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
PR_EC_CODE |
Y |
User Defined |
Required if calculation method of FP. Can have more than one earning code. Must be a valid code (Maintain>Payroll>Earning Codes). |
|