CODE_VALUE_ALIAS_MODS
Column Section | Top of Page |
Table-level Detail
Description: | CODE_VALUE_ALIAS CHANGES |
Definition: | Stores references to codes changed on the code_value_alias table |
Table Type: | ACTIVITY |
Column Detail - CODE_VALUE_ALIAS_MODS
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS | VARCHAR(255) | N | Reference to the alias on the CODE_VALUE_ALIAS table which experienced a change (INSERT/UPDATE) |
ALIAS_TYPE_MEANING | VARCHAR(12) | Y | Reference to the alias type meaning on the CODE_VALUE_ ALIAS table which experienced a change (INSERT/UPDATE) |
CODE_SET | DOUBLE | N | Reference to the code set identifier on the CODE_VALUE_ ALIAS table which experienced a change (INSERT/UPDATE) |
CODE_VALUE | DOUBLE | N | Reference to the code value on the CODE_VALUE_ ALIAS table which experienced a change (INSERT/UPDATE) |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | Reference to the Contributor source on the CODE_VALUE_ ALIAS table which experienced a change (INSERT/UPDATE) |
LOGICAL_CNT | DOUBLE | N | Alternate key of the table, used as a logical counter of changes added. It is assumed that each new addition has a value greater than any other identifier on the table. |
LOGICAL_CNT_INDEX | DOUBLE | N | PRIMARY KEY. will populate the column manually using a trigger. We will use this new column to create a simple window of changes. The new column will be calculated using a formula similar to "LOGICAL_CNT MOD x", where x is the size of the window. As a simple example, say we declare x to be 10, meaning we will keep at most 10 items on the table. Once the 11th change is reported, we will go back and overwrite the 1st item. This new column will help us limit the number of rows in the table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
CODE_VALUE_EXTNSN_MODS
Column Section | Top of Page |
Table-level Detail
Description: | CODE_VALUE_EXTENSION CHANGES |
Definition: | Stores references to codes changed on the code_value_extension table |
Table Type: | ACTIVITY |
Column Detail - CODE_VALUE_EXTNSN_MODS
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_SET | DOUBLE | N | Reference to the code set identifier on the CODE_VALUE_EXTENSION table which experienced a change (INSERT/UPDATE) |
CODE_VALUE | DOUBLE | N | Reference to the code value identifier on the CODE_VALUE_EXTENSION table which experienced a change (INSERT/UPDATE) |
FIELD_NAME | VARCHAR(32) | N | Reference to the field name on the CODE_VALUE_EXTENSION table which experienced a change (INSERT/UPDATE) |
LOGICAL_CNT | DOUBLE | N | Alternate key of the table, used as a logical counter of changes added. It is assumed that each new addition has a value greater than any other identifier on the table. |
LOGICAL_CNT_INDEX | DOUBLE | N | PRIMARY KEY. will populate the column manually using a trigger. We will use this new column to create a simple window of changes. The new column will be calculated using a formula similar to "LOGICAL_CNT MOD x", where x is the size of the window. As a simple example, say we declare x to be 10, meaning we will keep at most 10 items on the table. Once the 11th change is reported, we will go back and overwrite the 1st item. This new column will help us limit the number of rows in the table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
CODE_VALUE_GROUP_MODS
Column Section | Top of Page |
Table-level Detail
Description: | CODE_VALUE_GROUP CHANGES |
Definition: | Stores references to codes changed on the code_value_group table |
Table Type: | ACTIVITY |
Column Detail - CODE_VALUE_GROUP_MODS
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_CODE_VALUE | DOUBLE | N | Reference to the child code value identifier on the CODE_VALUE_GROUP table which experienced a change (INSERT/UPDATE) |
LOGICAL_CNT | DOUBLE | N | Alternate Key of the table, used as a logical counter of changes added. It is assumed that each new addition has a value greater than any other identifier on the table. |
LOGICAL_CNT_INDEX | DOUBLE | N | PRIMARY KEY. will populate the column manually using a trigger. We will use this new column to create a simple window of changes. The new column will be calculated using a formula similar to "LOGICAL_CNT MOD x", where x is the size of the window. As a simple example, say we declare x to be 10, meaning we will keep at most 10 items on the table. Once the 11th change is reported, we will go back and overwrite the 1st item. This new column will help us limit the number of rows in the table. |
PARENT_CODE_VALUE | DOUBLE | N | Reference to the parent code value identifier on the CODE_VALUE_GROUP table which experienced a change (INSERT/UPDATE) |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
CODE_VALUE_MODS
Column Section | Top of Page |
Table-level Detail
Description: | CODE_VALUE CHANGES |
Definition: | Stores references to codes changed on the code_value table |
Table Type: | ACTIVITY |
Column Detail - CODE_VALUE_MODS
Column Name | Type | Null? | Definition |
---|---|---|---|
CKI | VARCHAR(255) | Y | Reference to the CKI identifier on the CODE_VALUE table which experienced a change (INSERT/UPDATE) |
CODE_SET | DOUBLE | N | Reference to the CODE_SET value identifier on the CODE_VALUE table which experienced a change (INSERT/UPDATE) |
CODE_VALUE | DOUBLE | N | Reference to the code value identifier on the CODE_VALUE table which experienced a change (INSERT/UPDATE) |
CONCEPT_CKI | VARCHAR(255) | Y | Reference to the CONCEPT CKI identifier on the CODE_VALUE table which experienced a change (INSERT/UPDATE) |
LOGICAL_CNT | DOUBLE | N | Alternate Key of the table, used as a logical counter of changes added. It is assumed that each new addition has a value greater than any other identifier on the table. |
LOGICAL_CNT_INDEX | DOUBLE | N | PRIMARY KEY. will populate the column manually using a trigger. We will use this new column to create a simple window of changes. The new column will be calculated using a formula similar to "LOGICAL_CNT MOD x", where x is the size of the window. As a simple example, say we declare x to be 10, meaning we will keep at most 10 items on the table. Once the 11th change is reported, we will go back and overwrite the 1st item. This new column will help us limit the number of rows in the table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
CODE_VALUE_OUTBOUND_MODS
Column Section | Top of Page |
Table-level Detail
Description: | CODE_VALUE_OUTBOUND CHANGES |
Definition: | Stores references to codes changed on the code_value_outbound table |
Table Type: | ACTIVITY |
Column Detail - CODE_VALUE_OUTBOUND_MODS
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS_TYPE_MEANING | VARCHAR(12) | Y | Reference to the alias type meaning on the CODE_VALUE_ OUTBOUND table which experienced a change (INSERT/UPDATE) |
CODE_VALUE | DOUBLE | N | Reference to the code value identifier on the CODE_VALUE_OUTBOUND table which experienced a change (INSERT/UPDATE) |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | Reference to the Contributor source on the CODE_VALUE_ OUTBOUND table which experienced a change (INSERT/UPDATE) |
LOGICAL_CNT | DOUBLE | N | Alternate Key of the table, used as a logical counter of changes added. It is assumed that each new addition has a value greater than any other identifier on the table. |
LOGICAL_CNT_INDEX | DOUBLE | N | PRIMARY KEY. will populate the column manually using a trigger. We will use this new column to create a simple window of changes. The new column will be calculated using a formula similar to "LOGICAL_CNT MOD x", where x is the size of the window. As a simple example, say we declare x to be 10, meaning we will keep at most 10 items on the table. Once the 11th change is reported, we will go back and overwrite the 1st item. This new column will help us limit the number of rows in the table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |