Lawson Insight Technical Documentation |
|
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 ET700 LP04.2 LP04.3 LP04.4 LP04.5
LP04.6 LP04.7 LP04.8 LP04.9 LP188 LP198
LP220 LP231 LP264 LP34.1 LP64.1 LP64.2
LP65.1 LP88.1 PR160 PR180 PR80.2 PR80.1
LP01.1 LP02.1 LP63.1 LP63.2 BN150 ET530
ETI2.1 PR128 PR130 PR131 PR132 PR134
PR135 PR136 PR137 PR189 PR29.1 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR37.1 PR45.1 PR529 PR530 PR560
PR82.1 UK102 UK560 TA147
UPDATED BY
BN305 HR11.1 HR11.2 HR511 LP100 LP101
LP103 LP130 LP138 LP140 LP145 LP180
LP197 LP31.1 LP331 LP370 LP570 LP70.1
LP70.2 LP80.1 PA02.1 PA100 PA102 PA115
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 LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-EMPLOYEE Numeric 9 HR11.1 HR511
Element: Employee Contains the employee number. Each LP100 LP101
person employed by the company is LP180 LP197
assigned a unique number. The system LP31.1 LP80.1
uses the employee number to correlate PA100 PA52.4
all of the information related to that
person.
TEM-PLAN Alpha 10 HR11.1 HR511
Element: Ta Plan LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-EMPLOYEE-GROUP Alpha 10 HR11.1 HR511
Element: Group Name LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-HM-PROC-LEVEL Alpha 5 BN305 HR11.1
Element: Process Lev Hr HR11.2 HR511
LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA02.1 PA100
PA102 PA115
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
TEM-POSITION Alpha 12 HR11.1 HR511
Element: Position Contains the user-defined code that LP100 LP101
represents a position in the company. LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-MASTR-ENTRY Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-MSTR-ELIG-END Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP103 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-MSTR-END Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP103 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-STRUCTURE-END Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-MSTR-OVERRIDE Numeric 1 HR11.1 HR511
Element: Ta Override 0 = No LP100 LP101
1 = Yes LP103 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-SRV-BEGIN-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ACCR-BEGIN-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ACCR-START-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Start Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ACCR-LAST-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ALLOT-POINT Numeric 4 (mmdd) HR11.1 HR511
Element: Ta Point LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ALLOT-BEGIN-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ALLOT-LAST-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ELIG-BEGIN-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ELIG-LAST-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-RESET-POINT Numeric 4 (mmdd) HR11.1 HR511
Element: Ta Point LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-RESET-LAST-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-CARRYOVER-END Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-AVAIL-HRS-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-ACCR-HRS-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ALLOT-HRS-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-RESRV-HRS-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-CARRY-HRS-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-AVAIL-ERN-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-ACCR-ERN-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-ALLOT-ERN-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-RESRV-ERN-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-CARRY-ERN-BAL Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-CURRENCY-CODE Alpha 5 HR11.1 HR511
Element: Currency Code This field contains the company base LP100 LP101
currency code established in Company LP180 LP197
(GL10.1 ). LP31.1 LP80.1
PA100 PA52.4
TEM-OV-CARRY-HRS-A Signed 18.6 HR11.1 HR511
Element: Ta Carry Amt LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-CARRY-ERN-A Signed 18.6 HR11.1 HR511
Element: Ta Carry Amt LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-HRS-ACCR-CO Numeric 4 HR11.1 HR511
Element: Company Identifies the AP company if the LP100 LP101
resource type = V. Identifies the HR LP180 LP197
company if the resource type = E. It is LP31.1 LP80.1
blank for type A, P or Q resources. PA100 PA52.4
TEM-HRS-ACCR-UNIT Alpha 15 HR11.1 HR511
Element: Acct Unit The accounting unit is a shorthand LP100 LP101
notation representing the variable level LP180 LP197
number. When used in the General Ledger LP31.1 LP80.1
Account Master file, the accounting unit PA100 PA52.4
must be defined in the General Ledger
Names file as a posting accounting unit.
TEM-HRS-ACCR-ACCT Numeric 6 HR11.1 HR511
Element: Account This field along with the accounting LP100 LP101
unit and subaccount make up the location LP180 LP197
(account) where amounts and other LP31.1 LP80.1
account information is stored. PA100 PA52.4
TEM-HRS-ACCR-SUB Numeric 4 HR11.1 HR511
Element: Sub Acct This field contains the subaccount from LP100 LP101
your general ledger chart of accounts LP180 LP197
that was charged with the amount carried LP31.1 LP80.1
on this record. PA100 PA52.4
TEM-HRS-EXP-CO Numeric 4 HR11.1 HR511
Element: Company Identifies the AP company if the LP100 LP101
resource type = V. Identifies the HR LP180 LP197
company if the resource type = E. It is LP31.1 LP80.1
blank for type A, P or Q resources. PA100 PA52.4
TEM-HRS-EXP-UNIT Alpha 15 HR11.1 HR511
Element: Acct Unit The accounting unit is a shorthand LP100 LP101
notation representing the variable level LP180 LP197
number. When used in the General Ledger LP31.1 LP80.1
Account Master file, the accounting unit PA100 PA52.4
must be defined in the General Ledger
Names file as a posting accounting unit.
TEM-HRS-EXP-ACCT Numeric 6 HR11.1 HR511
Element: Account This field along with the accounting LP100 LP101
unit and subaccount make up the location LP180 LP197
(account) where amounts and other LP31.1 LP80.1
account information is stored. PA100 PA52.4
TEM-HRS-EXP-SUB Numeric 4 HR11.1 HR511
Element: Sub Acct This field contains the subaccount from LP100 LP101
your general ledger chart of accounts LP180 LP197
that was charged with the amount carried LP31.1 LP80.1
on this record. PA100 PA52.4
TEM-HRS-ACTIVITY Alpha 15 HR11.1 HR511
Element: Activity Activities are the processes or LP100 LP101
procedures that produce work. Cost LP180 LP197
objects (products, services, customers, LP31.1 LP80.1
and so on) are the reasons for PA100 PA52.4
performing the activity.
TEM-HRS-ACCT-CAT Alpha 5 HR11.1 HR511
Element: Acct Category Account categories are groupings of LP100 LP101
costs, revenues, or a combination of LP180 LP197
both used for reporting and inquiries LP31.1 LP80.1
for activities in the Activity PA100 PA52.4
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 thru
TEM-ERN-ACCR-CO Numeric 4 HR11.1 HR511
Element: Company Identifies the AP company if the LP100 LP101
resource type = V. Identifies the HR LP180 LP197
company if the resource type = E. It is LP31.1 LP80.1
blank for type A, P or Q resources. PA100 PA52.4
TEM-ERN-ACCR-UNIT Alpha 15 HR11.1 HR511
Element: Acct Unit The accounting unit is a shorthand LP100 LP101
notation representing the variable level LP180 LP197
number. When used in the General Ledger LP31.1 LP80.1
Account Master file, the accounting unit PA100 PA52.4
must be defined in the General Ledger
Names file as a posting accounting unit.
TEM-ERN-ACCR-ACCT Numeric 6 HR11.1 HR511
Element: Account This field along with the accounting LP100 LP101
unit and subaccount make up the location LP180 LP197
(account) where amounts and other LP31.1 LP80.1
account information is stored. PA100 PA52.4
TEM-ERN-ACCR-SUB Numeric 4 HR11.1 HR511
Element: Sub Acct This field contains the subaccount from LP100 LP101
your general ledger chart of accounts LP180 LP197
that was charged with the amount carried LP31.1 LP80.1
on this record. PA100 PA52.4
TEM-ERN-EXP-CO Numeric 4 HR11.1 HR511
Element: Company Identifies the AP company if the LP100 LP101
resource type = V. Identifies the HR LP180 LP197
company if the resource type = E. It is LP31.1 LP80.1
blank for type A, P or Q resources. PA100 PA52.4
TEM-ERN-EXP-UNIT Alpha 15 HR11.1 HR511
Element: Acct Unit The accounting unit is a shorthand LP100 LP101
notation representing the variable level LP180 LP197
number. When used in the General Ledger LP31.1 LP80.1
Account Master file, the accounting unit PA100 PA52.4
must be defined in the General Ledger
Names file as a posting accounting unit.
TEM-ERN-EXP-ACCT Numeric 6 HR11.1 HR511
Element: Account This field along with the accounting LP100 LP101
unit and subaccount make up the location LP180 LP197
(account) where amounts and other LP31.1 LP80.1
account information is stored. PA100 PA52.4
TEM-ERN-EXP-SUB Numeric 4 HR11.1 HR511
Element: Sub Acct This field contains the subaccount from LP100 LP101
your general ledger chart of accounts LP180 LP197
that was charged with the amount carried LP31.1 LP80.1
on this record. PA100 PA52.4
TEM-ERN-ACTIVITY Alpha 15 HR11.1 HR511
Element: Activity Activities are the processes or LP100 LP101
procedures that produce work. Cost LP180 LP197
objects (products, services, customers, LP31.1 LP80.1
and so on) are the reasons for PA100 PA52.4
performing the activity.
TEM-ERN-ACCT-CAT Alpha 5 HR11.1 HR511
Element: Acct Category Account categories are groupings of LP100 LP101
costs, revenues, or a combination of LP180 LP197
both used for reporting and inquiries LP31.1 LP80.1
for activities in the Activity PA100 PA52.4
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 thru
TEM-LAST-OBJ-ID Numeric 12 HR11.1 HR511
Element: Obj Id This field is not currently being used LP100 LP101
by Absence Management. Reserve for LP180 LP197
future use. LP31.1 LP80.1
PA100 PA52.4
TEM-LST-SEQ-NBR Numeric 4 HR11.1 HR511
Element: Seq Nbr An automatically assigned sequence LP100 LP101
number. LP130 LP138
LP140 LP145
LP180 LP197
LP31.1 LP370
LP570 LP70.1
LP70.2 LP80.1
PA100 PA52.4
TEM-LST-OBJ-ID-HRS Numeric 12 HR11.1 HR511
Element: Obj Id This is the object identifier. It is LP100 LP101
used to relate commitments or posted LP180 LP197
transactions back to the originating LP31.1 LP80.1
subsystems. Each subsystem record that PA100 PA52.4
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.
TEM-LST-OBJ-ID-ERN Numeric 12 HR11.1 HR511
Element: Obj Id This is the object identifier. It is LP100 LP101
used to relate commitments or posted LP180 LP197
transactions back to the originating LP31.1 LP80.1
subsystems. Each subsystem record that PA100 PA52.4
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.
TEM-LST-PER-DT-HRS Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP180 LP197
LP31.1 LP570
LP80.1 PA100
PA52.4
TEM-LST-PER-DT-ERN Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP180 LP197
LP31.1 LP570
LP80.1 PA100
PA52.4
TEM-HRH-OBJ-ID Numeric 12 HR11.1 HR511
Element: Obj Id This is the object identifier. It is LP100 LP101
used to relate commitments or posted LP180 LP197
transactions back to the originating LP31.1 LP80.1
subsystems. Each subsystem record that PA100 PA52.4
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.
TEM-OV-ACCR-HRS Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-ACCR-ERN Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-ALLOT-HRS Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-ALLOT-ERN Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-BAL-HRS Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-BAL-ERN Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-ACRLIM-HRS Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-ACRLIM-ERN Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-CARRY-HRS-T Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-CARRY-ERN-T Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-HRS-LIA Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-ERN-LIA Alpha 10 HR11.1 HR511
Element: Ta Table LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-T-SRV-BEGIN-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ACCR-BEGIN-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ACCR-START-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ACCR-LAST-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ALLOT-POINT Numeric 4 (mmdd) HR11.1 HR511
Element: Ta Point LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ALLOT-BEGIND Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ALLOT-LAST-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ELIG-BEGIN-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Begin Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ELIG-LAST-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-RESET-POINT Numeric 4 (mmdd) HR11.1 HR511
Element: Ta Point LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-RESET-LAST-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Last Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-CARRY-END-D Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-LST-PER-DT-E Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-LST-PER-DT-H Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta End Date LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-LST-OBJ-ID-E Numeric 12 HR11.1 HR511
Element: Obj Id This is the object identifier. It is LP100 LP101
used to relate commitments or posted LP130 LP140
transactions back to the originating LP145 LP180
subsystems. Each subsystem record that LP197 LP31.1
is updated as a commitment or posted LP80.1 PA100
transaction is assigned an object PA52.4
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.
TEM-T-LST-OBJ-ID-H Numeric 12 HR11.1 HR511
Element: Obj Id This is the object identifier. It is LP100 LP101
used to relate commitments or posted LP130 LP140
transactions back to the originating LP145 LP180
subsystems. Each subsystem record that LP197 LP31.1
is updated as a commitment or posted LP80.1 PA100
transaction is assigned an object PA52.4
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.
TEM-T-AVAIL-HRS-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ACCR-HRS-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ALLOT-HRS-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-RESRV-HRS-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-CARRY-HRS-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-AVAIL-ERN-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ACCR-ERN-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-ALLOT-ERN-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-RESRV-ERN-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-CARRY-ERN-B Signed 18.6 HR11.1 HR511
Element: Ta Amount LP100 LP101
LP130 LP140
LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-T-RUN-FLAG Numeric 1 HR11.1 HR511
Element: Ta Run Flag 0 = No Transactions Processed LP100 LP101
1 = Transactions Processed LP130 LP140
2 = LP130 transactions processed LP145 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4
TEM-CREATE-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Date Stamp This field contains the server date LP100 LP101
(month, date, and year) of the last LP180 LP197
change to this record. LP31.1 LP80.1
PA100 PA52.4
TEM-CREATE-TIME Numeric 6 (hhmmss) HR11.1 HR511
Element: Time Stamp Contains the server time (hour, minute, LP100 LP101
and second) when the record was last LP180 LP197
changed. LP31.1 LP80.1
PA100 PA52.4
TEM-CREATE-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
Element: User LP100 LP101
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-DATE-STAMP Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Date Stamp This field contains the server date LP100 LP101
(month, date, and year) of the last LP140 LP145
change to this record. LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR511
Element: Time Stamp Contains the server time (hour, minute, LP100 LP101
and second) when the record was last LP140 LP145
changed. LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
Element: User LP100 LP101
LP140 LP145
LP180 LP197
LP31.1 LP80.1
PA100 PA52.4
TEM-OV-HRS-NEG-BAL Numeric 1
Element: Ta Negativ Bal0 = Do not override
1 = Warning
2 = Error
3 = Do not check balances
4 = Reclassify as unpaid time
TEM-OV-ERN-NEG-BAL Numeric 1
Element: Ta Negativ Bal0 = Do not override
1 = Warning
2 = Error
3 = Do not check balances
4 = Reduce to plan balance
TEM-OV-HRS-NEG-WEB Numeric 1
Element: Ta Negativ Bal0 = Do not override
1 = Warning
2 = Error
3 = Do not check balances
4 = Reclassify as unpaid time
TEM-OV-ERN-NEG-WEB Numeric 1
Element: Ta Negativ Bal0 = Do not override
1 = Warning
2 = Error
3 = Do not check balances
4 = Reduce to plan balance
TEM-OV-HRS-NEG-LMT Signed 18.6
Element: Ta Amount
TEM-OV-HRS-LINK-TB Alpha 10
Element: Ta Table
TEM-OV-HRS-PRO-ORD Numeric 1
Element: Ta Proc Order 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
TEM-OV-HRS-UNPD-CD Alpha 4
Element: Ta Service Cd
TEM-OV-ERN-NEG-LMT Signed 18.6
Element: Ta Amount
TEM-OV-ERN-LINK-TB Alpha 10
Element: Ta Table
TEM-OV-ERN-PRO-ORD Numeric 1
Element: Ta Proc Order 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
TAEEMASTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TEMSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
PLAN BN105 BN245
EMPLOYEE-GROUP BN305 BN31.1
POSITION BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET700 HR11.1
HR11.2 HR511
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
...
TEMSET2 COMPANY LP01.1 LP02.1
PLAN LP101 LP103
EMPLOYEE-GROUP LP180 LP220
EMPLOYEE LP331 LP63.1
POSITION LP63.2
TEMSET3 COMPANY LP100 LP130
EMPLOYEE LP180
EMPLOYEE-GROUP
PLAN
POSITION
TEMSET4 COMPANY LP100
EMPLOYEE
POSITION
PLAN
EMPLOYEE-GROUP
TEMSET5 COMPANY KeyChange BN150 ET530
HM-PROC-LEVEL ETI2.1 LP130
EMPLOYEE LP140 LP145
PLAN LP180 LP188
EMPLOYEE-GROUP LP197 LP198
POSITION PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
...
TEMSET6 COMPANY KeyChange LP145 LP198
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
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When TEM-CURRENCY-CODE != Spaces
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 Required
When 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 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 Required
When 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
Hm Proc Level PRSYSTEM Required
When TEM-HM-PROC-LEVEL != Spaces
TEM-COMPANY -> PRS-COMPANY
TEM-HM-PROC-LEVEL -> PRS-PROCESS-LEVEL
Hrs Accr Dist GLMASTER Required
When 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 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 Required
When 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
Ov Hrs Unpd Cd TASERVCODE Required
TEM-COMPANY -> TSC-COMPANY
TEM-OV-HRS-UNPD-CD -> TSC-SERVICE-CODE
Paemployee PAEMPLOYEE Required
TEM-COMPANY -> PEM-COMPANY
TEM-EMPLOYEE -> PEM-EMPLOYEE
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
Accr Ern Tbl TATABLE
Valid When TEM-OV-ACCR-ERN != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ACCR-ERN -> TBL-TABLE
TBL-EFFECTIVE-DATE
Accr Hrs Tbl TATABLE
Valid When TEM-OV-ACCR-HRS != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ACCR-HRS -> TBL-TABLE
TBL-EFFECTIVE-DATE
Acrlim Ern Tbl TATABLE
Valid When TEM-OV-ACRLIM-ERN != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ACRLIM-ERN -> TBL-TABLE
TBL-EFFECTIVE-DATE
Acrlim Hrs Tbl TATABLE
Valid When TEM-OV-ACRLIM-HRS != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ACRLIM-HRS -> TBL-TABLE
TBL-EFFECTIVE-DATE
Allot Ern Tbl TATABLE
Valid When TEM-OV-ALLOT-ERN != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ALLOT-ERN -> TBL-TABLE
TBL-EFFECTIVE-DATE
Allot Hrs Tbl TATABLE
Valid When TEM-OV-ALLOT-HRS != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ALLOT-HRS -> TBL-TABLE
TBL-EFFECTIVE-DATE
Bal Ern Tbl TATABLE
Valid When TEM-OV-BAL-ERN != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-BAL-ERN -> TBL-TABLE
TBL-EFFECTIVE-DATE
Bal Hrs Tbl TATABLE
Valid When TEM-OV-BAL-HRS != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-BAL-HRS -> TBL-TABLE
TBL-EFFECTIVE-DATE
Bn Ta Employee BNTAEMPBAL
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 Tbl TATABLE
Valid When TEM-OV-CARRY-ERN-T != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-CARRY-ERN-T -> TBL-TABLE
TBL-EFFECTIVE-DATE
Carry Hrs Tbl TATABLE
Valid When TEM-OV-CARRY-HRS-T != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-CARRY-HRS-T -> TBL-TABLE
TBL-EFFECTIVE-DATE
Ern Lia Tbl TATABLE
Valid When TEM-OV-ERN-LIA != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-ERN-LIA -> TBL-TABLE
TBL-EFFECTIVE-DATE
Hrhistory HRHISTORY Delete Cascades
Valid 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 Tbl TATABLE
Valid When TEM-OV-HRS-LIA != Spaces
TEM-COMPANY -> TBL-COMPANY
TEM-OV-HRS-LIA -> TBL-TABLE
TBL-EFFECTIVE-DATE
Position PAPOSITION
Valid When TEM-POSITION != Spaces
TEM-COMPANY -> POS-COMPANY
TEM-POSITION -> POS-POSITION
POS-EFFECT-DATE
Ta Enrl No Pos TAENROLL Delete Cascades
Valid 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 Enroll TAENROLL Delete Cascades
Valid 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
Taemptrans TAEMPTRANS Delete 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
Taloshrs TALOSHRS Delete 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
Tastructur TASTRUCTUR
TEM-COMPANY -> TST-COMPANY
TEM-EMPLOYEE-GROUP -> TST-EMPLOYEE-GROUP
TEM-PLAN -> TST-PLAN
TST-BEGIN-DATE
Tatransum TATRANSUM Delete 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
|