CS_CHNG_HIST_VW(SQL View) |
Index Back |
|---|---|
Change History Viewcel 10/15/07 - new view to help display the change history relationship |
| SELECT cs_doc_id , datetime_stamp , cs_version , cs_amendment , cs_doc_action , cs_source_ver , cs_source_round , %DateNull FROM PS_CS_DOC_HDR_HIST WHERE cs_doc_action = '09' OR CS_DOC_ACTION = '01' OR CS_DOC_ACTION = '11' OR CS_DOC_ACTION = '12' OR CS_DOC_ACTION = '13' OR CS_DOC_ACTION = '27' OR CS_DOC_ACTION = '28' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 3 | CS_VERSION | Number(6,2) | DECIMAL(5,2) NOT NULL | Version |
| 4 | CS_AMENDMENT | Number(3,0) | SMALLINT NOT NULL | Amendment |
| 5 | 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 |
| 6 | 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. |
| 7 | CS_SOURCE_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 8 | REVISION_DT | Date(10) | DATE | Revision Date |