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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#TEM-COMPANY PK
COMPANY
Numeric 4—HR11.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 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-EMPLOYEE-GROUP PK
EMPLOYEE_GROUP
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-HM-PROC-LEVEL SET5 SET6
HM_PROC_LEVEL
Alpha 5—BN305, 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.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +9 more
#TEM-ACCR-HRS-BAL
ACCR_HRS_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-ALLOT-HRS-BAL
ALLOT_HRS_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-RESRV-HRS-BAL
RESRV_HRS_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-CARRY-HRS-BAL
CARRY_HRS_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-AVAIL-ERN-BAL
AVAIL_ERN_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +9 more
#TEM-ACCR-ERN-BAL
ACCR_ERN_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-ALLOT-ERN-BAL
ALLOT_ERN_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-RESRV-ERN-BAL
RESRV_ERN_BAL
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-CARRY-ERN-BAL
CARRY_ERN_BAL
Signed 18.6—HR11.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.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-CARRY-ERN-A
OV_CARRY_ERN_A
Signed 18.6—HR11.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 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ACCR-ERN
OV_ACCR_ERN
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ALLOT-HRS
OV_ALLOT_HRS
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ALLOT-ERN
OV_ALLOT_ERN
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-BAL-HRS
OV_BAL_HRS
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-BAL-ERN
OV_BAL_ERN
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ACRLIM-HRS
OV_ACRLIM_HRS
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ACRLIM-ERN
OV_ACRLIM_ERN
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-CARRY-HRS-T
OV_CARRY_HRS_T
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-CARRY-ERN-T
OV_CARRY_ERN_T
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-HRS-LIA
OV_HRS_LIA
Alpha 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ERN-LIA
OV_ERN_LIA
Alpha 10—HR11.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.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-ACCR-HRS-B
T_ACCR_HRS_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-ALLOT-HRS-B
T_ALLOT_HRS_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-RESRV-HRS-B
T_RESRV_HRS_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-CARRY-HRS-B
T_CARRY_HRS_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-AVAIL-ERN-B
T_AVAIL_ERN_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-ACCR-ERN-B
T_ACCR_ERN_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-ALLOT-ERN-B
T_ALLOT_ERN_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-RESRV-ERN-B
T_RESRV_ERN_B
Signed 18.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP130, LP131 +11 more
#TEM-T-CARRY-ERN-B
T_CARRY_ERN_B
Signed 18.6—HR11.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.6—HR11.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 10—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more
#TEM-OV-ERN-NEG-LMT
OV_ERN_NEG_LMT
Signed 18.6—HR11.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.6—HR11.1, HR511, LP100, LP101, LP102, LP103, LP131, LP151 +8 more

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TEMSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
PrimaryBN100, BN101, BN102, BN103, BN105, BN150, BN245, BN305 +22 more (list truncated in source)
TEMSET2
  1. COMPANY
  2. PLAN
  3. EMPLOYEE-GROUP
  4. EMPLOYEE
  5. POSITION
HS706, LP01.1, LP02.1, LP101, LP103, LP180, LP220, LP331 +2 more
TEMSET3
  1. COMPANY
  2. EMPLOYEE
  3. EMPLOYEE-GROUP
  4. PLAN
  5. POSITION
LP100, LP130, LP180
TEMSET4
  1. COMPANY
  2. EMPLOYEE
  3. POSITION
  4. PLAN
  5. EMPLOYEE-GROUP
LP100
TEMSET5
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. PLAN
  5. EMPLOYEE-GROUP
  6. POSITION
KeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, LP140, LP145, LP180 +22 more (list truncated in source)
TEMSET6
  1. COMPANY
  2. HM-PROC-LEVEL
  3. PLAN
  4. EMPLOYEE-GROUP
  5. EMPLOYEE
  6. POSITION
KeyChangeLP145, LP198

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMCUCODESEMPLOYEEPERSGROUPGLMASTERACACCTCATACACTIVITYLPLINKTASERVCODEPAEMPLOYEETAPLANTATABLEBNTAEMPBALHRHISTORYLPPENDREQPAPOSITIONTAENROLLTAEMPTRANSTALOSHRSTASTRUCTURTATRANSUMTAEEMASTER

