PBS_ATC_ITEM



Column Section Top of Page


Table-level Detail

Description: PBS_ATC_ITEM
Definition: Australian Pharmaceutical Benefits Schedule - Anatomic Therapeutic Class data
Table Type: REFERENCE





Column Detail - PBS_ATC_ITEM


Column Name Type Null? Definition
ATC_CODE VARCHAR(20) N 1st level - a - anatomic main group 2nd level - nn - therapeutic main group 3rd level - a - therapeutic sub group 4th level - a - chemical/therapeutic subgroup 5th level - nn - subgroup for chemical substance
ATC_MEANING VARCHAR(100) N World Health Org ATC description
PBS_ATC_ID DOUBLE N This is the value of the unique primary identifier of the PBS_ATC_ITEM table. It is an internal system assigned 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.


PBS_AUTHORITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_AUTHORITY
Definition: Australian Pharmaceutical Benefits Schedule ¿ Authority Method
Table Type: REFERENCE





Column Detail - PBS_AUTHORITY


Column Name Type Null? Definition
AUTHORITY_CD DOUBLE N Streamlined Authority Method - CODE SET 28682
PBS_AUTHORITY_ID DOUBLE N This is the value of the unique primary identifier of the PBS_AUTHORITY table. It is an internal system assigned number.
PBS_INDICATION_ID DOUBLE N Foreign key from PBS_INDICATION table
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_AUTHORITY


Child Column in PBS_AUTHORITY(FK) Parent Table Name Parent Column Name
Parents: PBS_INDICATION_ID PBS_INDICATION PBS_INDICATION_ID


PBS_CAUTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_CAUTION
Definition: Australian Pharmaceutical Benefits Schedule Caution Text
Table Type: REFERENCE





Column Detail - PBS_CAUTION


Column Name Type Null? Definition
CAUTION_IDENT DOUBLE N PBS XML caution id
CAUTION_TEXT LONGTEXT Y Caution Text - LONG text format
PBS_CAUTION_ID DOUBLE N This is the value of the unique primary identifier of the PBS_CAUTION table. It is an internal system assigned 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_CAUTION




Parent Column in PBS_CAUTION (PK) Child Table Name Child Column Name
Children: PBS_CAUTION_ID PBS_CAUTION_RELTN PBS_CAUTION_ID


PBS_CAUTION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_CAUTION_RELTN
Definition: Store relationship between a PBS Item and caution text
Table Type: REFERENCE





Column Detail - PBS_CAUTION_RELTN


Column Name Type Null? Definition
PBS_CAUTION_ID DOUBLE N Foreign Key PBS_CAUTION
PBS_CAUTION_RELTN_ID DOUBLE N Primary Key for table.
PBS_ITEM_ID DOUBLE N Foreign Key PBS_ITEM
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_CAUTION_RELTN


Child Column in PBS_CAUTION_RELTN(FK) Parent Table Name Parent Column Name
Parents: PBS_CAUTION_ID PBS_CAUTION PBS_CAUTION_ID
PBS_ITEM_ID PBS_ITEM PBS_ITEM_ID


PBS_DRUG



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_DRUG
Definition: Australian Pharmaceutical Benefits Schedule - definition of generic drug forms and strengths.
Table Type: REFERENCE





Column Detail - PBS_DRUG


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.
BRAND_IDENT VARCHAR(45) N Brand xml reference id
BRAND_NAME VARCHAR(45) N Brand Name. May be truncated at 45 char.
DRUG_UUID VARCHAR(255) N The drug unique universal identifier
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.
FORM_LEGAL VARCHAR(400) Y Form Strength legal documentation
FORM_PACK VARCHAR(100) Y FORM PACK column
FORM_STRENGTH VARCHAR(400) N Form Strength. Concatenated form and strength, may be truncated at 150 char.
PACK_SIZE DOUBLE N Quantity contained in manufacturer's package
PACK_SIZE_UNIT_CD DOUBLE N Pack size code related to pack_size_item. code set 54
PBS_DRUG_ID DOUBLE N This is the value of the unique primary identifier of the PBS_DRUG table. It is an internal system assigned number.
PBS_ITEM_ID DOUBLE N Foreign Key PBS_ITEM
PBS_MANUFACTURER_ID DOUBLE N Foreign key PBS_MANF
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_DRUG


Child Column in PBS_DRUG(FK) Parent Table Name Parent Column Name
Parents: PBS_ITEM_ID PBS_ITEM PBS_ITEM_ID
PBS_MANUFACTURER_ID PBS_MANF PBS_MANUFACTURER_ID




Parent Column in PBS_DRUG (PK) Child Table Name Child Column Name
Children: PBS_DRUG_ID PBS_OCS_MAPPING PBS_DRUG_ID