CS_CHNG_AUC_VW(SQL View) |
Index Back |
|---|
| SELECT A.CS_DOC_ID , C.LAST_UPDATE_DTTM , 0 , 0 , 'XX' , C.AUC_VERSION , C.AUC_ROUND , %DatePart(C.LAST_UPDATE_DTTM) FROM PS_CS_DOC_HDR A , PS_CS_DOC_AUC_KEYS B , PS_AUC_HDR C WHERE A.CS_DOC_ID = B.CS_DOC_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.AUC_ID = C.AUC_ID AND (C.AUC_ROUND <> 1 OR C.AUC_VERSION <> 1) |
| # | 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 |