|
|
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 HR700 PA02.1 PA302 PA502
HR00.1 HR01.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPD-COMPANY Numeric 4 HR15.2 HR515
Company Contains the company number. PA02.1 PA502
HPD-TYPE Alpha 2 HR15.2 HR515
Type Contains a code that describes the PA02.1 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 PA02.1 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 PA02.1 PA502
HPD-EFFECT-DATE Numeric 8 (yyyymmdd) HR15.2 HR515
Begin Date Contains the effective date for a PA02.1 PA502
position.
HPD-END-DATE Numeric 8 (yyyymmdd) HR15.2 HR515
End Date Contains the end date for a position. PA02.1 PA502
HPD-A-FIELD Alpha 10 HR15.2 HR515
Alpha User Fields Contains valid user defined PA02.1 PA502
alphanumeric values.
HPD-N-FIELD Signed 11.2 HR15.2 HR515
Numeric User Fields Contains valid user defined numeric PA02.1 PA502
values.
HPD-D-FIELD Numeric 8 (yyyymmdd) HR15.2 HR515
Date User Fields Contains valid user defined date values. PA02.1 PA502
HPD-DATE-STAMP Numeric 8 (yyyymmdd) HR15.2 HR515
Date Stamp Contains the server date (month, date, PA02.1 PA502
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, PA02.1 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 PA02.1 PA502
last changed this record.
HPD-CURRENCY-CODE Alpha 5 HR15.2 HR515
Currency Code If user field contains a currency value, HR700 PA02.1
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 HR700 PA02.1
Decimals defined for the currency of the object.
HPD-BASE-CURRENCY Alpha 5 HR15.2 HR515
Base Currency Contains the company base currency. PA02.1
HPD-BASE-ND Numeric 1 HR15.2 HR515
Base Number Of The number of decimal positions defined PA02.1
Decimals for the company base currency.
HPD-BASE-AMOUNT Signed 15.2 HR15.2 HR515
Base Amount Contains the amount in the company's PA02.1
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 PA02.1 PA202
EFFECT-DATE PA302 PA502
FIELD-KEY PBIP.1
HPDSET2 TYPE HR700 PA04.2
FIELD-KEY PA04.3 PA04.4
COMPANY PA04.5
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
HPD-EFFECT-DATE -> HRH-BEG-DATE
HRH-FLD-NBR
HRH-SEQ-NBR
|