[Home] [Help] [Dependency Information]
Object Name: | BEN_CWB_STOCK_OPTN_DTLS |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_CWB_STOCK_OPTN_DTLS |
Subobject Name: | |
Status: | VALID |
BEN_CWB_STOCK_OPTN_DTLS is loaded with data from 3rd party stock option administrators.
The data contained can be configure to display in the Compensation Workbench History and the Compensation Workbench Stock Option Total Position Report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_CWB_STOCK_OPTN_DTLS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERSON_ID |
BEN_CWB_STOCK_OPTN_DTLS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRTT_RT_VAL_ID |
BEN_CWB_STOCK_OPTN_DTLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BUSINESS_GROUP_ID
EMPLOYEE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CWB_STOCK_OPTN_DTLS_ID | NUMBER | (15) | Yes | System Generated primary Key. |
GRANT_ID | NUMBER | (15) | Column for identifying a grant. | |
GRANT_NUMBER | VARCHAR2 | (30) | User specified number for a grant. | |
GRANT_NAME | VARCHAR2 | (100) | Name of the grant. | |
GRANT_TYPE | VARCHAR2 | (30) | Type of the grant. | |
GRANT_DATE | DATE | Date of giving the grant. | ||
GRANT_SHARES | NUMBER | Number of options granted. | ||
GRANT_PRICE | NUMBER | Grant price of the shares. | ||
VALUE_AT_GRANT | NUMBER | Value of the stock shares granted. | ||
CURRENT_SHARE_PRICE | NUMBER | Price of the current option. | ||
CURRENT_SHARES_OUTSTANDING | NUMBER | Price of the current option. | ||
VESTED_SHARES | NUMBER | Number of vested options. | ||
UNVESTED_SHARES | NUMBER | Number of unvested options. | ||
EXERCISABLE_SHARES | NUMBER | Number of options which can be exercised. | ||
EXERCISED_SHARES | NUMBER | Options exercised. | ||
CANCELLED_SHARES | NUMBER | Number of options cancelled. | ||
TRADING_SYMBOL | VARCHAR2 | (30) | Symbol in which the stock is traded. | |
EXPIRATION_DATE | DATE | Expiration Date. | ||
REASON_CODE | VARCHAR2 | (30) | Reason code for the grant. | |
CLASS | VARCHAR2 | (30) | Class. | |
MISC | VARCHAR2 | (100) | For any miscellaneous entries. | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee Number assigned to the person. | |
PERSON_ID | NUMBER | (15) | Foreign Key to PER_PEOPLE_F. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
PRTT_RT_VAL_ID | NUMBER | (15) | Participant Rate Val Id of the person. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CSO_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flex field column. | |
CSO_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flex field attribute. | |
CSO_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flex field attribute. |
Cut, paste (and edit) the following text to query this object:
SELECT CWB_STOCK_OPTN_DTLS_ID
, GRANT_ID
, GRANT_NUMBER
, GRANT_NAME
, GRANT_TYPE
, GRANT_DATE
, GRANT_SHARES
, GRANT_PRICE
, VALUE_AT_GRANT
, CURRENT_SHARE_PRICE
, CURRENT_SHARES_OUTSTANDING
, VESTED_SHARES
, UNVESTED_SHARES
, EXERCISABLE_SHARES
, EXERCISED_SHARES
, CANCELLED_SHARES
, TRADING_SYMBOL
, EXPIRATION_DATE
, REASON_CODE
, CLASS
, MISC
, EMPLOYEE_NUMBER
, PERSON_ID
, BUSINESS_GROUP_ID
, PRTT_RT_VAL_ID
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CSO_ATTRIBUTE_CATEGORY
, CSO_ATTRIBUTE1
, CSO_ATTRIBUTE2
, CSO_ATTRIBUTE3
, CSO_ATTRIBUTE4
, CSO_ATTRIBUTE5
, CSO_ATTRIBUTE6
, CSO_ATTRIBUTE7
, CSO_ATTRIBUTE8
, CSO_ATTRIBUTE9
, CSO_ATTRIBUTE10
, CSO_ATTRIBUTE11
, CSO_ATTRIBUTE12
, CSO_ATTRIBUTE13
, CSO_ATTRIBUTE14
, CSO_ATTRIBUTE15
, CSO_ATTRIBUTE16
, CSO_ATTRIBUTE17
, CSO_ATTRIBUTE18
, CSO_ATTRIBUTE19
, CSO_ATTRIBUTE20
, CSO_ATTRIBUTE21
, CSO_ATTRIBUTE22
, CSO_ATTRIBUTE23
, CSO_ATTRIBUTE24
, CSO_ATTRIBUTE25
, CSO_ATTRIBUTE26
, CSO_ATTRIBUTE27
, CSO_ATTRIBUTE28
, CSO_ATTRIBUTE29
, CSO_ATTRIBUTE30
FROM BEN.BEN_CWB_STOCK_OPTN_DTLS;
BEN.BEN_CWB_STOCK_OPTN_DTLS does not reference any database object
BEN.BEN_CWB_STOCK_OPTN_DTLS is referenced by following:
|
|
|