...
Database Modifications
...
New and Modified Tables
Table | FieldName | FieldType | Description |
WEB_CP_ |
INSTANCE_ID
EVAL_RULE | SCHEDULE_CORRECTION_EMPLOYEE | INT | Add column |
WEB_CP_EVAL_RULE | SCHEDULE_POINT_EMPLOYEE | INT | Add column |
WEB_CP_ |
EVAL_ |
RULE | REPEAT_ |
ENABLED |
SUMMARY
NVARCHAR(1000)
Change field type
BIT | Add column | ||
WEB_CP_EVAL_RULE | REPEAT_ENABLED_EMPLOYEE | BIT | Add column |
WEB_CP_EVAL_ |
RULE |
COMMENT
REPEAT_EVERY | INT | Add column |
PWWAITINGROOM
Recreate table
INTERFACE
NVARCHAR(16)
ENDPOINT
NVARCHAR(50)
EXTERNAL_PIN
NVARCHAR(100)
EXTERNAL_SEQNO
NVARCHAR(200)
EXTERNAL_SEQNO_TEXT
NVARCHAR(200)
PIN
INT
NAME
VARCHAR(100)
ERROR
NVARCHAR(MAX)
SOLUTION
NVARCHAR(MAX)
REQUEST
NVARCHAR(MAX)
REQUEST_DATE
DATETIME
PW001P00_XREF
Recreate table
INTERFACE_XREF
VARCHAR(10)
TABLE_REF
INT
SEQUENCENO_REF
INT
SEQUENCENO_XREF
VARCHAR(200)
COMMENT
NVARCHAR(100)
WEB_CP_EVAL_RULE | REPEAT_EVERY_EMPLOYEE | INT | Add column |
WEB_CP_EVAL_RULE | REPEAT_UNTIL | DATETIME | Add column |
WEB_CP_EVAL_RULE | REPEAT_UNTIL_EMPLOYEE | DATETIME | Add column |
WEB_CP_EVAL_RULE
| SCHEDULE_CORRECTION | INT | Updated type to nullable
|
|
|
|
|
WEB_CP_TIMECARD_DAILY_CORRECTION | OPERATION_TYPE | VARCHAR(1) | Add column |
WEB_CP_TIMECARD_DAILY_CORRECTION | CHECKED_BY_USER | BIT | Add column |
WEB_CP_TIMECARD_DAILY_CORRECTION | IS_RECORD_DELETED |
| Drop column |
WEB_CP_TIMECARD_DAILY_CORRECTION | REJECTED_BY_USER |
| Drop column |
|
|
|
|
WEB_CP_API_KEYS |
|
|
New table | |||
| GUID | UNIQUEIDENTIFIER |
|
| CLIENT | INT |
|
| INTERFACE | VARCHAR(10) |
|
| API | NVARCHAR(32) |
|
| API_NAME | NVARCHAR(64) |
|
| KEY_PREFIX | VARCHAR(7) |
|
| KEY_HASH | VARCHAR(MAX) |
| |||
| DATECREATED | DATETIME |
|
|
|
|
|
WEB_CP_API_KEY_SCOPES |
|
| New table |
| API_GUID | UNIQUEIDENTIFIER |
|
| SCOPE | VARCHAR(128) |
|
|
|
|
|
WEB_CP_ADONIS_API_KEYS |
|
| New table |
| APP_CODE | NVARCHAR(32) |
|
| KEY_PREFIX | VARCHAR(7) |
|
| KEY_HASH | VARCHAR(MAX) |
|
|
|
|
|
WEB_CP_EVAL_DOCUMENTS | ACTIVATEDATE
| DATETIME | Add column |
...
Other Versions
...
| Page Properties Report | ||
|---|---|---|
|