Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CAVACMSTR


                             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
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CAV-PLAN-NAME          Alpha 10                                  TA40.2  TA40.3
Element: From Plan NameThis 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
Beginning Effective
Date

CAV-END-EFF-DATE       Numeric 8  (yyyymmdd)                     TA40.2  TA40.3
Element: Z

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: Payment Class

CAV-PAY-CODE           Alpha 4 Occurs 24 Times                   TA40.2  TA40.3
Element: 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
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                                              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