[Home] [Help] [Dependency Information]
Object Name: | BEN_ACTN_TYP |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_ACTN_TYP |
Subobject Name: | |
Status: | VALID |
BEN_ACTN_TYP is an action required to complete enrollment, either for enrollment results or enrollment events. It includes Requirement to Designate Beneficiary, Designate Dependent Provide Proof of Good Health, Obtain Third Party Administrator Approval.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_ACTN_TYP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACTN_TYP_ID |
BEN_ACTN_TYP_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTN_TYP_ID | NUMBER | (15) | Yes | System generated primary key column. |
NAME | VARCHAR2 | (240) | Yes | Name of the action item type. |
DESCRIPTION | VARCHAR2 | (600) | Yes | Description. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
TYPE_CD | VARCHAR2 | (30) | Yes | Action item type. |
EAT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
EAT_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
EAT_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. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTN_TYP_ID
, NAME
, DESCRIPTION
, BUSINESS_GROUP_ID
, TYPE_CD
, EAT_ATTRIBUTE_CATEGORY
, EAT_ATTRIBUTE1
, EAT_ATTRIBUTE2
, EAT_ATTRIBUTE3
, EAT_ATTRIBUTE4
, EAT_ATTRIBUTE5
, EAT_ATTRIBUTE6
, EAT_ATTRIBUTE7
, EAT_ATTRIBUTE8
, EAT_ATTRIBUTE9
, EAT_ATTRIBUTE10
, EAT_ATTRIBUTE11
, EAT_ATTRIBUTE12
, EAT_ATTRIBUTE13
, EAT_ATTRIBUTE14
, EAT_ATTRIBUTE15
, EAT_ATTRIBUTE16
, EAT_ATTRIBUTE17
, EAT_ATTRIBUTE18
, EAT_ATTRIBUTE19
, EAT_ATTRIBUTE20
, EAT_ATTRIBUTE21
, EAT_ATTRIBUTE22
, EAT_ATTRIBUTE23
, EAT_ATTRIBUTE24
, EAT_ATTRIBUTE25
, EAT_ATTRIBUTE26
, EAT_ATTRIBUTE27
, EAT_ATTRIBUTE28
, EAT_ATTRIBUTE29
, EAT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN.BEN_ACTN_TYP;
BEN.BEN_ACTN_TYP does not reference any database object
BEN.BEN_ACTN_TYP is referenced by following:
|
|
|