|
|
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
|
