CS_DOC_IDCS_ADHDOC_DELVW(SQL View) |
Index Back |
|---|---|
Adhoc Documents DeletedView on Doc delete table to show Adhoc docs that were deleted |
| SELECT CS_DOC_ID , LAST_MODIFIED_DATE FROM PS_CS_DOC_HDR_DEL WHERE CS_SOURCE_TRANS = '01' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | LAST_MODIFIED_DATE | DateTime(26) | TIMESTAMP | Last modified date |