SSF_IDUE_PPL_VW (SQL View)	Index Back
Items Due This view returns all payment plans that a student is enrolled in for a particular institution set.

SSF_IDUE_PPL_VW

(SQL View)

Items Due

This view returns all payment plans that a student is enrolled in for a particular institution set.

SELECT B.institution_set , A.business_unit , A.EMPLID , A.CONTRACT_NUM , A.item_amT FROM PS_SSF_PAY_PLAN_VW A , PS_ISET_BU_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set

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

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

5 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION_SET	Character(5)	VARCHAR2(5) NOT NULL	Institution Set
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
5	DUE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Due Amount