HATPLAN - Attendance Benefit Plan Definition (PL) Database

HATPLAN field information

 

Order Field Name Type Length Dec Description

1

P_ABTYPE

C

254

0

Associated Absence Types

2

P_ACTHOURS

L

1

0

Accrue time based on actual hours

3

P_CALCSRV

N

5

0

 Index for Seniority Calculated Serv

4

P_CHADATE

T

8

0

Last Change Date

5

P_COMPANY

C

3

0

Company Code

6

P_DESC

C

25

0

Plan Description

7

P_HOURS1

N

11

5

Hours for Level 1

8

P_HOURS10

N

11

5

Hours for Level 10

9

P_HOURS2

N

11

5

Hours for Level 2

10

P_HOURS3

N

11

5

Hours for Level 3

11

P_HOURS4

N

11

5

Hours for Level 4

12

P_HOURS5

N

11

5

Hours for Level 5

13

P_HOURS6

N

11

5

Hours for Level 6

14

P_HOURS7

N

11

5

Hours for Level 7

15

P_HOURS8

N

11

5

Hours for Level 8

16

P_HOURS9

N

11

5

Hours for Level 9

17

P_ID

C

7

0

Plan ID

18

P_LUMP

L

1

0

Lump Sum Code (Y/N)

19

P_MAXACCR

N

11

5

Maximum Accrual Amount

20

P_METHOD

C

12

0

Accrual Method

21

P_MINACCR

N

11

5

Restart Accruals when Below this Amount

22

P_NOACCRUE

L

1

0

Suspend Accrual Indicator

23

P_PERFECT

L

1

0

Perfect Attendance Report Indicator

24

P_PERIOD

C

10

0

Calculation Period

25

P_PTHOURS

N

11

5

Points per Hour

26

P_PTOCCUR

N

11

5

Points per Occurrence

27

P_PTPER

C

6

0

Units per Threshold

28

P_PTTHRE

N

11

5

Threshold Points

29

P_RULE

C

1

0

Rule Record

30

P_SENIOR1

N

3

0

Hours for Seniority Level 1

31

P_SENIOR10

N

3

0

Hours for Seniority Level 10

32

P_SENIOR2

N

3

0

Hours for Seniority Level 2

33

P_SENIOR3

N

3

0

Hours for Seniority Level 3

34

P_SENIOR4

N

3

0

Hours for Seniority Level 4

35

P_SENIOR5

N

3

0

Hours for Seniority Level 5

36

P_SENIOR6

N

3

0

Hours for Seniority Level 6

37

P_SENIOR7

N

3

0

Hours for Seniority Level 7

38

P_SENIOR8

N

3

0

Hours for Seniority Level 8

39

P_SENIOR9

N

3

0

Hours for Seniority Level 9

40

P_SPECDATE

T

8

0

Seniority Specified Date

41

P_TOTCAR1

N

12

5

Maximum Total Carryover

42

P_TYPE

C

12

0

Plan Type

43

P_USELIST

N

5

0

Index for List of Seniority Use Dat

44

P_YRCARRY1

N

11

5

Maximum Carryover Per Year

45

_LUMP

C

3

0

Lump Sum (Yes/No)

46

_ZFILTER

C

25

0

Filter Function