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, 2024, Oracle and/or its affiliates.