[Home] [Help] [Dependency Information]
Object Name: | PER_PAY_PROPOSAL_COMPONENTS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PER_PAY_PROPOSAL_COMPONENTS |
Subobject Name: | |
Status: | VALID |
PER_PAY_PROPOSAL_COMPONENTS stores details of a salary proposal
component. The details of PER_PAY_PROPOSAL_COMPONENTS cannot be
updated or inserted if the overall proposal has already been approved.
A salary proposal may have one or multiple components associated with
it. If the proposal has multiple components, you can approve each
component separately, but you cannot approve the overall proposal
unless all components have been approved.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_PAY_PROPOSAL_COMPONENT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | COMPONENT_ID |
PER_PAY_PROPOSAL_COMPONENT_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PAY_PROPOSAL_ID
COMPONENT_REASON |
SYS_IL0000043525C00037$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
PER_PAY_PROPOSAL_COMPONENT_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAY_PROPOSAL_ID |
PER_PAY_PROPOSAL_COMPONENT_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Table | |
Foreign Table | Foreign Key Column | PER_PAY_PROPOSAL_COMPONENTS | HR_ALL_ORGANIZATION_UNITS | PER_PAY_PROPOSAL_COMPONENTS BUSINESS_GROUP_ID | PER_PAY_PROPOSAL_COMPONENTS | PER_PAY_PROPOSALS | PER_PAY_PROPOSAL_COMPONENTS PAY_PROPOSAL_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPONENT_ID | NUMBER | (15) | Yes | System-generated primary key column. |
PAY_PROPOSAL_ID | NUMBER | (15) | Yes | Foreign key to PER_PAY_PROPOSALS. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
APPROVED | VARCHAR2 | (30) | Yes | Flag indicating whether component has been approved or not. |
COMPONENT_REASON | VARCHAR2 | (30) | Yes | Reason/name of the component (same domain as for proposal reason). |
CHANGE_AMOUNT_N | NUMBER | The amount that the component changes the salary proposal. Replaces CHANGE_AMOUNT in 11.5 | ||
CHANGE_PERCENTAGE | NUMBER | (13) | Change percentage, to be applied to the last approved salary. | |
NEW_AMOUNT | NUMBER | (15) | No longer used and should be set to null. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield 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 version of row. Increments by one with each update. | |
CHANGE_AMOUNT | VARCHAR2 | (60) | Change amount, to be applied to the last approved salary. Replaced by change_amount_n in 11.5 | |
COMMENTS | CLOB | (4000) | General remark. |
Cut, paste (and edit) the following text to query this object:
SELECT COMPONENT_ID
, PAY_PROPOSAL_ID
, BUSINESS_GROUP_ID
, APPROVED
, COMPONENT_REASON
, CHANGE_AMOUNT_N
, CHANGE_PERCENTAGE
, NEW_AMOUNT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, CHANGE_AMOUNT
, COMMENTS
FROM HR.PER_PAY_PROPOSAL_COMPONENTS;
HR.PER_PAY_PROPOSAL_COMPONENTS does not reference any database object
HR.PER_PAY_PROPOSAL_COMPONENTS is referenced by following:
|
|
|