Oracle Fusion · Data dictionary
CSE_W_COVERAGES_B
SharedUsed in 10 subject areas19 reporting columns
base table, language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for CSE_W_COVERAGES_B, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AUTHORIZATION_REQUIRED_FLAG | ● | Indicator (Y/N) for the authorization required. | |
| COVERAGE_CODE | ● | Code identifying the coverage. | |
| COVERAGE_END_DATE | ● | Coverage end date. | |
| COVERAGE_ID | ● | Identifier for the coverage. | |
| COVERAGE_START_DATE | ● | Coverage start date. | |
| COVERAGE_STATUS_CODE | ● | Code identifying the coverage status. | |
| COVERAGE_TYPE_CODE | ● | Code identifying the coverage type. | |
| INTERNAL_REPAIR_ALLOWED_FLAG | ● | Indicator (Y/N) for the internal repair allowed. | |
| LABOR_REIMBURSEMENT_FLAG | ● | Indicator (Y/N) for the labor reimbursement. | |
| MANUFACTURER_ID | ● | Identifier for the manufacturer. | |
| PARTS_REIMBURSEMENT_FLAG | ● | Indicator (Y/N) for the parts reimbursement. | |
| PARTS_RETURN_REQUIRED_FLAG | ● | Indicator (Y/N) for the parts return required. | |
| REACTIONS_AND_RESOLUTIONS | ● | Reactions and resolutions. | |
| SERVICE_LEVEL_AGREEMENTS | ● | Service level agreements. | |
| SUPPLIER_ID | ● | Identifier for the supplier. | |
| TERMS_AND_CONDITIONS | ● | Terms and conditions. | |
| WARRANTY_DURATION | ● | Warranty duration. | |
| WARRANTY_DURATION_UOM_CODE | ● | Code identifying the warranty duration unit of measure. | |
| WARRANTY_PROVIDER_ID | ● | Identifier for the warranty provider. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset History Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Supplier Warranty - Asset Real Time
Need the extract + dbt staging for CSE_W_COVERAGES_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table