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.