CS_CNTRCT_DOC_V (SQL View)	Index Back
Keys for PO Contract Keys for PO Contract in Supply Contract Mgmt. Note: There really can only be one doc id per setid/contract id .. but in order to to simplify pages, etc .. it was easier to keep the doc id as the key to make it appear as a sibling to the document tables. PO027 - TBG - Added new fields to increase view on Contract header 1/13/2020 CDEVARAJ 30369919 We ensured that document status is displayed accordingly (Maintain or Add Document) on Supplier Contract page

CS_CNTRCT_DOC_V

(SQL View)

Keys for PO Contract

Keys for PO Contract in Supply Contract Mgmt. Note: There really can only be one doc id per setid/contract id .. but in order to to simplify pages, etc .. it was easier to keep the doc id as the key to make it appear as a sibling to the document tables. PO027 - TBG - Added new fields to increase view on Contract header 1/13/2020 CDEVARAJ 30369919 We ensured that document status is displayed accordingly (Maintain or Add Document) on Supplier Contract page

SELECT PO.SETID , PO.CNTRCT_ID , PO.CS_DOC_ID , H.CS_DOC_STATUS , H.CS_VERSION , H.CS_AMENDMENT , H.CS_TEMPLATE_ID , H.DESCR60 , H.CS_DOC_OWNER , H.CS_SPONSOR , H.DEPTID , h.CREATED_DTTM , H.LAST_MODIFIED_DATE FROM PS_CS_DOC_PO_KEYS PO , PS_CS_DOC_HDR H , PS_CS_DOC_FILES F WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = F.CS_DOC_ID AND F.CS_DOC_TYPE = '001'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

4 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
AA=Approved
AD=Denied
AP=Pending Approval
CC=Collaborated
CP=Pending Collaboration
CR=Collaborated, Pending Review
DC=Complete
DR=Draft
DS=Dispatched
EC=Pending External Collaboration
EX=Executed
PI=Pending Internal Review

5 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version

6 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment

7 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04

8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

9 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
Prompt Table: PSOPRDEFN_VW

10 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor
Prompt Table: PSOPRDEFN_VW

11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: CS_DEPTID_VW

12 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

13 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CNTRCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
3	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
4	CS_DOC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Document Status AA=Approved AD=Denied AP=Pending Approval CC=Collaborated CP=Pending Collaboration CR=Collaborated, Pending Review DC=Complete DR=Draft DS=Dispatched EC=Pending External Collaboration EX=Executed PI=Pending Internal Review
5	CS_VERSION	Number(6,2)	DECIMAL(5,2) NOT NULL	Version
6	CS_AMENDMENT	Number(3,0)	SMALLINT NOT NULL	Amendment
7	CS_TEMPLATE_ID	Character(20)	VARCHAR2(20) NOT NULL	SCC 09/01/04
8	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
9	CS_DOC_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Document Administrator Prompt Table: PSOPRDEFN_VW
10	CS_SPONSOR	Character(30)	VARCHAR2(30) NOT NULL	Sponsor Prompt Table: PSOPRDEFN_VW
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: CS_DEPTID_VW
12	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
13	LAST_MODIFIED_DATE	DateTime(26)	TIMESTAMP	Last modified date