EODP_PRODUCT_CDEODP_PROD_CD_VW(SQL View) |
Index Back |
|---|---|
Product Code ViewProduct Code View |
| SELECT A.OBJECTOWNERID ,B.XLATLONGNAME FROM PS_EODP_PROD_DEFN A ,PSXLATITEM B WHERE A.OBJECTOWNERID=B.FIELDVALUE AND B.FIELDNAME='OBJECTOWNERID' AND B.EFF_STATUS='A' AND %EffdtCheck(PSXLATITEM,B,%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODP_PRODUCT_CD |
Character(4) | VARCHAR2(4) NOT NULL | PeopleSoft Product Code. Created for Sensitive Data Framework |
| 2 | EODP_OBJ_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product |