SSF_EAITMMAP_VW

(SQL View)
 Index Back

Ext Award Item Type Mapping

View that maps the SF payments to financial aid item types.

SELECT B.INSTITUTION ,D.AID_YEAR ,D.item_type ,C.item_type FROM ps_set_cntrl_rec A , ps_INSTITUTION_tbl B , ps_item_type_tbl C , PS_SFA_EA_ITM_XREF d WHERE A.setcntrlvalue = B.institution AND B.INSTITUTION = D.INSTITUTION AND A.recname = 'ITEM_TYPE_TBL' AND C.SFA_EA_TYPE = D.SFA_EA_TYPE AND C.SFA_EA_SOURCE = D.SFA_EA_SOURCE AND C.SFA_EA_PROGRAM_CD = D.SFA_EA_PROGRAM_CD AND C.setid = A.setid AND %EffdtCheck(ITEM_TYPE_TBL C1, C, %CurrentDateIn) AND C.EFF_STATUS = 'A' AND %EffdtCheck(INSTITUTION_TBL B1, B, %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
3 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
4 SSF_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type