Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAEEMASTER


                            TAEEMASTER FILE

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN245
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN531
BN65.1    BN71.1    BN72.1    BS13.1    BS14.1    BS15.1
BS32.1

UPDATED BY

HR11.1    HR11.2    HR511     PA02.1    PA100     PA102
PA13.1    PA13.2    PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PR110     PR113     PR120     PR13.1
PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TEM-COMPANY            Numeric 4                                 HR11.1  HR511
Element: Company Hr    Identifies the AP company if the          PA100   PA52.4
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

TEM-EMPLOYEE           Numeric 9                                 HR11.1  HR511
Element: Employee      Contains the employee number. Each        PA100   PA52.4
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

TEM-PLAN               Alpha 10                                  HR11.1  HR511
Element: Ta Plan                                                 PA100   PA52.4

TEM-EMPLOYEE-GROUP     Alpha 10                                  HR11.1  HR511
Element: Group Name                                              PA100   PA52.4

TEM-HM-PROC-LEVEL      Alpha 5                                   HR11.1  HR511
Element: Process Lev HrContains the employee's home process      PA100   PA52.4
                       level.

TEM-POSITION           Alpha 12                                  HR11.1  HR511
Element: Position      Contains the user-defined code that       PA100   PA52.4
                       represents a position in the company.

TEM-MASTR-ENTRY        Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Begin Date                                           PA100   PA52.4

TEM-MSTR-ELIG-END      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta End Date                                             PA100   PA52.4

TEM-MSTR-END           Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta End Date                                             PA100   PA52.4

TEM-STRUCTURE-END      Numeric 8  (yyyymmdd)
Element: Ta End Date

TEM-MSTR-OVERRIDE      Numeric 1                                 HR11.1  HR511
Element: Ta Override   0 = No                                    PA100   PA52.4
                       1 = Yes

TEM-SRV-BEGIN-DT       Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Begin Date                                           PA100   PA52.4

TEM-ACCR-BEGIN-DT      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Begin Date                                           PA100   PA52.4

TEM-ACCR-START-DT      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Start Date                                           PA100   PA52.4

TEM-ACCR-LAST-DT       Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Last Date                                            PA100   PA52.4

TEM-ALLOT-POINT        Numeric 4  (mmdd)                         HR11.1  HR511
Element: Ta Point                                                PA100   PA52.4

TEM-ALLOT-BEGIN-DT     Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Begin Date                                           PA100   PA52.4

TEM-ALLOT-LAST-DT      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Last Date                                            PA100   PA52.4

TEM-ELIG-BEGIN-DT      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Begin Date                                           PA100   PA52.4

TEM-ELIG-LAST-DT       Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Last Date                                            PA100   PA52.4

TEM-RESET-POINT        Numeric 4  (mmdd)                         HR11.1  HR511
Element: Ta Point                                                PA100   PA52.4

TEM-RESET-LAST-DT      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta Last Date                                            PA100   PA52.4

TEM-CARRYOVER-END      Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Ta End Date                                             PA100   PA52.4

TEM-AVAIL-HRS-BAL      Signed 18.6
Element: Ta Amount

TEM-ACCR-HRS-BAL       Signed 18.6
Element: Ta Amount

TEM-ALLOT-HRS-BAL      Signed 18.6
Element: Ta Amount

TEM-RESRV-HRS-BAL      Signed 18.6
Element: Ta Amount

TEM-CARRY-HRS-BAL      Signed 18.6
Element: Ta Amount

TEM-AVAIL-ERN-BAL      Signed 18.6
Element: Ta Amount

TEM-ACCR-ERN-BAL       Signed 18.6
Element: Ta Amount

TEM-ALLOT-ERN-BAL      Signed 18.6
Element: Ta Amount

TEM-RESRV-ERN-BAL      Signed 18.6
Element: Ta Amount

TEM-CARRY-ERN-BAL      Signed 18.6
Element: Ta Amount

TEM-CURRENCY-CODE      Alpha 5                                   HR11.1  HR511
Element: Currency Code This field contains the company base      PA100   PA52.4
                       currency code established in Company
                       (GL10.1 ).

TEM-OV-CARRY-HRS-A     Signed 18.6                               HR11.1  HR511
Element: Ta Carry Amt                                            PA100   PA52.4

TEM-OV-CARRY-ERN-A     Signed 18.6                               HR11.1  HR511
Element: Ta Carry Amt                                            PA100   PA52.4

