STDNT_TRMTOT_VW

(SQL View)
Index Back

Student Total by Term View


SELECT institution , common_id , emplid , item_term , item_type_group , SUM(item_amt) FROM PS_STDNT_ITEM_VW GROUP BY institution , common_id , emplid , item_term , item_type_group

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
5 ITEM_TYPE_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
6 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount