IN_SDWC_CONFIG(SQL Table) |
Index Back |
|---|---|
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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 3 | 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 |
| 4 | CHART_DIMENSION | Character(1) | VARCHAR2(1) NOT NULL |
Chart Dimension
2=2D 3=3D Default Value: 2 |
| 5 | 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: 30 |
| 6 | INTERVAL_PERIOD | Number(3,0) | SMALLINT NOT NULL | Days Per Interval |
| 7 | NBR_INTERVALS | Number(2,0) | SMALLINT NOT NULL |
Number of Intervals
Default Value: 1 |
| 8 | EXPAND_KITS_PB | Character(1) | VARCHAR2(1) NOT NULL |
Expand Kit Demand
Y/N Table Edit Default Value: N |
| 9 | DISPLAY_CONTROL | Character(1) | VARCHAR2(1) NOT NULL |
Display Closed Alerts
Y/N Table Edit Default Value: N |