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