PRCSINSTANCECONTENTIDFILENAMECDM_FILELIST_VW(SQL View) |
Index Back |
|---|---|
Rpt Dist - File listThis record is used by Rpt Mgr to store the content list that are viewed via PIA. |
| SELECT A.PRCSINSTANCE , A.CONTENTID , A.FILENAME ,A.CDM_FILE_TYPE , A.FILE_SIZE , A.DTTM_CREATED , B.CDM_ADMIN , B.CDM_BINARY_FILE , B.DESCR50 ,B.FLDNOTUSED FROM PS_CDM_FILE_LIST A , PS_CDM_FILE_EXT B WHERE A.CDM_FILE_TYPE = B.CDM_FILE_TYPE AND B.DISPLAY_OPTION = '1' |
| # | 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 |
| 7 | CDM_ADMIN | Character(1) | VARCHAR2(1) NOT NULL | Administrator Only |
| 8 | CDM_BINARY_FILE | Character(1) | VARCHAR2(1) NOT NULL | Transfer as Binary File |
| 9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 10 | FLDNOTUSED | Number(1,0) | SMALLINT NOT NULL | This field indicates whether a field is being actively used in a table or whether it is just there to avoid rebuilding the table and removing it. The default is 0, which means the field is used. |