New Table Columns Added to Innovation Pack 2017
The following table lists table columns that are new to Innovation Pack 2017. All of these tables are active. Some of the column headings are abbreviated as follows:
-
Opt indicates optional.
-
Len indicates length.
-
Prec indicates precision.
-
Def indicates default.
N/A in a row indicates not applicable.
Table | Column | Type | Opt | Data Type | Len | Prec | Scale | Def |
---|---|---|---|---|---|---|---|---|
S_APP_VIEW_RESP |
WS_ID |
Data (Private) |
Y |
Varchar |
15 |
N/A |
N/A |
N/A |
S_APP_VIEW_RESP |
WS_INACTIVE_FLG |
Data (Private) |
N |
Char |
1 |
N/A |
N/A |
N |
S_APP_VIEW_RESP |
WS_MIN_VER |
Data (Private) |
Y |
Number |
22 |
10 |
0 |
0 |
S_APP_VIEW_RESP |
WS_SRC_ID |
Data (Private) |
Y |
Varchar |
15 |
N/A |
N/A |
N/A |
S_ASSESS_ATTRIB |
CATEGORY_CD |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |
S_ASSESS_ATTVAL |
TYPE_CD |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |
S_ASSESS_VAL |
ATTRIB_01_VALUE |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |
S_ASSESS_VAL |
ATTRIB_02_VALUE |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |
S_ASSESS_VAL |
CATEGORY_CD |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |
S_ASSESS_VAL |
CONSIDERATIONS |
Data (Public) |
Y |
Varchar |
1500 |
N/A |
N/A |
N/A |
S_ASSESS_VAL |
DTCTBLTY_SCORE |
Data (Public) |
Y |
Number |
22 |
10 |
0 |
N/A |
S_ASSESS_VAL |
FUNCPLAN_IMPACT_CD |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |
S_ASSESS_VAL |
PROBABILITY_SCORE |
Data (Public) |
Y |
Number |
22 |
10 |
0 |
N/A |
S_ASSESS_VAL |
PROG_PTCL_CD |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N |
S_ASSESS_VAL |
RATIONALE |
Data (Public) |
Y |
Varchar |
256 |
N/A |
N/A |
10000 |
S_ASSESS_VAL |
TOTAL_SCORE |
Data (Public) |
Y |
Number |
22 |
10 |
0 |
0 |
S_LST_OF_VAL |
WS_ID |
Data (Private) |
Y |
Varchar |
15 |
N/A |
N/A |
N/A |
S_LST_OF_VAL |
WS_INACTIVE_FLG |
Data (Private) |
N |
Char |
1 |
N/A |
N/A |
N |
S_LST_OF_VAL |
WS_MAX_VER |
Data (Private) |
Y |
Number |
22 |
10 |
0 |
10000 |
S_LST_OF_VAL |
WS_MIN_VER |
Data (Private) |
Y |
Number |
22 |
10 |
0 |
0 |
S_LST_OF_VAL |
WS_SRC_ID |
Data (Private) |
Y |
Varchar |
15 |
N/A |
N/A |
N/A |
S_UI_CTRL_STYLE |
WEB_TEMPLATE |
Data (Private) |
Y |
Varchar |
75 |
N/A |
N/A |
N/A |
S_WS_WEBSERVICE |
TYPE_CD |
Data (Public) |
Y |
Varchar |
30 |
N/A |
N/A |
N/A |