# DW_CMP_STOCK_DETAIL_F

This table holds information about stock details

## Details

Module: Compensation

## Key Columns

STOCK_DETAILS_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
STOCK_DETAILS_ID | NUMBER | 38 | 0 | True | Stock Detail Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Primary Key consisting of Stock Details identifier |  |
GRANT_ID | VARCHAR2 | 32 |  |  | GRANT_ID |  |
PERSON_EVENT_ID | NUMBER | 38 | 0 |  | PERSON_EVENT_ID | DW_CMP_CWB_PERSON_INFO_D | PERSON_EVENT_ID
PERSON_ID | NUMBER | 38 | 0 |  | PERSON_ID | DW_PERSON_D | PERSON_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | ASSIGNMENT_ID |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | BUSINESS_GROUP_ID |  |
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | LEGAL_EMPLOYER_ID | DW_ORGANIZATION_CF_DH | ORGANIZATION_ID
REASON_CODE | VARCHAR2 | 32 |  |  | REASON_CODE |  |
CLASS_TYPE | VARCHAR2 | 32 |  |  | CLASS_TYPE |  |
MISC | VARCHAR2 | 128 |  |  | CLASS_TYPE |  |
WORKER_NUMBER | VARCHAR2 | 64 |  |  | WORKER_NUMBER |  |
TRADING_SYMBOL | VARCHAR2 | 32 |  |  | TRADING_SYMBOL |  |
GRANT_NUMBER | VARCHAR2 | 32 |  |  | GRANT_NUMBER |  |
GRANT_NAME | VARCHAR2 | 128 |  |  | GRANT_NAME |  |
GRANT_TYPE | VARCHAR2 | 32 |  |  | GRANT_TYPE |  |
ORIGINAL_GRANT_DATE | DATE |  |  |  | ORIGINAL_GRANT_DATE |  |
ORIGINAL_SHARES_GRANTED | NUMBER |  |  |  | ORIGINAL_SHARES_GRANTED |  |
ORIGINAL_GRANT_PRICE | NUMBER |  |  |  | ORIGINAL_GRANT_PRICE |  |
ORIGINAL_VALUE_AT_GRANT | NUMBER |  |  |  | ORIGINAL_VALUE_AT_GRANT |  |
EXERCISE_PRICE | NUMBER |  |  |  | EXERCISE_PRICE |  |
TOTAL_SHARES | NUMBER |  |  |  | TOTAL_SHARES |  |
VESTED_SHARES | NUMBER |  |  |  | VESTED_SHARES |  |
UNVESTED_SHARES | NUMBER |  |  |  | UNVESTED_SHARES |  |
EXERCISABLE_SHARES | NUMBER |  |  |  | EXERCISABLE_SHARES |  |
EXERCISED_SHARES | NUMBER |  |  |  | EXERCISED_SHARES |  |
CANCELLED_SHARES | NUMBER |  |  |  | CANCELLED_SHARES |  |
EXPIRATION_DATE | DATE |  |  |  | EXPIRATION_DATE |  |
ESTIMATED_STOCK_PRICE | NUMBER |  |  |  | ESTIMATED_STOCK_PRICE |  |
STOCK_PRICE_CURRENCY_CD | VARCHAR2 | 32 |  |  | STOCK_PRICE_CURRENCY_CD |  |
CREATION_DATE | TIMESTAMP |  |  |  | creation date |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.