Table Detail Report

BR_ALPHA_GROUP



Column Section Top of Page


Table-level Detail

Description: BEDROCK ALPHA GROUP
Definition: Alpha groups
Table Type: REFERENCE





Column Detail - BR_ALPHA_GROUP


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DESCRIPTION VARCHAR(50) Y Description for the alpha group.
GROUP_ID DOUBLE N Unique identifier for the table
SOURCE_VOCABULARY_CD DOUBLE N The source vocabulary associated to the alpha group.
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_ALPHA_GROUP_COMPONENTS



Column Section Top of Page


Table-level Detail

Description: BEDROCK ALPHA GROUP COMPONENTS
Definition: Alpha responses contained within the alpha groups
Table Type: REFERENCE





Column Detail - BR_ALPHA_GROUP_COMPONENTS


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DEFAULT_IND DOUBLE N Used to indicate which alpha response should be used as the default in result entry applications
GROUP_ID DOUBLE N Unique identifier for the table
NOMENCLATURE_ID DOUBLE N The alpha response associated to the alpha group
REFERENCE_IND DOUBLE N Indicates if the alpha response selected will be printed on hard-copy charts as the typical "reference" value.
RESULT_PROCESS_CD DOUBLE N Used to store processing codes that would flag alpha responses
SEQUENCE DOUBLE N Sequence
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.
USE_UNITS_IND DOUBLE N Used to indicate whether or not units of measure will be appended to the alpha response.


BR_APP_CATEGORY



Column Section Top of Page


Table-level Detail

Description: BEDROCK APPLICATION CATEGORY
Definition: Application Categories
Table Type: REFERENCE





Column Detail - BR_APP_CATEGORY


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CATEGORY_ID DOUBLE N Unique identifier for the table
DESCRIPTION VARCHAR(40) N The description for the application category.
DISPLAY_GROUP_DESC VARCHAR(40) Y The display description for the application category.
DISPLAY_GROUP_SEQ DOUBLE N The sequence of the application category.
SEQUENCE DOUBLE N Sequence
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_APP_CAT_COMP



Column Section Top of Page


Table-level Detail

Description: BEDROCK APPLICATION CATEGORY COMP
Definition: Applications within each application category
Table Type: REFERENCE





Column Detail - BR_APP_CAT_COMP


Column Name Type Null? Definition
APPLICATION_GROUP_CD DOUBLE N The application group for the application category.
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
CATEGORY_ID DOUBLE N Unique identifier for the table
SEQUENCE DOUBLE N Sequence
START_VERSION_NBR DOUBLE Y Identifies which version of start hs been loaded
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_ASSAY



Column Section Top of Page


Table-level Detail

Description: BEDROCK ASSAY
Definition: assay indicator fields
Table Type: REFERENCE





Column Detail - BR_ASSAY


Column Name Type Null? Definition
BR_CLIENT_ID DOUBLE N Identifies which bedrock client data belongs to
DELTA_CHECKING_IND DOUBLE N Defined as 1 the assay will need delta checking defined.
INTERPRETIVE_IND DOUBLE N Defined as 1 the assay will need interpretive data defined.
TASK_ASSAY_CD DOUBLE N dta code set
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.