This table stores supplier qualification details with assessment and initiative context.
Module: Supplier Model
QUALIFICATION_ID, ASSESSMENT_QUAL_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| QUALIFICATION_ID | NUMBER | 38 | 0 | True | Unique identifier for qualification | ||
| ASSESSMENT_QUAL_ID | NUMBER | 38 | 0 | True | System-generated unique identifier for Qualification-Assessment linkage. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Composite identifier built from qualification and assessment qualification. | ||||
| QUALIFICATION_NUMBER | VARCHAR2 | 32 | Qualification number assigned to the qualification. | ||||
| QUALIFICATION_NAME | VARCHAR2 | 128 | Qualification name assigned to the qualification. | ||||
| QUAL_AREA_NAME | VARCHAR2 | 128 | Qualification area name or identifier entered by the user. | ||||
| QUAL_AREA_SURVEY_FLAG | VARCHAR2 | 16 | Fag to identify if this is a survey qualification area. | ||||
| PROCUREMENT_BU_ID | NUMBER | 38 | 0 | Procurement business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID | |
| SUPPLIER_ID | NUMBER | 38 | 0 | Supplier identifier who is being qualified. | DW_SUPPLIER_D | SUPPLIER_ID | |
| SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site identifier who is being qualified. | |||
| QUALIFICATION_OWNER_ID | NUMBER | 38 | 0 | Person id of Qualification Owner. | DW_PERSON_D | PERSON_ID | |
| QUALIFICATION_OUTCOME | VARCHAR2 | 128 | The outcome assigned to the qualification. | ||||
| QUALIFICATION_STATUS_CODE | VARCHAR2 | 32 | The status of the qualification. | ||||
| QUALIFICATION_START_DATE | TIMESTAMP | The date at the beginning of the date range within which the row is effective. | |||||
| QUALIFICATION_END_DATE | TIMESTAMP | The date at the end of the date range within which the row is effective. | |||||
| QUAL_EVAL_DUE_DATE | DATE | Date by which this Qualification should be evaluated. | |||||
| QUAL_EVALUATED_BY | NUMBER | 38 | 0 | Person identifier of the evaluator. | DW_PERSON_D | PERSON_ID | |
| QUAL_EVALUATION_DATE | DATE | Date at which the evaluation for this qualification took place | |||||
| 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 | ||
| QUAL_EVAL_FISCAL_PERIOD_NAME | VARCHAR2 | 16 | Period Name as per EVALUATION_DATE. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| QUAL_CREATION_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| QUAL_CREATION_DATE | DATE | Who column: indicates the date of the creation of the row. | |||||
| QUAL_LAST_UPDATE_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| ASSESSMENT_ID | NUMBER | 38 | 0 | 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 | |
| ASSESSMENT_EVAL_DUE_DATE | DATE | Assessment evaluation due date. | |||||
| ASSESSMENT_OUTCOME | VARCHAR2 | 128 | The outcome assigned to the assessment. | ||||
| ASSESSMENT_EVALUATED_BY | NUMBER | 38 | 0 | Person identifier of the evaluator. | DW_PERSON_D | PERSON_ID | |
| ASSESSMENT_START_DATE | TIMESTAMP | Indicates the date at the beginning of the date range within which the row is effective. | |||||
| ASSESSMENT_END_DATE | TIMESTAMP | Indicates the date at the end of the date range within which the row is effective. | |||||
| ASSESSMENT_EVALUATION_DATE | DATE | Date at which the evaluation for this assessment took place. | |||||
| 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.