AID_YEARPrompt Table: FED_AID_YR_TBL
PELL_COMM_CODEDefault Value: PELL_COMNT_TBL.DESCR
0=Ignore
1=Action Required
2=Action Required if SAR C Flag
PELL_COM_CPY_VW(SQL View) |
Index Back |
|---|---|
Pell Comment Codes Copy ViewThis view is used to copy Pell Comment Codes from Aid Year to Aid Year. |
| SELECT AID_YEAR, PELL_COMM_CODE, DESCR, DESCRSHORT, SEVERITY_LVL, DESCRLONG FROM PS_PELL_COMNT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: FED_AID_YR_TBL |
| 2 | PELL_COMM_CODE |
Character(3) | VARCHAR2(3) NOT NULL | Pell Comment Codes |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: PELL_COMNT_TBL.DESCR |
| 5 | SEVERITY_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Severity Level
0=Ignore 1=Action Required 2=Action Required if SAR C Flag |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |