HRS_BIP_FED_LVW

(SQL View)
 Index Back

Federal Preferences View

This view returns descriptions for Federal preferences on Recruiting applications.

SELECT A.HRS_PERSON_ID , A.HRS_PROFILE_SEQ , RL1.LANGUAGE_CD , RL1.DESCR , RL2.DESCR , RL3.DESCR , RL4.DESCR , ' ' , ' ' FROM PS_HRS_APP_PROFILE A LEFT OUTER JOIN PS_HRS_GVT_HCP_LVW RL1 ON RL1.GVT_DISABILITY_CD = A.GVT_DISABILITY_CD LEFT OUTER JOIN PS_HRS_GVT_PPLNLVW RL2 ON RL2.GVT_PAY_PLAN = A.GVT_HIGH_PAY_PLAN LEFT OUTER JOIN PS_HRS_GVT_PPLNLVW RL3 ON RL3.GVT_PAY_PLAN = A.GVT_PAY_PLAN LEFT OUTER JOIN PS_HRS_VTPRF_LVW RL4 ON RL4.GVT_VET_PREF_APPT = A.GVT_VET_PREF_APPT

  • Related Language Record for HRS_BIP_FED_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    7 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    8 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
    9 DESCR5 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.