SSR_HE_ETHVW

(SQL View)
Index Back

SELECT SETID ,ETHNIC_GRP_CD ,EFFDT ,DESCRSHORT ,DESCR50 FROM %Table(ETHNIC_GRP_TBL)

  • Related Language Record: SSR_HE_ETH_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    2 ETHNIC_GRP_CD Character(8) VARCHAR2(8) NOT NULL Ethnic group code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50