Results for “appointment_type_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGW_BUDGET_PERSONNEL_V is a database view historically shipped with the Oracle Grants Proposal (IGW) module, a component of the Oracle E-Business Suite that supported the preparation, routing, and submission of sponsored research proposals. The ETRM metadata classifies this object under the product code IGW and describes it as "10SC Only," indicating that the view was implemented exclusively for the 10SC (Release 10 Character Set) environment and was not carried forward into later certified Oracle EBS releases. The metadata further states "Not implemented in this database," confirming that the view is obsolete and absent from supported 12.1.1 and 12.2.2 installations.

Functionally, the view presents budget personnel detail records — the individuals associated with a proposal budget and their corresponding effort, salary, and cost-sharing attributes — in a denormalized, read-only form intended for reporting and integration against the underlying transaction table. Its most prominent search-relevant column is PERCENT_EFFORT, which quantifies the proportion of a person's total activity committed to a sponsored project.

Underlying Base Objects

The ETRM metadata does not document the owner or any referenced base objects for this view. However, the view text explicitly identifies its single source table: IGW_BUDGET_PERSONNEL_DETAILS. The view is a straightforward projection over that table, selecting a defined column list without joins, unions, or aggregation. Consequently, no relationship to other IGW tables such as IGW_PROPOSALS or IGW_BUDGET_PERIODS is materialized in the view definition itself; any relational context must be resolved by the consumer through the foreign key columns exposed (for example, PROPOSAL_ID, VERSION_ID, BUDGET_PERIOD_ID, LINE_ITEM_ID, and PERSON_ID).

Because the view is documented as obsolete and unimplemented, it should not be relied upon in current 12.1.1 or 12.2.2 environments. On releases where it existed, its row set is identical in cardinality to IGW_BUDGET_PERSONNEL_DETAILS, with no filtering applied.

Key Columns

• PERCENT_EFFORT — The percentage of a person's total professional effort allocated to the budgeted line; the column most frequently queried for workload and effort certification analysis.
• PERCENT_CHARGED — The percentage of salary charged to the sponsored project, distinguishable from effort when cost sharing applies.
• BUDGET_PERSONNEL_DETAIL_ID — Primary key of the underlying detail record.
• PROPOSAL_ID / VERSION_ID — Identify the parent proposal and its version, enabling joins to proposal headers.
• BUDGET_PERIOD_ID / LINE_ITEM_ID — Associate the personnel record with a specific budget period and budget line.
• PERSON_ID — References the individual (typically PER_PEOPLE_F) to whom the effort and salary apply.
• START_DATE / END_DATE — The effective date range of the personnel assignment.
• PERIOD_TYPE_CODE / APPOINTMENT_TYPE_CODE — Classify the budget period and the appointment basis for the person.
• SALARY_REQUESTED — The salary amount requested for the assignment.
• COST_SHARING_PERCENT / COST_SHARING_AMOUNT — Quantify committed cost sharing, if any.
• UNDERRECOVERY_AMOUNT — Any amount not recovered through the sponsored award.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard EBS who-did-what traceability.

Common Use Cases and Queries

Where the view is available, its principal uses are effort reporting, salary and cost-share reconciliation, and extract-based integration with effort certification or payroll systems. A representative query is:

SELECT PROPOSAL_ID, VERSION_ID, PERSON_ID, START_DATE, END_DATE, PERCENT_EFFORT, PERCENT_CHARGED, SALARY_REQUESTED, COST_SHARING_PERCENT, COST_SHARING_AMOUNT FROM IGW_BUDGET_PERSONNEL_V WHERE PERCENT_EFFORT > 0 ORDER BY PROPOSAL_ID, PERSON_ID;

Analysts may also aggregate total effort per person or per budget period by grouping on PERSON_ID or BUDGET_PERIOD_ID, and compare PERCENT_CHARGED against PERCENT_EFFORT to detect underrecovery. Because the view is documented as obsolete and not implemented in 12.1.1 / 12.2.2, equivalent reporting should be sourced from the successor grants budget personnel tables.