[Home] [Help] [Dependency Information]
Object Name: | PSBFV_POSITION_PAY_DISTRS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_POSITION_PAY_DISTRS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
PSBFV_POSITION_PAY_DISTRS displays all position salary distributions.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_EFFECTIVE_DATE | DATE | Yes | Effective start date | |
END_EFFECTIVE_DATE | DATE | Effective end date | ||
_KF:POSITION_NAME | CHAR | (20) | Position name. Concatenated position Key Flexfield segments. | |
_KF:GL_ACCOUNT | CHAR | (17) | General Ledger account. Concatenated accounting Key Flexfield segments. | |
DESCRIPTION | VARCHAR2 | (365) | Grants Management charging instructions | |
SALARY_DISTRIBUTION_PERCENT | NUMBER | Yes | Salary distribution percent | |
DISTRIBUTION_ID | NUMBER | (20) | Yes | Distribution unique identifier |
POSITION_ID | NUMBER | (20) | Yes | Position unique identifier |
CODE_COMBINATION_ID | NUMBER | (20) | Code combination unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT START_EFFECTIVE_DATE
, END_EFFECTIVE_DATE
, _KF:POSITION_NAME
, _KF:GL_ACCOUNT
, DESCRIPTION
, SALARY_DISTRIBUTION_PERCENT
, DISTRIBUTION_ID
, POSITION_ID
, CODE_COMBINATION_ID
FROM APPS.PSBFV_POSITION_PAY_DISTRS;
APPS.PSBFV_POSITION_PAY_DISTRS is not referenced by any database object
|
|
|