EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: STUDENT_AID
BATCH_NUMBERISIR_FIELD_NUMPrompt Table: ISIR_FLD_SRCH
OLD_VALUENEW_VALUED=Delete
P=Pending
R=Resubmit
X=Processed
Default Value: P
ISIR_CORR_FLDS(SQL Table) |
Index Back |
|---|---|
Correction Field Level DataISIR_CORR_FLDS contains all of the field level corrections associated with a correction record submitted to the US Department of Education to make corrections to the Federal Financial Aid Application (called FAFSA or ISIR). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
| 4 | BATCH_NUMBER |
Character(23) | VARCHAR2(23) NOT NULL | CPS Batch Number |
| 5 | ISIR_FIELD_NUM |
Character(4) | VARCHAR2(4) NOT NULL |
ISIR Field Num
Prompt Table: ISIR_FLD_SRCH |
| 6 | OLD_VALUE |
Character(50) | VARCHAR2(50) NOT NULL | Previous Field Value |
| 7 | NEW_VALUE |
Character(50) | VARCHAR2(50) NOT NULL | Submitted Value |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | BATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Batch Action Code
D=Delete P=Pending R=Resubmit X=Processed Default Value: P |
| 10 | FIELD_ERROR | Character(90) | VARCHAR2(90) NOT NULL | Error Message |