EXT_ORG_IDSCC_PS_AUDO_BND(SQL View) |
Index Back |
|---|---|
Audience Bind - Org BasedPop Select Bind View for Audience criteria based on Organizations |
| SELECT A.EXT_ORG_ID , A.DESCR FROM PS_EXT_ORG_TBL A WHERE A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EXT_ORG_TBL X WHERE X.EXT_ORG_ID = A.EXT_ORG_ID AND X.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 |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |