SAD_UC_NAMTYPVW

(SQL View)
 Index Back

Name Type prompt


SELECT name_type , name_type_descr FROM %Table(name_type_tbl) WHERE name_type NOT IN ('PRI','PRF')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
2 NAME_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Name Type