HRS_GVT_HCP_LVW

(SQL View)
 Index Back

Handicap Table

Returns current effective government handicap descriptions based on today's date.

SELECT RL.GVT_DISABILITY_CD , RL.LANGUAGE_CD , RL.DESCR FROM PS_GVT_HANDICP_LNG RL , PS_GVT_HANDICP_TBL HCP WHERE RL.GVT_DISABILITY_CD = HCP.GVT_DISABILITY_CD AND RL.EFFDT = HCP.EFFDT AND %EffdtCheck(GVT_HANDICP_TBL HCP2, HCP, %CurrentDateIn) AND HCP.EFF_STATUS = 'A'

  • Related Language Record for HRS_GVT_HCP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description