Table Detail Report

PBS_NOTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_NOTE
Definition: Australian Pharmaceutical Benefits Schedule Note Text
Table Type: REFERENCE





Column Detail - PBS_NOTE


Column Name Type Null? Definition
NOTE_IDENT DOUBLE N PBS XML NOTE_ID
NOTE_TEXT LONGTEXT Y Note Text - LONG text format
PBS_NOTE_ID DOUBLE N This is the value of the unique primary identifier of the PBS_NOTE 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_NOTE




Parent Column in PBS_NOTE (PK) Child Table Name Child Column Name
Children: PBS_NOTE_ID PBS_NOTE_RELTN PBS_NOTE_ID


PBS_NOTE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_NOTE_RELTN
Definition: Store relationship between a PBS Item and note text
Table Type: REFERENCE





Column Detail - PBS_NOTE_RELTN


Column Name Type Null? Definition
PBS_ITEM_ID DOUBLE N Foreign Key PBS_ITEM
PBS_NOTE_ID DOUBLE N Foreign Key PBS_NOTE
PBS_NOTE_RELTN_ID DOUBLE N Primary Key for 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_NOTE_RELTN


Child Column in PBS_NOTE_RELTN(FK) Parent Table Name Parent Column Name
Parents: PBS_ITEM_ID PBS_ITEM PBS_ITEM_ID
PBS_NOTE_ID PBS_NOTE PBS_NOTE_ID


PBS_OCS_MAPPING



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_OCS_MAPPING
Definition: Map PBS Codes to Millennium order_catalog_synonym table
Table Type: REFERENCE





Column Detail - PBS_OCS_MAPPING


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.
DRUG_IDENTIFIER VARCHAR(99) N DNUM. Key to MLTM_DRUG_ID table
DRUG_SYNONYM_ID DOUBLE N CNUM. Key to MLM_DRUG_NAME table
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.
MAIN_MULTUM_DRUG_CODE DOUBLE N FK value from MLTM_NDC_MAIN_DRUG_CODE
PBS_DRUG_ID DOUBLE N Foreign Key PBS_DRUG
PBS_OCS_MAPPING_ID DOUBLE N SEQUENCE NAME:REFERENCE SEQThis is the value of the unique primary identifier of the PBS_OCS_MAPPING table. It is an internal system assigned number.
SYNONYM_ID DOUBLE N Foreign Key ORDER_CATALOG_SYNONYM
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_OCS_MAPPING


Child Column in PBS_OCS_MAPPING(FK) Parent Table Name Parent Column Name
Parents: DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER
DRUG_SYNONYM_ID MLTM_DRUG_NAME DRUG_SYNONYM_ID
MAIN_MULTUM_DRUG_CODE MLTM_NDC_MAIN_DRUG_CODE MAIN_MULTUM_DRUG_CODE
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PBS_DRUG_ID PBS_DRUG PBS_DRUG_ID


PBS_PRICING



Column Section Relationship Section Top of Page


Table-level Detail

Description: PBS_PRICING
Definition: Australian Pharmaceutical Benefits Schedule - definition of pricing information
Table Type: REFERENCE





Column Detail - PBS_PRICING


Column Name Type Null? Definition
BRAND_IDENT VARCHAR(45) Y Brand XML Reference Identifier
BRAND_PREMIUM DOUBLE N Brand Premium Amt
DISPENSED_COMMONWEALTH DOUBLE N Commonwealth dispensed price
DISPENSED_MANUFACTURER DOUBLE N Manufacturer dispensed price
DISPENSED_RETAIL DOUBLE N Retail dispensed price
DISPENSING_INCENTIVE DOUBLE N Dispensing incentive price
MAX_SAFETY_NET_VALUE DOUBLE N Max_val_for_safety_net amt
PBS_LISTING_ID DOUBLE N Foreign key PBS_LISTING
PBS_PRICING_ID DOUBLE N This is the value of the unique primary identifier of the PBS_PRICING table. It is an internal system assigned number.
PER_PACK_COMMONWEALTH DOUBLE N Commonwealth price per pack
PER_PACK_MANUFACTURER DOUBLE N Manufacturer price per pack
PER_PACK_REIMBURSEMENT DOUBLE N Reimbursement price per pack
PER_PACK_RETAIL DOUBLE N Retail price per pack
SPECIAL_PATIENT DOUBLE N Special patient premium amt
THERAPEUTIC_GROUP DOUBLE N Therapeutic_group_premium amt
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_PRICING


Child Column in PBS_PRICING(FK) Parent Table Name Parent Column Name
Parents: PBS_LISTING_ID PBS_LISTING PBS_LISTING_ID