HRS_APP_INFO_I

(SQL View)
 Index Back

Person - Applicant Info

Person - Applicant Info.

SELECT A.EMPLID , A.EFFDT , A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , B.APPLID , %DatePart(C.HRS_SUBMITTED_DTTM) , D.HRS_SOURCE_ID , D.HRS_SUBSOURCE_ID , D.SPECIFIC_REFER_SRC , D.EMPL_REFERRAL_ID , D.PREV_EMPL_BY_COMPY FROM PS_PERS_APPL_INFO A , PS_HRS_APPLICANT B , PS_HRS_APP_PROFILE C , PS_PERS_APPL_REF D WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = C.HRS_PROFILE_SEQ AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND A.HRS_PROFILE_SEQ = D.HRS_PROFILE_SEQ

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    5 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    6 APP_DT Date(10) DATE Date an application was submitted
    7 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
    8 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Subsource Id
    9 SPECIFIC_REFER_SRC Character(50) VARCHAR2(50) NOT NULL Specific Referral Source
    10 EMPL_REFERRAL_ID Character(11) VARCHAR2(11) NOT NULL Employee Referral ID

    Prompt Table: PERSON_NAME

    11 PREV_EMPL_BY_COMPY Character(1) VARCHAR2(1) NOT NULL Previously Employed by Company
    N=No
    Y=Yes

    Y/N Table Edit