TP_STD_CONTR_VW (SQL View)	Index Back
Pre Payment Plan Student This view is used to retrieve the pre payment contract amount for any prior contract for the prior academic year for the student.

TP_STD_CONTR_VW

(SQL View)

Pre Payment Plan Student

This view is used to retrieve the pre payment contract amount for any prior contract for the prior academic year for the student.

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM ,B.TP_CON_CURR_AID_YR ,A.TP_SEQ_NBR ,A.EMPLID ,A.TP_STATUS ,A.PRE_PLAN_AMT FROM PS_TP_STUDENT A, PS_TP_CONTRACT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CONTRACT_NUM = B.CONTRACT_NUM AND A.TP_STATUS = 'A' AND B.TP_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW

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

3 TP_CON_CURR_AID_YR Number(4,0) SMALLINT NOT NULL Current Aid Year

4 TP_SEQ_NBR Number(7,0) INTEGER NOT NULL TP Sequence Number

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

6 TP_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Active
C=Cancelled
H=Hold
I=Inactive
U=Not Posted
Default Value: A

7 PRE_PLAN_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Pre-Payment Plan Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
3	TP_CON_CURR_AID_YR	Number(4,0)	SMALLINT NOT NULL	Current Aid Year
4	TP_SEQ_NBR	Number(7,0)	INTEGER NOT NULL	TP Sequence Number
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	TP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Active C=Cancelled H=Hold I=Inactive U=Not Posted Default Value: A
7	PRE_PLAN_AMT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Pre-Payment Plan Amount