HATPLAN - Attendance Benefit Plan Definition (PL) Database
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 |