Table Detail Report
PBS_INDICATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PBS_INDICATION |
Definition: | Australian Pharmaceutical Benefits Schedule - Stores links between PBS items and restrictions/indications for use |
Table Type: | REFERENCE |
Column Detail - PBS_INDICATION
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
INDICATION_IDENT | DOUBLE | N | PBS xml indication id |
PBS_INDICATION_ID | DOUBLE | N | This is the value of the unique primary identifier of the PBS_INDICATION table. It is an internal system assigned number. |
PBS_LISTING_ID | DOUBLE | N | Foreign key from PBS_LISTING table |
RESTRICTION_TEXT | LONGTEXT | Y | Restriction Indication Text |
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 - PBS_INDICATION
Child Column in PBS_INDICATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PBS_LISTING_ID | PBS_LISTING | PBS_LISTING_ID |
Parent Column in PBS_INDICATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PBS_INDICATION_ID | PBS_AUTHORITY | PBS_INDICATION_ID |
PBS_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PBS_ITEM |
Definition: | Australian Pharmaceutical Benefits Schedule - definition of a generic drug |
Table Type: | REFERENCE |
Column Detail - PBS_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CAUTION_FLAG | DOUBLE | N | Drug has cautionary information. 1 - Caution attached, 0 - Otherwise |
DRUG_NAME | VARCHAR(200) | N | Drug Name. May be truncated at 200 char. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
NBR_OF_DAYS_BETWEEN_REFILLS | DOUBLE | N | Number of days between refills for SN20DR rule |
NOTE_FLAG | DOUBLE | N | Drug has additional notes attached. 1 - note attached, 0 - otherwise |
PBS_ITEM_ID | DOUBLE | N | This is the value of the unique primary identifier of the PBS_ITEM table. It is an internal system assigned number. |
PBS_ITEM_IDENT | VARCHAR(11) | N | PBS Item XML reference id |
PBS_LISTING_ID | DOUBLE | N | Foreign key PBS_LISTING |
SN20DR_IND | DOUBLE | N | Indicates if the SN20DR rule applies to the PBS item code |
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 - PBS_ITEM
Child Column in PBS_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PBS_LISTING_ID | PBS_LISTING | PBS_LISTING_ID |
Parent Column in PBS_ITEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PBS_ITEM_ID | PBS_CAUTION_RELTN | PBS_ITEM_ID |
PBS_DRUG | PBS_ITEM_ID | ||
PBS_NOTE_RELTN | PBS_ITEM_ID |
PBS_LISTING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PBS_LISTING |
Definition: | Australian Pharmaceutical Benefits Schedule - information on the availability of PBS items. |
Table Type: | REFERENCE |
Column Detail - PBS_LISTING
Column Name | Type | Null? | Definition |
---|---|---|---|
ATC_PRINT_OPTION | VARCHAR(1) | N | Determines how entry is printed in published PBS manual. 1 - print full entry only 2 - print full entry with cross ref 3 - print drug name only 4 - do not print |
DANGEROUS_DRUG_FEE_TXT | VARCHAR(10) | Y | Dangerous Drug Fee Indicator |
DISPENSE_FEE_TYPE_CODE | VARCHAR(2) | N | Dispense Fee Type Code. Additional fees based on dispense type. NF - No Fee RP - ready Prepared EP - extemp prepared EW - extemp + water |
DRUG_TYPE_MEAN | VARCHAR(2) | N | Drug type meaning |
INCREASE_MAXIMUM_QTY | DOUBLE | Y | Maximum Quantity increase limit |
INCREASE_NBR_OF_RPT | DOUBLE | Y | Number of Repeat increase limit |
MAXIMUM_QTY | DOUBLE | N | Maximum quantity approved for dispense. Whole number only |
MAXIMUM_QTY_UNIT_CD | DOUBLE | N | Maximum quantity code related to MAXIMUM_QTY. Code Set 54 |
NUMBER_OF_RPT | DOUBLE | N | Maximum number of repeats/refills approved. Whole number only |
PBS_ATC_ID | DOUBLE | N | Foreign Key value from PBS_ATC table. Anatomic Therapeutic Class code. |
PBS_ITEM_CODE | VARCHAR(5) | N | PBS Code |
PBS_ITEM_IDENT | VARCHAR(11) | N | PBS Item XML reference ID |
PBS_LISTING_ID | DOUBLE | N | This is the value of the unique primary identifier of the PBS_LISTING table. It is an internal system assigned number. |
RESTRICTION_CODE | VARCHAR(1) | N | Restriction level U - Unrestricted R - Restricted A - Authority Required |
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 - PBS_LISTING
Parent Column in PBS_LISTING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PBS_LISTING_ID | PBS_INDICATION | PBS_LISTING_ID |
PBS_ITEM | PBS_LISTING_ID | ||
PBS_PRICING | PBS_LISTING_ID |
PBS_LOAD_SN20DR
Column Section | Top of Page |
Table-level Detail
Description: | PBS LOAD SN20DR |
Definition: | Load table for PBS SN20DR data (in table PBS_ITEM). Table is loaded via Readme processes. |
Table Type: | REFERENCE |
Column Detail - PBS_LOAD_SN20DR
Column Name | Type | Null? | Definition |
---|---|---|---|
NBR_OF_DAYS_BETWEEN_REFILLS | DOUBLE | N | Number of days between refills for SN20DR rule |
PBS_ITEM_CODE | VARCHAR(5) | N | PBS Code |
SN20DR_TXT | VARCHAR(1) | N | Indicates if the SN20DR rule applies to the PBS Item Code. |
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. |
PBS_MANF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PBS_MANF |
Definition: | Australian Pharmaceutical Benefits Manufacturer data |
Table Type: | REFERENCE |
Column Detail - PBS_MANF
Column Name | Type | Null? | Definition |
---|---|---|---|
FACSIMILIE_NUMBER | VARCHAR(16) | N | Facsimile number ¿ numeric only |
MANUFACTURER_CODE | VARCHAR(20) | N | PBS XML manufacturer code |
MANUFACTURER_IDENT | VARCHAR(8) | N | Manufacturer XML Reference ID |
MANUFACTURER_NAME | VARCHAR(99) | N | Manufacturer name |
PBS_MANUFACTURER_ID | DOUBLE | N | This is the value of the unique primary identifier of the PBS_MANF table. It is an internal system assigned number. |
STREET_ADDRESS | VARCHAR(200) | N | Street address |
TELEPHONE_NUMBER | VARCHAR(16) | N | Telephone number |
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 - PBS_MANF
Parent Column in PBS_MANF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PBS_MANUFACTURER_ID | PBS_DRUG | PBS_MANUFACTURER_ID |