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.