CS_CNT_SN_TMP (SQL Table)	Index Back
Contract Syndication AE Temp 2/27/2008 RMK F-AHAYT-S60K7 Add version_nbr as key so that %JOIN in app engine sql steps will join correctly to all contract tables

CS_CNT_SN_TMP

(SQL Table)

Contract Syndication AE Temp

2/27/2008 RMK F-AHAYT-S60K7 Add version_nbr as key so that %JOIN in app engine sql steps will join correctly to all contract tables

# 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

3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

4 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node

5 CS_PUBLISHED_FLG Character(1) VARCHAR2(1) NOT NULL Contract Published

6 CS_LAST_SN_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

7 CS_MSG_CONTENT Character(1) VARCHAR2(1) NOT NULL Determines if contract should be published (or re-published) in it's entirety, or changes only. If contract has not been published the default is to 'publish all', if it has, then the default is 'changes only'.
A=Entire Contract
C=Changes Only

8 CS_LOCAL_EMAIL Character(70) VARCHAR2(70) NOT NULL Local Email Address

9 CS_SNDCT_DEFAULTS Character(1) VARCHAR2(1) NOT NULL Flag to identifiy if the CNTRCT_DEFAULTS table will be syndicated.
Y/N Table Edit

10 CS_SNDCT_MISC_CHG Character(1) VARCHAR2(1) NOT NULL Flag to identifiy if the CNTRCT_HDR_MISC table will be syndicated.
Y/N Table Edit

11 CS_SNDCT_MILESTN Character(1) VARCHAR2(1) NOT NULL Flag to identifiy if the CNTRCT_MILESTN table will be syndicated.
Y/N Table Edit

12 CS_SNDCT_SHP_SCHED Character(1) VARCHAR2(1) NOT NULL Flag to identifiy if the CNTRCT_LN_SHIP table will be syndicated.
Y/N Table Edit

13 CS_SNDCT_DISTRIB Character(1) VARCHAR2(1) NOT NULL Flag to identifiy if the CNTRCT_BU_DSTRB and CNTRCT_DSTRB tables will be syndicated.
Y/N Table Edit

14 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

15 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

#	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
3	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number
4	SUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Subscribing Node
5	CS_PUBLISHED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Contract Published
6	CS_LAST_SN_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	CS_MSG_CONTENT	Character(1)	VARCHAR2(1) NOT NULL	Determines if contract should be published (or re-published) in it's entirety, or changes only. If contract has not been published the default is to 'publish all', if it has, then the default is 'changes only'. A=Entire Contract C=Changes Only
8	CS_LOCAL_EMAIL	Character(70)	VARCHAR2(70) NOT NULL	Local Email Address
9	CS_SNDCT_DEFAULTS	Character(1)	VARCHAR2(1) NOT NULL	Flag to identifiy if the CNTRCT_DEFAULTS table will be syndicated. Y/N Table Edit
10	CS_SNDCT_MISC_CHG	Character(1)	VARCHAR2(1) NOT NULL	Flag to identifiy if the CNTRCT_HDR_MISC table will be syndicated. Y/N Table Edit
11	CS_SNDCT_MILESTN	Character(1)	VARCHAR2(1) NOT NULL	Flag to identifiy if the CNTRCT_MILESTN table will be syndicated. Y/N Table Edit
12	CS_SNDCT_SHP_SCHED	Character(1)	VARCHAR2(1) NOT NULL	Flag to identifiy if the CNTRCT_LN_SHIP table will be syndicated. Y/N Table Edit
13	CS_SNDCT_DISTRIB	Character(1)	VARCHAR2(1) NOT NULL	Flag to identifiy if the CNTRCT_BU_DSTRB and CNTRCT_DSTRB tables will be syndicated. Y/N Table Edit
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field