CS_DOC_ADHH_SVW

(SQL View)
 Index Back

Adhoc Docs for Contracts

Contract AdHoc docs for PTSF 11/17/2015 TBG Added CNTRCT_STYLE field for Master Contracts 3/25/2018 TBG Added VENDOR_ID/VENDOR_SETID for searching Adhoc Docs when same added to Document Details page

SELECT DISTINCT ADH.CS_DOC_ID ,H.DESCR60 ,'0008' ,ADH.SETID ,ADH.CS_ADHOC_ID ,H.CS_DOC_STATUS ,H.CS_DOCUMENT_TYPE ,H.CNTRCT_STYLE ,H.CS_DOC_OWNER ,H.CS_SPONSOR ,H.DEPTID ,H.CS_SETID ,T.CS_TMPL_TYPE ,H.CS_TEMPLATE_ID ,H.CS_VERSION ,H.CS_AMENDMENT ,H.CS_TWOFILE_AMEND ,H.CS_SOURCE_TRANS ,H.CS_TRANKEY_REC ,H.CNTRCT_BEGIN_DT ,H.CNTRCT_EXPIRE_DT ,H.CREATED_DTTM , H.CREATED_DTTM , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 1, 4) , %Substring(%Cast(H.CREATED_DTTM, Datetime, Character), 9, 2) , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 6, 2) , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 6, 2) ,H.CREATED_BY_USER ,H.DATETIME_CHECKOUT ,H.CHECKED_OUT_BY ,H.COMMENT1 ,H.COLLABED_DTTM ,H.APPROVAL_DTTM ,H.DATETIME_DISPATCH ,H.EXECUTED_DTTM ,H.LAST_MODIFIED_DATE ,H.LASTUPDOPRID ,H.CLOSE_FLAG ,CASE WHEN %Coalesce(TMP.DTTM_MODIFIED, %datetimein('1900-01-01-00.00.00.000000')) > %Coalesce(TMP.DTTM_MODIFIED_SES, %datetimein('1900-01-01-00.00.00.000000')) THEN TMP.DTTM_MODIFIED ELSE TMP.DTTM_MODIFIED_SES END ,H.CS_INT_SIGN_STATUS ,H.CS_EXT_SIGN_STATUS ,H.CS_ROUTE_SIGN_FLG ,H.VENDOR_SETID ,H.VENDOR_ID ,H.CS_CHAR_USER1 ,H.CS_CHAR_USER2 ,H.CS_CHAR_USER3 ,H.CS_CHAR_USER4 ,H.CS_CHAR_USER5 ,H.CS_CHAR_USER6 ,H.CS_CHAR_USER7 ,H.CS_CHAR_USER8 ,H.CS_CHAR_USER9 ,H.CS_CHAR_USER10 ,H.CS_CHAR_USER11 ,H.CS_CHAR_USER12 ,H.CS_CHAR_USER13 ,H.CS_CHAR_USER14 ,H.CS_CHAR_USER15 ,H.CS_CHAR_USER16 ,H.CS_CHAR_USER17 ,H.CS_CHAR_USER18 ,H.CS_CHAR_USER19 ,H.CS_CHAR_USER20 ,H.CS_CHAR_USER21 ,H.CS_CHAR_USER22 ,H.CS_CHAR_USER23 ,H.CS_CHAR_USER24 ,H.CS_CHAR_USER25 ,H.CS_CHAR_USER26 ,H.CS_CHAR_USER27 ,H.CS_CHAR_USER28 ,H.CS_CHAR_USER29 ,H.CS_CHAR_USER30 ,H.CS_CHAR_USER31 ,H.CS_CHAR_USER32 ,H.CS_CHAR_USER33 ,H.CS_CHAR_USER34 ,H.CS_CHAR_USER35 ,H.CS_CHAR_USER36 ,H.CS_CHAR_USER37 ,H.CS_CHAR_USER38 ,H.CS_DATE_USER1 ,H.CS_DATE_USER2 ,H.CS_DATE_USER3 ,H.CS_DATE_USER4 ,H.CS_DATE_USER5 ,H.CS_DATE_USER6 ,H.CS_DATE_USER7 ,H.CS_DATE_USER8 ,H.CS_DATE_USER9 ,H.CS_DATE_USER10 ,H.CS_DATE_USER11 ,H.CS_DATE_USER12 ,H.CS_DATE_USER13 ,H.CS_DATE_USER14 ,H.CS_DATE_USER15 ,H.CS_DEC_USER1 ,H.CS_DEC_USER2 ,H.CS_DEC_USER3 ,H.CS_DEC_USER4 ,H.CS_DEC_USER5 ,H.CS_DEC_USER6 ,H.CS_DEC_USER7 ,H.CS_DEC_USER8 ,H.CS_DEC_USER9 ,H.CS_DEC_USER10 ,H.CS_DEC_USER11 ,H.CS_DEC_USER12 ,H.CS_DEC_USER13 ,H.CS_DEC_USER14 ,H.CS_DEC_USER15 ,H.CS_INT_USER1 ,H.CS_INT_USER2 ,H.CS_INT_USER3 ,H.CS_INT_USER4 ,H.CS_INT_USER5 ,H.CS_INT_USER6 ,H.CS_INT_USER7 ,H.CS_INT_USER8 ,H.CS_INT_USER9 ,H.CS_INT_USER10 ,H.CS_INT_USER11 ,H.CS_INT_USER12 ,H.CS_INT_USER13 ,H.CS_INT_USER14 ,H.CS_INT_USER15 ,H.CS_INT_USER16 ,H.CS_INT_USER17 ,H.CS_INT_USER18 ,H.CS_INT_USER19 ,H.CS_INT_USER20 ,H.CS_INT_USER21 ,H.CS_INT_USER22 ,H.CS_INT_USER23 ,H.CS_INT_USER24 FROM PS_CS_DOC_ADH_KEYS ADH ,(PS_CS_DOC_HDR H LEFT OUTER JOIN PS_CS_TMPL_TBL T ON H.CS_TEMPLATE_ID = T.CS_TEMPLATE_ID AND H.CS_SETID = T.SETID) ,PS_CS_DOC_DATE_SES TMP WHERE ADH.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = TMP.CS_DOC_ID

  • Related Language Record: CS_DOC_ADHH_LVW

    • # 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_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
    4 CS_ADHOC_SETID Character(5) VARCHAR2(5) NOT NULL Setid for the Adhoc documents
    5 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    6 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
    7 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File
    8 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    9 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator
    10 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor

    Prompt Table: PSOPRDEFN_VW

    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    12 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    13 CS_TMPL_TYPE Character(4) VARCHAR2(4) NOT NULL SCC 09/01/04
    14 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
    15 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
    16 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
    17 CS_TWOFILE_AMEND Character(1) VARCHAR2(1) NOT NULL Amendment Option
    1=Amend Contract Only
    2=Amend Contract with Amendments
    3=Amendment Files Only

    Y/N Table Edit

    Default Value: N

    18 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
    19 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
    20 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    21 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    22 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    23 SES_DOCUMENT_DATE Date(10) DATE Document Date
    24 SES_YEAR Character(4) VARCHAR2(4) NOT NULL Document Date Hierarchy
    25 SES_DAY Character(2) VARCHAR2(2) NOT NULL Day
    26 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    27 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    28 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    29 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
    30 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
    31 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
    32 COLLABED_DTTM DateTime(26) TIMESTAMP Collaborated On
    33 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper
    34 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
    35 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
    36 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    37 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.
    38 CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Close Contract Flag
    39 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    40 CS_INT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Signature Status
    NR=Not Required
    PS=Pending Signatures
    SS=Signed

    Default Value: NR

    41 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

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

    Y/N Table Edit

    Default Value: N

    43 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    44 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    45 CS_CHAR_USER1 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 1
    46 CS_CHAR_USER2 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 2
    47 CS_CHAR_USER3 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 3
    48 CS_CHAR_USER4 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 4
    49 CS_CHAR_USER5 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 5
    50 CS_CHAR_USER6 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 6
    51 CS_CHAR_USER7 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 7
    52 CS_CHAR_USER8 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 8
    53 CS_CHAR_USER9 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 9
    54 CS_CHAR_USER10 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 10
    55 CS_CHAR_USER11 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 11
    56 CS_CHAR_USER12 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 12
    57 CS_CHAR_USER13 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 13
    58 CS_CHAR_USER14 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 14
    59 CS_CHAR_USER15 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 15
    60 CS_CHAR_USER16 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 16
    61 CS_CHAR_USER17 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 17
    62 CS_CHAR_USER18 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 18
    63 CS_CHAR_USER19 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 19
    64 CS_CHAR_USER20 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 20
    65 CS_CHAR_USER21 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 21
    66 CS_CHAR_USER22 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 22
    67 CS_CHAR_USER23 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 23
    68 CS_CHAR_USER24 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 24
    69 CS_CHAR_USER25 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 25
    70 CS_CHAR_USER26 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 26
    71 CS_CHAR_USER27 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 27
    72 CS_CHAR_USER28 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 28
    73 CS_CHAR_USER29 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 29
    74 CS_CHAR_USER30 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 30
    75 CS_CHAR_USER31 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 31
    76 CS_CHAR_USER32 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 32
    77 CS_CHAR_USER33 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 33
    78 CS_CHAR_USER34 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 34
    79 CS_CHAR_USER35 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 35
    80 CS_CHAR_USER36 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 36
    81 CS_CHAR_USER37 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 37
    82 CS_CHAR_USER38 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 38
    83 CS_DATE_USER1 Date(10) DATE Date User Field 1
    84 CS_DATE_USER2 Date(10) DATE Date User Field 2
    85 CS_DATE_USER3 Date(10) DATE Date User Field 3
    86 CS_DATE_USER4 Date(10) DATE Date User Field 4
    87 CS_DATE_USER5 Date(10) DATE Date User Field 5
    88 CS_DATE_USER6 Date(10) DATE Date User Field 6
    89 CS_DATE_USER7 Date(10) DATE Date User Field 7
    90 CS_DATE_USER8 Date(10) DATE Date User Field 8
    91 CS_DATE_USER9 Date(10) DATE Date User Field 9
    92 CS_DATE_USER10 Date(10) DATE Date User Field 10
    93 CS_DATE_USER11 Date(10) DATE Date User Field 11
    94 CS_DATE_USER12 Date(10) DATE Date User Field 12
    95 CS_DATE_USER13 Date(10) DATE Date User Field 13
    96 CS_DATE_USER14 Date(10) DATE Date User Field 14
    97 CS_DATE_USER15 Date(10) DATE Date User Field 15
    98 CS_DEC_USER1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 1 (23.3)
    99 CS_DEC_USER2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 2 (23.3)
    100 CS_DEC_USER3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 3 (23.3)
    101 CS_DEC_USER4 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 4 (11.4)
    102 CS_DEC_USER5 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field5 (11.4)
    103 CS_DEC_USER6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 6 (23.3)
    104 CS_DEC_USER7 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 7 (23.3)
    105 CS_DEC_USER8 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 8 (23.3)
    106 CS_DEC_USER9 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 9 (23.3)
    107 CS_DEC_USER10 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 10 (23.3)
    108 CS_DEC_USER11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 11 (23.3)
    109 CS_DEC_USER12 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 12 (11.4)
    110 CS_DEC_USER13 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 13 (11.4)
    111 CS_DEC_USER14 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 14 (11.4)
    112 CS_DEC_USER15 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 15 (11.4)
    113 CS_INT_USER1 Number(8,0) INTEGER NOT NULL Integer User Field 1
    114 CS_INT_USER2 Number(8,0) INTEGER NOT NULL Integer User Field 2
    115 CS_INT_USER3 Number(8,0) INTEGER NOT NULL Integer User Field 3
    116 CS_INT_USER4 Number(8,0) INTEGER NOT NULL Integer User Field 4
    117 CS_INT_USER5 Number(8,0) INTEGER NOT NULL Integer User Field 5
    118 CS_INT_USER6 Number(8,0) INTEGER NOT NULL Integer User Field 6
    119 CS_INT_USER7 Number(8,0) INTEGER NOT NULL Integer User Field 7
    120 CS_INT_USER8 Number(8,0) INTEGER NOT NULL Integer User Field 8
    121 CS_INT_USER9 Number(8,0) INTEGER NOT NULL Integer User Field 9
    122 CS_INT_USER10 Number(8,0) INTEGER NOT NULL Integer User Field 10
    123 CS_INT_USER11 Number(8,0) INTEGER NOT NULL Integer User Field 11
    124 CS_INT_USER12 Number(8,0) INTEGER NOT NULL Integer User Field 12
    125 CS_INT_USER13 Number(8,0) INTEGER NOT NULL Integer User Field 13
    126 CS_INT_USER14 Number(8,0) INTEGER NOT NULL Integer User Field 14
    127 CS_INT_USER15 Number(8,0) INTEGER NOT NULL Integer User Field 15
    128 CS_INT_USER16 Number(8,0) INTEGER NOT NULL Integer User Field 16
    129 CS_INT_USER17 Number(8,0) INTEGER NOT NULL Integer User Field 17
    130 CS_INT_USER18 Number(8,0) INTEGER NOT NULL Integer User Field 18
    131 CS_INT_USER19 Number(8,0) INTEGER NOT NULL Integer User Field 19
    132 CS_INT_USER20 Number(8,0) INTEGER NOT NULL Integer User Field 20
    133 CS_INT_USER21 Number(8,0) INTEGER NOT NULL Integer User Field 21
    134 CS_INT_USER22 Number(8,0) INTEGER NOT NULL Integer User Field 22
    135 CS_INT_USER23 Number(8,0) INTEGER NOT NULL Integer User Field 23
    136 CS_INT_USER24 Number(8,0) INTEGER NOT NULL Integer User Field 24