HRS_LIST_PRFDTL

(SQL Table)
Index Back

Applicant List Item Details

Stores list member details. Used for OFCCP IA compliance reasons.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_LST_ID Number(15,0) DECIMAL(15) NOT NULL List ID
2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
3 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
4 SRCH_SCORE Number(4,0) SMALLINT NOT NULL Search Score
5 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
6 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
7 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
8 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id