CS_DOC_HDR

(SQL Table)
Index Back

Contract Document Header

11/17/2015 TBG added CNTRCT_STYLE for PO0025 feature and also VENDOR_ID and VENDOR-SETID for adhoc enhancement to modify vendor for awarded Sources 11/10/2010 RMK Open XML integration - added cs_file_format to track document xml version versus contract library (cs_file_format in cs_config_tbl) 10/11/07 F-AHAYT-X0ES6 New field to track which file has been checked out; only used when contract goes into amendment cycle. This field is introduced due to managing check out/in of each file using the 2-file option 2008 cel Added the cycle time, user defined fields. etc. 5/3008 cel added the proxy user field. 11/17/2015 TBG Master Contracts changes

  • Related Language Record: CS_DOC_HDR_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    3 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
    AA=Approved
    AD=Denied
    AP=Pending Approval
    CC=Collaborated
    CP=Pending Collaboration
    CR=Collaborated, Pending Review
    DC=Complete
    DR=Draft
    DS=Dispatched
    EC=Pending External Collaboration
    EX=Executed
    PI=Pending Internal Review
    4 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File

    Prompt Table: CS_DOCT_ALL_VW

    5 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator

    Prompt Table: PSOPRDEFN_VW

    6 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor

    Prompt Table: PSOPRDEFN_VW

    7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: CS_DEPTID_VW

    8 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects

    Prompt Table: SP_SETID_NONVW

    9 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04

    Prompt Table: CS_TEMPLATE_DVW

    10 CS_TEMPLATE_AMEND Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
    11 CS_EX_SUMM_TMPL_ID Character(20) VARCHAR2(20) NOT NULL Executive Summary Configurator

    Prompt Table: CS_TEMPLATE_DVW

    12 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
    13 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
    14 CS_TWOFILE_AMEND Character(1) VARCHAR2(1) NOT NULL Amendment Option
    1=Amend Contract Only
    2=Amend Contract with Amendments
    3=Amendment Files Only

    Default Value: 1

    15 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
    01=Ad Hoc
    02=Purchasing Contracts
    03=Purchase Orders
    04=Sourcing Events
    97=All Sources
    98=Multiple Sources
    99=Not Transactional
    16 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
    17 CS_DOC_ATT_VER Number(3,0) SMALLINT NOT NULL This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history
    18 CS_DOC_EXT_ATT_VER Number(3,0) SMALLINT NOT NULL This is the cycle/seq nbr that indicates the change interation/version that the normal attachments are on. Since we want to save them off in history
    19 CS_DOC_DISP_VER Number(3,0) SMALLINT NOT NULL Dispatch version/cycle
    20 CS_DOC_COLLAB_VER Number(3,0) SMALLINT NOT NULL Collaboration Version
    21 CS_DOC_LOG_VER Number(3,0) SMALLINT NOT NULL Logging Version
    22 CS_DOC_SIGN_VER Number(5,0) INTEGER NOT NULL Signing Version Number
    23 CS_DOC_EXEC_VER Number(3,0) SMALLINT NOT NULL Executed Summary Version
    24 CS_COLLAB_INSTR Character(254) VARCHAR2(254) NOT NULL Collaboration Instructions
    25 CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Close Contract Flag

    Y/N Table Edit

    Default Value: N

    26 EXT_LOCK_FLG Character(1) VARCHAR2(1) NOT NULL External Lock Flag

    Y/N Table Edit

    Default Value: N

    27 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold

    Y/N Table Edit

    Default Value: N

    28 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    29 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    30 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    31 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    32 AMENDED_DTTM DateTime(26) TIMESTAMP Amendment Created On
    33 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
    34 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
    35 DATETIME_EX_CHKOUT DateTime(26) TIMESTAMP Summary Checked Out On
    36 CHECKED_OUT_EX_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
    37 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
    38 COLLABED_DTTM DateTime(26) TIMESTAMP Collaborated On
    39 COLLABED_EXT_DTTM DateTime(26) TIMESTAMP Collaborated Externally On
    40 CS_COLLAB_DUE_DT Date(10) DATE Collaboration Due Date
    41 CS_COLLAB_DUE_TM Time(15) TIMESTAMP Collaboration Due Time
    42 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper
    43 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
    44 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
    45 CS_COMPLETED_DTTM DateTime(26) TIMESTAMP Completed Datetime
    46 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    47 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    48 CS_IMPORT_CODE Character(1) VARCHAR2(1) NOT NULL Import Type
    1=Authored
    2=Imported
    3=Hybrid
    4=Automatic Import

    Default Value: 1

    49 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

    Prompt Table: SP_BU_PM_NONVW

    50 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

    Prompt Table: CS_REQ_ID_VW

    51 CS_REQ_LOCATION Character(1) VARCHAR2(1) NOT NULL Requisition Transaction
    C=Core
    E=ePro
    52 CS_DOC_ID_ORIG Character(25) VARCHAR2(25) NOT NULL Document ID
    53 ATTACHED_TO_REQ Character(1) VARCHAR2(1) NOT NULL Attached to Requisition

    Y/N Table Edit

    Default Value: N

    54 CS_DOC_BLD_STATUS Character(1) VARCHAR2(1) NOT NULL Used by Copy Doc. All other document create processes automatically set to 1.
    1=Complete
    2=Refresh Binds
    3=Original Copied
    4=Exec Summary Copied
    5=Wizard Invoked
    9=Copy Initiated

    Default Value: 1

    55 CS_ROUTE_SIGN_FLG Character(1) VARCHAR2(1) NOT NULL Document in Signature Loop

    Y/N Table Edit

    Default Value: N

    56 CS_SIGN_FILE Character(1) VARCHAR2(1) NOT NULL File Being Signed
    0=No Files
    1=Main
    2=Amendment

    Default Value: 0

    57 CS_SIGN_PREP_DONE Character(1) VARCHAR2(1) NOT NULL Adobe Signature Prep

    Y/N Table Edit

    Default Value: N

    58 CS_INT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Signature Status
    NR=Not Required
    PS=Pending Signatures
    SS=Signed

    Default Value: NR

    59 CS_EXT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL External Signature Status
    NR=Not Initiated
    PS=Pending Signatures
    RJ=Declined
    SS=Signed

    Default Value: NR

    60 CS_CHECKOUT_STATUS Character(1) VARCHAR2(1) NOT NULL 10/02/07 Field created for SCMT release 9.1 - flag to determine the checkout status N - not checked out M - main document is checked out (amendment option 1 or 2) A - amendment file is checked out ((amendment option 2 or 3) B - both files are checked out ((amendment option 2)
    A=Checked out amendment file
    B=Checked out both files
    M=Checked out main document
    N=No checkout

    Default Value: N

    61 CS_SOURCE_VER Number(3,0) SMALLINT NOT NULL cel 10/19/2007 - will store the associated source version number that this document is build upon. Both PO and Contracts in 9.1 will have a corresponding version.
    62 CS_SOURCE_ROUND Number(5,0) INTEGER NOT NULL Event Round
    63 CS_DOC_DUE_DATE Date(10) DATE Cycle Due Date
    64 CS_DOC_START_DATE Date(10) DATE Cycle Start Date
    65 CS_DOC_STATUS_DATE Date(10) DATE Last Status Change Date
    66 CS_CHAR_USER1 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 1
    67 CS_CHAR_USER2 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 2
    68 CS_CHAR_USER3 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 3
    69 CS_CHAR_USER4 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 4
    70 CS_CHAR_USER5 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 5
    71 CS_CHAR_USER6 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 6
    72 CS_CHAR_USER7 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 7
    73 CS_CHAR_USER8 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 8
    74 CS_CHAR_USER9 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 9
    75 CS_CHAR_USER10 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 10
    76 CS_CHAR_USER11 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 11
    77 CS_CHAR_USER12 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 12
    78 CS_CHAR_USER13 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 13
    79 CS_CHAR_USER14 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 14
    80 CS_CHAR_USER15 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 15
    81 CS_CHAR_USER16 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 16
    82 CS_CHAR_USER17 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 17
    83 CS_CHAR_USER18 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 18
    84 CS_CHAR_USER19 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 19
    85 CS_CHAR_USER20 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 20
    86 CS_CHAR_USER21 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 21
    87 CS_CHAR_USER22 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 22
    88 CS_CHAR_USER23 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 23
    89 CS_CHAR_USER24 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 24
    90 CS_CHAR_USER25 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 25
    91 CS_CHAR_USER26 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 26
    92 CS_CHAR_USER27 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 27
    93 CS_CHAR_USER28 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 28
    94 CS_CHAR_USER29 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 29
    95 CS_CHAR_USER30 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 30
    96 CS_CHAR_USER31 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 31
    97 CS_CHAR_USER32 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 32
    98 CS_CHAR_USER33 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 33
    99 CS_CHAR_USER34 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 34
    100 CS_CHAR_USER35 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 35
    101 CS_CHAR_USER36 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 36
    102 CS_CHAR_USER37 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 37
    103 CS_CHAR_USER38 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 38
    104 CS_DATE_USER1 Date(10) DATE Date User Field 1
    105 CS_DATE_USER2 Date(10) DATE Date User Field 2
    106 CS_DATE_USER3 Date(10) DATE Date User Field 3
    107 CS_DATE_USER4 Date(10) DATE Date User Field 4
    108 CS_DATE_USER5 Date(10) DATE Date User Field 5
    109 CS_DATE_USER6 Date(10) DATE Date User Field 6
    110 CS_DATE_USER7 Date(10) DATE Date User Field 7
    111 CS_DATE_USER8 Date(10) DATE Date User Field 8
    112 CS_DATE_USER9 Date(10) DATE Date User Field 9
    113 CS_DATE_USER10 Date(10) DATE Date User Field 10
    114 CS_DATE_USER11 Date(10) DATE Date User Field 11
    115 CS_DATE_USER12 Date(10) DATE Date User Field 12
    116 CS_DATE_USER13 Date(10) DATE Date User Field 13
    117 CS_DATE_USER14 Date(10) DATE Date User Field 14
    118 CS_DATE_USER15 Date(10) DATE Date User Field 15
    119 CS_DEC_USER1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 1 (23.3)
    120 CS_DEC_USER2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 2 (23.3)
    121 CS_DEC_USER3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 3 (23.3)
    122 CS_DEC_USER4 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 4 (11.4)
    123 CS_DEC_USER5 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field5 (11.4)
    124 CS_DEC_USER6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 6 (23.3)
    125 CS_DEC_USER7 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 7 (23.3)
    126 CS_DEC_USER8 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 8 (23.3)
    127 CS_DEC_USER9 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 9 (23.3)
    128 CS_DEC_USER10 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 10 (23.3)
    129 CS_DEC_USER11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 11 (23.3)
    130 CS_DEC_USER12 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 12 (11.4)
    131 CS_DEC_USER13 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 13 (11.4)
    132 CS_DEC_USER14 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 14 (11.4)
    133 CS_DEC_USER15 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 15 (11.4)
    134 CS_INT_USER1 Number(8,0) INTEGER NOT NULL Integer User Field 1
    135 CS_INT_USER2 Number(8,0) INTEGER NOT NULL Integer User Field 2
    136 CS_INT_USER3 Number(8,0) INTEGER NOT NULL Integer User Field 3
    137 CS_INT_USER4 Number(8,0) INTEGER NOT NULL Integer User Field 4
    138 CS_INT_USER5 Number(8,0) INTEGER NOT NULL Integer User Field 5
    139 CS_INT_USER6 Number(8,0) INTEGER NOT NULL Integer User Field 6
    140 CS_INT_USER7 Number(8,0) INTEGER NOT NULL Integer User Field 7
    141 CS_INT_USER8 Number(8,0) INTEGER NOT NULL Integer User Field 8
    142 CS_INT_USER9 Number(8,0) INTEGER NOT NULL Integer User Field 9
    143 CS_INT_USER10 Number(8,0) INTEGER NOT NULL Integer User Field 10
    144 CS_INT_USER11 Number(8,0) INTEGER NOT NULL Integer User Field 11
    145 CS_INT_USER12 Number(8,0) INTEGER NOT NULL Integer User Field 12
    146 CS_INT_USER13 Number(8,0) INTEGER NOT NULL Integer User Field 13
    147 CS_INT_USER14 Number(8,0) INTEGER NOT NULL Integer User Field 14
    148 CS_INT_USER15 Number(8,0) INTEGER NOT NULL Integer User Field 15
    149 CS_INT_USER16 Number(8,0) INTEGER NOT NULL Integer User Field 16
    150 CS_INT_USER17 Number(8,0) INTEGER NOT NULL Integer User Field 17
    151 CS_INT_USER18 Number(8,0) INTEGER NOT NULL Integer User Field 18
    152 CS_INT_USER19 Number(8,0) INTEGER NOT NULL Integer User Field 19
    153 CS_INT_USER20 Number(8,0) INTEGER NOT NULL Integer User Field 20
    154 CS_INT_USER21 Number(8,0) INTEGER NOT NULL Integer User Field 21
    155 CS_INT_USER22 Number(8,0) INTEGER NOT NULL Integer User Field 22
    156 CS_INT_USER23 Number(8,0) INTEGER NOT NULL Integer User Field 23
    157 CS_INT_USER24 Number(8,0) INTEGER NOT NULL Integer User Field 24
    158 CS_DOC_UFLD_VER Number(3,0) SMALLINT NOT NULL User Defined Field Version
    159 CS_PROXY_USER Character(30) VARCHAR2(30) NOT NULL Proxy Administrator
    160 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
    161 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
    162 CS_FILE_FORMAT Character(1) VARCHAR2(1) NOT NULL Created in 9.2 to indicate xml version - word xml vs. open
    0=Imported or Signature Document
    1=Word 2003 XML
    2=Word Open XML

    Default Value: 0

    163 CS_RELXD_CHKIN Character(1) VARCHAR2(1) NOT NULL Relaxed CheckIn Used

    Y/N Table Edit

    Default Value: N

    164 CS_COLLAB_COMMENTS Long Character CLOB Collaboration Comments
    165 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style

    Prompt Table: CS_CNTSTYLE_VW

    166 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    167 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: CS_ADH_VENDR_VW

    168 CS_DOCUMENTKEY Character(100) VARCHAR2(100) NOT NULL December 2014 PUM#14 SCMT002 EchoSign electronic signature
    169 CS_ESEND_DTTM DateTime(26) TIMESTAMP SCMT002 2/11/2015 RMK Datetime stamp document is routed for electronic signature
    170 CS_EMAIL_ADDRESS Character(70) VARCHAR2(70) NOT NULL Account Email