Table Detail Report

BR_CAT_EVENT_NORMALCY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Multiple Drug Resistance Organism Category Event Normalcy
Definition: Stores related Event Code and Normalcy Code information, used in Multiple Drug Resistance Organisms (MDRO) Bedrock Wizard.
Table Type: REFERENCE





Column Detail - BR_CAT_EVENT_NORMALCY


Column Name Type Null? Definition
BR_CAT_EVENT_NORMALCY_ID DOUBLE N Unique generated number that identifies a single row on the BR_CAT_EVENT_NORMALCY table.
BR_MDRO_CAT_EVENT_ID DOUBLE N The event that this normalcy code is related to.
NORMALCY_CD DOUBLE N "CODE SET: 52 Stores Code value of the Normalcy Codes associated with this Event Code."
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 - BR_CAT_EVENT_NORMALCY


Child Column in BR_CAT_EVENT_NORMALCY(FK) Parent Table Name Parent Column Name
Parents: BR_MDRO_CAT_EVENT_ID BR_MDRO_CAT_EVENT BR_MDRO_CAT_EVENT_ID


BR_CCN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock CMS Certification Number
Definition: Stores information about CMS Certification Numbers, which are unique identifiers given to hospitals by the Centers for Medicare and Medicaid Services that identify the site that is submitting data to them.
Table Type: REFERENCE





Column Detail - BR_CCN


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_CCN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_CCN table.
CCN_NAME VARCHAR(150) N Stores the name associated to the CCN.
CCN_NBR DOUBLE N *** OBSOLETE ***
CCN_NBR_TXT VARCHAR(150) N Stores the CCN's identifying number.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ORIG_BR_CCN_ID DOUBLE N Used for versioning. The original BR_CCN_ID value.
TAX_ID_NBR_TXT VARCHAR(50) N Stores the tax id number associated to the CCN.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BR_CCN


Child Column in BR_CCN(FK) Parent Table Name Parent Column Name
Parents: ORIG_BR_CCN_ID BR_CCN BR_CCN_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in BR_CCN (PK) Child Table Name Child Column Name
Children: BR_CCN_ID BR_CCN ORIG_BR_CCN_ID
BR_CCN_EXTENSION BR_CCN_ID
BR_CCN_LOC_RELTN BR_CCN_ID
BR_PRSNL_CCN_RELTN BR_CCN_ID


BR_CCN_EXTENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock CMS Certification Number Extension
Definition: Contains attributes of a CCN that require history to be kept.
Table Type: REFERENCE





Column Detail - BR_CCN_EXTENSION


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_CCN_EXTENSION_ID DOUBLE N Unique generated number that identifies a single row on the BR_CCN_EXTENSION table.
BR_CCN_ID DOUBLE N Identifies the CCN that is the main source for the data on this table.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MEDICAID_STAGE_CD DOUBLE N Stores the stage and year for the Medicaid program enrollment
MEDICARE_YEAR DOUBLE Y The effective year for the Medicare program associated to this CCN
ORIG_BR_CCN_EXTENSION_ID DOUBLE N The PK value of the Original (Effective) Row for this versioned set
PROGRAM_TYPE_TXT VARCHAR(50) N Identifies what type of program this CCN is associated to.
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 - BR_CCN_EXTENSION


Child Column in BR_CCN_EXTENSION(FK) Parent Table Name Parent Column Name
Parents: BR_CCN_ID BR_CCN BR_CCN_ID
ORIG_BR_CCN_EXTENSION_ID BR_CCN_EXTENSION BR_CCN_EXTENSION_ID




Parent Column in BR_CCN_EXTENSION (PK) Child Table Name Child Column Name
Children: BR_CCN_EXTENSION_ID BR_CCN_EXTENSION ORIG_BR_CCN_EXTENSION_ID


BR_CCN_LOC_PTSVC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock DMS Certification Number Location Point of Service Relation
Definition: Stores point of service information associated to locations that are associated to CCNs.
Table Type: REFERENCE





Column Detail - BR_CCN_LOC_PTSVC_RELTN


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_CCN_LOC_PTSVC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_CCN_LOC_PTSVC_RELTN table.
BR_CCN_LOC_RELTN_ID DOUBLE N The Location and CCN that this Point of Service Code and Encounter Type pertain to.
ENCNTR_TYPE_CD DOUBLE N Stores the encounter associated encounter type. The combination of point of service, encounter type, and location drive how the data is submitted to CMS.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ORIG_BR_CCN_LOC_PTSVC_R_ID DOUBLE N Used for versioning. Contains the original PK from BR_CCN_LOC_PTSVC_RELTN
PTSVC_CODE_NBR DOUBLE N Stores the point of service code used on professional claims to specify the entity where service(s) were rendered.
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 - BR_CCN_LOC_PTSVC_RELTN


Child Column in BR_CCN_LOC_PTSVC_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORIG_BR_CCN_LOC_PTSVC_R_ID BR_CCN_LOC_PTSVC_RELTN BR_CCN_LOC_PTSVC_RELTN_ID
BR_CCN_LOC_RELTN_ID BR_CCN_LOC_RELTN BR_CCN_LOC_RELTN_ID




Parent Column in BR_CCN_LOC_PTSVC_RELTN (PK) Child Table Name Child Column Name
Children: BR_CCN_LOC_PTSVC_RELTN_ID BR_CCN_LOC_PTSVC_RELTN ORIG_BR_CCN_LOC_PTSVC_R_ID


BR_CCN_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock CMS Certification Number Location Relation
Definition: Stores locations associated to a CMS Certification Number.
Table Type: REFERENCE





Column Detail - BR_CCN_LOC_RELTN


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BR_CCN_ID DOUBLE N Identifies the CCN that is associated to this location.
BR_CCN_LOC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_CCN_LOC_RELTN table.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LOCATION_CD DOUBLE N The location associated to this CMS Certification Number.
ORIG_BR_CCN_LOC_RELTN_ID DOUBLE N Used for versioning. Contains the original PK value for BR_CCN_LOC_RELTN.
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 - BR_CCN_LOC_RELTN


Child Column in BR_CCN_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_CCN_ID BR_CCN BR_CCN_ID
ORIG_BR_CCN_LOC_RELTN_ID BR_CCN_LOC_RELTN BR_CCN_LOC_RELTN_ID
LOCATION_CD LOCATION LOCATION_CD




Parent Column in BR_CCN_LOC_RELTN (PK) Child Table Name Child Column Name
Children: BR_CCN_LOC_RELTN_ID BR_CCN_LOC_PTSVC_RELTN BR_CCN_LOC_RELTN_ID
BR_CCN_LOC_RELTN ORIG_BR_CCN_LOC_RELTN_ID