ABSTRACTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: ABSTRACTING
Definition: Encounter based table for ProFile Chart Abstracting information
Table Type: ACTIVITY





Column Detail - ABSTRACTING


Column Name Type Null? Definition
ABSTRACTING_ID DOUBLE N This is the value of the unique primary identifier of the abstracting table. It is an internal system assigned number.
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.
COMPLETED_DT_TM DATETIME Y The date and time that the abstracting information for an encounter was saved as final.
CREATE_DT_TM DATETIME Y The date that the record was created in the table.
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the row in the table
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SVC_CAT_HIST_ID DOUBLE N This is a unique identifier for the service category history table.
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 - ABSTRACTING


Child Column in ABSTRACTING(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID


ABSTRACT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Abstract data collected for a specific patient's encounter.
Definition: Abstract data
Table Type: ACTIVITY





Column Detail - ABSTRACT_DATA


Column Name Type Null? Definition
ABSTRACT_DATA_ID DOUBLE N This is the value of the unique primary identifier of the Abstract_data table. It is an internal system assigned number
ABSTRACT_FIELD_DEF_CD DOUBLE N this is the abstract field def tables unique identifier.
ABSTRACT_FIELD_TYPE_CD DOUBLE N Abstract field type code
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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_SLICE_ID DOUBLE N Identifies an Encounter as it relates to a time slice.
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.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SVC_CAT_HIST_ID DOUBLE N This is the unique identifier for the service category history table.
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.
VALUE_CD DOUBLE N This is the value code associated with the code_set, given that the abstract field type is Code Set.
VALUE_DT_TM DATETIME Y This is a date and time value for the abstract data
VALUE_FREE_TEXT VARCHAR(255) Y This is the free text value, given that the abstract field type is text.
VALUE_NUMBER DOUBLE Y This is the number value, given that the abstract field type is numeric.



Relationship Detail - ABSTRACT_DATA


Child Column in ABSTRACT_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID


ABSTRACT_FIELD_DEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Abstract Field definition table
Definition: User defined abstract fields
Table Type: REFERENCE





Column Detail - ABSTRACT_FIELD_DEF


Column Name Type Null? Definition
ABSTRACT_DESC VARCHAR(255) Y Description of the chart abstracting field being added
ABSTRACT_FIELD_DEF_CD DOUBLE N This is the coded primary identifier for this table
ABSTRACT_FIELD_TYPE_CD DOUBLE N The codes that represent the types of information (string, numeric, etc.). that the abstract field is capturing
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.
CALCULATE_CD DOUBLE N To do calculation on abstract field based on the code value from code set 20689
CODESET_NBR DOUBLE Y The number of the codeset that the data in this abstract field must be a subset of
CONDITIONAL_IND DOUBLE Y Indicates if this is a conditional field or not.
DATE_CHK_IND DOUBLE Y This flexes whether the date should be validated against admit and discharge dates or not
DISPLAY_LABEL VARCHAR(255) Y The label for the abstract field.
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.
LENGTH DOUBLE Y The length for the abstract data being entered.
OMF_FACT_IND DOUBLE Y To represent Fact or Dimension by 1 or 0
REQUIRED_IND DOUBLE Y Indicates if this is a required abstract field or not.
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 - ABSTRACT_FIELD_DEF




Parent Column in ABSTRACT_FIELD_DEF (PK) Child Table Name Child Column Name
Children: ABSTRACT_FIELD_DEF_CD ABSTRACT_FIELD_FLEX ABSTRACT_FIELD_DEF_CD


ABSTRACT_FIELD_FLEX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Abstract field flex
Definition: Holds the field type and other field properties
Table Type: REFERENCE





Column Detail - ABSTRACT_FIELD_FLEX


Column Name Type Null? Definition
ABSTRACT_FIELD_DEF_CD DOUBLE Y This is the unique identifier for the Abstract Field Def table
ABSTRACT_FIELD_FLEX_ID DOUBLE N This is the value of the unique primary identifier of the abstract_field_flex table. It is an internal system assigned number
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 Y 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 Y 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.
DEPENDENT_TABLE_CD DOUBLE Y This stores the coded value from the dependent table
DEPENDENT_TABLE_DT_TM DATETIME Y Date to be compared by a relational operator
DEPENDENT_TABLE_FIELD VARCHAR(255) Y This is the name of the field on the dependent table
DEPENDENT_TABLE_NAME VARCHAR(255) Y This is the name of the dependent table
DEPENDENT_TABLE_VALUE VARCHAR(255) Y This is the value from the dependent field
ENCNTR_IND DOUBLE Y Indicator to check the encntr_id on the defined table
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.
PERSON_IND DOUBLE Y Indicator to check the person_id on the defined table
RELATIONAL_OPERATOR VARCHAR(2) Y Defines what comparison needs to be done (<, >, etc.)
REQUIRED_IND DOUBLE Y This field indicates if a value is required
START_DT_TM DATETIME Y Date field to be used in a date range comparison
START_VALUE VARCHAR(255) Y Start value for a range comparison other than dates
STOP_DT_TM DATETIME Y Date field to be used in a date range comparison
STOP_VALUE VARCHAR(255) Y Stop value for range comparisons other than dates
SVC_CAT_IND DOUBLE N Service Category indicator
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 - ABSTRACT_FIELD_FLEX


Child Column in ABSTRACT_FIELD_FLEX(FK) Parent Table Name Parent Column Name
Parents: ABSTRACT_FIELD_DEF_CD ABSTRACT_FIELD_DEF ABSTRACT_FIELD_DEF_CD


ABSTRACT_IN



Column Section Top of Page


Table-level Detail

Description: Abstract In
Definition: This table will be used for 'IN-conditional' functionality on Profile's Abstracting tool.
Table Type: ACTIVITY





Column Detail - ABSTRACT_IN


Column Name Type Null? Definition
ABSTRACT_IN_ID DOUBLE N This field is the primary key to the ABSTRACT_IN table.
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.
GROUP_NAME_CD DOUBLE N This field defines the name a specific IN-conditional group
SOURCE_IDENTIFIER VARCHAR(50) N The code, or key, from the source vocabulary that contributed the string to the 48 nomenclature.
SOURCE_VOCABULARY_CD DOUBLE N The external vocabulary or lexicon that contributed the string, e.g. ICD9, SNOMED, 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.