IN_SDWC_OPR_CFG(SQL Table) |
Index Back |
|---|---|
User Workcenter config |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAGELET_CONFIG_ID |
Character(18) | VARCHAR2(18) NOT NULL | FSWC-Workcenter ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 4 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 5 | CHART_DIMENSION | Character(1) | VARCHAR2(1) NOT NULL |
Chart Dimension
2=2D 3=3D Default Value: IN_SDWC_CONFIG.CHART_DIMENSION |
| 6 | IN_SDWC_CHART_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Chart Type
00=Bar 10=Percent Bar 20=Stacked Bar 30=Pie 40=Exploding Pie 50=Horizontal Bar Default Value: IN_SDWC_CONFIG.IN_SDWC_CHART_TYPE |
| 7 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Project Template
Prompt Table: IN_SDWC_SW_VW |
| 8 | DISPLAY_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Display Closed Alerts
Y/N Table Edit Default Value: N |