CATEGORY_SECT_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | CATEGORY SECT RELTN |
Definition: | Contains the relationship between the chart_category and chart_section |
Table Type: | REFERENCE |
Column Detail - CATEGORY_SECT_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
CATEGORY_SECT_RELTN_ID | DOUBLE | N | Unique identifier of the category_sect_reltn table |
CHART_CATEGORY_ID | DOUBLE | N | Unique identifier of the chart_category that is being associated |
CHART_FORMAT_ID | DOUBLE | N | Unique identifier of the chart_format table |
CHART_SECTION_ID | DOUBLE | N | Unique identifier of the chart_section that is being associated |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
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. |
CHARTING_OPERATIONS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | charting operations |
Definition: | This table stores the information needed for distributions to be printed from op |
Table Type: | REFERENCE |
Column Detail - CHARTING_OPERATIONS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
BATCH_NAME | VARCHAR(100) | N | This is the description given to the combined parameters needed to define the operations job |
BATCH_NAME_KEY | VARCHAR(100) | N | Name of the operations job in capitol letters used to prevent duplicate batch names |
CHARTING_OPERATIONS_ID | DOUBLE | N | The unique identifying number given to each operations job |
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. |
PARAM | VARCHAR(100) | Y | Stores the data associated with the param_type_flag (i.e. the chart format id, the run type, distribution id) |
PARAM_TYPE_FLAG | DOUBLE | Y | This defines the type of parameter that is being defined for the operations job. |
SEQUENCE | DOUBLE | N | This is the sequence in which the rows on the table should be read. |
UPDATE_IND | DOUBLE | Y | Indicates if this row has been updated |
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 - CHARTING_OPERATIONS
Child Column in CHARTING_OPERATIONS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
CHARTING_OPERATIONS_PRSNL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table relates the physicians to be included or excluded by an operation. |
Definition: | This table would hold the list of personnel who would be exluded from getting a chart in a distribution run or those list of personnel who would be included to get a chart if they are qualified. This is a child table of charting_operations table. |
Table Type: | REFERENCE |
Column Detail - CHARTING_OPERATIONS_PRSNL
Column Name | Type | Null? | Definition |
---|---|---|---|
CHARTING_OPERATIONS_ID | DOUBLE | N | Defines the operation for which the corresponding personnel id is either included or excluded. |
CHARTING_OPERATIONS_PRSNL_ID | DOUBLE | N | Unique identifier for Charting_operations_prsnl table. |
PRSNL_ID | DOUBLE | N | This field defines the personnel who is to be included or excluded from receiving a chart for the operation. |
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 - CHARTING_OPERATIONS_PRSNL
Child Column in CHARTING_OPERATIONS_PRSNL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_ID | PRSNL | PERSON_ID |
CHART_ACTIVITY_TEMP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Chart Activity Temp |
Definition: | This table is temporary and will store the event codes and catalog codes associated to the distribution format. This table was created to utilize direct Oracle joins instead of using dummyt tables when combining against the event_cds and catalog_cds for a given format. |
Table Type: | ACTIVITY |
Column Detail - CHART_ACTIVITY_TEMP
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | Orderable. From code set 200 |
CONTENT_TYPE_MEAN | VARCHAR(12) | Y | stores content type cdf meaning for corresponding rows when used. |
DISTRIBUTION_ID | DOUBLE | N | Unique identifier representing the distribution being processed. |
EVENT_CD | DOUBLE | N | The Event Code from code set 72 |
FLEX_TYPE_FLAG | DOUBLE | N | Used for Blood Bank and HLA chart sections to determine what type sections were selected. Blood Bank can be Transfusion or Crossmatch. HLA can have a Typing or Haplotype section. |
PROCEDURE_TYPE_FLAG | DOUBLE | N | A value of 0 implies that an event set was assigned to the format while 1 implies orderables were assigned. |
SECT_TYPE_FLAG | DOUBLE | N | Represents the type of section such as AP, Gen Lab, PowerForms, etc. |
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 - CHART_ACTIVITY_TEMP
Child Column in CHART_ACTIVITY_TEMP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DISTRIBUTION_ID | CHART_DISTRIBUTION | DISTRIBUTION_ID |
CHART_ALLERGY_FORMAT
Column Section | Top of Page |
Table-level Detail
Description: | CHART ALLERGY FORMAT |
Definition: | This table defines the attributes of the allergy list section. |
Table Type: | REFERENCE |
Column Detail - CHART_ALLERGY_FORMAT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
CANCEL_LBL | VARCHAR(32) | Y | This is the column for the cancel reason label |
CANCEL_ODR | DOUBLE | N | This is the column for the cancel reason order |
CATEGORY_LBL | VARCHAR(32) | Y | This is the column for the category label |
CATEGORY_ODR | DOUBLE | N | This is the column for the category order |
CHART_GROUP_ID | DOUBLE | N | The chart_group_id |
COMMENT_LBL | VARCHAR(32) | Y | This is the column for the comment label |
ONSET_DT_LBL | VARCHAR(32) | Y | The label for the onset date column. |
ONSET_DT_ODR | DOUBLE | N | The order for the onset date column. |
REACTION_LBL | VARCHAR(32) | Y | This is the column for the reaction label |
REACTION_ODR | DOUBLE | N | This is the column for the reaction order |
REACTION_STAT_LBL | VARCHAR(32) | Y | The label for the reaction status column. |
REACTION_STAT_ODR | DOUBLE | N | The order for the reaction status column. |
RESULT_SEQUENCE_IND | DOUBLE | N | Determines if the chart will print newest to oldest(0) or oldest to newest(1). |
SEVERITY_LBL | VARCHAR(32) | Y | The label for the severity column. |
SEVERITY_ODR | DOUBLE | N | The order for the severity column. |
SOURCE_LBL | VARCHAR(32) | Y | This is the column for the source label |
SOURCE_ODR | DOUBLE | N | This is the column for the source order |
SUBSTANCE_LBL | VARCHAR(32) | Y | The label for the substance column. |
TYPE_LBL | VARCHAR(32) | Y | This is the column for the type label |
TYPE_ODR | DOUBLE | N | This is the column for the type order |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_BY_LBL | VARCHAR(32) | Y | This is the column for the update by label |
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_LBL | VARCHAR(32) | Y | This is the column for the update date label |
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. |