SFA_EA_ITM_XREF(SQL Table) |
Index Back |
|---|---|
External Award Item Type MapSet Up table to cross reference external awards with FA Item Types |
| # | 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 | SFA_EA_PROGRAM_CD |
Character(3) | VARCHAR2(3) NOT NULL |
External Award program code (customer defined).
Prompt Table: SFA_EA_PROGRAM |
| 6 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TP_FA_AWRD |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | 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 Default Value: N |
| 9 | SFA_EA_ITM_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
Sequence
A=After B=Before F=First L=Last N=After need based award |
| 10 | SFA_ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TP_FA_AWRD |