INFOSCAN_NOTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infoscan notes
Definition: Notes reference data for InfoScan data
Table Type: REFERENCE





Column Detail - INFOSCAN_NOTE


Column Name Type Null? Definition
NOTES VARCHAR(250) N notes text
NOTE_ADVISE_RESTRICT_IND DOUBLE Y 1- Advisory 2- Restrictions
NOTE_IDENTIFIER VARCHAR(10) N external identifier defined by infoscan
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 - INFOSCAN_NOTE




Parent Column in INFOSCAN_NOTE (PK) Child Table Name Child Column Name
Children: NOTE_IDENTIFIER INFOSCAN_PRODUCT NOTE_IDENTIFIER


INFOSCAN_ORG



Column Section Top of Page


Table-level Detail

Description: InfoScan Organization
Definition: InfoScan Organization Table
Table Type: REFERENCE





Column Detail - INFOSCAN_ORG


Column Name Type Null? Definition
ADDR1 VARCHAR(40) Y Address 1Column
CITY VARCHAR(40) Y cityColumn
FORMULARY_IDENTIFIER VARCHAR(10) N formulary identifierColumn
INFOSCAN_ORG_IDENTIFIER VARCHAR(15) N InfoScan Organization IdentifierColumn
INJECT_DRUG_CVRG_FLAG DOUBLE Y injectable drug coverage flagColumn
NAME VARCHAR(80) Y nameColumn
NEW_APP_DRUG_CVRG_FLAG DOUBLE Y newly approved drug coverageColumn
NON_FORMU_CVRG_FLAG DOUBLE Y non formulary drug coverage flagColumn
OC_CVRG_FLAG DOUBLE Y oral contraceptive coverage flagColumn
OTC_CVRG_FLAG DOUBLE Y OTC coverage flagColumn
POLICY_BRAND_INTERCHG_FLAG DOUBLE Y policy brand interchange flagColumn
POLICY_BRAND_REIMBURSE_FLAG DOUBLE Y policy brand reimburse flagColumn
POLICY_GENERIC_DRUG_FLAG DOUBLE Y policy generic drug flagColumn
POLICY_UNLISTED_DRUG_FLAG DOUBLE Y policy unlisted drug flagColumn
SMOKE_CESS_CVRG_FLAG DOUBLE Y smoking cessation coverage flagColumn
STATE CHAR(2) Y stateColumn
TIER_FLAG DOUBLE Y tier flagColumn
TYPE_FLAG DOUBLE N Type of Healthcare Organization or Plan. 1 - HMO, 2 - PPO, 3 - Insurer, 4 - Employer, 5 - PBM, 6 - POS, 7 - Medicaid, 8 - Medical Group
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.
XPRMNTL_DRUG_CVRG_FLAG DOUBLE Y experimental drug coverage flagColumn


INFOSCAN_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: InfoScan product
Definition: InfoScan product Table
Table Type: REFERENCE





Column Detail - INFOSCAN_PRODUCT


Column Name Type Null? Definition
FORMULARY_IDENTIFIER VARCHAR(10) N formulary identifierColumn
MULTUM_FLAG DOUBLE Y indicates which Multum tables to retrieve record from
MULTUM_IDENTIFIER DOUBLE N Multum identifierColumn
MULTUM_NAME_CODE VARCHAR(11) N Multum name codeColumn
NOTE_IDENTIFIER VARCHAR(10) N note identifierColumn
PROD_FORMU_STATUS_FLAG DOUBLE Y product formulary status flagColumn
THERAP_CLASS_IDENTIFIER DOUBLE N therapeutic class identifierColumn
THERAP_SUB_CLASS_IDENTIFIER DOUBLE N therapeutic sub class identifierColumn
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 - INFOSCAN_PRODUCT


Child Column in INFOSCAN_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: NOTE_IDENTIFIER INFOSCAN_NOTE NOTE_IDENTIFIER
THERAP_CLASS_IDENTIFIER INFOSCAN_TC THERAP_CLASS_IDENTIFIER
THERAP_SUB_CLASS_IDENTIFIER INFOSCAN_TC THERAP_SUB_CLASS_IDENTIFIER


INFOSCAN_TC



Column Section Relationship Section Top of Page


Table-level Detail

Description: InfoScan Therapeutic Class
Definition: InfoScan Therapeutic Class Table
Table Type: REFERENCE





Column Detail - INFOSCAN_TC


Column Name Type Null? Definition
THERAP_CLASS_DESC VARCHAR(80) Y Therapeutic class descriptionColumn
THERAP_CLASS_IDENTIFIER DOUBLE N Therapeutic class identifierColumn
THERAP_SUB_CLASS_DESC VARCHAR(80) Y Therapeutic sub class descriptionColumn
THERAP_SUB_CLASS_IDENTIFIER DOUBLE N Therapeutic sub class identifierColumn
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 - INFOSCAN_TC




Parent Column in INFOSCAN_TC (PK) Child Table Name Child Column Name
Children: THERAP_CLASS_IDENTIFIER INFOSCAN_PRODUCT THERAP_CLASS_IDENTIFIER
THERAP_SUB_CLASS_IDENTIFIER INFOSCAN_PRODUCT THERAP_SUB_CLASS_IDENTIFIER


MLTM_ADDITIONAL_DOSEFORM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Multum additional doseform
Definition: This table contains a listing of additional terms that may be used to describe a solid oral dosage form (such as sugar coated, film coated, or layered). Each description has a unique identifier.
Table Type: REFERENCE





Column Detail - MLTM_ADDITIONAL_DOSEFORM


Column Name Type Null? Definition
ADDITIONAL_DOSEFORM_DESC VARCHAR(255) Y additional terms that may be used to describe a solid oral dosage form
ADDITIONAL_DOSEFORM_ID DOUBLE N The PK value for this table.
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 - MLTM_ADDITIONAL_DOSEFORM




Parent Column in MLTM_ADDITIONAL_DOSEFORM (PK) Child Table Name Child Column Name
Children: ADDITIONAL_DOSEFORM_ID MLTM_NDC_IMAGE ADDITIONAL_DOSEFORM_ID