PELL_DATA_REQ(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 3 | TIV_SCHOOL_CODE |
Character(6) | VARCHAR2(6) NOT NULL |
Pell ID Reporting
Prompt Table: PELL_ATTEND_VW |
| 4 | PELL_ID_ATTENDED |
Character(6) | VARCHAR2(6) NOT NULL |
Attended Pell ID
Prompt Table: PELL_ATTCAMP_VW |
| 5 | PG_REQUEST_SEQ |
Number(5,0) | INTEGER NOT NULL | Request Sequence Number |
| 6 | PG_REQUEST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Request Type
B=Batch Replacement M=Multiple Reporting R=Reconciliation Request S=Statement of Accounts Y=Year-To-Date |
| 7 | PG_BATCH_ID_00 | Character(26) | VARCHAR2(26) NOT NULL |
Pell Batch ID
Prompt Table: PELL_BATCH_VW |
| 8 | PG_MULT_RQ_CD1 | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Report Request Code 1
D=Disbursed Records O=Originated Records |
| 9 | PG_MULT_RQ_CD2 | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Report Request Code 2
A=All Students I=Selected Institution S=Selected Students |