TEM-HRS-ACCR-CO        Numeric 4                                 HR11.1  HR511
Element: Company                                                 PA100   PA52.4

TEM-HRS-ACCR-UNIT      Alpha 15                                  HR11.1  HR511
Element: Accounting Unit                                         PA100   PA52.4

TEM-HRS-ACCR-ACCT      Numeric 6                                 HR11.1  HR511
Element: Account                                                 PA100   PA52.4

TEM-HRS-ACCR-SUB       Numeric 4                                 HR11.1  HR511
Element: Subaccount                                              PA100   PA52.4

TEM-HRS-EXP-CO         Numeric 4                                 HR11.1  HR511
Element: Company                                                 PA100   PA52.4

TEM-HRS-EXP-UNIT       Alpha 15                                  HR11.1  HR511
Element: Accounting Unit                                         PA100   PA52.4

TEM-HRS-EXP-ACCT       Numeric 6                                 HR11.1  HR511
Element: Account                                                 PA100   PA52.4

TEM-HRS-EXP-SUB        Numeric 4                                 HR11.1  HR511
Element: Subaccount                                              PA100   PA52.4

TEM-HRS-ACTIVITY       Alpha 15                                  HR11.1  HR511
Element: Activity                                                PA100   PA52.4

TEM-HRS-ACCT-CAT       Alpha 5                                   HR11.1  HR511
Element: Account Category                                        PA100   PA52.4

TEM-ERN-ACCR-CO        Numeric 4                                 HR11.1  HR511
Element: Company                                                 PA100   PA52.4

TEM-ERN-ACCR-UNIT      Alpha 15                                  HR11.1  HR511
Element: Accounting Unit                                         PA100   PA52.4

TEM-ERN-ACCR-ACCT      Numeric 6                                 HR11.1  HR511
Element: Account                                                 PA100   PA52.4

TEM-ERN-ACCR-SUB       Numeric 4                                 HR11.1  HR511
Element: Subaccount                                              PA100   PA52.4

TEM-ERN-EXP-CO         Numeric 4                                 HR11.1  HR511
Element: Company                                                 PA100   PA52.4

TEM-ERN-EXP-UNIT       Alpha 15                                  HR11.1  HR511
Element: Accounting Unit                                         PA100   PA52.4

TEM-ERN-EXP-ACCT       Numeric 6                                 HR11.1  HR511
Element: Account                                                 PA100   PA52.4

TEM-ERN-EXP-SUB        Numeric 4                                 HR11.1  HR511
Element: Subaccount                                              PA100   PA52.4

TEM-ERN-ACTIVITY       Alpha 15                                  HR11.1  HR511
Element: Activity                                                PA100   PA52.4

TEM-ERN-ACCT-CAT       Alpha 5                                   HR11.1  HR511
Element: Account Category                                        PA100   PA52.4

TEM-LAST-OBJ-ID        Numeric 12
Object
Identification

TEM-LST-SEQ-NBR        Numeric 5
Element: Ta Seq Nbr

TEM-LST-OBJ-ID-HRS     Numeric 12
Object
Identification

TEM-LST-OBJ-ID-ERN     Numeric 12
Object
Identification

TEM-LST-PER-DT-HRS     Numeric 8  (yyyymmdd)
Element: Ta Last Date

TEM-LST-PER-DT-ERN     Numeric 8  (yyyymmdd)
Element: Ta Last Date

TEM-HRH-OBJ-ID         Numeric 12
Object
Identification

TEM-OV-ACCR-HRS        Alpha 10
Element: Ta Table

TEM-OV-ACCR-ERN        Alpha 10
Element: Ta Table

TEM-OV-ALLOT-HRS       Alpha 10
Element: Ta Table

TEM-OV-ALLOT-ERN       Alpha 10
Element: Ta Table

TEM-OV-BAL-HRS         Alpha 10
Element: Ta Table

TEM-OV-BAL-ERN         Alpha 10
Element: Ta Table

TEM-OV-ACRLIM-HRS      Alpha 10
Element: Ta Table

TEM-OV-ACRLIM-ERN      Alpha 10
Element: Ta Table

TEM-OV-CARRY-HRS-T     Alpha 10
Element: Ta Table

TEM-OV-CARRY-ERN-T     Alpha 10
Element: Ta Table

TEM-OV-HRS-LIA         Alpha 10
Element: Ta Table

TEM-OV-ERN-LIA         Alpha 10
Element: Ta Table

