INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: AID_YEAR_TBL
ADJUST_REASON_CDLANGUAGE_CDDefault Value: AWD_ADJ_RSN_TBL.DESCR50
AWDAJRSNCOPYLNG(SQL View) |
Index Back |
|---|---|
Award Adjustment ReasonsAWDAJRSNCOPYLNG is the related language recordfor the record AWD_AJ_RSN_COPY This table allows users to define reason codes used for tracking the various reasons financial aid awards are adjusted once they have been packaged for a student. A common reason for adjusting an award is due to an Appeal, or a Professional Judgement situation. |
| SELECT INSTITUTION ,AID_YEAR ,ADJUST_REASON_CD ,language_cd ,DESCR50 ,DESCRLONG FROM PS_AWDADJRSNTBLLNG |
| # | 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
Prompt Table: AID_YEAR_TBL |
| 3 | ADJUST_REASON_CD |
Character(3) | VARCHAR2(3) NOT NULL | Adjustment Reason |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 6 | DESCRLONG | Long Character | CLOB |
Long Description
Default Value: AWD_ADJ_RSN_TBL.DESCR50 |