TAEEMASTER – Employee Absence Plan

System
Absence Management (LP)
Prefix
TEM
Primary key
COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION
Fields
121
Updated by
125 programs
Referenced by
27 programs

TAEEMASTER is the Employee Absence Plan table in Lawson Absence Management (prefix TEM). It is indexed by COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION (TEMSET1); alternate indexes: TEMSET2, TEMSET3, TEMSET4, TEMSET5 and TEMSET6. It is related 1:1 to PRSYSTEM, CUCODES, EMPLOYEE, PERSGROUP, GLMASTER, ACACCTCAT, ACACTIVITY, LPLINK and 3 more and 1:M to TATABLE, BNTAEMPBAL, HRHISTORY, LPPENDREQ, PAPOSITION, TAENROLL, TAEMPTRANS, TALOSHRS and 2 more. It is updated by BN100, BN101, BN102, BN103, BN105, BN150, BN245, BN305 and 117 more and referenced by HR170, HR70.1, HS17.1, HS19.1, HS19.2, HS706, LP01.1, LP04.2 and 19 more. The table has 121 fields, 6 indexes and 40 documented relations.

About TAEEMASTER

No description in the Lawson data dictionary.

Fields (121)

Column = COBOL field name without the TEM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TEM-COMPANY PK
COMPANY
Numeric 4HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-EMPLOYEE PK
EMPLOYEE
Numeric 9Contains the employee number. Each 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.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-PLAN PK
PLAN
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-EMPLOYEE-GROUP PK
EMPLOYEE_GROUP
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HM-PROC-LEVEL
HM_PROC_LEVEL
Alpha 5BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LP100, LP101 +34 more
TEM-POSITION PK
POSITION
Alpha 12Contains the user-defined code that represents a position in the company.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-MASTR-ENTRY
MASTR_ENTRY
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-MSTR-ELIG-END
MSTR_ELIG_END
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-MSTR-END
MSTR_END
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-STRUCTURE-END
STRUCTURE_END
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-MSTR-OVERRIDE
MSTR_OVERRIDE
Numeric 1
  • 0 No
  • 1 Yes
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-SRV-BEGIN-DT
SRV_BEGIN_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ACCR-BEGIN-DT
ACCR_BEGIN_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ACCR-START-DT
ACCR_START_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ACCR-LAST-DT
ACCR_LAST_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ALLOT-POINT
ALLOT_POINT
Numeric 4 (mmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ALLOT-BEGIN-DT
ALLOT_BEGIN_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ALLOT-LAST-DT
ALLOT_LAST_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ELIG-BEGIN-DT
ELIG_BEGIN_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ELIG-LAST-DT
ELIG_LAST_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-RESET-POINT
RESET_POINT
Numeric 4 (mmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-RESET-LAST-DT
RESET_LAST_DT
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-CARRYOVER-END
CARRYOVER_END
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-AVAIL-HRS-BAL
AVAIL_HRS_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +9 more
TEM-ACCR-HRS-BAL
ACCR_HRS_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ALLOT-HRS-BAL
ALLOT_HRS_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-RESRV-HRS-BAL
RESRV_HRS_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-CARRY-HRS-BAL
CARRY_HRS_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-AVAIL-ERN-BAL
AVAIL_ERN_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +9 more
TEM-ACCR-ERN-BAL
ACCR_ERN_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ALLOT-ERN-BAL
ALLOT_ERN_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-RESRV-ERN-BAL
RESRV_ERN_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-CARRY-ERN-BAL
CARRY_ERN_BAL
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-CARRY-HRS-A
OV_CARRY_HRS_A
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-CARRY-ERN-A
OV_CARRY_ERN_A
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-ACCR-CO
HRS_ACCR_CO
Numeric 4Identifies 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.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-ACCR-UNIT
HRS_ACCR_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-ACCR-ACCT
HRS_ACCR_ACCT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-ACCR-SUB
HRS_ACCR_SUB
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-EXP-CO
HRS_EXP_CO
Numeric 4Identifies 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.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-EXP-UNIT
HRS_EXP_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-EXP-ACCT
HRS_EXP_ACCT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-EXP-SUB
HRS_EXP_SUB
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-ACTIVITY
HRS_ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-HRS-ACCT-CAT
HRS_ACCT_CAT
Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruHR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-ACCR-CO
ERN_ACCR_CO
Numeric 4Identifies 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.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-ACCR-UNIT
ERN_ACCR_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-ACCR-ACCT
ERN_ACCR_ACCT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-ACCR-SUB
ERN_ACCR_SUB
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-EXP-CO
ERN_EXP_CO
Numeric 4Identifies 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.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-EXP-UNIT
ERN_EXP_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-EXP-ACCT
ERN_EXP_ACCT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-EXP-SUB
ERN_EXP_SUB
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-ACTIVITY
ERN_ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ERN-ACCT-CAT
ERN_ACCT_CAT
Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruHR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-LAST-OBJ-ID
LAST_OBJ_ID
Numeric 12This field is not currently being used by Absence Management. Reserve for future use.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-LST-SEQ-NBR
LST_SEQ_NBR
Numeric 4An automatically assigned sequence number.HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +16 more
TEM-LST-OBJ-ID-HRS
LST_OBJ_ID_HRS
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-LST-OBJ-ID-ERN
LST_OBJ_ID_ERN
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-LST-PER-DT-HRS
LST_PER_DT_HRS
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +9 more
TEM-LST-PER-DT-ERN
LST_PER_DT_ERN
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +9 more
TEM-HRH-OBJ-ID
HRH_OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ACCR-HRS
OV_ACCR_HRS
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ACCR-ERN
OV_ACCR_ERN
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ALLOT-HRS
OV_ALLOT_HRS
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ALLOT-ERN
OV_ALLOT_ERN
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-BAL-HRS
OV_BAL_HRS
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-BAL-ERN
OV_BAL_ERN
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ACRLIM-HRS
OV_ACRLIM_HRS
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ACRLIM-ERN
OV_ACRLIM_ERN
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-CARRY-HRS-T
OV_CARRY_HRS_T
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-CARRY-ERN-T
OV_CARRY_ERN_T
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-HRS-LIA
OV_HRS_LIA
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ERN-LIA
OV_ERN_LIA
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-T-SRV-BEGIN-D
T_SRV_BEGIN_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ACCR-BEGIN-D
T_ACCR_BEGIN_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ACCR-START-D
T_ACCR_START_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ACCR-LAST-D
T_ACCR_LAST_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ALLOT-POINT
T_ALLOT_POINT
Numeric 4 (mmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ALLOT-BEGIND
T_ALLOT_BEGIND
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ALLOT-LAST-D
T_ALLOT_LAST_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ELIG-BEGIN-D
T_ELIG_BEGIN_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ELIG-LAST-D
T_ELIG_LAST_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-RESET-POINT
T_RESET_POINT
Numeric 4 (mmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-RESET-LAST-D
T_RESET_LAST_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-CARRY-END-D
T_CARRY_END_D
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-LST-PER-DT-E
T_LST_PER_DT_E
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-LST-PER-DT-H
T_LST_PER_DT_H
Numeric 8 (yyyymmdd)HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-LST-OBJ-ID-E
T_LST_OBJ_ID_E
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-LST-OBJ-ID-H
T_LST_OBJ_ID_H
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-AVAIL-HRS-B
T_AVAIL_HRS_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ACCR-HRS-B
T_ACCR_HRS_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ALLOT-HRS-B
T_ALLOT_HRS_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-RESRV-HRS-B
T_RESRV_HRS_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-CARRY-HRS-B
T_CARRY_HRS_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-AVAIL-ERN-B
T_AVAIL_ERN_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ACCR-ERN-B
T_ACCR_ERN_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-ALLOT-ERN-B
T_ALLOT_ERN_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-RESRV-ERN-B
T_RESRV_ERN_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-CARRY-ERN-B
T_CARRY_ERN_B
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-T-RUN-FLAG
T_RUN_FLAG
Numeric 1
  • 0 No Transactions Processed
  • 1 Transactions Processed
  • 2 LP130 transactions processed
HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
TEM-CREATE-DATE
CREATE_DATE
Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-CREATE-TIME
CREATE_TIME
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-CREATE-USER-ID
CREATE_USER_ID
Alpha 10 (Lower Case)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-DATE-STAMP
DATE_STAMP
Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP140 +11 more
TEM-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP140 +11 more
TEM-USER-ID
USER_ID
Alpha 10 (Lower Case)HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP140 +11 more
TEM-OV-HRS-NEG-BAL
OV_HRS_NEG_BAL
Numeric 1
  • 0 Do not override
  • 1 Warning
  • 2 Error
  • 3 Do not check balances
  • 4 Reclassify as unpaid time
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ERN-NEG-BAL
OV_ERN_NEG_BAL
Numeric 1
  • 0 Do not override
  • 1 Warning
  • 2 Error
  • 3 Do not check balances
  • 4 Reduce to plan balance
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-HRS-NEG-WEB
OV_HRS_NEG_WEB
Numeric 1
  • 0 Do not override
  • 1 Warning
  • 2 Error
  • 3 Do not check balances
  • 4 Reclassify as unpaid time
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ERN-NEG-WEB
OV_ERN_NEG_WEB
Numeric 1
  • 0 Do not override
  • 1 Warning
  • 2 Error
  • 3 Do not check balances
  • 4 Reduce to plan balance
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-HRS-NEG-LMT
OV_HRS_NEG_LMT
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-HRS-LINK-TB
OV_HRS_LINK_TB
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-HRS-PRO-ORD
OV_HRS_PRO_ORD
Numeric 1
  • 0 Do not override
  • 1 Link plans
  • 2 Orig neg bal limit
  • 3 Link plans; orig neg bal limit
  • 4 Link plans; link neg bal limit
  • 5 Orig neg bal limit; link plans
  • 6 Org ng bal lmt; link; link lmt
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-HRS-UNPD-CD
OV_HRS_UNPD_CD
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ERN-NEG-LMT
OV_ERN_NEG_LMT
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ERN-LINK-TB
OV_ERN_LINK_TB
Alpha 10HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-OV-ERN-PRO-ORD
OV_ERN_PRO_ORD
Numeric 1
  • 0 Do not override
  • 1 Link plans
  • 2 Orig neg bal limit
  • 3 Link plans; orig neg bal limit
  • 4 Link plans; link neg bal limit
  • 5 Orig neg bal limit; link plans
  • 6 Org ng bal lmt; link; link lmt
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-TRANSFER-FLAG
TRANSFER_FLAG
Numeric 1
  • 0 Open
  • 1 Stop Events
  • 8 Stop Events;Closed
  • 9 Closed
HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
TEM-ACCUM-HRS-LIA
ACCUM_HRS_LIA
Signed 18.6HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TEMSET1COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITIONPrimaryBN100, BN101, BN102, BN103, BN105, BN150, BN245, BN305 +22 more (list truncated in source)
TEMSET2COMPANY, PLAN, EMPLOYEE-GROUP, EMPLOYEE, POSITIONHS706, LP01.1, LP02.1, LP101, LP103, LP180, LP220, LP331 +2 more
TEMSET3COMPANY, EMPLOYEE, EMPLOYEE-GROUP, PLAN, POSITIONLP100, LP130, LP180
TEMSET4COMPANY, EMPLOYEE, POSITION, PLAN, EMPLOYEE-GROUPLP100
TEMSET5COMPANY, HM-PROC-LEVEL, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITIONKeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, LP140, LP145, LP180 +22 more (list truncated in source)
TEMSET6COMPANY, HM-PROC-LEVEL, PLAN, EMPLOYEE-GROUP, EMPLOYEE, POSITIONKeyChangeLP145, LP198

Relations

One to one (18) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTEM-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen TEM-CURRENCY-CODE != SpacesTEM-CURRENCY-CODECUC-CURRENCY-CODE
EmployeeEMPLOYEERequiredTEM-COMPANYEMP-COMPANY, TEM-EMPLOYEEEMP-EMPLOYEE
Employee GroupPERSGROUPRequiredTEM-COMPANYPRG-COMPANY, TEM-EMPLOYEE-GROUPPRG-GROUP-NAME
Ern Accr DistGLMASTERRequiredWhen TEM-ERN-ACCR-CO != Zeroes And TEM-ERN-ACCR-UNIT != Spaces And TEM-ERN-ACCR-ACCT != ZeroesTEM-ERN-ACCR-COGLM-COMPANY, TEM-ERN-ACCR-UNITGLM-ACCT-UNIT, TEM-ERN-ACCR-ACCTGLM-ACCOUNT, TEM-ERN-ACCR-SUBGLM-SUB-ACCOUNT
Ern Acct CatACACCTCATRequiredWhen (TEM-ERN-ACCT-CAT != Spaces)TEM-ERN-ACCT-CATAAX-ACCT-CATEGORY
Ern ActivityACACTIVITYRequiredWhen (TEM-ERN-ACTIVITY != Spaces)TEM-ERN-ACTIVITYACV-ACTIVITY
Ern Exp DistGLMASTERRequiredWhen TEM-ERN-EXP-CO != Zeroes And TEM-ERN-EXP-UNIT != Spaces And TEM-ERN-EXP-ACCT != ZeroesTEM-ERN-EXP-COGLM-COMPANY, TEM-ERN-EXP-UNITGLM-ACCT-UNIT, TEM-ERN-EXP-ACCTGLM-ACCOUNT, TEM-ERN-EXP-SUBGLM-SUB-ACCOUNT
Ern Link TableLPLINKRequiredTEM-COMPANYLNK-COMPANY, TEM-OV-ERN-LINK-TBLNK-LINK-PLAN-TB, 2LNK-TABLE-TYPE
Hm Proc LevelPRSYSTEMRequiredWhen TEM-HM-PROC-LEVEL != SpacesTEM-COMPANYPRS-COMPANY, TEM-HM-PROC-LEVELPRS-PROCESS-LEVEL
Hrs Accr DistGLMASTERRequiredWhen TEM-HRS-ACCR-CO != Zeroes And TEM-HRS-ACCR-UNIT != Spaces And TEM-HRS-ACCR-ACCT != ZeroesTEM-HRS-ACCR-COGLM-COMPANY, TEM-HRS-ACCR-UNITGLM-ACCT-UNIT, TEM-HRS-ACCR-ACCTGLM-ACCOUNT, TEM-HRS-ACCR-SUBGLM-SUB-ACCOUNT
Hrs Acct CatACACCTCATRequiredWhen (TEM-HRS-ACCT-CAT != Spaces)TEM-HRS-ACCT-CATAAX-ACCT-CATEGORY
Hrs ActivityACACTIVITYRequiredWhen (TEM-HRS-ACTIVITY != Spaces)TEM-HRS-ACTIVITYACV-ACTIVITY
Hrs Exp DistGLMASTERRequiredWhen TEM-HRS-EXP-CO != Zeroes And TEM-HRS-EXP-UNIT != Spaces And TEM-HRS-EXP-ACCT != ZeroesTEM-HRS-EXP-COGLM-COMPANY, TEM-HRS-EXP-UNITGLM-ACCT-UNIT, TEM-HRS-EXP-ACCTGLM-ACCOUNT, TEM-HRS-EXP-SUBGLM-SUB-ACCOUNT
Hrs Link TableLPLINKRequiredTEM-COMPANYLNK-COMPANY, TEM-OV-HRS-LINK-TBLNK-LINK-PLAN-TB, 1LNK-TABLE-TYPE
Ov Hrs Unpd CdTASERVCODERequiredTEM-COMPANYTSC-COMPANY, TEM-OV-HRS-UNPD-CDTSC-SERVICE-CODE
PaemployeePAEMPLOYEERequiredTEM-COMPANYPEM-COMPANY, TEM-EMPLOYEEPEM-EMPLOYEE
PlanTAPLANRequiredTEM-COMPANYTAP-COMPANY, TEM-PLANTAP-PLAN

One to many (22) — child tables

RelationTableRulesConditionField map
Accr Ern TblTATABLEValid When TEM-OV-ACCR-ERN != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ACCR-ERNTBL-TABLE, TBL-EFFECTIVE-DATE
Accr Hrs TblTATABLEValid When TEM-OV-ACCR-HRS != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ACCR-HRSTBL-TABLE, TBL-EFFECTIVE-DATE
Acrlim Ern TblTATABLEValid When TEM-OV-ACRLIM-ERN != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ACRLIM-ERNTBL-TABLE, TBL-EFFECTIVE-DATE
Acrlim Hrs TblTATABLEValid When TEM-OV-ACRLIM-HRS != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ACRLIM-HRSTBL-TABLE, TBL-EFFECTIVE-DATE
Allot Ern TblTATABLEValid When TEM-OV-ALLOT-ERN != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ALLOT-ERNTBL-TABLE, TBL-EFFECTIVE-DATE
Allot Hrs TblTATABLEValid When TEM-OV-ALLOT-HRS != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ALLOT-HRSTBL-TABLE, TBL-EFFECTIVE-DATE
Bal Ern TblTATABLEValid When TEM-OV-BAL-ERN != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-BAL-ERNTBL-TABLE, TBL-EFFECTIVE-DATE
Bal Hrs TblTATABLEValid When TEM-OV-BAL-HRS != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-BAL-HRSTBL-TABLE, TBL-EFFECTIVE-DATE
Bn Ta EmployeeBNTAEMPBALTEM-COMPANYBTE-COMPANY, TEM-PLANBTE-TA-PLAN, TEM-EMPLOYEE-GROUPBTE-EMPLOYEE-GROUP, TEM-EMPLOYEEBTE-EMPLOYEE, TEM-POSITIONBTE-POSITION, BTE-PLAN-CODE, BTE-START-DATE
Carry Ern TblTATABLEValid When TEM-OV-CARRY-ERN-T != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-CARRY-ERN-TTBL-TABLE, TBL-EFFECTIVE-DATE
Carry Hrs TblTATABLEValid When TEM-OV-CARRY-HRS-T != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-CARRY-HRS-TTBL-TABLE, TBL-EFFECTIVE-DATE
Ern Lia TblTATABLEValid When TEM-OV-ERN-LIA != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-ERN-LIATBL-TABLE, TBL-EFFECTIVE-DATE
HrhistoryHRHISTORYDelete CascadesValid When TEM-HRH-OBJ-ID != ZeroesTEM-COMPANYHRH-COMPANY, TEM-EMPLOYEEHRH-EMPLOYEE, TEM-HRH-OBJ-IDHRH-OBJ-ID, HRH-FLD-NBR, HRH-POS-LEVEL, HRH-BEG-DATE, HRH-SEQ-NBR
Hrs Lia TblTATABLEValid When TEM-OV-HRS-LIA != SpacesTEM-COMPANYTBL-COMPANY, TEM-OV-HRS-LIATBL-TABLE, TBL-EFFECTIVE-DATE
LppendreqLPPENDREQTEM-COMPANYLPQ-COMPANY, TEM-EMPLOYEELPQ-EMPLOYEE, TEM-PLANLPQ-PLAN, TEM-EMPLOYEE-GROUPLPQ-EMPLOYEE-GROUP, TEM-POSITIONLPQ-POSITION, LPQ-SEQ-NUMBER
PositionPAPOSITIONValid When TEM-POSITION != SpacesTEM-COMPANYPOS-COMPANY, TEM-POSITIONPOS-POSITION, POS-EFFECT-DATE
Ta Enrl No PosTAENROLLDelete CascadesValid When TAP-BALANCE-TYPE = 1 And TAP-ENROLL-TYPE > 1TEM-COMPANYTEN-COMPANY, TEM-EMPLOYEETEN-EMPLOYEE, TEM-PLANTEN-PLAN, TEM-EMPLOYEE-GROUPTEN-EMPLOYEE-GROUP, TEN-POSITION, TEN-JOB-CODE, TEN-PROCESS-LEVEL, TEN-DEPARTMENT
Ta EnrollTAENROLLDelete CascadesValid When TAP-BALANCE-TYPE = 2 And TAP-ENROLL-TYPE > 2TEM-COMPANYTEN-COMPANY, TEM-EMPLOYEETEN-EMPLOYEE, TEM-PLANTEN-PLAN, TEM-EMPLOYEE-GROUPTEN-EMPLOYEE-GROUP, TEM-POSITIONTEN-POSITION, TEN-JOB-CODE, TEN-PROCESS-LEVEL, TEN-DEPARTMENT
TaemptransTAEMPTRANSDelete CascadesTEM-COMPANYTTR-COMPANY, TEM-EMPLOYEETTR-EMPLOYEE, TEM-PLANTTR-PLAN, TEM-EMPLOYEE-GROUPTTR-EMPLOYEE-GROUP, TEM-POSITIONTTR-POSITION, TTR-DATE, TTR-SEQ-NBR
TaloshrsTALOSHRSDelete CascadesTEM-COMPANYTLH-COMPANY, TEM-EMPLOYEETLH-EMPLOYEE, TEM-PLANTLH-PLAN, TEM-EMPLOYEE-GROUPTLH-EMPLOYEE-GROUP, TEM-POSITIONTLH-POSITION, TLH-PLAN-RULE, TLH-ACCRUAL-TYPE, TLH-YEAR
TastructurTASTRUCTURTEM-COMPANYTST-COMPANY, TEM-EMPLOYEE-GROUPTST-EMPLOYEE-GROUP, TEM-PLANTST-PLAN, TST-BEGIN-DATE
TatransumTATRANSUMDelete CascadesTEM-COMPANYTTS-COMPANY, TEM-EMPLOYEETTS-EMPLOYEE, TEM-PLANTTS-PLAN, TEM-EMPLOYEE-GROUPTTS-EMPLOYEE-GROUP, TEM-POSITIONTTS-POSITION, TTS-TA-TYPE, TTS-RESET-DATE

Programs

Updated by (125)

Referenced by (27)