EODP_RPT_PRD_VW(SQL View) |
Index Back |
---|---|
Product View for EODP SearchProduct view for data privacy Search |
SELECT A.REPORT_DEFN_ID , B.XLATLONGNAME FROM PSXPRPTDEFN A , PSXLATITEM B WHERE B.FIELDNAME = 'OBJECTOWNERID' AND B.FIELDVALUE = A.OBJECTOWNERID AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table: EODP_RPT_RDF_VW |
2 | EODP_PROD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product Description |