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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HPDSET1
  1. COMPANY
  2. TYPE
  3. OBJ-ID
  4. EFFECT-DATE
  5. FIELD-KEY
PrimaryHLTM.1, HR00.1, HR01.1, HR06.1, HR15.2, HR15.3, HR206, HR506 +9 more
HPDSET2
  1. TYPE
  2. FIELD-KEY
  3. COMPANY
  4. OBJ-ID
  5. EFFECT-DATE ↓
HR26.2, HR26.3, HR26.4, HR26.5, LT101, LT111, PA04.2, PA04.3 +2 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCODESPRSYSTEMHRPOSFLDSJOBCODEPAPOSITIONHRPOSVALHRHISTORYHRPOSUSD

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (HPD-CURRENCY-CODE != Spaces)
HPD-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
HPD-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
JobcodeJOBCODERequired
HPD-OBJ-ID→JBC-OBJ-ID
PositionPAPOSITIONRequired
HPD-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 DtHRHISTORY
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

Programs

Updated by (12)

Referenced by (13)