HRS_REC_APCRT_I

(SQL View)
 Index Back

Stored Search

Saved stored search criteria.

SELECT A.HRS_OWNER_ID , A.SEARCH_NAME , A.HRS_SEARCH_ID , A.VISIBLE_PROPERTY , A.HRS_SCH_ACTIVE , A.HRS_SCH_TYPE , A.HRS_SCH_ACCESS , A.AUTOMATCH_IND , A.LAST_RUN_DTM , A.HRS_LST_FREEZE , A.CREATED_DTTM , %subrec(HRS_CRIT_SBR, A) , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_SRCH_SAVED A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_OWNER_ID Character(11) VARCHAR2(11) NOT NULL Owner ID
2 SEARCH_NAME Character(20) VARCHAR2(20) NOT NULL Stored Search Name
3 HRS_SEARCH_ID Number(15,0) DECIMAL(15) NOT NULL Search Id counter
4 VISIBLE_PROPERTY Character(1) VARCHAR2(1) NOT NULL Used in SS Framework
5 HRS_SCH_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active Indicator
N=Inactive
Y=Active
6 HRS_SCH_TYPE Character(1) VARCHAR2(1) NOT NULL Search Type
A=Advanced
B=Basic
D=Database
7 HRS_SCH_ACCESS Character(1) VARCHAR2(1) NOT NULL Access
P=Public
V=Private
8 AUTOMATCH_IND Character(1) VARCHAR2(1) NOT NULL Search Automatch Search agent indicator
9 LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On
10 HRS_LST_FREEZE Character(1) VARCHAR2(1) NOT NULL Freeze List
11 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
12 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
13 EXTERNAL_APPL_IND Character(1) VARCHAR2(1) NOT NULL External applicant indicator.

Y/N Table Edit

14 APP_PER_STATUS Character(1) VARCHAR2(1) NOT NULL Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant
E=Employee
N=Non-Employee
15 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
16 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
17 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
18 EMPLOYEE_IND Character(1) VARCHAR2(1) NOT NULL Employee indicator.

Y/N Table Edit

19 NON_EMPLOYEE_IND Character(1) VARCHAR2(1) NOT NULL Non-employee indicator.

Y/N Table Edit

20 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
21 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
22 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
23 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
24 CITY Character(30) VARCHAR2(30) NOT NULL City
25 COUNTRY_DESCR1 Character(30) VARCHAR2(30) NOT NULL Country Description

Prompt Table: HRS_COUNTRY_VW

26 STATE_DESCR1 Character(30) VARCHAR2(30) NOT NULL State Description

Prompt Table: HRS_STATE_I

27 START_DT Date(10) DATE Start Date
28 END_DT Date(10) DATE end date
29 HRS_APPRCV_WTN Character(3) VARCHAR2(3) NOT NULL Application Received within specified timframe
A=Anytime...
D=Within Last Day
M=Within Last Month
W=Within Last Week
Y=Within Last Year
30 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
31 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL SubSource ID
32 RESUME_TEXT_100 Character(100) VARCHAR2(100) NOT NULL Resume Text
33 SRCH_CATEGORY Character(1) VARCHAR2(1) NOT NULL Search Category
A=All Fields Selected
N=Any Field Selected
34 ZONE_ACCOMP Character(100) VARCHAR2(100) NOT NULL Accomplishments
35 ZONE_COMPETENCIES Character(100) VARCHAR2(100) NOT NULL Competencies
36 ZONE_EDUCATION Character(100) VARCHAR2(100) NOT NULL Education
37 ZONE_WORK_EXP Character(100) VARCHAR2(100) NOT NULL Work Experience
38 LAST_ACTIVITY_TIME DateTime(26) TIMESTAMP Last Activity Time
39 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
40 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
41 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
42 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id