Table Detail Report
DM_REFCHG_PKW_PARM
Column 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_PK_WHERE_ |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_PKW_PARM
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
DM_REFCHG_PKW_VERS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM REFCHG PKW VRS |
Definition: | Contains versions of RDDS PK_WHERE string for each table it tracks. |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_PKW_VERS
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. |
DM_REFCHG_PKW_VERS_ID | DOUBLE | N | Unique identifier of table |
PKW_FORMAT | VARCHAR(1000) | Y | Format of what a RDDS PK_where should look like for an insert or update on the table_name. |
TABLE_NAME | VARCHAR(30) | N | Name of table that we are storing PK_where formats for. |
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_PKW_VERS
Parent Column in DM_REFCHG_PKW_VERS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DM_REFCHG_PKW_VERS_ID | DM_CHG_LOG | DM_REFCHG_PKW_VERS_ID |
DM_REFCHG_PREFDIR_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Database Architecture Refchg Prefdir Data |
Definition: | Stores information used to correctly translate preferences that require custom logic |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_PREFDIR_DATA
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. |
DIST_NAME | VARCHAR(2000) | N | Holds the reference string for the preference |
DIST_NAME_SHORT | VARCHAR(255) | N | Short version of DIST_NAME for building indexes on this field. |
DM_REFCHG_PREFDIR_DATA_ID | DOUBLE | N | Primary Key for table ( Sequence for PK will be controlled and shipped from Cerner - no sequence assigned ) |
ENTRY_DATA | VARCHAR(2000) | N | Data associated to the DIST_NAME. |
MERGE_ALG | VARCHAR(10) | N | Holds the merge algorithm that should be used |
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_PREFDIR_DATA
Parent Column in DM_REFCHG_PREFDIR_DATA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DM_REFCHG_PREFDIR_DATA_ID | DM_REFCHG_PREFDIR_DATA_EXCL | DM_REFCHG_PREFDIR_DATA_ID |
DM_REFCHG_PREFDIR_DATA_EXCL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Database Architecture Refchg Prefdir Data Exclusions |
Definition: | Stores information used to exclude certain overrides in DM_REFCHG_PREFDIR_DATA from certain preferences. |
Table Type: | REFERENCE |
Column Detail - DM_REFCHG_PREFDIR_DATA_EXCL
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. |
DIST_NAME_EXCLUDE | VARCHAR(2000) | N | Holds the exclusion string |
DM_REFCHG_PREFDIR_DATA_EXCL_ID | DOUBLE | N | Primary Key for table. Does not use a standard Oracle sequence - Controlled and shipped from in-house (exception_flg = 1) |
DM_REFCHG_PREFDIR_DATA_ID | DOUBLE | N | Holds the reference back to the PK of the DM_REFCHG_PREFDIR_DATA Does not use a standard Oracle Sequence - Controlled and shipped from in-house (exception_flg = 1) |
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_PREFDIR_DATA_EXCL
Child Column in DM_REFCHG_PREFDIR_DATA_EXCL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DM_REFCHG_PREFDIR_DATA_ID | DM_REFCHG_PREFDIR_DATA | DM_REFCHG_PREFDIR_DATA_ID |
DM_REFCHG_PROCESS
Column Section | Top of Page |
Table-level Detail
Description: | Data Management REFCHG Processes |
Definition: | This table will be used to track RDDS Processes |
Table Type: | ACTIVITY |
Column Detail - DM_REFCHG_PROCESS
Column Name | Type | Null? | Definition |
---|---|---|---|
DM_REFCHG_PROCESS_ID | DOUBLE | N | Primary Key of table |
ENV_SOURCE_ID | DOUBLE | N | The source environment where the process is grabbing data from |
LAST_ACTION_DT_TM | DATETIME | Y | The last time/date that the process running hit a check point. |
LOG_FILE | VARCHAR(80) | Y | Log File of Process that is running |
PROCESS_NAME | VARCHAR(12) | N | Current Process value from V$Session |
RDBHANDLE_VALUE | DOUBLE | N | Current RDBHANDLE of session |
REFCHG_STATUS | VARCHAR(20) | Y | Status of Process. The status that the process is currently in (Starting, In Process, Finished, etc.) |
REFCHG_TYPE | VARCHAR(20) | N | The type of process that is being run (RDDS MOVER, RDDS CUTOVER, etc.) |
SERIAL_NUMBER | DOUBLE | N | SERIAL# from GV$SESSION for process |
SESSION_SID | DOUBLE | N | SID from GV$SESSION for process |
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. |