[Home] [Help] [Dependency Information]
Object Name: | BEN_PL_REGY_BOD_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PL_REGY_BOD_F |
Subobject Name: | |
Status: | VALID |
BEN_PL_REGY_BOD_F identifies a legislative or policy making agency which dictates or enforces rules for this plan or reporting group. In the United States, for example, the Internal Revenue Service regulates most health and welfare plans.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PL_REGY_BOD_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PL_REGY_BOD_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PL_REGY_BOD_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RPTG_GRP_ID |
BEN_PL_REGY_BOD_F_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORGANIZATION_ID |
BEN_PL_REGY_BOD_F_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PL_REGY_BOD_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PL_REGY_BOD_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 |
QUALD_FLAG | VARCHAR2 | (30) | Yes | Qualified Y or N. |
REGY_PL_NAME | VARCHAR2 | (240) | Regulatory plan name. | |
APRVD_TRMN_DT | DATE | Approved termination date. | ||
RPTG_GRP_ID | NUMBER | (15) | Foreign key to BEN_RPTG_GRP. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
PRB_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PRB_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PRB_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. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
QUALD_DT | DATE | Qualified date. |
Cut, paste (and edit) the following text to query this object:
SELECT PL_REGY_BOD_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, QUALD_FLAG
, REGY_PL_NAME
, APRVD_TRMN_DT
, RPTG_GRP_ID
, PL_ID
, PRB_ATTRIBUTE_CATEGORY
, PRB_ATTRIBUTE1
, PRB_ATTRIBUTE2
, PRB_ATTRIBUTE3
, PRB_ATTRIBUTE4
, PRB_ATTRIBUTE5
, PRB_ATTRIBUTE6
, PRB_ATTRIBUTE7
, PRB_ATTRIBUTE8
, PRB_ATTRIBUTE9
, PRB_ATTRIBUTE10
, PRB_ATTRIBUTE11
, PRB_ATTRIBUTE12
, PRB_ATTRIBUTE13
, PRB_ATTRIBUTE14
, PRB_ATTRIBUTE15
, PRB_ATTRIBUTE16
, PRB_ATTRIBUTE17
, PRB_ATTRIBUTE18
, PRB_ATTRIBUTE19
, PRB_ATTRIBUTE20
, PRB_ATTRIBUTE21
, PRB_ATTRIBUTE22
, PRB_ATTRIBUTE23
, PRB_ATTRIBUTE24
, PRB_ATTRIBUTE25
, PRB_ATTRIBUTE26
, PRB_ATTRIBUTE27
, PRB_ATTRIBUTE28
, PRB_ATTRIBUTE29
, PRB_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ORGANIZATION_ID
, QUALD_DT
FROM BEN.BEN_PL_REGY_BOD_F;
BEN.BEN_PL_REGY_BOD_F does not reference any database object
BEN.BEN_PL_REGY_BOD_F is referenced by following:
|
|
|