This table holds information about stock details
Module: Compensation
STOCK_DETAILS_ID
| 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.