SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
LOCATIONPrompt Table: %EDIT_STATE
TD_LOCATION_VW(SQL View) |
Index Back |
|---|---|
Promotions Location VWUsed on the Promotion Contract |
| SELECT A.SETID , A.LOCATION , A.DESCR , A.ADDRESS1 , A.CITY , A.STATE , A.POSTAL , A.COUNTRY_CODE , A.PHONE FROM PS_LOCATION_TBL A , PS_TD_SETID_TBL B WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_LOCATION_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.LOCATION = A_ED.LOCATION AND A_ED.EFFDT <= %CurrentDateIn) AND A.LOCATION = B.LOCATION AND A.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.RECNAME = 'LOCATION_TBL' AND C.SETCNTRLVALUE = B.SETID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 5 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 7 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 8 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
| 9 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |