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 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 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 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
PRSC.1 TM240 TM245 TM470 TM52.1 HRLRD
HS12.1 HS13.1 HS15.1 HS52.1 HS52.2 HS22.1
HS22.2 HS22.3
UPDATED BY
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 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HSU-COMPANY Numeric 4 HR07.1 HR507
Element: Company Hr Identifies the AP company if the PA242
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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 HR07.1 HR11.1
Element: Employee Contains the employee number of the HR11.2 HR507
individual who holds the supervisor HR511 PA02.1
position. 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
Object Contains a system-assigned identifier
Identification 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: Effective DateContains the date the supervisor code
becomes effective.
HSU-ACTIVE-FLAG Alpha 1 HR07.1 HR507
Element: Status 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
BN335 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
HR211 HR213
...
HSUSET2 OBJ-ID KeyChange
HSUSET3 COMPANY KeyChange HR11.1 HS10.1
EMPLOYEE HS10.2 HS12.1
CODE HS13.1 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
|