CS_DOC_MAIN_AET(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | ABORT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Abort Process Flag |
3 | 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. |
4 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
5 | CS_AMENDMENT | Number(3,0) | SMALLINT NOT NULL | Amendment |
6 | CS_DOC_ACTION | Character(2) | VARCHAR2(2) NOT NULL | 4/22/08 RMK F-AHAYT-X0ES6 Added action "53" Amendment File Updated 7/08 cel Added 54 Created Executive Summary file |
7 | 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 |
8 | CS_DOC_COPY | Character(1) | VARCHAR2(1) NOT NULL |
Document created through Copy
Y/N Table Edit Default Value: N |
9 | CS_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
10 | CS_DOC_ID_ORIG | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
11 | CS_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
stores the file type -- main file, amendment, preview, throwaway
Date Initials Issue Description
==========================================
06/2007 CEL F-AHAYT-25EQ8 added the external main and amendment types
7/2008 cel Added new executive summary file type.
9/30/2008 RMK Changed values 005 and 006 to 095 and 096, and added 010 for executive summary. This change is due to the search on file type using range (001-010 for non-attachment search, and 001-096 for attachment search)
001=Main Document 002=Amendment 003=Preview Document 004=Compare File 005=Document Attachment 006=Transaction Attachment 007=Config Selector 008=Main Signature Document 009=Amendment Signature File 010=Executive Summary 011=Exec-Sign 095=Document Attachment 096=Transaction Attachment 101=Main Document 102=Amendment Document 998=Main Document - ext collab 999=Amendment External Collab |
12 | 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 |
13 | CS_RELXD_CHKIN | Character(1) | VARCHAR2(1) NOT NULL | Relaxed CheckIn Used |
14 | CS_SETID | Character(5) | VARCHAR2(5) NOT NULL | setid for the document objects |
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_UPDATE_AMNDFILE | Character(1) | VARCHAR2(1) NOT NULL | Update Amendment File |
17 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
18 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
19 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
20 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
21 | 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. |
22 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
23 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |