HRPOSUSD FILE
Position User Field Type
Contains user defined fields that have been established for tables other than
the applicant and employee. This file also holds the system-assigned 2-digit
code which identifies the class of data to which the user fields are linked
and the type of data associated with the user field, such as alpha, date, or
numeric.
REFERENCED BY
PA202 PA04.2 PA04.3 PA04.4 PA04.5
UPDATED BY
HR15.2 HR515 PA302 PA502 HR00.1 HR01.1
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPD-COMPANY Numeric 4 HR15.2 HR515
Company Contains the company number. PA502
HPD-TYPE Alpha 2 HR15.2 HR515
Type Contains a code that describes the PA502
class of data to which the user defined
attributes are linked.
1 = Position
HPD-OBJ-ID Numeric 12 HR15.2 HR515
Object Contains the object identifier. It is PA502
Identification used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
HPD-FIELD-KEY Alpha 2 HR15.2 HR515
Field Key PA502
HPD-EFFECT-DATE Numeric 8 (yyyymmdd) HR15.2 HR515
Begin Date Contains the effective date for a PA502
position.
HPD-END-DATE Numeric 8 (yyyymmdd) HR15.2 HR515
End Date Contains the end date for a position. PA502
HPD-A-FIELD Alpha 10 HR15.2 HR515
Alpha User Fields Contains valid user defined PA502
alphanumeric values.
HPD-N-FIELD Signed 11.2 HR15.2 HR515
Numeric User Fields Contains valid user defined numeric PA502
values.
HPD-D-FIELD Numeric 8 (yyyymmdd) HR15.2 HR515
Date User Fields Contains valid user defined date values. PA502
HPD-DATE-STAMP Numeric 8 (yyyymmdd) HR15.2 HR515
Date Stamp This field contains the server date PA502
(month, date, and year) of the last
change to this record.
HPD-TIME-STAMP Numeric 6 (hhmmss) HR15.2 HR515
Time Stamp Contains the server time (hour, minute, PA502
and second) when the record was last
changed.
HPD-USER-ID Alpha 10 (Lower Case) HR15.2 HR515
User ID Contains the user ID of the person who PA502
last changed this record.
HPD-CURRENCY-CODE Alpha 5 HR15.2 HR515
Currency Code If user field contains a currency PA502
value, this field contains the currency
in which the value is recorded.
HPD-CURR-ND Numeric 1 HR15.2 HR515
Currency Number of Represents the number of decimals PA502
Decimals defined for the currency of the object.
HPD-BASE-CURRENCY Alpha 5 HR15.2 HR515
Base Currency Contains the company base currency. PA502
HPD-BASE-ND Numeric 1 HR15.2 HR515
Base Number Of The number of decimal positions defined PA502
Decimals for the company base currency.
HPD-BASE-AMOUNT Signed 15.2 HR15.2 HR515
Base Amount Contains the amount in the company's PA502
base currency.
HRPOSUSD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HPDSET1 COMPANY HR00.1 HR01.1
TYPE HR15.2 HR515
OBJ-ID PA202 PA302
EFFECT-DATE PA502 PR197
FIELD-KEY
HPDSET2 TYPE PA04.2 PA04.3
FIELD-KEY PA04.4 PA04.5
COMPANY
OBJ-ID
EFFECT-DATE*
HRPOSUSD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When (HPD-CURRENCY-CODE != Spaces )
HPD-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
HPD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When (HPD-CURRENCY-CODE != Spaces )
HPD-CURRENCY-CODE -> CUC-CURRENCY-CODE
Field Data HRPOSFLDS Required
HPD-TYPE -> HRP-TYPE
HPD-FIELD-KEY -> HRP-FIELD-KEY
Position PAPOSITION Required
HPD-COMPANY -> POS-COMPANY
HPD-OBJ-ID -> POS-OBJ-ID
HPD-EFFECT-DATE -> POS-EFFECT-DATE
Values HRPOSVAL Required
When (HPD-REQ-VALUE = "Y" )
HPD-TYPE -> HVL-TYPE
HPD-FIELD-KEY -> HVL-FIELD-KEY
HPD-A-FIELD -> HVL-CODE
HRPOSUSD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Hr Hist Dt HRHISTORY
HPD-COMPANY -> HRH-COMPANY
Zeroes -> HRH-EMPLOYEE
HPD-OBJ-ID -> HRH-OBJ-ID
Zeroes -> HRH-POS-LEVEL
HPD-EFFECT-DATE -> HRH-BEG-DATE
HRH-FLD-NBR
HRH-SEQ-NBR
|
