HRSUPER

Supervisors

Contains the supervisor code and description as well as the employee number of the individual who is assigned to the supervisor position.

REFERENCED BY
BN145 BN231 BN232 BN234 BN238 BN240
BN245 BN246 BN335 HCDL.1 HCEM.1 HCHP.1
HCSU.1 HAP3.1 HCRE.1 HEP4.1 HHSU.1 HLTM.1
HPOS.1 HPQC.1 HPRS.1 HR15.1 HR155 HR156
HR170 HR207 HR211 HR213 HR217 HR220
HR51.2 HR51.5 HR51.6 HR51.8 HR515 HR52.2
HR52.5 HR52.6 HR54.1 HR55.2 HR70.1 HR93.4
HRS1.1 HRSC.1 HS10.1 HS10.2 HS19.1 HS208
HS703 LT11.5 LT13.5 ZH156 ZH230 ZH500
ZH568 EXLD.1 LP100 LP101 LP251 LP260
LP262 PA103 PA113 PA149 PA16.1 PA20.1
PA202 PA208 PA21.1 PA210 PA212 PA214
PA215 PA216 PA217 PA218 PA22.1 PA220
PA221 PA222 PA223 PA224 PA225 PA227
PA24.1 PA242 PA248 PA249 PA262 PA27.1
PA272 PA290 PA310 PA311 PA315 PA320
PA325 PA330 PA335 PA34.1 PA345 PA35.1
PA350 PA355 PA36.1 PA360 PA370 PA372
PA38.1 PA42.1 PA42.3 PA490 PA520 PA53.1
PA532 PA535 PA54.1 PA59.1 PA590 PA66.2
PA66.3 PA90.1 TR21.1 TR22.1 TR26.1 TR500
ZE532 HS20.1 HS21.1 HS36.1 TM240 TM245
TM470 TM52.1 HRLRD HS12.1 HS12.2 HS13.1
HS13.2 HS15.1 HS52.1 HS52.2 HS22.1 HS22.2
HS22.3


UPDATED BY
BN305 HR07.1 HR11.1 HR11.2 HR11.4 HR28.1
HR507 HR511 LT101 LT111 ZH510 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 PR512 HR00.1 HR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HSU-COMPANY
Element: Company Hr		Numeric 4
HR07.1 HR507
LT101 LT111
PA242
HSU-CODE
Element: Code		Alpha 10
Contains the supervisor code. The supervisor code identifies the supervisor position.
HR07.1 HR507
LT101 LT111
HSU-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the supervisor code description.
HR07.1 HR507
LT101 LT111
PA218
HSU-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number of the individual who holds the supervisor position.
BN305 HR07.1
HR11.1 HR11.2
HR11.4 HR28.1
HR507 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA242 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 PR512
ZH510
HSU-OBJ-ID
Element: Obj Id		Numeric 12
Contains a system-assigned identifier that provides access to data in related files.
HR07.1 HR507
LT101 LT111
HSU-FULL-NAME
Element: Full Name		Derived
HSU-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the date the supervisor code becomes effective.
HR07.1 HR507
LT101 LT111
HSU-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
HR07.1 HR507
LT101 LT111
HSU-SUPER-RPTS-TO
Element: Super Rpts To		Alpha 10
Indicates supervisor to whom this supervisor reports.
HR07.1 HR507
LT101 LT111
HSU-USER1
Element: User1		Alpha 10
Contains information from the first user field.
HR07.1 HR507
LT101 LT111
HSU-USER2
Element: User2		Alpha 10
Contains information from the second supervisor user field.
HR07.1 HR507
LT101 LT111
HSU-USER3
Element: User3		Alpha 10
Contains information from the third user field.
HR07.1 HR507
LT101 LT111
HSU-USER4
Element: User4		Alpha 10
Contains information from the fourth user field.
HR07.1 HR507
LT101 LT111
HSU-USER5
Element: User5		Alpha 10
Contains information from the fifth user field.
HR07.1 HR507
LT101 LT111
HSU-FULL-NAME-SUFF
Element: Full Name Suff		Derived
HSU-FULL-NAME-CND
Element: Full Name Cnd		Derived
HSU-SHORT-NAME-CND
Element: Short Name Cnd		Derived
HSU-LABEL-NAME-1
Element: Label Name 1		Derived
HSU-FULL-NAME-COND
Element: Full Name Cond		Derived
HSU-SHRT-NAME-COND
Element: Shrt Name Cond		Derived
HSU-UPDATED-BY-LTM
Element: Updated By Ltm		Alpha 1

