CS_AUC_HD_CLS_V

(SQL View)
 Index Back

Event Header Factor Clauses

Used to store Event bid factor clauses.

SELECT A.BUSINESS_UNIT ,A.AUC_ROUND ,A.AUC_VERSION ,A.BID_FACTOR_NBR ,A.CS_OBJECT_ID ,'0012' ,A.AUC_ID ,A.SEQ_NBR_5 ,A.AUC_PARENT_CLS_ID ,A.CS_BODY_TYPE FROM PS_AUC_HDR_FCT_CLS A

  • Parent record: AUC_LN_BID_FCTR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    3 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    4 BID_FACTOR_NBR Number(10,0) DECIMAL(10) NOT NULL Bid Factor Number
    5 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
    6 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
    7 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    8 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long
    9 AUC_PARENT_CLS_ID Character(20) VARCHAR2(20) NOT NULL Parent Clause ID
    10 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