Table Definitions - Seniority
Employee Seniority
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
02=Seniority Code | SENIORITY | * SENIORITY_CODE | Size: 10 |
02=Seniority Code | SENIORITY | SENIORITY_CODE | Size: 10 |
02=Seniority Code | SENIORITY | SENIORITY_CODE_DESCRIPTION | Detailed Explanation of code. Size: 30 |
02=Seniority Description | SENIORITY | * SENIORITY_CODE_DESCRIPTION | Size: 30 |
03=Amount (Hours) | SENIORITY | TOTAL_HOURS | Size: 10 Format: ########.## |
04=Amount (Days) | SENIORITY | TOTAL_DAYS | Size: 10 Format: ########.## |
Days | SENIORITY | * DAY_SENIORITY | Current Seniority Size: 10 Format: ########.## |
Days | SENIORITY | DAY_SENIORITY | Current Seniority Size: 10 Format: ########.## |
Month | SENIORITY | * MONTH_SENIORITY | Current Seniority Size: 6 Format: ########### |
Month | SENIORITY | MONTH_SENIORITY | Current Seniority Size: 6 Format: ########### |
Select only Current Seniority | SENIORITY | CUR_HIRE_SENIORITY_ONLY_YN | Internal Lookup: Y=Yes, current hire seniority codes, N=No, all seniority codes, Size: 10 |
Total Days | SENIORITY | * TOTAL_DAYS | Current Seniority Size: 10 Format: ########.## |
Total Hours | SENIORITY | * TOTAL_HOURS | Current Seniority Size: 10 Format: ########.## |
Vacation Seniority | SENIORITY | * VACATION_SENIORITY | Size: 10 Format: ########.## |
Vacation Seniority | SENIORITY | VACATION_SENIORITY | Size: 10 Format: ########.## |
Years | SENIORITY | * YEAR_SENIORITY | Current Seniority Size: 4 Format: ########### |
Years | SENIORITY | YEAR_SENIORITY | Current Seniority Size: 4 Format: ########### |
Employee Seniority Adjustment
| Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
02=Seniority Bank | SENIORITY_ADJUSTMENT | SENIORITY BANK DESC | Detailed Explanation of code. Size: 30 |
02=Seniority Bank | SENIORITY_ADJUSTMENT | SENIORITY_BANK_CODE | Size: 10 |
03=Pay ID | SENIORITY_ADJUSTMENT | PAYROLL_DESCRIPTION | Detailed Explanation of code. Size: 30 |
03=Pay ID | SENIORITY_ADJUSTMENT | PAYROLL_ID | Size: 10 |
04=Period | SENIORITY_ADJUSTMENT | PAY_PERIOD | Size: 6 |
05=Type | SENIORITY_ADJUSTMENT | TYPE | Internal Lookup: O=Calculated From Payroll, M=Manual, Size: 4 |
06=Amount | SENIORITY_ADJUSTMENT | AMOUNT | Size: 10 Format: ########.## |
07=Unit [D/H] | SENIORITY_ADJUSTMENT | UNIT_TYPE | Internal Lookup: H=HOURS, D=DAYS, Size: 10 |
08=Hours Per Day | SENIORITY_ADJUSTMENT | HOURS_PER_DAY | Size: 10 Format: ########.## |
09=Comment | SENIORITY_ADJUSTMENT | COMMENT | Size: 80 |
Date | SENIORITY_ADJUSTMENT | DATE | Size: 11 Format: DD-MMM-YYYY |
Internal: Date Adjustment was made | SENIORITY_ADJUSTMENT | TIMESTAMP | Size: 20 Format: DD-MMM-YYYY H |
Seniority Code Selection
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
Seniority Code #1 | SENIORITY | CUR_HIRE_SEN_CODE_01 | Size: 10 |
Seniority Code #2 | SENIORITY | CUR_HIRE_SEN_CODE_02 | Size: 10 |
Seniority Code #3 | SENIORITY | CUR_HIRE_SEN_CODE_03 | Size: 10 |
Seniority Code #4 | SENIORITY | CUR_HIRE_SEN_CODE_04 | Size: 10 |
Seniority Code #5 | SENIORITY | CUR_HIRE_SEN_CODE_05 | Size: 10 |
Seniority Definition
Field in atrieveERP | Report Writer Table | Report Writer Field | Field Information |
|---|---|---|---|
01=Def Code | DEFINED_SENIORITY | GROUP_CODE_DESC | Detailed Description of Code Size: 30 |
01=Def Code | DEFINED_SENIORITY | SEN_DEF_GROUP_CODE | Size: 10 |
02=Type | DEFINED_SENIORITY | SEN_DEF_GROUP_TYPE | Size: 10 |
08=Field Type | DEFINED_SENIORITY | SENIORITY_TYPE_1 | Seniority Field 01 Size: 10 |
13=Field Type | DEFINED_SENIORITY | SENIORITY_TYPE_2 | Seniority Field 02 Size: 10 |
18=Field Type | DEFINED_SENIORITY | SENIORITY_TYPE_3 | Seniority Field 03 Size: 10 |
23=Field Type | DEFINED_SENIORITY | SENIORITY_4_TYPE | Seniority Field 04 Size: 10 |
28=Field Type | DEFINED_SENIORITY | SENIORITY_TYPE_5 | Seniority Field 05 Size: 10 |
Seniority Field 01 | DEFINED_SENIORITY | SENIORITY_1 | Size: 10 |
Seniority Field 02 | DEFINED_SENIORITY | SENIORITY_2 | Size: 10 |
Seniority Field 03 | DEFINED_SENIORITY | SENIORITY_3 | Size: 10 |
Seniority Field 04 | DEFINED_SENIORITY | SENIORITY_4 | Size: 10 |
Seniority Field 05 | DEFINED_SENIORITY | SENIORITY_5 | Size: 10 |
Seniority Map | DEFINED_SENIORITY | SENIORITY_MAP | Size: 100 |
Seniority Query | DEFINED_SENIORITY | SENIORITY_QUERY | Size: 100 |
Seniority Sorted | DEFINED_SENIORITY | SORTED_SENIORITY_1 | Size: 10 |
Seniority Sorted | DEFINED_SENIORITY | SORTED_SENIORITY_2 | Size: 10 |
Seniority Sorted | DEFINED_SENIORITY | SORTED_SENIORITY_3 | Size: 10 |
Seniority Sorted | DEFINED_SENIORITY | SORTED_SENIORITY_4 | Size: 10 |
Seniority Sorted | DEFINED_SENIORITY | SORTED_SENIORITY_5 | Size: 10 |