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
AC550 AC551 BN145 BN231 BN232 BN238
BN240 BN245 BN246 BN335 HCEM.1 HCOP.1
HCOP.2 HCSU.1 HGLM.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 ZR651
PA113 PA149 PA16.1 PA20.1 PA202 PA208
PA21.1 PA212 PA214 PA215 PA216 PA217
PA218 PA22.1 PA220 PA221 PA222 PA224
PA225 PA227 PA24.1 PA242 PA248 PA249
PA262 PA27.1 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
TR26.1 TR500 HS20.1 HS21.1 HS36.1 PRSC.1
TM240 TM245 TM470 TM52.1 FCLRD HRLRD
HS12.1 HS13.1 HS15.1 HS52.1 HS52.2 HS22.1
HS22.2 HS22.3 HC01.1
UPDATED BY
HR07.1 HR11.1 HR11.2 HR507 HR511 HR650
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 The company number represents an PA242
established company and is entered on
all function codes.
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 HR650
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
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: Date Contains 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 AC550 AC551
CODE BN145 BN231
BN232 BN238
BN240 BN245
BN246 BN335
HCEM.1 HCOP.1
HCOP.2 HCSU.1
HGLM.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
FCLRD HRLRD
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
Requisition PAJOBREQ
HSU-COMPANY -> PJR-COMPANY
HSU-CODE -> PJR-SUPERVISOR
PJR-REQUISITION
|