TEM-T-SRV-BEGIN-D      Numeric 8  (yyyymmdd)
Element: Ta Begin Date

TEM-T-ACCR-BEGIN-D     Numeric 8  (yyyymmdd)
Element: Ta Begin Date

TEM-T-ACCR-START-D     Numeric 8  (yyyymmdd)
Element: Ta Begin Date

TEM-T-ACCR-LAST-D      Numeric 8  (yyyymmdd)
Element: Ta Last Date

TEM-T-ALLOT-POINT      Numeric 4  (mmdd)
Element: Ta Point

TEM-T-ALLOT-BEGIND     Numeric 8  (yyyymmdd)
Element: Ta Begin Date

TEM-T-ALLOT-LAST-D     Numeric 8  (yyyymmdd)
Element: Ta Last Date

TEM-T-ELIG-BEGIN-D     Numeric 8  (yyyymmdd)
Element: Ta Begin Date

TEM-T-ELIG-LAST-D      Numeric 8  (yyyymmdd)
Element: Ta Last Date

TEM-T-RESET-POINT      Numeric 4  (mmdd)
Element: Ta Point

TEM-T-RESET-LAST-D     Numeric 8  (yyyymmdd)
Element: Ta Last Date

TEM-T-CARRY-END-D      Numeric 8  (yyyymmdd)
Element: Ta End Date

TEM-T-LST-PER-DT-E     Numeric 8  (yyyymmdd)
Element: Ta End Date

TEM-T-LST-PER-DT-H     Numeric 8  (yyyymmdd)
Element: Ta End Date

TEM-T-LST-OBJ-ID-E     Numeric 12
Object
Identification

TEM-T-LST-OBJ-ID-H     Numeric 12
Object
Identification

TEM-T-AVAIL-HRS-B      Signed 18.6
Element: Ta Amount

TEM-T-ACCR-HRS-B       Signed 18.6
Element: Ta Amount

TEM-T-ALLOT-HRS-B      Signed 18.6
Element: Ta Amount

TEM-T-RESRV-HRS-B      Signed 18.6
Element: Ta Amount

TEM-T-CARRY-HRS-B      Signed 18.6
Element: Ta Amount

TEM-T-AVAIL-ERN-B      Signed 18.6
Element: Ta Amount

TEM-T-ACCR-ERN-B       Signed 18.6
Element: Ta Amount

TEM-T-ALLOT-ERN-B      Signed 18.6
Element: Ta Amount

TEM-T-RESRV-ERN-B      Signed 18.6
Element: Ta Amount

TEM-T-CARRY-ERN-B      Signed 18.6
Element: Ta Amount

TEM-T-RUN-FLAG         Numeric 1
Element: Ta Run Flag   0 = No Transactions Processed
                       1 = Transactions Processed

TEM-CREATE-DATE        Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Date Stamp    The creation date.                        PA100   PA52.4

TEM-CREATE-TIME        Numeric 6  (hhmmss)                       HR11.1  HR511
Element: Time Stamp                                              PA100   PA52.4

TEM-CREATE-USER-ID     Alpha 10  (Lower Case)                    HR11.1  HR511
Element: User                                                    PA100   PA52.4

TEM-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR11.1  HR511
Element: Date Stamp    This field contains the server date       PA100   PA52.4
                       (month, date, and year) of the last
                       change to this record.

TEM-TIME-STAMP         Numeric 6  (hhmmss)                       HR11.1  HR511
Element: Time Stamp    Contains the server time (hour, minute,   PA100   PA52.4
                       and second) when the record was last
                       changed.

TEM-USER-ID            Alpha 10  (Lower Case)                    HR11.1  HR511
Element: User          Contains the user ID of the person who    PA100   PA52.4
                       last changed this record.

                         TAEEMASTER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TEMSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN                                                   BN105   BN245
          EMPLOYEE-GROUP                                         BN31.1  BN31.2
          POSITION                                               BN32.1  BN32.2
                                                                 BN32.3  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR11.1
                                                                 HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 ...

TEMSET2   COMPANY
          PLAN
          EMPLOYEE-GROUP
          EMPLOYEE
          POSITION

TEMSET3   COMPANY
          EMPLOYEE
          EMPLOYEE-GROUP
          PLAN
          POSITION

TEMSET4   COMPANY
          EMPLOYEE
          POSITION
          PLAN
          EMPLOYEE-GROUP

