SFA_COD_OPEIDVW(SQL View) |
Index Back |
---|---|
Pell_ID_Attending TableThis table defines the variousTitle IV School codes (Attending Campus) for the schools whose Pell Reporting is performed by another school (Reporting Campus). |
SELECT DISTINCT INSTITUTION ,AID_YEAR ,SFA_COD_CAMP_OPEID ,CAMPUS FROM PS_SFA_COD_OPEID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
|
2 | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
|
3 | Character(8) | VARCHAR2(8) NOT NULL | Enrollment School Code for use with the Department of Education financial aid. | |
4 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |