# DW_SUPPLIER_REG_BUS_CLASS_MAP_G

This table stores information about business classification requests for suppliers.

## Details

Module: Supplier Model

## Key Columns

BUS_CLASS_REQUEST_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
BUS_CLASS_REQUEST_ID | NUMBER | 38 | 0 | True | Business classification request identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
SUPPLIER_REG_ID | NUMBER | 38 | 0 |  | Supplier registration identifier |  |
BUSINESS_CLASS_CODE | VARCHAR2 | 32 |  |  | Code of business classification lookup | DW_SUPPLIER_BUS_CLASS_LKP_TL | BUSINESS_CLASSIFICATION_CODE
BUSINESS_SUB_CLASS_CODE | VARCHAR2 | 256 |  |  | Currently stores miniority group code | DW_SUPPLIER_SUBCLASS_LKP_TL | SUB_CLASSIFICATION_CODE
CERTIFICATION_NO | VARCHAR2 | 128 |  |  | Certification number |  |
CERTIFYING_AGENCY_NAME | VARCHAR2 | 256 |  |  | Certifying agency name |  |
CERTIFYING_AGENCY_DESCRIPTION | VARCHAR2 | 999 |  |  | Certifying agency Description |  |
OTHER_CERTIFYING_AGENCY | VARCHAR2 | 256 |  |  | Field to capture other cerifying agency. |  |
REQUEST_STATUS | VARCHAR2 | 32 |  |  | Status of the request | DW_SUPPLIER_PROFILE_REQ_STATUS_LKP_TL | REQUEST_STATUS_CODE
START_DATE | DATE |  |  |  | Start Date of the classification certificate. | DW_DAY_D | CALENDAR_DATE
EXPIRATION_DATE | DATE |  |  |  | Expiration date of the certification | DW_DAY_D | CALENDAR_DATE
PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement business unit identifier | DW_LEDGER_D | LEDGER_ID
PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger of Procurement Business Unit. | DW_PERSON_D | PERSON_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal period type | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Fiscal Calendar Name | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
STARTED_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Period name as per Start Date | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
EXPIRATION_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Period name as per Expiration Date | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
CREATION_DATE | TIMESTAMP |  |  |  | The date and time of the creation of the row |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | The date and time of the last update of the row. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.