CAVACMSTR FILE
REFERENCED BY
TA146 TA148
UPDATED BY
TA40.2 TA40.3 TA40.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAV-COMPANY Numeric 4 TA40.2 TA40.3
Element: Company Hr
CAV-PLAN-NAME Alpha 10 TA40.2 TA40.3
Element: Plan Name This field contains the plan name.
CAV-TAX-ID-CODE Alpha 10 TA40.2 TA40.3
Element: Tax Id Code
CAV-BEG-EFF-DATE Numeric 8 (yyyymmdd) TA40.2 TA40.3
Element: Beg Eff Date
CAV-END-EFF-DATE Numeric 8 (yyyymmdd) TA40.2 TA40.3
Element: End Eff Date
CAV-VAC-PERCENT Signed 5.2 Occurs 24 Times TA40.2 TA40.3
Element: Vac Percent
CAV-PAY-CLASS Alpha 3 Occurs 24 Times TA40.2 TA40.3
Element: Pay Class
CAV-PAY-CODE Alpha 4 Occurs 24 Times TA40.2 TA40.3
Element: Pay 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
Element: Vac Entitle Hr
CAV-BEG-HRS-YRS Numeric 7 Occurs 24 Times TA40.2 TA40.3
Element: Beg Hrs Yrs
CAV-END-HRS-YRS Numeric 7 Occurs 24 Times TA40.2
Element: End Hrs Yrs
CAV-SERV-DT-USED Numeric 2 TA40.3
Element: Serv Dt Used 00 = n/a
01 = Hire Date
02 = Adj Hire Date
CAV-BEG-HRS-TYPE Numeric 2 Occurs 24 Times TA40.2
Element: 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
Element: 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 TA40.1 TA40.2
TAX-ID-CODE TA40.3
BEG-EFF-DATE
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
Taeemaster TAEEMASTER
CAV-COMPANY -> TEM-COMPANY
TEM-EMPLOYEE
TEM-PLAN
TEM-EMPLOYEE-GROUP
TEM-POSITION
|
