HATSUM - Employee Attendance Summary (TO) Database

HATSUM field information

 

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