One to one (18) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TEM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen TEM-CURRENCY-CODE != Spaces
TEM-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
TEM-COMPANY→EMP-COMPANY
TEM-EMPLOYEE→EMP-EMPLOYEE
Employee GroupPERSGROUPRequired
TEM-COMPANY→PRG-COMPANY
TEM-EMPLOYEE-GROUP→PRG-GROUP-NAME
Ern Accr DistGLMASTERRequiredWhen TEM-ERN-ACCR-CO != Zeroes And TEM-ERN-ACCR-UNIT != Spaces And TEM-ERN-ACCR-ACCT != Zeroes
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 CatACACCTCATRequiredWhen (TEM-ERN-ACCT-CAT != Spaces)
TEM-ERN-ACCT-CAT→AAX-ACCT-CATEGORY
Ern ActivityACACTIVITYRequiredWhen (TEM-ERN-ACTIVITY != Spaces)
TEM-ERN-ACTIVITY→ACV-ACTIVITY
Ern Exp DistGLMASTERRequiredWhen TEM-ERN-EXP-CO != Zeroes And TEM-ERN-EXP-UNIT != Spaces And TEM-ERN-EXP-ACCT != Zeroes
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
Ern Link TableLPLINKRequired
TEM-COMPANY→LNK-COMPANY
TEM-OV-ERN-LINK-TB→LNK-LINK-PLAN-TB
2→LNK-TABLE-TYPE
Hm Proc LevelPRSYSTEMRequiredWhen TEM-HM-PROC-LEVEL != Spaces
TEM-COMPANY→PRS-COMPANY
TEM-HM-PROC-LEVEL→PRS-PROCESS-LEVEL
Hrs Accr DistGLMASTERRequiredWhen TEM-HRS-ACCR-CO != Zeroes And TEM-HRS-ACCR-UNIT != Spaces And TEM-HRS-ACCR-ACCT != Zeroes
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 CatACACCTCATRequiredWhen (TEM-HRS-ACCT-CAT != Spaces)
TEM-HRS-ACCT-CAT→AAX-ACCT-CATEGORY
Hrs ActivityACACTIVITYRequiredWhen (TEM-HRS-ACTIVITY != Spaces)
TEM-HRS-ACTIVITY→ACV-ACTIVITY
Hrs Exp DistGLMASTERRequiredWhen TEM-HRS-EXP-CO != Zeroes And TEM-HRS-EXP-UNIT != Spaces And TEM-HRS-EXP-ACCT != Zeroes
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
Hrs Link TableLPLINKRequired
TEM-COMPANY→LNK-COMPANY
TEM-OV-HRS-LINK-TB→LNK-LINK-PLAN-TB
1→LNK-TABLE-TYPE
Ov Hrs Unpd CdTASERVCODERequired
TEM-COMPANY→TSC-COMPANY
TEM-OV-HRS-UNPD-CD→TSC-SERVICE-CODE
PaemployeePAEMPLOYEERequired
TEM-COMPANY→PEM-COMPANY
TEM-EMPLOYEE→PEM-EMPLOYEE
PlanTAPLANRequired
TEM-COMPANY→TAP-COMPANY
TEM-PLAN→TAP-PLAN

One to many (22) — child tables

