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
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 HR51.8
HR515 HR54.1 HR55.2 HR70.1 HR93.4 HRS1.1
HRSC.1 HS208 HS703 XH700 XH777 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 HS20.1 HS21.1 HS36.1 TM240
TM245 TM470 TM52.1


UPDATED BY
BN305 HR07.1 HR11.1 HR11.2 HR507 HR511
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 HCSU.1 HHSU.1 HLTM.1 HR00.1
HR01.1 HR207 HS10.1 HS10.2 PA532 HRLRD
HS12.1 HS12.2 HS13.1 HS13.2 HS15.1 HS52.1
HS52.2 HS22.1 HS22.2 HS22.3

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HSU-COMPANY
Element: Company Hr		Numeric 4
HR07.1 HR507
PA242 XH700
XH777
HSU-CODE
Element: Code		Alpha 10
Contains the supervisor code. The supervisor code identifies the supervisor position.
HR07.1 HR507
HSU-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the supervisor code description.
HR07.1 HR507
PA218 XH700
XH777
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
HR507 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA242 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 XH700
XH777
HSU-OBJ-ID
Element: Obj Id		Numeric 12
Contains a system-assigned identifier that provides access to data in related files.
HR07.1 HR507
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
HSU-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
HR07.1 HR507
HSU-SUPER-RPTS-TO
Element: Super Rpts To		Alpha 10
Indicates supervisor to whom this supervisor reports.
HR07.1 HR507
HSU-USER1
Element: User1		Alpha 10
Contains information from the first user field.
HR07.1 HR507
HSU-USER2
Element: User2		Alpha 10
Contains information from the second supervisor user field.
HR07.1 HR507
HSU-USER3
Element: User3		Alpha 10
Contains information from the third user field.
HR07.1 HR507
HSU-USER4
Element: User4		Alpha 10
Contains information from the fourth user field.
HR07.1 HR507
HSU-USER5
Element: User5		Alpha 10
Contains information from the fifth user field.
HR07.1 HR507
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


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: Wed Jun 08 20:49:09 2016

Home
Contact Us



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