[Home] [Help] [Dependency Information]
Object Name: | PSBBV_POSITION_FTE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBBV_POSITION_FTE |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSITION_FTE_LINE_ID | NUMBER | (20) | Yes | Position FTE line unique identifier |
POSITION_ID | NUMBER | (20) | Yes | Position Unique Identifier |
BUDGET_REVISION_ID | NUMBER | (20) | Budget revision unique identifier | |
BASE_LINE_VERSION | VARCHAR2 | (1) | Indicates if the values were originally posted in budget preparation phase or the current values from budget revisions. Valid values are 'O' - original and 'C' - current | |
START_DATE | DATE | Yes | Start date of the year for which the position FTE values are maintained | |
END_DATE | DATE | Yes | End date of the year for which the position FTE values are maintained | |
FTE | NUMBER | Yes | Position Control annual FTE value for the position |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_FTE_LINE_ID
, POSITION_ID
, BUDGET_REVISION_ID
, BASE_LINE_VERSION
, START_DATE
, END_DATE
, FTE
FROM APPS.PSBBV_POSITION_FTE;
APPS.PSBBV_POSITION_FTE is not referenced by any database object
|
|
|