ITEM_TERM_CR_VW

(SQL View)
Index Back

SELECT DISTINCT a.business_unit ,a.common_id ,a.sa_id_type ,a.emplid ,a.ext_org_id ,a.item_term ,SUM(item_amt) FROM PS_ITEM_SF a WHERE a.item_type_cd IN ('P','D','W','L','Z','F') GROUP BY a.business_unit ,a.common_id ,a.sa_id_type ,a.emplid ,a.ext_org_id ,a.item_term HAVING SUM(a.item_amt) <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 STRM Character(4) VARCHAR2(4) NOT NULL Term
7 TOTAL_CREDITS Signed Number(18,2) DECIMAL(16,2) NOT NULL Total Credits