SFA_EA_ITM_VW(SQL View) |
Index Back |
|---|---|
External Award Item Type MapSet Up table to cross reference external awards with FA Item Types |
| SELECT INSTITUTION , AID_YEAR , SFA_EA_TYPE , SFA_EA_SOURCE , ITEM_TYPE , SFA_EA_PROGRAM_CD , SFA_EA_SS_VISIBLE FROM PS_SFA_EA_ITM_XREF |
| # | 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 | SFA_EA_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
External Award type (customer defined).
Prompt Table: SFA_EA_TYPE |
| 4 | SFA_EA_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL |
External Award source (customer defined).
Prompt Table: SFA_EA_SOURCE |
| 5 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TP_FA_AWRD |
| 6 | SFA_EA_PROGRAM_CD | Character(3) | VARCHAR2(3) NOT NULL |
External Award program code (customer defined).
Prompt Table: SFA_EA_PROGRAM |
| 7 | SFA_EA_SS_VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
External Award - set admin comments visible/not visible on student self service component (Y/N).
Y/N Table Edit |