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 |