USERIDPRCSINSTANCECONTENTIDDBNAMEPSXP_ATTRIBUT_NAMEPSXP_IS_BURST_FLDPY_YE_XMLRPT_VW(SQL View) |
Index Back |
|---|---|
Report Attributes TableReport Attributes Table to Store Name Value pairs of a report. Used in Report Folders Implementation. |
| SELECT A.USERID ,A.PRCSINSTANCE ,A.CONTENTID ,A.DBNAME ,B.PSXP_ATTRIBUT_NAME ,B.PSXP_IS_BURST_FLD ,B.PSXP_ATTRIBUT_VALU ,C.URL ,D.FILENAME FROM PSXP_RF_VW A , PSXP_RATTR_TBL B , PS_CDM_LIST_VW C , PS_CDM_FILELIST_VW D WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND A.CONTENTID = B.CONTENTID AND A.DBNAME = B.DBNAME AND B.PSXP_IS_BURST_FLD = 'Y' AND A.PRCSINSTANCE = C.PRCSINSTANCE AND A.CONTENTID = C.CONTENTID AND A.PRCSNAME = C.PRCSNAME AND A.USERID = C.OPRID AND C.PRCSINSTANCE = D.PRCSINSTANCE AND C.CONTENTID = D.CONTENTID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | CONTENTID |
Number(15,0) | DECIMAL(15) NOT NULL | Report ID |
| 4 | DBNAME |
Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 5 | PSXP_ATTRIBUT_NAME |
Character(100) | VARCHAR2(100) NOT NULL | Reporting Folder's Attribute Name |
| 6 | PSXP_IS_BURST_FLD |
Character(1) | VARCHAR2(1) NOT NULL | Is tthis bust field |
| 7 | PSXP_ATTRIBUT_VALU | Character(128) | VARCHAR2(128) NOT NULL | Reportring Folder's Attribute Value |
| 8 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 9 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |