PV_CNTRCT_VW (SQL View)	Index Back
Contract ID prompt view.

PV_CNTRCT_VW

(SQL View)

Contract ID prompt view.

SELECT DISTINCT SETID , CNTRCT_ID FROM PS_CNTRCT_HDR WHERE CNTRCT_PROC_OPT <> 'DST' AND CNTRCT_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID