Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
PERSON_NUMBER | varchar(16) | not null | Identifies a Patient uniquely across multiple sites for a single enterprise |
PAT_NUM | varchar(12) | not null | Patient Number |
CVX_CODE | varchar(6) | not null | CVX(Vaccine Administered) Code.(Link to PHM_CVXCODES_MASTER.CVX_CODE) |
SEQ | varchar(12) | not null | Sequence Number |
PMP | varchar(5) | null | Pharmacy Order Number |
VACCINE | varchar(80) | null | Vaccine |
DOSE | varchar(120) | null | Dose |
CHARTED_DATE_TIME | varchar(18) | null | Charted Date/Time. Value could be MM/YYYY, MM/DD/YYYY, or MM/DD/YYYY HH:MM, or MM/DD/YYYY HH:MMxx |
CHARTED_BY_INITIALS | varchar(6) | null | Charted By Initials |
CHARTED_BY_NAME | varchar(32) | null | Charted By Name |
ROUTE_CODE | varchar(10) | null | Route Code |
ROUTE_CODE_DESC | varchar(18) | null | Route Code Description |
DR_NO | varchar(6) | null | Doctor Number |
DR_NAME | varchar(23) | null | Doctor Name |
DR_NPI | varchar(10) | null | Doctor NPI(National Provider Identifier) |
ADMIN_SITE_CODE | varchar(12) | null | Admin Site Code |
ADMIN_SITE_CODE_DESC | varchar(32) | null | Admin Site Code Description |
LOT_NUMBER | varchar(30) | null | Lot Number |
MFG_CODE | varchar(6) | null | Manufacturer Code |
MFG_CODE_DESC | varchar(30) | null | Manufacturer Code Description |
EXP_DATE | varchar(10) | null | Expiration Date(MM/YYYY or MM/DD/YYYY) |
ADMIN_NO | varchar(3) | null | Admin Number |
VACCINE_INFO_CODE | varchar(3) | null | Vaccine Information Code |
VACCINE_INFO_STATEMENT | varchar(40) | null | Vaccine Information Statement |
VACCINE_INFO_PUB_DATE | varchar(10) | null | Vaccine Information Publication Date(MM/DD/YYYY) |
VACCINE_ELIGIBILITY_CODE | varchar(3) | null | Vaccine Eligibility Code |
VACCINE_ELIGIBILITY_CODE_DESC | varchar(65) | null | Vaccine Eligibility Code Description |
NOT_GIVE_TYPE | varchar(12) | null | Not Given Type(Refused or Immune) |
REFU_OR_IMMU_RSN_CODE | varchar(9) | null | Refused or Immune Reason Code |
REFU_OR_IMMU_RSN_CODE_DESC | varchar(69) | null | Refused or Immune Reason Code Description |
NOTES | varchar(180) | null | Notes |
SOURCE_CODE | varchar(2) | null | Source Code |
SOURCE_CODE_DESC | varchar(65) | null | Source Code Description |
OCCURRENCE_DATTIM | varchar(12) | null | Occurrence Date/Time(YYYYMMDDHHMM) |
STATUS | varchar(12) | null | Status |
ENTER_BY_INITIALS | varchar(6) | null | Enter By Initials |
ENTER_BY_NAME | varchar(32) | null | Enter By Name |
ENTERED_DATTIM | varchar(12) | null | Entered Date/Time(YYYYMMDDHHMM) |
ITN | varchar(12) | null | Internal Number used to create a Unique Key for Active Patient Files |
IMR | varchar(16) | null | Internal Number used to create a Unique Key for Historical Files |
NDC_NUMBER | varchar(14) | null | NDC(National Drug Code) Number |
BRAND_NAME | varchar(30) | null | Brand Name of Drug |
GENERIC_NAME | varchar(30) | null | Generic Name of Drug |
PRIMARY_NAME_IND | varchar(8) | null | Primary Name Indicator. Indicates whether or not the Primary Name is Brand or Generic.(0=Generic, 1=Brand) |
DATA_SOURCE | varchar(512) | null | Source of Data |
DATA_SOURCE_AUTHOR | varchar(512) | null | Data Source Author |
DATA_SOURCE_TITLE | varchar(512) | null | Data Source Title |
EXTERNAL_SYSTEM | varchar(3) | null | External System(AIS or IIS) |
RECONCILE_STATE | varchar(16) | null | Reconcile State(Rejected or Accepted) |
RECONCILE_DATE_TIME | varchar(18) | null | Reconcile Date/Time(MM/DD/YYYY HH:MM, or MM/DD/YYYY HH:MMxx) |
RECONCILE_BY_INITIALS | varchar(6) | null | Reconcile By Initials |
RECONCILE_BY_NAME | varchar(32) | null | Reconcile By Name |
NCIT_ROUTE_CODE | varchar(6) | null | NCIT(National Cancer Institute Thesaurus) Route Code |
NCIT_ROUTE_CODE_DESC | varchar(30) | null | NCIT(National Cancer Institute Thesaurus) Route Code Description |
VACCINE_INFO_BARCODE | varchar(24) | null | Vaccine Information Barcode |
FUNDING_SOURCE_CODE | varchar(6) | null | Funding Source Code |
FUNDING_SOURCE_CODE_DESC | varchar(30) | null | Funding Source Code Description |
POPULATION_GROUP_CODE | VARCHAR(15) | NULL | Population Group code |
POPULATION_GROUP_CODE_DESC | VARCHAR(45) | NULL | Population Group code Description |
PATIENT_OID | INT | not null | Soarian Clinicals Patient OID. Not valued on Pharmacy system. Only used by Soarian Clinicals as part of EHI(Electronic Health Information) Export. |
|
|
|