[Home] [Help] [Dependency Information]
Object Name: | PSB_POSITION_FTE |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_POSITION_FTE |
Subobject Name: | |
Status: | VALID |
PSB_POSITION_FTE stores the position control full-time equivalency information with the baseline values from budget revisions. This is an interface table for position control into which position full-time equivalency values are populated before posting to any position control system.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_POSITION_FTE_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | POSITION_FTE_LINE_ID |
PSB_POSITION_FTE_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | POSITION_ID |
PSB_POSITION_FTE_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | BUDGET_REVISION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSITION_FTE_LINE_ID | NUMBER | (20) | Yes | Position full-time equivalency line unique identifier |
POSITION_ID | NUMBER | (20) | Yes | Position unique identifier |
START_DATE | DATE | Yes | Start date for which the position full-time equivalency values are maintained | |
END_DATE | DATE | Yes | End date for which the position full-time equivalency values are maintained | |
FTE | NUMBER | Yes | Position control full-time equivalency value for the position | |
BUDGET_REVISION_ID | NUMBER | (20) | Budget revision unique identifier | |
BASE_LINE_VERSION | VARCHAR2 | (1) | Base line version is O (Original Values from Budget Preparation) or C (Current Values from Position Control). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
HR_POSITION_ID | NUMBER | (20) | Unique identifier for position in source Human Resource Management System | |
HR_BUDGET_ID | NUMBER | (20) | Unique identifier for budget in source Human Resource Management System | |
TRANSFER_TO_PC_FLAG | VARCHAR2 | (1) | Flag indicating whether record has been posted to position control or not |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_FTE_LINE_ID
, POSITION_ID
, START_DATE
, END_DATE
, FTE
, BUDGET_REVISION_ID
, BASE_LINE_VERSION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, HR_POSITION_ID
, HR_BUDGET_ID
, TRANSFER_TO_PC_FLAG
FROM PSB.PSB_POSITION_FTE;
PSB.PSB_POSITION_FTE does not reference any database object
PSB.PSB_POSITION_FTE is referenced by following:
|
|
|