CS_ATTACH_AET(SQL Table) |
Index Back |
---|---|
Attachment upgrade Run ControlRun Control for process that upgrades ftp attachments to db server |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPR_DEF_TBL_PM |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | CS_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
5 | CS_DOC_ID_TO | Character(25) | VARCHAR2(25) NOT NULL | Document ID To |
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 | 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 |
9 | 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 |
10 | FROM_DATE | Date(10) | DATE | From Date |
11 | THRU_DATE | Date(10) | DATE | Through Date |