EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONDefault Value: STDNT_AID_SRCH.INSTITUTION
Prompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: STUDENT_AID
BATCH_NUMBERPrompt Table: ISIRS_VW
P=Processed
R=Rejected
S=Submitted
X=Reprocessed
ISIR_CORRECT(SQL Table) |
Index Back |
|---|---|
Rejected Correction RecordsISIR_CORRECT contains ISIR Correction Records that were rejected by the US Dept. of Education. These records are reviewed by the operator and either corrected and resubmitted, or deleted. |
| # | 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
Default Value: STDNT_AID_SRCH.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 | SUBMIT_DT | Date(10) | DATE | Submission Date |
| 6 | ASOFDATE | Date(10) | DATE |
As of Date
Prompt Table: ISIRS_VW |
| 7 | SEQUENCE_NUMBER | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 8 | ISIR_TXN_NBR | Number(2,0) | SMALLINT NOT NULL | Transaction Num |
| 9 | CORR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Batch Status
P=Processed R=Rejected S=Submitted X=Reprocessed |
| 10 | BATCH_ERROR | Character(51) | VARCHAR2(51) NOT NULL | Batch Error |