Results for “igs_en_atd_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_EN_ATD_TYPE is a reporting view in the Oracle E-Business Suite IGS (Student System) product line, which is documented as obsolete in the ETRM reference for releases 12.1.1 and 12.2.2. The view exposes the set of attendance types available within the institution, such as full-time and part-time classifications, and is intended to serve as a secured, operating-unit-filtered read layer over the underlying attendance type definition table. Rather than functioning as a transactional entity, it acts as a lookup-style reporting and integration object that allows downstream queries, concurrent programs, and external interfaces to resolve attendance type codes, their descriptive text, enrolment load boundaries, and government reporting equivalents without directly accessing the maintenance table.
The ETRM metadata states explicitly that the view is not implemented in the documented database. Consequently, it should be treated as a definition of record rather than a guaranteed runtime object in every environment. Where the object does exist, it follows the standard Oracle multi-org security pattern applied to key flexfield-adjacent setup data.
Underlying Base Objects
The view is defined over a single documented base object, IGS_EN_ATD_TYPE_ALL. The "_ALL" suffix indicates that the table stores rows across all operating units, with organization context carried in the ORG_ID column. The view applies the standard Oracle multiorg predicate by comparing the organization identifier held in the session client information against the table's ORG_ID value, defaulting to a sentinel of -99 when no client information is available.
This construction means IGS_EN_ATD_TYPE behaves as an operating-unit (Org ID) secured view: rows belonging to other operating units are filtered out automatically, and records with a null ORG_ID are surfaced only through the sentinel comparison logic. Because the underlying table is an "_ALL" table, no additional join to a base translation table is present in the documented view text, and no other base objects are documented as referenced.
Key Columns
- ROW_ID – The row identifier derived from the table ROWID, used for optimistic locking and unique row addressing.
- ORG_ID – The operating unit that owns the attendance type record.
- ATTENDANCE_TYPE – The code identifying the attendance type, for example a full-time or part-time classification.
- DESCRIPTION – The descriptive name of the attendance type presented to users.
- GOVT_ATTENDANCE_TYPE – The corresponding government or statutory attendance classification used for external reporting.
- LOWER_ENR_LOAD_RANGE / UPPER_ENR_LOAD_RANGE – The lower and upper bounds of the enrolment load range associated with the attendance type.
- RESEARCH_PERCENTAGE – The proportion of the load attributable to research activity.
- CLOSED_IND – Indicator of whether the attendance type is closed to new use.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle audit columns recording who created and last modified each row.
Common Use Cases and Queries
The principal use case is validating and reporting enrolment load classifications. A typical query lists active attendance types for the current operating unit with their load ranges:
SELECT attendance_type, description, govt_attendance_type, lower_enr_load_range, upper_enr_load_range, research_percentage FROM igs_en_atd_type WHERE NVL(closed_ind, 'N') = 'N';SELECT attendance_type, description FROM igs_en_atd_type ORDER BY attendance_type;SELECT a.attendance_type, a.govt_attendance_type, a.research_percentage FROM igs_en_atd_type a WHERE a.org_id = :org_id;
Because the object is documented as obsolete and not implemented, any interface or report referencing it should first verify object existence and confirm that the equivalent setup data is maintained through the supported Student System setup path. Where the view is absent, equivalent information must be sourced directly from the corresponding attendance type maintenance table, observing the same operating unit filter semantics described above.
-
View: IGS_EN_ATD_TYPE 12.1.1
View incorporating various attendance types available. i.e. full-time, part-time.
APPS.IGS_EN_ATD_TYPE·↳ IGS_EN_ATD_TYPE_ALL·Explore IGS module →
-
VIEW: APPS.IGS_EN_ATD_TYPE 12.1.1
-
View: IGS_EN_ATD_TYPE 12.2.2
View incorporating various attendance types available. i.e. full-time, part-time.
Not implemented in this database·Explore IGS module →
-
APPS.IGS_PR_MILESTONE_CRV_ATT_V·↳ IGS_EN_ATD_TYPE·↳ IGS_PS_OFR_OPT·↳ IGS_RE_DFLT_MS_SET·Explore IGS module →
-
View: IGF_AW_DP_TEACH_PRDS_V 12.1.1
Award Distribution Plan Teaching Periods
APPS.IGF_AW_DP_TEACH_PRDS_V·↳ IGF_AW_DP_TEACH_PRDS·↳ IGS_CA_INST·↳ IGS_EN_ATD_TYPE·Explore IGF module →
-
View: IGF_SP_STDNT_REL_V 12.1.1
FORM VIEW formed by joining IGF_SP_STDNT_REL MO view, IGF_AW_FUND_MAST view and IGF_AP_FA_BASE_REC. The view holds sponsor student relation details
APPS.IGF_SP_STDNT_REL_V·↳ IGF_AP_FA_BASE_REC·↳ IGF_AW_FUND_MAST·↳ IGF_SP_STDNT_REL·Explore IGF module →
-
View: IGF_AP_AWYR_ATMAP_V 12.1.1
Stores Student System Attendance Types for award year
APPS.IGF_AP_AWYR_ATMAP_V·↳ IGF_AP_BATCH_AW_MAP·↳ IGS_EN_ATD_TYPE·Explore IGF module →
-
View: IGS_PR_OU_TYPE_V 12.1.1
APPS.IGS_PR_OU_TYPE_V·↳ IGS_EN_ATD_TYPE·↳ IGS_FI_ENCMB_TYPE·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_PS_VAL_GAT 12.1.1
-
PACKAGE: APPS.IGS_PS_VAL_COO 12.1.1
-
View: IGF_AW_AWD_DISB_V 12.1.1
Stores details of each disbursement
APPS.IGF_AW_AWD_DISB_V·↳ IGF_AW_AWD_DISB·↳ IGF_AW_AWD_RVSN_RSN·↳ IGF_AW_GEN·Explore IGF module →
-
View: IGF_AP_IA_LOOKUP_V 12.1.1
Lookup Types required for Institutional Application LOV items
APPS.IGF_AP_IA_LOOKUP_V·↳ IGF_AP_APPL_SETUP_ALL·↳ IGF_LOOKUPS_VIEW·↳ IGS_AD_LOCATION·Explore IGF module →
-
View: IGS_FI_FEE_AS_RATE_V 12.1.1
APPS.IGS_FI_FEE_AS_RATE_V·↳ HZ_PARTIES·↳ IGS_AD_LOCATION·↳ IGS_AS_UNIT_CLASS·Explore IGS module →
-
View: IGF_AW_DP_TEACH_PRDS_V 12.2.2
Award Distribution Plan Teaching Periods
Not implemented in this database·Explore IGF module →
-
View: IGF_AP_AWYR_ATMAP_V 12.2.2
Stores Student System Attendance Types for award year
Not implemented in this database·Explore IGF module →