Oracle Fusion · Data dictionary
CSE_W_CLAIMS_B
SharedUsed in 1 subject areas32 reporting columns
base table, language-neutral data (paired with _TL labels and the _VL view).
Primary key: not yet catalogued for CSE_W_CLAIMS_B, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVE_END_DATE | ● | Active end date. | |
| ASSIGNED_TO_PERSON_ID | ● | Identifier for the assigned to person. | |
| CLAIM_ADJUSTMENT_AMOUNT | ● | Claim adjustment amount. | |
| CLAIM_AMOUNT | ● | Claim amount. | |
| CLAIM_AMOUNT_CURRENCY_CODE | ● | Currency code for the claim amount. | |
| CLAIM_DATE | ● | Claim date. | |
| CLAIM_ID | ● | Identifier for the claim. | |
| CLAIM_NOTES | ● | Claim notes. | |
| CLAIM_NUMBER | ● | Claim number. | |
| CLAIM_STATUS_CODE | ● | Code identifying the claim status. | |
| CLAIM_TYPE_CODE | ● | Code identifying the claim type. | |
| CORP_CURRENCY_CODE | ● | Currency code for the corp. | |
| CURCY_CONV_RATE_TYPE | ● | Type of curcy conv rate. | |
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENCY_CONVERSION_RATE | ● | Currency conversion rate. | |
| CURRENCY_CONVERSION_TYPE | ● | Type of currency conversion. | |
| EQUIPMENT_AMOUNT_TOTAL | ● | Equipment amount total. | |
| LABOR_AMOUNT_TOTAL | ● | Labor amount total. | |
| MANUALLY_CREATED_FLAG | ● | Indicator (Y/N) for the manually created. | |
| MATCH_TO_TXN_CODE_FLAG | ● | Indicator (Y/N) for the match to transaction code. | |
| MATERIAL_AMOUNT_TOTAL | ● | Material amount total. | |
| OBJECT_ID | ● | Identifier for the object. | |
| OBJECT_TYPE_CODE | ● | Code identifying the object type. | |
| OTHER_AMOUNT | ● | Other amount. | |
| PROVIDER_LABOR_RATE | ● | Provider labor rate. | |
| REIMBURSEMENT_AMOUNT | ● | Reimbursement amount. | |
| REIMBURSEMENT_REFERENCE | ● | Reimbursement reference. | |
| REIMBURSEMENT_TYPE_CODE | ● | Code identifying the reimbursement type. | |
| RESOLUTION_DATE | ● | Resolution date. | |
| STANDARD_LABOR_AMOUNT | ● | Standard labor amount. | |
| SUBMIT_BY_DATE | ● | Submit by date. | |
| 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for CSE_W_CLAIMS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table