CAVACMSTR

REFERENCED BY
TA148


UPDATED BY
TA40.2 TA40.3 TA40.1 HR00.1 HR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAV-COMPANY
Element: Company Hr
Numeric 4
TA40.2 TA40.3
CAV-PLAN-NAME
Element: Plan Name
Alpha 10
This field contains the plan name.
TA40.2 TA40.3
CAV-TAX-ID-CODE
Element: Tax Id Code
Alpha 10
TA40.2 TA40.3
CAV-BEG-EFF-DATE
Element: Beg Eff Date
Numeric 8 (yyyymmdd)
TA40.2 TA40.3
CAV-END-EFF-DATE
Element: End Eff Date
Numeric 8 (yyyymmdd)
TA40.2 TA40.3
CAV-VAC-PERCENT
Element: Vac Percent
Signed 5.2 Occurs 24 Times
TA40.2 TA40.3
CAV-PAY-CLASS
Element: Pay Class
Alpha 3 Occurs 24 Times
TA40.2 TA40.3
CAV-PAY-CODE
Element: Pay Code
Alpha 4 Occurs 24 Times
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
TA40.2 TA40.3
CAV-VAC-ENTITLE-HR
Element: Vac Entitle Hr
Numeric 4 Occurs 24 Times
TA40.2 TA40.3
CAV-BEG-HRS-YRS
Element: Beg Hrs Yrs
Numeric 7 Occurs 24 Times
TA40.2 TA40.3
CAV-END-HRS-YRS
Element: End Hrs Yrs
Numeric 7 Occurs 24 Times
TA40.2
CAV-SERV-DT-USED
Element: Serv Dt Used
Numeric 2

00 = n/a
01 = Hire Date
02 = Adj Hire Date
TA40.3
CAV-BEG-HRS-TYPE
Element: Beg Hrs Type
Numeric 2 Occurs 24 Times

00 = n/a
01 = Year To Date <
02 = Year To Date >=
03 = Life To Date <
04 = Life To Date >=
TA40.2
CAV-END-HRS-TYPE
Element: End Hrs Type
Numeric 2 Occurs 24 Times

00 = n/a
01 = Year To Date <
02 = Year To Date >=
03 = Life To Date <
04 = Life To Date >=
TA40.2


CAVACMSTR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAVSET1 COMPANY
PLAN-NAME
TAX-ID-CODE
BEG-EFF-DATE
HR00.1 HR01.1
TA40.1 TA40.2
TA40.3
CAVSET2 COMPANY
PLAN-NAME
TAX-ID-CODE
BEG-EFF-DATE*
TA148 TA40.2
TA40.3


CAVACMSTR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:30:18 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.