Results for “igs_ps_ver”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_VER is an Oracle E-Business Suite view owned by the APPS schema and registered as VALID in the IGS (Student System) product. As documented in the ETRM metadata, the view is defined with the descriptive purpose "This view would be used in form," indicating that it was constructed primarily to support the Oracle Forms-based user interface of the Student System rather than to serve as a standalone reporting entity. In Oracle EBS 12.1.1 and 12.2.2, such views typically wrap an underlying "_ALL" table and apply Multi-Org security filtering, exposing a subset of columns in the exact shape required by a particular form block.
The view presents version-level course (program/unit version) information from the Student System, including course identity, effective dates, status, and a large set of descriptive and administrative attributes. Because it applies an ORG_ID filter through the CLIENT_INFO session context, it behaves as an organization-restricted view: callers only see rows belonging to the operating unit context established for their session.
Underlying Base Objects
The documented base object for this view is IGS_PS_VER_ALL. The view text selects from this table using the alias TAB, projecting a defined column list and appending a WHERE clause that restricts rows by organization:
WHERE NVL(TAB.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
This is the standard Oracle EBS Multi-Org secured view pattern. When CLIENT_INFO is unset, the DECODE returns NULL, the fallback value becomes -99, and rows with a null ORG_ID (shared/global records) qualify. When an operating unit is set, only rows matching that ORG_ID are returned. The "_ALL" suffix on the base table confirms the underlying storage is not itself org-secured, and the view supplies the security layer.
Key Columns
IGS_PS_VER exposes a wide column list. Notable columns include:
- ROW_ID — ROWID of the underlying row, used for form-based updates.
- COURSE_CD, VERSION_NUMBER — the course/version key attributes.
- START_DT, REVIEW_DT, EXPIRY_DT, END_DT — version lifecycle and effective dating.
- COURSE_STATUS, COURSE_TYPE — status and classification of the version.
- TITLE, SHORT_TITLE, ABBREVIATION — descriptive names.
- GENERIC_COURSE_IND, GRADUATE_STUDENTS_IND, COURSE_STATUS — flags controlling behaviour.
- RESPONSIBLE_ORG_UNIT_CD, RESPONSIBLE_OU_START_DT — owning organization.
- CONTACT_HOURS, CREDIT_POINTS_REQUIRED, COURSE_TOTAL_EFTSU — teaching and load measures.
- APPROVAL_DATE, EXTERNAL_APPROVAL_DATE — approval tracking.
- ORG_ID — operating unit used for Multi-Org filtering.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard DFF (Descriptive Flexfield) columns, plus audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Because the view is Multi-Org secured, queries should be run in a session (or responsibility) with the desired operating unit context set; otherwise only global (ORG_ID null/-99) rows are visible. Typical uses include:
- Retrieving a course version for a given code and version number.
- Listing all currently active versions for a course.
- Reading flexfield attributes for downstream reporting.
Example queries:
SELECT course_cd, version_number, title, course_status, start_dt, end_dt FROM apps.igs_ps_ver WHERE course_cd = :course_cd AND version_number = :version_number;
SELECT course_cd, version_number, title FROM apps.igs_ps_ver WHERE course_status = 'ACTIVE' AND SYSDATE BETWEEN start_dt AND NVL(end_dt, SYSDATE) ORDER BY course_cd, version_number;
SELECT course_cd, version_number, attribute_category, attribute1, attribute2 FROM apps.igs_ps_ver WHERE org_id = :org_id;
-
View: IGS_PS_VER 12.1.1
This view would be used in form
-
VIEW: APPS.IGS_PS_VER 12.1.1
-
View: IGS_PS_VER 12.2.2
This view would be used in form
Not implemented in this database·Explore IGS module →