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 |