| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
STUDENT_AID
|
| 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:
AID_YEAR_TBL
|
| 4 |
PELL_ORIG_ID |
Character(23) |
VARCHAR2(23) NOT NULL |
Pell Origination ID
|
| 5 |
TIV_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell ID Reporting
Prompt Table:
PELL_ATTEND_VW
|
| 6 |
PELL_TRANS_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Trans Status
C=Review
H=On Hold
R=Ready
T=Transmitted
X=Cancel
|
| 7 |
PELL_TRANS_STAT_DT |
DateTime(26) |
TIMESTAMP |
Pell Trans Status Date
|
| 8 |
UPDATE_PELL_ORG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Pell Origination
Y/N Table Edit
Default Value: N
|
| 9 |
PELL_MANUAL_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Manual Override
Y/N Table Edit
|
| 10 |
PELL_ORIG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Origination Status
A=Accepted
C=Corrected
O=Originated
R=Rejected
T=Transmitted
U=Change to Origination
X=Canceled
|
| 11 |
PELL_ORIG_STAT_DT |
DateTime(26) |
TIMESTAMP |
Pell Origination Status Date
|
| 12 |
PELL_MRR_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Pell MRR Status
BC=Blocked and Concurrent Enrlmnt
CE=Concurrent Enrollment Inst
PB=Blocked Institution
PR=Blocker Institution
PU=Unblocked Institution
RC=Blocker/Concurrent Enrlmnt
RD=Disbursed Institution
RN=None Found
RO=Originated Institution
SI=Shared SAR ID
VW=Verification W
|
| 13 |
PELL_MRR_STAT_DT |
DateTime(26) |
TIMESTAMP |
Pell MRR Status Date
|