EXT_ORG_IDY/N Table Edit
Prompt Table: EXT_ORG_TBL
EXT_ORGAN_VW(SQL View) |
Index Back |
|---|---|
External Organization ViewEXT_ORGAN_VW is a view of the EXT_ORG_TBL. It is used for checking if an organization has a catalog_org and is used in the ext_course panel. |
| SELECT a.ext_org_id ,a.shared_catalog ,a.catalog_org FROM PS_EXT_ORG_TBL_ADM a WHERE a.effdt=( SELECT MAX(b.effdt) FROM PS_EXT_ORG_TBL_ADM b WHERE a.ext_org_id = b.ext_org_id AND b.eff_status = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 2 | SHARED_CATALOG | Character(1) | VARCHAR2(1) NOT NULL |
Shared Catalog
Y/N Table Edit |
| 3 | CATALOG_ORG | Character(11) | VARCHAR2(11) NOT NULL |
Catalog Organization
Prompt Table: EXT_ORG_TBL |