Results for “salary_requested”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGW_BUDGET_PERSONNEL_DETAILS table resides in the IGW schema, which supports the Oracle E-Business Suite Grants Proposal (IGW) product. In EBS 12.1.1 and 12.2.2, this table stores the personnel detail records that are attached to an individual budget line. Whereas the parent budget line defines the funding structure and period breakdown for a proposal, IGW_BUDGET_PERSONNEL_DETAILS captures the labor dimension of that line: which person is charged to the budget, over what interval, in what capacity, and at what salary and effort levels. Because a single budget line can carry multiple personnel assignments, this table typically holds many child rows per parent line item.
From a Data Vault modeling perspective, the documented foreign-key topology suggests a satellite-leaning classification. The table carries descriptive and quantitative attributes (dates, percentages, salary amounts) that describe a business entity rather than acting as a pure hub or a pure relationship link, although it also resolves associations between budget lines, persons, and proposal versions. Practitioners designing downstream warehouses should treat it as an attribute-bearing detail table whose grain is one personnel assignment per budget line.
Key Information Stored
The physical schema documents 23 columns. The most significant are:
- BUDGET_PERSONNEL_DETAIL_ID — The surrogate primary key, enforced through the constraint
IGW_BUDG_PERSL_DETAILS_PKand the unique indexIGW_BUDG_PERSL_DETAILS_U1. This is the only documented business-key candidate, so it also serves as the reliable join key to dependent tables. - LINE_ITEM_ID — Foreign key to
IGW_BUDGET_DETAILS, identifying the budget line to which the personnel record belongs. - PROPOSAL_ID — Foreign key to
IGW_BUDGET_PERSONSand the proposal context in which the assignment exists. - VERSION_ID — Foreign key to
VEA_VERSIONS, distinguishing budget proposal versions. - BUDGET_PERIOD_ID — Ties the record to a specific budget period.
- PERSON_ID and PARTY_ID — Identification of the individual, and the associated trading-party (TCA) record.
- START_DATE and END_DATE — The effective interval of the personnel assignment.
- PERIOD_TYPE_CODE and APPOINTMENT_TYPE_CODE — Classification of the appointment (for example, academic versus calendar terms).
- SALARY_REQUESTED, PERCENT_CHARGED, PERCENT_EFFORT, COST_SHARING_PERCENT — Core costing and effort metrics for the assignment.
- COST_SHARING_AMOUNT and UNDERRECOVERY_AMOUNT — Derived monetary values supporting sponsor and institutional cost-share reporting.
- RECORD_VERSION_NUMBER — Concurrency control, alongside the standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN).
Common Use Cases and Queries
Typical reporting scenarios include reconstructing a proposal's labor budget by period, tracking cost-sharing commitments, and reconciling calculated amounts against requested amounts. A frequent query joins the detail rows to their parent line and to the calculated amounts table:
- Personnel cost-share reporting: aggregate
COST_SHARING_AMOUNTandCOST_SHARING_PERCENTbyPROPOSAL_IDandVERSION_ID. - Effort distribution analysis: sum
PERCENT_EFFORTbyPERSON_IDacrossBUDGET_PERIOD_IDto validate that committed effort does not exceed 100 percent. - Line-level drill-down: join to
IGW_BUDGET_DETAILSonLINE_ITEM_IDto present requested salary against the line's overall budgeted amount. - Version comparison: filter on
VERSION_IDto compare personnel assumptions between successive budget versions.
Standard SQL patterns use BUDGET_PERSONNEL_DETAIL_ID as the join key to IGW_BUDGET_PERSONNEL_CAL_AMTS, and LINE_ITEM_ID or PROPOSAL_ID to reach the parent budget structures.
Related Objects
- IGW_BUDGET_DETAILS — Parent budget line; joined via
LINE_ITEM_ID. - IGW_BUDGET_PERSONS — Person/proposal association; joined via
PROPOSAL_ID. - VEA_VERSIONS — Proposal version control; joined via
VERSION_ID. - IGW_BUDGET_PERSONNEL_CAL_AMTS — Child table holding calculated amounts; joined via
BUDGET_PERSONNEL_DETAIL_ID.
-
Personnel detail attached to a budget line
-
View displays summary information about personnel included in budget lines
-
View to display personnel and their information for the first budget period
APPS.IGW_REPORT_BUDGET_PERSONNEL_V·↳ HZ_PARTIES·↳ IGW_BUDGETS·↳ IGW_BUDGET_INTEGRATION·Explore IGW module →
-
APPS.IGWBV_GRNT_PRPSL_BDGT_LIN_PERS·↳ FND_GLOBAL·↳ IGW_BUDGET_PERSONNEL_DETAILS·↳ IGW_LOOKUPS_V·Explore IGW module →
-
View: IGW_BUDGET_PERSONNEL_V 12.1.1
10SC Only
APPS.IGW_BUDGET_PERSONNEL_V·↳ IGW_BUDGET_PERSONNEL_DETAILS·Explore IGW module →
-
APPS.IGWFV_GRNT_PRPSL_BDGT_LIN_PERS·↳ FND_GLOBAL·↳ IGW_BUDGET_PERSONNEL_DETAILS·↳ IGW_LOOKUPS_V·Explore IGW module →
-
View displays details about personnel included in budget lines
-
View: IGW_BUDGET_PERSONNEL_V 12.2.2
10SC Only
Not implemented in this database·Explore IGW module →
-
View displays summary information about personnel included in budget lines
Not implemented in this database·Explore IGW module →
-
View to display personnel and their information for the first budget period
Not implemented in this database·Explore IGW module →
-
Not implemented in this database·Explore IGW module →
-
Not implemented in this database·Explore IGW module →
-
View displays details about personnel included in budget lines
Not implemented in this database·Explore IGW module →
-
eTRM - IGW Tables and Views 12.1.1
Information on proposal subjects