DP_CONSTANTNAMEDP_SEASTYPES_VW(SQL View) |
Index Back |
|---|---|
DP_SEASTYPES_VWDP_SEASTYPES_VW |
| SELECT DP_CONSTANTNAME , DP_CONSTANTCAPTION , DP_CONSTANTVALUE FROM PS_DP_FCSTX_CONS WHERE DP_FIELDID = 'DP_BF_SEAS_TYPE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CONSTANTNAME |
Character(40) | VARCHAR2(40) NOT NULL | DP_CONSTANTNAME |
| 2 | DP_CONSTANTCAPTION | Character(60) | VARCHAR2(60) NOT NULL | DP_CONSTANTCAPTION |
| 3 | DP_CONSTANTVALUE | Character(6) | VARCHAR2(6) NOT NULL | DP_CONSTANTVALUE |