eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGW.IGW_BUDGET_PERSONNEL_DETAILS

Object Details

Object Name:	IGW_BUDGET_PERSONNEL_DETAILS
Object Type:	TABLE
Owner:	IGW
FND Design Data:	IGW.IGW_BUDGET_PERSONNEL_DETAILS
Subobject Name:
Status:	VALID

IGW_BUDGET_PERSONNEL_DETAILS stores personnel details and related information, such as duration of work, percentage of effort charged, and percentage of effort worked for a budget line. A budget line can have multiple persons attached.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_BUDG_PERSL_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_PERSONNEL_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_PERSONNEL_DETAIL_ID	NUMBER	(15)	Yes	Budget personnel detail identifier
PROPOSAL_ID	NUMBER	(15)	Yes	Proposal identifier
VERSION_ID	NUMBER	(4)	Yes	Budget version identifier
BUDGET_PERIOD_ID	NUMBER	(4)	Yes	Budget period identifier
LINE_ITEM_ID	NUMBER	(15)	Yes	Budget line identifier
PERSON_ID	NUMBER	(15)		Person identifier
START_DATE	DATE		Yes	Start date from which a person in a budget line is effective
END_DATE	DATE		Yes	End date through which a person in a budget line is effective
PERIOD_TYPE_CODE	VARCHAR2	(30)	Yes	Code that uniquely identifies period type. Period type can be Academic, Calendar, Summer, or Cycle.
APPOINTMENT_TYPE_CODE	VARCHAR2	(30)	Yes	Code that uniquely identifies appointment type
SALARY_REQUESTED	NUMBER	(15)		Calculated salary for the person based on start date, end date, and percent charged
PERCENT_CHARGED	NUMBER	(5)		Percentage charged for a person in the budget line
PERCENT_EFFORT	NUMBER	(5)		Percentage effort of a person in the budget line
COST_SHARING_PERCENT	NUMBER	(5)		Percentage of cost sharing for the budget person
COST_SHARING_AMOUNT	NUMBER	(15)		Cost sharing amount calculation based on percentage of cost sharing for the budget person
UNDERRECOVERY_AMOUNT	NUMBER	(15)		Underrecovery amount for the budget person
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
RECORD_VERSION_NUMBER	NUMBER		Yes	Field for storing locking sequence number
PARTY_ID	NUMBER	(15)	Yes	Party identifier for person

Query Text

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


SELECT BUDGET_PERSONNEL_DETAIL_ID
,      PROPOSAL_ID
,      VERSION_ID
,      BUDGET_PERIOD_ID
,      LINE_ITEM_ID
,      PERSON_ID
,      START_DATE
,      END_DATE
,      PERIOD_TYPE_CODE
,      APPOINTMENT_TYPE_CODE
,      SALARY_REQUESTED
,      PERCENT_CHARGED
,      PERCENT_EFFORT
,      COST_SHARING_PERCENT
,      COST_SHARING_AMOUNT
,      UNDERRECOVERY_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
,      PARTY_ID
FROM IGW.IGW_BUDGET_PERSONNEL_DETAILS;

Dependencies

[top of page]

IGW.IGW_BUDGET_PERSONNEL_DETAILS does not reference any database object

IGW.IGW_BUDGET_PERSONNEL_DETAILS is referenced by following:

APPS: IGW_BUDGET_PERSONNEL_DETAILS