LOCATIONSETCNTRLVALUEHRS_JO_LOC_DT_I(SQL View) |
Index Back |
|---|---|
Location ViewLocation View created for use in Job Posting Search Index Pre-Processing Library. |
| SELECT B.LOCATION ,G.SETCNTRLVALUE ,B.DESCR ,B.COUNTRY ,C.DESCR ,B.STATE ,D.DESCR ,B.CITY FROM PS_LOCATION_TBL B ,PS_COUNTRY_TBL C ,PS_STATE_TBL D ,PS_SET_CNTRL_GROUP G WHERE B.COUNTRY= C.COUNTRY AND B.STATE=D.STATE AND C.COUNTRY=D.COUNTRY AND B.SETID= G.SETID AND G.REC_GROUP_ID = ( SELECT H.REC_GROUP_ID FROM PS_REC_GROUP_REC H WHERE H.RECNAME = 'LOCATION_TBL') AND B.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_LOCATION_TBL A WHERE A.SETID = B.SETID AND A.LOCATION = B.LOCATION AND A.EFFDT <= %CurrentDateIn) AND ((D.COUNTRY = 'USA' AND D.NUMERIC_CD > ' ') OR (D.COUNTRY = 'CAN' AND D.NUMERIC_CD > ' ') OR D.COUNTRY NOT IN ('USA','CAN')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 2 | SETCNTRLVALUE |
Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | COUNTRY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | STATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | State Description |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |