HATCO - Previous Year Employee Attendance Summary (CO)
Database
Order | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
T_ACCRUED |
N |
11 |
5 |
Hours Accrued Since Last Close |
2 |
T_CARRY |
N |
11 |
5 |
Carryover Hours |
3 |
T_CHADATE |
T |
8 |
0 |
Last Change Date |
4 |
T_CLOSE |
N |
11 |
5 |
Hours Accrued Through Last Close |
5 |
T_COMPANY |
C |
3 |
0 |
Company Code |
6 |
T_DACCRUE |
T |
8 |
0 |
Last Accrual Date |
7 |
T_DCARRY |
T |
8 |
0 |
Carryover Date |
8 |
T_DCLOSE |
T |
8 |
0 |
Last Close Date |
9 |
T_DPLAN |
T |
8 |
0 |
Plan Start Date |
10 |
T_DSNSTART |
T |
8 |
0 |
Seniority Start Date |
11 |
T_DYREND |
T |
8 |
0 |
Year End Date |
12 |
T_EMPNO |
C |
9 |
0 |
Employee ID |
13 |
T_ID |
C |
7 |
0 |
Plan ID Code |
14 |
T_MSENIOR |
N |
11 |
5 |
Months of Seniority |
15 |
T_NOACCRUE |
L |
1 |
0 |
Suppress Accrual Code (Y/N) |
16 |
T_TAKEN |
N |
11 |
5 |
Hours Taken |
17 |
T_THRESH |
N |
11 |
5 |
Plan Threshold |
18 |
T_YREND |
N |
11 |
5 |
Year End Eligibility |
19 |
_ID |
C |
25 |
0 |
Plan ID |
20 |
_NOACCRUE |
C |
3 |
0 |
Suppress Accrual (Yes/No) |
21 |
_ZFILTER |
C |
25 |
0 |
Filter Function |