HRPOSUSD – Position User Field Type

System
Human Resources (HR)
Prefix
HPD
Primary key
COMPANY, TYPE, OBJ-ID, EFFECT-DATE, FIELD-KEY
Fields
17
Updated by
12 programs
Referenced by
13 programs

HRPOSUSD is the Position User Field Type table in Lawson Human Resources (prefix HPD). It is indexed by COMPANY, TYPE, OBJ-ID, EFFECT-DATE, FIELD-KEY (HPDSET1); alternate indexes: HPDSET2. It is related 1:1 to CUCODES, PRSYSTEM, HRPOSFLDS, JOBCODE, PAPOSITION and HRPOSVAL and 1:M to HRHISTORY. It is updated by HR00.1, HR01.1, HR06.1, HR15.2, HR15.3, HR506, HR515, LT101 and 4 more and referenced by HLTM.1, HR206, HR26.2, HR26.3, HR26.4, HR26.5, PA04.2, PA04.3 and 5 more. The table has 17 fields, 2 indexes and 9 documented relations.

About HRPOSUSD

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.

Fields (17)

Column = COBOL field name without the HPD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
HPD-COMPANY PK
COMPANY		Numeric 4Contains the company number.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-TYPE PK
TYPE		Alpha 2Contains 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, LT111, PA02.1, PA502
HPD-OBJ-ID PK
OBJ_ID		Numeric 12Contains 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, LT111, PA02.1, PA502
HPD-FIELD-KEY PK
FIELD_KEY		Alpha 2—HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the effective date for a position.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the end date for a position.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-A-FIELD
A_FIELD		Alpha 10Contains valid user defined alphanumeric values.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-N-FIELD
N_FIELD		Signed 11.2Contains valid user defined numeric values.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-D-FIELD
D_FIELD		Numeric 8 (yyyymmdd)Contains valid user defined date values.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-DATE-STAMP
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, LT111, PA02.1, PA502
HPD-TIME-STAMP
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, LT111, PA02.1, PA502
HPD-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5If user field contains a currency value, this field contains the currency in which the value is recorded.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company base currency.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502
HPD-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the amount in the company's base currency.HR15.2, HR15.3, HR515, LT101, LT111, PA02.1, PA502

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HPDSET1COMPANY, TYPE, OBJ-ID, EFFECT-DATE, FIELD-KEYPrimaryHLTM.1, HR00.1, HR01.1, HR06.1, HR15.2, HR15.3, HR206, HR506 +9 more
HPDSET2TYPE, FIELD-KEY, COMPANY, OBJ-ID, EFFECT-DATE*HR26.2, HR26.3, HR26.4, HR26.5, LT101, LT111, PA04.2, PA04.3 +2 more

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (HPD-CURRENCY-CODE != Spaces)HPD-BASE-CURRENCY → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredHPD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (HPD-CURRENCY-CODE != Spaces)HPD-CURRENCY-CODE → CUC-CURRENCY-CODE
Field DataHRPOSFLDSRequired"1 " → HRP-TYPE, HPD-FIELD-KEY → HRP-FIELD-KEY
Job DataHRPOSFLDSRequired"2" → HRP-TYPE, HPD-FIELD-KEY → HRP-FIELD-KEY
JobcodeJOBCODERequiredHPD-OBJ-ID → JBC-OBJ-ID
PositionPAPOSITIONRequiredHPD-COMPANY → POS-COMPANY, HPD-OBJ-ID → POS-OBJ-ID, HPD-EFFECT-DATE → POS-EFFECT-DATE
ValuesHRPOSVALRequiredWhen (HRP-REQ-VALUE = "Y")HPD-TYPE → HVL-TYPE, HPD-FIELD-KEY → HVL-FIELD-KEY, HPD-A-FIELD → HVL-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
Hr Hist DtHRHISTORYHPD-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

Programs

Updated by (12)

Referenced by (13)