HRPOSFLDS

Position User Fields

REFERENCED BY
HLTM.1 HR206 LT10.1 PA103 PA495


UPDATED BY
HR26.2 HR26.3 HR26.4 PA04.2 PA04.3 PA04.4
HR15.2 HR15.3 HR210 HR226 HR50.1 PA02.1
PA202 PA204 PA302 PA502 HR515

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRP-TYPE
Element: Type
Alpha 2
Contains the code that describes the class of data to which the user defined attributes are linked.
1 = Position
2 = Job Code
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-FIELD-KEY
Element: Field Key
Alpha 2
Contains the unique system assigned key to this record.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-FIELD-NAME
Element: Field Name
Alpha 20 (Lower Case)
Contains the user defined name of the data being tracked. This name is unique per Field Key and Type.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-FIELD-TYPE
Element: Field Type
Alpha 1
Contains the type of data associated with this field name.
1 = Alphanumeric
2 = Numeric
3 = Date
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-BEG-NUMBER
Element: Begining Value
Signed 11.2
For numeric field types, contains the lowest value in a defined range of valid values.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-END-NUMBER
Element: End Value
Signed 11.2
For a numeric field type, contains the highest value in a user defined range of valid values.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-BEG-DATE
Element: Beginning Date
Numeric 8 (yyyymmdd)
For date field types, contains the lowest date in the user defined range of valid values.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
For date field types, contains the highest date in the user defined range of valid values.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-REQ-FLAG
Element: Required
Alpha 1
Contains a value which indicates if data must be entered in this field when a record is created. For example, if a field called Succession Plan is flagged as required, then a position record can not be added until a value is entered in the Succession Plan field.
X = Field Always Required
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-REQ-VALUE
Element: Required
Alpha 1
Contains a value that indicates whether a value list must be created for this field name. This field is available only to alphanumeric user fields.
Y = Yes
N = No
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-LOG-FLAG
Element: History
Alpha 1
Contains a value that indicates whether history should be kept for this field name.
X = Log Changes
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
Contains the server date (month, date, and year) of the last change to this record.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-USER-ID
Element: User ID
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-CURRENCY-FLAG
Element: Currency Flag
Alpha 1
Indicates whether user field is a currency field.
N = No
Y = Yes
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4
HRP-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The Active flag indicates if the position user field can be newly added for a current position.
A = Active
I = Inactive
HR26.2 HR26.3
HR26.4 PA04.2
PA04.3 PA04.4


HRPOSFLDS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRPSET1 TYPE
FIELD-KEY
HLTM.1 HR15.2
HR15.3 HR206
HR210 HR226
HR26.2 HR26.3
HR26.4 HR26.5
HR50.1 LT10.1
PA02.1 PA04.2
PA04.3 PA04.4
PA04.5 PA103
PA202 PA204
PA302 PA502
HRPSET2 TYPE
FIELD-TYPE
FIELD-NAME
HR226 HR26.2
HR26.3 HR26.4
HR515 PA04.2
PA04.3 PA04.4
PA204 PA495
HRPSET3 TYPE
REQ-FLAG*
FIELD-NAME
KeyChange
HR15.2 HR15.3
HR26.2 HR26.3
HR26.4 PA02.1
PA04.2 PA04.3
PA04.4 PA302
PA502


HRPOSFLDS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Job Data HRPOSUSD Delete Cascades
"2 "->HPD-TYPE
HRP-FIELD-KEY->HPD-FIELD-KEY
  HPD-COMPANY
  HPD-OBJ-ID
  HPD-EFFECT-DATE
Job Values HRPOSVAL Delete Cascades
Valid When (HRP-TYPE ="2" )
And(HRP-REQ-VALUE ="Y" )
HRP-TYPE->HVL-TYPE
HRP-FIELD-KEY->HVL-FIELD-KEY
  HVL-CODE
Pos Data HRPOSUSD Delete Cascades
"1 "->HPD-TYPE
HRP-FIELD-KEY->HPD-FIELD-KEY
  HPD-COMPANY
  HPD-OBJ-ID
  HPD-EFFECT-DATE
Values HRPOSVAL Delete Cascades
Valid When (HRP-FIELD-TYPE ="1" )
And(HRP-REQ-VALUE ="Y" )
HRP-TYPE->HVL-TYPE
HRP-FIELD-KEY->HVL-FIELD-KEY
  HVL-CODE


File created: Wed Jun 08 20:49:09 2016

Home
Contact Us



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