Results for “grading_period”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_AS_GPC_PROGRAMS_V view is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. It presents grading period information associated with programs and courses, exposing a denormalized, human-readable representation of grading period assignments. In Oracle EBS Release 12.1.1 and 12.2.2, this view resides in the APPS schema and carries a VALID status, indicating that it is a supported, queryable object suitable for use in reports, concurrent programs, and interface extracts.
Because the underlying IGS_AS_GPC_PROGRAMS table stores grading period assignments only as coded values, the view's primary role is to resolve those codes into descriptive meanings and to join them to course version titles. This makes the view particularly useful when building operational reports, grading extracts, or dashboards where end users require legible descriptions rather than internal lookup codes. The name itself decomposes into "GPC" (grading period configuration) and "PROGRAMS," reflecting its function of mapping grading periods to programmatically defined courses.
Underlying Base Objects
The view is defined over three referenced objects joined in a single SELECT statement:
IGS_AS_GPC_PROGRAMS GPR— the primary base table holding grading period program records. ItsGPC_PROGRAM_IDserves as the unique identifier.IGS_LOOKUPS_VIEW LKUP— the lookup view used to translate theGRADING_PERIOD_CDcode into a meaningful description, filtered by the lookup typeAS_GRADING_PERIOD.IGS_PS_VER PRGV— the course version table, joined on course code and version number to supply the course title.
The join predicates are:
GPR.GRADING_PERIOD_CD = LKUP.LOOKUP_CODEwithLKUP.LOOKUP_TYPE = 'AS_GRADING_PERIOD'GPR.COURSE_CD = PRGV.COURSE_CDandGPR.COURSE_VERSION_NUMBER = PRGV.VERSION_NUMBER
No additional base objects are documented for this view in the 12.2.2 metadata. The view does not appear to perform aggregation; it is a straightforward equi-join projection identifying each row by GPR.ROWID.
Key Columns
ROW_ID— the ROWID of the underlyingIGS_AS_GPC_PROGRAMSrecord, providing a stable row identifier.GPC_PROGRAM_ID— the surrogate primary key for the grading period program record.GRADING_PERIOD_CD— the coded grading period value, joining toAS_GRADING_PERIODlookups.GRADING_PERIOD— the decoded meaning of the grading period code, sourced fromIGS_LOOKUPS_VIEW.MEANING.COURSE_CDandCOURSE_VERSION_NUMBER— the course and version to which the grading period applies.COURSE_TITLE— the descriptive title of the course version, taken fromIGS_PS_VER.TITLE.- Audit columns —
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE, andLAST_UPDATE_LOGINsupport audit and incremental-extract logic.
Common Use Cases and Queries
Typical scenarios include grading period setup validation, course-to-grading-period reporting, and extract generation for downstream academic systems. A representative query retrieves all grading periods for a specific course:
SELECT gpc_program_id, grading_period, course_cd, course_version_number, course_title FROM igs_as_gpc_programs_v WHERE course_cd = :course_code ORDER BY grading_period;
For audit or incremental extraction, the timestamp columns may be filtered:
SELECT * FROM igs_as_gpc_programs_v WHERE last_update_date >= :last_extract_date;
Because the view already resolves lookup meanings, it is commonly embedded in Oracle Reports, BI Publisher data templates, and OAF pages servicing academic configuration, eliminating the need for report-level lookup joins.
-
View: IGS_AS_GPC_PROGRAMS_V 12.1.1
Grading period for programs
APPS.IGS_AS_GPC_PROGRAMS_V·↳ IGS_AS_GPC_PROGRAMS·↳ IGS_LOOKUPS_VIEW·↳ IGS_PS_VER·Explore IGS module →
-
View: IGS_AS_GPC_PE_ID_GRP_V 12.1.1
Holds the grading period information for a person ID group
APPS.IGS_AS_GPC_PE_ID_GRP_V·↳ IGS_AS_GPC_PE_ID_GRP·↳ IGS_LOOKUPS_VIEW·↳ IGS_PE_PERSID_GROUP_V·Explore IGS module →
-
View: IGS_AS_GPC_UNIT_SETS_V 12.1.1
Grading period for Unit Sets
APPS.IGS_AS_GPC_UNIT_SETS_V·↳ IGS_AS_GPC_UNIT_SETS·↳ IGS_EN_UNIT_SET·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_AS_GPC_PROGRAMS_V 12.2.2
Grading period for programs
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_GPC_PE_ID_GRP_V 12.2.2
Holds the grading period information for a person ID group
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_GPC_UNIT_SETS_V 12.2.2
Grading period for Unit Sets
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_AS_GEN_008 12.1.1
-
PACKAGE: APPS.IGS_AS_GEN_008 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.