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 | 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 |