NAME_TYP_CPY_VW(SQL View) |
Index Back |
---|---|
Prompt for name type |
SELECT DISTINCT A.NAME_TYPE , B.NAME_TYPE_DESCR FROM PS_NAMES A , PS_NAME_TYPE_TBL B WHERE A.NAME_TYPE = B.NAME_TYPE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: NAME_TYPE_TBL |
2 | NAME_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Name Type Description |