TP_PAYP_CNAD_VW (SQL View)	Index Back
Payment Plan Contract Add This view will be used to display the valid Payment Plan Contracts and will be used to populate the dropdownlist for update/display functions - TP_CON_TYPE = 'P' and TP_STATUS = Active

TP_PAYP_CNAD_VW

(SQL View)

Payment Plan Contract Add

This view will be used to display the valid Payment Plan Contracts and will be used to populate the dropdownlist for update/display functions - TP_CON_TYPE = 'P' and TP_STATUS = Active

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM ,A.DESCR FROM PS_TP_CONTRACT A WHERE A.TP_CON_TYPE = 'P' AND A.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 DESCR Character(30) VARCHAR2(30) NOT NULL Description