DEF_CONT_SRCHVW

(SQL View)
Index Back

Payment Plan Contract View

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

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

# 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