HRSUPER FILE 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 BN238 BN240 BN245 BN246 BN335 HCEM.1 HCOP.1 HCSU.1 HHSU.1 HR15.1 HR155 HR170 HR207 HR211 HR213 HR54.1 HR55.2 HR70.1 HR700 HRS1.1 HRSC.1 HS10.1 PA149 PA16.1 PA20.1 PA202 PA208 PA21.1 PA212 PA214 PA215 PA216 PA217 PA218 PA22.1 PA220 PA221 PA222 PA224 PA225 PA24.1 PA242 PA248 PA249 PA262 PA272 PA290 PA300 PA305 PA310 PA311 PA315 PA320 PA325 PA330 PA335 PA34.1 PA345 PA35.1 PA350 PA355 PA36.1 PA360 PA370 PA372 PA38.1 PA42.1 PA490 PA520 PA53.1 PA532 PA54.1 PA59.1 PA590 PA66.2 PA66.3 PA90.1 TR21.1 TR22.1 TR500 HS20.1 HS21.1 TM240 TM245 TM470 TM52.1 HS12.1 HS13.1 HS15.1 HS22.1 HS22.2 HC01.1 UPDATED BY HR07.1 HR11.1 HR507 HR511 PA02.1 PA100 PA102 PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR13.1 HR00.1 HR01.1 PBIP.1 PA115 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY HSU-COMPANY Numeric 4 HR07.1 HR507 Company The company number represents an PA242 established company and is entered on all function codes. HSU-CODE Alpha 10 HR07.1 HR507 Code Contains the supervisor code. The supervisor code identifies the supervisor position. HSU-DESCRIPTION Alpha 30 (Lower Case) HR07.1 HR507 Description Contains the supervisor code description. HSU-EMPLOYEE Numeric 9 HR07.1 HR11.1 Employee Contains the employee number of the HR507 HR511 individual who holds the supervisor PA02.1 PA100 position. PA102 PA13.1 PA13.2 PA242 PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR13.1 HSU-OBJ-ID Numeric 12 HR07.1 HR507 Object Contains a system-assigned identifier Identification that provides access to data in related files. HSU-FULL-NAME Derived Full Name HSU-EFFECT-DATE Numeric 8 (yyyymmdd) HR07.1 HR507 Effective Date Contains the date the supervisor code becomes effective. HSU-ACTIVE-FLAG Alpha 1 HR07.1 HR507 Status The Active flag of the credit card type. A = Active I = Inactive HSU-SUPER-RPTS-TO Alpha 10 HR07.1 HR507 Super Rpts To Indicates supervisor to whom this supervisor reports. HSU-USER1 Alpha 10 HR07.1 HR507 User1 Contains information from the first user field. HSU-USER2 Alpha 10 HR07.1 HR507 User2 Contains information from the second supervisor user field. HSU-USER3 Alpha 10 HR07.1 HR507 User3 Contains information from the third user field. HSU-USER4 Alpha 10 HR07.1 HR507 User4 Contains information from the fourth user field. HSU-USER5 Alpha 10 HR07.1 HR507 User5 Contains information from the fifth user field. HSU-FULL-NAME-SUFF Derived Full Name Suff HSU-FULL-NAME-CND Derived Full Name Cnd HRSUPER FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN HSUSET1 COMPANY BN145 BN231 CODE BN232 BN238 BN240 BN245 BN246 BN335 HCEM.1 HCOP.1 HCSU.1 HHSU.1 HR00.1 HR01.1 HR07.1 HR11.1 HR15.1 HR155 HR170 HR207 HR211 HR213 HR507 HR511 HR54.1 HR55.2 HR70.1 HR700 HRS1.1 HRSC.1 ... HSUSET2 OBJ-ID KeyChange HSUSET3 COMPANY KeyChange HS10.1 HS12.1 EMPLOYEE HS13.1 HS15.1 CODE PA115 HS22.1 HS22.2 HSUSET4 COMPANY KeyChange, Subset HC01.1 HCSU.1 SUPER-RPTS-TO Where (SUPER-RPTS-TO != Spaces ) HR07.1 HR507 CODE HS10.1 HRSUPER FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME 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 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 RELATED NAME 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 |