HRS_PE_OPR_MGR

(SQL Table)
Index Back

# 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 ER_PE_LAST_N_DAYS Number(3,0) SMALLINT NOT NULL Number used to personalize Recruiting Manager Summary pagelet indicating the number of days up to the current date to include when calculating metrics.
3 ER_PE_INCL_EXT Character(1) VARCHAR2(1) NOT NULL Flag used to personalize Recruiting Manager Summary pagelet indicating whether External Applicants should be included in the metrics.

Y/N Table Edit

Default Value: Y

4 ER_PE_INCL_INT Character(1) VARCHAR2(1) NOT NULL Flag used to personalize Recruiting Manager Summary pagelet indicating whether Internal Applicants should be included in the metrics.

Y/N Table Edit

Default Value: Y

5 ER_PE_HOT_JOBS Character(1) VARCHAR2(1) NOT NULL Flag used to personalize Recruiting Manager Summary pagelet indicating whether to only include Hot Jobs in metrics.

Y/N Table Edit

Default Value: N

6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id