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 |