Results for “support_level_id”

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

Overview

The IGS_PE_PERS_DISABLTY table is a core table within the Oracle E-Business Suite Student System (IGS) product family. It records the disabilities associated with a person — typically a student or applicant — along with the special requirements, accommodations, and support services that pertain to that individual. As part of the Person/Student records area, it stores sensitive disability and accessibility information that institutions use to coordinate academic accommodations, special allowances, and support services across Student System modules.

From a Data Vault modeling perspective, the heuristic classification for this table is satellite-leaning. This suggests it functions primarily as a descriptive satellite attached to a person or party hub, capturing changeable disability attributes, effective dates, and interview context rather than serving as a pure hub or link. The presence of multiple foreign keys to reference code tables and party tables, plus effective-dated columns such as START_DATE and END_DATE, reinforces this satellite interpretation.

Key Information Stored

The table contains 42 documented columns. The most significant include:

• IGS_PE_PERS_DISABLTY_ID — the surrogate primary key, uniquely identifying each disability record (enforced by IGS_PE_PERS_DISABLTY_PK).
• PERSON_ID — foreign key to HZ_PARTIES, identifying the person to whom the disability record applies.
• DISABILITY_TYPE — foreign key to IGS_AD_DISBL_TYPE, categorizing the nature of the disability.
• START_DATE and END_DATE — the effective period of the disability record.
• SPECIAL_ALLOW_ID, SUPPORT_LEVEL_ID, and SPECIAL_SERVICE_ID — all foreign keys to IGS_PE_CODE_CLASSES, defining the allowances, support level, and special services provided.
• SPECIAL_ALLOW_CD and SUPPORT_LEVEL_CD — denormalized code values for allowances and support levels.
• INTERVIEWER_ID and INTERVIEWER_DATE — foreign key to HZ_PARTIES and the associated date, identifying who conducted the disability interview.
• ELIG_EARLY_REG_IND — indicates eligibility for early registration, a common accommodation outcome.
• CONTACT_IND and DOCUMENTED — flags indicating contact preference and whether the disability is formally documented.
• INFO_SOURCE — the source of the disability information.
• Standard audit and attribute columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ATTRIBUTE1–ATTRIBUTE20).

Two unique indexes serve as business-key candidates: IGS_PE_PERS_DISABLTY_U1 on IGS_PE_PERS_DISABLTY_ID, and IGS_PE_PERS_DISABLTY_U2 on the composite of PERSON_ID, DISABILITY_TYPE, and START_DATE. The latter prevents duplicate disability types for the same person beginning on the same date.

Common Use Cases and Queries

Typical uses include identifying students requiring accommodations, tracking support service history, and generating accessibility reports for compliance.

• Retrieve all active disabilities for a person:

  SELECT disability_type, start_date, end_date
  FROM igs_pe_pers_disablty
  WHERE person_id = :person_id
  AND (end_date IS NULL OR end_date > SYSDATE);

• List students eligible for early registration based on documented accommodations:

  SELECT person_id, special_service_id
  FROM igs_pe_pers_disablty
  WHERE elig_early_reg_ind = 'Y'
  AND documented = 'Y';

• Join to code classes for descriptive labels of support services and allowances.

Related Objects

• HZ_PARTIES — joined on PERSON_ID and INTERVIEWER_ID for party details.
• IGS_AD_DISBL_TYPE — joined on DISABILITY_TYPE for disability category descriptors.
• IGS_PE_CODE_CLASSES — joined on SPECIAL_ALLOW_ID, SUPPORT_LEVEL_ID, and SPECIAL_SERVICE_ID for allowance, support, and service definitions.
• IGS_PE_SN_SERVICE — references this table via DISABILITY_ID, linking services delivered to a disability record.
• IGS_PE_SN_CONTACT — references this table via DISABILITY_ID, capturing related contact records.