| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 4 |
RESTRICTED_AID_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Restricted Aid ID
Prompt Table:
RSTRC_AID
|
| 5 |
FINAL_DECISION |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Decision
A=Approved
D=Denied
E=Eligible
L=Alternate Recipient
O=Other - See Note
|
| 6 |
DECISION_DATE |
Date(10) |
DATE |
Decision Date
|
| 7 |
APP_DT |
Date(10) |
DATE |
Date an application was submitted
|
| 8 |
APP_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Method
E=External
M=Met Criteria
R=Referral
S=Student Applied
|
| 9 |
OFFER_AMOUNT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Offer Amount
|
| 10 |
RENEWABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewable
Y/N Table Edit
Default Value: RSTRC_AID.RENEWABLE
|
| 11 |
RATING_SCHEME |
Character(10) |
VARCHAR2(10) NOT NULL |
Rating Scheme
Default Value: RSTRC_AID.RATING_SCHEME
Prompt Table:
RATING_SCH_TBL
|
| 12 |
EVALUATN_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation Status
CM=Complete
IP=In Progress
Default Value: IP
Prompt Table:
EVAL_STATUS_TBL
|
| 13 |
OVERALL_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Overall Rating
|
| 14 |
STATUS_DT |
Date(10) |
DATE |
Status Date
Default Value: %date
|
| 15 |
COMMENTS |
Long Character |
CLOB |
Comment
|