United States Health Information Knowledgebase

 

Pharmacy Claims File Submission

Utah

Versions: August 12, 2009 - v1.3• December 5, 2013 - v2.0Compare Versions


At A Glance

Name:Pharmacy Claims File Submission
State:Utah
Definition:Not Provided
VersionDecember 5, 2013 - v2.0

File Specification for Pharmacy Claims File Submission

Data Element ID Data Element Description Type Format Length
PC001 Payer Code Distributed by OHCS varchar 8
PC002 Payer Name Distributed by OHCS varchar 30
PC003 Insurance Type/Product Code Not Provided char 2
PC004 Payer Claim Control Number Must apply to the entire claim and be unique within the payer's system. varchar 35
PC005 Line Counter Line number for this service. The line counter begins with 1 and is incremented by 1 for each additional service line of a claim. int 4
PC006 Insured Group Number Group or policy number - not the number that uniquely identifies the subscriber varchar 30
PC007 Subscriber Social Security Number Subscriber's social security number; Set as null if unavailable varchar 9
PC008 Plan Specific Contract Number Plan assigned subscriber's contract number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the subscriber. varchar 128
PC009 Member Suffix or Sequence Number Unique number of the member within the contract. Must be an identifier that is unique to the member. Must match ME010. varchar 20
PC010 Member Identification Code Member's social security number; Set as null if contract number = subscriber's social security number or use an alternate unique identifier such as Medicaid ID. Must be an identifier that is unique to the member. varchar 128
PC011 Individual Relationship Code Member's relationship to insured char 2
PC012 Member Gender Not Provided char 1
PC013 Member Date of Birth Not Provided Date YYYYMMDD 8
PC014 Member City Name of Residence City name of member varchar 50
PC015 Member State or Province As defined by the US Postal Service char 2
PC016 Member ZIP Code ZIP Code of member - may include non-US codes; Do not include dash. Plus 4 optional but desired. varchar 11
PC017 Date Service Approved (AP Date) date claim paid if available, otherwise set to Date Prescription Filled Date YYYYMMDD 8
PC018 Pharmacy Number Payer assigned pharmacy number. AHFS number is acceptable. varchar 30
PC019 Pharmacy Tax ID Number Federal taxpayer's identification number coded with no punctuation (carriers that contract with outside PBM's will not have this) varchar 10
PC020 Pharmacy Name Name of pharmacy varchar 50
PC021 National Provider ID Number National Provider ID. This data element pertains to the entity or individual directly providing the service. varchar 20
PC048 Pharmacy Location Street Address Street address of pharmacy Varchar 30
PC022 Pharmacy Location City City name of pharmacy - preferably pharmacy location (if mail order null) varchar 30
PC023 Pharmacy Location State As defined by the US Postal Service (if mail order null) char 2
PC024 Pharmacy ZIP Code ZIP Code of pharmacy - may include non-US codes. Do not include dash. Plus 4 optional but desired (if mail order null) varchar 10
PC024d Pharmacy Country Name Code US for United States varchar 30
PC025 Claim Status Not Provided char 2
PC026 Drug Code NDC Code varchar 11
PC027 Drug Name Text name of drug varchar 80
PC028 New Prescription or Refill Older systems provide only an "N" for new or an "R" for refill, otherwise provide refill # varchar 2
PC029 Generic Drug Indicator Not Provided char 2
PC030 Dispense as Written Code Not Provided char 1
PC031 Compound Drug Indicator Not Provided char 1
PC032 Date Prescription Filled Not Provided Date YYYYMMDD 8
PC033 Quantity Dispensed Number of metric units of medication dispensed int 5
PC034 Days Supply Estimated number of days the prescription will last int 3
PC035 Charge Amount Do not code decimal point or provide any punctuation where $1,000.00 converted to 100000 Same for all financial data that follows. int 10
PC036 Paid Amount Includes all health plan payments and excludes all member payments. Do not code decimal point. int 10
PC037 Ingredient Cost/List Price Cost of the drug dispensed. Do not code decimal point. int 10
PC038 Postage Amount Claimed Do not code decimal point. Not typically captured. int 10
PC039 Dispensing Fee Do not code decimal point. int 10
PC040 Co-pay Amount The preset, fixed dollar amount for which the individual is responsible. Do not code decimal point. int 10
PC041 Coinsurance Amount The dollar amount an individual is responsible for - not the percentage. Do not code decimal point. int 10
PC042 Deductible Amount Do not code decimal point. int 10
PC043 Unassigned Reserved for assignment (future use) Not Supplied Not Supplied Not Supplied
PC044 Prescribing Physician First Name Physician first name. varchar 25
PC045 Prescribing Physician Middle Name Physician middle name or initial. varchar 25
PC046 Prescribing Physician Last Name Physician last name. varchar 60
PC047 Prescribing Physician NPI NPI number for prescribing physician varchar 20
PC049 Member Street Address Street address of member varchar 50
PC101 Subscriber Last Name Subscriber Last Name varchar 128
PC102 Subscriber First Name Subscriber First Name varchar 128
PC103 Subscriber Middle Initial Subscriber Middle Initial char 1
PC104 Member Last Name Member Last Name varchar 128
PC105 Member First Name Member First Name varchar 128
PC106 Member Middle Initial Member Middle Initial char 1
PC201 Version Number The version number of this claim service line. The original claim will have a version number of 0, with the next version being assigned a 1, and each subsequent version being incremented by 1 for that service line. int 4
PC202 Prescription Written Date Date Prescription was written Date 8
PC047a Prescribing Physician Provider ID Provider ID for the prescribing physician varchar 30
PC047b Prescribing Physician DEA DEA number for prescribing physician varchar 20
PC899 Record Type Not Provided char 2

Downloads

Downloads
 
Download Excel
Excel
Download as an MS Excel™ spreadsheet.
[Download Excel Reader Exit Disclaimer]
 

Codes and Values

Data Element ID Data Element Code Value
PC003 Insurance Type/Product Code 12 Preferred Provider Organization (PPO)
13 Point of Service (POS)
15 Indemnity Insurance
16 Health Maintenance Organization (HMO) Medicare Advantage
17 Dental Maintenance Organization (DMO)
99 Other
CI Commercial Insurance Company
DN Dental
HM Health Maintenance Organization
HN HMO Medicare Risk/ Medicare Part C
MA Medicare Part A
MB Medicare Part B
MC Medicaid
MD Medicare Part D
MP Medicare Primary
QM Qualified Medicare Beneficiary
SP Supplemental Policy
SP Medicare Supplemental (Medi-gap) plan
TV Title V
PC011 Individual Relationship Code 01 Spouse
04 Grandfather or Grandmother
05 Grandson or Granddaughter
07 Nephew or Niece
10 Foster Child
15 Ward
17 Stepson or Stepdaughter
19 Child
20 Employee/Self
21 Unknown
22 Handicapped Dependent
23 Sponsored Dependent
24 Dependent of a Minor Dependent
29 Significant Other
32 Mother
33 Father
36 Emancipated Minor
39 Organ Donor
40 Cadaver Donor
41 Injured Plaintiff
43 Child Where Insured Has No Financial Responsibility
53 Life Partner
76 Dependent
PC012 Member Gender F Female
M Male
U UNKNOWN
PC024d Pharmacy Country Name US United States
PC025 Claim Status 01 Processed as primary
02 Processed as secondary
03 Processed as tertiary
19 Processed as primary, forwarded to additional payer(s)
20 Processed as secondary, forwarded to additional payer(s)
21 Processed as tertiary, forwarded to additional payer(s)
22 Reversal of previous payment
PC028 New Prescription or Refill 01 New prescription
02 Refill
PC029 Generic Drug Indicator 01 branded drug
02 generic drug
PC030 Dispense as Written Code 0 Not dispensed as written
1 Physician dispense as written
2 Member dispense as written
3 Pharmacy dispense as written
4 No generic available
5 Brand dispensed as generic
6 Override
7 Substitution not allowed - brand drug mandated by law
8 Substitution allowed - generic drug not available in marketplace
9 Other
PC031 Compound Drug Indicator N Non-compound drug
U Non-specified drug compound
Y Compound drug
PC899 Record Type PC
Scroll To Top