HRPOSFLDS FILE
Position User Fields
REFERENCED BY
HR15.2 HR210 PA202 PA204 PA302 HR515
PA02.1 PA502
UPDATED BY
PA04.2 PA04.3 PA04.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
HRP-TYPE Alpha 2 PA04.2 PA04.3
Type Contains the code that describes the PA04.4
class of data to which the user defined
attributes are linked.
1 = Position
HRP-FIELD-KEY Alpha 2 PA04.2 PA04.3
Field Key Contains the unique system assigned key PA04.4
to this record.
HRP-FIELD-NAME Alpha 20 (Lower Case) PA04.2 PA04.3
Field Name Contains the user defined name of the PA04.4
data being tracked. This name is unique
per Field Key and Type.
HRP-FIELD-TYPE Alpha 1 PA04.2 PA04.3
Field Type Contains the type of data associated PA04.4
with this field name.
1 = Alphanumeric
2 = Numeric
3 = Date
HRP-BEG-NUMBER Signed 11.2 PA04.2 PA04.3
Begining Value For numeric field types, contains the PA04.4
lowest value in a defined range of valid
values.
HRP-END-NUMBER Signed 11.2 PA04.2 PA04.3
End Value For a numeric field type, contains the PA04.4
highest value in a user defined range of
valid values.
HRP-BEG-DATE Numeric 8 (yyyymmdd) PA04.2 PA04.3
Beginning Date For date field types, contains the PA04.4
lowest date in the user defined range of
valid values.
HRP-END-DATE Numeric 8 (yyyymmdd) PA04.2 PA04.3
End Date For date field types, contains the PA04.4
highest date in the user defined range
of valid values.
HRP-REQ-FLAG Alpha 1 PA04.2 PA04.3
Required Contains a value which indicates if PA04.4
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
HRP-REQ-VALUE Alpha 1 PA04.2 PA04.3
Required Contains a value that indicates whether PA04.4
a value list must be created for this
field name. This field is available only
to alphanumeric user fields.
Y = Yes
N = No
HRP-LOG-FLAG Alpha 1 PA04.2 PA04.3
History Contains a value that indicates whether PA04.4
history should be kept for this field
name.
X = Log Changes
HRP-DATE-STAMP Numeric 8 (yyyymmdd) PA04.2 PA04.3
Date Stamp Contains the server date (month, date, PA04.4
and year) of the last change to this
record.
HRP-TIME-STAMP Numeric 6 (hhmmss) PA04.2 PA04.3
Time Stamp Contains the server time (hour, minute, PA04.4
and second) when the record was last
changed.
HRP-USER-ID Alpha 10 (Lower Case) PA04.2 PA04.3
User ID Contains the user ID of the person who PA04.4
last changed this record.
HRP-CURRENCY-FLAG Alpha 1 PA04.2 PA04.3
Currency Flag Indicates whether user field is a PA04.4
currency field.
N = No
Y = Yes
HRP-ACTIVE-FLAG Alpha 1
Status The Active flag indicates if the
position user field can be newly added
for a current position.
A = Active
I = Inactive
HRPOSFLDS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
HRPSET1 TYPE HR15.2 HR210
FIELD-KEY PA04.2 PA04.3
PA04.4 PA04.5
PA202 PA204
PA302
HRPSET2 TYPE HR515 PA04.2
FIELD-TYPE PA04.3 PA04.4
FIELD-NAME PA204
HRPSET3 TYPE KeyChange HR15.2 PA02.1
REQ-FLAG* PA04.2 PA04.3
FIELD-NAME PA04.4 PA302
PA502
HRPOSFLDS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
