PRCSINSTANCECONTENTIDFILENAMELANGUAGE_CDCDM_FILE_VW_LAN(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 , C.LANGUAGE_CD , C.DESCR50 FROM PS_CDM_FILE_LIST A , PS_CDM_FILE_EXT B , PS_CDM_FILEEXT_LAN C WHERE A.CDM_FILE_TYPE = B.CDM_FILE_TYPE AND B.DISPLAY_OPTION = '1' AND B.CDM_FILE_TYPE = C.CDM_FILE_TYPE |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |