GPTH_STATE_VW

(SQL View)
Index Back

Used for LYOR03 Query

This 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