STATESTATE_MMREF_VW(SQL View) |
Index Back |
|---|---|
State MMREF ViewSTATE_NAMES_VW is a view of STATE_NAMES_TBL. The difference is STATE_NAMES_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.STATE IN ('AL', 'AR', 'AZ', 'CO', 'CT', 'DC', 'DE', 'HI', 'GA', 'IA' ,'ID', 'IL', 'IN', 'KS', 'KY', 'LA', 'MA', 'MD', 'ME', 'MI', 'MN', 'MO', 'MS', 'MT', 'NE', 'NC', 'ND', 'NJ', 'NM', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC', 'UT', 'VA', 'VT', 'WI', 'WV') AND A.COUNTRY = 'USA' |
| # | 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 |