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