EXT_ORG_IDPrompt Table: EXT_ORG_TBL
INSTITUTIONDefault Value: ORG_INST_TBL.INSTITUTION
Prompt Table: INSTITUTION_TBL
ORG_GRP_TYPEACA=Academic Quality
FDR=Feeder School
MGN=Magnet School
ORG_GRP_CDPrompt Table: ORG_GRP_CD_TBL
ORG_GROUPING(SQL Table) |
Index Back |
|---|---|
Org GroupingUse ORG_GROUPING to classify schools by ORG_GRP_TYPE and ORG_GRP_CODE. Schools can belong to multiple classifications. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: ORG_INST_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | ORG_GRP_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Organization Group Type
ACA=Academic Quality FDR=Feeder School MGN=Magnet School |
| 4 | ORG_GRP_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Organization Group Code
Prompt Table: ORG_GRP_CD_TBL |