Table Detail Report
DM_REFCHG_FILTER_PARM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Data Management reference change PK where function parameters |
Definition: |
Stores the parameters which will be used in the REFCHG_FILTER_ |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_FILTER_PARM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
COLUMN_NAME | VARCHAR(30) | N | Name of the column that needs to be passed into the REFCHG_PK_WHERE* function. |
PARM_NBR | DOUBLE | N | Order that this column needs to be placed when call the REFCHG_PK_WHERE* function. |
TABLE_NAME | VARCHAR(30) | N | Name of the table which has a filter requirement on it. |
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. |
Relationship Detail - DM_REFCHG_FILTER_PARM
Child Column in DM_REFCHG_FILTER_PARM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TABLE_NAME | DM_REFCHG_FILTER | TABLE_NAME |
DM_REFCHG_FILTER_TEST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Data Management reference change filter tests |
Definition: |
Stores the various tests that should be performed to see if a row for the given table should be recorded for RDDS. The tests could be simple comparison (like |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_FILTER_TEST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
MOVER_STRING | VARCHAR(1000) | N | A filter string the mover uses when interacting with the table. |
STATEMENT_IND | DOUBLE | N | Indicates if this test is a statement like a Select. |
TABLE_NAME | VARCHAR(30) | N | Name of the table which has a filter requirement on it. |
TEST_NBR | DOUBLE | N | Sequence number for PK |
TEST_STR | VARCHAR(2000) | N | Testing text to be used for filtering. Input variable will have :: around them. |
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. |
Relationship Detail - DM_REFCHG_FILTER_TEST
Child Column in DM_REFCHG_FILTER_TEST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TABLE_NAME | DM_REFCHG_FILTER | TABLE_NAME |
DM_REFCHG_INSTRUCTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Database Management Reference Change Instruction |
Definition: | This table will store instructions to aid in the RDDS process |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_INSTRUCTION
Column Name | Type | Null? | Definition |
---|---|---|---|
AUTHORIZED_IND | DOUBLE | N | Indicates if the instruction was reviewed/tested by Cerner |
DESCRIPTION | VARCHAR(500) | N | Holds the description of what instruction does |
DM_REFCHG_INSTRUCTION_ID | DOUBLE | N | Primary Key for table |
INSTRUCTION_TEXT_ID | DOUBLE | N | Points to the LONG_TEXT_ID holding the instruction |
INS_MEANING | VARCHAR(50) | N | Name of instruction, and alternate key |
RUN_ORDER | DOUBLE | Y | Indicates the order in which instructions should run within a given run time. |
RUN_TIME_FLAG | DOUBLE | N | Indicates when the instruction runs |
TABLE_NAME | VARCHAR(30) | Y | Holds what table name is affected by instruction. Can be blank |
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. |
Relationship Detail - DM_REFCHG_INSTRUCTION
Child Column in DM_REFCHG_INSTRUCTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INSTRUCTION_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
DM_REFCHG_INVALID_XLAT
Column Section | Top of Page |
Table-level Detail
Description: | Database Management REFCHG Invalid Translations table |
Definition: | Table for RDDS to track deleted reference values |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_INVALID_XLAT
Column Name | Type | Null? | Definition |
---|---|---|---|
PARENT_ENTITY_ID | DOUBLE | N | Primary Key ID of the row deleted from table identified in PARENT_ENTITY_NAME |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Name of the table that had a row deleted. |
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. |
DM_REFCHG_OBJECT_CHECK
Column Section | Top of Page |
Table-level Detail
Description: | Data Management reference change object checks |
Definition: | Stores the various dependency checks that should be performed to see if a pl/sql object is able to be compiled |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_OBJECT_CHECK
Column Name | Type | Null? | Definition |
---|---|---|---|
CHECK_COLUMN | VARCHAR(30) | N | Represents the column name to check for |
CHECK_TABLE | VARCHAR(30) | N | Represents the table name to check for |
DM_REFCHG_OBJECT_CHECK_ID | DOUBLE | N | Primary Key for table |
OBJECT_NAME | VARCHAR(30) | N | Contains Object name to run checks on |
OBJECT_NBR | DOUBLE | N | Contest object number to run checks on |
OBJECT_TYPE | VARCHAR(30) | N | Displays the type of pl/sql object to check |
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. |