|
|
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
PA103 PA202 PA495 PA04.2 PA04.3 PA04.4
PA04.5
UPDATED BY
HR15.2 HR515 PA02.1 PA302 PA502 HR00.1
HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPD-COMPANY Numeric 4 HR15.2 HR515
Element: Company Contains the company number. PA02.1 PA502
HPD-TYPE Alpha 2 HR15.2 HR515
Element: 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
Element: Obj Id Contains the object identifier. It is PA02.1 PA502
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
Element: Field Key PA02.1 PA502
HPD-EFFECT-DATE Numeric 8 (yyyymmdd) HR15.2 HR515
Element: Begin Date Contains the effective date for a PA02.1 PA502
position.
HPD-END-DATE Numeric 8 (yyyymmdd) HR15.2 HR515
Element: End Date Contains the end date for a position. PA02.1 PA502
HPD-A-FIELD Alpha 10 HR15.2 HR515
Element: Alpha User FieContains valid user defined PA02.1 PA502
alphanumeric values.
HPD-N-FIELD Signed 11.2 HR15.2 HR515
Element: Numeric User FContains valid user defined numeric PA02.1 PA502
values.
HPD-D-FIELD Numeric 8 (yyyymmdd) HR15.2 HR515
Element: Date User FielContains valid user defined date values. PA02.1 PA502
HPD-DATE-STAMP Numeric 8 (yyyymmdd) HR15.2 HR515
Element: Date Stamp This field contains the server date PA02.1 PA502
(month, date, and year) of the last
change to this record.
HPD-TIME-STAMP Numeric 6 (hhmmss) HR15.2 HR515
Element: 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
Element: User ID PA02.1 PA502
HPD-CURRENCY-CODE Alpha 5 HR15.2 HR515
Element: Currency Code If user field contains a currency PA02.1 PA502
value, this field contains the currency
in which the value is recorded.
HPD-CURR-ND Numeric 1 HR15.2 HR515
Element: Acct Nd The number of decimals assigned to a PA02.1 PA502
particular account as determined by the
account currency.
HPD-BASE-CURRENCY Alpha 5 HR15.2 HR515
Element: Base Currency Contains the company base currency. PA02.1 PA502
HPD-BASE-ND Numeric 1 HR15.2 HR515
Element: Base Nd The number of decimal positions defined PA02.1 PA502
for the company base currency.
HPD-BASE-AMOUNT Signed 15.2 HR15.2 HR515
Element: Base Amt Contains the amount in the company's PA02.1 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 PA02.1 PA103
EFFECT-DATE PA202 PA302
FIELD-KEY PA495 PA502
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 (HRP-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
|
