HATSUM - Employee Attendance Summary (TO) 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_DPRATE |
T |
8 |
0 |
Last Close Accrue Date |
11 |
T_DSNSTART |
T |
8 |
0 |
Seniority Start Date |
12 |
T_DYREND |
T |
8 |
0 |
Year End Date |
13 |
T_EMPNO |
C |
9 |
0 |
Employee ID |
14 |
T_ID |
C |
7 |
0 |
Plan ID Code |
15 |
T_MAXFREEZ |
L |
1 |
0 |
Maximum Time Available Exceeded |
16 |
T_MSENIOR |
N |
11 |
5 |
Months of Seniority |
17 |
T_NOACCRUE |
L |
1 |
0 |
Suppress Accrual Code (Y/N) |
18 |
T_PRATE |
N |
11 |
5 |
Last Close Period Hours |
19 |
T_TAKEN |
N |
11 |
5 |
Hours Taken |
20 |
T_THRESH |
N |
11 |
5 |
Plan Threshold |
21 |
T_YREND |
N |
11 |
5 |
Year End Eligibility |
22 |
_ID |
C |
25 |
0 |
Plan ID Description |
23 |
_NOACCRUE |
C |
3 |
0 |
Suppress Accrual (Yes/No) |
24 |
_ZFILTER |
C |
25 |
0 |
Filter Function |