CMP_TCS_STOCK_HISTORY_TL

Stores translatable information of CMP_TCS_STOCK_HISTORY

Details

  • Schema: FUSION

  • Object owner: CMP

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMP_TCS_STKHIST_TL_PK

STOCK_HISTORY_ID, LANGUAGE, BUSINESS_GROUP_ID, PERD_RUN_ID

Columns

Name Datatype Length Precision Not-null Comments
STOCK_HISTORY_ID NUMBER 18 Yes STOCK_HISTORY_ID
PERD_RUN_ID NUMBER 18 Yes PERD_RUN_ID
GRANT_DATE_LABEL VARCHAR2 240 GRANT_DATE_LABEL
STOCK_SYMBOL_LABEL VARCHAR2 240 STOCK_SYMBOL_LABEL
GRANT_NUMBER_LABEL VARCHAR2 240 GRANT_NUMBER_LABEL
GRANT_NAME_LABEL VARCHAR2 240 GRANT_NAME_LABEL
GRANT_TYPE_LABEL VARCHAR2 240 GRANT_TYPE_LABEL
TOTAL_SHRS_LABEL VARCHAR2 240 TOTAL_SHRS_LABEL
SHRS_GRANTED_LABEL VARCHAR2 240 SHRS_GRANTED_LABEL
XRCISE_PRICE_LABEL VARCHAR2 240 XRCISE_PRICE_LABEL
GRANT_PRICE_LABEL VARCHAR2 240 GRANT_PRICE_LABEL
GRANT_VALUE_LABEL VARCHAR2 240 GRANT_VALUE_LABEL
CANCELLED_SHRS_LABEL VARCHAR2 240 CANCELLED_SHRS_LABEL
REASON_CODE_LABEL VARCHAR2 240 REASON_CODE_LABEL
CLASS_TYPE_LABEL VARCHAR2 240 CLASS_TYPE_LABEL
EST_MKT_VAL_LABEL VARCHAR2 240 EST_MKT_VAL_LABEL
MISC_LABEL VARCHAR2 240 MISC_LABEL
EST_VALUE_LABEL VARCHAR2 240 EST_VALUE_LABEL
VST_EST_UNEX_MKT_VAL_LABEL VARCHAR2 240 VST_EST_UNEX_MKT_VAL_LABEL
VST_SHRS_LABEL VARCHAR2 240 VST_SHRS_LABEL
VST_EX_LABEL VARCHAR2 240 VST_EX_LABEL
VST_UNEX_LABEL VARCHAR2 240 VST_UNEX_LABEL
VST_EST_VAL_LABEL VARCHAR2 240 VST_EST_VAL_LABEL
VST_EST_MKT_VAL_LABEL VARCHAR2 240 VST_EST_MKT_VAL_LABEL
VST_EST_UNEX_VAL_LABEL VARCHAR2 240 VST_EST_UNEX_VAL_LABEL
UNVST_SHRS_LABEL VARCHAR2 240 UNVST_SHRS_LABEL
UNVST_EST_VAL_LABEL VARCHAR2 240 UNVST_EST_VAL_LABEL
UNVST_EST_MKT_VAL_LABEL VARCHAR2 240 UNVST_EST_MKT_VAL_LABEL
EXPIRE_DATE_LABEL VARCHAR2 240 EXPIRE_DATE_LABEL
VEST_DATE_LABEL VARCHAR2 240 Label for Vest Date column
EXERCISE_DATE_LABEL VARCHAR2 240 Label for Exercise Date column
CANCEL_DATE_LABEL VARCHAR2 240 Label for Calcellation Date column
MISC1_LABEL VARCHAR2 240 Label for Miscellaneous Text 1 column
MISC2_LABEL VARCHAR2 240 Label for Miscellaneous Text 2 column
MISC3_LABEL VARCHAR2 240 Label for Miscellaneous Text 3 column
MISC4_LABEL VARCHAR2 240 Label for Miscellaneous Text 4 column
MISC5_LABEL VARCHAR2 240 Label for Miscellaneous Text 5 column
MISC_NUM1_LABEL VARCHAR2 240 Label for Miscellaneous Number 1 column
MISC_NUM2_LABEL VARCHAR2 240 Label for Miscellaneous Number 2 column
MISC_NUM3_LABEL VARCHAR2 240 Label for Miscellaneous Number 3 column
MISC_NUM4_LABEL VARCHAR2 240 Label for Miscellaneous Number 4 column
MISC_NUM5_LABEL VARCHAR2 240 Label for Miscellaneous Number 5 column
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
BUSINESS_GROUP_ID NUMBER 18 Yes BUSINESS_GROUP_ID

Indexes

Index Uniqueness Tablespace Columns
CMP_TCS_STKHIST_TL_UK1 Unique FUSION_TS_TX_DATA STOCK_HISTORY_ID, LANGUAGE, BUSINESS_GROUP_ID, PERD_RUN_ID