 |
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
HR125 HR15.1 HR511 HR515 HR54.1 HR650
HRS1.1 HRSC.1 PA113 PA125 PA502 PA513
PA54.1 PR13.1 PR13.5 PR13.6 PR13.8
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HER-COMPANY Numeric 4 HR15.1 HR511
Company The company number represents an HR515 HR54.1
established company and is entered on HR650 HRS1.1
all function codes. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-EMPLOYEE Numeric 9 HR15.1 HR511
Employee Contains the employee number. Each HR515 HR54.1
person employed by the company is HR650 HRS1.1
assigned a unique number. The system HRSC.1 PA113
uses the employee number to correlate PA502 PA513
all of the information related to that PA54.1 PR13.1
person. PR13.5 PR13.6
PR13.8
HER-OBJ-ID Numeric 12 HR15.1 HR511
Object Contains a system-assigned identifier HR515 HR54.1
Identification that provides access to data in related HR650 HRS1.1
files. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-EFFECT-DATE Numeric 8 (yyyymmdd) HR15.1 HR511
Effective Date Contains the date the item was HR515 HR54.1
originally logged to history. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-ACTION-CODE Alpha 10 HR15.1 HR511
Action Code This field contains the personnel HR515 HR54.1
action code. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-ACTION-NBR Numeric 4 HR15.1 HR511
Action Number Contains the personnel action number. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-FLD-NBR Numeric 4 HR15.1 HR511
Dictionary Field Contains the PA dictionary field number. HR515 HR54.1
Number HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-SEQ-NBR Numeric 4 HR15.1 HR511
Sequence Number An automatically assigned sequence HR515 HR54.1
number. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-REASON Alpha 10 Occurs 2 Times HR15.1 HR511
Reason Contains the personnel action reason. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA113
PA340 PA502
PA513 PA54.1
PR13.1 PR13.5
PR13.6 PR13.8
HER-POS-LEVEL Numeric 2 HR15.1 HR511
Pos Level Contains the position level. HR515 HR54.1
01 = Level 1 HR650 HRS1.1
02 = Level 2 HRSC.1 PA113
03 = Level 3 PA502 PA513
04 = Level 4 PA54.1 PR13.1
05 = Level 5 PR13.5 PR13.6
PR13.8
HER-ACT-OBJ-ID Numeric 12 HR15.1 HR511
Subsystem Activity If the change was done via a personnel HR515 HR54.1
InterfaceID action, this field contains the record HR650 HRS1.1
identifier of that action. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-A-VALUE Alpha 30 (Lower Case) HR15.1 HR511
A Value Contains alpha data items. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-N-VALUE Signed 13.4 HR15.1 HR511
N Value Contains numeric data items. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-D-VALUE Numeric 8 (yyyymmdd) HR15.1 HR511
D Value Contains date value data items. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-NEW-VALUE Alpha 30 HR15.1 HR511
Field Value After Contains the field value after the HR515 HR54.1
Change personnel action change. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-ACTION-TYPE Alpha 1 HR15.1 HR511
Action Type This field contains the action type. HR515 HR54.1
A = Hire an Applicant HR650 HRS1.1
E = Individual Employee HRSC.1 PA113
M = Mass Change PA502 PA513
P = Mass Pay Change PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-DATA-TYPE Alpha 1 HR15.1 HR511
Data Type Determines the type of data being HR515 HR54.1
entered and how to edit it. Values are HR650 HRS1.1
Date, Alpha, or Numeric. HRSC.1 PA113
E = Emp PA502 PA513
A = App PA54.1 PR13.1
D = Ded PR13.5 PR13.6
J = Job PR13.8
P = Pos
S = Sup
T = Time
HER-ANT-END-DATE Numeric 8 (yyyymmdd) HR15.1 HR511
Anticipated Ending Contains the personnel action HR515 HR54.1
Date anticipated end date. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-SALARY-CLASS Alpha 1 HR15.1 HR511
Salary Class Contains the salary class. HR515 HR54.1
H = Hourly HR650 HRS1.1
S = Salary HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-ANNUAL-SALARY Signed 13.4 HR15.1 HR511
Annual Salary Contains the annual salary. HR515 HR54.1
HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-DATE-STAMP Numeric 8 (yyyymmdd) HR15.1 HR511
Date Stamp This field contains the server date HR515 HR54.1
(month, date, and year) of the last HR650 HRS1.1
change to this record. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-TIME-STAMP Numeric 6 (hhmmss) HR15.1 HR511
Time Stamp Contains the server time (hour, minute, HR515 HR54.1
and second) when the record was last HR650 HRS1.1
changed. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-USER-ID Alpha 10 (Lower Case) HR15.1 HR511
User ID Name Contains the user ID of the person who HR515 HR54.1
last changed this record. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-DATE-STAMP2 Numeric 8 (yyyymmdd) HR15.1 HR511
Date Stamp2 Contains the date this record was moved HR515 HR54.1
to the history error file. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-TIME-STAMP2 Numeric 6 (hhmmss) HR15.1 HR511
Time Stamp2 Contains the time this record was moved HR515 HR54.1
to the history error file. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-USER-ID2 Alpha 10 (Lower Case) HR15.1 HR511
User Id2 Contains the User ID of the person who HR515 HR54.1
moved the record to the history error HR650 HRS1.1
file. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-CURRENCY-CODE Alpha 5 HR15.1 HR511
Currency Code Contains the currency in which the pay HR515 HR54.1
is recorded. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-CURR-ND Numeric 1 HR15.1 HR511
Currency Number of Represents the number of decimals HR515 HR54.1
Decimals defined for the currency of the object. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-BASE-CURRENCY Alpha 5 HR15.1 HR511
Base Currency Contains the base currency in which the HR515 HR54.1
pay is recorded. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-BASE-ND Numeric 1 HR15.1 HR511
Base Number Of The number of decimal positions defined HR515 HR54.1
Decimals for the company base currency. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-BASE-PAY-RATE Signed 13.4 HR15.1 HR511
Base Pay Rate Contains the pay in the employee's HR515 HR54.1
base currency. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-ANNUAL-HOURS Numeric 4 HR15.1 HR511
Annual Hours Contains the employee's annual hours at HR515 HR54.1
the time of this pay rate history HR650 HRS1.1
record. HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HER-NBR-FTE Signed 4.3 HR15.1 HR511
Full Time Contains the employee's FTE at the time HR515 HR54.1
Equivalent Number of this pay rate history. HR650 HRS1.1
HRSC.1 PA113
PA502 PA513
PA54.1 PR13.1
PR13.5 PR13.6
PR13.8
HISTERR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HERSET1 COMPANY HR105 HR125
EMPLOYEE HR54.1 PA105
OBJ-ID PA125 PA340
EFFECT-DATE PA54.1
ACTION-CODE
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 HR15.1 HR511
EMPLOYEE HR515 HR54.1
OBJ-ID HR650 HRLO.1
FLD-NBR HRS1.1 HRSC.1
EFFECT-DATE* PA113 PA502
SEQ-NBR* PA513 PA54.1
ACTION-CODE PA67.1 PR13.1
ACTION-NBR PR13.5 PR13.6
PR13.8
HERSET4 COMPANY
EMPLOYEE
OBJ-ID
ACTION-CODE
EFFECT-DATE*
ACTION-NBR*
FLD-NBR
SEQ-NBR
HERSET5 ACT-OBJ-ID Subset HR15.1 HR511
FLD-NBR Where (ACT-OBJ-ID != Zeroes ) HR515 HR54.1
SEQ-NBR HR650 HR701
HRS1.1 HRSC.1
PA113 PA125
PA502 PA513
PA54.1 PA66.1
PA66.2 PA66.3
PR13.1 PR13.5
PR13.6 PR13.8
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
|