Table Detail Report

BR_SETUP_WIZARD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Setup Wizard
Definition: Used for storing Identifiers created in various identifier setup wizards.
Table Type: REFERENCE





Column Detail - BR_SETUP_WIZARD


Column Name Type Null? Definition
BR_SETUP_WIZARD_ID DOUBLE N Unique, generated number that identifies a single row on the BR_SETUP_WIZARD table.
SETUP_IDENT VARCHAR(20) N Represents an identifier for a site, assigned by an outside agency . A site could be a group of facilities, or a floor of a single facility. It could be a specific ambulatory section, or it could be the entire organization. Can encompass several locations.
SETUP_NAME VARCHAR(150) N The name associated with the setup identifier.
SETUP_WIZARD_FLAG DOUBLE N Identifies the setup wizard associated with an outside agency.
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_SETUP_WIZARD




Parent Column in BR_SETUP_WIZARD (PK) Child Table Name Child Column Name
Children: BR_SETUP_WIZARD_ID BR_SETUP_WIZARD_LOC_RELTN BR_SETUP_WIZARD_ID


BR_SETUP_WIZARD_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Setup Wizard Location Relation
Definition: Stores relationships between locations and setup wizards.
Table Type: REFERENCE





Column Detail - BR_SETUP_WIZARD_LOC_RELTN


Column Name Type Null? Definition
BR_SETUP_WIZARD_ID DOUBLE N Identifies the wizard associated with this location.
BR_SETUP_WIZARD_LOC_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_SETUP_WIZARD_LOC_RELTN table.
LOCATION_CD DOUBLE N Identifies the location associated to this setup wizard.
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_SETUP_WIZARD_LOC_RELTN


Child Column in BR_SETUP_WIZARD_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_SETUP_WIZARD_ID BR_SETUP_WIZARD BR_SETUP_WIZARD_ID
LOCATION_CD LOCATION LOCATION_CD


BR_STEP



Column Section Top of Page


Table-level Detail

Description: BEDROCK STEP
Definition: list of Bedrock wizards
Table Type: REFERENCE





Column Detail - BR_STEP


Column Name Type Null? Definition
DEFAULT_SEQ DOUBLE Y order in which the step will display
EST_MIN_TO_COMPLETE DOUBLE N estimated minutes to complete the step
STEP_CAT_DISP VARCHAR(100) Y display name of the step category
STEP_CAT_MEAN VARCHAR(100) Y category of the step (pathnet, core, etc.)
STEP_DISP VARCHAR(100) N front-end display name
STEP_MEAN VARCHAR(100) N short name of step
STEP_TYPE VARCHAR(100) N type of step
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 date/time on which the record was added to the file
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.


BR_STEP_PARAMETER



Column Section Top of Page


Table-level Detail

Description: Bedrock Step Parameter
Definition: Parameters of a Bedrock Step, which represents a Bedrock Wizard entity. The parameters are used as metadata that needs to be defined for that particular Bedrock Step to function as intended by the Bedrock application. Not all Bedrock Steps need parameters defined, therefore this is optional metadata for a Bedrock Step.
Table Type: REFERENCE





Column Detail - BR_STEP_PARAMETER


Column Name Type Null? Definition
BR_STEP_PARAMETER_ID DOUBLE N Unique generated number that identifies a single row on the br_step_parameter table.
PARAMETER_NAME VARCHAR(100) N The name of the step parameter. It is used as the key in the pairing between parameter_name and parameter_value. The name needs to be known to the Bedrock application for it to be used in a meaningful way.
PARAMETER_SEQ DOUBLE N The functional sequence of parameters with the same step_mean. This is an optional field and is only to be used if the sequence is of functional value. Otherwise, the default of 0 should be used.
PARAMETER_VALUE VARCHAR(255) N The value of the step parameter. It is used as the value in the pairing between parameter_name and parameter_value.
STEP_MEAN VARCHAR(100) N Short Name of the step
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.


BR_SVC_ENTITY_REPORT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Service Entity Report Relation
Definition: Stores the relationship between either a CCN or Eligible Provider to a functional measure.
Table Type: REFERENCE





Column Detail - BR_SVC_ENTITY_REPORT_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_DATAMART_REPORT_ID DOUBLE N The functional measure that is being related.
BR_SVC_ENTITY_REPORT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the BR_SVC_ENTITY_REPORT_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.
ORIG_BR_SVC_ENTITY_REPORT_R_ID DOUBLE N Used for versioning. Contains the value of the PK for a particular set of rows in BR_SVC_ENTITY_REPORT_RELTN.
PARENT_ENTITY_ID DOUBLE N The id of the related CCN or Eligible Provider.
PARENT_ENTITY_NAME VARCHAR(32) N Indicates if the related object is a CCN or an Eligible Provider.
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_SVC_ENTITY_REPORT_RELTN


Child Column in BR_SVC_ENTITY_REPORT_RELTN(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_REPORT_ID BR_DATAMART_REPORT BR_DATAMART_REPORT_ID
ORIG_BR_SVC_ENTITY_REPORT_R_ID BR_SVC_ENTITY_REPORT_RELTN BR_SVC_ENTITY_REPORT_RELTN_ID




Parent Column in BR_SVC_ENTITY_REPORT_RELTN (PK) Child Table Name Child Column Name
Children: BR_SVC_ENTITY_REPORT_RELTN_ID BR_SVC_ENTITY_REPORT_RELTN ORIG_BR_SVC_ENTITY_REPORT_R_ID