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. |