|
|
TAENROLL FILE
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
TEN-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.
TEN-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.
TEN-PLAN Alpha 10 HR11.1 HR511
Element: Ta Plan PA100 PA52.4
TEN-EMPLOYEE-GROUP Alpha 10 HR11.1 HR511
Element: Group Name PA100 PA52.4
TEN-HM-PROC-LEVEL Alpha 5 HR11.1 HR511
Element: Process Lev HrContains the employee's home process PA100 PA52.4
level.
TEN-POSITION Alpha 12 HR11.1 HR511
Element: Position Contains the user-defined code that PA100 PA52.4
represents a position in the company.
TEN-JOB-CODE Alpha 9 HR11.1 HR511
Element: Job Code Contains a user-defined code that PA100 PA52.4
represents a type of job.
TEN-PROCESS-LEVEL Alpha 5 HR11.1 HR511
Element: Process Lev HrThis field contains the process level, PA100 PA52.4
which is the reporting hierarchy below
company.
TEN-DEPARTMENT Alpha 5 HR11.1 HR511
Element: Department Contains the department. PA100 PA52.4
TEN-ENRL-START-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Start Date PA100 PA52.4
TEN-ENRL-STOP-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Stop Date PA100 PA52.4
TEN-ENRL-OVERRIDE Numeric 1 HR11.1 HR511
Element: Ta Override 0 = No PA100 PA52.4
1 = Yes
TEN-CREATE-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Date Stamp The creation date. PA100 PA52.4
TEN-CREATE-TIME Numeric 6 (hhmmss) HR11.1 HR511
Element: Time Stamp PA100 PA52.4
TEN-CREATE-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
Element: User PA100 PA52.4
TEN-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.
TEN-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.
TEN-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.
TAENROLL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TENSET1 COMPANY HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
PLAN PA100 PA102
EMPLOYEE-GROUP PA13.1 PA13.2
POSITION PA502 PA513
JOB-CODE PA52.1 PA52.3
PROCESS-LEVEL PA52.4 PA52.5
DEPARTMENT PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
TENSET2 COMPANY
EMPLOYEE
EMPLOYEE-GROUP
PLAN
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TENSET3 COMPANY KeyChange
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TAENROLL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TEN-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When (TEN-DEPARTMENT != Spaces )
TEN-COMPANY -> DPT-COMPANY
TEN-DEPARTMENT -> DPT-DEPARTMENT
Spaces -> DPT-PROCESS-LEVEL
Employee EMPLOYEE Required
TEN-COMPANY -> EMP-COMPANY
TEN-EMPLOYEE -> EMP-EMPLOYEE
Employee Group PERSGROUP Required
TEN-COMPANY -> PRG-COMPANY
TEN-EMPLOYEE-GROUP -> PRG-GROUP-NAME
Job Code JOBCODE Required
When (TEN-JOB-CODE != Spaces )
TEN-COMPANY -> JBC-COMPANY
TEN-JOB-CODE -> JBC-JOB-CODE
Plan TAPLAN Required
TEN-COMPANY -> TAP-COMPANY
TEN-PLAN -> TAP-PLAN
Process Level PRSYSTEM Required
When (TEN-PROCESS-LEVEL != Spaces )
TEN-COMPANY -> PRS-COMPANY
TEN-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Ta Master TAEEMASTER Required
TEN-COMPANY -> TEM-COMPANY
TEN-EMPLOYEE -> TEM-EMPLOYEE
TEN-PLAN -> TEM-PLAN
TEN-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
TEN-POSITION -> TEM-POSITION
TAENROLL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (TEN-POSITION != Spaces )
TEN-COMPANY -> POS-COMPANY
TEN-POSITION -> POS-POSITION
POS-EFFECT-DATE
|
