FIELDNAMEPL_DP_ARRFLD_VW(SQL View) |
Index Back |
|---|---|
PL_DP_ARRFLD_VWPL_DP_ARRFLD_VW |
| SELECT A.FIELDNAME FROM PSRECFIELD A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND A.RECNAME = 'DP_PUB_FCITDATA' AND (A.FIELDNAME LIKE 'DP_FORECAST%' OR A.FIELDNAME LIKE 'DP_EVAL%' OR A.FIELDNAME LIKE 'DP_USERDATA%' OR A.FIELDNAME = 'DP_ADJFORECAST' OR A.FIELDNAME = 'DP_PROFORECAST' OR A.FIELDNAME = 'DP_STATFORECAST' OR A.FIELDNAME = 'DP_SUMMFORECAST') AND A.FIELDNAME <> 'DP_FORECASTADJ' AND (B.FIELDTYPE = 2 OR B.FIELDTYPE = 3) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |