GPSG_NID_TYP_VW

(SQL View)
Index Back

Nat ID Types for Singapore

Used to get National_id_types for Singapore

SELECT A.NATIONAL_ID_TYPE , A.DESCRSHORT FROM PS_NID_TYPE_TBL A WHERE A.COUNTRY = 'SGP'

  • Related Language Record: GPSG_NIDTYP_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
    2 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description