# DW_SUPPLIER_ASSESSMENT_CF

This table stores supplier assessment details with related initiative context and fiscal attributes.

## Details

Module: Supplier Model

## Key Columns

ASSESSMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSESSMENT_ID | NUMBER | 38 | 0 | True | System-generated unique identifier. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. System generated Unique Identifier. |  |
ASSESSMENT_NUMBER | VARCHAR2 | 32 |  |  | The assessment number assigned to the assessment. |  |
ASSESSMENT_NAME | VARCHAR2 | 128 |  |  | Assessment name associated with the qualification model name. |  |
ASSESSMENT_STATUS_CODE | VARCHAR2 | 32 |  |  | The status assigned to the assessment. |  |
ASSESSMENT_OWNER_ID | NUMBER | 38 | 0 |  | The unique identifier associated with the person who is the assessment owner. | DW_PERSON_D | PERSON_ID
EVALUATION_DUE_DATE | DATE |  |  |  | Assessment evaluation due date. |  |
EVALUATED_BY | NUMBER | 38 | 0 |  | Person identifier of the evaluator. | DW_PERSON_D | PERSON_ID
ASSESSMENT_OUTCOME | VARCHAR2 | 128 |  |  | The outcome assigned to the assessment. |  |
EFFECTIVE_START_DATE | TIMESTAMP |  |  |  | Indicates the date at the beginning of the date range within which the row is effective. |  |
EFFECTIVE_END_DATE | TIMESTAMP |  |  |  | Indicates the date at the end of the date range within which the row is effective. |  |
EVALUATION_DATE | DATE |  |  |  | Date at which the evaluation for this assessment took place. |  |
PROCUREMENT_BU_ID | NUMBER | 38 | 0 |  | Procurement business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROCUREMENT_LEDGER_ID | NUMBER | 38 | 0 |  | Identifier for Procurement Ledger. | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal period Type of Procurement Business Unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Calendar Name for Procurement business unit. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
EVALUATION_FISCAL_PERIOD_NAME | VARCHAR2 | 16 |  |  | Period Name as per EVALUATION_DATE. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
SUPPLIER_ID | NUMBER | 38 | 0 |  | Supplier identifier who is being assessed. | DW_SUPPLIER_D | SUPPLIER_ID
SUPPLIER_SITE_ID | NUMBER | 38 | 0 |  | Supplier site identifier associated with the assessment. |  |
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
INITIATIVE_ID | NUMBER | 38 | 0 |  | The unique identifier associated with the initiative. |  |
INITIATIVE_NUMBER | VARCHAR2 | 32 |  |  | The number that is assigned to the initiative. |  |
INITIATIVE_DESCRIPTION | VARCHAR2 | 256 |  |  | A description of the initiative. |  |
INITIATIVE_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of the Initiative (ASSESSMENT or QUALIFICATION). |  |
INITIATIVE_TITLE | VARCHAR2 | 128 |  |  | The title that is assigned to the initiative. |  |
INITIATIVE_STATUS_CODE | VARCHAR2 | 32 |  |  | Indicates the status of the initiative. |  |
INITIATIVE_OWNER_ID | NUMBER | 38 | 0 |  | Identifier of the Initiative owner. | DW_PERSON_D | PERSON_ID
INITIATIVE_SURVEY_FLAG | VARCHAR2 | 16 |  |  | This flag to identify survey initiative. |  |
INITIATIVE_LAUNCH_DATE | DATE |  |  |  | Date on which Initiative is launched. | DW_DAY_D | CALENDAR_DATE
INITIATIVE_CREATION_DATE | DATE |  |  |  | The date of the creation of the row | DW_DAY_D | CALENDAR_DATE
INITIATIVE_COMPLETED_DATE | DATE |  |  |  | Initiative process completed date. | DW_DAY_D | CALENDAR_DATE
SUPPLIER_RESP_DUE_DATE | DATE |  |  |  | Indicates the date on which questionnaire response is due from suppliers. |  |
INTERNAL_RESP_DUE_DATE | DATE |  |  |  | Indicates the date on which questionnaire response is due from internal responders. |  |
INTERNAL_RESP_CLOSE_DATE | DATE |  |  |  | Indicates when all the open questionnaires will be closed. |  |
SEND_QSTNR_SUPPLIER_FLAG | VARCHAR2 | 16 |  |  | Indicates if questionnaire is sent to Supplier. | DW_YN_LKP_TL | YN_LKP_CODE
SEND_QSTNR_INTERNAL_FLAG | VARCHAR2 | 16 |  |  | Indicates if questionnaire is sent to Internal responder. | DW_YN_LKP_TL | YN_LKP_CODE

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