| # |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 4 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
STDNT_FA_TRM_VW
|
| 5 |
RTRN_TIV_PGM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Type (Credit/Clock Hr)
L=Clock Hour Program
R=Credit Hour Program
Default Value: R
|
| 6 |
RTOF_TRACK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Status
C=Completed
P=Pending
|
| 7 |
RTOF_NOTIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Notified
Y/N Table Edit
|
| 8 |
RTOF_NOTIF_DT |
Date(10) |
DATE |
Notification Date
|
| 9 |
RTOF_STU_RESP_DT |
Date(10) |
DATE |
Response Date
|
| 10 |
RTOF_RPAY_ARRANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Repayment Arrangement
0=N/A
1=Will Pay in Full
2=Will Make Arrangements
3=Will Not Make Arrangements
4=No Response
5=Make Arrangements School
6=Make Arrangements DOE
7=No Satisfactory Arrangements
8=Pay School in Full
9=Arrangement not Complied
A=Title IV Loans Only
|
| 11 |
TOT_AMT_STU_OWE |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
K. Amt Due From Student
|
| 12 |
RTRN_TIV_DAYS_PAST |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Days Elapsed *
|
| 13 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 14 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 15 |
SFA_HERA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTIV Hera flag.
N=New RTIV HERA Version
O=Old RTIV Version
Default Value: N
|