| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
VERIFICATION_DATE |
DateTime(26) |
TIMESTAMP |
Verification Date
|
| 6 |
VERIFICATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Type
F=Federal
I=Institutional
Default Value: F
|
| 7 |
VERIF_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source
I=ISIR
P=Institutional App
T=Tax Forms/Verification
|
| 8 |
VERIF_TARGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Target
I=ISIR
P=Institutional App
|
| 9 |
APP_SOURCE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan
|
| 10 |
VERIF_FAILURE_LVL |
Character(3) |
VARCHAR2(3) NOT NULL |
Pass/Fail Option
FED=Federal Level
FLD=Field Level
Default Value: FED
|
| 11 |
VERIF_PROC_SEL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Status
B=Both Pending and Required
P=Verification Pending
R=Required to be Performed
|
| 12 |
AUTO_CORRECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Update Target Table
Y/N Table Edit
Default Value: N
|
| 13 |
MARK_AS_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Mark Assumptions as Verified
Y/N Table Edit
Default Value: N
|
| 14 |
UPDATE_ISIR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Set to Send ISIR Correction
Y/N Table Edit
Default Value: N
|
| 15 |
MARK_AS_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Verification Complete
Y/N Table Edit
Default Value: N
|
| 16 |
STUDENTS_SEL |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Selected
|
| 17 |
STUDENTS_SKIPPED |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Skipped
|
| 18 |
STUDENTS_PROC |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Processed
|
| 19 |
STUDENTS_VERIF |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Passed
|
| 20 |
STUDENTS_NOT_VERIF |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Students Failed
|