 |
Lawson Insight Technical Documentation |
|
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
AC550 AC551 BN145 BN231 BN232 BN238
BN240 BN245 BN246 BN335 HCEM.1 HCOP.1
HCSU.1 HHSU.1 HR15.1 HR155 HR170 HR207
HR211 HR213 HR217 HR220 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 HS10.1 HS10.2 PA149
PA16.1 PA202 PA208 PA212 PA214 PA215
PA216 PA217 PA218 PA220 PA221 PA222
PA224 PA225 PA242 PA248 PA249 PA262
PA272 PA290 PA300 PA305 PA310 PA311
PA315 PA320 PA325 PA330 PA335 PA345
PA350 PA355 PA360 PA370 PA372 PA42.1
PA490 PA53.1 PA532 PA54.1 PA59.1 PA590
PA66.2 PA66.3 PA90.1 TR22.1 TR500 HS20.1
HS21.1 HS36.1 TM240 TM245 TM470 TM52.1
HS12.1 HS13.1 HS15.1 HS52.1 HS52.2 HS22.1
HS22.2 HC01.1
UPDATED BY
HR07.1 HR507 HR511 HR650 PA502 PA513
PR13.1 PR13.5 PR13.6 PR13.8 HR00.1 HR01.1
PR197
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 PA218
description.
HSU-EMPLOYEE Numeric 9 HR07.1 HR507
Employee Contains the employee number of the HR511 HR650
individual who holds the supervisor PA242 PA502
position. PA513 PR13.1
PR13.5 PR13.6
PR13.8
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
HSU-SHORT-NAME-CND Derived
Short Name Cnd
HSU-LABEL-NAME-1 Derived
Label Name 1
HRSUPER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HSUSET1 COMPANY AC550 AC551
CODE BN145 BN231
BN232 BN238
BN240 BN245
BN246 BN335
HCEM.1 HCOP.1
HCSU.1 HHSU.1
HR00.1 HR01.1
HR07.1 HR15.1
HR155 HR170
HR207 HR211
HR213 HR217
HR220 HR507
HR511 HR54.1
HR55.2 HR650
...
HSUSET2 OBJ-ID KeyChange
HSUSET3 COMPANY KeyChange HS10.1 HS10.2
EMPLOYEE HS12.1 HS13.1
CODE HS15.1 HS52.1
HS52.2 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 HS10.2
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
|