GPCH_TX_CANTONGPCH_DP_CANT_VW(SQL View) |
Index Back |
|---|---|
Dep Canton View CHEDep Canton View CHE |
| SELECT A.STATE FROM PS_STATE_TBL A WHERE A.COUNTRY = 'CHE' UNION SELECT 'EX' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_TX_CANTON |
Character(2) | VARCHAR2(2) NOT NULL | Canton |