PROCESS_INSTANCECS_DOC_IDCS_DOC_ACTIONCS_DOC_LSTACTMP(SQL Table) |
Index Back |
|---|---|
Shows last action date/opridused in reporting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 3 | 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 |
| 4 | CS_LST_APPSUB | DateTime(26) | TIMESTAMP | Last Approval Submit |
| 5 | CS_LST_APPSUB_OPR | Character(30) | VARCHAR2(30) NOT NULL | Last Approval Submit Operator |
| 6 | CS_LST_CHKIN | DateTime(26) | TIMESTAMP | Last Checked In |
| 7 | CS_LST_CHKIN_OPR | Character(30) | VARCHAR2(30) NOT NULL | Last Checked In Operator |