HRS_GVT_HCP_VW

(SQL View)
 Index Back

Handicap Table

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

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

  • Related Language Record: HRS_GVT_HCP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.

    Y/N Table Edit

    Default Value: N