PRCSINSTANCECONTENTIDFILENAMECDM_FILE_LIST(SQL Table) |
Index Back |
|---|---|
Rpt Mgr - File listThis record is used by Report Manager to store the file list that are viewed from PIA. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CONTENTID |
Number(15,0) | DECIMAL(15) NOT NULL | Report ID |
| 3 | FILENAME |
Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 4 | CDM_FILE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | File types to be referenced by the Distribution Agent for report distribution. |
| 5 | FILE_SIZE | Number(10,0) | DECIMAL(10) NOT NULL | Physical File Size |
| 6 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |