Lawson Insight Technical Documentation |
|
HRSUPER
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 BN234 BN238 BN240
BN245 BN246 BN335 ET700 HCDL.1 HCEM.1
HCHP.1 HCSU.1 HAP3.1 HEP4.1 HHSU.1 HPOS.1
HPQC.1 HPRS.1 HR15.1 HR155 HR170 HR207
HR211 HR213 HR217 HR220 HR515 HR54.1
HR55.2 HR70.1 HRS1.1 HRSC.1 HS10.1 HS10.2
HS208 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 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 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 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HSU-COMPANY Numeric 4 HR07.1 HR507
Element: Company Hr PA242
HSU-CODE Alpha 10 HR07.1 HR507
Element: Code Contains the supervisor code. The
supervisor code identifies the
supervisor position.
HSU-DESCRIPTION Alpha 30 (Lower Case) HR07.1 HR507
Element: Description Contains the supervisor code PA218
description.
HSU-EMPLOYEE Numeric 9 BN305 HR07.1
Element: Employee Contains the employee number of the HR11.1 HR11.2
individual who holds the supervisor HR507 HR511
position. 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
HSU-OBJ-ID Numeric 12 HR07.1 HR507
Element: Obj Id Contains a system-assigned identifier
that provides access to data in related
files.
HSU-FULL-NAME Derived
Element: Full Name
HSU-EFFECT-DATE Numeric 8 (yyyymmdd) HR07.1 HR507
Element: Effect Date Contains the date the supervisor code
becomes effective.
HSU-ACTIVE-FLAG Alpha 1 HR07.1 HR507
Element: Active Flag The Active flag of the credit card
type.
A = Active
I = Inactive
HSU-SUPER-RPTS-TO Alpha 10 HR07.1 HR507
Element: Super Rpts To Indicates supervisor to whom this
supervisor reports.
HSU-USER1 Alpha 10 HR07.1 HR507
Element: User1 Contains information from the first
user field.
HSU-USER2 Alpha 10 HR07.1 HR507
Element: User2 Contains information from the second
supervisor user field.
HSU-USER3 Alpha 10 HR07.1 HR507
Element: User3 Contains information from the third
user field.
HSU-USER4 Alpha 10 HR07.1 HR507
Element: User4 Contains information from the fourth
user field.
HSU-USER5 Alpha 10 HR07.1 HR507
Element: User5 Contains information from the fifth
user field.
HSU-FULL-NAME-SUFF Derived
Element: Full Name Suff
HSU-FULL-NAME-CND Derived
Element: Full Name Cnd
HSU-SHORT-NAME-CND Derived
Element: Short Name Cnd
HSU-LABEL-NAME-1 Derived
Element: Label Name 1
HSU-FULL-NAME-COND Derived
Element: Full Name Cond
HSU-SHRT-NAME-COND Derived
Element: Shrt Name Cond
HRSUPER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HSUSET1 COMPANY BN145 BN231
CODE BN232 BN234
BN238 BN240
BN245 BN246
BN305 BN335
ET700 HCDL.1
HCEM.1 HCHP.1
HCSU.1 HAP3.1
HEP4.1 HHSU.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR07.1
HR11.1 HR11.2
HR15.1 HR155
HR170 HR207
...
HSUSET2 OBJ-ID KeyChange
HSUSET3 COMPANY KeyChange HR11.1 HS10.1
EMPLOYEE HS10.2 HS12.1
CODE HS12.2 HS13.1
HS13.2 HS15.1
HS52.1 HS52.2
PA115 HS22.1
HS22.2 HS22.3
HRLRD
HSUSET4 COMPANY KeyChange, Subset HCSU.1 HR07.1
SUPER-RPTS-TO Where (SUPER-RPTS-TO != Spaces ) HR507 HS10.1
CODE 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
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 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
Requisition PAJOBREQ
HSU-COMPANY -> PJR-COMPANY
HSU-CODE -> PJR-SUPERVISOR
PJR-REQUISITION
|