Y = Yes
N = No


HRSUPER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HSUSET1 COMPANY
CODE
...
BN145 BN231
BN232 BN234
BN238 BN240
BN245 BN246
BN305 BN335
HCDL.1 HCEM.1
HCHP.1 HCSU.1
HAP3.1 HCRE.1
HEP4.1 HHSU.1
HLTM.1 HPOS.1
HPQC.1 HPRS.1
HR00.1 HR01.1
HR07.1 HR11.1
HR11.2 HR11.4
HR15.1 HR155
HSUSET2 OBJ-ID
KeyChange
HR93.4
HSUSET3 COMPANY
EMPLOYEE
CODE
KeyChange
HR11.1 HS10.1
HS10.2 HS12.1
HS12.2 HS13.1
HS13.2 HS15.1
HS52.1 HS52.2
PA115 HS22.1
HS22.2 HS22.3
HRLRD
HSUSET4 COMPANY
SUPER-RPTS-TO
CODE
KeyChange, Subset
Where(SUPER-RPTS-TO !=Spaces)
HCSU.1 HR07.1
HR507 HS10.1
HS10.2 LT101
LT111


HRSUPER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
HSU-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When HSU-EMPLOYEE !=Zeroes
HSU-COMPANY->EMP-COMPANY
HSU-EMPLOYEE->EMP-EMPLOYEE
Emstatus EMSTATUS Not Required
Valid When HSU-EMPLOYEE !=Zeroes
HSU-COMPANY->EMS-COMPANY
EMP-EMP-STATUS->EMS-EMP-STATUS
Paemployee PAEMPLOYEE Required
HSU-COMPANY->PEM-COMPANY
HSU-EMPLOYEE->PEM-EMPLOYEE
Parent HRSUPER Not Required
Valid When (HSU-SUPER-RPTS-TO !=Spaces )
HSU-COMPANY->HSU-COMPANY
HSU-SUPER-RPTS-TO->HSU-CODE
User1 PCODES Not Required
Valid When (HSU-USER1 !=Spaces )
"S1"->PCO-TYPE
HSU-USER1->PCO-CODE
User2 PCODES Not Required
Valid When (HSU-USER2 !=Spaces )
"S2"->PCO-TYPE
HSU-USER2->PCO-CODE
User3 PCODES Not Required
Valid When (HSU-USER3 !=Spaces )
"S3"->PCO-TYPE
HSU-USER3->PCO-CODE
User4 PCODES Not Required
Valid When (HSU-USER4 !=Spaces )
"S4"->PCO-TYPE
HSU-USER4->PCO-CODE
User5 PCODES Not Required
Valid When (HSU-USER5 !=Spaces )
"S5"->PCO-TYPE
HSU-USER5->PCO-CODE


HRSUPER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Employees PATHFIND Delete Restricted
HSU-COMPANY->PTF-COMPANY
18->PTF-FLD-NBR
HSU-CODE->PTF-FLD-VALUE
  PTF-EMPLOYEE
  PTF-POS-LEVEL
History HRHISTORY Delete Cascades
HSU-COMPANY->HRH-COMPANY
Zeroes->HRH-EMPLOYEE
HSU-OBJ-ID->HRH-OBJ-ID
  HRH-FLD-NBR
  HRH-BEG-DATE
  HRH-SEQ-NBR
Indirect Emps PATHFIND
HSU-COMPANY->PTF-COMPANY
289->PTF-FLD-NBR
HSU-CODE->PTF-FLD-VALUE
  PTF-EMPLOYEE
  PTF-POS-LEVEL
Requisition PAJOBREQ
HSU-COMPANY->PJR-COMPANY
HSU-CODE->PJR-SUPERVISOR
  PJR-REQUISITION

File created: Thu Jun 09 02:16:22 2016

Home
Contact Us



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