Table Detail Report

RX_DISPENSE_GENERATOR_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Dispense Generator Audit
Definition: Table used to audit asynchronized transactions for Pharmacy Dispense Generator service.
Table Type: ACTIVITY





Column Detail - RX_DISPENSE_GENERATOR_AUDIT


Column Name Type Null? Definition
ACTION_NAME VARCHAR(50) N Describes the dispense type of the initiating dispense event.
CORRELATION_UID VARCHAR(36) N The identifier for a transaction to the PharmacyDispenseGenerator service.
CREATE_DT_TM DATETIME N This is the date and time the row was created.
INITIATING_DISPENSE_HX_ID DOUBLE N Identifies the dispense event from which this action is initiated.
MESSAGE_TXT VARCHAR(1000) N Text indicating success or failure messages.
RX_DISPENSE_GENERATOR_AUDIT_ID DOUBLE N Unique generated number that identifies a single row on the RX_DISPNSE_GENERATOR_AUDIT table.
STATUS_FLAG DOUBLE N Indicates the status of the transaction. 1 - success, 0 - fail
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 - RX_DISPENSE_GENERATOR_AUDIT


Child Column in RX_DISPENSE_GENERATOR_AUDIT(FK) Parent Table Name Parent Column Name
Parents: INITIATING_DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID


RX_HEALTH_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RX HEALTH PLAN
Definition: Store Pharmacy specific attributes of Health Plan.
Table Type: REFERENCE





Column Detail - RX_HEALTH_PLAN


Column Name Type Null? Definition
ALIAS_POOL_CD DOUBLE N Alias pool code identifies a unique set or list of identifiers (i.e., numbers). The alias pool code also determines the accept display format for the unique set of identifiers.
ALT_OTHER_PAYER_NAME VARCHAR(10) Y Alternate Other Payer for a specific health plan when coordination of benefits is used.
BRAND_COPAY DOUBLE Y Prescription copay amount for Brand products for a specific health plan
BRAND_COPAY_PERCENT DOUBLE Y Prescription copay percent amount for Brand products for a specific health plan
CLAIM_CNT DOUBLE Y Claim Count
CLAIM_FORMAT_CD DOUBLE N Identifies an overall claim format for a specific health plan or a single ingredient format
CLAIM_VALIDATION_CD DOUBLE N Identifies an overall claim validation for a specific health plan
CMPD_CLAIM_CNT DOUBLE Y maximum number of compound prescriptions allowed per Claim Transmission
CMPD_ING_CNT DOUBLE Y maximum number of ingredients allowed in a compound prescription
COB_OTHER_PAYER_IND DOUBLE N indicates Both the patient responsibility and the other payer amount should be sent in a claim request. 0 = Not send Both together, 1 = Send Both together
COB_PATIENT_RESP_IND DOUBLE N Indicates if the Patient Responsibility or the Other Payer Amount should be sent in a claim request. 0 = Other Payer, 1 = Patient Responsibility
COB_SUBMISSION_TYPE_CD DOUBLE N Coordination of benefits segment type used to submit claims.
COB_TYPE_CD DOUBLE N Co-ordination of benefits participation type
COMPOUND_FORMAT_CD DOUBLE N Identifies a compound claim format for a specific health plan
COPAY DOUBLE Y Prescription copay amount for a specific health plan
COPAY_OVERRIDE_IND DOUBLE Y Copay override ind
COPAY_PERCENT DOUBLE Y Prescription copay percent for a specific health plan
GENERIC_COPAY DOUBLE Y Prescription copay amount for generic products for a specific health plan
GENERIC_COPAY_PERCENT DOUBLE Y Prescription copay percent amount for generic products for a specific health plan
HEALTH_PLAN_ID DOUBLE N ID generated for unique health plans.
INCLUDE_INVESTIGATIONAL_IND DOUBLE Y Indicator (0,1). Indicates whether or not to include investigational drugs on prescription claims.
INCLUDE_OTC_IND DOUBLE Y Indicator (0,1). Indicates whether or not to include Over-The-Counter drugs on prescription claims.
INPATIENT_BILLING_FLAG DOUBLE N Indicates that the health plan supports billing Inpatient dispenses via Outpatient claims
OTH_PAYR_PAT_RESP_AMT_SUM_IND DOUBLE N Indicates whether the current health plan expects all the Other Payer-Patient Responsibility Amount to be summed and sent under NQ with qualifier of NP=06.
PARTIAL_FILL_TYPE_CD DOUBLE N Indicates if a health plan supports NCPDP 51 Partial Fill Submission Process.
PRESCRIPTION_IND DOUBLE N Indicates if the health plan is a prescription plan
PRICE_CODE_CD DOUBLE N Identifies a price code for a health plan
PROC_CONTROL_NUMBER CHAR(20) Y Proc control number
PRSNL_ALIAS_CD DOUBLE N Personnel alias code
TWO_STEP_DISPENSE_IND DOUBLE N This column defines whether the orders should follow two step dispense process
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.
USE_ALT_OTHER_PAYER_IND DOUBLE N Indicates whether the Alternate Other Payer is selected or not when Coordination of Benefits is used.
VENDOR_CERT_NBR_TXT CHAR(10) Y An external ID assigned by the switch or processor to identify the software source.



