CNT_UPN_CD_VW(SQL View) |
Index Back |
---|---|
UPN Type CodesUPN Type codes |
SELECT DISTINCT SETID , UPN_TYPE_CD FROM PS_UPN_TYPE_FS WHERE UPN_TYPE_CD <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | UPN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
Default Value: MANUFACTURER.UPN_TYPE_CD Prompt Table: UPN_TYPE_FS |