[Home] [Help] [Dependency Information]
Object Name: | BEN_POPL_RPTG_GRP_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_POPL_RPTG_GRP_F |
Subobject Name: | |
Status: | VALID |
BEN_POPL_RPTG_GRP_F establishes affinity between a program or plan and a reporting group. Plans and programs are grouped together for a number of reasons ,more importantly, however, the plan sponsor may have to group plans or programs in order to identify that they are, in essence, the same thing.This is necessary in those cases when for plan design purposes, the user must create multiple plan records for the same underlying plan.
For example, they are reported together as a group for regulatory purposes, their financial statements are combined, the participants are reported against as a group.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_POPL_RPTG_GRP_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
POPL_RPTG_GRP_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_POPL_RPTG_GRP_F_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_POPL_RPTG_GRP_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RPTG_GRP_ID |
BEN_POPL_RPTG_GRP_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PGM_ID |
BEN_POPL_RPTG_GRP_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POPL_RPTG_GRP_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 |
RPTG_GRP_ID | NUMBER | (15) | Foreign key to BEN_RPTG_GRP. | |
PGM_ID | NUMBER | (15) | Foreign key to BEN_PGM_F. | |
PL_ID | NUMBER | (15) | Foreign Key to BEN_PL_F. | |
RGR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
RGR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
RGR_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. | |
ORDR_NUM | NUMBER | (15) | Order Number |
Cut, paste (and edit) the following text to query this object:
SELECT POPL_RPTG_GRP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, RPTG_GRP_ID
, PGM_ID
, PL_ID
, RGR_ATTRIBUTE_CATEGORY
, RGR_ATTRIBUTE1
, RGR_ATTRIBUTE2
, RGR_ATTRIBUTE3
, RGR_ATTRIBUTE4
, RGR_ATTRIBUTE5
, RGR_ATTRIBUTE6
, RGR_ATTRIBUTE7
, RGR_ATTRIBUTE8
, RGR_ATTRIBUTE9
, RGR_ATTRIBUTE10
, RGR_ATTRIBUTE11
, RGR_ATTRIBUTE12
, RGR_ATTRIBUTE13
, RGR_ATTRIBUTE14
, RGR_ATTRIBUTE15
, RGR_ATTRIBUTE16
, RGR_ATTRIBUTE17
, RGR_ATTRIBUTE18
, RGR_ATTRIBUTE19
, RGR_ATTRIBUTE20
, RGR_ATTRIBUTE21
, RGR_ATTRIBUTE22
, RGR_ATTRIBUTE23
, RGR_ATTRIBUTE24
, RGR_ATTRIBUTE25
, RGR_ATTRIBUTE26
, RGR_ATTRIBUTE27
, RGR_ATTRIBUTE28
, RGR_ATTRIBUTE29
, RGR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, ORDR_NUM
FROM BEN.BEN_POPL_RPTG_GRP_F;
BEN.BEN_POPL_RPTG_GRP_F does not reference any database object
BEN.BEN_POPL_RPTG_GRP_F is referenced by following:
|
|
|