CAVACMSTR FILE
REFERENCED BY
TA146 TA148
UPDATED BY
TA40.2 TA40.3 TA40.1 HR00.1 HR01.1 PBIP.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAV-COMPANY Numeric 4 TA40.2 TA40.3
Company The company number represents an
established company and is entered on
all function codes.
CAV-PLAN-NAME Alpha 10 TA40.2 TA40.3
From Plan Name This field contains the plan name.
CAV-TAX-ID-CODE Alpha 10 TA40.2 TA40.3
Tax Id Code
CAV-BEG-EFF-DATE Numeric 8 (yyyymmdd) TA40.2 TA40.3
Beginning Effective
Date
CAV-END-EFF-DATE Numeric 8 (yyyymmdd) TA40.2 TA40.3
Z
CAV-VAC-PERCENT Signed 5.2 Occurs 24 Times TA40.2 TA40.3
Vac Percent
CAV-PAY-CLASS Alpha 3 Occurs 24 Times TA40.2 TA40.3
Payment Class
CAV-PAY-CODE Alpha 4 Occurs 24 Times TA40.2 TA40.3
Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
CAV-VAC-ENTITLE-HR Numeric 4 Occurs 24 Times TA40.2 TA40.3
Vac Entitle Hr
CAV-BEG-HRS-YRS Numeric 7 Occurs 24 Times TA40.2 TA40.3
Beg Hrs Yrs
CAV-END-HRS-YRS Numeric 7 Occurs 24 Times TA40.2
End Hrs Yrs
CAV-SERV-DT-USED Numeric 2 TA40.3
Serv Dt Used 00 = n/a
01 = Hire Date
02 = Adj Hire Date
CAV-BEG-HRS-TYPE Numeric 2 Occurs 24 Times TA40.2
Beg Hrs Type 00 = n/a
01 = Year To Date <
02 = Year To Date >=
03 = Life To Date <
04 = Life To Date >=
CAV-END-HRS-TYPE Numeric 2 Occurs 24 Times TA40.2
End Hrs Type 00 = n/a
01 = Year To Date <
02 = Year To Date >=
03 = Life To Date <
04 = Life To Date >=
CAVACMSTR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAVSET1 COMPANY HR00.1 HR01.1
PLAN-NAME PBIP.1 PR197
TAX-ID-CODE TA40.1 TA40.2
BEG-EFF-DATE TA40.3
CAVSET2 COMPANY TA146 TA148
PLAN-NAME TA40.2 TA40.3
TAX-ID-CODE
BEG-EFF-DATE*
CAVACMSTR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CAV-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Plan PLANMASTER Required
CAV-COMPANY -> PLM-COMPANY
CAV-PLAN-NAME -> PLM-PLAN-NAME
Tax Authority PRTAXAUTH Required
CAV-TAX-ID-CODE -> PRX-TAX-ID-CODE
CAVACMSTR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Eeplan EMTAMASTR
CAV-COMPANY -> ETM-COMPANY
CAV-PLAN-NAME -> ETM-PLAN-NAME
ETM-EMPLOYEE
|
