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 HAP3.1
HCRE.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR15.1
HR155 HR156 HR170 HR211 HR213 HR217
HR220 HR51.2 HR51.5 HR51.6 HR515 HR52.2
HR52.5 HR52.6 HR54.1 HR55.2 HR70.1 HR93.4
HRS1.1 HRSC.1 HS208 HS703 LT11.5 ZH156
ZH230 ZH500 ZH503 ZH568 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 PA535 PA54.1 PA59.1 PA590
PA66.2 PA66.3 PA90.1 TR21.1 TR22.1 TR26.1
TR500 ZE521 ZE531 ZE540 HS36.1 TM240
TM245 TM470 TM52.1 HCHP.1 HS20.1 HS21.1


UPDATED BY
BN305 HCSU.1 HHSU.1 HLTM.1 HR00.1 HR01.1
HR07.1 HR11.1 HR11.2 HR207 HR28.1 HR507
HR511 HS10.1 HS10.2 LT101 ZH510 HS12.1
HS12.2 HS13.1 HS13.2 HS15.1 HS52.1 HS52.2
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA532 ZE532 HS22.1 HS22.2 HS22.3 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR30.2 HRLRD

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HSU-COMPANY
Element: Company Hr		Numeric 4
HR07.1 HR507
LT101 PA242
HSU-CODE
Element: Code		Alpha 10
Contains the supervisor code. The supervisor code identifies the supervisor position.
HR07.1 HR507
LT101
HSU-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the supervisor code description.
HR07.1 HR507
LT101 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
HR28.1 HR507
HR511 LT101
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 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
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
HSU-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
HR07.1 HR507
LT101
HSU-SUPER-RPTS-TO
Element: Super Rpts To		Alpha 10
Indicates supervisor to whom this supervisor reports.
HR07.1 HR507
LT101
HSU-USER1
Element: User1		Alpha 10
Contains information from the first user field.
HR07.1 HR507
LT101
HSU-USER2
Element: User2		Alpha 10
Contains information from the second supervisor user field.
HR07.1 HR507
LT101
HSU-USER3
Element: User3		Alpha 10
Contains information from the third user field.
HR07.1 HR507
LT101
HSU-USER4
Element: User4		Alpha 10
Contains information from the fourth user field.
HR07.1 HR507
LT101
HSU-USER5
Element: User5		Alpha 10
Contains information from the fifth user field.
HR07.1 HR507
LT101
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


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 HR15.1
HR155 HR156
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


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 11:15:01 2016

Home
Contact Us



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