...
| Page Properties | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Database Modifications
...
New and Modified Tables
Table | FieldName | FieldType | Description |
WEB_CP_EVAL_ANSWERS
PWWAITINGROOM |
|
|
Drop column
WEB_CP_EVAL_ANSWERS
COMMENT_EVALUATEE
NVARCHAR(MAX)
Add column
WEB_CP_EVAL_ANSWERS
COMMENT_EVALUATOR
NVARCHAR(MAX)
Add column
New table | |||
| INTERFACE | VARCHAR(16) |
|
| EXTERNAL_PIN | VARCHAR(100) |
|
| ENDPOINT | VARCHAR(50) |
|
|
PIN | INT |
|
|
NAME | VARCHAR(100) |
|
|
SEQNO
ERROR | NVARCHAR(MAX) |
|
|
REQUEST |
NVARCHAR( |
MAX) |
|
|
REQUEST_ |
DATE |
DATETIME |
|
|
|
int
|
|
PW001P00_ |
XREF |
|
| New table |
|
INTERFACE_ |
XREF |
VARCHAR( |
10) |
|
| TABLE_REF |
INT |
|
|
WEB_CP_EVAL_RULE
SEQUENCENO_REF | INT |
|
|
WEB_CP_EVAL_RULE
TEMPLATE_CODE
varchar(10)
Add column
WEB_CP_EVAL_RULE_RANKS
New table
RULEID
int
RANKCODE
varchar(10)
CODE
varchar(10)
WEB_CP_EVAL_DOCUMENTS
DATETIME
DATETIME
Change field type
WEB_CP_EVAL_RULE
WORKFLOWDEF_ID
INT
Add column
WEB_CP_EVAL_WORKFLOW_DEFINITION
New table
WORKFLOWDEF_ID
int
NAME
NVARCHAR(255)
DELETEDDATE
DATETIME
WEB_CP_EVAL_WORKFLOWSTAGES
New table
STAGE_ID
INT
WORKFLOWDEF_ID
INT
NAME
NVARCHAR(255)
STAGE_TYPE
INT
STAGE_STEP
INT
PREVIOUS_STAGE
NVARCHAR(255)
NEXT_STAGE
NVARCHAR(255)
STATUS_TEXT
NVARCHAR(255)
DELETEDDATE
NVARCHAR(MAX)
WEB_CP_EVAL_WORKFLOW
New table
EVALW_ID
int
DOCUMENT_ID
int
STAGE_ID
int
STEP
int
BASISWORKFLOW
NVARCHAR(255)
DELETEDDATE
DATETIME
WEB_CP_ACTIVITIES_PRIORITY
New table
CODE
varchar(10)
PRIORITY
int
WEB_CP_EVAL_WORKFLOW_DEFINITION
CODE
VARCHAR(10)
Change field type
WEB_CP_EVAL_WORKFLOWSTAGES
CODE
VARCHAR(10)
Change field type
WEB_CP_EVAL_WORKFLOWSTAGES
EVALUATOR_TIMELINE_TEXT
NVARCHAR(MAX)
New column
WEB_CP_EVAL_WORKFLOWSTAGES
EVALUAEE_TIMELINE_TEXT
NVARCHAR(MAX)
SEQUENCENO_XREF | VARCHAR(200) |
| |
| COMMENT | NVARCHAR(100) |
|
|
|
|
|
WEB_CP_EVAL_WORKFLOWSTAGES | IS_SHOW_ |
SECTION_ |
SCORE | BIT |
Add column | |
WEB_CP_EVAL_WORKFLOWSTAGES | IS_ |
BIT
New column
WEB_CP_EVAL_WORKFLOWSTAGES
SHOW_EVALUEE_QUESTION_SCORE | BIT |
New column
Add column |
WEB_CP_ |
DEFAULT_SON
EVAL_WORKFLOWSTAGES | IS_SHOW_EVALUATOR_QUESTION_SCORE | BIT | Add column |
WEB_CP_ |
EVAL_ |
WORKFLOWSTAGES | IS_ |
SHOW_ |
TOTAL_ |
SCORE |
BIT |
Add column | |||
|
|
|
|
WEB_CP_EVAL_ |
DOCUMENTS |
EVALUETION_FORM_ |
INT
Change field type
CODE |
|
Drop column |
WEB_CP_EVAL_ |
DOCUMENTS |
DESCRIPTION |
|
Drop column | |||
|
|
|
|
WEB_CP_EVAL_WORKFLOW_ |
AR_EVALAUEE_EVALUAEE
VARCHAR(10)
New column
DEFINITION | CREATED | DATETIME | Add column |
|
|
|
|
WEB_CP_EVAL_SECTION_ |
QUEST |
SORT_ |
VARCHAR(10)
New column
WEB_CP_EVAL_WORKFLOWSTAGES
AR_EVALAUTOR_EVALUAEE
VARCHAR(10)
ORDER | INT | Add column | |
|
|
|
|
WEB_CP_EVAL_WORKFLOW_ |
AR_EVALAUTOR_EVALAUTOR
VARCHAR(10)
DEFINITION | DELETEDDATE |
| Drop column |
|
|
|
|
WEB_CP_EVAL_ |
ETAG
VARCHAR(100)
WORKFLOW | DELETEDDATE |
|
Drop column |
WEB_CP_ |
EVAL_ |
DEFAULT_FOR_ROSTER
bit
WORKFLOW | BASISWORKFLOW |
| Drop column |
|
|
|
|
WEB_CP_EVAL_ |
WORKFLOWSTAGES |
STATUS
NVARCHAR(255)
STAGE_TYPE |
| Drop column |
WEB_CP_EVAL_ |
WORKFLOWSTAGES |
DELETEDDATE |
|
Drop column | ||
|
|
|
| |||
WEB_CP_EVAL_ANSWERS | EVALUEE_SCORE | INT | Add column |
WEB_CP_EVAL_ |
ANSWERS |
EVALUATOR_ |
SCORE |
INT |
Add column |
WEB_CP_EVAL_ |
ANSWERS |
EVALUEE_CALCULATED_ |
DATETIME
SCORE | DECIMAL(7,4) | Add column |
WEB_CP_EVAL_ |
ANSWERS |
EVALUATOR_CALCULATED_ |
SCORE |
DECIMAL( |
7,4) |
Add column | |||
|
|
|
|
WEB_CP_EVAL_DOCUMENTS | TOTAL_SCORE | DECIMAL(7,4) | Add column |
...
Other Versions
...
| Page Properties Report | ||
|---|---|---|
|