HRS_PSN

(SQL View)
 Index Back

Job Requis-Applicants for Posn

The POSN_APP_JOBREQ view sorts applicants by job requisition and then job code (position applied for). This data is used primarily in Recruitment. You can create multiple POSN_APP_JOBREQ records for an applicant.

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT FROM PS_HRS_RCMNT A WHERE EXISTS ( SELECT 'X' FROM PS_HRS_INT_EVAL D WHERE D.HRS_PERSON_ID =A.HRS_PERSON_ID AND D.HRS_RCMNT_ID = A.HRS_RCMNT_ID AND D.HRS_SUBMITTED = 'Y')

  • Parent record: HRS_JOB_OPENING

    • # 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_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    4 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

    5 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_REC_I

    6 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field