Oracle Fusion · Data dictionary
CMP_STOCK_DETAILS
CompensationUsed in 0 subject areas47 reporting columnsBICC incremental-ready
Compensation (CMP) — detail-level data.
Likely primary key: STOCK_DETAILS_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| CANCELLATION_DATE | ● | Cancellation date. | |
| CANCELLED_SHARES | ● | Cancelled shares. | |
| CLASS_TYPE | ● | Type of class. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| ELEMENT_ENTRY_ID | ● | Identifier for the element entry. | |
| EXERCISABLE_SHARES | ● | Exercisable shares. | |
| EXERCISED_SHARES | ● | Exercised shares. | |
| EXERCISE_DATE | ● | Exercise date. | |
| EXERCISE_PRICE | ● | Exercise price. | |
| EXPIRATION_DATE | ● | Expiration date. | |
| GRANT_ID | ● | Identifier for the grant. | |
| GRANT_NAME | ● | Name of the grant. | |
| GRANT_NUMBER | ● | Grant number. | |
| GRANT_TYPE | ● | Type of grant. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| MISC | ● | Misc. | |
| MISC1_CHAR | ● | Misc1 char. | |
| MISC1_VAL | ● | Misc1 val. | |
| MISC2_CHAR | ● | Misc2 char. | |
| MISC2_VAL | ● | Misc2 val. | |
| MISC3_CHAR | ● | Misc3 char. | |
| MISC3_VAL | ● | Misc3 val. | |
| MISC4_CHAR | ● | Misc4 char. | |
| MISC4_VAL | ● | Misc4 val. | |
| MISC5_CHAR | ● | Misc5 char. | |
| MISC5_VAL | ● | Misc5 val. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| ORIGINAL_GRANT_DATE | ● | Original grant date. | |
| ORIGINAL_GRANT_PRICE | ● | Original grant price. | |
| ORIGINAL_SHARES_GRANTED | ● | Original shares granted. | |
| ORIGINAL_VALUE_AT_GRANT | ● | Original value at grant. | |
| PERSON_EVENT_ID | ● | Identifier for the person event. | |
| PERSON_ID | ● | Identifier for the person. | |
| REASON_CODE | ● | Code identifying the reason. | |
| STOCK_DETAILS_ID | PK? | ● | Identifier for the stock details. |
| TOTAL_SHARES | ● | Total shares. | |
| TRADING_SYMBOL | ● | Trading symbol. | |
| UNVESTED_SHARES | ● | Unvested shares. | |
| VESTED_SHARES | ● | Vested shares. | |
| VEST_DATE | ● | Vest date. | |
| WORKER_NUMBER | ● | Worker number. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Subject areas
- —
Need the extract + dbt staging for CMP_STOCK_DETAILS?
We ship parameterized SQL, BICC config, and dbt models you own.