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