Student Management Lookups

Review Oracle Student Management Cloud lookups that have user or extensible configuration levels. Update them as appropriate to suit requirements of your academic institution.

Access the Manage Student Management Lookups page: From Student Central, click Search and search for Manage Student Management Lookups.

One way to search for lookups is to use the User Module Name field. For example, select Tuition and Fees Setup as the user module name to search for lookups related to tuition and fees setup.

Campus Community Lookups

This table shows examples of Campus Community lookups.

Lookup Type	Description	Configuration Level
ORA_HEY_NAME_TYPE	Name types, such as legal, maiden, and primary.	Extensible
ORA_HEY_RESIDENCY_CODE	Residency statuses of students, such as in state, out of state, and international.	Extensible
ORA_HEY_RESIDENCY_EXCPT_CODE	Exceptions for which residency rules don't apply, such as military, graduate student, and married to in-state student.	Extensible
ORA_HEY_RESIDENCY_EXC_PURPOSE	Purposes for which a residency exception is applied, such as tuition.	Extensible
ORA_HEY_RES_APPEAL_STATUS	Review statuses of a residency appeal, such as initiated, approved, and rejected.	Extensible
ORA_HEY_SELF_REPORTED_SOURCE	Sources of self-reported residency information, such as admissions application and residency application.	Extensible
ORA_HEY_SELF_REPORTED_STATUS	Review statuses of self-reported residency records, such as received, under review, and reviewed.	Extensible
ORA_HEY_RES_TYPE_CODE	Values to indicate to whom the residency record applies, such as student, spouse of student, and mother of student.	Extensible
ORA_HEY_MILITARY_BRANCHES	Branches of the military, such as air force, navy, and army.	Extensible
ORA_HEY_MILITARY_STATUS	Statuses for the military branch of a person, such as active reserve, inactive reserve, and not a veteran.	Extensible
ORA_HEY_ETHNICITY	Values to indicate whether a person is of Hispanic or Latino origin.	User
ORA_HEY_RACE	Types of race, such as African American, Asian, and White.	User
ORA_HEY_ORG_TYPE	Types of external organizations, such as business, sponsorship, and nonprofit.	Extensible
ORA_HEY_ORG_CON_TYPE	Types of external organization contacts, such as registrar, sponsor coordinator, and guidance counselor.	Extensible
ORA_HEY_ORG_ID_TYPE	Types of external organization identifiers, such as CEEB, FICE, and NCES.	Extensible
ORA_HEY_SERVICE_TYPE	Types of a service in a service impact and service indicator, such as service provided and service restricted.	Extensible
HZ_GENDER	Person genders, such as female and male.	User
MARITAL_STATUS	Marital statuses, such as married, divorced, and single.	User
PARTY_SITE_USE_CODE	Types of party address usages, such as business, legal, and home.	User
CONTACT_POINT_PURPOSE	Types of purpose for phone and email contact, such as work, emergency, and home.	User

Student Records Lookups

This table shows examples of Student Records lookups.

Lookup Type	Description	Configuration Level
ORA_HER_FACILITY_CHARACTER	Physical characteristics and attributes of facilities to assist in scheduling courses and assignment of facilities. Examples include wireless network access, podium, and sound amplification.	User
ORA_HER_FACILITY_CLUSTERING	Geographically groups buildings on a campus to facilitate scheduling courses and assignment of facilities. Examples include East A for eastern part of campus in grouping A and East B for eastern part of campus in grouping B.	User
ORA_HER_FACILITY_TYPE_CODE	Classifications of the facility used to assist in scheduling courses and assignment of facilities. Examples include auditorium, classroom, and computer lab.	User
ORA_HER_MESSAGE_TYPE_CODE	Contexts of the curriculum tags, such as faculty, scheduled course information, and textbooks.	Extensible
ORA_HER_STAFF_ROLE_TYPE_CODE	Roles to which staff members can be assigned, such as department chair, dean, and professor.	Extensible
ORA_HER_IMPACT_ACTION_CODE	Functionality that can be impacted by service impacts, such as restrict enrollment adds and restrict enrollment drops.	Extensible

A scheduled course is also known as a course section.

Student Financials Lookups

This table shows examples of Student Financials lookups.

Lookup Type	Description	Configuration Level
ORA_CREDIT_SOURCE_CODE	Values to indicate credit source, such as state sponsorship.	User
ORA_HES_ADJUSTMENT_OPTION_CODE	Valid adjustment options for the adjustment calendar, such as enrollment period start date, reporting period start date, and scheduled course start date.	Extensible
ORA_HES_CHARGE_METHOD_CODE	Valid methods to create academic period fees, such as by reporting period and by scheduled course.	Extensible
ORA_HES_SPONSOR_AGREE_STATUS	Valid statuses for a sponsorship agreement, such as draft, active, and inactive.	Extensible
ORA_HES_SPONSOR_AGREE_TYPE	Valid types of sponsorship agreements, such as course, scheduled course, and reporting period.	Extensible
ORA_HES_TUITION_CALC_MODE	Modes in which tuition calculation was ran, such as calculate and post, and calculate only.	Extensible
ORA_HES_DUE_DATE_BASIS	Dates on which due date calculation is based, such as days from pivot date and days from system date.	Extensible
ORA_HES_DUE_DATE_CALENDAR_TYPE	Values to indicate whether a due date calendar is set for an academic period or a date range.	Extensible
ORA_HES_DUE_DATE_PIVOT_DATE	Values to indicate from which date a due date schedule is derived, such as reporting period start date and scheduled course start dated.	Extensible

A scheduled course is also known as a course section.

Student Admissions Lookups

This table shows examples of Student Admissions lookups.

Lookup Type	Description	Configuration Level
ORA_HEQ_ADMIT_TYPE	Types of applicant, such as new student, international, and transfer.	Extensible
ORA_HEQ_EVALUATION_STATUS	Evaluation statuses for applications, such as assigned, in review, and complete.	Extensible