GR Tables (132)
GR - Process Manufacturing Regulatory Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
GR_ADDITIVE_CALCS |
10 | Contains Hazard Class Code and Risk Phrase Code. The Hazard Class Code is optional and will display on a form as Hazard to Assign. The Risk |
GR_ADD_MANDATORY_RISKS |
7 | Contains European Hazard Classifications. Works in conjunction with the Additive table. |
GR_AUDIT |
8 | History of changes to any record. |
GR_CALCULATED |
10 | Contains the calculated values for attributes, such as heavy elements, lists, and physical properties. |
GR_CALCULATION_NAMES |
7 | Contains the Calculation Names that control the calculation routines for Risk Phrases. |
GR_CONC_RANGES |
9 | One record for each organization code |
GR_COUNTRY_PROFILES |
11 | Contains Country Codes and Descriptions that can be linked to a customer so that documents display or print in the appropriate country's for |
GR_COVER_LETTERS_B |
7 | The base table for the cover letter for the recipient and the default cover letter for the Organization table. |
GR_COVER_LETTERS_TL |
10 | The translation table for the cover letter for the recipient and the default cover letter for the Organization table. |
GR_DISCLOSURES |
12 | Contains Disclosure information and Minimum, Text, Label, Exposure, and Toxicity Reporting Levels for an ingredient. |
GR_DISPATCH_HISTORIES |
43 | Contains transaction information, such as who received what and when. |
GR_DISPATCH_HISTORY |
47 | Contains transaction information, such as who received what and when. |
GR_DOCUMENT_CODES |
80 | Contains the date format and determines whether detailed ingredient, toxic, and exposure information displays or prints on the document. Al |
GR_DOCUMENT_CODES_TL |
9 | Contains the Document Code Description in Multiple Languages |
GR_DOCUMENT_DETAILS |
11 | Contains each phrase as it will display or print on the document. |
GR_DOCUMENT_HEADINGS |
11 | Contains the headings and subheadings linked to a document. |
GR_DOCUMENT_PRINT |
45 | Contains print information for the document by Item Code, Document Code, and Date. |
GR_DOCUMENT_RTK |
9 | Contains the Right-to-Know (RTK) detail information that will display or print on the document. |
GR_DOCUMENT_STRUCTURES |
45 | Contains the detailed breakdown of how the document will display or print. A row of date format and detailed ingredient, toxic, and exposu |
GR_DOC_HDR_FTR |
10 | Contains a row for each Header or Footer row that will be printed in the document. |
GR_EIN_ASL_CONCS |
12 | Contains one record of concentration information for each EINECS Number (European Inventory of Existing Chemical Substances number). |
GR_EIN_ASL_RISKS |
7 | Contains the EINECS Number (European Inventory of Existing Chemical Substances number) phrases associated with the ASL (Approved Supply List |
GR_EIN_HAZARDS |
7 | Contains a row for each european index number hazard classification |
GR_EIN_NUMBERS_B |
9 | Contains a row for each european index number |
GR_EIN_NUMBERS_TL |
9 | Contains a row for each european index number language description |
GR_EIN_RISKS |
7 | Contains a row for each european index number risk phrase code |
GR_EIN_SAFETY |
7 | Contains a row for each european index number safety phrase code |
GR_EMEA |
42 | Contains Europe and Middle East-specific regulatory information about the item. |
GR_EUROHAZARDS_B |
9 | Contains European Hazard Classification description information. |
GR_EUROHAZARDS_TL |
10 | This entity stores the hazard description information in multiple languages |
GR_EURO_CLASSN_RISKS |
8 | Contains the risks assigned to the classifications |
GR_EURO_DEFAULT_CONCS |
14 | Contains European Default Hazard Classification information. |
GR_EURO_MANDATORY_RISKS |
7 | Contains the Risk Phrase codes that must be assigned for a hazard when classifying that hazard according to the European directives. |
GR_EXPOSURE_AUTHS_B |
6 | Contains the Exposure Authority Code. |
GR_EXPOSURE_AUTHS_TL |
9 | Contains the Exposure Authority Description in multiple languages. |
GR_EXPOSURE_TYPES_B |
6 | Contains the Exposure Type Code. |
GR_EXPOSURE_TYPES_TL |
9 | Contains the Exposure Type Description in multiple languages. |
GR_GENERIC_ITEMS_B |
40 | Stores the generic MSDS that has been assigned for an item. |
GR_GENERIC_ML_NAME_TL |
42 | Contains the Generic Names for the item, by language. |
GR_HAZARD_GROUPS |
7 | Contains the Hazard Group Code and Description. |
GR_INGREDIENT_CONCENTRATIONS |
9 | Table of Ingredient ConcentraionRegulatory Item details, includes the items details for Regulatory Items with regard to the Convergence mode |
GR_INGREDIENT_CONC_DETAILS |
8 | View of Regulatory Item details, includes the items details for Regulatory Items with regard to the Convergence model |
GR_INV_ITEM_PROPERTIES |
13 | Table of Regulatory Item properties details, includes the items details for Regulatory Items with regard to the Convergence model |
GR_INV_ITEM_RISK_PHRASES |
8 | able used to store the risk phrases that are associated to an organization specific Regulatory Item. This for European support. |
GR_INV_ITEM_SAFETY_PHRASES |
8 | Table used to store the safety phrases that are associated to an organization specific Regulatory Item. This for European support. |
GR_ITEMS_REQUESTED |
4 | Regulatory Items Requests log table, which is updated on every GRIRI inbound requests. |
GR_ITEM_CLASSNS |
7 | Contains the Classification Code for the item. |
GR_ITEM_CONCENTRATIONS |
10 | A temporary table used during the document build process. |
GR_ITEM_CONC_DETAILS |
7 | A temporary table used during the document build process. |
GR_ITEM_DISCLOSURES |
13 | Contains Disclosure information for the item. |
GR_ITEM_DOCUMENT_DTLS |
14 | Contains the phrase definition for the item on the document. |
GR_ITEM_DOC_STATUSES |
13 | Contains the last change date and Item Document Status. |
GR_ITEM_EXPLOSION_PROPERTIES |
10 | Table of Regulatory Item Explosion details, includes the items details for Regulatory Items with regard to the Convergence model |
GR_ITEM_EXPOSURE |
44 | Contains the exposure limit information for the item listed by country and authority. The exposure limit information shown on a document is |
GR_ITEM_FIELD_NAME_MASKS_B |
8 | GR field name masks for regulatory items |
GR_ITEM_FIELD_NAME_MASKS_TL |
11 | GR translated field name masks for regulatory items |
GR_ITEM_GENERAL |
50 | Stores regulatory information that further identifies the item. It also stores flags that govern what data displays on the MSDS. |
GR_ITEM_GENERAL_MIG |
4 | View of Regulatory Item Explosion details, includes the items details for Regulatory Items with regard to the Convergence model |
GR_ITEM_GROUPS_B |
8 | Contains the item Group Code and Description and Consolidated Toxicity and Exposure Data. |
GR_ITEM_GROUPS_TL |
9 | Contains the Item Group Description in multiple languages. |
GR_ITEM_PROPERTIES |
14 | Contains the characteristics of the item such as physical properties, transport, and country-specific information. |
GR_ITEM_RIGHT_TO_KNOW |
19 | Contains product composition information pertinent to each state's reporting level. |
GR_ITEM_RISK_PHRASES |
10 | Contains the Standard European Risk Phrase for the item. Multiple rows of Risk Phrase information can exist for each item. |
GR_ITEM_SAFETY_PHRASES |
10 | Contains the European Safety Phrase for the item. Multiple rows of Safety Phrase information can exist for each item. |
GR_ITEM_TOXIC |
46 | This entity holds the toxicity information recorded for an item. There can be multiple rows of toxic information for each item. |
GR_LABELS_B |
52 | Contains many label classes, each containing many rows that define the format and text for each line on the document. For example, a label |
GR_LABELS_TL |
10 | Contains the Label Description that will be displayed or printed on the document. One row displays for each language for each label code. |
GR_LABEL_CLASSES_B |
41 | The LABEL CLASS groups the label codes together into like areas such as HEADER, PHYSICAL and TRANSPORT. Although we will distribute the app |
GR_LABEL_CLASSES_TL |
10 | Contains the Label Class Description in multiple languages. |
GR_LABEL_CLASS_RESPS |
10 | Contains the Responsibility Code that can be assigned to the label. Primarily used for security purposes in the application. For example, |
GR_LABEL_PROD_CLASSES |
7 | Contains the product classes that will not print the label code and associated information. |
GR_LABEL_PROPERTIES |
10 | Contains the display properties for the label for each item code. For example, the label Color has a display property of text or phrase ent |
GR_LINKED_RISKS |
8 | Contains additional Risk Phrase Codes for European environmental class hazards that are linked to the first Risk Phrase Code. |
GR_MAIN_HEADINGS_B |
8 | Contains the Main Heading Code where the heading text is located and where the Glossary heading text is located. Codes are both system-defi |
GR_MAIN_HEADINGS_TL |
9 | The Main Heading Description. |
GR_MULTILINGUAL_NAME_TL |
41 | Contains the Document, Shipping, Trade, and Chemical Family Names for the item, by language. |
GR_ORGANIZATION_CONTACTS |
18 | Contains the contact information for the organization |
GR_OTHER_NAMES_TL |
11 | The synonym entity records alternative names for an item by language. They will be sequenced in one of two ways, as determined by the prefer |
GR_PHRASES_B |
39 | Contains the high-level information about the Phrase, the Label Code, and the wording that identifies where on the document the phrase norma |
GR_PHRASES_TL |
50 | Contains information for indexing and the print image. |
GR_PHRASE_CONCS |
41 | Contains at least one record for a phrase. Also holds the type and hierarchy associated with the concentration levels for the phrase. |
GR_PHRASE_CONFLICTS |
8 | Contains the action for resolving conflicting text phrases. |
GR_PHRASE_GROUP_ASSOC |
9 | Contains the Phrase Group Sequence Number. |
GR_PHRASE_GROUP_CODES |
7 | Contains the Phrase Group Code and Description. |
GR_PHRASE_TYPES |
7 | Contains the Phrase Type Code and Description |
GR_PRODUCT_CLASSES |
8 | Contains the classifications of products with similar requirements or properties, such as solids or acid-based products |
GR_PROPERTIES_B |
11 | Contains the Property Code and Indicator for the label attributes. A label can have several Property Codes |
GR_PROPERTIES_TL |
10 | Contains the Property Description for the label attributes. A label can have several Property Codes. |
GR_PROPERTY_VALUES_TL |
12 | Contains the Description, Value, and Meaning used to validate the data entered for the property. For example, Marine Pollutants can have val |
GR_PROP_CHNG_TEMP |
5 | GR Table used by the Map to temporaily property change information |
GR_RECIPIENT_ADDRESSES |
8 | Contains multiple address information for the customer. |
GR_RECIPIENT_ADDR_TYPES |
7 | Contains additional address types and descriptions that fall outside of the standard shipping and invoice addresses |
GR_RECIPIENT_DOCUMENTS |
7 | This entity will only be populated if the ADDITIONAL DOCUMENTFLAG on the customer entity is set to 'Y'. It allows the user to specifythe pr |
GR_RECIPIENT_INFO |
52 | Contains additional customer specific information. |
GR_REGIONS |
7 | Stores the region code and its description. Each record represents a geographic region. |
GR_REGION_LANGUAGES |
7 | Contains the language and region combinations. |
GR_RISK_CALCULATIONS |
8 | Contains the flags that associate carcinogenic, health, and toxicity classifications with Risk Phrases. |
GR_RISK_COMBINATIONS |
10 | Contains the Group and Sequence information for listing multiple Risk Phrase Codes. |
GR_RISK_PHRASES_B |
40 | Stores the code and name of acceptable phrases in multiple languages. |
GR_RISK_PHRASES_TL |
10 | Stores the code and name of acceptable phrases in multiple languages. |
GR_SAFETY_CATEGORIES_B |
6 | The safety category code that is used in the European classification process. |
GR_SAFETY_CATEGORIES_TL |
9 | Stores the safety category code in multiple languages. |
GR_SAFETY_COMBINATIONS |
10 | Contains the Group and Sequence information for combining multiple Safety Phrase Codes. |
GR_SAFETY_PHRASES_B |
40 | Stores the code and name of acceptable phrases in multiple languages. |
GR_SAFETY_PHRASES_TL |
10 | Stores the code and name of acceptable phrases in multiple languages. |
GR_SAFETY_RULES |
11 | Because of the complexity and volume of information stored in this table there will be no maintenance program provided to the user. Changes |
GR_SELECTION |
13 | Contains a table which holds the information for which document is to be printed from the Sales Order Processing information. |
GR_SELECTION_HEADER |
13 | Contains all the selection criteria for printing documents from Sales Orders that have been taken and/or shipped. |
GR_SOURCE_RISKS |
7 | Contains the Risk Phrases that are applied based on the ingredient. |
GR_SPHRASE_CONFLICTS |
8 | Contains the safety phrases that when combined would conflict and the safety phrase that should be applied in the situation. |
GR_SUB_HEADINGS_B |
8 | Contains the Sub Heading Code for the sub heading text. |
GR_SUB_HEADINGS_TL |
9 | The Sub Heading Description. |
GR_TOXIC_EFFECTS_B |
6 | This entity stores, by language, the standard observed toxic effects. The 3 character code is based on those used in Sax's Properties of Dan |
GR_TOXIC_EFFECTS_TL |
9 | This entity stores, by language, the standard observed toxic effects. The 3 character code is based on those used in Sax's Properties of Dan |
GR_TOXIC_ROUTES_B |
6 | This entity stores, by language, the description of the route of administration for the toxicity test. The 3 character code is based on thos |
GR_TOXIC_ROUTES_TL |
9 | This entity stores, by language, the standard observed toxic routes. The 3 character code is based on those used in Sax's Properties of Dang |
GR_TOXIC_SPECIES_B |
7 | This entity stores, by language, the standard codes and descriptions for animal species used in testing. The 3 character code is based on th |
GR_TOXIC_SPECIES_TL |
9 | This entity stores, by language, the standard codes and descriptions for animal species used in testing. The 3 character code is based on th |
GR_UPLOAD_FILE_TMP |
3 | Temporary Table to load the generated MSDS |
GR_WORK_ADDITIVES |
6 | Contains a temporary table used during the document build process. |
GR_WORK_ADDITIVE_RISKS |
3 | Contains a temporary table used during the document build process. |
GR_WORK_AUDIT |
3 | Contains European information for building audit reports |
GR_WORK_BUILD_DOCS |
16 | Contains a temporary table used during the document build process. |
GR_WORK_CLASSNS |
5 | Contains a temporary table used during the document build process. |
GR_WORK_CLASSN_RISKS |
4 | Contains a temporary table used during the document build process. |
GR_WORK_COUNTRY |
7 | Contains a temporary table used during the heavy element build process. |
GR_WORK_HEAVY_ELEMENTS |
7 | Contains a temporary table used during the heavy element build process. |
GR_WORK_INGRED_CONCS |
5 | Contains a temporary table used during the document build process. |
GR_WORK_SAFETY_CATEGORY |
6 | Contains a temporary table used during the document build process. |
GR_WORK_SAFETY_PHRASES |
9 | Contains a temporary table used during the document build process. |
GR_WORK_WORKSHEETS |
7 | Work table for printing worksheets. |
GR_XML_PROPERTIES_MAP |
3 | GR XML mapping table |