SSF_EA_MAPGR_VW

(SQL View)
 Index Back

Item Group Charge View

View of all item sf item types mapped to an item group.

SELECT I.INSTITUTION ,I.AID_YEAR ,D.ITEM_TYPE_GROUP ,I.ITEM_TYPE ,I.SSF_ITEM_TYPE FROM PSTREEDEFN A ,PSTREENODE B ,PSTREELEAF C ,PS_ITEM_GROUP_TBL D ,PS_ITEM_GROUP_DTL E ,PS_SSF_EAITMMAP_VW I WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.SETID = D.TREE_NAME_SETID AND D.ITEM_TYPE_GROUP = E.ITEM_TYPE_GROUP AND D.SETID = E.SETID AND D.SETID = ( SELECT D1.SETID FROM PS_SET_CNTRL_REC D1 WHERE D1.SETCNTRLVALUE = I.INSTITUTION AND D1.RECNAME = 'ITEM_GROUP_TBL') AND D.EFFDT=E.EFFDT AND D.EFF_STATUS='A' AND %EffdtCheck(ITEM_GROUP_TBL D2, D, %CurrentDateIn) AND B.TREE_NODE = E.TREE_NODE AND A.VALID_TREE='Y' AND A.TREE_NAME = B.TREE_NAME AND A.TREE_NAME=C.TREE_NAME AND A.EFFDT=B.EFFDT AND A.EFFDT=C.EFFDT AND %EffdtCheck(PSTREEDEFN A1, A, %CurrentDateIn) AND C.TREE_NODE_NUM = B.TREE_NODE_NUM AND I.ITEM_TYPE >= C.RANGE_FROM AND I.ITEM_TYPE <= C.RANGE_TO

# 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_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
4 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
5 SSF_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type