CS_ADHCOPY_VW (SQL View)	Index Back
Contract Search for PO's

CS_ADHCOPY_VW

(SQL View)

Contract Search for PO's

SELECT B.SETID , B.CS_ADHOC_ID , A.CNTRCT_BEGIN_DT , A.CNTRCT_EXPIRE_DT , A.CS_DOC_ID , A.CS_DOC_OWNER , A.CS_DOC_STATUS , A.CS_DOCUMENT_TYPE , A.CS_SETID , A.CS_SPONSOR , A.DEPTID , A.DESCR60 , A.CS_TEMPLATE_ID , F.CS_FILE_FORMAT , F.CS_RELXD_CHKIN , F.SCM_ATTACH_ID , F.ATT_VERSION FROM PS_CS_DOC_HDR A , PS_CS_DOC_ADH_KEYS B , PS_CS_DOC_FILES F WHERE A.CS_SOURCE_TRANS IN ('01','99') AND A.CS_IMPORT_CODE = '1' AND A.CS_DOC_BLD_STATUS = '1' AND B.CS_DOC_ID = A.CS_DOC_ID AND F.CS_DOC_ID = A.CS_DOC_ID AND F.CS_DOC_TYPE = '001'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CS_ADHOC_ID Character(25) VARCHAR2(25) NOT NULL Ad Hoc ID

3 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date

4 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date

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

6 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator

7 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

8 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
001=Main Document
002=Amendment
003=Preview Document
004=Compare File

9 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects

10 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor

11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

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

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

14 CS_FILE_FORMAT Character(1) VARCHAR2(1) NOT NULL Created in 9.2 to indicate xml version - word xml vs. open
0=Imported or Signature Document
1=Word 2003 XML
2=Word Open XML

15 CS_RELXD_CHKIN Character(1) VARCHAR2(1) NOT NULL Relaxed CheckIn Used

16 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.

17 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CS_ADHOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Ad Hoc ID
3	CNTRCT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
4	CNTRCT_EXPIRE_DT	Date(10)	DATE	Expire Date
5	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
6	CS_DOC_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Document Administrator
7	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
8	CS_DOCUMENT_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Document Type 001=Main Document 002=Amendment 003=Preview Document 004=Compare File
9	CS_SETID	Character(5)	VARCHAR2(5) NOT NULL	setid for the document objects
10	CS_SPONSOR	Character(30)	VARCHAR2(30) NOT NULL	Sponsor
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
13	CS_TEMPLATE_ID	Character(20)	VARCHAR2(20) NOT NULL	SCC 09/01/04
14	CS_FILE_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Created in 9.2 to indicate xml version - word xml vs. open 0=Imported or Signature Document 1=Word 2003 XML 2=Word Open XML
15	CS_RELXD_CHKIN	Character(1)	VARCHAR2(1) NOT NULL	Relaxed CheckIn Used
16	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
17	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.