[Home] [Help] [Dependency Information]
Object Name: | BEN_PL_TYP_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PL_TYP_F |
Subobject Name: | |
Status: | VALID |
BEN_PL_TYP_F categorizes plans according to the type of compensation benefit provided. A plan can have only one plan type associated with it.
For example, Flex, Medical, Dental, Vision, Employee Group Life Insurance, Disability, Savings, Health Care Flexible Spending Account or dependent Care Flexible Spending Account.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PL_TYP_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PL_TYP_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PL_TYP_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PL_TYP_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PL_TYP_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. | |
NAME | VARCHAR2 | (240) | Yes | Name of the plan type. |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
NO_MX_ENRL_NUM_DFND_FLAG | VARCHAR2 | (30) | Yes | No Maximum Enroll Number Defined Y or N. |
NO_MN_ENRL_NUM_DFND_FLAG | VARCHAR2 | (30) | Yes | No Minimum Enroll Number Defined Y or N. |
OPT_DSPLY_FMT_CD | VARCHAR2 | (30) | Option display format. | |
COMP_TYP_CD | VARCHAR2 | (30) | Compensation type. | |
PTP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PTP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PTP_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. | |
MX_ENRL_ALWD_NUM | NUMBER | (15) | Maximum enrollment allowed in the plan type. | |
MN_ENRL_RQD_NUM | NUMBER | (15) | Minimum enrollment required in the plan type. | |
PL_TYP_STAT_CD | VARCHAR2 | (30) | Plan type status. | |
OPT_TYP_CD | VARCHAR2 | (30) | Option type. | |
IVR_IDENT | VARCHAR2 | (90) | Interactive Voice Response identifier. | |
SHORT_CODE | VARCHAR2 | (30) | Short Code | |
SHORT_NAME | VARCHAR2 | (30) | short Name | |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign key to FND_TERRITORIES. | |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Further identifies the legislation of startup data. |
Cut, paste (and edit) the following text to query this object:
SELECT PL_TYP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, NAME
, BUSINESS_GROUP_ID
, NO_MX_ENRL_NUM_DFND_FLAG
, NO_MN_ENRL_NUM_DFND_FLAG
, OPT_DSPLY_FMT_CD
, COMP_TYP_CD
, PTP_ATTRIBUTE_CATEGORY
, PTP_ATTRIBUTE1
, PTP_ATTRIBUTE2
, PTP_ATTRIBUTE3
, PTP_ATTRIBUTE4
, PTP_ATTRIBUTE5
, PTP_ATTRIBUTE6
, PTP_ATTRIBUTE7
, PTP_ATTRIBUTE8
, PTP_ATTRIBUTE9
, PTP_ATTRIBUTE10
, PTP_ATTRIBUTE11
, PTP_ATTRIBUTE12
, PTP_ATTRIBUTE13
, PTP_ATTRIBUTE14
, PTP_ATTRIBUTE15
, PTP_ATTRIBUTE16
, PTP_ATTRIBUTE17
, PTP_ATTRIBUTE18
, PTP_ATTRIBUTE19
, PTP_ATTRIBUTE20
, PTP_ATTRIBUTE21
, PTP_ATTRIBUTE22
, PTP_ATTRIBUTE23
, PTP_ATTRIBUTE24
, PTP_ATTRIBUTE25
, PTP_ATTRIBUTE26
, PTP_ATTRIBUTE27
, PTP_ATTRIBUTE28
, PTP_ATTRIBUTE29
, PTP_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, MX_ENRL_ALWD_NUM
, MN_ENRL_RQD_NUM
, PL_TYP_STAT_CD
, OPT_TYP_CD
, IVR_IDENT
, SHORT_CODE
, SHORT_NAME
, LEGISLATION_CODE
, LEGISLATION_SUBGROUP
FROM BEN.BEN_PL_TYP_F;
BEN.BEN_PL_TYP_F does not reference any database object
BEN.BEN_PL_TYP_F is referenced by following:
|
|
|