JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

SupplierQualificationAreas

Manages qualification areas, like compliance or financial stability, for assessing supplier eligibility and performance.

Columns

Name Type Description
QualAreaId [KEY] Long Unique identifier for the qualification area. This ID links the specific qualification area to the supplier qualification process. It can be found in the qualification area data tables.
OriginalQualAreaId Long Original identifier for the qualification area, if the current area is a revision. This helps trace the original area in the history of changes. It can be found in the qualification area revision data.
Revision Int Revision number of the qualification area. This helps track the version history of the qualification area. The revision number is stored in the qualification area versioning system.
QualArea String Name or title of the qualification area. This value typically represents the category or topic being evaluated during the qualification process. It is available in the qualification area listing.
QualAreaDescription String Textual description of the qualification area. This provides more context and details about the qualification area. The description is stored in the qualification area details.
QualAreaStatus String Current status of the qualification area. Valid values include 'Active', 'Inactive', and 'Expired'. The status helps track whether the area is currently in use or archived. Review the list of accepted values in the qualification management system.
QualAreaStatusCode String Abbreviation of the qualification area status. For example, 'ACT' for active, or 'INA' for inactive. Accepted values are found in the lookup type for qualification status codes.
GlobalFlag Bool Indicates whether the qualification area is global or region-specific. If true, the area is applicable globally. If false, it applies only to specific regions or business units.
InformationOnlyFlag Bool Indicates if the qualification area is for informational purposes only. If true, the area is not used in active evaluations but is available for reference.
LatestRevisionFlag Bool Indicates whether this revision is the latest version. If true, this is the most recent revision of the qualification area.
QualAreaLevelCode String Abbreviation identifying the qualification area's level (for example, 'Basic', 'Advanced'). This helps determine the depth or complexity of the qualification area. The list of accepted levels can be found in the qualification level lookup.
QualAreaLevel String Full name describing the qualification area's level (for example, 'Basic', 'Advanced'). This value categorizes the qualification area based on its depth and is typically found in qualification system settings.
ProcurementBUId Long Unique identifier for the procurement business unit associated with the qualification area. This helps link the qualification area to the appropriate procurement department.
ProcurementBU String Name of the procurement business unit associated with the qualification area. It indicates the department or division handling the qualification.
OwnerId Long Unique identifier for the owner of the qualification area. This is the person or group responsible for managing the qualification area.
Owner String Name of the owner of the qualification area. This individual or group is responsible for overseeing and updating the qualification area.
SubjectCode String Code that identifies the subject of the qualification area. The subject can be a category or theme within the procurement process. Accepted values are available in the qualification area subject lookup.
Subject String Name of the subject of the qualification area. It provides a brief description of the topic or category of evaluation, such as 'Supplier Management' or 'Compliance'.
StandardsOrganizationCode String Code that identifies the standards organization relevant to the qualification area. A list of accepted values is defined in the organization standards lookup.
StandardsOrganization String Name of the standards organization associated with the qualification area. This could be an industry-recognized body that defines standards for the qualification process.
ActivationDate Datetime The date when the qualification area becomes active. This date is important for tracking when the area can be used in evaluations.
EnableScoringFlag Bool Indicates whether scoring is enabled for the qualification area. If true, suppliers are scored based on their responses; otherwise, scoring is not applicable.
AutoAcceptResponsesFlag Bool Indicates if responses to the qualification area are automatically accepted. If true, responses are automatically marked as accepted without manual review.
AutoPopulateResponsesFlag Bool Indicates whether responses are automatically populated from existing data repositories. If true, previous responses are pre-filled during evaluation.
AutoEvaluateQualFlag Bool Indicates if qualification area responses are automatically evaluated. If true, responses are evaluated based on predefined criteria; otherwise, manual evaluation is required.
ExpirationReminderTypeCode String Abbreviation for the type of expiration reminder. Possible values include 'DAYS' or 'WEEKS'. This determines the frequency of reminders sent before the qualification area expires.
ExpirationReminderType String Description of the type of expiration reminder. It could include options like 'Days', 'Weeks', or 'Months'. Accepted values are defined in the expiration reminder type lookup.
ExpirationReminderPeriod Int Number of days, weeks, or months before expiration when the reminder will be sent. For example, if set to 30, a reminder will be sent 30 days before expiration.
RequalifyExpirationFlag Bool Indicates whether the qualification area will require requalification upon expiration. If true, the supplier must requalify to continue participating.
QualificationDurationTypeCode String Code that defines the type of duration for the qualification area (for example, 'YEAR', 'MONTH'). Accepted values are defined in the qualification duration type lookup.
QualificationDurationType String Name of the type of duration for the qualification area (for example, 'Year', 'Month'). This helps define how long the qualification area remains valid before requiring updates.
QualificationDuration Int Length of time for which the qualification area is valid. For example, a duration of 12 means the qualification is valid for 12 months.
ShowQualToSupplierFlag Bool Indicates whether the qualification area is visible to the supplier. If true, suppliers can view and respond to the qualification; otherwise, it is hidden.
ShowQualSuppRespFlag Bool Indicates whether supplier responses to the qualification area are visible. If true, suppliers can see responses from others; if false, they cannot.
ShowQualInterRespFlag Bool Indicates whether internal responses to the qualification area are visible. If true, internal responses are displayed for review; if false, they are hidden.
NoteToSupplier String Text note that provides additional information or instructions to the supplier regarding the qualification area.
RequalifyResponseFlag Bool Indicates whether suppliers need to provide new responses upon requalification. If true, suppliers must submit new responses; otherwise, existing responses are retained.
SingleQualAutoInitFlag Bool Indicates whether the qualification process should automatically initialize for a single qualification. If true, the process begins automatically for each new qualification.
QualificationOwnerId Long Unique identifier for the qualification area owner, who is responsible for managing the qualification process.
QualificationOwnerName String Name of the owner of the qualification area. This is the person or group responsible for overseeing the qualification process.
QualAreaSurveyFlag Bool Indicates whether the qualification area is part of a survey. If true, the area is included in a survey sent to suppliers.
SectionName String Name of the section that the qualification area belongs to. This helps categorize the qualification within larger documents or surveys.
Finder String Search term or filter used to locate the qualification area record in the system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434