HRS_APP_NO_STS

(SQL View)
 Index Back

Applicant View

This view is used to join APPLICANT, APPL_DATA_EFFDT, and APPLICANT_DATA, for the primary record in Applicant Activity. It is also used in the APPL_SRCH_GBL.

SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.HRS_SUBMITTED_DTTM ,B.NAME ,B.LAST_NAME_SRCH ,B.NAME_AC ,C.APP_PER_STATUS ,C.STATUS_CODE ,C.EMPLID FROM PS_HRS_APP_PROFILE A , PS_HRS_APP_NAMES B , PS_HRS_APPLICANT C WHERE C.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.HRS_PERSON_ID = A.HRS_PERSON_ID

  • Parent record: HRS_APPLICANT

    • # 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_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    6 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    7 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
    8 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_APP_VW

    9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON