To read more about our different types of releases (main release, intermediate release), click me!
Important
1) From release 2021.10 Internet Explorer (IE) is not supported.
2) Before the upgrade, records from the repl_Task table with IDs 3000-4999 that are not related to WEB_CP tables should be deleted manually (see APP-3082 in APP 2021.10 release notes)
Adonis Personnel Portal Compatibility Matrix
APP Version | Compatible APM Version |
2020.60.x, 2021.10. x, 2021.20. x, 2021.30. x, 2021.40. x, 2022.10. x, 2022.20. x 2022.30. x 2023.10. x | APM 2020.10.x and newer version |
fds
Database Modifications
New and Modified Tables
Table | FieldName | FieldType | Description |
WEB_CP_EVAL_ANSWERS | SELECTED_ANSWER |
| Drop column |
WEB_CP_EVAL_ANSWERS | COMMENT_EVALUATEE | NVARCHAR(MAX) | Add column |
WEB_CP_EVAL_ANSWERS | COMMENT_EVALUATOR | NVARCHAR(MAX) | Add column |
|
|
|
|
WEB_CP_EVAL_RULE |
|
| New table |
| SEQNO | int |
|
| CODE | varchar(10) |
|
| TEMPLATE_SEQNO | int |
|
| SCHEDULE_POINT | int |
|
| SCHEDULE_CORRECTION | int |
|
| SQL_STATEMENT | NVARCHAR(MAX) |
|
|
|
|
|
WEB_CP_EVAL_RULE | TEMPLATE_SEQNO |
| Drop column |
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) | New column |
WEB_CP_EVAL_WORKFLOWSTAGES | IS_READONLY_EVALUAEE | BIT | New column |
WEB_CP_EVAL_WORKFLOWSTAGES | IS_SUBMIT_EVALUAEE | BIT | New column |
WEB_CP_EVAL_WORKFLOWSTAGES | IS_SHOW_COMMENT | BIT | New column |
|
|
|
|
WEB_CP_GRATUITY_SIGONOFF_RULE_ACTIVATION | DEFAULT_SON |
| Drop column |
WEB_CP_GRATUITY_SIGONOFF_RULE_ACTIVATION | DEFAULT_SOF |
| Drop column |
|
|
|
|
WEB_CP_EVAL_WORKFLOWSTAGES | STAGE_STEP | INT | Change field type |
|
|
|
|
WEB_CP_EVAL_SECTIONS | WEIGHT | INT | New column |
|
|
|
|
WEB_CP_EVAL_WORKFLOWSTAGES | AR_EVALAUEE_EVALUAEE | VARCHAR(10) | New column |
WEB_CP_EVAL_WORKFLOWSTAGES | AR_EVALUAEE_EVALAUTOR | VARCHAR(10) | New column |
WEB_CP_EVAL_WORKFLOWSTAGES | AR_EVALAUTOR_EVALUAEE | VARCHAR(10) | New column |
WEB_CP_EVAL_WORKFLOWSTAGES | AR_EVALAUTOR_EVALAUTOR | VARCHAR(10) | New column |
|
|
|
|
WEB_CP_GRATUITYPOS | ETAG | VARCHAR(100) | Change field type |
|
|
|
|
WEB_CP_REPORT_SETTINGS | DEFAULT_FOR_ROSTER | bit | New column |
|
|
|
|
WEB_CP_EVAL_DOCUMENTS | STATUS | NVARCHAR(255) | New column |
WEB_CP_EVAL_DOCUMENTS | DATETIME | DATETIME | New column |
|
|
|
|
WEB_CP_EVAL_WORKFLOWSTAGES | IS_ALLOW_REJECT | BIT | New column |
|
|
|
|
WEB_CP_EVAL_WORKFLOW | CREATION_DATE | DATETIME | New column |
WEB_CP_EVAL_WORKFLOW | ANSWERS_JSON | NVARCHAR(MAX) | New column |
|
|
|
Other Versions
