# DW_SUPPLIER_BUS_CLASSIFICATIONS_D

This table stores information about the business classifications for suppliers

## Details

Module:

## Key Columns

CLASSIFICATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CLASSIFICATION_ID | NUMBER | 38 | 0 | True | Classification identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Unique Source Record Identifier.This column contains the Classification Id |  |
PARTY_ID | NUMBER | 38 | 0 |  | Party Identifier |  |
CLASSIFICATION_CODE | VARCHAR2 | 64 |  |  | Lookup code for the business classification type | DW_SUPPLIER_BUS_CLASS_LKP_TL | SUPPLIER_BUS_CLASS_LKP_CODE
START_DATE | DATE |  |  |  | The Start Date of the business classification certificate. |  |
EXPIRATION_DATE | DATE |  |  |  | Expiration date of the certificate |  |
CERTIFICATE_NUMBER | VARCHAR2 | 128 |  |  | Certificate Number of the certificate granted to the supplier for the classification |  |
SUB_CLASSIFICATION_CODE | VARCHAR2 | 256 |  |  | Sub Classification eg:the minority type for the Minority Owned business classification | DW_SUPPLIER_SUBCLASS_LKP_TL | SUPPLIER_SUBCLASS_LKP_CODE
VENDOR_ID | NUMBER | 38 | 0 |  | Vendor Identifier |  |
DELETED_FLAG | VARCHAR2 | 16 |  |  | Business Classification status: Y - deleted row Default - N |  |
CERTIFYING_AGENCY_ID | NUMBER | 38 | 0 |  | Identifier of the certifying agency that granted the business classification certificate to the supplier |  |
OTHER_CERTIFYING_AGENCY | VARCHAR2 | 256 |  |  | Field to capture other certifying agencies apart from those in the list. |  |
CLASS_STATUS_CODE | VARCHAR2 | 256 |  |  | Status of the classification used by the internal buyers. Valid values are PENDING, APPROVED, REJECTED. | DW_SUPPLIER_BUS_CLASS_STATUS_LKP_TL | SUPPLIER_BUS_CLASS_STATUS_LKP_CODE
CERTIFYING_AGENCY_NAME | VARCHAR2 | 256 |  |  | Certifying agency name |  |
CERTIFYING_AGENCY_DESC | VARCHAR2 | 999 |  |  | Certifying agency Description |  |
CERTIFYING_AGENCY_ENDDATE | DATE |  |  |  | End date of the Certifying Agency. The certifying Agency will be inactive after this date. |  |

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