GPNL_S_INSGP_VW

(SQL View)
 Index Back

Social Insurance Groups

View to retrieve Social Insurance Groups

SELECT GPNL_INS_GRP , EFFDT , DESCR FROM PS_GPNL_INS_GRP WHERE GPNL_INS_TYPE = '1' AND EFF_STATUS = 'A'

  • Related Language Record: GPNL_INS_GR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPNL_INS_GRP Character(3) VARCHAR2(3) NOT NULL Insurance Group
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description