REPORT_DEFN_IDRECNAMEPrompt Table: EODP_RECORD_VW
FIELDNAMEPrompt Table: EODP_FIELD_VW
EODP_RUNCNTLCMPEODP_SQR_RCT_VW(SQL View) |
Index Back |
|---|---|
Query Records Temp TableSensitive Data Framework: Query Records Temp Table |
| SELECT SR.EODP_SQR_NAME ,SF.RECNAME ,SF.FIELDNAME ,SR.EODP_RUNCNTLCMP , PD.DESCR ,PD.OBJECTOWNERID , NI.PORTAL_NAVPATH FROM PS_EODP_SQR_REF SF , PS_EODP_NAVINFO NI , PS_EODP_SQR_RUNCNT SR LEFT OUTER JOIN PSPNLGRPDEFN PD ON PD.PNLGRPNAME = SR.EODP_RUNCNTLCMP WHERE NI.PORTAL_NAME = SR.PORTAL_NAME AND NI.PORTAL_REFTYPE = SR.PORTAL_REFTYPE AND NI.PORTAL_OBJNAME = SR.PORTAL_OBJNAME AND SF.EODP_SQR_NAME = SR.EODP_SQR_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_DEFN_ID |
Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: EODP_RECORD_VW |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EODP_FIELD_VW |
| 4 | EODP_RUNCNTLCMP |
Character(18) | VARCHAR2(18) NOT NULL | Run Control Component Name |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 7 | PORTAL_NAVPATH | Long Character | CLOB | Navigation Path |