Search Results variable_increment

Overview

APPS.IGS_PS_USEC_CPS_V is a supplementary Oracle EBS view in the Student Systems (IGS) schema, owned by APPS and registered under FND Design Data as IGS.IGS_PS_USEC_CPS_V. The view presents credit point and workload attributes for unit section offerings — the "USEC" (unit section) context — consolidating credit point definitions, contact hours, workload, and billing measures into a single queryable structure. Its documented purpose is to simplify Oracle Forms coding rather than to serve as an end-user reporting interface. Oracle explicitly warns that querying or altering data through this view is not recommended, since its definition may change dramatically across minor or major releases. This view is distinct from typical TCA or financials views and sits within the Oracle Student System (formerly Student Administration/IR) domain, where "unit section credit points" govern how academic credit, workload, financial aid, and billing hours are calculated for a given unit offering occurrence.

Underlying Base Objects

The ETRM metadata records no documented base objects for this view; the dependency list exposes only the view itself and its column roster. In practice, the column naming (notably UNIT_SEC_CREDIT_POINTS_ID and UOO_ID) indicates the view is defined over the unit section credit points entity and joined to its parent unit offering option (UOO) record. The presence of ROW_ID confirms an underlying rowid source used by the Forms block. Because the ETRM documents no referenced base objects and the view type is "supplementary ... to simplify forms coding," consumers should treat the underlying joins as internal implementation details subject to change, and should not assume the view maps one-to-one to any single table.

Key Columns

• ROW_ID — ROWID identifying the underlying row, used by Forms for record navigation.
• UNIT_SEC_CREDIT_POINTS_ID — Primary key of the unit section credit points record.
• UOO_ID — Unit offering option identifier that anchors the section to its offering.
• MINIMUM_CREDIT_POINTS / MAXIMUM_CREDIT_POINTS / VARIABLE_INCREMENT — The credit point band and step value. This is the column the user searched for under "variable_increment"; it defines the increment between minimum and maximum credit points where variable credit is permitted.
• LECTURE_CREDIT_POINTS, LAB_CREDIT_POINTS, OTHER_CREDIT_POINTS — Credit point split by delivery component.
• WORK_LOAD_CP_LECTURE, WORK_LOAD_CP_LAB, WORK_LOAD_OTHER — Workload credit points by component.
• CONTACT_HRS_LECTURE, CONTACT_HRS_LAB, CONTACT_HRS_OTHER, DSP_CONTACT_HRS_TOTAL — Contact hours, with a display total.
• ACHIEVABLE_CREDIT_POINTS / ENROLLED_CREDIT_POINTS — Credit points achievable on completion versus those the student is considered enrolled in.
• BILLING_CREDIT_POINTS / BILLING_HRS — Billing measures.
• FIN_AID_CP / FIN_AID_HRS — Financial aid credit points and hours (documented as obsolete).
• CLAIMABLE_HOURS, CLOCK_HOURS, CONTINUING_EDUCATION_UNITS, EXCLUDE_FROM_MAX_CP_LIMIT, NON_SCHD_REQUIRED_HRS — Supplementary regulatory and institutional measures.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Because Oracle discourages direct querying, the principal supported use is Forms block population within the Student System. Where read-only reporting is required, a query constrained by UOO_ID is typical:

SELECT unit_sec_credit_points_id, uoo_id, minimum_credit_points, maximum_credit_points, variable_increment, achievable_credit_points, enrolled_credit_points FROM apps.igs_ps_usec_cps_v WHERE uoo_id = :p_uoo_id;

Analysts investigating variable credit configuration will target VARIABLE_INCREMENT alongside the minimum and maximum bounds to validate that valid credit selections are integral multiples of the increment. Given the release volatility warning, any dependent custom code should be reviewed on upgrade to 12.2.2 and regression-tested, since the view's SQL definition is not guaranteed across releases.