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

SF_ISET_ITUE_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.INSTITUTION_SET , Z.BUSINESS_UNIT FROM PS_SF_ISET_ICHK_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 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set

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

#	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	INSTITUTION_SET	Character(5)	VARCHAR2(5) NOT NULL	Institution Set
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit