| ID | EXTEMPORANEOUS_PREPARATION | 
|---|---|
| Method | GET | 
| URI | 
 | 
| Embargo Data | No | 
| Requires authentication | No | 
| Description | A table listing all standard formula preparations with agreed prices which can be prepard extemporaneously by a compounding pharmacist. | 
Parameters
| Parameter | Description | Default | Required | Example | 
| format | specifies the output format | JSON | false | ?format=csv | 
| include_header | specifies whether a header is included in the results. Note: only works for CSV output formats. | false | false | ?include_header=true | 
| download | specifies whether the request should prompt a download response in the user's browser (Chrome compatible) | false | false | ?download=true | 
| SCHEDULE_CODE | Schedule Code is a unique identifier given to each month's Schedule. By having a Schedule Code in each table, 13 months (schedules) worth of data can be maintained in the Data Mart to assist users in the identification of Delisted Items and change-over-time. In order to see what year/month/effective date a schedule code refers to, look it up in the SCHEDULE_T table | false | ?SCHEDULE_CODE=**exampleValue** | |
| PREPARATION | Specifies the form in which a standard formula preparation is provided. Required for PBS website, legislative instruments and Schedule of Pharmaceutical Benefits | false | ?PREPARATION=**exampleValue** | |
| MAXIMUM_QUANTITY | The maximum quantity of a pharmaceutical benefit allowed to be prescribed/dispensed as recommended by the Pharmaceutical Benefits Advisory Committee (PBAC). | false | ?MAXIMUM_QUANTITY=**exampleValue** | |
| NUMBER_OF_REPEATS | The number of repeat prescriptions of a pharmaceutical benefit allowed to be prescribed/dispensed as recommended by the Pharmaceutical Benefits Advisory Committee (PBAC). | false | ?NUMBER_OF_REPEATS=**exampleValue** | |
| SFP_PBS_CODE | The PBS Code/item code given to a standard formula preparation drug. Required for the PBS website and Schedule of Pharmaceutical Benefits. | false | ?SFP_PBS_CODE=**exampleValue** | |
| PBS_CODE | PBS Item Code relates directly to a Prescribing Rule in PharmCIS. A drug/form combination will have a different PBS Item Code for each combination of maximum quantity (or maximum amount), number of repeats, pack quantity or if the drug/form combination is listed on different programs. This information is required for the PBS website, Schedule of Pharmaceutical Benefits and legislative instruments compiled by the PBS Publishing Team. | false | ?PBS_CODE=**exampleValue** | |
| SFP_DRUG_NAME | The name given to a standard formula preparation drug using Australian Medicine Terminology (AMT) naming conventions. Required for PBS websites, the Schedule of Pharmaceuitcal Benefits and the legislative instruments compiled by the PBS Publishing Team. | false | ?SFP_DRUG_NAME=**exampleValue** | |
| SFP_REFERENCE | Indicates the Pharmaceutical Reference Standards which must be applied when specific drugs are compounded by a pharmacy. | false | ?SFP_REFERENCE=**exampleValue** | 
Example
curl -d https://aucapiapppbspilot.azurewebsites.net/EXTEMPORANEOUS_PREPARATION?format=csv&include_header=true&schedule_code=2710
Sample Response
Get November 2020 Schedule's EXTEMPORANEOUS_PREPARATION data in CSV format
https://aucapiapppbspilot.azurewebsites.net/EXTEMPORANEOUS_PREPARATION?format=csv&include_header=true&schedule_code=2710
Sample output:
**insert here**
Created on , last edited on 7/12/2020