EXT_ORG_IDDefault Value: 0
EFFDTDefault Value: %date
A=Active
I=Inactive
Prompt Table: SCC_ORG_TYP_TBL
Prompt Table: COUNTRY_TBL
Prompt Table: STATE_NAMES_TBL
AV_EXT_ORG_SRCH(SQL View) |
Index Back |
|---|---|
External Org Search ViewThis search view is used to include the city, state, and country address fields as alternate search keys. It was created to be used on external organization summary panels. |
| SELECT DISTINCT A.EXT_ORG_ID , A.EFFDT , A.EFF_STATUS , A.OTH_NAME_SORT_SRCH , A.DESCR , A.EXT_ORG_TYPE , A.COUNTRY , A.STATE , A.CITY FROM PS_EXT_ORG_PRI_VW A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EXT_ORG_TBL A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Default Value: 0 |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | OTH_NAME_SORT_SRCH | Character(50) | VARCHAR2(50) NOT NULL | Search Name |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EXT_ORG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Organization Type
Prompt Table: SCC_ORG_TYP_TBL |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 9 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |