Table Detail Report

BR_SCH_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Scheduling Template
Definition: This table is the primary table for storing imported default schedule information from the data collection worksheet. We'll store info from the worksheet in this working table where the wizard will read each template in & let the user of the wizard validate the data & turn it into the Millennium equivalent
Table Type: REFERENCE





Column Detail - BR_SCH_TEMPLATE


Column Name Type Null? Definition
APPLY_BEG_DT_TM DATETIME Y Future Use.
APPLY_BEG_DT_TM_STRING VARCHAR(40) Y Future Use.
APPLY_END_DT_TM DATETIME Y Future Use.
APPLY_END_DT_TM_STRING VARCHAR(40) Y Future Use.
APPLY_OCCURRENCES_STR VARCHAR(5) N The number of times that this template should be applied.
APPLY_RANGE DOUBLE Y apply range column
APPLY_RANGE_STR VARCHAR(40) Y apply range string column
BR_CLIENT_ID DOUBLE N *** OBSOLETE *** Identifies which bedrock client data belongs to
BR_SCH_TEMPLATE_ID DOUBLE N The primary index and unique identifier for this table.
DAYBEGIN DOUBLE N The numeric value of the time of day the day begins for this template. (0900).
DAYBEGIN_STR VARCHAR(40) Y The string display value of the time of day the day begins for this template. Stored as a string in case a non-numeric character was entered by accident & the day begin time couldn't be defaulted.
DAYEND DOUBLE N The numeric value of the time of day the day ends for this template (1700).
DAYEND_STR VARCHAR(40) Y The string display value of the time of day the day ends for this template. Stored as a string in case a non-numeric character was entered by accident & the day end time couldn't be defaulted.
DAYOFWEEK VARCHAR(10) Y A string showing which days of the week this template will be applied. For example, "MWF" or "M". Valid values are Sun-Sat are UMTWHFS.
DEF_SCHED_ID DOUBLE N Once resolved, the default schedule ID that was generated is stamped here.
IMPORT_NAME VARCHAR(100) N If more than one set of data will be imported, this column can be used to identify each set. Typically, it'll be a formatted date, but it can be anything and is a column in the data collection spreadsheet.
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.
MONTH_OPT1_DATESOFMONTH VARCHAR(100) N For the monthly application option 1, this string field stores the dates of the month that this template should be applied.
MONTH_OPT1_NBROFMONTHS VARCHAR(5) N For the monthly application option 1, this string field stores the number of months that this template should be applied.
MONTH_OPT2_DAYSOFWEEK VARCHAR(10) N For the monthly application option 2, this string field stores the days of the week that this template should be applied.
MONTH_OPT2_NBROFMONTHS VARCHAR(5) N For the monthly application option 2, this string field stores the number of months that this template should be applied.
MONTH_OPT2_WEEKSOFMONTH VARCHAR(10) N For the monthly application option 2, this string field stores the weeks of the month that this template should be applied.
NEW_FORMAT_IND DOUBLE N The number of times that this template should be applied.
TEMPLATE_NAME VARCHAR(100) N The name of the default schedule template.
TEMPLATE_STATUS_FLAG DOUBLE N Stores the status of the template. Zero is the default and means unresolved. Anything greater than zero means its been either resolved or deleted.
UK_DATE_FORMAT_STR VARCHAR(5) N This string field stores the reply to the UK date format field.
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.
WEEKOFMONTH VARCHAR(10) Y A string showing the weeks of the month that this template will be applied. Every week is "12345". Every other week is "135". Only the first week is "1". Etc.
WEEK_OPT_DAYSOFWEEK VARCHAR(10) N For the weekly application option, this string field stores the days of week that this template should be applied.
WEEK_OPT_NBROFWEEKS VARCHAR(5) N For the weekly application option, this string field stores the number of weeks that this template should be applied.
YEAR_OPT1_DATESOFMONTH VARCHAR(100) N For the yearly application option 1, this string field stores the dates of the month that this template should be applied.
YEAR_OPT1_MONTHSOFYEAR VARCHAR(50) N For the yearly application option 1, this string field stores the months of the year that this template should be applied.
YEAR_OPT2_DAYSOFWEEK VARCHAR(10) N For the yearly application option 2, this string field stores the days of week that this template should be applied.
YEAR_OPT2_MONTHSOFYEAR VARCHAR(50) N For the yearly application option 2, this string field stores the months of the year that this template should be applied.
YEAR_OPT2_WEEKSOFMONTH VARCHAR(10) N For the yearly application option 2, this string field stores the weeks of the month that this template should be applied.



Relationship Detail - BR_SCH_TEMPLATE




Parent Column in BR_SCH_TEMPLATE (PK) Child Table Name Child Column Name
Children: BR_SCH_TEMPLATE_ID BR_SCH_TEMP_RES_R BR_SCH_TEMPLATE_ID
BR_SCH_TEMP_SLOT_R BR_SCH_TEMPLATE_ID


BR_SCH_TEMP_RES_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR_SCH_TEMP_RES_R
Definition: Stores the resources from the a data collection spreadsheet associated with a default schedule template (on the BR_SCH_TEMPLATE table).
Table Type: REFERENCE





Column Detail - BR_SCH_TEMP_RES_R


Column Name Type Null? Definition
APPLY_BEGIN_DT_TM DATETIME Y The internal date representation of the apply_begin_str if it contains a date in the expected format.
APPLY_BEGIN_STR VARCHAR(40) Y A string containing the day that this resource should start having the template applied to its' schedule. Format mm/dd/yyyy
APPLY_END_DT_TM DATETIME Y The internal date representation of the apply_begin_str if it contains a date in the expected format.
APPLY_END_STR VARCHAR(40) Y A string containing the day that this resource should stop having the template applied to its' schedule. Format mm/dd/yyyy
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
BR_SCH_TEMPLATE_ID DOUBLE N The id of the template that this resource row is associated with.
BR_SCH_TEMP_RES_R_ID DOUBLE N Primary index and unique identifier for rows on this table.
RESOURCE_CD DOUBLE N If the resource_name matched up with a valid sch_resource during the import, the code value of the resource will be here.
RESOURCE_NAME VARCHAR(100) N The name of the resource as entered into the data collection worksheet.
RESOURCE_STATUS_FLAG DOUBLE N Future use, values not defined (as of 3/3/06)
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_SCH_TEMP_RES_R


Child Column in BR_SCH_TEMP_RES_R(FK) Parent Table Name Parent Column Name
Parents: BR_SCH_TEMPLATE_ID BR_SCH_TEMPLATE BR_SCH_TEMPLATE_ID


BR_SCH_TEMP_SLOT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BR_SCH_TEMP_SLOT_R
Definition: Stores the various slot types from the default schedule data collection spreadsheet associated with each default schedule in the spreadsheet.
Table Type: REFERENCE





