EPA_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Electronic Prior Authorization Activity |
Definition: | Stores activity information for each Prior Authorization Transaction. |
Table Type: | ACTIVITY |
Column Detail - EPA_ACTIVITY
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. |
APPEAL_EXPIRATION_DATE_TXT | VARCHAR(255) | Y | The deadline to appeal the PA decision. |
APPEAL_NOTE_ID | DOUBLE | N | **OBSOLETE** use column EPA_APPEAL_NOTE_ID |
DEADLINE_FOR_REPLY_TXT | VARCHAR(255) | Y | The deadline by which the prior authorization must be responded to. |
EAPPEAL_SUPPORTED_IND | DOUBLE | N | A boolean value that indicates if electronic appeals are supported. |
EPA_ACTIVITY_ID | DOUBLE | N | PRIMARY KEY |
EPA_APPEAL_NOTE_ID | DOUBLE | N | The EPA_long_text id of the appeal note. |
EPA_PA_NOTE_ID | DOUBLE | N | The EPA_long_text id of the pa note that corresponds to this activity. |
EPA_QUESTION_SET_BLOB_ID | DOUBLE | N | The EPA_long_blob id of the question set blob. |
EPA_RECORD_ID | DOUBLE | N | The identifier of the associated EPA_RECORD ( FK Value from EPA_RECORD) |
INBOUND_ATCHMT_IDENT | VARCHAR(255) | Y | The CAMM attachment identifier for a transaction level inbound attachment |
MESSAGE_IDENT | VARCHAR(255) | Y | The message id of the inbound NCPDP Transaction |
OUTBOUND_ATCHMT_IDENT | VARCHAR(255) | Y | The CAMM attachment identifier for a transaction level outbound attachment |
PA_NOTE_ID | DOUBLE | N | **OBSOLETE** use EPA_PA_NOTE_ID |
PA_REASON_BITMASK | DOUBLE | N | A bit mask that contains reason codes for the prior authorization status. |
QUESTION_SET_BLOB_ID | DOUBLE | N | **OBSOLETE** use EPA_QUESTION_SET_BLOB_ID |
STATUS_FLAG | DOUBLE | N | The status of the Electronic Prior Authorizations.See DM_FLAGS table for possible values ( 1- 17 ) |
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_ACTIVITY
Child Column in EPA_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EPA_QUESTION_SET_BLOB_ID | EPA_LONG_BLOB | EPA_LONG_BLOB_ID |
EPA_APPEAL_NOTE_ID | EPA_LONG_TEXT | EPA_LONG_TEXT_ID | |
EPA_PA_NOTE_ID | EPA_LONG_TEXT | EPA_LONG_TEXT_ID | |
EPA_RECORD_ID | EPA_RECORD | EPA_RECORD_ID |
EPA_AUTH_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Electronic Prior Authorization Details |
Definition: | Stores Electronic Prior Authorization information Details |
Table Type: | ACTIVITY |
Column Detail - EPA_AUTH_DETAIL
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. |
AUTH_EFFECTIVE_DATE_TXT | VARCHAR(255) | Y | The start date of the Authorization Period (character format). |
AUTH_EXPIRATION_DATE_TXT | VARCHAR(255) | Y | The end date of the Authorization Period (character format) |
AUTH_NOTE_ID | DOUBLE | N | **OBSOLETE** use EPA_AUTH_NOTE_ID |
AUTH_NUMBER_TXT | VARCHAR(255) | Y | The payer-assigned authorization number for the PA (character format) |
DAYS_SUPPLY_NBR | DOUBLE | N | This indicates the approved days supply of the requested medication. |
EPA_AUTH_DETAIL_ID | DOUBLE | N | PRIMARY KEY |
EPA_AUTH_NOTE_ID | DOUBLE | N | AUTH NOTE ID - FK Value from the EPA_LONG_TEXT table |
EPA_RECORD_ID | DOUBLE | N | This field contains the associated EPA_RECORD identifier ( Foreign Key from EPA_RECORD) |
NUMBER_OF_CYCLES | DOUBLE | N | This indicates the number of dispensing cycles approved. |
NUMBER_OF_REFILLS | DOUBLE | N | This indicates the number of approved refills. |
PHARMACY_TYPE_FLAG | DOUBLE | N | Indicates if only certain pharmacy types are approved to dispense the medication. 1 = Ret0ail, 2 = Mail Order, 3 = Secialty, 4 = Long Term Care, 5 = Anyo |
QUANTITY_UNIT_CD | DOUBLE | N | The codified value of the quantity's unit of measure. |
QUANTITY_VALUE | DOUBLE | N | This indicates the approved quantity of the requested medication. |
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_AUTH_DETAIL
Child Column in EPA_AUTH_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EPA_AUTH_NOTE_ID | EPA_LONG_TEXT | EPA_LONG_TEXT_ID |
EPA_RECORD_ID | EPA_RECORD | EPA_RECORD_ID |
EPA_ERROR_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Electronic Prior Authorization Errors |
Definition: | Stores partial failures that may occur during epa workflows |
Table Type: | ACTIVITY |
Column Detail - EPA_ERROR_LOG
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. |
DISMISS_IND | DOUBLE | N | Whether this error has been dismissed by the provider or not. |
EPA_ERROR_LOG_ID | DOUBLE | N | PRIMARY KEY |
EPA_ERROR_NOTE_ID | DOUBLE | N | This value comes from the LONG_TEXT id from the EPA_LONG_TEXT table |
EPA_RECORD_ID | DOUBLE | N | The EPA_RECORD id from the EPA_RECORD table |
FAILURE_IND_BIT | DOUBLE | N | A bitmask representing the failure(s) that occurred. |
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. |
WORKFLOW_FLAG | DOUBLE | N | Workflow where the error occurred.1 PA_UNKNOWN2 PA_INITIATION_REQUEST3 PA_INITIATION_RESPONSE4 PA_REQUEST5 PA_RESPONSE6 PA_CANCEL_REQUEST7 PA_CANCEL_RESPONSE8 PA_CHANGE_RESPONSE |
Relationship Detail - EPA_ERROR_LOG
Child Column in EPA_ERROR_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EPA_ERROR_NOTE_ID | EPA_LONG_TEXT | EPA_LONG_TEXT_ID |
EPA_RECORD_ID | EPA_RECORD | EPA_RECORD_ID |
EPA_LONG_BLOB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Electronic Prior Authorization Long Blob |
Definition: | Stores BLOB data for Electronic Authorization |
Table Type: | ACTIVITY |
Column Detail - EPA_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. |
EPA_LONG_BLOB_ID | DOUBLE | N | PRIMARY KEY |
LONG_BLOB | LONGBLOB | Y | The BLOB data to be stored on the EPA_LONG_BLOB table. |
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_LONG_BLOB
Parent Column in EPA_LONG_BLOB (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EPA_LONG_BLOB_ID | EPA_ACTIVITY | EPA_QUESTION_SET_BLOB_ID |
EPA_RECORD | EPA_MEDICATION_BLOB_ID | ||
EPA_RECORD | EPA_PATIENT_DEMOG_BLOB_ID |
EPA_LONG_TEXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Electronic Prior Authorization Long Text |
Definition: | Stores Long String Values for Electronic Authorization |
Table Type: | ACTIVITY |
Column Detail - EPA_LONG_TEXT
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. |
EPA_LONG_TEXT_ID | DOUBLE | N | PRIMARY KEY |
LONG_TEXT | LONGTEXT | Y | The String value to be stored on the EPA_LONG_TEXT table. |
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_LONG_TEXT
Parent Column in EPA_LONG_TEXT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EPA_LONG_TEXT_ID | EPA_ACTIVITY | EPA_APPEAL_NOTE_ID |
EPA_ACTIVITY | EPA_PA_NOTE_ID | ||
EPA_AUTH_DETAIL | EPA_AUTH_NOTE_ID | ||
EPA_ERROR_LOG | EPA_ERROR_NOTE_ID |