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