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