GPTH_STATE_VW(SQL View) |
Index Back |
---|---|
Used for LYOR03 QueryThis view is used to extend GPTH_STATE_TBL. It makes us to get the row whose 'state' value is space. It is used in GPTH_LYOR03_QRY. |
SELECT COUNTRY , STATE , DESCR , NUMERIC_CD , DESCR_AC FROM PS_STATE_TBL UNION SELECT 'THA' AS COUNTRY , ' ' AS STATE , '' AS DESCR , ' ' AS NUMERIC_CD , ' ' AS DESCR_AC FROM PS_STATE_TBL WHERE COUNTRY = 'THA' AND STATE = '10' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
2 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | NUMERIC_CD | Character(2) | VARCHAR2(2) NOT NULL | Numeric Code |
5 | DESCR_AC | Character(30) | VARCHAR2(30) NOT NULL | Alternate Char Description |