CSE_W_CLAIMS_B
The claim created for the warranty provider with all the collected entitlements.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSE_W_CLAIMS_B_PK |
CLAIM_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
CLAIM_ID | NUMBER | 18 | Yes | Claim Identifier. This is the primary key of this entity. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
CLAIM_NUMBER | VARCHAR2 | 80 | Yes | The user identifiable unique number for the claim. | ||
CLAIM_TYPE_CODE | VARCHAR2 | 30 | The type of the claim. User defined in the lookup ORA_CSE_WTY_CLAIM_TYPE. | |||
MANUALLY_CREATED_FLAG | VARCHAR2 | 1 | Flag indicating whether this claim is autogenerated by the entitmenents engine or is manually created. | |||
OBJECT_TYPE_CODE | VARCHAR2 | 30 | The type of object that is primarily associated to the claim. The primary use case involved the work order business object. | |||
OBJECT_ID | NUMBER | 18 | The object identifier that is primarily associated to the claim. It is the work order identifier when the object_type is a work order. | |||
ASSET_ID | NUMBER | 18 | The asset for which the claim is made. When the claim is done for a work order, it is usually the asset at the work order. | Obsolete | ||
WARRANTY_PROVIDER_ID | NUMBER | 18 | The actual provider of the warranty. It could be either the manufacturer, supplier, or a third party. | |||
CLAIM_DATE | DATE | Yes | The date the claim was put through for the warranty provider. | |||
CLAIM_STATUS_CODE | VARCHAR2 | 30 | Yes | The various statuses that the claim can transition to. | ||
SUBMIT_BY_DATE | DATE | The date by which the claim must be submitted. This is driven by the default must submit by days parameter at the provider parameters setup. | ||||
CLAIM_AMOUNT | NUMBER | The total claimable amount from the warranty provider. | ||||
CLAIM_AMOUNT_CURRENCY_CODE | VARCHAR2 | 20 | The currency in which the claim is made. | |||
CLAIM_NOTES | VARCHAR2 | 4000 | Notes documented for the claim processor. | |||
REIMBURSEMENT_REFERENCE | VARCHAR2 | 120 | Reference information from a third party system. | |||
ASSIGNED_TO_PERSON_ID | NUMBER | 18 | The employee that is assigned to process this claim. | |||
REASON_FOR_REPAIR_CODE_ID | NUMBER | 18 | Represents the reason for which this repair operation is to be performed. Foreign key to cse_condition_event_codes_b table. | |||
PROVIDER_LABOR_RATE | NUMBER | The labor rate which the provider has agreed to pay for the repair work. | ||||
MATCH_TO_TXN_CODE_FLAG | VARCHAR2 | 1 | Flag to indicate that the transactions performed in this work order must be coded with predefined transaction codes. | |||
MATERIAL_AMOUNT_TOTAL | NUMBER | The total material cost collected from the entitlements. Summary column. | ||||
EQUIPMENT_AMOUNT_TOTAL | NUMBER | The total equipment resource cost collected from the entitlements. Summary column. | ||||
RESOURCE_AMOUNT_TOTAL | NUMBER | The total resource cost collected from the entitlements. Summary column. | Obsolete | |||
LABOR_AMOUNT_TOTAL | NUMBER | The total resource cost collected from the entitlements. Summary column. | ||||
STANDARD_LABOR_AMOUNT | NUMBER | The standard labor repair amount computed for the standard repair work allowed for the provider. | ||||
OTHER_AMOUNT | NUMBER | Any other miscellaneous cost incurred in the repair process. | ||||
CLAIM_ADJUSTMENT_AMOUNT | NUMBER | The amount to be adjusted to the claimable amount. | ||||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | The currency conversion type used to arrive at the conversion rate. | |||
CURRENCY_CONVERSION_RATE | NUMBER | The currency conversion rate used in converting the base amount to the claim curency code. | ||||
REIMBURSEMENT_AMOUNT | NUMBER | The actual amount that is reimburded from the warranty provider. | ||||
REIMBURSEMENT_TYPE_CODE | VARCHAR2 | 30 | The type of reimbursement. This is an user defined lookup. | |||
RESOLUTION_DATE | DATE | The date when the warranty claim was processed by the warranty provider. | ||||
ACTIVE_END_DATE | DATE | The date when the claim is invalidated. | ||||
EXTN_ATTRIBUTE_CHAR001 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR002 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR003 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR004 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR005 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR006 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR007 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR008 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR009 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR010 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR011 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR012 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR013 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR014 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR015 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR016 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR017 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR018 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR019 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR020 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR021 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR022 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR023 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR024 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR025 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR026 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR027 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR028 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR029 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR030 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR031 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR032 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR033 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR034 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR035 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR036 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR037 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR038 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR039 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR040 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR041 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR042 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR043 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR044 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR045 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR046 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR047 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR048 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR049 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR050 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR051 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR052 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR053 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR054 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR055 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR056 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR057 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR058 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR059 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR060 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR061 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR062 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR063 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR064 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR065 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR066 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR067 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR068 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR069 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR070 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR071 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR072 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR073 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR074 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR075 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR076 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR077 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR078 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR079 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR080 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR081 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR082 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR083 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR084 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR085 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR086 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR087 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR088 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR089 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR090 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR091 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR092 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR093 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR094 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR095 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR096 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR097 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR098 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR099 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR100 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_CLOB001 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_CLOB002 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_CLOB003 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_CLOB004 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
EXTN_ATTRIBUTE_CLOB005 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | ||||
CURRENCY_CODE | VARCHAR2 | 15 | Runtime Extensibility: Currency code for the extensibility. | |||
CORP_CURRENCY_CODE | VARCHAR2 | 15 | Runtime Extensibility: Corporate currency code for extensibility. | |||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | Runtime Extensibility: Currency conversion rate type for extensibility. | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_W_CLAIMS_B_U01 | Unique | Default | CLAIM_ID |