Relationship Detail - RX_HEALTH_PLAN


Child Column in RX_HEALTH_PLAN(FK) Parent Table Name Parent Column Name
Parents: CLAIM_VALIDATION_CD CODE_VALUE CODE_VALUE
PRICE_CODE_CD CODE_VALUE CODE_VALUE
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID




Parent Column in RX_HEALTH_PLAN (PK) Child Table Name Child Column Name
Children: HEALTH_PLAN_ID RX_CLAIM_PENDING HEALTH_PLAN_ID
RX_HEALTH_PLAN_CLAIM HEALTH_PLAN_ID
RX_HEALTH_PLAN_SERV_RES_R HEALTH_PLAN_ID


RX_HEALTH_PLAN_CLAIM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Health Plan Claim
Definition: List of claim fields that can be flexed by health plan and by claim format.
Table Type: REFERENCE





Column Detail - RX_HEALTH_PLAN_CLAIM


Column Name Type Null? Definition
CLAIM_FIELD_CD DOUBLE N Determines which claim field type is being flexed.
CLAIM_FORMAT_ID DOUBLE N Used to flex claim fields at the claim format level. The same health plan can be flexed using multiple claim formats.
CODE_VALUE_CD DOUBLE N Determines the value that a specific claim field is flexed with.
FIELD_ALIAS_CD DOUBLE N Stores a code_value for a PERSON or PRSNL alias associated with the claim.
HEALTH_PLAN_ID DOUBLE N Determines what health plan the fields are related to. Used to flex claim fields at the health plan level.
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 - RX_HEALTH_PLAN_CLAIM


Child Column in RX_HEALTH_PLAN_CLAIM(FK) Parent Table Name Parent Column Name
Parents: CODE_VALUE_CD CODE_VALUE CODE_VALUE
CLAIM_FIELD_CD RX_CLAIM_FIELD CLAIM_FIELD_CD
CLAIM_FORMAT_ID RX_CLAIM_FORMAT FORMAT_ID
HEALTH_PLAN_ID RX_HEALTH_PLAN HEALTH_PLAN_ID


RX_HEALTH_PLAN_SERV_RES_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pharmacy Health Plan Service Resource Relation
Definition: Stores the relationship between a pharmacy health plan and a service resource. Pharmacy health plans can be mapped to one or more service resources. This relationship will be used in Retail medication manager to decide if the selected health plan is enabled for the service resource to process 'HAAD claims'. This applies to Middle east claims only currently.
Table Type: REFERENCE





Column Detail - RX_HEALTH_PLAN_SERV_RES_R


Column Name Type Null? Definition
HEALTH_PLAN_ID DOUBLE N The health plan that is mapped to this service resource.
RX_HEALTH_PLAN_SERV_RES_R_ID DOUBLE N Unique, generated number that identifies a single row on the RX_HEALTH_PLAN_SERV_RES_R table.
SERVICE_RESOURCE_CD DOUBLE N The service resource that is mapped to the pharmacy health plan on the same row.
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 - RX_HEALTH_PLAN_SERV_RES_R


Child Column in RX_HEALTH_PLAN_SERV_RES_R(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID RX_HEALTH_PLAN HEALTH_PLAN_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


RX_HEALTH_PLAN_SWITCH_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RX HEALTH PLAN SWITCH R
Definition: Health Plan Switch relation
Table Type: REFERENCE





Column Detail - RX_HEALTH_PLAN_SWITCH_R


Column Name Type Null? Definition
BIN_NBR VARCHAR(200) Y BIN Number associated with a switch
HEALTH_PLAN_ID DOUBLE N ID generated for a specific health plan
PROC_CONTROL_NUMBER CHAR(20) Y proc control number
SEQUENCE DOUBLE Y Order of indicated switches
SWITCH_CD DOUBLE N Value associated with a specific switch
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 - RX_HEALTH_PLAN_SWITCH_R


Child Column in RX_HEALTH_PLAN_SWITCH_R(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID