File_Layout_Pre-June2002

Field Name	Size	Position	Description
MC_CODE	7	1-7	Old Medi-Cal code. Obsolete, maintained only for data compatibility reasons.
LABEL_NAME	30	8-37	The brand name, strength, and dosage form of the drug.
NDC	11	38-48	National Drug Code number
PKG_SIZE	12	49-60	Package size
UNIT	2	61-62	Unit of measurement, with the following meanings: AP = ampule; CP = capsule; EA = each; GM = gram; IN = insert; ML = milliliter (cc); OT = other; SP = suppository; TB = tablet.
QTY	12	63-74	Number of units reported as dispensed. This is only as reliable as the submitter of the claim.
LOWEST	10	75-84	The price Medi-Cal was willing to pay for that product, on the date the report was produced. It is the lowest of AWP - 5%, or Direct Price for certain companies, or the Federal Upper Limit price, or the State Maximum Allowable Ingredient Cost (MAIC) price.
ING_COST	12	85-96	The estimated ingredient cost. It is calculated by multiplying the quantity reported on a single claim by the "lowest" price in effect on the claim's date of service. The ingredient costs for each claim are summed to give the total ingredient cost for each NDC. Since quantities reported by pharmacies are not always accurate, the estimated ingredient cost often is far from accurate, especially for liquids. It tends to be more accurate for tablets and capsules.
PD_ON_TAR	8	97-104	The number of claims paid where a Treatment Authorization Request (TAR) number is present on the claim.
AMT_PAID	14	105-118	The total amount paid.
AVG_PAID	8	119-126	The average amount paid per prescription.
DAYSUPPLY	14	127-140	The total days supply, taken from the estimated days supply reported on each claim. This number is only as reliable as the submitter of the claim, and tends to be more accurate for tablets and capsules taken on a regular basis.
NO_RXS	10	141-150	The total number of claim lines paid.
Total bytes per record	151

Field Name

Size

Position

Description

MC_CODE

1-7

Old Medi-Cal code. Obsolete, maintained only for data compatibility reasons.

LABEL_NAME

8-37

The brand name, strength, and dosage form of the drug.

NDC

38-48

National Drug Code number

PKG_SIZE

49-60

Package size

UNIT

61-62

Unit of measurement, with the following meanings: AP = ampule; CP = capsule; EA = each; GM = gram; IN = insert; ML = milliliter (cc); OT = other; SP = suppository; TB = tablet.

QTY

63-74

Number of units reported as dispensed. This is only as reliable as the submitter of the claim.

LOWEST

75-84

The price Medi-Cal was willing to pay for that product, on the date the report was produced. It is the lowest of AWP - 5%, or Direct Price for certain companies, or the Federal Upper Limit price, or the State Maximum Allowable Ingredient Cost (MAIC) price.

ING_COST

85-96

The estimated ingredient cost. It is calculated by multiplying the quantity reported on a single claim by the "lowest" price in effect on the claim's date of service. The ingredient costs for each claim are summed to give the total ingredient cost for each NDC. Since quantities reported by pharmacies are not always accurate, the estimated ingredient cost often is far from accurate, especially for liquids. It tends to be more accurate for tablets and capsules.

PD_ON_TAR

97-104

The number of claims paid where a Treatment Authorization Request (TAR) number is present on the claim.

AMT_PAID

105-118

The total amount paid.

AVG_PAID

119-126

The average amount paid per prescription.

DAYSUPPLY

127-140

The total days supply, taken from the estimated days supply reported on each claim. This number is only as reliable as the submitter of the claim, and tends to be more accurate for tablets and capsules taken on a regular basis.

NO_RXS

141-150

The total number of claim lines paid.

Total bytes per record

151

Field Name	Type	Width	Dec	Description
MC_CODE	Character	7		Old Medi-Cal code. Obsolete, maintained only for data compatibility reasons.
LABEL_NAME	Character	30		The brand name, strength, and dosage form of the drug.
NDC	Character	11		National Drug Code number
PKG_SIZE	Numeric	12	3	Package size
UNIT	Character	2		Unit of measurement, with the following meanings: AP = ampule; CP = capsule; EA = each; GM = gram; IN = insert; ML = milliliter (cc); OT = other; SP = suppository; TB = tablet.
QTY	Numeric	12		Number of units reported as dispensed. This is only as reliable as the submitter of the claim.
LOWEST	Numeric	10	4	The price Medi-Cal was willing to pay for that product, on the date the report was produced. It is the lowest of AWP - 5%, or Direct Price for certain companies, or the Federal Upper Limit price, or the State Maximum Allowable Ingredient Cost (MAIC) price.
ING_COST	Numeric	12	2	The estimated ingredient cost. It is calculated by multiplying the quantity reported on a single claim by the "lowest" price in effect on the claim's date of service. The ingredient costs for each claim are summed to give the total ingredient cost for each NDC. Since quantities reported by pharmacies are not always accurate, the estimated ingredient cost often is far from accurate, especially for liquids. It tends to be more accurate for tablets and capsules.
PD_ON_TAR	Numeric	8		The number of claims paid where a Treatment Authorization Request (TAR) number is present on the claim.
AMT_PAID	Numeric	14	2	The total amount paid.
AVG_PAID	Numeric	8	2	The average amount paid per prescription.
DAYSUPPLY	Numeric	14		The total days supply, taken from the estimated days supply reported on each claim. This number is only as reliable as the submitter of the claim, and tends to be more accurate for tablets and capsules taken on a regular basis.
NO_RXS	Numeric	10		The total number of claim lines paid.
Total bytes per record	151