C6EMPADDRT

UPDATED BY
BN150 BN66.1 PR521 EXI2.1 EXI4.1 LP130
PR128 PR131 PR132 PR134 PR135 PR136
PR137 PR140 PR189 PR195 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 PR36.4 PR37.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR89.1
PRAT.1 UK102 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAR-COMPANY
Element: Hr Company		Numeric 4
EAR-EMPLOYEE
Element: Employee		Numeric 9
EAR-PAY-CODE
Element: Pay Code		Alpha 4
EAR-EAR-SEQ-NBR
Element: Seq Nbr Ear		Numeric 10
EAR-RATE
Element: Rate		Signed 13.4
EAR-START-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
EAR-END-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
EAR-JOB-CODE
Element: Job Code		Alpha 9
EAR-POSITION
Element: Position		Alpha 12
EAR-NOTIONAL
Element: Notional		Signed 13.4
EAR-SALARY-CLASS
Element: Salary Class		Alpha 1
EAR-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
EAR-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
EAR-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
EAR-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
EAR-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
EAR-USER-ID
Element: User Id		Alpha 10 (Lower Case)


C6EMPADDRT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EARSET1 COMPANY
EMPLOYEE
PAY-CODE
POSITION
JOB-CODE
START-DATE
EAR-SEQ-NBR
EARSET2 COMPANY
EMPLOYEE
PAY-CODE
POSITION
JOB-CODE
START-DATE*
EAR-SEQ-NBR*
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR140
PR189 PR195
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


C6EMPADDRT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Not Required
EAR-COMPANY->EMP-COMPANY
EAR-EMPLOYEE->EMP-EMPLOYEE
Jobcode JOBCODE Not Required
Valid When EAR-JOB-CODE !=Spaces
EAR-COMPANY->JBC-COMPANY
EAR-JOB-CODE->JBC-JOB-CODE
Prpaycode PRPAYCODE Not Required
EAR-COMPANY->PCD-COMPANY
Spaces->PCD-PROCESS-LEVEL
Spaces->PCD-JOB-CODE
EAR-PAY-CODE->PCD-PAY-CODE

File created: Thu Jun 09 02:11:51 2016

Home
Contact Us



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