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 |