HRPOSUSD

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
HLTM.1 PA103 PA495


UPDATED BY
HR00.1 HR01.1 HR06.1 HR15.2 HR15.3 HR206
HR26.2 HR26.3 HR26.4 HR26.5 HR506 HR515
LT101 PA02.1 PA04.2 PA04.3 PA04.4 PA04.5
PA202 PA302 PA502

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HPD-COMPANY
Element: Company		Numeric 4
Contains the company number.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-TYPE
Element: Type		Alpha 2
Contains a code that describes the class of data to which the user defined attributes are linked.
1 = Position
2 = Job Code
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-OBJ-ID
Element: Obj Id		Numeric 12
Contains the object identifier. It is 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.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-FIELD-KEY
Element: Field Key		Alpha 2
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-EFFECT-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
Contains the effective date for a position.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the end date for a position.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-A-FIELD
Element: Alpha User Fields		Alpha 10
Contains valid user defined alphanumeric values.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-N-FIELD
Element: Numeric User Fields		Signed 11.2
Contains valid user defined numeric values.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-D-FIELD
Element: Date User Fields		Numeric 8 (yyyymmdd)
Contains valid user defined date values.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-USER-ID
Element: User ID		Alpha 10 (Lower Case)
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-CURRENCY-CODE
Element: Currency Code		Alpha 5
If user field contains a currency value, this field contains the currency in which the value is recorded.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company base currency.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502
HPD-BASE-AMOUNT
Element: Base Amt		Signed 15.2
Contains the amount in the company's base currency.
HR15.2 HR15.3
HR515 LT101
PA02.1 PA502


HRPOSUSD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HPDSET1 COMPANY
TYPE
OBJ-ID
EFFECT-DATE
FIELD-KEY
HLTM.1 HR00.1
HR01.1 HR06.1
HR15.2 HR15.3
HR206 HR506
HR515 LT101
PA02.1 PA103
PA202 PA302
PA495 PA502
HPDSET2 TYPE
FIELD-KEY
COMPANY
OBJ-ID
EFFECT-DATE*
HR26.2 HR26.3
HR26.4 HR26.5
LT101 PA04.2
PA04.3 PA04.4
PA04.5


HRPOSUSD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
"1 "->HRP-TYPE
HPD-FIELD-KEY->HRP-FIELD-KEY
Job Data HRPOSFLDS Required
"2"->HRP-TYPE
HPD-FIELD-KEY->HRP-FIELD-KEY
Jobcode JOBCODE Required
HPD-OBJ-ID->JBC-OBJ-ID
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
NAME		 RELATED 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

File created: Thu Jun 09 11:15:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.