HRS_PE_OPR_MYJO

(SQL Table)
Index Back

My Job Opening Personalization

This record is used to store personalization options for the My Job Openings (9.2) pagelet.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 HRS_JO_SORT_BY Character(3) VARCHAR2(3) NOT NULL Job Opening 360 Sort By Dropdonw list
AC=Jobs Created by Me
ALL=All Jobs
ASN=Jobs Assigned to Me
ASO=Jobs Associated with Me

Default Value: ASN

3 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_JO_I

4 ER_WITHIN_DAYS Character(3) VARCHAR2(3) NOT NULL Applied Within Last
A=010 - Today
B=020 - Yesterday
C=030 - Last 3 Days
D=040 - Last Week
E=050 - Last 2 Weeks
F=060 - Last Month
G=070 - Last Year
V=080 - View All

Default Value: G

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