Column Detail - BR_SCH_TEMP_SLOT_R


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N *** OBSOLETE *** Identifies which bedrock client data belongs to
BR_SCH_TEMPLATE_ID DOUBLE N The unique identifier of the template that the slot belongs to.
BR_SCH_TEMP_SLOT_R_ID DOUBLE N The primary index & unique identifier for rows on this table.
INTERVAL DOUBLE Y actual text the user enters as the slot interval on the import
INTERVAL_STR VARCHAR(40) Y user-defined input converted to an integer
SLOT_END DOUBLE N The time of day that the slot ends in numeric format (i.e. 1000)
SLOT_END_STR VARCHAR(40) Y The actual end time from the data collection spreadsheet. Stored in string format in case an invalid entry is made (audit purposes).
SLOT_NAME VARCHAR(100) N The name of the slot from the data collection worksheet.
SLOT_RELEASE_HRS DOUBLE N The number of hours ahead of the slot_start that the slot should be release if not scheduled.
SLOT_RELEASE_TO VARCHAR(100) N If release data is associated with this slot, this will be the name of another slot that this slot could be released to. Comes from the data collection spreadsheet.
SLOT_RELEASE_TO_ID DOUBLE N If the slot_release_to contained a valid slot name, this will be the ID associated with that slot name.
SLOT_START DOUBLE N The time of day that the slot begins in numeric format (i.e. 0900)
SLOT_START_STR VARCHAR(40) Y The actual start time from the data collection spreadsheet. Stored in string format in case an invalid entry is made (audit purposes).
SLOT_STATUS_FLAG DOUBLE N Future use.
SLOT_TYPE_ID DOUBLE N If the slot_name from the data collection spreadsheet is valid, and it should be, this will hold the id of the slot from the sch_slot_type table.
TIME_BLOCK DOUBLE Y A numeric representation of the time block that the slot belongs to
TIME_BLOCK_STR VARCHAR(40) N Used to store the time block value in string format.
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_SCH_TEMP_SLOT_R


Child Column in BR_SCH_TEMP_SLOT_R(FK) Parent Table Name Parent Column Name
Parents: BR_SCH_TEMPLATE_ID BR_SCH_TEMPLATE BR_SCH_TEMPLATE_ID




Parent Column in BR_SCH_TEMP_SLOT_R (PK) Child Table Name Child Column Name
Children: BR_SCH_TEMP_SLOT_R_ID BR_SCH_TEMP_SLOT_RELEASE_R BR_SCH_TEMP_SLOT_R_ID


BR_SCH_TEMP_SLOT_RELEASE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bedrock Scheduling Template Release Relationship
Definition: Stores the release slots associated to the template slots.
Table Type: REFERENCE





Column Detail - BR_SCH_TEMP_SLOT_RELEASE_R


Column Name Type Null? Definition
BR_SCH_TEMP_SLOT_RELEASE_R_ID DOUBLE N Unique generated number that identifies a single row on the BR_SCH_TEMP_SLOT_RELEASE_R table.
BR_SCH_TEMP_SLOT_R_ID DOUBLE N The slot that is available for release.
RELEASE_END_TIME_STR VARCHAR(40) N Stores when the release will end.
RELEASE_NAME VARCHAR(100) N Stores the name of the release.
RELEASE_START_TIME_STR VARCHAR(40) N Stores when the release will start.
RELEASE_TYPE_ID DOUBLE N The slot type that can be released.
RELEASE_UNIT VARCHAR(10) N Stores the release unit.
RELEASE_UNIT_VALUE_STR VARCHAR(10) N Stores the release unit value.
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_SCH_TEMP_SLOT_RELEASE_R


Child Column in BR_SCH_TEMP_SLOT_RELEASE_R(FK) Parent Table Name Parent Column Name
Parents: BR_SCH_TEMP_SLOT_R_ID BR_SCH_TEMP_SLOT_R BR_SCH_TEMP_SLOT_R_ID
RELEASE_TYPE_ID SCH_SLOT_TYPE SLOT_TYPE_ID


BR_SEG_FIELD_R



Column Section Top of Page


Table-level Detail

Description: Bedrock Segment Field Relationship
Definition: This table stores the HL7 fields and code sets that are available for the HL7 interface type/interface direction/segment
Table Type: REFERENCE





Column Detail - BR_SEG_FIELD_R


Column Name Type Null? Definition
BR_SEG_FIELD_R_ID DOUBLE N Unique id
BR_TYPE_SEG_R_ID DOUBLE N ID of the row on the BR_TYPE_SEG_R table with which this row is associated
CODESET DOUBLE N the code set associated to the HL7 field
FIELD_NAME VARCHAR(20) N the name of the HL7 field, i.e. PID 2.5, PID 3.3, PV1 2
REQUIRED_IND DOUBLE N value of 1 indicates that this code set is required for the segment
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.