TEMSET5   COMPANY       KeyChange
          HM-PROC-LEVEL
          EMPLOYEE
          PLAN
          EMPLOYEE-GROUP
          POSITION

TEMSET6   COMPANY       KeyChange
          HM-PROC-LEVEL
          PLAN
          EMPLOYEE-GROUP
          EMPLOYEE
          POSITION

                         TAEEMASTER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TEM-COMPANY           -> PRS-COMPANY  (PRSSET1)
                            Spaces                -> PRS-PROCESS-LEVEL

Currency       CUCODES      Not Required

                            TEM-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required

                            TEM-COMPANY           -> EMP-COMPANY
                            TEM-EMPLOYEE          -> EMP-EMPLOYEE

Employee Group PERSGROUP    Required

                            TEM-COMPANY           -> PRG-COMPANY
                            TEM-EMPLOYEE-GROUP    -> PRG-GROUP-NAME

Ern Accr Dist  GLMASTER     Not Required

                            TEM-ERN-ACCR-CO       -> GLM-COMPANY
                            TEM-ERN-ACCR-UNIT     -> GLM-ACCT-UNIT
                            TEM-ERN-ACCR-ACCT     -> GLM-ACCOUNT
                            TEM-ERN-ACCR-SUB      -> GLM-SUB-ACCOUNT

Ern Acct Cat   ACACCTCAT    Required
                            When (TEM-ERN-ACCT-CAT != Spaces )

                            TEM-ERN-ACCT-CAT      -> AAX-ACCT-CATEGORY

Ern Activity   ACACTIVITY   Required
                            When (TEM-ERN-ACTIVITY != Spaces )

                            TEM-ERN-ACTIVITY      -> ACV-ACTIVITY

Ern Exp Dist   GLMASTER     Not Required

                            TEM-ERN-EXP-CO        -> GLM-COMPANY
                            TEM-ERN-EXP-UNIT      -> GLM-ACCT-UNIT
                            TEM-ERN-EXP-ACCT      -> GLM-ACCOUNT
                            TEM-ERN-EXP-SUB       -> GLM-SUB-ACCOUNT

Hm Proc Level  PRSYSTEM     Required

                            TEM-COMPANY           -> PRS-COMPANY
                            TEM-HM-PROC-LEVEL     -> PRS-PROCESS-LEVEL

Hrs Accr Dist  GLMASTER     Not Required

                            TEM-HRS-ACCR-CO       -> GLM-COMPANY
                            TEM-HRS-ACCR-UNIT     -> GLM-ACCT-UNIT
                            TEM-HRS-ACCR-ACCT     -> GLM-ACCOUNT
                            TEM-HRS-ACCR-SUB      -> GLM-SUB-ACCOUNT

Hrs Acct Cat   ACACCTCAT    Required
                            When (TEM-HRS-ACCT-CAT != Spaces )

                            TEM-HRS-ACCT-CAT      -> AAX-ACCT-CATEGORY

Hrs Activity   ACACTIVITY   Required
                            When (TEM-HRS-ACTIVITY != Spaces )

                            TEM-HRS-ACTIVITY      -> ACV-ACTIVITY

Hrs Exp Dist   GLMASTER     Not Required

                            TEM-HRS-EXP-CO        -> GLM-COMPANY
                            TEM-HRS-EXP-UNIT      -> GLM-ACCT-UNIT
                            TEM-HRS-EXP-ACCT      -> GLM-ACCOUNT
                            TEM-HRS-EXP-SUB       -> GLM-SUB-ACCOUNT

Plan           TAPLAN       Required

                            TEM-COMPANY           -> TAP-COMPANY
                            TEM-PLAN              -> TAP-PLAN

                         TAEEMASTER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Position       PAPOSITION
                            Valid When (TEM-POSITION != Spaces )

                            TEM-COMPANY           -> POS-COMPANY
                            TEM-POSITION          -> POS-POSITION
                                                     POS-EFFECT-DATE

Ta Enroll      TAENROLL     Delete Cascades

                            TEM-COMPANY           -> TEN-COMPANY
                            TEM-EMPLOYEE          -> TEN-EMPLOYEE
                            TEM-PLAN              -> TEN-PLAN
                            TEM-EMPLOYEE-GROUP    -> TEN-EMPLOYEE-GROUP
                            TEM-POSITION          -> TEN-POSITION
                                                     TEN-JOB-CODE
                                                     TEN-PROCESS-LEVEL
                                                     TEN-DEPARTMENT