PRCSINSTANCECONTENTIDPSXP_ATTRIBUT_VALUPY_SSP_URL_VW(SQL View) |
Index Back |
|---|---|
PNA SSP URL AddressPNA Self Service Paycheck URL individual addresses |
| SELECT A.PRCSINSTANCE , A.CONTENTID , B.PSXP_ATTRIBUT_VALU , B.PSXP_ATTRIBUT_NAME , C.FILENAME , D.URL FROM PS_CDM_LIST A , PSXP_RATTR_TBL B , PS_CDM_FILE_LIST C , PS_CDM_DIST_NODE D WHERE A.DISTSTATUS <> '6' AND A.PRCSNAME = 'XMLP' AND A.PRCSINSTANCE = B.PRCSINSTANCE AND A.CONTENTID = B.CONTENTID AND B.PSXP_IS_BURST_FLD = 'Y' AND B.PRCSINSTANCE = C.PRCSINSTANCE AND B.CONTENTID = C.CONTENTID AND C.CDM_FILE_TYPE = 'PDF' AND A.DISTNODENAME = D.DISTNODENAME |
| # | 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 | PSXP_ATTRIBUT_VALU |
Character(128) | VARCHAR2(128) NOT NULL | Reportring Folder's Attribute Value |
| 4 | PSXP_ATTRIBUT_NAME | Character(100) | VARCHAR2(100) NOT NULL | Reporting Folder's Attribute Name |
| 5 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 6 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |