CS_CT_HD_SN_VW1

(SQL View)

SELECT SETID ,CNTRCT_ID ,SUBNODE ,CS_SN_TYPE ,CS_PUBLISHED_FLG ,CS_CNTRCT_ID_SN ,CS_ORIG_SN_DTTM ,CS_LAST_SN_DTTM FROM %Table(CS_CNTRCT_HD_SN)

# 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 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
Prompt Table: CS_NODES_VW

4 CS_SN_TYPE Character(1) VARCHAR2(1) NOT NULL Syndicate Type
P=Parent
R=Remote
Default Value: R

5 CS_PUBLISHED_FLG Character(1) VARCHAR2(1) NOT NULL Contract Published
Y/N Table Edit
Default Value: N

6 CS_CNTRCT_ID_SN Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

7 CS_ORIG_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.

8 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.

#	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	SUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Subscribing Node Prompt Table: CS_NODES_VW
4	CS_SN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Syndicate Type P=Parent R=Remote Default Value: R
5	CS_PUBLISHED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Contract Published Y/N Table Edit Default Value: N
6	CS_CNTRCT_ID_SN	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
7	CS_ORIG_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.
8	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.