TAENROLL

REFERENCED BY
BN150 HR00.1 HR01.1 HR02.1 HR06.1 HR506
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 ZP530
TA147


UPDATED BY
BN305 HR11.1 HR11.2 HR28.1 HR511 LT101
ZH510 LP100 LP101 LP102 LP103 LP131
LP140 LP180 LP188 LP197 LP231 LP31.1
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 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR30.2

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 LT101
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 LT101
PA100 PA52.4
TEN-PLAN
Element: Ta Plan		Alpha 10
HR11.1 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 LT101
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 LT101
PA100 PA52.4
TEN-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
BN305 HR11.1
HR11.2 HR28.1
HR511 LP100
LP101 LP180
LP32.1 LP32.2
LP32.3 LP80.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 ZH510
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 LT101
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 LT101
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 LT101
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 LT101
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 LT101
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
LT101 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 LT101
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 LT101
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 LT101
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 LT101
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
LT101 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
LT101 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
LT101 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
HR00.1 HR01.1
HR02.1 HR06.1
HR11.1 HR11.2
HR28.1 HR506
HR511 LT101
PR521 ZH510
EXI2.1 EXI4.1
LP100 LP101
LP102 LP103
LP130 LP131
LP140 LP145
LP180 LP188
LP197 LP198
LP231 LP31.1
TENSET2 COMPANY
EMPLOYEE
EMPLOYEE-GROUP
PLAN
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
HR11.1 HR511
LT101 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 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


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: Thu Jun 09 11:19:45 2016

Home
Contact Us



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