[Home] [Help] [Dependency Information]
Object Name: | BEN_VSTG_SCHED_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_VSTG_SCHED_F |
Subobject Name: | |
Status: | VALID |
BEN_VSTG_SCHED_F identifies the progressive periods on which a person becomes vested in benefits. Vesting schedules may be applied to benefit accruals for retirement plans, employer contributions made to savings plans, and stock option grants. For example, stock options are 4-year graded at 25% per year and have a 5-year cliff.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_VSTG_SCHED_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
VSTG_SCHED_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_VSTG_SCHED_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_VSTG_SCHED_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORMULA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VSTG_SCHED_ID | NUMBER | (15) | Yes | System generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
PCT_VSTD_VAL | NUMBER | (15) | Yes | Percent vested. |
FORMULA_ID | NUMBER | (15) | Yes | Foreign key to FF_FORMULAS_F. |
BIS_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
LOS_DET_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. | |
VSC_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
VSC_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
VSC_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
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). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated primary key. Increments by one each update. | |
AGE_DET_RL | NUMBER | (15) | Foreign key to FF_FORMULAS_F. |
Cut, paste (and edit) the following text to query this object:
SELECT VSTG_SCHED_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, PCT_VSTD_VAL
, FORMULA_ID
, BIS_RL
, LOS_DET_RL
, VSC_ATTRIBUTE_CATEGORY
, VSC_ATTRIBUTE1
, VSC_ATTRIBUTE2
, VSC_ATTRIBUTE3
, VSC_ATTRIBUTE4
, VSC_ATTRIBUTE5
, VSC_ATTRIBUTE6
, VSC_ATTRIBUTE7
, VSC_ATTRIBUTE8
, VSC_ATTRIBUTE9
, VSC_ATTRIBUTE10
, VSC_ATTRIBUTE11
, VSC_ATTRIBUTE12
, VSC_ATTRIBUTE13
, VSC_ATTRIBUTE14
, VSC_ATTRIBUTE15
, VSC_ATTRIBUTE16
, VSC_ATTRIBUTE17
, VSC_ATTRIBUTE18
, VSC_ATTRIBUTE19
, VSC_ATTRIBUTE20
, VSC_ATTRIBUTE21
, VSC_ATTRIBUTE22
, VSC_ATTRIBUTE23
, VSC_ATTRIBUTE24
, VSC_ATTRIBUTE25
, VSC_ATTRIBUTE26
, VSC_ATTRIBUTE27
, VSC_ATTRIBUTE28
, VSC_ATTRIBUTE29
, VSC_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, AGE_DET_RL
FROM BEN.BEN_VSTG_SCHED_F;
BEN.BEN_VSTG_SCHED_F does not reference any database object
BEN.BEN_VSTG_SCHED_F is referenced by following:
|
|
|