IMMUNIZATION_EXT_CLOB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | External staging table for data from an interface for the Immunizations concept |
Definition: | To temporarily hold untrusted data that has come from an external source (e.g. FHIR). This table will hold the actual data that came across the interface. |
Table Type: | ACTIVITY |
Column Detail - IMMUNIZATION_EXT_CLOB
Column Name | Type | Null? | Definition |
---|---|---|---|
DATA_CLOB | LONGTEXT | Y | The data that has come from an external interface. |
IMMUNIZATION_EXT_CLOB_ID | DOUBLE | N | PRIMARY KEY |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VERSION_NBR | DOUBLE | N | The version of the external data. |
Relationship Detail - IMMUNIZATION_EXT_CLOB
Parent Column in IMMUNIZATION_EXT_CLOB (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | IMMUNIZATION_EXT_CLOB_ID | IMMUNIZATION_EXT_DATA | IMMUNIZATION_EXT_CLOB_ID |
IMMUNIZATION_EXT_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | External staging data table for Immunizations concept |
Definition: | To temporarily hold untrusted data that has come from an external source (e.g. FHIR) |
Table Type: | ACTIVITY |
Column Detail - IMMUNIZATION_EXT_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | Y | The date and time of the action. |
ACTION_PRSNL_ID | DOUBLE | N | The personnel who performed the action. |
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. |
ADMIN_DT_TM_TXT | VARCHAR(30) | N | The date and time for the administrative action in ISO 8601 format. Date and Time will be local. |
CLIENT_IDENT | VARCHAR(255) | N | An unique string representing the registration information provided by the client |
CORRELATION_IDENT | VARCHAR(80) | N | Upper case hyphenated GUID that identifies the transaction that updated this row. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. |
ENCNTR_ID | DOUBLE | N | The encounter related to the external data. |
EVENT_CD | DOUBLE | N | The event code for the immunization. |
EVENT_ID | DOUBLE | N | An EVENT_ID from tha CLINICAL_EVENT table. Identifies the CLINICAL EVENT/s associated to this immunization |
IMMUNIZATION_EXT_CLOB_ID | DOUBLE | N | The associated data that came from an external interface. |
IMMUNIZATION_EXT_DATA_ID | DOUBLE | N | PRIMARY KEY |
PERSONA_TXT | VARCHAR(40) | Y | The persona is part of the OAuth2 token, and indicates the type of user contacting the service. |
PERSON_ID | DOUBLE | N | The PERSON related to the external data |
REQUESTED_ACTION_CD | DOUBLE | N | Action requested for the data. |
SUBMITTED_DT_TM | DATETIME | Y | The date and time this external data was added to the staging tables. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - IMMUNIZATION_EXT_DATA
Child Column in IMMUNIZATION_EXT_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
IMMUNIZATION_EXT_CLOB_ID | IMMUNIZATION_EXT_CLOB | IMMUNIZATION_EXT_CLOB_ID | |
PERSON_ID | PERSON | PERSON_ID | |
ACTION_PRSNL_ID | PRSNL | PERSON_ID |
IMMUNIZATION_MODIFIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | IMMUNIZATION MODIFIER |
Definition: | This is the list of modifiers to expectations and Immunization events. |
Table Type: | ACTIVITY |
Column Detail - IMMUNIZATION_MODIFIER
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
CLINICAL_EVENT_ID | DOUBLE | N | THIS COLUMN NOT USED. Clinical event identifier (from CLINICAL_EVENT) related to this modifier information. This column is not used and will be made obsolete. Use EVENT_ID instead. 6/25/03 |
CONSENT_LONG_TEXT_ID | DOUBLE | N | OBSOLETE - ID to LONG_TEXT for comments related to the consent for the related Expectation. |
CONSENT_PERSON_ID | DOUBLE | N | OBSOLETE - ID from PERSON of the person giving consent for the Expectation. |
CONSENT_PERSON_REL_CD | DOUBLE | N | OBSOLETE - Value from CS40 to indicate the relationship of the person giving consent for the person identified by person_id. |
DEFAULT_EVENT_IND | DOUBLE | Y | Indicates whether the event for the immunization was selected by default. |
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. |
EVENT_CD | DOUBLE | N | The event code that corresponds to this modifier. |
EVENT_ID | DOUBLE | N | This value comes from the non-key EVENT_ID column in the CLINICAL_EVENT table. |
EXPECT_MEANING | VARCHAR(250) | N | The Expectation meaning of the HM Expectation associated with the modifier. |
FUNDING_SOURCE_CD | DOUBLE | N | The funding source code associated to this modifier. |
IMMUNIZATION_MODIFIER_ID | DOUBLE | N | Unique Identifier for the immunization_modifier table. |
ORGANIZATION_ID | DOUBLE | N | Foreign Key from ORGANIZATION table |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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. |
VFC_STATUS_CD | DOUBLE | N | The Code that identifies the Vaccines For Children (VFC) status for the related Expectation. |
VIS_CD | DOUBLE | N | The Vaccine Information Statement code associated to this modifier |
VIS_DT_TM | DATETIME | Y | The version date printed on the Vaccine Information Sheet (VIS) for the related Expectation. |
VIS_PROVIDED_ON_DT_TM | DATETIME | Y | The date and time that the VIS was provided to the patient or their parent/guardian |
Relationship Detail - IMMUNIZATION_MODIFIER
Child Column in IMMUNIZATION_MODIFIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONSENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
CONSENT_PERSON_ID | PERSON | PERSON_ID | |
PERSON_ID | PERSON | PERSON_ID |
IMMUNIZATION_OBSERVATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Immunization Observation |
Definition: | Documented patient observations that correspond to a codified Indication or Contraindication for Immunization Forecasting. |
Table Type: | ACTIVITY |
Column Detail - IMMUNIZATION_OBSERVATION
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. |
BEGIN_DT_TM | DATETIME | Y | Begin Date Time of the Observation |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
END_DT_TM | DATETIME | Y | End Date Time of the Observation |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
IMMUNIZATION_OBSERVATION_ID | DOUBLE | N | PRIMARY KEY |
OBSERVATION_CD | DOUBLE | N | observation code |
OBSERVATION_ID | DOUBLE | Y | a grouper for history on the table and will reference the IMMUNIZATION_OBSERVATION_ID associated with the initial write to the table. |
PERSON_ID | DOUBLE | N | Foreign Key to the Patient Person |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VACCINE_GROUP_CD | DOUBLE | N | Code Value for the Vaccine Group |
Relationship Detail - IMMUNIZATION_OBSERVATION
Child Column in IMMUNIZATION_OBSERVATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OBSERVATION_ID | IMMUNIZATION_OBSERVATION | IMMUNIZATION_OBSERVATION_ID |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in IMMUNIZATION_OBSERVATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | IMMUNIZATION_OBSERVATION_ID | IMMUNIZATION_OBSERVATION | OBSERVATION_ID |
IMMUNIZATION_RULES
Column Section | Top of Page |
Table-level Detail
Description: | Immunizations Forecasting Rules table |
Definition: | To store the CDSi version of the immunizations forecasting rules that will be used by the system. |
Table Type: | REFERENCE |
Column Detail - IMMUNIZATION_RULES
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. |
IMMUNIZATION_RULES_ID | DOUBLE | N | PRIMARY KEY |
IMMUN_FORECAST_RULES_CLOB | LONGTEXT | Y | The rules that are used to forecast patient data in the immunization forecasting. The clob will contain a json text file. No imbedded ID data, |
IMPORTED_DT_TM | DATETIME | Y | The date and time the row was imported into the database. |
LOGIC_SPECIFICATION_VRSN_TXT | VARCHAR(6) | N | The document that we implement for the business logic portion of praemoneo and will require a release of praemoneo to update. It's currently 4.0. |
SUPPORTING_DATA_VRSN_TXT | VARCHAR(6) | N | The different series, intervals, skip conditions for each vaccine group and will be the content we will deliver. Its current version is 4.3. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPLOAD_DT_TM | DATETIME | Y | The date and time the row was uploaded to the ftp3 site. |