TAENROLL

REFERENCED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 LP145
LP198 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
PR582 PR80.1 PR80.4 PR82.1 UK102 UK560
TA147


UPDATED BY
BN305 HR11.1 HR11.2 HR511 LP100 LP101
LP103 LP180 LP32.1 LP32.2 LP32.3 LP331
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 PR13.9 LP102 LP131 LP140
LP188 LP197 LP231 LP31.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TEN-COMPANY
Element: Company Hr		Numeric 4
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-EMPLOYEE
Element: Employee		Numeric 9
Contains 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
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-PLAN
Element: Ta Plan		Alpha 10
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
BN305 HR11.1
HR11.2 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
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
PR13.9
TEN-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-ENRL-START-DT
Element: Ta Start Date		Numeric 8 (yyyymmdd)
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-ENRL-STOP-DT
Element: Ta Stop Date		Numeric 8 (yyyymmdd)
HR11.1 HR511
LP100 LP101
LP103 LP180
LP32.1 LP32.2
LP32.3 LP80.1
PA100 PA52.4
TEN-ENRL-OVERRIDE
Element: Ta Override		Numeric 1

0 = No
1 = Yes
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-CREATE-DATE
Element: 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
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-DATE-STAMP
Element: 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
LP103 LP180
LP32.1 LP32.2
LP32.3 LP80.1
PA100 PA52.4
TEN-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR11.1 HR511
LP100 LP101
LP103 LP180
LP32.1 LP32.2
LP32.3 LP80.1
PA100 PA52.4
TEN-USER-ID
Element: User		Alpha 10 (Lower Case)
HR11.1 HR511
LP100 LP101
LP103 LP180
LP32.1 LP32.2
LP32.3 LP80.1
PA100 PA52.4


TAENROLL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TENSET1 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
...
BN150 BN305
HR11.1 HR11.2
HR511 PR521
EXI2.1 EXI4.1
LP100 LP101
LP102 LP103
LP130 LP131
LP140 LP145
LP180 LP188
LP197 LP198
LP231 LP31.1
LP32.1 LP32.2
LP32.3 LP331
LP80.1 PA02.1
PA100 PA102
TENSET2 COMPANY
EMPLOYEE
EMPLOYEE-GROUP
PLAN
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TENSET3 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
KeyChange
...
BN150 PR521
EXI2.1 EXI4.1
LP130 LP140
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


TAENROLL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TEN-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Department DEPTCODE Required
When (TEN-DEPARTMENT !=Spaces )
TEN-COMPANY->DPT-COMPANY
TEN-PROCESS-LEVEL->DPT-PROCESS-LEVEL
TEN-DEPARTMENT->DPT-DEPARTMENT
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
Hm Proc Level PRSYSTEM Required
When TEN-HM-PROC-LEVEL !=Spaces
TEN-COMPANY->PRS-COMPANY
TEN-HM-PROC-LEVEL->PRS-PROCESS-LEVEL
Job Code JOBCODE Required
When (TEN-JOB-CODE !=Spaces )
TEN-COMPANY->JBC-COMPANY
TEN-JOB-CODE->JBC-JOB-CODE
Paemployee PAEMPLOYEE Required
TEN-COMPANY->PEM-COMPANY
TEN-EMPLOYEE->PEM-EMPLOYEE
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
When TAP-BALANCE-TYPE =2
TEN-COMPANY->TEM-COMPANY
TEN-EMPLOYEE->TEM-EMPLOYEE
TEN-PLAN->TEM-PLAN
TEN-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
TEN-POSITION->TEM-POSITION
Ta Mstr No Pos TAEEMASTER Required
When TAP-BALANCE-TYPE =1
TEN-COMPANY->TEM-COMPANY
TEN-EMPLOYEE->TEM-EMPLOYEE
TEN-PLAN->TEM-PLAN
TEN-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
Spaces->TEM-POSITION


TAENROLL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (TEN-POSITION !=Spaces )
TEN-COMPANY->POS-COMPANY
TEN-POSITION->POS-POSITION
  POS-EFFECT-DATE
Taemptr No Pos TAEMPTRANS
Valid When TAP-BALANCE-TYPE =1
TEN-COMPANY->TTR-COMPANY
TEN-EMPLOYEE->TTR-EMPLOYEE
TEN-PLAN->TTR-PLAN
TEN-EMPLOYEE-GROUP->TTR-EMPLOYEE-GROUP
Spaces->TTR-POSITION
  TTR-DATE
  TTR-SEQ-NBR
Taemptr Pos TAEMPTRANS
Valid When TAP-BALANCE-TYPE =2
TEN-COMPANY->TTR-COMPANY
TEN-EMPLOYEE->TTR-EMPLOYEE
TEN-PLAN->TTR-PLAN
TEN-EMPLOYEE-GROUP->TTR-EMPLOYEE-GROUP
TEN-POSITION->TTR-POSITION
  TTR-DATE
  TTR-SEQ-NBR
Tastructur TASTRUCTUR
TEN-COMPANY->TST-COMPANY
TEN-EMPLOYEE-GROUP->TST-EMPLOYEE-GROUP
TEN-PLAN->TST-PLAN
  TST-BEGIN-DATE
Tatrnsum Nopos TATRANSUM
TEN-COMPANY->TTS-COMPANY
TEN-EMPLOYEE->TTS-EMPLOYEE
TEN-PLAN->TTS-PLAN
TEN-EMPLOYEE-GROUP->TTS-EMPLOYEE-GROUP
Spaces->TTS-POSITION
  TTS-TA-TYPE
  TTS-RESET-DATE
Tatrnsum Pos TATRANSUM
Valid When TAP-BALANCE-TYPE =2
TEN-COMPANY->TTS-COMPANY
TEN-EMPLOYEE->TTS-EMPLOYEE
TEN-PLAN->TTS-PLAN
TEN-EMPLOYEE-GROUP->TTS-EMPLOYEE-GROUP
TEN-POSITION->TTS-POSITION
  TTS-TA-TYPE
  TTS-RESET-DATE

File created: Wed Jun 08 20:50:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.