CS_AUC_LN_CLS_V (SQL View)	Index Back
Event Line Factor Clauses Used to store Event Line bid factor clauses.

CS_AUC_LN_CLS_V

(SQL View)

Event Line Factor Clauses

Used to store Event Line bid factor clauses.

SELECT '0012' ,a.business_unit ,a.auc_id ,a.auc_round ,a.auc_version ,a.line_nbr ,a.bid_factor_nbr ,a.cs_object_id ,a.seq_nbr_5 ,a.auc_parent_cls_id ,a.cs_body_type FROM PS_AUC_LN_FCTR_CLS a

Parent record: AUC_LN_BID_FCTR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID

4 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

5 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

7 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number

8 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section

9 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

10 AUC_PARENT_CLS_ID Character(20) VARCHAR2(20) NOT NULL Parent Clause ID

11 CS_BODY_TYPE Character(1) VARCHAR2(1) NOT NULL indicates body type -- full or by ref for clause/section
F=Full Text
R=By Reference Text
Default Value: F

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_CONTENT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options. 0001=Clause 0002=Section 0003=Ad Hoc Clause 0004=Rule 0005=Bind Variables 0006=Wizard Definition 0007=Document Configurator 0008=Document 0009=Contract Agreement 0010=Bid Factor 0011=Contract 0012=Sourcing Event 0013=Question Group 0014=Document Type 0015=Word Template 0016=Document Format and Options
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CS_CONTENT_ID	Character(30)	VARCHAR2(30) NOT NULL	Content ID
4	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
5	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
7	BID_FACTOR_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Bid Factor Number
8	CS_OBJECT_ID	Character(20)	VARCHAR2(20) NOT NULL	Object id -- clause, section
9	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
10	AUC_PARENT_CLS_ID	Character(20)	VARCHAR2(20) NOT NULL	Parent Clause ID
11	CS_BODY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	indicates body type -- full or by ref for clause/section F=Full Text R=By Reference Text Default Value: F