TP_CONT_SRCH_VW (SQL View)	Index Back
Payment Plan Contract View This view will be used to display the valid Third Party Contracts and will be used to populate the dropdownlist for update/display functions - TP_CON_TYPE = 'T'

TP_CONT_SRCH_VW

(SQL View)

Payment Plan Contract View

This view will be used to display the valid Third Party Contracts and will be used to populate the dropdownlist for update/display functions - TP_CON_TYPE = 'T'

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM FROM PS_TP_CONTRACT A WHERE A.TP_CON_TYPE = 'T'

# 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