HRS_JO_APP_A_VW

(SQL View)
 Index Back

Position Applied For - Max Req

Maximum app dt for position applied for record for an applicant for each requisition.

SELECT A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_PROFILE_SEQ ,SEC.OPRID ,AP.HRS_RESUME_ID ,A.ENTRY_DATE ,A.STATUS_REASON ,B.DESCRSHORT ,A.HRS_STATUS_DT ,B.STATUS_PHASE ,NM.LAST_NAME ,SEC.APP_PER_STATUS ,A.HRS_ROW_UPD_DTTM FROM PS_HRS_RCMNT_I A LEFT OUTER JOIN PS_HRS_APP_PROFILE AP ON (A.HRS_PROFILE_SEQ = AP.HRS_PROFILE_SEQ AND A.HRS_PERSON_ID = AP.HRS_PERSON_ID) , PS_HRS_STS_REC_I B , PS_HRS_APP_SEC_VW SEC , PS_HRS_APP_NAME_I NM WHERE A.HRS_PERSON_ID = SEC.HRS_PERSON_ID AND A.HRS_PERSON_ID = NM.HRS_PERSON_ID AND A.STATUS_CODE = B.STATUS_CODE AND A.STATUS_CODE NOT IN ( SELECT STATUS_CODE FROM PS_HRS_STS_REC_I WHERE STATUS_AREA = '3' AND HRS_DRFT_STS_IND = 'Y')

  • Related Language Record: HRS_JO_APP_LN_I

  • Parent record: HRS_APP_PROFILE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    2 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_JO_I

    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    5 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    7 HRS_RESUME_ID Number(15,0) DECIMAL(15) NOT NULL Resume id
    8 ENTRY_DATE Date(10) DATE Date Entered

    Default Value: %date

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

    Prompt Table: HRS_RSN_JO_I

    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    11 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
    12 STATUS_PHASE Character(1) VARCHAR2(1) NOT NULL Identifies a phase within a status area.
    1=1-Review
    2=2-Applied
    3=3-Screen
    4=4-Route
    5=5-Interview
    6=6-Offer
    7=7-Hire
    8=8-Reject
    13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    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 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime