Table Detail Report
EPA_RECORD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Electronic Prior Authorization Record |
Definition: | Stores Electronic Prior Authorization information |
Table Type: | ACTIVITY |
Column Detail - EPA_RECORD
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. |
CHANGERX_MESSAGE_IDENT | VARCHAR(2000) | Y | CHANGE RX MESSAGE IDENTIFIER |
CHG_RX_FLAG | DOUBLE | N | A flag that denotes if a Change Response has ben triggered. Supported Values: 0-Unset, 1 - This PA Record expects a Response, 2- Change Rx Response has been triggered. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CREATE_DT_TM | DATETIME | Y | The Data Time when the PA was created |
DATA_ENTERER_PRSNL_ID | DOUBLE | N | The action personnel of the prior authorization. |
DISMISS_IND | DOUBLE | N | Indicates if the record has been dismissed by the provider 1 = yes / 0= no |
DRUG_IDENT | VARCHAR(2000) | Y | The NDC of the drug. |
ENCNTR_ID | DOUBLE | N | The encounter id tied to the prior authorization. |
EPA_MEDICATION_BLOB_ID | DOUBLE | N | The blob that contains un-matched drug information from the external vendor. FK value from EPA_LONG_BLOB |
EPA_PATIENT_DEMOG_BLOB_ID | DOUBLE | N | The blob that contains un-matched patient information from the external vendor. FK value from EPA_LONG_BLOB |
EPA_RECORD_ID | DOUBLE | N | PRIMARY KEY |
INTERCHANGE_ID | DOUBLE | N | Interchange ID. refers to interchange_id on the EEM_TRANSACTION table. That column is a unique index on the table not the PK. |
INTERCHANGE_SEQUENCE | DOUBLE | N | Order of the transactions as found in the INTERCHANGE_ID field. |
MEDICATION_BLOB_ID | DOUBLE | N | **OBSOLETE** use column EPA_MEDICATION_BLOB_ID |
ORDER_CATALOG_CKI | VARCHAR(255) | Y | The order catalog CKI |
ORDER_DESCRIPTION | VARCHAR(2000) | Y | The drug description of the order. This can be the ORDERED_AS_MNEMONIC for Prospective workflows and the DRUG_DESCRIPTION from the NCPDP transaction for Retrospective workflows. |
ORGANIZATION_ID | DOUBLE | N | The organization where the medication was prescribed. |
PATIENT_DEMOG_BLOB_ID | DOUBLE | N | **OBSOLETE** use column EPA_PATIENT_DEMOG_BLOB_ID |
PA_CASE_IDENT | VARCHAR(2000) | Y | The tracking Identifier assigned by the Payer as a unique reference to this prior authorization case |
PA_REF_IDENT | VARCHAR(2000) | N | The tracking identifier on all prior authorization request and response transactions that tie related prior authorization transactions. |
PERSON_ID | DOUBLE | N | The patient who the EPA belongs to. |
PHARMACY_IDENT | VARCHAR(2000) | Y | The NCPDP Identifier of the Pharmacy |
PRSNL_ID | DOUBLE | N | The provider who prescribed the medication. |
RELATED_ORDER_ID | DOUBLE | N | The order id related to the Prior Authorization. This can be the order id for an order or the projected order id for a proposed order |
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 - EPA_RECORD
Child Column in EPA_RECORD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
EPA_MEDICATION_BLOB_ID | EPA_LONG_BLOB | EPA_LONG_BLOB_ID | |
EPA_PATIENT_DEMOG_BLOB_ID | EPA_LONG_BLOB | EPA_LONG_BLOB_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
DATA_ENTERER_PRSNL_ID | PRSNL | PERSON_ID | |
PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in EPA_RECORD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EPA_RECORD_ID | EPA_ACTIVITY | EPA_RECORD_ID |
EPA_AUTH_DETAIL | EPA_RECORD_ID | ||
EPA_ERROR_LOG | EPA_RECORD_ID |
ERX_EXT_MED_LIST_ACCESS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ERX EXTERNAL MEDICATION LIST ACCESS |
Definition: | Stores patient consent for physicians to access their external medication list. |
Table Type: | ACTIVITY |
Column Detail - ERX_EXT_MED_LIST_ACCESS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESS_TYPE_CD | DOUBLE | Y | The Sweden NLL access reason/level 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. |
ENCNTR_ID | DOUBLE | Y | The identifier for the encounter the access request is related to.; |
ERX_EXT_MED_LIST_ACCESS_ID | DOUBLE | N | PRIMARY KEY |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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. |
USER_ID | DOUBLE | Y | The physician / clinician / User who is being granted or revoked access. |
Relationship Detail - ERX_EXT_MED_LIST_ACCESS
Child Column in ERX_EXT_MED_LIST_ACCESS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
USER_ID | PRSNL | PERSON_ID |
ERX_LONG_BLOB
Column Section | Top of Page |
Table-level Detail
Description: | Electronic Prescribing Long Blob |
Definition: | Stores BLOB data for Electronic Prescribing |
Table Type: | ACTIVITY |
Column Detail - ERX_LONG_BLOB
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. |
CONSUMER_IDENT | VARCHAR(255) | N | Unique ID to identify the stored blob data. The ID value is decided by the client/consumer. The |
CONSUMER_IDENT_HASH | DOUBLE | N | Hash of CONSUMER_IDENT. This value is used as an index for retrieving data. |
ERX_LONG_BLOB | LONGBLOB | Y | The BLOB data to be stored on the ERX_LONG_BLOB table. |
ERX_LONG_BLOB_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. |