RelationTableRulesConditionField map
Accr Ern TblTATABLEValid When TEM-OV-ACCR-ERN != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ACCR-ERN→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Accr Hrs TblTATABLEValid When TEM-OV-ACCR-HRS != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ACCR-HRS→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Acrlim Ern TblTATABLEValid When TEM-OV-ACRLIM-ERN != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ACRLIM-ERN→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Acrlim Hrs TblTATABLEValid When TEM-OV-ACRLIM-HRS != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ACRLIM-HRS→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Allot Ern TblTATABLEValid When TEM-OV-ALLOT-ERN != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ALLOT-ERN→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Allot Hrs TblTATABLEValid When TEM-OV-ALLOT-HRS != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ALLOT-HRS→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Bal Ern TblTATABLEValid When TEM-OV-BAL-ERN != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-BAL-ERN→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Bal Hrs TblTATABLEValid When TEM-OV-BAL-HRS != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-BAL-HRS→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Bn Ta EmployeeBNTAEMPBAL
TEM-COMPANY→BTE-COMPANY
TEM-PLAN→BTE-TA-PLAN
TEM-EMPLOYEE-GROUP→BTE-EMPLOYEE-GROUP
TEM-EMPLOYEE→BTE-EMPLOYEE
TEM-POSITION→BTE-POSITION
—→BTE-PLAN-CODE
—→BTE-START-DATE
Carry Ern TblTATABLEValid When TEM-OV-CARRY-ERN-T != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-CARRY-ERN-T→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Carry Hrs TblTATABLEValid When TEM-OV-CARRY-HRS-T != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-CARRY-HRS-T→TBL-TABLE
—→TBL-EFFECTIVE-DATE
Ern Lia TblTATABLEValid When TEM-OV-ERN-LIA != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-ERN-LIA→TBL-TABLE
—→TBL-EFFECTIVE-DATE
HrhistoryHRHISTORYDelete CascadesValid When TEM-HRH-OBJ-ID != Zeroes
TEM-COMPANY→HRH-COMPANY
TEM-EMPLOYEE→HRH-EMPLOYEE
TEM-HRH-OBJ-ID→HRH-OBJ-ID
—→HRH-FLD-NBR
—→HRH-POS-LEVEL
—→HRH-BEG-DATE
—→HRH-SEQ-NBR
Hrs Lia TblTATABLEValid When TEM-OV-HRS-LIA != Spaces
TEM-COMPANY→TBL-COMPANY
TEM-OV-HRS-LIA→TBL-TABLE
—→TBL-EFFECTIVE-DATE
LppendreqLPPENDREQ
TEM-COMPANY→LPQ-COMPANY
TEM-EMPLOYEE→LPQ-EMPLOYEE
TEM-PLAN→LPQ-PLAN
TEM-EMPLOYEE-GROUP→LPQ-EMPLOYEE-GROUP
TEM-POSITION→LPQ-POSITION
—→LPQ-SEQ-NUMBER
PositionPAPOSITIONValid When TEM-POSITION != Spaces
TEM-COMPANY→POS-COMPANY
TEM-POSITION→POS-POSITION
—→POS-EFFECT-DATE
Ta Enrl No PosTAENROLLDelete CascadesValid When TAP-BALANCE-TYPE = 1 And TAP-ENROLL-TYPE > 1
TEM-COMPANY→TEN-COMPANY
TEM-EMPLOYEE→TEN-EMPLOYEE
TEM-PLAN→TEN-PLAN
TEM-EMPLOYEE-GROUP→TEN-EMPLOYEE-GROUP
—→TEN-POSITION
—→TEN-JOB-CODE
—→TEN-PROCESS-LEVEL
—→TEN-DEPARTMENT
Ta EnrollTAENROLLDelete CascadesValid When TAP-BALANCE-TYPE = 2 And TAP-ENROLL-TYPE > 2
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
TaemptransTAEMPTRANSDelete Cascades
TEM-COMPANY→TTR-COMPANY
TEM-EMPLOYEE→TTR-EMPLOYEE
TEM-PLAN→TTR-PLAN
TEM-EMPLOYEE-GROUP→TTR-EMPLOYEE-GROUP
TEM-POSITION→TTR-POSITION
—→TTR-DATE
—→TTR-SEQ-NBR
TaloshrsTALOSHRSDelete Cascades
TEM-COMPANY→TLH-COMPANY
TEM-EMPLOYEE→TLH-EMPLOYEE
TEM-PLAN→TLH-PLAN
TEM-EMPLOYEE-GROUP→TLH-EMPLOYEE-GROUP
TEM-POSITION→TLH-POSITION
—→TLH-PLAN-RULE
—→TLH-ACCRUAL-TYPE
—→TLH-YEAR
TastructurTASTRUCTUR
TEM-COMPANY→TST-COMPANY
TEM-EMPLOYEE-GROUP→TST-EMPLOYEE-GROUP
TEM-PLAN→TST-PLAN
—→TST-BEGIN-DATE
TatransumTATRANSUMDelete Cascades
TEM-COMPANY→TTS-COMPANY
TEM-EMPLOYEE→TTS-EMPLOYEE
TEM-PLAN→TTS-PLAN
TEM-EMPLOYEE-GROUP→TTS-EMPLOYEE-GROUP
TEM-POSITION→TTS-POSITION
—→TTS-TA-TYPE
—→TTS-RESET-DATE

Programs

Updated by (125)

Referenced by (27)