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