| # |
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_ATTENDING
|
| 4 |
PELL_ID_ATTENDED |
Character(6) |
VARCHAR2(6) NOT NULL |
Attended Pell ID
Prompt Table:
PELL_ATTENDING
|
| 5 |
PG_REQUEST_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Request Sequence Number
|
| 6 |
SFA_CR_REQ_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
ACG/SMART Request Type
AA=ACG Statement of Accounts
AC=ACG Reconciliation Request
AM=ACG Multiple Reporting
AY=ACG Year-To-Date
SA=SMART Statement of Accounts
SC=SMART Reconciliation Request
SM=SMART Multiple Reporting
SY=SMART Year-To-Date
|
| 7 |
PG_MULT_RQ_CD1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Report Request Code 1
D=Disbursed Records
O=Originated Records
|
| 8 |
PG_MULT_RQ_CD2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Report Request Code 2
A=All Students
I=Selected Institution
S=Selected Students
|