...
Database Modifications
...
New and Modified Tables
Table | FieldName | FieldType | Description |
PWWAITINGROOM |
|
| New table |
| INTERFACE | VARCHAR(16) |
|
| EXTERNAL_PIN | VARCHAR(100) |
|
| ENDPOINT | VARCHAR(50) |
|
| PIN | INT |
|
| NAME | VARCHAR(100) |
|
| ERROR | NVARCHAR(MAX) |
|
| REQUEST | NVARCHAR(MAX) |
|
| REQUEST_DATE | DATETIME |
|
|
|
|
|
PW001P00_XREF |
|
| New table |
| INTERFACE_XREF | VARCHAR(10) |
|
| TABLE_REF | INT |
|
| SEQUENCENO_REF | INT |
|
| SEQUENCENO_XREF | VARCHAR(200) |
|
| COMMENT | NVARCHAR(100) |
|
|
|
|
|
WEB_CP_EVAL_WORKFLOWSTAGES
IS_SHOW_SECTION_SCORE
BIT
PWWAITINGROOM | REQUEST_DATE |
| Rename column DATE |
WEB_CP_ |
WEB_CP_EVAL_WORKFLOWSTAGES
IS_SHOW_EVALUATOR_QUESTION_SCORE
BIT
Add column
WEB_CP_EVAL_WORKFLOWSTAGES
IS_SHOW_TOTAL_SCORE
BIT
Add column
TIMECARD |
IS_SHOW_EVALUEE_QUESTION_SCORE
BIT
Add column
MODIFICATION_REASON |
| Rename column COMMENTS | |
|
|
|
|
WEB_CP_ |
EVALUETION_FORM_CODE
Drop column
WEB_CP_EVAL_DOCUMENTS
API_KEYS |
|
|
New table
|
|
WEB_CP_EVAL_WORKFLOW_DEFINITION
CREATED
DATETIME
Add column
WEB_CP_EVAL_SECTION_QUEST
SORT_ORDER
INT
GUID | UNIQUEIDENTIFIER |
| |
| CLIENT | INT |
|
|
WEB_CP_EVAL_WORKFLOW_DEFINITION
INTERFACE | VARCHAR(10) |
|
|
API | NVARCHAR(32) |
|
|
WEB_CP_EVAL_WORKFLOW
API_NAME | NVARCHAR(64) |
|
|
WEB_CP_EVAL_WORKFLOW
KEY_PREFIX | VARCHAR(7) |
|
Drop column
| KEY_HASH | VARCHAR(MAX) |
|
|
WEB_CP_EVAL_WORKFLOWSTAGES
STAGE_TYPE
Drop column
WEB_CP_EVAL_WORKFLOWSTAGES
DELETEDDATE
SCOPES | VARCHAR(MAX) |
| |
| DATECREATED | DATETIME |
|
|
|
|
|
WEB_CP_ |
EVALUEE_SCORE
INT
RELIEVER | IS_PASSIVE |
| Rename column IS_ACTIVE |
|
|
|
|
WEB_CP_EVAL_ |
DOCUMENTS |
|
|
Add column
WEB_CP_EVAL_ANSWERS
EVALUEE_CALCULATED_SCORE
DECIMAL(7,4)
Add column
WEB_CP_EVAL_ANSWERS
New table | |||
| SECTION_SCORES_JSON | NVARCHAR(MAX) |
|
| EVALUATOR_TOTAL_SCORE | DECIMAL(7,4) |
| |||
|
|
|
|
WEB_CP_EVAL_DOCUMENTS
| EVALUEE_TOTAL_SCORE |
DECIMAL(7,4)
| Rename column TOTAL_SCORE |
...
Other Versions
...
| Page Properties Report | ||
|---|---|---|
|