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