 |
Lawson Insight Technical Documentation |
|
HISTERR FILE
Contains history errors moved using HR54.1 (Employee History Correction) and
PA54.1 (Personnel Action History Correction).
REFERENCED BY
HR105 PA105 PA340 HRLO.1 PA67.1 HR701
PA66.1 PA66.2 PA66.3
UPDATED BY
HR11.1 HR11.2 HR125 HR15.1 HR511 HR515
HR54.1 HR650 HRS1.1 HRSC.1 PA02.1 PA100
PA102 PA113 PA125 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PA54.1
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PRSC.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HER-COMPANY Numeric 4 HR11.1 HR11.2
Company The company number represents an HR15.1 HR511
established company and is entered on HR515 HR54.1
all function codes. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-EMPLOYEE Numeric 9 HR11.1 HR11.2
Employee Contains the employee number. Each HR15.1 HR511
person employed by the company is HR515 HR54.1
assigned a unique number. The system HR650 HRS1.1
uses the employee number to correlate HRSC.1 PA02.1
all of the information related to that PA100 PA102
person. PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-OBJ-ID Numeric 12 HR11.1 HR11.2
Object Contains a system-assigned identifier HR15.1 HR511
Identification that provides access to data in related HR515 HR54.1
files. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-EFFECT-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Effective Date Contains the date the item was HR15.1 HR511
originally logged to history. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ACTION-CODE Alpha 10 HR11.1 HR11.2
Action Code This field contains the personnel HR15.1 HR511
action code. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ACTION-NBR Numeric 4 HR11.1 HR11.2
Action Number Contains the personnel action number. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-FLD-NBR Numeric 4 HR11.1 HR11.2
Dictionary Field Contains the PA dictionary field number. HR15.1 HR511
Number HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-SEQ-NBR Numeric 4 HR11.1 HR11.2
Sequence Number An automatically assigned sequence HR15.1 HR511
number. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-REASON Alpha 10 Occurs 2 Times HR11.1 HR11.2
Reason Contains the personnel action reason. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA340
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRSC.1
HER-POS-LEVEL Numeric 2 HR11.1 HR11.2
Pos Level Contains the position level. HR15.1 HR511
01 = Level 1 HR515 HR54.1
02 = Level 2 HR650 HRS1.1
03 = Level 3 HRSC.1 PA02.1
04 = Level 4 PA100 PA102
05 = Level 5 PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ACT-OBJ-ID Numeric 12 HR11.1 HR11.2
Subsystem Activity If the change was done via a personnel HR15.1 HR511
InterfaceID action, this field contains the record HR515 HR54.1
identifier of that action. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-A-VALUE Alpha 30 (Lower Case) HR11.1 HR11.2
A Value Contains alpha data items. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-N-VALUE Signed 13.4 HR11.1 HR11.2
N Value Contains numeric data items. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-D-VALUE Numeric 8 (yyyymmdd) HR11.1 HR11.2
D Value Contains date value data items. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-NEW-VALUE Alpha 30 HR11.1 HR11.2
Field Value After Contains the field value after the HR15.1 HR511
Change personnel action change. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ACTION-TYPE Alpha 1 HR11.1 HR11.2
Action Type This field contains the action type. HR15.1 HR511
A = Hire an Applicant HR515 HR54.1
E = Individual Employee HR650 HRS1.1
M = Mass Change HRSC.1 PA02.1
P = Mass Pay Change PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-DATA-TYPE Alpha 1 HR11.1 HR11.2
Data Type Determines the type of data being HR15.1 HR511
entered and how to edit it. Values are HR515 HR54.1
Date, Alpha, or Numeric. HR650 HRS1.1
E = Emp HRSC.1 PA02.1
A = App PA100 PA102
D = Ded PA113 PA13.1
J = Job PA13.2 PA502
P = Pos PA513 PA52.1
S = Sup PA52.3 PA52.4
T = Time PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ANT-END-DATE Numeric 8 (yyyymmdd) HR11.1 HR11.2
Anticipated Ending Contains the personnel action HR15.1 HR511
Date anticipated end date. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-SALARY-CLASS Alpha 1 HR11.1 HR11.2
Salary Class Contains the salary class. HR15.1 HR511
H = Hourly HR515 HR54.1
S = Salary HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ANNUAL-SALARY Signed 13.4 HR11.1 HR11.2
Annual Salary Contains the annual salary. HR15.1 HR511
HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-DATE-STAMP Numeric 8 (yyyymmdd) HR11.1 HR11.2
Date Stamp This field contains the server date HR15.1 HR511
(month, date, and year) of the last HR515 HR54.1
change to this record. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR11.2
Time Stamp Contains the server time (hour, minute, HR15.1 HR511
and second) when the record was last HR515 HR54.1
changed. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-USER-ID Alpha 10 (Lower Case) HR11.1 HR11.2
User ID Name Contains the user ID of the person who HR15.1 HR511
last changed this record. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-DATE-STAMP2 Numeric 8 (yyyymmdd) HR11.1 HR11.2
Date Stamp2 Contains the date this record was moved HR15.1 HR511
to the history error file. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-TIME-STAMP2 Numeric 6 (hhmmss) HR11.1 HR11.2
Time Stamp2 Contains the time this record was moved HR15.1 HR511
to the history error file. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-USER-ID2 Alpha 10 (Lower Case) HR11.1 HR11.2
User Id2 Contains the User ID of the person who HR15.1 HR511
moved the record to the history error HR515 HR54.1
file. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-CURRENCY-CODE Alpha 5 HR11.1 HR11.2
Currency Code Contains the currency in which the pay HR15.1 HR511
is recorded. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-CURR-ND Numeric 1 HR11.1 HR11.2
Currency Number of Represents the number of decimals HR15.1 HR511
Decimals defined for the currency of the object. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-BASE-CURRENCY Alpha 5 HR11.1 HR11.2
Base Currency Contains the base currency in which the HR15.1 HR511
pay is recorded. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-BASE-ND Numeric 1 HR11.1 HR11.2
Base Number Of The number of decimal positions defined HR15.1 HR511
Decimals for the company base currency. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-BASE-PAY-RATE Signed 13.4 HR11.1 HR11.2
Base Pay Rate Contains the pay in the employee's HR15.1 HR511
base currency. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-ANNUAL-HOURS Numeric 4 HR11.1 HR11.2
Annual Hours Contains the employee's annual hours at HR15.1 HR511
the time of this pay rate history HR515 HR54.1
record. HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HER-NBR-FTE Signed 4.3 HR11.1 HR11.2
Full Time Contains the employee's FTE at the time HR15.1 HR511
Equivalent Number of this pay rate history. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PRSC.1
HISTERR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HERSET1 COMPANY HR105 HR11.1
EMPLOYEE HR125 HR54.1
OBJ-ID PA105 PA115
EFFECT-DATE PA125 PA340
ACTION-CODE PA54.1
ACTION-NBR
FLD-NBR
SEQ-NBR
HERSET2 COMPANY PA125 PA340
ACTION-CODE
EMPLOYEE
OBJ-ID
EFFECT-DATE*
ACTION-NBR*
FLD-NBR
SEQ-NBR
HERSET3 COMPANY HR11.1 HR11.2
EMPLOYEE HR15.1 HR511
OBJ-ID HR515 HR54.1
FLD-NBR HR650 HRLO.1
EFFECT-DATE* HRS1.1 HRSC.1
SEQ-NBR* PA02.1 PA100
ACTION-CODE PA102 PA113
ACTION-NBR PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PA67.1
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
...
HERSET4 COMPANY
EMPLOYEE
OBJ-ID
ACTION-CODE
EFFECT-DATE*
ACTION-NBR*
FLD-NBR
SEQ-NBR
HERSET5 ACT-OBJ-ID Subset HR11.1 HR11.2
FLD-NBR Where (ACT-OBJ-ID != Zeroes ) HR15.1 HR511
SEQ-NBR HR515 HR54.1
HR650 HR701
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA113
PA125 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA66.1 PA66.2
PA66.3 PR110
PR113 PR120
...
HISTERR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Action Code PERSACTYPE Required
When (HER-ACT-OBJ-ID != Zeroes )
HER-COMPANY -> PAT-COMPANY
HER-ACTION-CODE -> PAT-ACTION-CODE
Applicant APPLICANT Required
When (HER-DATA-TYPE = "A" )
HER-COMPANY -> APL-COMPANY
HER-EMPLOYEE -> APL-APPLICANT
Base Currency CUCODES Required
When (HER-CURRENCY-CODE != Spaces )
HER-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
HER-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When (HER-CURRENCY-CODE != Spaces )
HER-CURRENCY-CODE -> CUC-CURRENCY-CODE
Deduction EMDEDMASTR Required
When (HER-DATA-TYPE = "D" )
HER-OBJ-ID -> EDM-OBJ-ID
Employee EMPLOYEE Required
When (HER-DATA-TYPE = "E" )
HER-COMPANY -> EMP-COMPANY
HER-EMPLOYEE -> EMP-EMPLOYEE
Fld Nbr PADICT Required
HER-FLD-NBR -> PAD-FLD-NBR
Job Code JOBCODE Required
When (HER-DATA-TYPE = "J" )
HER-OBJ-ID -> JBC-OBJ-ID
Paemployee PAEMPLOYEE Required
When (HER-DATA-TYPE = "E" )
HER-COMPANY -> PEM-COMPANY
HER-EMPLOYEE -> PEM-EMPLOYEE
Pers Act Hst PERSACTHST Required
When (HER-ACT-OBJ-ID != Zeroes )
HER-ACT-OBJ-ID -> PAH-OBJ-ID
Position PAPOSITION Required
When (HER-DATA-TYPE = "P" )
HER-COMPANY -> POS-COMPANY
HER-OBJ-ID -> POS-OBJ-ID
HER-EFFECT-DATE -> POS-EFFECT-DATE
Reason PCODES Required
When (HER-REASON != Spaces )
"RA" -> PCO-TYPE
HER-REASON -> PCO-CODE
Standard Time STANDTIME Required
When (HER-DATA-TYPE = "T" )
HER-OBJ-ID -> STM-OBJ-ID
Supervisor HRSUPER Required
When (HER-DATA-TYPE = "S" )
HER-OBJ-ID -> HSU-OBJ-ID
HISTERR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments PACOMMENTS
Valid When (HER-ACT-OBJ-ID != Zeroes )
HER-COMPANY -> PAC-COMPANY
Zeroes -> PAC-EMP-APP
"PA" -> PAC-CMT-TYPE
HER-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
HER-ACTION-CODE -> PAC-ACTION-CODE
HER-ACTION-NBR -> PAC-LN-NBR
PAC-SEQ-NBR
|