JA_AU_EARNING_TRANSACTIONS
This table contains FIC earning transaction information.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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. | ||
| MEASURE_RESULT_ID | NUMBER | 18 | Yes | Unique identifier for the measure result. | |
| EARNING_ID | NUMBER | 18 | Yes | Unique identifier for the earning transaction. | |
| CREDIT_ID | NUMBER | 18 | Yes | CREDIT_ID | |
| TRANSACTION_ID | NUMBER | 18 | Yes | TRANSACTION_ID | |
| PARTICIPANT_NAME | VARCHAR2 | 360 | Yes | PARTICIPANT_NAME | |
| SOURCE_EVENT_DATE | DATE | Yes | SOURCE_EVENT_DATE | ||
| PERIOD_NAME | VARCHAR2 | 30 | Yes | PERIOD_NAME | |
| COMM_AMT_FUNC_CURR | NUMBER | COMM_AMT_FUNC_CURR | |||
| COMM_AMT_CALC_CURR | NUMBER | COMM_AMT_CALC_CURR | |||
| CALC_CURRENCY_CODE | VARCHAR2 | 15 | CALC_CURRENCY_CODE | ||
| TRANSACTION_TYPE | VARCHAR2 | 80 | Yes | TRANSACTION_TYPE | |
| ELIGIBLE_CAT_ID | NUMBER | 18 | ELIGIBLE_CAT_ID | ||
| CREDIT_CATEGORY | VARCHAR2 | 80 | CREDIT_CATEGORY | ||
| OBJECT_STATUS | VARCHAR2 | 30 | Yes | OBJECT_STATUS | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| SOURCE_TRX_NUMBER | VARCHAR2 | 30 | Yes | SOURCE_TRX_NUMBER | |
| PLAN_COMPONENT_ID | NUMBER | 18 | Yes | PLAN_COMPONENT_ID | |
| PLAN_COMPONENT_NAME | VARCHAR2 | 80 | PLAN_COMPONENT_NAME | ||
| ORIGINATING_CHANNEL_NAME | VARCHAR2 | 240 | ORIGINATING_CHANNEL_NAME | ||
| HOLD_FLAG | VARCHAR2 | 1 | Yes | HOLD_FLAG | |
| COMPONENT_CATEGORY | VARCHAR2 | 50 | Yes | COMPONENT_CATEGORY | |
| COMPONENT_TYPE | VARCHAR2 | 50 | Yes | COMPONENT_TYPE | |
| OUTPUT_ACHIEVED | NUMBER | Yes | OUTPUT_ACHIEVED | ||
| MEASURE_TYPE | VARCHAR2 | 20 | Yes | MEASURE_TYPE | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |
| ATTRIBUTE_VALUE1 | VARCHAR2 | 240 | ATTRIBUTE_VALUE1 | ||
| ATTRIBUTE_NAME2 | VARCHAR2 | 30 | ATTRIBUTE_NAME2 | ||
| ATTRIBUTE_VALUE2 | VARCHAR2 | 240 | ATTRIBUTE_VALUE2 | ||
| ATTRIBUTE_NAME3 | VARCHAR2 | 30 | ATTRIBUTE_NAME3 | ||
| ATTRIBUTE_VALUE3 | VARCHAR2 | 240 | ATTRIBUTE_VALUE3 | ||
| ATTRIBUTE_NAME4 | VARCHAR2 | 30 | ATTRIBUTE_NAME4 | ||
| ATTRIBUTE_VALUE4 | VARCHAR2 | 240 | ATTRIBUTE_VALUE4 | ||
| ATTRIBUTE_NAME5 | VARCHAR2 | 30 | ATTRIBUTE_NAME5 | ||
| ATTRIBUTE_VALUE5 | VARCHAR2 | 240 | ATTRIBUTE_VALUE5 | ||
| ATTRIBUTE_NAME6 | VARCHAR2 | 30 | ATTRIBUTE_NAME6 | ||
| ATTRIBUTE_VALUE6 | VARCHAR2 | 240 | ATTRIBUTE_VALUE6 | ||
| ATTRIBUTE_NAME7 | VARCHAR2 | 30 | ATTRIBUTE_NAME7 | ||
| ATTRIBUTE_VALUE7 | VARCHAR2 | 240 | ATTRIBUTE_VALUE7 | ||
| ATTRIBUTE_NAME8 | VARCHAR2 | 30 | ATTRIBUTE_NAME8 | ||
| ATTRIBUTE_VALUE8 | VARCHAR2 | 240 | ATTRIBUTE_VALUE8 | ||
| ATTRIBUTE_NAME9 | VARCHAR2 | 30 | ATTRIBUTE_NAME9 | ||
| ATTRIBUTE_VALUE9 | VARCHAR2 | 240 | ATTRIBUTE_VALUE9 | ||
| ATTRIBUTE_NAME10 | VARCHAR2 | 30 | ATTRIBUTE_NAME10 | ||
| ATTRIBUTE_VALUE10 | VARCHAR2 | 240 | ATTRIBUTE_VALUE10 | ||
| ATTRIBUTE_NAME11 | VARCHAR2 | 30 | ATTRIBUTE_NAME11 | ||
| ATTRIBUTE_VALUE11 | VARCHAR2 | 240 | ATTRIBUTE_VALUE11 | ||
| ATTRIBUTE_NAME12 | VARCHAR2 | 30 | ATTRIBUTE_NAME12 | ||
| ATTRIBUTE_VALUE12 | VARCHAR2 | 240 | ATTRIBUTE_VALUE12 | ||
| ATTRIBUTE_NAME13 | VARCHAR2 | 30 | ATTRIBUTE_NAME13 | ||
| ATTRIBUTE_VALUE13 | VARCHAR2 | 240 | ATTRIBUTE_VALUE13 | ||
| ATTRIBUTE_NAME14 | VARCHAR2 | 30 | ATTRIBUTE_NAME14 | ||
| ATTRIBUTE_VALUE14 | VARCHAR2 | 240 | ATTRIBUTE_VALUE14 | ||
| ATTRIBUTE_NAME15 | VARCHAR2 | 30 | ATTRIBUTE_NAME15 | ||
| ATTRIBUTE_VALUE15 | VARCHAR2 | 240 | ATTRIBUTE_VALUE15 | ||
| ATTRIBUTE_NAME16 | VARCHAR2 | 30 | ATTRIBUTE_NAME16 | ||
| ATTRIBUTE_VALUE16 | VARCHAR2 | 240 | ATTRIBUTE_VALUE16 | ||
| ATTRIBUTE_NAME17 | VARCHAR2 | 30 | ATTRIBUTE_NAME17 | ||
| ATTRIBUTE_VALUE17 | VARCHAR2 | 240 | ATTRIBUTE_VALUE17 | ||
| ATTRIBUTE_NAME18 | VARCHAR2 | 30 | ATTRIBUTE_NAME18 | ||
| ATTRIBUTE_VALUE18 | VARCHAR2 | 240 | ATTRIBUTE_VALUE18 | ||
| ATTRIBUTE_NAME19 | VARCHAR2 | 30 | ATTRIBUTE_NAME19 | ||
| ATTRIBUTE_VALUE19 | VARCHAR2 | 240 | ATTRIBUTE_VALUE19 | ||
| ATTRIBUTE_NAME20 | VARCHAR2 | 30 | ATTRIBUTE_NAME20 | ||
| ATTRIBUTE_VALUE20 | VARCHAR2 | 240 | ATTRIBUTE_VALUE20 | ||
| ATTRIBUTE_NAME21 | VARCHAR2 | 30 | ATTRIBUTE_NAME21 | ||
| ATTRIBUTE_VALUE21 | VARCHAR2 | 240 | ATTRIBUTE_VALUE21 | ||
| ATTRIBUTE_NAME22 | VARCHAR2 | 30 | ATTRIBUTE_NAME22 | ||
| ATTRIBUTE_VALUE22 | VARCHAR2 | 240 | ATTRIBUTE_VALUE22 | ||
| ATTRIBUTE_NAME23 | VARCHAR2 | 30 | ATTRIBUTE_NAME23 | ||
| ATTRIBUTE_VALUE23 | VARCHAR2 | 240 | ATTRIBUTE_VALUE23 | ||
| ATTRIBUTE_NAME24 | VARCHAR2 | 30 | ATTRIBUTE_NAME24 | ||
| ATTRIBUTE_VALUE24 | VARCHAR2 | 240 | ATTRIBUTE_VALUE24 | ||
| ATTRIBUTE_NAME25 | VARCHAR2 | 30 | ATTRIBUTE_NAME25 | ||
| ATTRIBUTE_VALUE25 | VARCHAR2 | 240 | ATTRIBUTE_VALUE25 | ||
| ATTRIBUTE_NAME26 | VARCHAR2 | 30 | ATTRIBUTE_NAME26 | ||
| ATTRIBUTE_VALUE26 | VARCHAR2 | 240 | ATTRIBUTE_VALUE26 | ||
| ATTRIBUTE_NAME27 | VARCHAR2 | 30 | ATTRIBUTE_NAME27 | ||
| ATTRIBUTE_VALUE27 | VARCHAR2 | 240 | ATTRIBUTE_VALUE27 | ||
| ATTRIBUTE_NAME28 | VARCHAR2 | 30 | ATTRIBUTE_NAME28 | ||
| ATTRIBUTE_VALUE28 | VARCHAR2 | 240 | ATTRIBUTE_VALUE28 | ||
| ATTRIBUTE_NAME29 | VARCHAR2 | 30 | ATTRIBUTE_NAME29 | ||
| ATTRIBUTE_VALUE29 | VARCHAR2 | 240 | ATTRIBUTE_VALUE29 | ||
| ATTRIBUTE_NAME30 | VARCHAR2 | 30 | ATTRIBUTE_NAME30 | ||
| ATTRIBUTE_VALUE30 | VARCHAR2 | 240 | ATTRIBUTE_VALUE30 | ||
| TRX_ATTRIBUTE1 | VARCHAR2 | 240 | TRX_ATTRIBUTE1 | ||
| TRX_ATTRIBUTE2 | VARCHAR2 | 240 | TRX_ATTRIBUTE2 | ||
| TRX_ATTRIBUTE3 | VARCHAR2 | 240 | TRX_ATTRIBUTE3 | ||
| TRX_ATTRIBUTE4 | VARCHAR2 | 240 | TRX_ATTRIBUTE4 | ||
| TRX_ATTRIBUTE5 | VARCHAR2 | 240 | TRX_ATTRIBUTE5 | ||
| TRX_ATTRIBUTE6 | VARCHAR2 | 240 | TRX_ATTRIBUTE6 | ||
| TRX_ATTRIBUTE7 | VARCHAR2 | 240 | TRX_ATTRIBUTE7 | ||
| TRX_ATTRIBUTE8 | VARCHAR2 | 240 | TRX_ATTRIBUTE8 | ||
| TRX_ATTRIBUTE9 | VARCHAR2 | 240 | TRX_ATTRIBUTE9 | ||
| TRX_ATTRIBUTE10 | VARCHAR2 | 240 | TRX_ATTRIBUTE10 | ||
| TRX_ATTRIBUTE11 | VARCHAR2 | 240 | TRX_ATTRIBUTE11 | ||
| TRX_ATTRIBUTE12 | VARCHAR2 | 240 | TRX_ATTRIBUTE12 | ||
| TRX_ATTRIBUTE13 | VARCHAR2 | 240 | TRX_ATTRIBUTE13 | ||
| TRX_ATTRIBUTE14 | VARCHAR2 | 240 | TRX_ATTRIBUTE14 | ||
| TRX_ATTRIBUTE15 | VARCHAR2 | 240 | TRX_ATTRIBUTE15 | ||
| TRX_ATTRIBUTE16 | VARCHAR2 | 240 | TRX_ATTRIBUTE16 | ||
| TRX_ATTRIBUTE17 | VARCHAR2 | 240 | TRX_ATTRIBUTE17 | ||
| TRX_ATTRIBUTE18 | VARCHAR2 | 240 | TRX_ATTRIBUTE18 | ||
| TRX_ATTRIBUTE19 | VARCHAR2 | 240 | TRX_ATTRIBUTE19 | ||
| TRX_ATTRIBUTE20 | VARCHAR2 | 240 | TRX_ATTRIBUTE20 | ||
| TRX_ATTRIBUTE21 | VARCHAR2 | 240 | TRX_ATTRIBUTE21 | ||
| TRX_ATTRIBUTE22 | VARCHAR2 | 240 | TRX_ATTRIBUTE22 | ||
| TRX_ATTRIBUTE23 | VARCHAR2 | 240 | TRX_ATTRIBUTE23 | ||
| TRX_ATTRIBUTE24 | VARCHAR2 | 240 | TRX_ATTRIBUTE24 | ||
| TRX_ATTRIBUTE25 | VARCHAR2 | 240 | TRX_ATTRIBUTE25 | ||
| TRX_ATTRIBUTE26 | VARCHAR2 | 240 | TRX_ATTRIBUTE26 | ||
| TRX_ATTRIBUTE27 | VARCHAR2 | 240 | TRX_ATTRIBUTE27 | ||
| TRX_ATTRIBUTE28 | VARCHAR2 | 240 | TRX_ATTRIBUTE28 | ||
| TRX_ATTRIBUTE29 | VARCHAR2 | 240 | TRX_ATTRIBUTE29 | ||
| TRX_ATTRIBUTE30 | VARCHAR2 | 240 | TRX_ATTRIBUTE30 | ||
| TRX_ATTRIBUTE31 | VARCHAR2 | 240 | TRX_ATTRIBUTE31 | ||
| TRX_ATTRIBUTE32 | VARCHAR2 | 240 | TRX_ATTRIBUTE32 | ||
| TRX_ATTRIBUTE33 | VARCHAR2 | 240 | TRX_ATTRIBUTE33 | ||
| TRX_ATTRIBUTE34 | VARCHAR2 | 240 | TRX_ATTRIBUTE34 | ||
| TRX_ATTRIBUTE35 | VARCHAR2 | 240 | TRX_ATTRIBUTE35 | ||
| TRX_ATTRIBUTE36 | VARCHAR2 | 240 | TRX_ATTRIBUTE36 | ||
| TRX_ATTRIBUTE37 | VARCHAR2 | 240 | TRX_ATTRIBUTE37 | ||
| TRX_ATTRIBUTE38 | VARCHAR2 | 240 | TRX_ATTRIBUTE38 | ||
| TRX_ATTRIBUTE39 | VARCHAR2 | 240 | TRX_ATTRIBUTE39 | ||
| TRX_ATTRIBUTE40 | VARCHAR2 | 240 | TRX_ATTRIBUTE40 | ||
| TRX_ATTRIBUTE_NUMBER1 | NUMBER | TRX_ATTRIBUTE_NUMBER1 | |||
| TRX_ATTRIBUTE_NUMBER2 | NUMBER | TRX_ATTRIBUTE_NUMBER2 | |||
| TRX_ATTRIBUTE_NUMBER3 | NUMBER | TRX_ATTRIBUTE_NUMBER3 | |||
| TRX_ATTRIBUTE_NUMBER4 | NUMBER | TRX_ATTRIBUTE_NUMBER4 | |||
| TRX_ATTRIBUTE_NUMBER5 | NUMBER | TRX_ATTRIBUTE_NUMBER5 | |||
| TRX_ATTRIBUTE_NUMBER6 | NUMBER | TRX_ATTRIBUTE_NUMBER6 | |||
| TRX_ATTRIBUTE_NUMBER7 | NUMBER | TRX_ATTRIBUTE_NUMBER7 | |||
| TRX_ATTRIBUTE_NUMBER8 | NUMBER | TRX_ATTRIBUTE_NUMBER8 | |||
| TRX_ATTRIBUTE_NUMBER9 | NUMBER | TRX_ATTRIBUTE_NUMBER9 | |||
| TRX_ATTRIBUTE_NUMBER10 | NUMBER | TRX_ATTRIBUTE_NUMBER10 | |||
| TRX_ATTRIBUTE_NUMBER11 | NUMBER | TRX_ATTRIBUTE_NUMBER11 | |||
| TRX_ATTRIBUTE_NUMBER12 | NUMBER | TRX_ATTRIBUTE_NUMBER12 | |||
| TRX_ATTRIBUTE_NUMBER13 | NUMBER | TRX_ATTRIBUTE_NUMBER13 | |||
| TRX_ATTRIBUTE_NUMBER14 | NUMBER | TRX_ATTRIBUTE_NUMBER14 | |||
| TRX_ATTRIBUTE_NUMBER15 | NUMBER | TRX_ATTRIBUTE_NUMBER15 | |||
| TRX_ATTRIBUTE_NUMBER16 | NUMBER | TRX_ATTRIBUTE_NUMBER16 | |||
| TRX_ATTRIBUTE_NUMBER17 | NUMBER | TRX_ATTRIBUTE_NUMBER17 | |||
| TRX_ATTRIBUTE_NUMBER18 | NUMBER | TRX_ATTRIBUTE_NUMBER18 | |||
| TRX_ATTRIBUTE_NUMBER19 | NUMBER | TRX_ATTRIBUTE_NUMBER19 | |||
| TRX_ATTRIBUTE_NUMBER20 | NUMBER | TRX_ATTRIBUTE_NUMBER20 | |||
| TRX_ATTRIBUTE_NUMBER21 | NUMBER | TRX_ATTRIBUTE_NUMBER21 | |||
| TRX_ATTRIBUTE_NUMBER22 | NUMBER | TRX_ATTRIBUTE_NUMBER22 | |||
| TRX_ATTRIBUTE_NUMBER23 | NUMBER | TRX_ATTRIBUTE_NUMBER23 | |||
| TRX_ATTRIBUTE_NUMBER24 | NUMBER | TRX_ATTRIBUTE_NUMBER24 | |||
| TRX_ATTRIBUTE_NUMBER25 | NUMBER | TRX_ATTRIBUTE_NUMBER25 | |||
| PLAN_ATTRIBUTE1 | VARCHAR2 | 240 | PLAN_ATTRIBUTE1 | ||
| PLAN_ATTRIBUTE2 | VARCHAR2 | 240 | PLAN_ATTRIBUTE2 | ||
| PLAN_ATTRIBUTE3 | VARCHAR2 | 240 | PLAN_ATTRIBUTE3 | ||
| PLAN_ATTRIBUTE4 | VARCHAR2 | 240 | PLAN_ATTRIBUTE4 | ||
| PLAN_ATTRIBUTE5 | VARCHAR2 | 240 | PLAN_ATTRIBUTE5 | ||
| PLAN_ATTRIBUTE6 | VARCHAR2 | 240 | PLAN_ATTRIBUTE6 | ||
| PLAN_ATTRIBUTE7 | VARCHAR2 | 240 | PLAN_ATTRIBUTE7 | ||
| PLAN_ATTRIBUTE8 | VARCHAR2 | 240 | PLAN_ATTRIBUTE8 | ||
| PLAN_ATTRIBUTE9 | VARCHAR2 | 240 | PLAN_ATTRIBUTE9 | ||
| PLAN_ATTRIBUTE10 | VARCHAR2 | 240 | PLAN_ATTRIBUTE10 | ||
| PLAN_ATTRIBUTE11 | VARCHAR2 | 240 | PLAN_ATTRIBUTE11 | ||
| PLAN_ATTRIBUTE12 | VARCHAR2 | 240 | PLAN_ATTRIBUTE12 | ||
| PLAN_ATTRIBUTE13 | VARCHAR2 | 240 | PLAN_ATTRIBUTE13 | ||
| PM_ATTRIBUTE1 | VARCHAR2 | 240 | PM_ATTRIBUTE1 | ||
| PM_ATTRIBUTE2 | VARCHAR2 | 240 | PM_ATTRIBUTE2 | ||
| PM_ATTRIBUTE3 | VARCHAR2 | 240 | PM_ATTRIBUTE3 | ||
| PM_ATTRIBUTE4 | VARCHAR2 | 240 | PM_ATTRIBUTE4 | ||
| PM_ATTRIBUTE5 | VARCHAR2 | 240 | PM_ATTRIBUTE5 | ||
| PM_ATTRIBUTE6 | VARCHAR2 | 240 | PM_ATTRIBUTE6 | ||
| PM_ATTRIBUTE7 | VARCHAR2 | 240 | PM_ATTRIBUTE7 | ||
| PM_ATTRIBUTE8 | VARCHAR2 | 240 | PM_ATTRIBUTE8 | ||
| PM_ATTRIBUTE9 | VARCHAR2 | 240 | PM_ATTRIBUTE9 | ||
| PM_ATTRIBUTE10 | VARCHAR2 | 240 | PM_ATTRIBUTE10 | ||
| PM_ATTRIBUTE11 | VARCHAR2 | 240 | PM_ATTRIBUTE11 | ||
| PM_ATTRIBUTE12 | VARCHAR2 | 240 | PM_ATTRIBUTE12 | ||
| PM_ATTRIBUTE13 | VARCHAR2 | 240 | PM_ATTRIBUTE13 | ||
| PM_ATTRIBUTE14 | VARCHAR2 | 240 | PM_ATTRIBUTE14 |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JA_AU_EARNING_TRANSACTIONS_U1 | Unique | FUSION_TS_TX_DATA | MEASURE_RESULT_ID, REQUEST_ID, EARNING_ID |