EXT_ORG_IDRA_LASTSCH_VW(SQL View) |
Index Back |
|---|---|
Last School Attended ViewView is used as search prompt for profile field definition. |
| SELECT A.EXT_ORG_ID , A.DESCR FROM PS_EXT_ORG_PRI_VW A , PS_EXT_ORG_TBL_ADM B WHERE %EffdtCheck (EXT_ORG_TBL A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.EXT_ORG_ID = B.EXT_ORG_ID AND %EffdtCheck (EXT_ORG_TBL_ADM B1, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B.OFFERS_COURSES = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |