CS_DOC_IDCS_DOC_DT_HD_VW(SQL View) |
Index Back |
|---|---|
Document Dates for WorkbenchNew view to pull all doc dates for contract workbench |
| SELECT CS_DOC_ID ,CREATED_DTTM ,LAST_MODIFIED_DATE ,CS_DOC_START_DATE ,CS_DOC_DUE_DATE ,COLLABED_DTTM ,COLLABED_EXT_DTTM ,CS_COLLAB_DUE_DT ,APPROVAL_DTTM ,DATETIME_DISPATCH ,EXECUTED_DTTM ,CNTRCT_BEGIN_DT ,CNTRCT_EXPIRE_DT FROM PS_CS_DOC_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |
| 3 | LAST_MODIFIED_DATE | DateTime(26) | TIMESTAMP | Last modified date |
| 4 | CS_DOC_START_DATE | Date(10) | DATE | Cycle Start Date |
| 5 | CS_DOC_DUE_DATE | Date(10) | DATE | Cycle Due Date |
| 6 | COLLABED_DTTM | DateTime(26) | TIMESTAMP | Collaborated On |
| 7 | COLLABED_EXT_DTTM | DateTime(26) | TIMESTAMP | Collaborated Externally On |
| 8 | CS_COLLAB_DUE_DT | Date(10) | DATE | Collaboration Due Date |
| 9 | APPROVAL_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a given transaction is approved by an oper |
| 10 | DATETIME_DISPATCH | DateTime(26) | TIMESTAMP | 02/2001 cel WV-802-1.0 |
| 11 | EXECUTED_DTTM | DateTime(26) | TIMESTAMP | Executed On |
| 12 | CNTRCT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 13 | CNTRCT_EXPIRE_DT | Date(10) | DATE | Expire Date |