STATEGPUS_MMREFST_VW(SQL View) |
Index Back |
|---|---|
State MMREF ViewThis is a view of STATE_NAMES_TBL. The difference is GPUS_MMREFST_VW doesn't have COUNTRY as the high-order key. |
| SELECT A.STATE ,A.NUMERIC_CD ,A.DESCR FROM PS_STATE_NAMES_TBL A WHERE A.COUNTRY = 'USA' AND A.STATE IN ('AL', 'AR', 'AZ', 'CO', 'CT', 'DC', 'DE', 'GA', 'ID', 'IL', 'IN', 'KS', 'KY', 'LA', 'MA', 'MD', 'ME', 'MI', 'MN', 'MO', 'MS', 'MT', 'NE', 'NC', 'ND', 'NJ', 'NM', 'OH', 'OR', 'PA', 'RI', 'SC', 'UT', 'VA', 'VT', 'WI', 'WV') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | NUMERIC_CD | Character(2) | VARCHAR2(2) NOT NULL | Numeric Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |