Table Definitions - Leave Management
Cost Days
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
20=Cost Days 1 | LEAVES | COSTING_DAYS_1 | Size: 10 Format: ######.#### |
22=Cost Days 2 | LEAVES | COSTING_DAYS_2 | Size: 10 Format: ######.#### |
24=Cost Days 3 | LEAVES | COSTING_DAYS_3 | Size: 10 Format: ######.#### |
Cost Rule
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
21=Cost Rule 1 Code | LEAVES | COSTING_RULE_1_CODE | Size: 10 |
21=Cost Rule 1 Description | LEAVES | COSTING_RULE_1_DESC | Detailed Explanation of code. Size: 30 |
23=Cost Rule 2 Code | LEAVES | COSTING_RULE_2_CODE | Size: 10 |
23=Cost Rule 2 Description | LEAVES | COSTING_RULE_2_DESC | Detailed Explanation of code. Size: 30 |
25=Cost Rule 3 Code | LEAVES | COSTING_RULE_3_CODE | Size: 10 |
25=Cost Rule 3 Description | LEAVES | COSTING_RULE_3_DESC | Detailed Explanation of code. Size: 30 |
Leave Application
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
02=Leave Type | LEAVES | LEAVE_TYPE_CODE | Size: 4 |
02=Leave Type | LEAVES | LEAVE_TYPE_DESC | Detailed Explanation of code. Size: 30 |
03=Location | LEAVES | LOCATION_CODE | Size: 4 |
03=Location | LEAVES | LOCATION_NAME | Detailed Explanation of code. Size: 30 |
04=Position | LEAVES | POSITION_CODE | Size: 8 |
04=Position | LEAVES | POSITION_DESC | Detailed Explanation of code. Size: 30 |
05=Medical Form | LEAVES | MEDICAL_NOTE_YN | Internal Lookup: Y=Yes, N=No, Size: 3 |
06=Docs | LEAVES | OTHER_DOCUMENTS_YN | Internal Lookup: Y=Yes, N=No, Size: 3 |
07=Start Date | LEAVES | START_DATE | Size: 11 Format: DD-MMM-YYYY |
08=End Date | LEAVES | END_DATE | Size: 11 Format: DD-MMM-YYYY |
09=Week Days | LEAVES | DAYS_OF_WEEK | Size: 7 |
10=Days | LEAVES | INTERFACED_DAYS | Size: 10 Format: ######.#### |
12=Cost Rule | LEAVES | APPL_COST_RULE_CODE | Size: 14 |
12=Cost Rule | LEAVES | APPL_COST_RULE_DESC | Detailed Explanation of code. Size: 30 |
13=Comment | LEAVES | APPLICATION_COMMENT | Size: 30 |
Leave Approval
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
14=Status | LEAVES | STATUS_CODE | Internal Lookup: R=Requested, A=Approved, D=Denied, V=Under Review, C=Cancelled, Size: 4 |
15=Approval Date | LEAVES | APPROVED_DATE | Size: 11 Format: DD-MMM-YYYY |
16=Replacing Code | LEAVES | REPLACEMENT_TYPE_CODE | Size: 10 |
16=Replacing Code | LEAVES | REPLACEMENT_TYPE_DESC | Detailed Explanation of code. Size: 30 |
16=Replacing Type | LEAVES | APPR_REPL_TYPE_CODE | Size: 10 |
17=Replacing Emp | LEAVES | REPLACING_EMPLOYEE_NAME | Detailed Explanation of code. Size: 30 |
17=Replacing Emp | LEAVES | REPLACING_EMPLOYEE_NO | This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
18=Approving Emp | LEAVES | APPROVING_EMPLOYEE_NAME | Detailed Explanation of code. Size: 30 |
18=Approving Emp | LEAVES | APPROVING_EMPLOYEE_NO | This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
19=Comment | LEAVES | APPROVED_COMMENT | Size: 30 |
Time Used: | LEAVES | TOTAL_UNITS | Size: 10 Format: ######.#### |
Other Costing Information
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
26=Customer # | LEAVES | CUSTOMER_NO | Size: 10 |
27=Approv # | LEAVES | APPROVAL_NO | Size: 10 |
29=Abs Cost Center | LEAVES | ABS_COST_CENTER | Size: 10 |
30=Abs GL | LEAVES | ABS_GL_ACCOUNT_NO | Size: 20 |
30=Abs GL | LEAVES | ABS_SL_ACCOUNT_NO | Size: 10 |
31=Rep Cost Center | LEAVES | REP_COST_CENTER | Size: 10 |
32=Rep GL | LEAVES | REP_GL_ACCOUNT_NO | Size: 20 |
32=Rep GL | LEAVES | REP_SL_ACCOUNT_NO | Size: 10 |
33=Supplmental Billing Info | LEAVES | SUPP_BILLING_COMMENT | Size: 30 |