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 | HR206 | PA103 | PA202 | PA495 | HR26.2 |
HR26.3 | HR26.4 | HR26.5 | PA04.2 | PA04.3 | PA04.4 |
PA04.5 |
HR15.2 | HR15.3 | HR515 | LT101 | LT111 | PA02.1 |
PA302 | PA502 | HR00.1 | HR01.1 | HR06.1 | HR506 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
HPD-COMPANY Element: Company | Numeric 4 Contains the company number. |
|
||||||||
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 |
|
||||||||
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. |
|
||||||||
HPD-FIELD-KEY Element: Field Key | Alpha 2 |
|
||||||||
HPD-EFFECT-DATE Element: Begin Date | Numeric 8 (yyyymmdd) Contains the effective date for a position. |
|
||||||||
HPD-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the end date for a position. |
|
||||||||
HPD-A-FIELD Element: Alpha User Fields | Alpha 10 Contains valid user defined alphanumeric values. |
|
||||||||
HPD-N-FIELD Element: Numeric User Fields | Signed 11.2 Contains valid user defined numeric values. |
|
||||||||
HPD-D-FIELD Element: Date User Fields | Numeric 8 (yyyymmdd) Contains valid user defined date values. |
|
||||||||
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. |
|
||||||||
HPD-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||
HPD-USER-ID Element: User ID | Alpha 10 (Lower Case) |
|
||||||||
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. |
|
||||||||
HPD-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||
HPD-BASE-CURRENCY Element: Base Currency | Alpha 5 Contains the company base currency. |
|
||||||||
HPD-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||
HPD-BASE-AMOUNT Element: Base Amt | Signed 15.2 Contains the amount in the company's base currency. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HPDSET1 |
COMPANY TYPE OBJ-ID EFFECT-DATE FIELD-KEY |
|
| ||||||||||||||||||||||||
HPDSET2 |
TYPE FIELD-KEY COMPANY OBJ-ID EFFECT-DATE* |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Base Currency | CUCODES |
Required
| |||||||||||||||
Company | PRSYSTEM |
Required
| |||||||||||||||
Currency | CUCODES |
Required
| |||||||||||||||
Field Data | HRPOSFLDS |
Required
| |||||||||||||||
Job Data | HRPOSFLDS |
Required
| |||||||||||||||
Jobcode | JOBCODE |
Required
| |||||||||||||||
Position | PAPOSITION |
Required
| |||||||||||||||
Values | HRPOSVAL |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Hr Hist Dt | HRHISTORY |
|
All trademarks and registered trademarks are the property of their
respective owners.