COUNTRYPrompt Table: COUNTRY_TBL
STATEPrompt Table: STATE_NAMES_TBL
CITYSAD_CRM_ORG_VW(SQL View) |
Index Back |
|---|---|
Organization ViewSA/CRm Integration View created to load external organization into the CRM database as attribute choices on the marketing profiles. |
| SELECT B.COUNTRY , B.STATE , B.CITY , EOT.DESCR , EOT.EXT_ORG_ID FROM PS_EXT_ORG_TBL EOT , PS_ORG_LOCATION B WHERE EOT.EXT_ORG_TYPE = 'SCHL' AND EOT.EFF_STATUS = 'A' AND EOT.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EXT_ORG_TBL X WHERE X.EXT_ORG_ID = EOT.EXT_ORG_ID AND X.EFF_STATUS = EOT.EFF_STATUS AND X.EFFDT <= %CurrentDateIn) AND EOT.EXT_ORG_ID = B.EXT_ORG_ID AND EOT.EFFDT = B.EFFDT AND EOT.ORG_LOCATION = B.ORG_LOCATION AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 3 | CITY |
Character(30) | VARCHAR2(30) NOT NULL | City |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |