ECCnet RX Attribute Guide_v1.3

Document Sample
ECCnet RX Attribute Guide_v1.3 Powered By Docstoc
					Change Log


Date       Version Attribute                     Change                                                     Initials
 6/15/07        1.1                              Creation of Guide                                          VM

 6/27/07        1.2 *Federal Reportable          *Changed size from 1/1 to 1/2                              VM
                    *Shakable Product
                    *Sterile Product
                    *Targeted Substance

                      *DIN                       *Notes added to 'Requested Use' column for the DIN field

                                                 *Added existing RX1 fields Generic Name, Reinstatement
                      *Various                   Date, Must Sell by Days, Controlled Substance, and
                                                 Product Form Aerosol to this document.
                                                 *Product Form Aerosol code indicated - PFK.




  7/3/07        1.2 *Discontinue Date, Cancel    *Available at the AU level                                 VM
                    Date
                    *Image Last Update           *Format mmddyyyy


 7/13/07        1.3 *Label Storage Condition,    *Indicated English and French requirements.                VM
                    Markings (Front/Back/Alt),
                    Shape, Flavour, Colour

                      *Temperature Control Range *Size & Format were updated.
                      - Other

 7/23/07        1.3 *Reinstatement date          Size changed from 10 to 8/8.                               VM
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Active Ingredient Group (AIG) Number                                                     Null                                 N                        Unit                  D             Mandatory          Y per DIN   An NPN will not                   N              10/10
Definition: Specifies the Active Ingredient Group Number (AIG) assigned by Health                                                                      Item                               dependent on                    have an AIG
Canada in the Drug Product Database. The AIG number is a 10 digit number that                                                                                                            the presence of     6 allowances assigned to it.
                                                                                                                                                                                              a DIN
identifies products that have the same active ingredient(s) and ingredient
strength(s). The AIG is comprised of three portions:* the first portion (2 digits)
identifies the number of active ingredients * the second portion(5digits) identifies the
unique groups of active ingredients(s); * the last portion (3 digits) identifies the
active ingredient group strength. The strength group has a tolerance of -2% to
+10%.

Examples: 1234567890 1st 2 digits = # of active ingredients 5 digits = designates
the groups of active ingredients (Health Canada - Canadian Drug Identification
Code Book CDIC) 3 digits = identifies the active ingredient strength

Business Rule: Precursor, Controlled and Targeted Substances fields are needed
for the proper handling and storing of these products (e.g. lock-up, storage,
disposal, reporting) and also for identification of the products (i.e. patient safety)


Active Ingredient Name                                                                                   Null                 N                        Unit                  D             Mandatory               Y         Strength UOM code             AN               1/80
Active Ingredient Strength                                                                                                                             Item                               dependent on        Max of 35      list same as Size
                                                                                                                                                                                         the presence of       repeats       UOM.                           N             1/20
Active Ingredient Strength UOM
                                                                                                                                                                                          a DIN or NPN         allowed                                                   (1 dec)
Active Ingredient Strength per Typical Dose
                                                                                                                                                                                                                             Per Typical Dose
Active Ingredient Strength per Typical Dose UOM                                                                                                                                                                              UOM drop-down                  R                2/2
                                                                                                                                                                                                                             descriptions:
Definition: Specifies the name of each active ingredient, its strength and the unit of                                                                                                     per Typical                       Per Millilitres                N             1/20
measure contained in the GTIN. This attribute will repeat for each active ingredient                                                                                         O             Dose & per                        Per Milligrams                              (1 dec)
in the GTIN. Active ingredient is any component that has medicinal properties, and                                                                                                        Typical Dose                       Per Grams
supplies pharmacological activity or other direct effect in the diagnosis, cure,                                                                                                            UOM are                          Per Each                       R                2/2
mitigation, treatment or prevention of disease, or to affect structure or any function                                                                                                      Optional
                                                                                                                                                                                                                             Codes for above:
of the body of man or other animals. (Health Canada).
                                                                                                                                                                                                                             QL
                                                                                                                                                                                                                             QM
Example:                                                                                                                                                                                                                     QN
1 tablet - Rabeprazole Sodium 10mg                                                                                                                                                                                           QO
Liquid - Robitussin 10mg/5ML

Business Rule: For tablets, the active ingredient is expressed as the strength and
UOM only. Ex. Rabeprazole Sodium 10mg
For liquids, the active ingredient is expressed as the strength/UOM and per typical
dose unit of measure. Ex. Robitussin 10mg/5ML




                                                                                                                                     2                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

American Hospital Formulary System (AHFS) Classification Code                                            Null                 N                        Unit                  D            Dependant on            Y      Code list source:                 AN                8/8
                                                                                                                                                       Item                              the presence of     Maximum 6 Health Canada
Definition: Specifies the American Hospital Formulary System (AHFS) classification                                                                                                             DIN           occurrences database.
code. This may be used to identify therapeutic alternatives. This is used and
published on the Health Canada Database. Multiple codes may be assigned to a
GTIN (product).

Example:28:08:92
Business Rule: Patient Safety and Pharmacy product selection and dispensing -
(Provides searchability and therapeutic cross referencing)
Anatomical Therapeutic Chemical (ATC) Classification Code                                                Null                 N                        Unit                  D            Dependant on             N         Code list source:             AN               1/10
                                                                                                                                                       Item                              the presence of                     Health Canada
Definition: Specifies the Anatomical Therapeutic Chemical (ATC) Classification                                                                                                                 DIN                           database.
Code (source: Health Canada)
                                                                                                                                                                                                                             User should enter
Example: B01AA03
                                                                                                                                                                                                                             the Therapeutic
                                                                                                                                                                                                                             Chemical
Business Rule: ATC will assist in product identification (ie. patient safety, cross                                                                                                                                          Classification Code.
reference to other therapeutic choices).
Biomedical Hazard                                                                                        Null                 N                        Unit                  O                                     N       Codes:                           ID               2/2
                                                                                                                                                       Item                                                 Must allow for B1 = Cytotoxic /
Definition: Specifies the type of biomedical hazard that the GTIN contains (may be                                                                                                                            all three    Antineoplastic
                                                                                                                                                                                                                           Material
more than one). Options are:
                                                                                                                                                                                                                           B2 = Biologic
1. Cytotoxic / Antineoplastic Material &/or                                                                                                                                                                                Material
2. Biologic Material &/or                                                                                                                                                                                                  B3 = Radioactive
3. Radioactive Material                                                                                                                                                                                                    Material
Example: Cytotoxin contained in TamoxifenCancer treatment

Business Rule: Must know how to handle the product - work place safety.
Compliance with WHMIS (Workplace Hazardous Materials Information System).

Cancel Date                                                                                              Cancel Date          Y                         Unit                 O                                     N                                       DT                8/8
                                                                                                                                                        Item
Definition: The date an item was cancelled as defined by the Trade Item                                                                                Inner
                                                                                                                                                       Case
Identification and Communication Guidelines.
                                                                                                                                                       Pallet

Business Rule: This field may be used to indicate that the GTIN was never
manufactured or shipped by the vendor and may be removed from the Retailer’s
catalogue.




                                                                                                                                     3                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

POS Description                                                                                          POS Description      N                        Item                  O                                     N                                       AN               1/20
                                                                                                         En
Definition: The cash register description of the item. A non-structured Price Look Up
                                                                                      POS Description
description limited to 20 characters.
                                                                                                         Fr
Cases Per Layer (Tie)                                                                                    Tie (cases per       Y                        Case                  O                                     N                                        N                1/3
                                                                                                         layer)                                        Pallet
Definition: The number of cases per layer.
Change Date                                                                                              Change Date          Y                         All                  O                                     N         System generated              DT                8/8

Definition: Date of change as defined by the Trade Item Identification and
Communication Guidelines.
Controlled Drug                                                                                          Null                 N                        Item                  D            Dependant on             N         Codes:                         ID               1/4
                                                                                                                                                                                         the presence of                     CON1 = Part G
Indicate if the product is a controlled drug in the Canadian Food and Drug                                                                                                                    Federal                        Schedule - Part I
                                                                                                                                                                                           Reportable                        or
Regulations:
                                                                                                                                                                                             Indicator                       CON2 = Part G
Part G Schedule - Part I or
                                                                                                                                                                                                                             Schedule - Part II
Part G Schedule - Part II or                                                                                                                                                                                                 or
Part G Schedule - Part III or                                                                                                                                                                                                CON3 = Part G
Not Applicable                                                                                                                                                                                                               Schedule - Part III
                                                                                                                                                                                                                             or
Business Rule: Narcotic, Precursor, Controlled and Targeted fields are needed for                                                                                                                                            CON4 = Not
the proper handling and storing of these products (e.g. lock-up, storage, disposal,                                                                                                                                          Applicable
reporting) and also for identification of the products (i.e. patient safety)
                                                                                                                                                                                                                             ECCnet currently
                                                                                                                                                                                                                             has the following:
                                                                                                                                                                                                                             - Controlled
                                                                                                                                                                                                                             Substance - Class 2
                                                                                                                                                                                                                             (Controlled)


Controlled Substance                                                                                     Controlled           Y                        Item                  O                                               This field has                AN               1/80
                                                                                                         Substance                                                                                                           expanded and is
Indicates that the pharmaceutical item is classified as a "Controlled Substance".                                                                                                                                            more clearly defined
                                                                                                                                                                                                                             in the RX2 subset.
Class 2 - Controlled
Class 3 - Narcotic
Class 3N - Non-narcotic
Class 4 - Targeted
Class 5 - Precursor




                                                                                                                                     4                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Country of Origin                                                                                        Country of Origin Y                           Item                  O                                     N                                        ID               2/2

Definition: The country of origin of the item. (See Volume 4, Appendix 4 for a list of
Country Codes).

Business Rule: If the product is manufactured in more than one country leave blank
or enter the most likely country.

Discontinue Date                                                                                         Discontinue Date Y                             Unit                 O                                     N                                       DT                8/8
                                                                                                                                                        Item
Definition: The “Last Order Date” when the item is no longer available for order as                                                                    Inner
                                                                                                                                                       Case
defined by the Trade Item Identification and Communication Guidelines.
                                                                                                                                                       Pallet

Business Rule: The Discontinue Date should not be specified until a discontinue
date is known.
Dosage Form                                                                                              Dosage Form          Partially*               Item                  D            Dependant on             N      There are new                    AN               1/12
                                                                                                                                                                                         the presence of                  dosage codes for
Definition: Indicates the form of the pharmaceutical item.                                                                                                                                     DIN                        RX2. See Tab
                                                                                                                                                                                                                          Appendix A in this
See NEW Code list in Appendix A.
                                                                                                                                                                                                                          document.
Drug Identification Number (DIN)                                                                         DIN                  Partially*               Unit                  O                                  N - For   One occurrence of                AN                8/8
                                                                                                                                                       Item                                                  application DIN was available in
Definition: For Pharmaceutical items and Consumer products that have been                                                                                            Mandatory if RX                        unit DIN does RX1.
                                                                                                                                                                                                             not repeat
assigned a DIN or contain “active” ingredients, Drug Identification Number assigned
                                                                                                                                                                       Optional for
by Canadian Health Protection Branch
                                                                                                                                                                     others such as                          Y - For item
                                                                                                                                                                      OTC and PC                            level - max of
Business Rule: Mandatory for RX items, desirable for others such as toothpaste.                                                                                                                             6 occurrences




                                                                                                                                     5                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Drug Merchandising Designation/Scheduling                                                                Drug                 Partially*               Item                  M                                     N         The "Unscheduled"              ID               2/2
                                                                                                         Merchandising                                                                                                       option under the
Definition: Specifies the drug merchandising designation or scheduling by province.                                                                                                                                          Drug Merchandising
                                                                                                                                                                                                                             field does not exist
Designations include:
                                                                                                                                                                                                                             in RX1 today. It is
Schedule I (prescription),
                                                                                                                                                                                                                             part of RX2.
Schedule II (behind-the-counter),
Schedule III (over-the-counter when pharmacist present), or
Unscheduled (over-the-counter in any retail outlet).                                                                                                                                                                         New Code UN =
Source: NAPRA (National Association of Pharmacy Regulatory Authorities).                                                                                                                                                     Unscheduled

Examples: Drug is unscheduled in Ontario and Alberta

Business Rule: Required for proper handling and storage -- i.e. patient safety. For
example, Schedule III drugs must be locked up if the pharmacy section of grocery
store is closed or pharmacist is not present.

Drug Type Identifier                                                                                     Null                 N                        Item                  M                                     N         Codes                          ID               2/2
                                                                                                                                                                                                                             T1 - Brand Name
Definition: Identifies that the GTIN is either a brand name drug or generic drug. A
                                                                                                                                                                                                                             T2 - Generic
brand name drug means the first drug developed, said to be original, and put on the
market. A generic drug means any reproduction of a brand name drug.

Business Rule: Drug Type will assist in product identification (health plan coverage
may not cover Brand products). You may only select one of the two options -
Generic or Brand Name.

ECCnet Classification Code                                                                               ECCnet Class         Y                         Unit                 M                                     N         New Code Option:               ID               6/6
                                                                                                         Code                                           Item                                                                 000423 -
Definition: The ECCnet Merchandising Classification Code is a six-digit code which                                                                     Inner                                                                 Homeopathic
                                                                                                                                                       Case                                                                  Medicine
identifies the type of merchandise. The Classification Code is a solution under the
                                                                                                                                                       Pallet
Global UCC/EAN Classification system. The Code is intended to address
Retailer/Distributor needs to route new listings to the correct Buying/Category
Management team.
Electronic Article Surveillance                                                     EAS tag                                   Y                        Item                  O                                     N                                        ID               3/3

Definition: Indicates that the item packaging contains an Electronic Article
Surveillance (EAS) Tag.
Expected Product Life                                                                                    Expected Product Y                            Item                  O                                     N         Available in the               N               1/20
                                                                                                         Life                                                                                                                Product Life section
Definition: The maximum shelf life in days at the point of manufacture                                                                                                                                                       of ProSYNC.




                                                                                                                                     6                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Extended Description (English & French)                                             Extended           Y                                                Unit                 M                                     N                                       AN               1/80
                                                                                    Description                                                         Item
Definition: Proposed – A structured and non-abbreviated description of the product. english                                                            Inner
                                                                                    Extended                                                           Case
                                                                                    Description french                                                 Pallet
Business Rule: Mixed case may be used. Accented characters are NOT to be used.
While this field is up to 80 characters, most retailer legacy systems are not capable
of long descriptions. Vendors should not design their descriptions to build to the
largest value. Retailer systems in general cannot accommodate extended
descriptions of 80 characters. If vendors can provide a good description of the item
within 40 characters that may address a larger percentage of their retailers.


Federal Reportable Indicator                                                                             Null                 N                        Item                  D           Dependant on              N                                   Boolean               1/2
                                                                                                                                                                                           Narcotic or
Definition: Indicates whether the federal government requires the record of sales of                                                                                                      Targetted or
                                                                                                                                                                                         Controlled Drug
the GTIN by the manufacturer.
Yes
No

Yes - GTIN is federally reportable or No - GTIN is not federally reportable.
First Ship Date                                                                                          First Ship Date      Y                         Item                 O                                     N                                       DT                8/8
                                                                                                                                                       Inner
Definition – First available ship date. Implies nothing about current availability                                                                     Case
                                                                                                                                                       Pallet
First Order Date                                                                                         First Order Date     Y                         Item                 O                                     N                                       DT                8/8
                                                                                                                                                       Inner
Definition – The date the item is available for ordering. If not specified the item is                                                                 Case
                                                                                                                                                       Pallet
immediately available for ordering.
Flavour Description                                                                                      Null                 N                        Unit                  M                                     N                                       AN               1/80
                                                                                                                                                       Item
Definition: Free text field used to identify the variant of the product. Variants are the
distinguishing characteristics that differentiate products with the same brand and
size including such things as the particular flavor, fragrance, taste. Field is required
in English and French.

Note: This attribute must be consistent with the approved manufacturers submission
to Health Canada Example: peppermint, strawberry.

Business Rule: Flavor is used for identification when dispensing product (Patient
safety)



                                                                                                                                     7                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Generic Name                                                                                             Generic Name         Y                        Item                  O                                     N                                       AN               1/80

The chemical or generic name of the drug. This could be the top medicinal
ingredients as identified on the package.
Global Product Classification Code                                                                       GPC                  N                         Unit                 O                                     N                                        N                8/8
                                                                                                                                                        Item
Definition: The Global Product Classification (GPC) is part of the GS1 System and a                                                                    Inner
                                                                                                                                                       Case
key enabler for the Global Data Synchronization Network (GDSN) and category
                                                                                                                                                       Pallet
management.

Gift with Purchase (Purchase Type=GW)                                                                    Purchase Type        Y                        Item                  O                                     N         ProSYNC currently             AN                1/2
                                                                                                                                                                                                                             has a drop-down for
Definition : An item given to a consumer, as part of a promotional event contingent                                                                                                                                          field Purchase Type.
                                                                                                                                                                                                                             Options are: Gift
on the consumer making a purchase of another item or items. A Gift With Purchase
                                                                                                                                                                                                                             with Purchase or
is considered inventory and has no retail value.
                                                                                                                                                                                                                             Purchase with
                                                                                                                                                                                                                             Purchase.


Gross Weight / Unit of Measure                                                                           Gross Weight         Y                        Inner                 M                                     N                                        R                1/8
                                                                                                                                                       Case
Definition: The weight of the item. The gross weight includes all packaging                                                                            Pallet                                                                                               ID               2/2
materials of the product.

Business Rule: Specify in Metric with up to 2 decimal places. (See Appendix 1,
Volume 4 for a list of Unit of Measure Codes). If specified the value must be greater
than zero. ECCnet maintains this field with up to 5 integer positions and 3 decimal
positions.
GST Applicable by Province                                                            Point of Sales                          Y                        Item                  O                                     N                                       AN                5/5
                                                                                                         Taxes
Definition: Taxes applicable to the product at point-of-sale to the consumer.                            GST
A two part code:
Part I GST=Federal Good & Services Tax
Part II The two-character province or territory code
GTIN (Global Trade Item Number)                                                                          GTIN Code            Y                         Unit                 M                                     N                                       AN              12/14
                                                                                                                                                        Item
Definition: Identifies the UPC/SCC14 or EAN number of the product.                                                                                     Inner
                                                                                                                                                       Case
Business Rule: The GTIN must include the check-digit and must have the correct
                                                                                                                                                       Pallet
length for the specified type of GTIN.




                                                                                                                                     8                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                  Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                 Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency           Allowed       Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Hazard Rating System                                                                                     WHMIS Code           Y                        Item                  O                                     N                                       AN               1/12

Definition: The WHMIS Classification Code
A=Class A – Compressed Gas
B=Class B – Flammable and Combustible
C=Class C – Oxidizing Material
D1=Class D1 – Poisonous and Infectious Material. Material causing immediate and
serious toxic effects
D2=Class D2 – Poisonous and Infectious Material. Material causing other toxic
effects
D3=Class D3 – Poisonous and Infectious Material. Bio-Hazardous Infectious
Material
E=Class E – Corrosive Material
F=Class F – Dangerously Reactive Material

Hazardous Material                                                                                       WHMIS text           Y                        Item                  O                                     N                                       AN               1/80

Definition: A free-form description of the hazardous material.

Business Rule: Use as “WHMIS Free Text” to describe situations not covered by
the WHMIS Classification Codes.
Hazardous Material & Transportation Handling                                                             Special Handling     Y                        Case                  O                                     N                                        ID               2/3
                                                                                                         & Hazardous
Definition: To specify special transportation handling instructions. Only one is                         Transportation
allowed, supply most relevant.
DA = Dangerous Goods
DNF= Do Not Freeze
EL = Environmental Control Limits
FL = Flammable
FR = Fragile Handle with Care
HM= Endorsed as Hazardous Materials
IC = Ice
MRF=Refrigerated
OTC=Temperature Control
PG = Poisonous Gas




                                                                                                                                     9                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Height / Unit of Measure                                                                                 Height               Y                 Item                M                                       N                Height at the each             R                1/8
                                                                                                         Height UOM                             Inner                                                                        level is mandatory in
Definition: From the base to the top after default front has been established.                                                                  Case                                                                         ECCnet based upon              ID               2/2
                                                                                                                                                Pallet                                                                       the ECCnet Class
Vertical dimension of the object measured when the object is in the upright position.
                                                                                                                                                                                                                             Code.
Business Rule: Specify in Metric with up to 2 decimal places. Centimeter is
suggested unless the value is too small or too large. (See Appendix 1, Volume 4 for
a list of Unit of Measure codes.) If specified the value must be greater than zero.

ECCnet maintains this field with up to 5 integer positions and 3 decimal positions.



HST Applicable by Province                                                                               Point of Sales       Y                 Item                O                                       N                New Brunswick                 AN                5/5
                                                                                                         Taxes                                                                                                               Newfoundland
Definition: Taxes applicable to the product at point-of-sale to the consumer.                            HST                                                                                                                 Nova Scotia
A two part code.
Part I HST=Harmonized Sales Tax
Part II The two-character province or territory code.
Image Last Update Date                                                                                   Null                 N                 Unit                D                   Dependent on    N                                                  DT              10/10
                                                                                                                                                                                        the presence of
Specifies the date the GTIN image was last changed.                                                                                                                                     Image Link
Example: mm/dd/yyyy (10/20/2005)

Business Rule: Image change date is used for identification and patient safety when
dispensing product.
Image Link                                                                                               Null                 N                 Unit                O                                       N                                              AN              1/400

Provides a link or reference to an image of the product and indicates that an image
is available.
Example: telephone numbers, internet URLs.

Business Rule: Images are essential for identification when dispensing product to
assist in patient safety and security.




                                                                                                                                    10                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Invoice Issuer                                                                                           Invoicing            Y                 Case                O                                                        In ECCnet                     AN               1/35
                                                                                                                                                                                                                             ProSYNC, it is
Definition: Name of the entity issuing the invoice. The Invoice Issuer is only                                                                                                                                               located in the
                                                                                                                                                                                                                             Manufacturer
required when Brokers are populating one catalogue with products from several
                                                                                                                                                                                                                             Information section
manufacturers and need to identify a different invoicing relationship for that product.
                                                                                                                                                                                                                             as a drop-down with
                                                                                                                                                                                                                             options:
                                                                                                                                                                                                                             Manufacturer will
                                                                                                                                                                                                                             NOT invoice
                                                                                                                                                                                                                             Manufacturer will
                                                                                                                                                                                                                             invoice


Is Dispensing Unit Divisible                                                                             Null                 N                 Unit                O                                       N                                          Boolean               1/2

Definition: Indicates whether a dispensing unit may be divided or separated into two
or more portions as per prescribed direction.
Y
N

Business Rule: Patient safety and patient compliance when dispensing product. A
pill or tablet (dispensing unit) may be divisible into two or more portions as directed.

Label Storage Condition                                                                                  Null                 N                 Item                D                   Dependent on    N                    Specific instructions         AN              1/400
                                                                                                                                                                                        presence of DIN                      to the Consumer for
Definition: Describes the storage and handling conditions as reflected on the label                                                                                                     or NPN                               storage. Free-form
                                                                                                                                                                                                                             text field.
of the trade item. Field is required in English and French.

Business Rule: There are products that need to be handled correctly to ensure
product integrity and efficacy.

Layers per Pallet (Tier)                                                                                 Tier (# of layers)   Y                 Case                         O                                     N                                        N                1/3
                                                                                                                                                Pallet
Definition: The number of layer per pallet.
Length / Unit of Measure                                                                                 Length / Unit of     Y                 Item                M                                       N                Length at the each             R                1/8
                                                                                                         Measure                                Inner                                                                        level is mandatory
Definition: After the default front is determined, from the front to the back.                                                                  Case                                                                         based upon the                 ID               2/2
                                                                                                                                                Pallet                                                                       ECCnet Class
Business Rule: Specify in Metric with up to 2 decimal places. Centimeter is
                                                                                                                                                                                                                             Code.
suggested unless the value is too small or too large. If specified the value must be
greater than zero.

ECCnet maintains this field with up to 5 integer positions and 3 decimal positions.



                                                                                                                                    11                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Manufacturer/Supplier Address 1, Address 2, City, Province, and Country            Manufacturer                               Y                 Case                O                                       N                In ProSYNC, part of           AN               1/35
                                                                                   Address 1,                                                                                                                                Manufacturer                  AN               1/35
Definition: Street Address, City, State/Province, Country of Manufacture/Supplier. Address 2, City,                                                                                                                          Information section.          AN               2/20
Only required when Brokers or non-exclusive distributors are populating one vendor Province, and                                                                                                                                                           ID                2/2
                                                                                   Country                                                                                                                                                                 AN                2/2
catalogue with products from several manufacturers.


Manufacturer/Supplier ID Type and Number                                                                 Company              Y                 Case                O                                       N                In ProSYNC, part of           ID               2/13
                                                                                                         GLN/Duns+4                                                                                                          Manufacturer                  AN               1/13
Definition: A coded identification of the Manufacturer/Supplier.                                                                                                                                                             Information section.
Type Codes 9 = D-U-N-S+4 (Dun & Bradstreet plus 4-character suffix)
UL = Global Location Number (GLN)
Manufacturer/Supplier Name                                                                               Manufacturer         Y                 Case                O                                       N                In ProSYNC, part of           AN               1/35
                                                                                                         Name                                                                                                                Manufacturer
Definition: Name of the Manufacturer or Supplier of the item. The                                                                                                                                                            Information section.
Manufacturer/Supplier Name is only required when Brokers are populating one
Vendor catalogue with products from several manufacturers.
Markings (Front)                                                                                         Null                 N                 Unit                M                                       N                                              AN               1/30
                                                                                                                                                Item
Definition: Describes the distinctive markings on the front of a tablet or capsule to
identify and distinguish the product. The front is the primary facing side of the
product as determined by the manufacturer. If only one side is marked, then the
Markings (Front) attribute should be used.This includes scoring or indentations or
logos or imprints or strength etc. or a combination of these. Field is required in
English and French.

Example: Brand, strength, logo, design, shield, none

Business Rule: Markings are used for identification when dispensing product
(Patient safety)Note: This attribute must be consistent with the approved
manufacturers submission to Health Canada.




                                                                                                                                    12                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Markings (Back)                                                                                          Null                 N                 Unit                D                   Dependant on     N                                                 AN               1/30
                                                                                                                                                Item                                    presence of
Definition: Describes the distinctive imprints on the back of a tablet or capsule to                                                                                                    Markings (Front)
identify and distinguish the product. The markings Back will only be used if the front
is also described. (Note manufacturers determine the front of their product.)This
includes scoring or indentations or logos or imprints or strength etc. or a
combination of these. Field is required in English and French.

Example: Identifies any special product marking (i.e. 50 cent off coupon, none, etc)

Business Rule: Markings are used for identification when dispensing product
(Patient safety).Note: This attribute must be consistent with the approved
manufacturers submission to Health Canada.

Markings (Alternate)                                                                                     Null                 N                 Unit                O                                       N                                              AN               1/30
                                                                                                                                                Item
Definition: Describes the distinctive imprints that are on a side or portion of the
product that is alternate to the front or back of a tablet or capsule and are used to
identify and distinguish the product. (Note manufacturers determine the front of their
product.) This includes scoring or indentations or logos or imprints or strength etc.
or a combination of these. Field is required in English and French.

Business Rule: Markings are used for identification when dispensing product
(Patient safety)Note: This attribute must be consistent with the approved
manufacturers submission to Health Canada


Marked Expiry Date                                                                                       Marked with          Y                 Item                O                                       N                Product Markings              AN                1/7
                                                                                                         Expiry Date                                                                                                         section of ProSYNC
Definition: Identifies that the product is marked with an expiry date.
Marked Lot Number                                                                                        Marked with Lot      Y                 Item                O                                       N                Product Markings              AN                1/7
                                                                                                         Number                                                                                                              section of ProSYNC
Definition: Identifies that the product is marked with a Lot Number.
Maximum Order Quantity                                                                                   Maximum Order        Y                 Case                O                                       N                                               R               1/15
                                                                                                         Quantity
Definition: Maximum quantity of order allowed for the item.
Business Rule: If specified must be greater than zero.




                                                                                                                                    13                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Medical Device Class                                                                                     Null                 N                 Unit                O                                       N                Drop-down                      ID               4/4
                                                                                                                                                Item                                                                         Descriptions:
Definition: Specifies the Medical Device Class (I,II,III or IV) and is associated with a                                                                                                                                     Class I (Lowest
                                                                                                                                                                                                                             Risk)
specific Medical Device License Number (also known as the MDL). Regulated by
                                                                                                                                                                                                                             Class II (Low Risk)
the Therapeutic Products Directorate of Health Canada. As defined by Health
                                                                                                                                                                                                                             Class III (Moderate
Canada .From Health Canada:Class / Risk /                                                                                                                                                                                    Risk)
                                                                                                                                                                                                                             Class IV (High Risk)
Examples:
Class I - Lowest risk i.e Surgical Instruments, culture media                                                                                                                                                                Codes:
Class II - Low risk i.e. Contact lenses, epidural catheters, pregnancy test kits,                                                                                                                                            MDC1
surgical gloves, ultrasound scanner                                                                                                                                                                                          MDC2
Class III - Moderate Risk i.e Orthopedics implants, glucose monitors, dental                                                                                                                                                 MDC3
implants, haemodialysis systems.                                                                                                                                                                                             MDC4
Class IV - High Risk i.e HIV test kits, pacemakers, angiographic catheters.

Business Rule: The Medical Device Class is used to identify the product (i.e. patient
safety). Class is connected to a license number and it is required if an MDL number
is supplied. Regulatory follow ups and approvals to re license. MFG – license and
approve. Rtl – needs a license to sell products.

Medical Device License Number                                                                            Null                 N                 Unit                D                   Dependant on       N                                               AN                1/6
                                                                                                                                                Item                                    presence of the
Definition: The Medical Device License Number identifies the license number of the                                                                                                      medical device
                                                                                                                                                                                        class II,III or IV
medical device that the trade item represents or contains and is assigned according
to Health Canada’s regulations. The Trade Item is associated with a Medical Device
Class and is assigned a Medical Device License Number when Class II, III or IV are
applicable.

Example: 12345

Business Rule: The MDL is used to identify the product (i.e. patient safety).MD
Class is connected to a license number and it is required if an MDL number is
supplied for MD Class II, III, or IV.


Minimum Order Quantity                                                                                   Minimum Order        Y                 Case                O                                       N                                               R               1/15
                                                                                                         Quantity
Definition: Manufacturer imposed minimum order for the item.
Business Rule: If specified must be an integer value greater than zero. Please
refer to the Trade Item Identification and Communication Guidelines for more
details.



                                                                                                                                    14                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Model Number                                                                                             Vendor Model         Y                 Item                O                                       N                                              AN               1/20
                                                                                                         Number
Definition: Vendor assigned number (the same for all retailers)
Must Sell By                                                                                             Must Sell By         Y                 Item                O                                       N                                               N                1/4

Definition: Used to designate the number of days open dated product must 'sell by'
from date of manufacture. If specified must be greater than zero. The number of
days an item can remain on the shelf and must then be removed.

i.e. Fresh and Dairy items.

Business Rule: Most items can be adequately defined through the use of "Expected
Product Life" – Must Sell By Days should only be used when for particular
commodities it has added value and is provided in addition to Expected Product Life

Narcotic                                                                                                 Null                 N                 Item                M                                       N                Codes:                         ID               1/4
                                                                                                                                                                                                                             NAR1 = Narcotic
Indicate if the product is a Narcotic from Schedule 1 or 2 of the CDSA (Controlled                                                                                                                                           ONLY
                                                                                                                                                                                                                             NAR2 = Narcotic
Drugs & Substances Act).
                                                                                                                                                                                                                             Preparation
                                                                                                                                                                                                                             NAR3 = Exempted
Options are:                                                                                                                                                                                                                 Codeine
Narcotic - Narcotic ONLY                                                                                                                                                                                                     NAR4 = Not
Narcotic - Narcotic Preparation                                                                                                                                                                                              Applicable
Narcotic - Exempted Codeine
Not Applicable                                                                                                                                                                                                               ECCnet currently
                                                                                                                                                                                                                             has the following:
Business Rule: Narcotic, Precursor, Controlled and Targeted fields are needed for                                                                                                                                            - Controlled
the proper handling and storing of these products (e.g. lock-up, storage, disposal,                                                                                                                                          Substance - Class 3
                                                                                                                                                                                                                             (Narcotic)
reporting) and also for identification of the products (i.e. patient safety).
                                                                                                                                                                                                                             - Controlled
                                                                                                                                                                                                                             Substance - Class
                                                                                                                                                                                                                             3N (Non-narcotic)




                                                                                                                                    15                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Natural Health Product Number (NPN)                                                                      Null                 N                 Unit                O                                               Y        An NPN will not               AN                8/8
                                                                                                                                                Item                                                            Item level   have an AIG
Definition: The Natural Health Product Number (NPN) identifies the trade item as a                                                                                                                                 only.     assigned to it.
natural health product and the number is assigned by a regulatory health
organization.

As defined by Health Canada – Interim Solution Natural Health Product Number In
Canada, the NPN is an eight digit (8) numerical code and is assigned by the Natural
Health Products Directorate (Health Canada). If the number is a temporary
application number (6 digits), prefix the number with an “AP”. Sunset – temporary
AP number will not be used after the sunset date, as determined by Health Canada.

Example: Certain Products, within a category may have a DIN while others may
have an NPN, depending on the ingredients. Also, the products that should have an
NPN may remain with a DIN until the formula changes or the transition time ends.

Business Rule: Products that are designated as natural health products and have an
NPN will not have an AIG number assigned to it. For these products, suppliers
must provide the active ingredients name, strength and UOM.


Net Weight / UOM                                                                                         Null                 Y                 Unit                O                                       N                                               R                1/8
                                                                                                                                                Inner
Definition: Net weight includes the contents of the product, but excludes any                                                                   Case
                                                                                                                                                Pallet
packaging materials.

Example: 10.25 grams – The weight of a pill or a capsule.

Business Rules: Required for inventory management and reporting (e.g. recalls).
London Drugs: Weight is used for supplementary identification when dispensing
product (Patient safety and dispensing accuracy). At the unit level, when a pill
comes in a blister pack, the unit new weight is the net weight of the pill, excluding
the blister pack.
Not Legal to Advertise                                                                                   Not Legal to         Y                 Item                O                                       N                Cannot send more              AN                4/4
                                                                                                         Advertise                                                                                                           than 1 value for
Definition: Indicates whether the item is not legal to advertise by province.                                                                                                                                                each province.


E.g. some products such as tobacco, beer, over-the-counter drugs cannot be legally
advertised according to provincial regulations.




                                                                                                                                    16                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Not Legal to Discount                                                                                    Not Legal to         Y                 Item                O                                       N                Cannot send more              AN                4/4
                                                                                                         Discount                                                                                                            than 1 value for
Definition: Indicates whether the item is not legal to discount by province (i.e. the                                                                                                                                        each province.
item is subject to government regulation regarding either price floors or pricing
practices).

E.g. Some products such as tobacco, beer, over-the-counter drugs cannot be legally
discounted according to provincial regulations. Milk in Quebec cannot be sold
below a floor price.
Total Units / Retail Pack                                                          Quantity                                   Y                 Item                M                                       N                Referred to as                 N                1/6
                                                                                                                                                Inner                                                                        'Retail Pack' at
Field is referred to as Retail Pack at the product type level of consumer item.                                                                 Case                                                                         consumer item
                                                                                                                                                Pallet                                                                       product type level,
Field is referred to as Total Units at every other product type level greater than a
                                                                                                                                                                                                                             or 'Total Units' at
consumer item.
                                                                                                                                                                                                                             higher levels.
(Also referred to as Number of Inner Packs.)

Definition: The number of inner containers, or number of eaches if there are no
inner containers, for the current level of packaging.
At the case or inner level this is the number of inner containers:
Inner – 4 blister packs of ampules - # of Inner Packs = 4, Size 150 ml
Case – 4 x 3 x 150 ml - # of Inner Packs = 4, # of Units in Inner Pack = 12
At the item level where there are no lower level of marked items this is the number
of consumable units if the Size/UOM field is not sufficient.
An item that is only itself (i.e. one Each) can be specified as 1 or the field can be left
empty.
Consumer Unit – ampule-# of Inner Packs = 1, Size 50 ml

Business Rule: At the Consumer Unit level this field typically drives the Retailer’s
shelf label comparison for consumers. Some Retailers refer to this field as the
“Retail Pack”.
Order Quantity Multiple                                                                                  Order Quantity       Y                          Item       O                                       N                                               R               1/15
                                                                                                         Multiple
Definition: Product must be ordered in multiples of this quantity.
Business Rule: If specified must be an integer value greater than zero.
Packaging Form                                                                                           Packaging Form       Y                          Item       O                                       N                                               ID               3/3

Definition: A code identifying the form of the packaging material.
See Appendix C.

Example: BOT – Bottle



                                                                                                                                    17                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Packaging Material                                                                                       Packaging            Y                        Item         O                                       N                                               ID               3/3
                                                                                                         Material
Definition: A code identifying the type of packaging material.
See Appendix D for a list of codes.

Example: 43 = Glass
Precursor Status                                                                                         Null                 N                        Item         D                   Dependant on    N                    Codes are:                     ID               2/2
                                                                                                                                                                                        presence of DIN                      PA = GTIN Contains
Definition: Indicates whether the trade item contains a Precursor substance                                                                                                                                                  Class A Precursor
                                                                                                                                                                                                                             Substance
(according to Health Canada) and it’s classification. Precursor substances are listed
                                                                                                                                                                                                                             PB = GTIN Contains
in Schedule VI of the Controlled Drugs and Substances Act (Canada)
                                                                                                                                                                                                                             Class B Precursor
                                                                                                                                                                                                                             Substance
Example: Asudafed Advance has a precursor substance therefore a precursor                                                                                                                                                    PN = GTIN DOES
Substance=true.                                                                                                                                                                                                              NOT Contain a
                                                                                                                                                                                                                             Precursor
Options are:                                                                                                                                                                                                                 Substance
Class A Precursor Substance
Class B Precursor Substance
Not Applicable

Business Rule: Precursor, Controlled and Targeted fields are needed for the proper
handling and storing of these products (e.g. lock-up, storage, disposal, reporting)
and also for identification of the products (i.e. patient safety)

Product Form Aerosol                                                                                     Product Form         Y                        item         O                                       N                Code is:                      AN                3/3
                                                                                                         Aerosol                                                                                                             PFK
Indicates that the product is aerosol. The product container holds a compressed                          or
                                                                                                         Physical Form
gas that is used to force the product out of the container i.e. hairspray or whipped
                                                                                                         (Aerosol)
cream.
Product Reordering                                                                                       Reorderable          Y                        Case         O                                       N                Codes:                        AN                2/2
                                                                                                                                                                                                                             RN = cannot be
Definition: Identifies whether an item can be reordered. Typically used with apparel,                                                                                                                                        reordered
seasonable or other limited time project. Normally specified on the Vendor Selling
                                                                                                                                                                                                                             RY = can be
Unit.
                                                                                                                                                                                                                             reordered
RN = Product cannot be reordered. Does not imply any information on current
availability.
RY = Product can be reordered. Does not imply any information on current
availability.
As the default business practice is that items can be reordered, it is not necessary
to transmit this value.




                                                                                                                                    18                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Product Type Code                                                                                        Product Type         Partially*                Unit        M                                       N                Application Unit               ID               2/2
                                                                                                         Code                                           Item                                                                 (UD) was not
Definition: Identifies the product type within the packaging levels.                                                                                   Inner                                                                 available within the
                                                                                                                                                       Case                                                                  RX1 subset.
EA=Each – lowest consumer selling unit
                                                                                                                                                       Pallet
PK=Package – consumer unit that is less than a shipping case (i.e. inner pack)
AP=Setpack –
CA=Case – shipping unit that is smaller than a pallet.
DS=Display – pre-assembled unit that does not contain cases, but one or more
consumer selling units. Not a full pallet.
PL=Pallet – shipping unit that contains one item that is constructed to TI/HI
specifications.
MX=Modular (Mixed) Pallet – special pre-built pallet with one or more GTINS that is
ready for display.
UD=Application Unit – for Pharmaceuticals – the dispensing unit. (Unit Dose)

PST Applicable by Province                                                                               Point of Sale        Y                        Item         O                                       N                                              AN                5/5
                                                                                                         Taxes
Definition: Taxes applicable to the product at point-of-sale to the consumer.                            PST
A two part code.
Part I PST=Provincial Sales Tax
Part II The two-character province or territory code.
Purchase with Purchase (Purchase Type=PW)                                                                Purchase Type        Y                        Item         O                                       N                ProSYNC currently             AN                1/2
                                                                                                                                                                                                                             has a drop-down for
Definition: – An item sold to the consumer at a special price, as part of a                                                                                                                                                  field Purchase Type.
                                                                                                                                                                                                                             Options are: Gift
promotional event, contingent on the consumer purchasing another item or items. A
                                                                                                                                                                                                                             with Purchase or
Purchase With Purchase item is considered inventory and has a retail value.
                                                                                                                                                                                                                             Purchase with
                                                                                                                                                                                                                             Purchase.


Reinstatement Date                                                                                       Reinstatement        Y                         All         O                                       N                mm/dd/yyyy                    DT                8/8
                                                                                                         Date
The date when a previously discontinued item is reinstated and again available for
ordering. Only one of either reinstatement date or discontinue date should be
indicated at one time.
Route of Administration                                                                                  Route of             Partially*               Item         D                   Dependant on    N                    There are new                  ID               2/2
                                                                                                         Administration                                                                 presence of DIN                      codes available for
Definition: Indicates the method of administering the pharmaceutical item.                                                                                                                                                   Route of
                                                                                                                                                                                                                             Administration in
                                                                                                                                                                                                                             RX2. See Appendix
                                                                                                                                                                                                                             B in this document.




                                                                                                                                    19                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Seasonable Product Currently Available                                                                   Seasonal Product Y                            Case         O                                       N                In ProSYNC, only              AN                2/2
                                                                                                                                                                                                                             available when
Definition: Identifies whether a seasonable product is currently available. Typically                                                                                                                                        vendor chooses
                                                                                                                                                                                                                             ECCnet Class Code
used with apparel or other seasonal products. Normally specified on the Vendor
                                                                                                                                                                                                                             of Seasonal.
Selling Unit.
SN = Seasonal product currently not available.
SY= Seasonal product currently available.
Selection Code                                                                                           Selection Code       Y                         Unit        M                                       N                                              AN                3/3
                                                                                                                                                        Item
Definition: The Selection Code is a 3-digit code, generated by Vendors, used to                                                                        Inner
                                                                                                                                                       Case
logically group products at a high level.
                                                                                                                                                       Pallet
This allows vendors to structure their catalogue according to their own internal
requirements. While mandatory, if not supplied defaults to 000 = All Products.
Shakable Product                                                                                         Null                 N                        Item         M                                       N                                          Boolean               1/2

Definition: Indicates weather the trade item may be or maybe not be shaken during
transit, storage, or use.
Example:
Yes - it is shakable
No - it is not shakable

Business Rule: There are products that need to be handled correctly to ensure
product integrity and efficacy.
Colour Description                                                                                       Null                 N                        Unit         M                                       N                                              AN               1/20
                                                                                                                                                       Item
Definition: Free form text description of the color of the trade item. Field is required
in English and French. Note: This attribute must be consistent with the approved
manufacturers submission to Health Canada.

Example: Color is used for identification when dispensing product (Patient safety).
Products like cosmetics (e.g. lipstick) come in different shades.

Business Rule: Color is used for identification when dispensing product (Patient
safety).

Short Product Description – English & French                                                             Short Description Y                            Unit        M                                       N                                              AN               1/30
                                                                                                         english                                        Item
Definition – A non-structured and abbreviated yet readable short description. The                        Short Description                             Inner
                                                                                                         french                                        Case
description should not include Pack, Size or UOM. Mixed case may be used.
                                                                                                                                                       Pallet




                                                                                                                                    20                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Size/ Unit of Measure                                                                                    Size / Unit of   Y                             Item        M                                       N                Size is not always             R                1/8
                                                                                                         Measure or Size                               Inner                                                                 mandatory in
Definition: Size of supplier units in pack.                                                              of Consumer Item                              Case                                                                  ECCnet. It is                  ID               2/2
                                                                                                                                                       Pallet                                                                optional or
Example: If “355 ml” this field would contain “355” and Unit of Measure would
                                                                                                                                                                                                                             mandatory based
contain “ML”.
                                                                                                                                                                                                                             upon ECCnet class
                                                                                                                                                                                                                             code.
Sterile Product Indicator                                                                                Null                 N                        Item         M                                       N                                          Boolean               1/2

Definition: Indicates whether the trade item must maintain its sterile condition to the
point of administration.
Y
N

Business Rule: There are products that need to be handled correctly to ensure
product integrity and efficacy.
Substituted for GTIN                                                                  Substituted for  Y                                                All         O                                       N                                              AN               8/14
                                                                                      GTIN or Replaces
Definition: Used to identify the GTIN of the product that has been substituted for by GTIN
this GTIN.

Example: If a 440g Baked Beans is being replaced by a 400g product, then the
GTIN of the 440g product should be identified in this field when registering the 400g
product to indicate the 400g has replaced the 440g product in the marketplace.

Business Rule: Note to permanently replace a GTIN – add the new GTIN indicating
the “substitution” and then discontinue the old GTIN. See the Trade Item
Identification and Communication Guidelines (formerly the UPC Data
Communications Guidelines for Retail and Apparel) for further rules regarding GTIN
life cycle requirements.




                                                                                                                                    21                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Targeted Substance                                                                                       Null                 N                        Item         M                                       N                ECCnet currently          Boolean               1/2
                                                                                                                                                                                                                             has the following:
Definition: Targeted Substance is a product from Schedule 1 of the Benzodiazepine
                                                                                                                                                                                                                             - Controlled
and Other Targeted Substances regulations of CDSA (Controlled Drug and
                                                                                                                                                                                                                             Substance - Class 4
Substances Act).
                                                                                                                                                                                                                             (Targeted)

Options are:
Yes
No

(Yes, drug product contains Targeted Substance or No, drug product does not
contain Targeted Substance)

Business Rule: Narcotic, Precursor, Controlled and Targeted fields are needed for
the proper handling and storing of these products (e.g. lock-up, storage, disposal,
reporting) and also for identification of the products (i.e. patient safety).

Temperature Control Range                                                                                Null                 N                        Item         M                                       N                Codes:                         ID               5/5
                                                                                                                                                                                                                             TCNSP = Not
Definition: Specifies allowed storage and transportation temperature ranges.                                                                                                                                                 Specified
                                                                                                                                                                                                                             TCFRZ = Frozen
                                                                                                                                                                                                                             TCREF =
Examples:
                                                                                                                                                                                                                             Refrigerated
Not specified                                                                                                                                                                                                                TCCOL = Cool
Frozen - '-25 to -20 C'                                                                                                                                                                                                      TCRMT = Room
Refrigerated - '2 to 8 C'                                                                                                                                                                                                    temperature
Cool - '8 to 15C'                                                                                                                                                                                                            TCCRT= Controlled
Room temperature - '15 - 30C'                                                                                                                                                                                                room temperature
Controlled room temperature - '20 - 25C'                                                                                                                                                                                     TCEXH = Excessive
Excessive Heat - '>40C'                                                                                                                                                                                                      Heat
If "Other", complete "Temperature Control Range - Other".                                                                                                                                                                    TCOTH= Other


Business Rule: There are products that need to be monitored and maintained at
specific temperature ranges to ensure product integrity and efficacy.




                                                                                                                                    22                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Temperature Control Range - Other                                                                        Null                 N                        Item         D                   Dependant on        N                                               N                1/3
                                                                                                                                                                                        Temperature
Definition: Specifies specific allowed handling, storage and transportation                                                                                                             control                                                            CE                2/2
                                                                                                                                                                                        range=other
temperature range when "other" is indicated in the Temperature Control Range
field.
Min in degrees Celsius.
Max in degrees Celsius.

Business Rule: There are products that need to be monitored and maintained at
specific temperature ranges to ensure product integrity and efficacy This field is
used when Temperature Control Range does not satisfy the business requirement.
Use Temperature Control Range Other but not both.
The United Nations Standard Products and Services Code (UNSPSC)                                          Null                 N                         Unit        O                                       N                                               N                8/8
                                                                                                                                                        Item
Definition: The United Nations Standard Products and Services Code provides an                                                                         Inner
                                                                                                                                                       Case
open, global multi-sector standard for efficient, accurate classification of products
                                                                                                                                                       Pallet
and services.
Drug Strength and Unit of Measure (UOM) as per Label                                                     Null                 N                        Item         O                                       N                                              AN               1/80

Definition: The strength and measurement (unit of measure UOM) as described on
the trade item package

Example 1: 30 mg per 100ml
Example 2: 500 mg each
Shape Description                                                                                        Null                 N                        Unit         O                                       N                                              AN               1/35
                                                                                                                                                       Item
Definition: The physical shape of the product. Defines the shape the trade item
takes and is distinct from the form of the packaging. Field is required in English and
French.

Example: round, square, triangle, oval, rectangle

Business Rule: Applicable to solid products only and excludes all packaging (liquids
excluded). This attribute must be consistent with the approved manufacturers
submission to Health Canada.
Trade / Brand Name (English & French)                                                                    Brand Name           Y                         Unit        M                                       N                                              AN               1/66
                                                                                                                                                        Item
Definition: The Vendor’s Trade Name (i.e. “Short” Brand Name).                                                                                         Inner
                                                                                                                                                       Case
Example: Nescafe (“Nescafe Frothy” would be considered a long brand).
                                                                                                                                                       Pallet




                                                                                                                                    23                                                                                                                      5/16/2012
                                                                                                                   ECCnet RX Attributes



LEGEND Partially* - within the column heading "Previously available in RX1" references the attribute exists in RX1, but an element of the field has changed in RX2 (i.e. The Dosage Form & Route of Administration code lists have increased in RX2; The DIN field
can repeat in RX2, but only 1 allowance was available in RX1,etc)




                                                                                                                                Previously         Supply for                                                   Multiple
                                                                                                          Current ECCnet        available in      Product Type                                                  Values
Attribute/Details                                                                                         Attribute Name           RX1               Level           Requested Use        Dependency            Allowed      Comments                   Format             Size

                                                                                                                                                                                                                                                        AN=Alpha
                                                                                                                                                                                                                                                          numeric
                                                                                                                                                                                                                                                      N=Numeric (fixed
                                                                                                                                                                                                                                                         decimals)
                                                                                                                                                  Options are:                                                                                          R=Numeric
                                                                                                                                                   Unit, Item,        O = Optional                                                                       (optional        Sizes are
                                                                                                                                                                                                                                                         decimals)      applicalble to
                                                                                                                                                  Inner, Case,       D = Dependent         List field       Can the field                            ID=Code Identifier   ECCnet
                                                                                                           (Name or Null)           (Y/N)            Pallet          M = Mandatory        dependency          repeat?                                    DT=Date        ProSYNC UI

Volume / Unit of Measure                                                                                 Volume / UOM         Y                        Inner                 M                                     N                                        R                1/8
                                                                                                                                                       Case
Definition: The cube of the item.                                                                                                                      Pallet                                                                                               ID               2/2


Business Rule: Specify in Metric with up to 3 decimal places. Cubic Meters is
suggested unless the value is too small or too large. If specified the value must be
greater than zero.
ECCnet maintains this field with up to 5 integer positions and 3 decimal positions.

Width / Unit of Measure                                                                                  Width / UOM          Y                         Item        M                                       N                Width at the each              R                1/8
                                                                                                                                                       Inner                                                                 level is mandatory in
Definition: After locating default front, it is the measurement from the left to the                                                                   Case                                                                  ECCnet based upon              ID               2/2
                                                                                                                                                       Pallet                                                                the ECCnet
right.
                                                                                                                                                                                                                             Classification Code.

Business Rule: Specify in Metric with up to 2 decimal places. Centimeter is
suggested unless the value is too small or too large. If specified the value must be
greater than zero.

ECCnet maintains this field with up to 5 integer positions and 3 decimal positions.




                                                                                                                                    24                                                                                                                      5/16/2012
ECCnet RX Attributes




         25            5/16/2012
ECCnet RX Attributes




         26            5/16/2012
ECCnet RX Attributes




         27            5/16/2012
ECCnet RX Attributes




         28            5/16/2012
ECCnet RX Attributes




         29            5/16/2012
ECCnet RX Attributes




         30            5/16/2012
ECCnet RX Attributes




         31            5/16/2012
ECCnet RX Attributes




         32            5/16/2012
ECCnet RX Attributes




         33            5/16/2012
ECCnet RX Attributes




         34            5/16/2012
ECCnet RX Attributes




         35            5/16/2012
ECCnet RX Attributes




         36            5/16/2012
ECCnet RX Attributes




         37            5/16/2012
ECCnet RX Attributes




         38            5/16/2012
ECCnet RX Attributes




         39            5/16/2012
ECCnet RX Attributes




         40            5/16/2012
ECCnet RX Attributes




         41            5/16/2012
ECCnet RX Attributes




         42            5/16/2012
ECCnet RX Attributes




         43            5/16/2012
ECCnet RX Attributes




         44            5/16/2012
ECCnet RX Attributes




         45            5/16/2012
ECCnet RX Attributes




         46            5/16/2012
ECCnet RX Attributes




         47            5/16/2012
     Appendix A - Dosage Form Code List

                                                   New
#        Dosage Form Attribute (2007)     Code              Subset
                                                   Code
 1   Aerosol                              AERO               RX1
 2   Aerosol (With Propellants)           AEPP     New       RX2
 3   Aerosol Powder                       AERP               RX1
 4   Aerosol Solution                     AERS               RX1
 5   Bar                                   BAR               RX1
 6   Beads                                BEAD               RX1
 7   Capsule                              CAPU     New       RX2
 8   Capsule Controlled Release           CPCR               RX1
 9   Capsule Conventional                 CAPS               RX1
10   Capsule, Delayed Release             CADR     New       RX2
11   Capsule, Extended Release            CAER     New       RX2
12   Cartridge                            CART     New       RX2
13   Concentrate                          CONC               RX1
14   Cream                                CREA               RX1
15   Crystals                             CRYS               RX1
16   Device (Not Specified)               DEVI               RX1
17   Diagnostic Test (Not Specified)      TEST               RX1
18   Diaphragm                            DPHR               RX1
19   Disk                                 DISK     New       RX2
20   Douche (Not Specified)               DCHE               RX1
21   Douche Solution                      DCHS               RX1
22   Elixir                                ELIX              RX1
23   Emulsion                             EMUL               RX1
24   Enema                                ENEM               RX1
25   Fluid Extract                        EXTR               RX1
26   Foam                                 FOAM               RX1
27   Gas                                   GAS               RX1
28   Gel (Jelly)                           GEL    Changed    RX2
29   Granules                             GRAN               RX1
30   Granules For Suspension              GRSS     New       RX2
31   Gum                                  GUM                RX1
32   Implant                              IMPL               RX1
33   Inhalation (Not Specified)           INHA               RX1
34   Injection (Not Specified)              INJ              RX1
35   Intrauterine Device                   IUD               RX1
36   Jelly                                JELY     New       RX2
37   Kit (Multiple Components)             KIT               RX1
38   Liquid (Not Specified)               LIQD               RX1
39   Liquid Controlled Release            LQCR               RX1
40   Lotion                               LOTN               RX1
41   Lozenge                              LOZG               RX1
42   Miscellaneous (Not Specified)        MISC               RX1
43   Nebulization Solution                NEBU               RX1
44   Ocular System                        OCSY               RX1
45   Oil                                   OIL               RX1
46   Ointment                             OINT               RX1
47   Package                              PAGE     New       RX2
48   Pads                                 PADS               RX1
49   Patch                                     PATC     New      RX2
50   Piece, Chewable                           PCHW     New      RX2
51   Pill                                       PILL    New      RX2
52   Powder Packet                             PACK              RX1
53   Powder, Metered Dose                      PMTD     New      RX2
54   Shampoo                                   SMAN              RX1
55   Solution                                  SOLN              RX1
56   Solution When Reconstituted               SOLR              RX1
57   Spray                                     SPRY     New      RX2
58   Strip                                     STRP              RX1
59   Suppository                               SUPP              RX1
60   Suppository (Sustained-Release)           SUSR              RX1
61   Suspension                                SUSP              RX1
62   Suspension When Reconstituted             SURR    Changed   RX2
63   Syrup                                     SYRP              RX1
64   Tablet                                    TABS              RX1
65   Tablet (Combined Release)                 TCRL     New      RX2
66   Tablet (Extended-Release)                 TAER     New      RX2
67   Tablet (Immediate Release)                 TAIR    New      RX2
68   Tablet (Orally Disintegrating)            TAOD     New      RX2
69   Tablet Chewable                           CHEW              RX1
70   Tablet Controlled Release                 TBCR              RX1
71   Tablet Effervescent                       TBEF              RX1
72   Tablet Enteric Coated                     TBEC              RX1
73   Tablet Film Coated                        TBFC              RX1
74   Tablet For Suspension                     TASS     New      RX2
75   Tablet Sublingual                         SUBL              RX1
     Tablet, Film Coated, Controlled Release
76                                             TBFR              RX1
77   Tampon                                    TAMP              RX1
78   Tape                                      TAPE              RX1
79   Tincture                                  TINC              RX1
80   Transdermal System                        TDSY              RX1
81   Troche                                    TROC              RX1
82   Vaginal Tablet                            VATT     New      RX2
83   Wafer                                     WAFR              RX1
84   Whip                                      WHIP              RX1
     Appendix B - Route of Administration

        Route of Administration
#                                     Code   New Code   Subset
              Attribute (2007)
1    Block/Infiltration                BI      New       RX2
2    Buccal                            BU                RX1
3    Caudal Block                      CB      New       RX2
4    Dental                            DE      New       RX2
5    Disinfectant (barn)               DB      New       RX2
6    Disinfectant (contact lens)       DC      New       RX2
7    Disinfectant (domestic)           DD      New       RX2
8    Disinfectant (food                DF      New       RX2
     premises)
9    Disinfectant                      DS      New       RX2
     (institutional/industrial)
10   Disinfectant (medical             DM      New       RX2
     instruments)
11   Disinfectant (hospital/hc         DH      New       RX2
     facilities)
12   External                          EX                RX1
13   Implant                           IM                RX1
14   In vitro                          VI                RX1
15   Inhalation                        IN                RX1
16   Injection (intramuscular)         IA    Changed     RX2
                                             (was IM)
17   Injection (intravenous)           IT                RX1
18   Injection (not specified)          IJ               RX1
19   Injection (subcutaneous)          SC                RX1
20   Instillation                      I1      New       RX2
21   Intra-amniotic                    I2      New       RX2
22   Intra-arterial                    I3      New       RX2
23   Intra-articular                   I4      New       RX2
24   Intrabrachial                     I5      New       RX2
25   Intrabursal                       I6      New       RX2
26   Intracardiac                      I7      New       RX2
27   Intracavernosal                   I8      New       RX2
28   Intracavity                       I9      New       RX2
29   Intracervical                     I0      New       RX2
30   Intracranial                      IB      New       RX2
31   Intracutaneous                    IC      New       RX2
32   Intradermal                       ID      New       RX2
33   Intraganglional                   IE      New       RX2
34   Intralesional                     IF      New       RX2
35   Intramammary                      IG      New       RX2
36   Intramuscular                     IH      New       RX2
37   Intranasal                         II     New       RX2
38   Intraocular                       IK      New       RX2
39   Intrapericardial                  IL      New       RX2
40   Intraperitoneal                   IO      New       RX2
41   Intrapleural                      IP      New       RX2
42   Intrapulmonary                    IQ      New       RX2
43   Intraspinal                       IS      New       RX2
44   Intrasynovial               IV    New      RX2
45   Intratendinous             IW     New      RX2
46   Intrathecal                 IX    New      RX2
47   Intratracheal               IY    New      RX2
48   Intrauterine                IU             RX1
49   Intravascular               IZ    New      RX2
50   Intravenous                T1     New      RX2
51   Intravesicular             T2     New      RX2
52   Intravitreal               T3     New      RX2
53   Irrigation                  IR             RX1
54   Laboratory Test            LT     New      RX2
55   Miscellaneous              MS     New      RX2
56   Mouth/Throat               MT              RX1
57   Nasal                      NA              RX1
58   Nil                        NL     New      RX2
59   Ophthalmic                 OP              RX1
60   Optic                      OT              RX1
61   Oral                       OR              RX1
62   Other                      XX              RX1
63   Parenteral (unspecified)   PA     New      RX2
64   Percutaneous               PE     New      RX2
65   Rectal                     RE              RX1
66   Retrobulbar                RT     New      RX2
67   Soft Tissue Injection      ST     New      RX2
68   Subarachnoidal             SB     New      RX2
69   Subcutaneous               SG     New      RX2
70   Subgingival                SH     New      RX2
71   Sublingual                 SL              RX1
72   Surgical                   SR     New      RX2
73   Teat-dip                   TP     New      RX2
74   Topical                    TO     New      RX2
75   Transdermal                TD              RX1
76   Udder Wash                 UW     New      RX2
77   Uretheral                  UR              RX1
78   Combination of the Above     -   Removed   RX2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:5/17/2012
language:English
pages:51
fanzhongqing fanzhongqing http://
About