CS_DOC_ADH_KEYS (SQL Table)	Index Back
Adhoc ID keys for Document Keys for Adhoc Contract in Supply Contract Mgmt Note: There really can only be one doc id per setid/adhoc 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.

CS_DOC_ADH_KEYS

(SQL Table)

Adhoc ID keys for Document

Keys for Adhoc Contract in Supply Contract Mgmt Note: There really can only be one doc id per setid/adhoc 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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CS_ADHOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Ad Hoc ID