MULTYR_PPLN_VW (SQL View)	Index Back
Payment Plan Contract View This view will be used to display the valid Payment Plan Contracts - TP_CON_TYPE = 'M'

MULTYR_PPLN_VW

(SQL View)

Payment Plan Contract View

This view will be used to display the valid Payment Plan Contracts - TP_CON_TYPE = 'M'

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM ,A.TP_STATUS ,A.TP_CON_PLAN_FEE FROM PS_TP_CONTRACT A WHERE A.TP_CON_TYPE = 'M'

# 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
Prompt Table: MULTYR_CONT_VW

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

4 TP_CON_PLAN_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Plan Fee 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 Prompt Table: MULTYR_CONT_VW
3	TP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contract Status A=Active C=Cancelled H=Hold I=Inactive U=Not Posted
4	TP_CON_PLAN_FEE	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Plan Fee Amount