[Home] [Help] [Dependency Information]
Object Name: | BEN_PY_BSS_RT_F |
---|---|
Object Type: | TABLE |
Owner: | BEN |
FND Design Data: | BEN.BEN_PY_BSS_RT_F |
Subobject Name: | |
Status: | VALID |
BEN_PY_BSS_RT_F identifies the pay basis or salary basis, based on the pay basis on the person's assignment, that makes the rates applicable to that person (most typical usage) or make the person excluded from (least typical) rates defined by the associated variable rate profile.
.
BEN_PY_BSS_RT_F is the intersection of BEN_VRBL_RT_PRFL_F and PER_PAY_BASES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BEN_PY_BSS_RT_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PY_BSS_RT_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
BEN_PY_BSS_RT_F_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAY_BASIS_ID |
BEN_PY_BSS_RT_F_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
BEN_PY_BSS_RT_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VRBL_RT_PRFL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PY_BSS_RT_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. | |
EXCLD_FLAG | VARCHAR2 | (30) | Yes | Exclude Y or N. |
ORDR_NUM | NUMBER | (15) | Yes | Order number. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
VRBL_RT_PRFL_ID | NUMBER | (15) | Foreign key to BEN_VRBL_RT_PRFL_F | |
PBR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
PBR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive Flexfield segment column. | |
PBR_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. | |
PAY_BASIS_ID | NUMBER | (15) | System generated primary key column. |
Cut, paste (and edit) the following text to query this object:
SELECT PY_BSS_RT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, EXCLD_FLAG
, ORDR_NUM
, BUSINESS_GROUP_ID
, VRBL_RT_PRFL_ID
, PBR_ATTRIBUTE_CATEGORY
, PBR_ATTRIBUTE1
, PBR_ATTRIBUTE2
, PBR_ATTRIBUTE3
, PBR_ATTRIBUTE4
, PBR_ATTRIBUTE5
, PBR_ATTRIBUTE6
, PBR_ATTRIBUTE7
, PBR_ATTRIBUTE8
, PBR_ATTRIBUTE9
, PBR_ATTRIBUTE10
, PBR_ATTRIBUTE11
, PBR_ATTRIBUTE12
, PBR_ATTRIBUTE13
, PBR_ATTRIBUTE14
, PBR_ATTRIBUTE15
, PBR_ATTRIBUTE16
, PBR_ATTRIBUTE17
, PBR_ATTRIBUTE18
, PBR_ATTRIBUTE19
, PBR_ATTRIBUTE20
, PBR_ATTRIBUTE21
, PBR_ATTRIBUTE22
, PBR_ATTRIBUTE23
, PBR_ATTRIBUTE24
, PBR_ATTRIBUTE25
, PBR_ATTRIBUTE26
, PBR_ATTRIBUTE27
, PBR_ATTRIBUTE28
, PBR_ATTRIBUTE29
, PBR_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, PAY_BASIS_ID
FROM BEN.BEN_PY_BSS_RT_F;
BEN.BEN_PY_BSS_RT_F does not reference any database object
BEN.BEN_PY_BSS_RT_F is referenced by following:
|
|
|