SETIDDefault Value: ITEM_FA_CD_TBL.SETID
Prompt Table: SP_SETID_NONVW
AID_YEARDefault Value: ITEM_FA_CD_TBL.AID_YEAR
Prompt Table: FED_AID_YR_TBL
AWARD_MSG_CDAWD_MESSAGE_VW(SQL View) |
Index Back |
|---|---|
Award Messages Prompt TblView of award message table with aid year and setid |
| Select Setid, Aid_Year, Award_Msg_Cd From PS_AWD_MESSAGE_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: ITEM_FA_CD_TBL.SETID Prompt Table: SP_SETID_NONVW |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: ITEM_FA_CD_TBL.AID_YEAR Prompt Table: FED_AID_YR_TBL |
| 3 | AWARD_MSG_CD |
Character(4) | VARCHAR2(4) NOT NULL | Award Message |