INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SFA_CR_SCHOOL_IDY/N Table Edit
Default Value: Y
SFA_OPEID_XF_VW(SQL View) |
Index Back |
|---|---|
OPEID Institution Cross RefThis table creates cross reference of variousTitle IV School codes (OPEID) against Institution Id. |
| SELECT INSTITUTION ,SFA_CR_SCHOOL_ID ,SFA_ACTIVE_OPEID FROM PS_SFA_OPEID_XREF WHERE SFA_CR_ID_TYPE = '02' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | SFA_CR_SCHOOL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Common School ID/OPEID |
| 3 | SFA_ACTIVE_OPEID | Character(1) | VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit Default Value: Y |