| # |
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 |
RESTRICTED_AID_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Restricted Aid ID
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: RSTRC_AID.DESCR
|
| 6 |
APP_DEADLINE |
Date(10) |
DATE |
Application Deadline
|
| 7 |
APP_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Required
E=External
I=Internal
N=No App
|
| 8 |
APP_SUBMIT_LOC |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Submit Location
A=Admissions Office
F=Fin-Aid Office
G=Graduate Office
L=Fellowship Office
S=Scholarship Office
U=Alumni Office
|
| 9 |
RENEWABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewable
Y/N Table Edit
Default Value: N
|
| 10 |
APP_REQMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
Application Requirements
Prompt Table:
APP_REQ_VW
|
| 11 |
TOTAL_FUNDING |
Number(15,5) |
DECIMAL(14,5) NOT NULL |
Total Funding
|
| 12 |
NUMBER_OF_AWDS |
Number(6,0) |
INTEGER NOT NULL |
Number Of Awards
|
| 13 |
MAX_AMT |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Maximum Amount
|
| 14 |
MIN_AMT |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Minimum Amount
|
| 15 |
DURATION_TIME |
Number(6,1) |
DECIMAL(5,1) NOT NULL |
Duration Time
|
| 16 |
SFA_DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
T=Terms
Y=Years
|
| 17 |
REPORT_REQMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
Report Requirements
Prompt Table:
REPORT_REQ_VW
|
| 18 |
RECIPIENT_REQMNT |
Character(6) |
VARCHAR2(6) NOT NULL |
Recipient Requirements
Prompt Table:
RECIPINT_REQ_VW
|
| 19 |
RESTRICTED_AID_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Restricted Aid Type
F=Fellowship
S=Scholarship
|
| 20 |
RATING_SCHEME |
Character(10) |
VARCHAR2(10) NOT NULL |
Rating Scheme
Prompt Table:
RATING_SCH_TBL
|
| 21 |
BILL_DONOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Donor
Y/N Table Edit
Default Value: N
|
| 22 |
DEVELOPMENT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Development Code
|
| 23 |
RESTRICTED_AID_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Restricted Aid Control
I=Institutional
O=Outside
|
| 24 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 25 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
Prompt Table:
ITEM_TP_FA_AWRD
|
| 26 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID
Prompt Table:
SETID_TBL
|