HRS_APLC_NJO_VW

(SQL View)
 Index Back

My Applications

Applicant's Applications on Home page

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_PROFILE_SEQ , A.HRS_JOB_OPENING_ID , ' ' , A.HRS_STATUS_DT , A.STATUS_CODE , A.HRS_WITHDRAWN_DTTM , D.DESCR , D.DESCRSHORT , E.HRS_SUBMITTED_DTTM , F.HRS_DRFT_STS_IND , E.HRS_ROW_ADD_DTTM FROM PS_HRS_RCMNT_I A , PS_HRS_STS_REC_I D , PS_HRS_APP_PROFILE E , PS_HRS_STS_TBL F WHERE A.STATUS_CODE=D.STATUS_CODE AND A.HRS_PERSON_ID= E.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = E.HRS_PROFILE_SEQ AND A.HRS_JOB_OPENING_ID = 0 AND A.STATUS_CODE = F.STATUS_CODE AND F.STATUS_AREA = '3' AND A.HRS_LOGICAL_DELETE = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
4 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
5 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
6 STATUS_DT Date(10) DATE NOT NULL Status Date

Default Value: %date

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

Prompt Table: HRS_STS_REC_I

8 HRS_WITHDRAWN_DTTM DateTime(26) TIMESTAMP Date time stamp when the candidate's application was withdrawn.
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
11 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
12 HRS_DRFT_STS_IND Character(1) VARCHAR2(1) NOT NULL Draft Status Indicator
13 HRS_APP_CREATED_DT DateTime(26) TIMESTAMP date application created