SSF_ISET_ITU_VW (SQL View)	Index Back
Item SF View This view is used to identify charges that can be paid given an Institution Set.

SSF_ISET_ITU_VW

(SQL View)

Item SF View

This view is used to identify charges that can be paid given an Institution Set.

SELECT DISTINCT Z.COMMON_ID , Z.BUSINESS_UNIT , Z.CHARGE_PRIORITY , Z.ITEM_TERM FROM PS_SSF_ISET_ITM_VW Z

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List

4 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CHARGE_PRIORITY	Character(8)	VARCHAR2(8) NOT NULL	Charge Priority List
4	ITEM_TERM	Character(4)	VARCHAR2(4) NOT NULL	Item Term