DBA Data[Home] [Help] [Dependency Information]

TABLE: PSB.PSB_WS_FTE_LINES

Object Details
Object Name: PSB_WS_FTE_LINES
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_WS_FTE_LINES
Subobject Name:
Status: VALID


PSB_WS_FTE_LINES stores the full-time equivalency values for a
position line by budget periods.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_WS_FTE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFTE_LINE_ID
PSB_WS_FTE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_LINE_ID
PSB_WS_FTE_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_YEAR_ID
ColumnSTAGE_SET_ID
Columns
Name Datatype Length Mandatory Comments
FTE_LINE_ID NUMBER
Yes Full-time equivalency line unique identifier
POSITION_LINE_ID NUMBER
Yes Position instance identifier
BUDGET_YEAR_ID NUMBER
Yes Budget year unique identifier. The budget year for which this full time equivalency line is assigned.
ANNUAL_FTE NUMBER
Yes Computed annual full-time equivalency value
SERVICE_PACKAGE_ID NUMBER
Yes Service package unique identifier
STAGE_SET_ID NUMBER
Yes Stage set unique identifier
START_STAGE_SEQ NUMBER
Yes Start stage sequence
CURRENT_STAGE_SEQ NUMBER
Yes Current stage sequence
END_STAGE_SEQ NUMBER

End stage sequence
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
PERIOD1_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD2_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD3_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD4_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD5_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD6_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD7_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD8_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD9_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD10_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD11_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD12_FTE NUMBER

Full-time equivalency for periods in a budget year
PERIOD13_FTE NUMBER

For future use
PERIOD14_FTE NUMBER

For future use
PERIOD15_FTE NUMBER

For future use
PERIOD16_FTE NUMBER

For future use
PERIOD17_FTE NUMBER

For future use
PERIOD18_FTE NUMBER

For future use
PERIOD19_FTE NUMBER

For future use
PERIOD20_FTE NUMBER

For future use
PERIOD21_FTE NUMBER

For future use
PERIOD22_FTE NUMBER

For future use
PERIOD23_FTE NUMBER

For future use
PERIOD24_FTE NUMBER

For future use
PERIOD25_FTE NUMBER

For future use
PERIOD26_FTE NUMBER

For future use
PERIOD27_FTE NUMBER

For future use
PERIOD28_FTE NUMBER

For future use
PERIOD29_FTE NUMBER

For future use
PERIOD30_FTE NUMBER

For future use
PERIOD31_FTE NUMBER

For future use
PERIOD32_FTE NUMBER

For future use
PERIOD33_FTE NUMBER

For future use
PERIOD34_FTE NUMBER

For future use
PERIOD35_FTE NUMBER

For future use
PERIOD36_FTE NUMBER

For future use
PERIOD37_FTE NUMBER

For future use
PERIOD38_FTE NUMBER

For future use
PERIOD39_FTE NUMBER

For future use
PERIOD40_FTE NUMBER

For future use
PERIOD41_FTE NUMBER

For future use
PERIOD42_FTE NUMBER

For future use
PERIOD43_FTE NUMBER

For future use
PERIOD44_FTE NUMBER

For future use
PERIOD45_FTE NUMBER

For future use
PERIOD46_FTE NUMBER

For future use
PERIOD47_FTE NUMBER

For future use
PERIOD48_FTE NUMBER

For future use
PERIOD49_FTE NUMBER

For future use
PERIOD50_FTE NUMBER

For future use
PERIOD51_FTE NUMBER

For future use
PERIOD52_FTE NUMBER

For future use
PERIOD53_FTE NUMBER

For future use
PERIOD54_FTE NUMBER

For future use
PERIOD55_FTE NUMBER

For future use
PERIOD56_FTE NUMBER

For future use
PERIOD57_FTE NUMBER

For future use
PERIOD58_FTE NUMBER

For future use
PERIOD59_FTE NUMBER

For future use
PERIOD60_FTE NUMBER

For future use
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FTE_LINE_ID
,      POSITION_LINE_ID
,      BUDGET_YEAR_ID
,      ANNUAL_FTE
,      SERVICE_PACKAGE_ID
,      STAGE_SET_ID
,      START_STAGE_SEQ
,      CURRENT_STAGE_SEQ
,      END_STAGE_SEQ
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PERIOD1_FTE
,      PERIOD2_FTE
,      PERIOD3_FTE
,      PERIOD4_FTE
,      PERIOD5_FTE
,      PERIOD6_FTE
,      PERIOD7_FTE
,      PERIOD8_FTE
,      PERIOD9_FTE
,      PERIOD10_FTE
,      PERIOD11_FTE
,      PERIOD12_FTE
,      PERIOD13_FTE
,      PERIOD14_FTE
,      PERIOD15_FTE
,      PERIOD16_FTE
,      PERIOD17_FTE
,      PERIOD18_FTE
,      PERIOD19_FTE
,      PERIOD20_FTE
,      PERIOD21_FTE
,      PERIOD22_FTE
,      PERIOD23_FTE
,      PERIOD24_FTE
,      PERIOD25_FTE
,      PERIOD26_FTE
,      PERIOD27_FTE
,      PERIOD28_FTE
,      PERIOD29_FTE
,      PERIOD30_FTE
,      PERIOD31_FTE
,      PERIOD32_FTE
,      PERIOD33_FTE
,      PERIOD34_FTE
,      PERIOD35_FTE
,      PERIOD36_FTE
,      PERIOD37_FTE
,      PERIOD38_FTE
,      PERIOD39_FTE
,      PERIOD40_FTE
,      PERIOD41_FTE
,      PERIOD42_FTE
,      PERIOD43_FTE
,      PERIOD44_FTE
,      PERIOD45_FTE
,      PERIOD46_FTE
,      PERIOD47_FTE
,      PERIOD48_FTE
,      PERIOD49_FTE
,      PERIOD50_FTE
,      PERIOD51_FTE
,      PERIOD52_FTE
,      PERIOD53_FTE
,      PERIOD54_FTE
,      PERIOD55_FTE
,      PERIOD56_FTE
,      PERIOD57_FTE
,      PERIOD58_FTE
,      PERIOD59_FTE
,      PERIOD60_FTE
FROM PSB.PSB_WS_FTE_LINES;

Dependencies

[top of page]

PSB.PSB_WS_FTE_LINES does not reference any database object

PSB.PSB_WS_FTE_LINES is referenced by following:

SchemaAPPS
SynonymPSB_WS_FTE_LINES