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