My Student System Table Descriptions hand book (I have big hands) Part 9

Student System - IGS_PS_UNITASS_ITEM	This entity describes all the assessment items for a unit section.
Column Name	Descritpion
UNIT_SECTION_ASS_ITEM_ID	Unique identifier for assessment unit for the unit section.
DUE_DT	Date before that the unit assessment rule should be applied to unit offering option.
REFERENCE	Source from that a check is made to assessment rule.
DFLT_ITEM_IND	Indicator that defaults the reference code of unit assessment item.
LOGICAL_DELETE_DT	Date on that a record is marked for deletion.
ACTION_DT	Date on that an action is taken on the unit assessment.
EXAM_CAL_TYPE	Calendar type for the unit assessment.
EXAM_CI_SEQUENCE_NUMBER	Unique number attached to a exam calendar instance.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
UOO_ID	Identifier for unit offering option.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record.
PROGRAM_ID	Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
GRADING_SCHEMA_CD	The grading schema for the assessment item associated with student assessment item
GS_VERSION_NUMBER	The version of grading schema for the assessment item associated with student assessment item.
RELEASE_DATE	Date on which outcome is released to the student. If the value is null the outcome is not displayed to the student on self service screens.
DESCRIPTION	Assessment item description defined at the unit section level.
US_ASS_ITEM_GROUP_ID	Unique identifier of a group to which the unit section assessment item is attached.
ASS_ID	Identifier for the assessment type.
MIDTERM_MANDATORY_TYPE_CODE	For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
MIDTERM_WEIGHT_QTY	Allows user to define the weight of the assessment item relative to other assessment items for 'Midterm' grading period.
FINAL_MANDATORY_TYPE_CODE	For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
FINAL_WEIGHT_QTY	Allows user to define the weight of the assessment item relative to other assessment items for 'Final' grading period.
SEQUENCE_NUMBER	Unique system generated number for an unit section occurrence .
CI_START_DT	Start date of the calendar instance for the unit section.
CI_END_DT	End date of the calendar instance for the unit section.
UNIT_CLASS	- Obsolete
UNIT_MODE	- Obsolete
LOCATION_CD	- Obsolete

Student System - IGS_PS_UNIT_CAT	This entity describes user-defined unit categories, which are used to categorize all units offered by the university.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CAT	Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records.
DESCRIPTION	Name of the unit category.
CLOSED_IND	Indicator that specifies whether the unit category is open or closed. Setting the checkbox to closed prevents the use of the category in new records.

Student System - IGS_PS_UNIT_CROS_REF	This entity holds the Cross Reference Information of Units.
Column Name	Descritpion
UNIT_CROSS_REFERENCE_ID	Unique identifier for cross section relations between units.
LAST_UPDATE_LOGIN	Standard Who column
PARENT_UNIT_CODE	Code of the unit that is parent at one level higher to the present unit.
PARENT_UNIT_VERSION_NUMBER	Version number of the unit that parent at one level higher to the present unit.
CHILD_UNIT_CODE	Code of the unit that is child at one level lower to the present unit.
CHILD_UNIT_VERSION_NUMBER	Version number of the unit that is child at one level lower to the present unit.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_UNIT_DISC_CRT	This entity describes the unit discontinuation date criteria of a teaching period calendar instance.
Column Name	Descritpion
ADMINISTRATIVE_UNIT_STATUS	Name of an institution-defined administrative unit status (AUS) mapped to the specified discontinuation date.
DELETE_IND	Indicator that specifies whether or not a student unit attempt should be logically deleted when the unit is discontinued on or after the discontinued date alias and before the next occurring discontinuation date in the teaching period.
DFLT_IND	Indicator that specifies whether or not the administrative unit status should be the default status when unit discontinuations occur on a particular date. Setting the indicator ticked makes this AUS the default, tough it may be overridden.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
UNIT_DISCONT_DT_ALIAS	Name of a date alias representing the date on or after that units are discontinued. Discontinuation date aliases are linked to administrative unit statuses (AUS).
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNIT_DSCP	This entity describes the discipline areas in which a unit is taught. If required a percentage allocation may be used across multiple discipline groups.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Code of the unit to that a discipline group is allocated.
VERSION_NUMBER	Version number of the unit to that a discipline group is allocated.
DISCIPLINE_GROUP_CD	Discipline group code. Discipline groups are used to classify units of study in terms of the subject matter being taught and or researched.
PERCENTAGE	Describes the percentage allocation of unit discipline for a unit.

Student System - IGS_PS_UNIT_FACILITY	This entity describes the Facilities (Media & Equipment) available at Buildings & Rooms of Unit Locations
Column Name	Descritpion
UNIT_MEDIA_ID	Unique identifier for the facility media in a unit location.
UNIT_CODE	Code of the unit that is offered.
UNIT_VERSION_NUMBER	Version number of the unit that is offered.
MEDIA_CODE	Code of the media equipment that is needed.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNIT_FLD_STDY	To capture the relation between Units & Fields of Study
Column Name	Descritpion
UNIT_FIELD_OF_STUDY_ID	Unique identifier for unit field of study.
UNIT_CODE	Code of the unit that is offered.
VERSION_NUMBER	Version number of the unit that is offered.
FIELD_OF_STUDY	Area or field to that the unit belongs to.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNIT_GRD_SCHM	Entity to capture the relation between Units and Grading Schemas
Column Name	Descritpion
UNIT_GRADING_SCHEMA_ID	Unique identifier for the unit grading schemas.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CODE	Code of the unit that is offered.
UNIT_VERSION_NUMBER	Version number of the unit. For example,1st one or 2nd.
GRADING_SCHEMA_CODE	Code of the grading method. For example, A, B ,B+ and others.
GRD_SCHM_VERSION_NUMBER	Version number of the grading method done for the unit.
DEFAULT_FLAG	Indicator flag that holds a Y or a N.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_UNIT_INT_LVL	This table describes the grouping of units in terms of program level for WEFTSU.
Column Name	Descritpion
UNIT_INT_COURSE_LEVEL_CD	Internal program level code.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description, or name, of the unit internal program level. Internal program levels are used in the determination of WEFTSU.
WEFTSU_FACTOR	Factor associated with the internal program level grouping used in the determination of WEFTSU.
CLOSED_IND	Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records.

Student System - IGS_PS_UNIT_LOCATION	Entity to capture the Unit Locations information
Column Name	Descritpion
UNIT_LOCATION_ID	Unique identifier for the unit locations.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CODE	Code of the unit that is offered.
UNIT_VERSION_NUMBER	Version number of the unit to be offered.
LOCATION_CODE	Code of the place at that the unit section is offered.
BUILDING_ID	Code of the building in that location.
ROOM_ID	Code of the room within a building.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_UNIT_OFR	This entity describes an offering of a unit within a calendar type.
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Unique identifier of the unit being offered.
VERSION_NUMBER	Version number of the unit being offered. Students are normally enrolled in the current version. Prior versions are end-dated.
CAL_TYPE	Calendar type in that the unit is offered. Units can only be offered in instances of calendar types that are categorized as Teaching calendars.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_UNIT_OFR_MODE	This entity describes the relation between Units and Offering Modes.
Column Name	Descritpion
UNIT_CD	Code used to identify the unit.
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
OFFERING_MODE	Describes the various modes in that a unit is offered. For example, On campus, Off campus.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNIT_OFR_NOTE	This table describes the notes associated with a unit offering.
Column Name	Descritpion
UNIT_CD	Code used to identify the unit.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Units can have versions. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated.
CAL_TYPE	Calendar type included in the unit offering note. Units can only be offered in instances of calendar types that are categorized as Teaching calendars.
REFERENCE_NUMBER	Reference number of a particular note.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types can be defined for any purpose. For example, institutions can define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column

Student System - IGS_PS_UNIT_REF_CD	This entity describes a reference code or codes related to the unit. E.g. IVRS code.
Column Name	Descritpion
UNIT_CD	Code of the unit for that the reference code is specified.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the unit for that the reference code is specified.
REFERENCE_CD_TYPE	Type or classification of an other system unit reference code.
REFERENCE_CD	Other system reference code for a unit. For example, an IVRS code used to represent a unit.
DESCRIPTION	Description, or name, of the unit reference code.
CREATED_BY	Standard Who column

Student System - IGS_PS_UNIT_RU	Unit rules
Column Name	Descritpion
UNIT_CD	Unit code
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
S_RULE_CALL_CD	Rule call name
RUL_SEQUENCE_NUMBER	Rule name rule sequence number
CREATED_BY	Standard Who column

Student System - IGS_PS_UNIT_STAT	This entity describes the user-defined unit statuses. E.g. Current, Suspended. These map back onto the system unit statuses, to provide the system with the ability to have a large number of statuses, which tie back to the system functionali
Column Name	Descritpion
S_UNIT_STATUS	System-defined unit status. Each institution-defined unit status is mapped to a system status.
CLOSED_IND	Indicator that specifies if the unit status is open or closed.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_STATUS	Describes the user-defined unit statuses. The unit status is attributed to each version to define its currency in the system. Unit status will map back onto the system unit statuses that will define the attached functionality.
DESCRIPTION	Provides an explanation of the institution-defined unit status.

Student System - IGS_PS_UNIT_VER_NOTE	This entity describes mappings of notes to unit versions.
Column Name	Descritpion
REFERENCE_NUMBER	Reference number of a particular note.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types may be defined for any purpose. For example, institutions may define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Unique identifier of the unit version that is the subject of the unit version note.
VERSION_NUMBER	Version number of the unit that is the subject of the unit version note.

Student System - IGS_PS_UNIT_VER_RU	Unit version rules
Column Name	Descritpion
UNIT_CD	Unit code
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number
S_RULE_CALL_CD	Rule call name
RUL_SEQUENCE_NUMBER	Rule name rule sequence number
CREATED_BY	Standard Who column

Student System - IGS_PS_UNT_OFR_OPT_N	This table describes the notes associated with a unit offering option.
Column Name	Descritpion
UNIT_CD	Unique identifier of the unit that is the subject of the unit offering option note.
REFERENCE_NUMBER	Reference number of a particular note.
UOO_ID	Unique identifier for a particular unit offering option.
VERSION_NUMBER	Version number of the unit for that the unit offering option note is being created.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types can be defined for any purpose. For example, institutions can define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CAL_TYPE	Institution-defined name of a particular Teaching type calendar.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance.
LOCATION_CD	Location or campus of the unit offering option.
UNIT_CLASS	Institution-defined code that identifies a unit class.

Student System - IGS_PS_UNT_OFR_PAT_N	This table describes the notes associated with a Unit Offering Pattern.
Column Name	Descritpion
REFERENCE_NUMBER	Reference number of a particular note.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types may be defined for any purpose. For example, institutions may define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Unique identifier of the unit that is the subject of the unit offering pattern note.
VERSION_NUMBER	Version of the unit that is the subject of the unit offering pattern note.
CAL_TYPE	Calendar type included in the unit offering pattern note. Units can only be offered in instances of calendar types that are categorized as Teaching calendars.
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance.

Student System - IGS_PS_UNT_PRV_GRADE	To capture the relation between Units and their Previous Grades Qualifying for Repeat
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_PREV_GRADE_ID	Unique identifier for grade
UNIT_CODE	Unit code of the previous grade
UNIT_VERSION_NUMBER	Version number of the unit
GRADING_SCHEMA_CODE	Grading schema code
GRADING_SCHEMA_VERSION_NUMBER	Grading schema version number
GRADING_SCHEMA_VALUE	Value of the grading schema
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_UNT_REPT_FMLY	Entity To capture the relation between Units and their Repeating Families
Column Name	Descritpion
UNIT_REPEAT_FAMILY_ID	Unique identifier for the relation between units and their repeating families.
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CODE	Unit code
UNIT_VERSION_NUMBER	Version number of the unit
REPEAT_FMLY_UNIT_CODE	Repeat family unit code
REPEAT_FMLY_UNIT_VERSION_NUM	Repeat family unit version number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_UOFR_WLST_PRF	This entity describes the Waitlist preferences for a Unit Offering Pattern
Column Name	Descritpion
UNIT_OFR_WAITLIST_PREF_ID	Unique identifier for the waitlist preference for a unit offering pattern.
LAST_UPDATE_LOGIN	Standard Who column
UNIT_OFR_WAITLIST_PRIORITY_ID	Unit offering waitlist priority identifier
PREFERENCE_ORDER	Order of the preference
PREFERENCE_CODE	Preference code
PREFERENCE_VERSION	Preference version number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_UOFR_WLST_PRI	To capture the Waitlist Priorities for a Unit Offering Pattern
Column Name	Descritpion
UNIT_OFR_WAITLIST_PRIORITY_ID	Unique identifier of waitlist priority for an unit offering pattern.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Unit code
VERSION_NUMBER	Version number
CALENDER_TYPE	Calendar type
CI_SEQUENCE_NUMBER	Sequence number of the calendar Type.
PRIORITY_NUMBER	Priority number
PRIORITY_VALUE	Priority value
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_USEC_AS	Entity to capture the relation between Unit Sections and Assessments done in it.
Column Name	Descritpion
UNIT_SECTION_ASSESSMENT_ID	Unique identifier for the relation between unit sections and assessments.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UOO_ID	Unit section identifier
FINAL_EXAM_DATE	Date of the final examination
EXAM_START_TIME	Examination start time
EXAM_END_TIME	Examination end time
LOCATION_CD	Unique identifier for the location
BUILDING_CODE	Building code
ROOM_CODE	Room code
CREATED_BY	Standard Who column

Student System - IGS_PS_USEC_CAL_NUMS	This table stores the maximum call number assigned to load calendar instances.
Column Name	Descritpion
UNIT_SECTION_CALL_NUMBER_ID	Unique identifier for the call numbers for the unit sections.
CALENDER_TYPE	Calendar type
CI_SEQUENCE_NUMBER	Sequence number of the calendar instance.
CALL_NUMBER	Unit section call number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_USEC_CPS	To capture the Credit Points for a Unit Section
Column Name	Descritpion
UNIT_SEC_CREDIT_POINTS_ID	Unique identifier of credit points for a unit section.
BILLING_CREDIT_POINTS	Audit Credit Points
WORK_LOAD_CP_LECTURE	Work load credit points on lecture
WORK_LOAD_CP_LAB	Work load credit point for laboratory
CONTINUING_EDUCATION_UNITS	Units for continuing education
ACHIEVABLE_CREDIT_POINTS	Number of credit points awarded upon successful completion of the unit section.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
WORK_LOAD_OTHER	Work load for any component other than lecture and laboratory
UOO_ID	Unit section identifier
CONTACT_HRS_LECTURE	Contacts hours for Lecture
CONTACT_HRS_LAB	Contacts hours for Laboratory
CONTACT_HRS_OTHER	Contact hours for any component other than lecture and laboratory
BILLING_HRS	Billable Credit Points
NON_SCHD_REQUIRED_HRS	Non Scheduled Required Hours
FIN_AID_CP	Financial Aid Credit Points - Obsolete
FIN_AID_HRS	Financial Aid Hours - Obsolete
EXCLUDE_FROM_MAX_CP_LIMIT	Excludes a unit's achievable credit points from counting in a student's maximum credit points limit.
CLAIMABLE_HOURS	The maximum hours that a student in a class can claim
ENROLLED_CREDIT_POINTS	Number of credit points in which the student is considered to be enrolled.
MINIMUM_CREDIT_POINTS	Minimum credit points
MAXIMUM_CREDIT_POINTS	Maximum credit points
VARIABLE_INCREMENT	Variable increment of credit points
LECTURE_CREDIT_POINTS	Lecture credit points
LAB_CREDIT_POINTS	Laboratory credit points
OTHER_CREDIT_POINTS	Any other credit points
CLOCK_HOURS	Number of clock hours

Student System - IGS_PS_USEC_GRD_SCHM	Entity to capture the Grading Schemas related to the Unit Sections.
Column Name	Descritpion
UNIT_SECTION_GRADING_SCHEMA_ID	Unique identifier for the grading schemas related to the unit sections.
LAST_UPDATE_LOGIN	Standard Who column
UOO_ID	Unit section identifier
GRADING_SCHEMA_CODE	Grading schema code for the unit section.
GRD_SCHM_VERSION_NUMBER	Grading schema version number.
DEFAULT_FLAG	Indication of default grading schema.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_USEC_LIM_WLST	This entity describes the Unit Section Limits and Waitlist information
Column Name	Descritpion
UNIT_SECTION_LIMIT_WAITLIST_ID	Unique identifier for the unit section limits and waitlist.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OVERRIDE_ENROLLMENT_MAX	This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased
MAX_AUDITORS_ALLOWED	Indicates maximum number of auditors allowed
UOO_ID	Unit section identifier
ENROLLMENT_EXPECTED	Expected number of enrollments.
ENROLLMENT_MINIMUM	Minimum number of enrollments.
ENROLLMENT_MAXIMUM	Maximum number of enrollments.
ADVANCE_MAXIMUM	Maximum number of advance enrollments.
WAITLIST_ALLOWED	Waitlist allowed indicator
MAX_STUDENTS_PER_WAITLIST	Maximum number of students per waitlist.
CREATED_BY	Standard Who column

Student System - IGS_PS_USEC_OCUR_REF	Entity to capture the Occurrences of a Unit Section.
Column Name	Descritpion
UNIT_SEC_OCCUR_REFERENCE_ID	Unique identifier for the occurrences of a unit section.
LAST_UPDATE_LOGIN	Standard Who column
UNIT_SECTION_OCCURRENCE_ID	Unit section occurrence identifier
REFERENCE_CODE_TYPE	Reference code type for the unit section occurrence
REFERENCE_CODE	Reference code for the unit section occurrence.
REFERENCE_CODE_DESC	This column stores the description of the reference code.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_USEC_PRV_GRAD	This entity describes the relation between Unit Sections and their Previous Grades Qualifying for Repeat
Column Name	Descritpion
UNIT_SECTION_PREV_GRADE_ID	Unique identifier that forms the relation between unit sections and their previous grades qualifying for repeat.
LAST_UPDATE_LOGIN	Standard Who column
UOO_ID	Unique identifier for the unit section.
GRADING_SCHEMA_CODE	Grading schema used in the previous grade.
GRADING_SCHEMA_VERSION_NUMBER	Grading schema version used in the previous grade.
GRADING_SCHEMA_VALUE	Grading schema value used in the previous grade.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_USEC_REF	To capture the relation between Unit Sections and Unit Section Reference Codes
Column Name	Descritpion
UNIT_SECTION_REFERENCE_ID	Unique identifier for the relation between unit sections and unit section reference code.
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
UOO_ID	Unique identifier for unit section.
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
ATTRIBUTE16	Descriptive Flexfield segment
ATTRIBUTE17	Descriptive Flexfield segment
ATTRIBUTE18	Descriptive Flexfield segment
ATTRIBUTE19	Descriptive Flexfield segment
ATTRIBUTE20	Descriptive Flexfield segment
CREATED_BY	Standard Who column
SHORT_TITLE	Short title for unit section reference.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RECORD_EXCLUSION_FLAG	Excludes unit section from displaying in self service records windows and on transcripts and excludes unit section from GPA calculation
TITLE	Title for the unit section
SUBTITLE_ID	The field is foreign key to IGS_PS_UNIT_SUBTITLE. Indicates the subtitle identifier for subtitle associated with the unit.
SUBTITLE	Obsolete- Subtitle for unit section reference.
SUBTITLE_MODIFIABLE_FLAG	Subtitle modifiable flag for unit section reference.
CLASS_SCHEDULE_EXCLUSION_FLAG	Class schedule exclusion flag for the unit section.
REGISTRATION_EXCLUSION_FLAG	Obsolete-Registration exclusion flag for the unit section reference.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column.
ATTRIBUTE1	Descriptive Flexfield segment

Student System - IGS_PS_USEC_REF_CD	Entity to capture the relation between Unit Sections Reference and Reference codes.
Column Name	Descritpion
REFERENCE_CODE_ID	Unique identifier for the assessment references - Obsolete
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_SECTION_REFERENCE_CD_ID	Unique identifier for the relation between unit sections and assessment references.
UNIT_SECTION_REFERENCE_ID	Unique identifier for the unit section.
REFERENCE_CODE_TYPE	This column stores reference code type of a unit section.
REFERENCE_CODE	This column stores reference code of a unit section.
REFERENCE_CODE_DESC	This column stores the description of the reference code of a unit section.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_USEC_RPT_COND	This entity describes the Repeat Conditions for a Unit Section. Case and Seed document: PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc - Obsolete
Column Name	Descritpion
UNIT_SECTION_REPT_CONDITION_ID	Unique identifier for the repeat conditions for a unit section.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UOO_ID	Unique unit section identifier.
REPEATABLE_IND	Repeatable indicator
SAME_TEACHING_PERIOD	Same teaching period indicator.
MAX_REPEATS_FOR_CREDIT	Maximum number of unit section repeat for credit.
MAX_REPEATS_FOR_FUNDING	Maximum repeat of unit section for funding.
MAX_REPEAT_CREDIT_POINTS	Maximum credit points for repeat of unit section.
SAME_TEACH_PERIOD_REPEATS	Same teaching period repeats for unit section repeat conditions.
SAME_TEACH_PERIOD_REPEATS_CP	Credit points of same teaching period repeats.

Student System - IGS_PS_USEC_RPT_FMLY	To capture the Repeat Family for a Unit Section
Column Name	Descritpion
UNIT_SECTION_REPEAT_FAMILY_ID	Unique identifier repeat family for a unit section.
UOO_ID	Unique identifier for the unit section.
REPEAT_FAMILY_UNIT_CD	Unit code of the repeat family.
REPEAT_FAMILY_VERSION_NUMBER	Version number of the repeat family unit code.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_USEC_SPNSRSHP	Entity to capture the Sponsorship Information for a Unit Section.
Column Name	Descritpion
UNIT_SECTION_SPONSORSHIP_ID	Unique identifier for the sponsorship information for a unit section.
UOO_ID	Unique identifier for unit section
ORGANIZATION_CODE	Sponsoring organizational unit code
SPONSORSHIP_PERCENTAGE	Percentage of sponsorship
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_USEC_STATUS
Column Name	Descritpion
STATUS_CODE
DESCRIPTION
OPEN_FOR_ENROLLMENTS
SYSTEM_CALCULATED
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Student System - IGS_PS_USEC_TCH_RESP	To capture the Teaching Responsibilities for a Unit Section
Column Name	Descritpion
UNIT_SECTION_TEACH_RESP_ID	Unique identifier of the teaching responsibilities for a unit section.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INSTRUCTIONAL_LOAD_LAB	Instructional Workload for laboratory
INSTRUCTIONAL_LOAD_LECTURE	Instructional Workload for lecture
UOO_ID	Unique identifier for unit section.
INSTRUCTOR_ID	Unique identifier for the Instructor.
CONFIRMED_FLAG	Indicates instructor is confirmed for teaching responsibility.
PERCENTAGE_ALLOCATION	Percentage allocated for the instructor.
INSTRUCTIONAL_LOAD	Load on the instructor.
LEAD_INSTRUCTOR_FLAG	Indicates the lead instructor for the unit section.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_USEC_WLST_PRF	Entity to capture the Waitlist Preferences for a Unit Section.
Column Name	Descritpion
UNIT_SEC_WAITLIST_PREF_ID	Unique identifier for the waitlist preferences for a unit section.
LAST_UPDATE_LOGIN	Standard Who column
UNIT_SEC_WAITLIST_PRIORITY_ID	Unique identifier for the unit section waitlist priority.
PREFERENCE_ORDER	Order of the preference.
PREFERENCE_CODE	Unit section waitlist preference code.
CREATION_DATE	Standard Who column
PREFERENCE_VERSION	Unit section waitlist preference version.
CREATED_BY	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_USEC_WLST_PRI	This entity describes the Waitlist Priorities for a Unit Section
Column Name	Descritpion
UNIT_SEC_WAITLIST_PRIORITY_ID	Unique identifier for the waitlist priorities for a unit section.
UOO_ID	Unique identifier for unit section.
UNIT_SECTION_LIMIT_WAITLIST_ID	Unique identifier for the unit section waitlist limit. Case and Seed document: PS204_Inheritance_i2c_2520994_CS_DP1.doc - Obsolete
PRIORITY_NUMBER	Unit section priority number
PRIORITY_VALUE	Unit section priority value
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_USEC_X_UNITS	To capture the Cross Listed Units
Column Name	Descritpion
UNIT_SEC_CROSS_UNITS_ID	Unique identifier for the cross listed units.
UOO_ID	Unique identifier for unit section
CROSS_LISTED_UNIT_CD	Code of the cross listed unit
CROSS_LISTED_VERSION_NUMBER	Version number of the cross listed unit
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_USEC_X_USEC	Entity to capture the Cross Listed Unit Sections.
Column Name	Descritpion
UNIT_SEC_CROSS_UNIT_SEC_ID	Unique identifier for the cross listed unit sections.
PARENT_UOO_ID	Unique identifier for the parent unit section.
CHILD_UOO_ID	Unique identifier for the child unit section.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_VER_NOTE	This entity describes mappings of notes to program versions.
Column Name	Descritpion
COURSE_CD	Unique identifier for the program for that the program version note is being specified.
VERSION_NUMBER	Unique identifier for the version of the program for that the program version note is being specified.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REFERENCE_NUMBER	Identifies the reference number of a particular note.
CRS_NOTE_TYPE	An institution-defined note type relating to a program. Note types may be defined for any purpose. For example institutions may define Handbook note types as items for publication in the institution's official handbook.

Student System - IGS_PS_VER_RU	Program version rules
Column Name	Descritpion
COURSE_CD	Code of the program version being offered.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the program version rule.
S_RULE_CALL_CD	Rule call name
RUL_SEQUENCE_NUMBER	Rule name rule sequence number
CREATED_BY	Standard Who column

Student System - IGS_PS_UNIT_CATEGORY_ALL	This entity describes the categories, which are applied to a unit. There may be multiple categories for each unit.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
UNIT_CD	Code of a unit assigned to the unit category.
VERSION_NUMBER	Version number of a unit assigned to a unit category.
UNIT_CAT	An institution-defined unit category.

Student System - IGS_PS_UNIT_LEVEL_ALL	This entity describes the available university unit levels.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
UNIT_LEVEL	Normal year level of the unit. For example, 1 - a first year unit within a program, 2 - a second year unit within a program.
DESCRIPTION	Explanation of the unit level.
WAM_WEIGHTING	Weighting attributed to the unit level for the purposes of calculating weighted average marks ( WAM).
CLOSED_IND	Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records.

Student System - IGS_PS_UNIT_LVL_ALL	This entity describes the level of a unit within a particular university program type. This value will override the default value stored against the unit.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
COURSE_CD	Program code for what the unit level for a unit code is overridden for a unit code.
COURSE_VERSION_NUMBER	Program version number
UNIT_CD	Code of the unit for that the level is specified.
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
COURSE_TYPE	Program type for that the unit level is specified. Enables the definition of different year levels for a unit when undertaken in programs of different types. --Obsoleted
UNIT_LEVEL	Unit level assigned to a unit when it is undertaken in a program of a specified type.
WAM_WEIGHTING	Describes the weighting of the program unit level for the purposes of a weighted average mark calculation.

Student System - IGS_PS_UNIT_LVL_HIST_ALL	This entity describes the history of changes to a unit version's program unit level.
Column Name	Descritpion
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Oracle username of the person who created the history record.
UNIT_LEVEL	Describes the available university levels. For example, 1 - A first year unit within a program, 2 - A second year unit within a program.
WAM_WEIGHTING	Describes the weighting of the program unit level for the purposes of a weighted average mark calculation.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating Unit Identifier
COURSE_CD	Program code for what the unit level for a unit code is overridden for a unit code.
COURSE_VERSION_NUMBER	Program version number
UNIT_CD	Code used to identify the unit.
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
COURSE_TYPE	Describes the type of programs offered by the university. Program type is an element defined by DETYA, however, the system is not limited to the DETYA list. DETYA element reference 310. For example, 01 Higher Doctorate, 20 Diploma. --O

Student System - IGS_PS_UNIT_OFR_OPT_ALL	This entity describes the available options for each unit offering.
Column Name	Descritpion
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record.
PROGRAM_ID	Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
ORG_ID	Operating unit identifier
OWNER_ORG_UNIT_CD	The responsible organization unit for the unit section
LOCATION_CD	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
ATTENDANCE_REQUIRED_IND	Indicator to control the unit sections for which Attendance self service rosters are produced for faculty to enter/report Attendance Hours as per the date aliases set in Academic Record
UNIT_CLASS	Institution-defined code that identifies a unit class.
RESERVED_SEATING_ALLOWED	If value is 'Y' then Reserved seating will be allowed otherwise Reserved seating will not be allowed. (Default value 'Y')
SPECIAL_PERMISSION_IND	Indicates if special permission is required for the unit
UOO_ID	Unique identifier for a unit offering option.
SS_DISPLAY_IND	Excludes unit from displaying in unit search windows in self service enrollments
DIR_ENROLLMENT	Number of students enrolled , class open.
ENR_FROM_WLST	Number of students enrolled from waitlist.
INQ_NOT_WLST	Number of students who attempted to enroll (add unit to cart) but the section was full and waitlist either not offered or offered & student not interested
IVRS_AVAILABLE_IND	Indicator that specifies whether the unit offering option is available for enrollment via the Interactive Voice Response System. Setting the indicator ticked enables students using the IVR System to enroll in the unit offering option.
REV_ACCOUNT_CD	Revenue Account Code (An alpha numeric string) . It is populated with the revenue account code when GL is not installed and system uses any other external account systems
ANON_UNIT_GRADING_IND	Anonymous Unit Grading Y / N
ANON_ASSESS_GRADING_IND	Anonymous Assessment Item Grading Y / N
NON_STD_USEC_IND	Indicates whether the Unit Section is Standard or Non Standard
AUDITABLE_IND	Indicates if the unit can be audited
CALL_NUMBER	Unique identifier needed to support Interactive Voice Response registration.
AUDIT_PERMISSION_IND	Indicates if permission is required to audit
NOT_MULTIPLE_SECTION_FLAG	Indicating whether this unit section should be excluded from multiple unit section.
SUP_UOO_ID	The superior unit section's identifier for this unit section.
RELATION_TYPE	Indicate whether this unit section is superior,subordinate or none of above.
DEFAULT_ENROLL_FLAG	Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled.
UNIT_SECTION_STATUS	Status of unit section occurrence. For example, planned, inactive.
ABORT_FLAG	Flag to indicate whether the Unit Section is ABORTED.
UNIT_SECTION_START_DATE	Start date of unit section is specified.
UNIT_SECTION_END_DATE	End date of unit section is specified.
ENROLLMENT_ACTUAL	Number of students enrolled in that unit section.
UNIT_CD	Unique identifier of the unit being offered.
WAITLIST_ACTUAL	Number of students waitlisted in that unit section.
OFFERED_IND	Indicator that specifies whether the unit offering option is available for offering. Setting the checkbox ticked makes the offering available.
STATE_FINANCIAL_AID	Indicator for eligibility of the unit section to qualify for state financial aid funding.
GRADING_SCHEMA_PRCDNCE_IND	Indicator that specifies whether any grading schema attached to the unit offering option takes precedence over the grading schema attached to the enrolled student's program offering.
VERSION_NUMBER	Version number of the unit being offered. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated.
FEDERAL_FINANCIAL_AID	Indicator for eligibility of the unit section to qualify for federal financial aid funding.
UNIT_QUOTA	An enrollment quota that restricts the number of students who might be enrolled in a particular unit offering.
UNIT_QUOTA_RESERVED_PLACES	Subset of the enrollment quota that is presently reserved.
INSTITUTIONAL_FINANCIAL_AID	Indicator for eligibility of the unit section to qualify for institutional financial aid funding.
CAL_TYPE	Calendar type in that the unit is offered. Units can only be offered in instances of calendar types that are categorized as teaching calendars.
GRADING_SCHEMA_CD	Code that identifies the grading schema. A grading schema describes the set of available marks and grades that can be used in the assessment of student unit attempts. There can be multiple grading schemas for any one institution.
GS_VERSION_NUMBER	System generated number used to identify the version of the grading schema.
UNIT_CONTACT	Person identification number of a staff member who is the contact for a particular unit offering.
SS_ENROL_IND	Self Service Enrollment Indicator
CREATED_BY	Standard Who column

Student System - IGS_PS_UNIT_OFR_PAT_ALL	This entity describes the offering pattern of a unit offering option.
Column Name	Descritpion
CI_SEQUENCE_NUMBER	Sequence number of the calendar instance for the unit offering pattern. The sequence number is the unique identifier of the calendar instance.
CI_START_DT	Start date of the teaching calendar instance that applies to the unit offering pattern. It is the date from that the calendar instance becomes effective.
CI_END_DT	End date of the teaching calendar instance that applies to the unit offering pattern. It is the date from that the calendar instance is no longer effective. For example, teaching period semester 1 1996,might end on 30/6/96.
WAITLIST_ALLOWED	Indicator to show whether waitlist is allowed for the unit or not.
MAX_STUDENTS_PER_WAITLIST	Maximum number of students who can be waitlisted is shown.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record.
PROGRAM_ID	Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
ORG_ID	Operating unit identifier
DELETE_FLAG	Delete flag denotes whether this unit offering pattern is logically deleted or not.
UNIT_CD	Unit code the unit offering pattern applies to. A unit code is an institution-defined unique identifier of unit of study.
ABORT_FLAG	Flag to indicate whether the Unit Offering Pattern is ABORTED.
VERSION_NUMBER	Version of the unit the unit offering pattern applies to. Students are normally enrolled in the current version. Prior versions of the unit are end-dated.
CAL_TYPE	Calendar type of the calendar instance in that the unit is offered. Units can only be offered in instances of calendars categorized as Teaching calendars.

Student System - IGS_PS_UNIT_REF_HIST_ALL	This entity describes the history of changes to a unit version's reference codes.
Column Name	Descritpion
UNIT_CD	Code used to identify the unit.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
REFERENCE_CD_TYPE	Describes the types of reference codes that are applied to the program offering options.
REFERENCE_CD	Other System reference code for a unit. For example, an IVRS code used to represent a unit.
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Oracle username of the person who created the history record.
DESCRIPTION	Description, or name, of the unit reference code.

Student System - IGS_PS_UNIT_VER_ALL	This entity describes a version of a unit, which is offered by the university.
Column Name	Descritpion
UNIT_CD	Unique identifier of the unit.
TITLE_OVERRIDE_IND	Indicator that specifies whether the title of the unit can be overridden at the student unit attempt level. Setting the checkbox ticked allows the title to be overridden.
ABBREVIATION	Abbreviated name of the unit.
UNIT_LEVEL	Normal year level of the unit.
CREDIT_POINT_DESCRIPTOR	Institution's name for credit points.
ENROLLED_CREDIT_POINTS	Number of credit points in that the student is considered to be enrolled.
POINTS_OVERRIDE_IND	Indicator that specifies whether it is possible to override the number of credit points awarded upon successful completion on the unit. Setting the checkbox ticked allows the enrolled credit points and the enrolled EFTSU to be overridden.
SUPP_EXAM_PERMITTED_IND	Indicator that specifies whether a supplementary examination or other supplementary assessment can be granted in this unit. Setting the checkbox ticked allows supplementary assessment to be granted.
COORD_PERSON_ID	Person identification number of the unit coordinator.
OWNER_ORG_UNIT_CD	Code of the organizational unit that owns the unit.
OWNER_OU_START_DT	Date on that the owning organizational unit became current.
VERSION_NUMBER	Version number of the unit. Students are normally enrolled in the current version. Prior versions are end-dated.
AWARD_COURSE_ONLY_IND	Indicator that specifies whether the unit is available only to award program students. Setting the checkbox ticked restricts enrollment to award program students.
RESEARCH_UNIT_IND	Indicator that specifies whether the unit is classified as a research unit. Setting the checkbox ticked classifies the unit as research. Research units are normally only available to students enrolled in research programs.
SUB_UNIT_ALLOWED_IND	Indicator that specifies whether this unit can be classified as a sub-unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a sub-unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_
SUP_UNIT_ALLOWED_IND	Indicator that specifies whether this unit can be classified as a superior unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a superior unit. Case and Seed document: PS202_SuperiorStructure_PS_30
INDUSTRIAL_IND	Indicator that specifies whether the unit is classified as an industrial experience unit.
PRACTICAL_IND	Indicator that specifies whether the unit is classified as a practical experience unit.
REPEATABLE_IND	Indicator that specifies whether the unit can count more than once towards the satisfaction of program requirements. Setting the checkbox ticked enables a student to repeat an already passed unit.
ASSESSABLE_IND	Indicator that specifies whether the unit is assessed. Setting the checkbox ticked indicates that the unit is assessed.
ACHIEVABLE_CREDIT_POINTS	Number of credit points awarded upon successful completion of the unit.
POINTS_INCREMENT	If the override credit points indicator is set, this field records the allowable credit point increment.
START_DT	Date on that this version of the unit became current.
POINTS_MIN	If the override credit point indicator is set, this field records the minimum number of credit points that can be awarded upon successful completion of the unit.
POINTS_MAX	If the override credit point indicator is set, this field records the maximum number of credit points that can be awarded upon successful completion of the unit.
UNIT_INT_COURSE_LEVEL_CD	Internal program level grouping of the unit.
SUBTITLE	Obsolete - Subordinate name
SUBTITLE_MODIFIABLE_FLAG	Sub Title modifiable or not indicator
APPROVAL_DATE	Approval date
LECTURE_CREDIT_POINTS	Lecture credit points
LAB_CREDIT_POINTS	Laboratory credit points
OTHER_CREDIT_POINTS	Other credit points
CLOCK_HOURS	Clock hours
BILLING_CREDIT_POINTS	Audit Credit Points
WORK_LOAD_CP_LECTURE	Lecture work load credit point
WORK_LOAD_CP_LAB	Lab workload credit points
CONTINUING_EDUCATION_UNITS	Continuing education units
ENROLLMENT_EXPECTED	Expected enrollment
ENROLLMENT_MINIMUM	Minimum enrollment
ENROLLMENT_MAXIMUM	Maximum enrollment
ADVANCE_MAXIMUM	Maximum waitlist in advance
REVIEW_DT	Date on that this version of the unit is due for review.
STATE_FINANCIAL_AID	State financial aid
FEDERAL_FINANCIAL_AID	Federal financial aid
INSTITUTIONAL_FINANCIAL_AID	Institutional financial aid
SAME_TEACHING_PERIOD	Same teaching period indicator
MAX_REPEATS_FOR_CREDIT	Number of maximum repeats for credits
MAX_REPEATS_FOR_FUNDING	Number of maximum repeats for funding
MAX_REPEAT_CREDIT_POINTS	Maximum repeat credit points
SAME_TEACH_PERIOD_REPEATS	Same teaching period repeats
SAME_TEACH_PERIOD_REPEATS_CP	Same teaching period repeats credit points
IVR_ENROL_IND	IVR Enrollment Indicator
CLAIMABLE_HOURS	The maximum hours that a student in a class can claim
ANON_UNIT_GRADING_IND	Anonymous Unit Grading Y / N
ANON_ASSESS_GRADING_IND	Anonymous Assessment Item Grading Y / N
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
SS_ENROL_IND	Self Service Enrollment Indicator
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
ATTRIBUTE6	Descriptive Flexfield segment
ATTRIBUTE7	Descriptive Flexfield segment
ATTRIBUTE8	Descriptive Flexfield segment
EXPIRY_DT	Date on that the unit version expires. Students already studying this unit version may remain enrolled. No further enrollments are normally allowable.
ATTRIBUTE9	Descriptive Flexfield segment
ATTRIBUTE10	Descriptive Flexfield segment
ATTRIBUTE11	Descriptive Flexfield segment
ATTRIBUTE12	Descriptive Flexfield segment
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
END_DT	Date on that this version of the unit ends. No students can remain enrolled in unit after its end date has been reached.
ATTRIBUTE16	Descriptive Flexfield segment
ATTRIBUTE17	Descriptive Flexfield segment
ATTRIBUTE18	Descriptive Flexfield segment
ATTRIBUTE19	Descriptive Flexfield segment
ATTRIBUTE20	Descriptive Flexfield segment
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_STATUS	Institution-defined status of a unit that maps to a system unit status.
ORG_ID	Operating unit identifier
SUBTITLE_ID	This field is Foreign key to IGS_PS_UNIT_SUBTITLE. It indicates the subtitle identifier for subtitle associated with the unit
WORK_LOAD_OTHER	Work load for any component other than lecture and laboratory.
CONTACT_HRS_LECTURE	Contact Hours for Lecture.
CONTACT_HRS_LAB	Contact hours for Laboratory
CONTACT_HRS_OTHER	Contact hours for any component other than lecture and laboratory.
BILLING_HRS	Billable Credit Points
NON_SCHD_REQUIRED_HRS	Non Scheduled Required Hours
FIN_AID_CP	Financial Aid Credit Points - Obsolete
FIN_AID_HRS	Financial Aid Hours - Obsolete
TITLE	Title of the unit.
EXCLUDE_FROM_MAX_CP_LIMIT	Excludes a unit's achievable credit points from counting in a student's maximum credit points limit.
RECORD_EXCLUSION_FLAG	Excludes unit from displaying in self service records windows and on transcripts, and excludes unit from GPA calculations
SS_DISPLAY_IND	Excludes unit from displaying in unit search windows in self service enrollments.
CAL_TYPE_ENROL_LOAD_CAL	Load Calendar type associated with Teaching Period in which unit was last offered and has actual enrollment > 0
SEQUENCE_NUM_ENROL_LOAD_CAL	Load Calendar Instance associated with Teaching Period in which unit was last offered and has actual enrollment > 0
CAL_TYPE_OFFER_LOAD_CAL	Load Calendar associated with Teaching Period in which unit was last offered. Sections which were offered and subsequently cancelled will be included in this field.
SEQUENCE_NUM_OFFER_LOAD_CAL	Load Calendar Instance associated with Teaching Period in which unit was last offered. Sections which were offered and subsequently cancelled will be included in this field.
CURRICULUM_ID	Master unit Identifier. Links different versions of unit when then unit code changes.
OVERRIDE_ENROLLMENT_MAX	This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased.
RPT_FMLY_ID	Indicates the repeat family to which the unit belongs.
SHORT_TITLE	Short name of the unit.
UNIT_TYPE_ID	Indicates the unit program type level to which the unit belongs.
SPECIAL_PERMISSION_IND	Indicates if special permission is required for the unit
REV_ACCOUNT_CD	Revenue Account Code (An alpha numeric string) . It is populated with the revenue account code when GL is not installed and system uses any other external account systems
AUDITABLE_IND	Indicates if the unit can be audited
AUDIT_PERMISSION_IND	Indicates if permission is required to audit
MAX_AUDITORS_ALLOWED	Indicates maximum number of auditors allowed
OVRD_WKLD_VAL_FLAG	Override workload validation flag
WORKLOAD_VAL_CODE	Workload validation type

Student System - IGS_PS_UNIT_VER_HIST_ALL	This entity describes the history of changes to a unit version.
Column Name	Descritpion
EXPIRY_DT	Date on the unit version expires. Students already studying this unit version can remain enrolled. No further enrollments are normally allowable.
CONTACT_HRS_LECTURE	Contact Hours for Lecture.
END_DT	Date on that this version of the unit closed. No students can be enrolled in a closed unit version.
CONTACT_HRS_LAB	Contact hours for Laboratory
UNIT_STATUS	Institution-defined status of a unit that maps to a system unit status.
CONTACT_HRS_OTHER	Contact hours for any component other than lecture and laboratory.
TITLE	The title of the unit.
BILLING_HRS	Billable Credit Points
SHORT_TITLE	The short name of the unit.
NON_SCHD_REQUIRED_HRS	Non Scheduled Required Hours
TITLE_OVERRIDE_IND	An indicator that specifies whether the title of the unit can be overridden at the student unit attempt level. Setting the checkbox ticked allows the title to be overridden.
FIN_AID_CP	Financial Aid Credit Points - Obsolete
ABBREVIATION	Abbreviated name of the unit.
FIN_AID_HRS	Financial Aid Hours - Obsolete
UNIT_LEVEL	Normal year level of the unit.
EXCLUDE_FROM_MAX_CP_LIMIT	Excludes a unit's achievable credit points from counting in a student's maximum credit points limit.
UL_DESCRIPTION	Explanation of the unit level.
RECORD_EXCLUSION_FLAG	Excludes unit from displaying in self service records windows and on transcripts, and excludes unit from GPA calculations
CREDIT_POINT_DESCRIPTOR	Institution's name for credit points.
SS_DISPLAY_IND	Excludes unit from displaying in unit search windows in self service enrollments.
CAL_TYPE_ENROL_LOAD_CAL	Load Calendar type associated with Teaching Period in which unit was last offered and has actual enrollment > 0
ENROLLED_CREDIT_POINTS	Number of credit points in that the student is considered to be enrolled.
SEQUENCE_NUM_ENROL_LOAD_CAL	Load Calendar Instance associated with Teaching Period in which unit was last offered and has actual enrollment > 0
CAL_TYPE_OFFER_LOAD_CAL	Load Calendar associated with Teaching Period in which unit was last offered. Sections which were offered and subsequently cancelled will be included in this field.
SEQUENCE_NUM_OFFER_LOAD_CAL	Load Calendar Instance associated with Teaching Period in which unit was last offered. Sections which were offered and subsequently cancelled will be included in this field.
CURRICULUM_ID	Master unit Identifier. Links different versions of unit when then unit code changes.
OVERRIDE_ENROLLMENT_MAX	This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased.
RPT_FMLY_ID	Indicates the repeat family to which the unit belongs.
REPEAT_CODE	Repeat code
UNIT_TYPE_ID	Indicates the unit program type level to which the unit belongs.
LEVEL_CODE	The unit program type level code for unit
POINTS_OVERRIDE_IND	Indicator that specifies whether it is possible to override the number of credit points awarded upon successful completion on the unit. Setting the checkbox ticked allows the number of credit points to be overridden.
ADVANCE_MAXIMUM	Maximum waitlist in advance
UNIT_CD	Code used to identify the unit.
APPROVAL_DATE	Approval date
SUPP_EXAM_PERMITTED_IND	Indicator that specifies whether a supplementary examination or other supplementary assessment can be granted in this unit. Setting the checkbox allows supplementary assessment to be granted.
BILLING_CREDIT_POINTS	Audit Credit Points
COORD_PERSON_ID	Person identification number of the unit coordinator.
CONTINUING_EDUCATION_UNITS	Continuing education units
OWNER_ORG_UNIT_CD	Code of the organizational unit that owns the unit.
ENROLLMENT_EXPECTED	Expected enrollment
OWNER_OU_START_DT	Date on that the owning organizational unit became current.
ENROLLMENT_MAXIMUM	Maximum enrollment
OU_DESCRIPTION	Description of an organizational unit. An organizational unit is a business unit of an institution or organization. Common organizational units in tertiary institutions are faculties, schools, departments, and divisions.
ENROLLMENT_MINIMUM	Minimum enrollment
AWARD_COURSE_ONLY_IND	Indicator that specifies whether the unit is available only to award program students. Setting the checkbox ticked restricts enrollment to award program students.
FEDERAL_FINANCIAL_AID	Federal financial aid
RESEARCH_UNIT_IND	Indicator that specifies whether the unit is classified as a research unit. Setting the checkbox ticked classifies the unit as research.
INSTITUTIONAL_FINANCIAL_AID	Institutional financial aid
SUB_UNIT_ALLOWED_IND	Indicator that specifies whether this unit can be classified as a sub-unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a sub-unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_
LAB_CREDIT_POINTS	Laboratory credit points
SUP_UNIT_ALLOWED_IND	Indicator that specifies whether this unit can be classified as a superior unit in a superior or sub unit relationship. Setting the checkbox allows the unit to be a superior unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_
LECTURE_CREDIT_POINTS	Lecture credit points
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
INDUSTRIAL_IND	Indicator that specifies whether the unit is classified as an industrial experience unit.
MAX_REPEATS_FOR_CREDIT	Number of maximum repeats for credits
PRACTICAL_IND	Indicator that specifies whether the unit is classified as a practical experience unit.
MAX_REPEATS_FOR_FUNDING	Number of maximum repeats for funding
REPEATABLE_IND	Indicator that specifies whether the unit can count more than once towards the satisfaction of program requirements. Setting the checkbox ticked enables a student to repeat an already passed unit.
MAX_REPEAT_CREDIT_POINTS	Maximum repeat credit points
ASSESSABLE_IND	Indicator that specifies whether the unit is assessed. Setting the checkbox ticked indicates that the unit is assessed.
CLOCK_HOURS	Clock hours
OTHER_CREDIT_POINTS	Other credit points
ACHIEVABLE_CREDIT_POINTS	Number of credit points awarded upon successful completion of the unit.
SAME_TEACHING_PERIOD	Same teaching period indicator
SAME_TEACH_PERIOD_REPEATS	Same teaching period repeats
POINTS_INCREMENT	Where the override credit point indicator is set, this field records the allowable credit point increment.
SAME_TEACH_PERIOD_REPEATS_CP	Same teaching period repeats credit points
STATE_FINANCIAL_AID	State financial aid
POINTS_MIN	Where the override credit point indicator is set, this field records the minimum number of credit points that can be awarded upon successful completion of the unit.
WORK_LOAD_CP_LAB	Lab workload credit points
HIST_START_DT	Effective start date and time of the history record.
WORK_LOAD_CP_LECTURE	Lecture work load credit point
POINTS_MAX	Where the override credit point indicator is set, this field records the maximum number of credit points that can be awarded upon successful completion of the unit.
SUBTITLE_MODIFIABLE_FLAG	Sub Title modifiable or not indicator
SUBTITLE	Obsolete - Subordinate name
UNIT_INT_COURSE_LEVEL_CD	Internal program level grouping of the unit for WEFTSU purposes. WEFTSU is equal to EFTSU multiplied by discipline funding index then multiplied by unit program level factor.
SPECIAL_PERMISSION_IND	Indicates if special permission is required for the unit
CLAIMABLE_HOURS	The maximum hours that a student in a class can claim
UICL_DESCRIPTION	Description, or name, of the unit internal program level. Internal program levels are used in the determination of WEFTSU.
SS_ENROL_IND	Self Service Enrollment Indicator
AUDITABLE_IND	Indicates if unit can be audited
IVR_ENROL_IND	IVR Enrollment Indicator
AUDIT_PERMISSION_IND	Indicates if permission is required to audit
MAX_AUDITORS_ALLOWED	Indicates maximum number of auditors allowed
OVRD_WKLD_VAL_FLAG	Override workload validation flag
HIST_END_DT	Effective end date and time of the history record.
WORKLOAD_VAL_CODE	Workload validation type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
HIST_WHO	Oracle username of the person who created the history record.
ORG_ID	Operating unit identifier
START_DT	Date on that this version of the unit became current.
SUBTITLE_ID	It indicates the subtitle identifier for subtitle associated with the unit
REVIEW_DT	Date on that this version of the unit is due for review.
WORK_LOAD_OTHER	Work load for any component other than lecture and laboratory.

Student System - IGS_PS_UNT_DSCP_HIST_ALL	This entity describes the history of changes to a unit version's unit discipline.
Column Name	Descritpion
UNIT_CD	Code used to identify the unit.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
ORG_ID	Operating unit identifier
DISCIPLINE_GROUP_CD	Describes the discipline group to that a unit of study is classified by the institution.
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Updated by person at the time of the history.
PERCENTAGE	Describes the percentage allocation of unit discipline for a unit.

Student System - IGS_PS_UNT_INLV_HIST_ALL	This entity describes the history of changes for a unit internal program level.
Column Name	Descritpion
WEFTSU_FACTOR	Factor associated with the internal program level grouping used in the determination of weighted equivalent full time student Units.
CLOSED_IND	Indicator that specifies if the unit internal program level is open or closed. Setting the checkbox to closed ticked prevents use of the internal program level in new or modified records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
UNIT_INT_COURSE_LEVEL_CD	Describes the internal program level code for WEFTSU unit grouping.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Oracle username of the person who created the history record.
DESCRIPTION	Description, or name, of the unit internal program level. Internal program levels are used in the determination of WEFTSU.

Student System - IGS_PS_USEC_OCCURS_ALL	This entity describes the Occurrences of a Unit Section
Column Name	Descritpion
UNIT_SECTION_OCCURRENCE_ID	Unique identifier for unit section occurrence.
START_TIME	Start time of the unit section occurrence.
END_TIME	End time of the unit section occurrence.
BUILDING_CODE	Building in that the unit section occurrences.
ROOM_CODE	Room in that the unit section occurrences.
SCHEDULE_STATUS	Status of the unit section occurrence.
STATUS_LAST_UPDATED	Last time in that the status of the unit section occurrence is updated.
INST_NOTIFY_IND	Indicates whether Instructor of Unit section should be notified of change in unit section details
NOTIFY_STATUS	Notification Status
ATTRIBUTE_CATEGORY	Standard DFF Column
ATTRIBUTE1	Standard DFF Column
ATTRIBUTE2	Standard DFF Column
ATTRIBUTE3	Standard DFF Column
UOO_ID	Unit section identifier
ATTRIBUTE4	Standard DFF Column
ATTRIBUTE5	Standard DFF Column
ATTRIBUTE6	Standard DFF Column
ATTRIBUTE7	Standard DFF Column
ATTRIBUTE8	Standard DFF Column
ATTRIBUTE9	Standard DFF Column
ATTRIBUTE10	Standard DFF Column
ATTRIBUTE11	Standard DFF Column
ATTRIBUTE12	Standard DFF Column
ATTRIBUTE13	Standard DFF Column
ATTRIBUTE14	Standard DFF Column
MONDAY	Indicates class is conducted on Monday.
ATTRIBUTE15	Standard DFF Column
ATTRIBUTE16	Standard DFF Column
ATTRIBUTE17	Standard DFF Column
ATTRIBUTE18	Standard DFF Column
ATTRIBUTE19	Standard DFF Column
ATTRIBUTE20	Standard DFF Column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
TUESDAY	Indicates class is conducted on Tuesday.
LAST_UPDATE_LOGIN	Standard Who column
ERROR_TEXT	Error text from the scheduling.
REQUEST_ID	Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record.
PROGRAM_ID	Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
ORG_ID	Operating unit identifier
WEDNESDAY	Indicates class is conducted on Wednesday.
DEDICATED_BUILDING_CODE	Column to store the Dedicated Building Identifier
DEDICATED_ROOM_CODE	Column to store the Dedicated Room ID
PREFERRED_BUILDING_CODE	Column to store the Preferred Building ID
PREFERRED_ROOM_CODE	Column to store the Preferred Room ID
START_DATE	Unit Section Occurrence Start Date
END_DATE	Unit Section Occurrence End Date
TO_BE_ANNOUNCED	Flag for Unit Section Occurrence
INSTRUCTOR_ID	Identifier of the Instructor.
PREFERRED_REGION_CODE	User Preferred Region code for the Unit Section Occurrence
NO_SET_DAY_IND	Indicator to indicate the unit section occurrence is a no set day unit section occurrence or not. No set day unit section occurrence doesn't require scheduling information like (Building, Room etc.) e.g. web programs.
THURSDAY	Indicates class is conducted on Thursday.
CANCEL_FLAG	Flag to indicate the unit section occurrence is requested for cancel.
OCCURRENCE_IDENTIFIER	Unique identity for an occurrence within a unit section.
ABORT_FLAG	Flag to indicate whether the occurrence is ABORTED.
FRIDAY	Indicates class is conducted on Friday.
SATURDAY	Indicates class is conducted on Saturday.
SUNDAY	Indicates class is conducted on Sunday.

Student System - IGS_PS_VER_ALL	This entity describes the versions of programs which are offered by the university, covering both award and non-award programs.
Column Name	Descritpion
RESPONSIBLE_OU_START_DT	Start date of the organizational unit responsible for the program version.
GOVT_SPECIAL_COURSE_TYPE	Code that identifies programs of special interest.
QUALIFICATION_RECENCY	Time period in years for that other studies can be recognized for the purpose of granting advanced standing in this program.
EXTERNAL_ADV_STND_LIMIT	Maximum amount of advanced standing that can be granted in the program for studies undertaken outside the institution.
INTERNAL_ADV_STND_LIMIT	Maximum amount of advanced standing that can be granted in the program for previous studies undertaken at the institution.
CONTACT_HOURS	Minimum number of contact hours required for completion of the program.
CREDIT_POINTS_REQUIRED	Minimum number of credit points required to complete program requirements.
GOVT_COURSE_LOAD	Aggregate equivalent full time student units value for a program, expressed in tenths For example, 3.0 is represented as 30.
STD_ANNUAL_LOAD	Number of credit points that constitute an annual full-time enrollment.
COURSE_TOTAL_EFTSU	The total effective full time student units for the program.
STD_FT_COMPLETION_TIME	OBSOLETE. Value that indicates the standard time to complete the requirements of the program on a full time basis.
STD_PT_COMPLETION_TIME	OBSOLETE. Value that indicates the standard time to complete the requirements of the program on a part time basis.
MAX_INTRMSN_DURATION	Describes the maximum duration in months for any single period of intermission.
NUM_OF_UNITS_BEFORE_INTRMSN	Number of units a student must complete before being allowed a period of intermission.
COURSE_CD	Code used to identify the program in that the student is enrolled.
MIN_SBMSN_PERCENTAGE	Contains the percentage of the total effective full time days that must be attained prior to submission of a research thesis. This detail applies only to research programs.
MAX_CP_PER_TEACHING_PERIOD	Maximum credit points per teaching period
APPROVAL_DATE	Approval date
EXTERNAL_APPROVAL_DATE	External approval date
RESIDENCY_CP_REQUIRED	Residency credit points required
STATE_FINANCIAL_AID	Is the financial aid funded by the state.
FEDERAL_FINANCIAL_AID	Is the financial aid funded by the federation.
INSTITUTIONAL_FINANCIAL_AID	Is the financial aid funded by the institution.
VERSION_NUMBER	Version number of the program. There can only be one version of a program with a system status of Active and an unset Expiry Date.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column.
ATTRIBUTE1	Attribute for descriptive Flexfield
START_DT	Date on that the program version became current.
ATTRIBUTE2	Attribute for descriptive Flexfield
ATTRIBUTE3	Attribute for descriptive Flexfield
ATTRIBUTE4	Attribute for descriptive Flexfield
ATTRIBUTE5	Attribute for descriptive Flexfield
REVIEW_DT	Date on that the program version is due for review. No automatic closure or rollover is implied by this date.
ATTRIBUTE6	Attribute for descriptive Flexfield
ATTRIBUTE7	Attribute for descriptive Flexfield
EXPIRY_DT	Date on that the program version expires. Students already enrolled can remain in an expired program version. New students are not normally enrolled in an expired program version.
ATTRIBUTE8	Attribute for descriptive Flexfield
ATTRIBUTE9	Attribute for descriptive Flexfield
ATTRIBUTE10	Attribute for descriptive Flexfield
ATTRIBUTE11	Attribute for descriptive Flexfield
END_DT	Date on that the program version is completely ended. All students will have completed or been transferred to other versions. No more students can be enrolled in the version.
ATTRIBUTE12	Attribute for descriptive Flexfield
ATTRIBUTE13	Attribute for descriptive Flexfield
COURSE_STATUS	Institution-defined program status that indicates the level of activity of the program version. A program must be established with a status equivalent to the system program status of Planned.
ATTRIBUTE14	Attribute for descriptive Flexfield
ATTRIBUTE15	Attribute for descriptive Flexfield
ATTRIBUTE16	Attribute for descriptive Flexfield
ATTRIBUTE17	Attribute for descriptive Flexfield
ATTRIBUTE18	Attribute for descriptive Flexfield
ATTRIBUTE19	Attribute for descriptive Flexfield
ATTRIBUTE20	Attribute for descriptive Flexfield
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TITLE	Title or full name of the program.
SHORT_TITLE	Short title of the program version.
ORG_ID	Operating unit identifier
ABBREVIATION	Abbreviated program version name.
MIN_CP_PER_CALENDAR	The minimum credit points to be taken by student and is critical to control minimum load required for certain students cohorts for federal financial assistance recipients and intercollegiate athletes
REV_ACCOUNT_CD	Revenue Account Code (An alpha numeric string) . It is populated with the revenue account code when GL is not installed and system uses any other external account systems
PRIMARY_PROGRAM_RANK	Primary Program Rank, Higher the Value , Lower the Rank
MAX_WLST_PER_STUD	Maximum waitlists allowed per student
ANNUAL_INSTRUCTION_TIME	Annul Instruction Time of the program measured in weeks.
SUPP_EXAM_PERMITTED_IND	Indicator that specifies whether or not supplementary examinations or other assessment can be undertaken by students enrolled in this program. Setting the checkbox ticked allows supplementary assessment to be granted.
GENERIC_COURSE_IND	Indicator that specifies whether the program is generic. Students do not normally graduate from a generic program, but after a period of enrollment possibly one semester, or a year transfer to one of its constituent programs.
GRADUATE_STUDENTS_IND	Indicator that describes whether or not students may graduate from the program. The indicator is typically not set for non-award programs or generic programs.
COUNT_INTRMSN_IN_TIME_IND	Indicator that specifies whether or not to count the duration of a student's intermission when checking the maximum time allowed to complete a program.
INTRMSN_ALLOWED_IND	Indicator that specifies whether or not intermission is allowed for this program version. Setting the checkbox ticked allows intermission.
COURSE_TYPE	Institution-defined program type. Program type indicates the type of higher education program.
RESPONSIBLE_ORG_UNIT_CD	Code of the organizational unit responsible for the program version.

Student System - IGS_PS_VER_HIST_ALL	This entity describes the history of changes to a program version.
Column Name	Descritpion
HIST_END_DT	Effective end date and time of the history record.
FEDERAL_FINANCIAL_AID	Is the financial aid funded by the federation.
HIST_WHO	Updated by person at the time of the history.
INSTITUTIONAL_FINANCIAL_AID	Is the financial aid funded by the institution.
START_DT	Date on that the program version became current.
MAX_CP_PER_TEACHING_PERIOD	Maximum credit points per teaching period
REVIEW_DT	Date on that the program version is due for review. No automatic closure or rollover is implied by this date.
RESIDENCY_CP_REQUIRED	Residency credit points required
EXPIRY_DT	Date on that the program version expires. Students already enrolled may remain in an expired program version. New students are not normally enrolled in an expired program version.
STATE_FINANCIAL_AID	Is the financial aid funded by the state.
END_DT	Date on that the program version is completely ended. All students will have completed or been transferred to other versions. No more students can be enrolled in the version.
PRIMARY_PROGRAM_RANK	Primary Program Rank Higher the Value , Lower the Rank
COURSE_STATUS	Institution-defined program status that indicates the level of program.
TITLE	Full name of the program.
MAX_WLST_PER_STUD	Maximum waitlists allowed per student
SHORT_TITLE	Short title of the program version.
ANNUAL_INSTRUCTION_TIME	Annul Instruction Time of the program measured in weeks.
ABBREVIATION	Abbreviated program version name.
SUPP_EXAM_PERMITTED_IND	Indicator that specifies whether or not supplementary examinations or other assessment can be undertaken by students enrolled in this program. Setting the checkbox ticked allows supplementary assessment to be granted.
GENERIC_COURSE_IND	Indicates whether the program is a generic program. Students in a generic program can transfer to any of the programs in the related group at any point during their enrollment.
GRADUATE_STUDENTS_IND	Describes whether or not students may graduate after completing this program. Setting the checkbox ticked enables students to graduate upon completion of program requirements. The indicator is not set for non-award programs.
COUNT_INTRMSN_IN_TIME_IND	Indicator that specifies whether or not to count the duration of a student's intermission when checking the maximum time allowed to complete a program.
INTRMSN_ALLOWED_IND	Indicates whether intermission is allowed for this program version.
COURSE_TYPE	Institution-defined program type. Program type indicates the type of higher education program. Each program type must map to a government program type.
CT_DESCRIPTION	Description of the institution-defined program type.
RESPONSIBLE_ORG_UNIT_CD	Unique code of the organizational unit responsible for this program version.
RESPONSIBLE_OU_START_DT	Start date of the organizational unit responsible for this program version.
OU_DESCRIPTION	Description of an organizational unit. An organizational unit is a business unit of an institution or organization. Common organizational units in tertiary institutions are faculties, schools, departments, and divisions.
GOVT_SPECIAL_COURSE_TYPE	Code that identifies programs of special interest.
GSCT_DESCRIPTION	Description of the government special program type.
QUALIFICATION_RECENCY	The time period in years for that other studies will be recognized for the purpose of granting advanced standing in this program.
EXTERNAL_ADV_STND_LIMIT	Maximum amount of advanced standing that can be granted in the program for studies undertaken outside the institution.
INTERNAL_ADV_STND_LIMIT	Maximum amount of advanced standing that can be granted in the program for studies undertaken at the institution.
CONTACT_HOURS	Minimum number of contact hours required for completion of the program.
CREDIT_POINTS_REQUIRED	The minimum number of credit points required to complete program requirements.
GOVT_COURSE_LOAD	Aggregate effective full time student units value for a program, expressed in tenths.
STD_ANNUAL_LOAD	Describes the load in credit points that a full-time student would normally study in a year if enrolled in the program. This is used to calculate the relative weighting of the units.
COURSE_TOTAL_EFTSU	The total equivalent full time student units for the program.
STD_FT_COMPLETION_TIME	OBSOLETE. Code that indicates the standard time to complete the requirements of the program on a full time basis. For example 30 is equal to 3 years. Not in current use.
STD_PT_COMPLETION_TIME	OBSOLETE. Code that indicates the standard time to complete the requirements of the program on a part time basis. For example, 60 is equal to 6 years. Not in current use.
MAX_INTRMSN_DURATION	Describes the maximum intermission duration in months.
NUM_OF_UNITS_BEFORE_INTRMSN	The number of units a student must complete before being allowed intermission.
MIN_SBMSN_PERCENTAGE	Contains the percentage of the total effective full time days that must be attained prior to submission of a research thesis. This detail applies only to research programs.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
COURSE_CD	Describes the program code.
MIN_CP_PER_CALENDAR	The minimum credit points to be taken by student and is critical to control minimum load required for certain students cohorts for federal financial assistance recipients and intercollegiate athletes .
VERSION_NUMBER	Version number of the program. There can only be one version of a program with a system status of active and an unset expiry date.
APPROVAL_DATE	Approval Date
HIST_START_DT	Effective start date and time of the history record.
EXTERNAL_APPROVAL_DATE	External Approval Date

Student System - IGS_RE_CAND_SEO_CLS	This field describes the links between a candidature and one or more Socio-Economic Objectives.
Column Name	Descritpion
PERSON_ID	Describes the person identifier number that uniquely identifies a person
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
SEO_CLASS_CD	Describes the socio-economic objective applicable to the research candidature
PERCENTAGE	Describes the percentage of the research effort applying to the objective. Two classifications are represented within a single structure.

Student System - IGS_RE_CDT_FLD_OF_SY	This table describes the links to field(s) of study from a research candidature. There may be multiple links split by percentage.
Column Name	Descritpion
PERSON_ID	Describes the person identifier number that uniquely identifies a person
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
FIELD_OF_STUDY	Describes the field of study applicable to the candidature. Two classifications are represented within a single structure.
PERCENTAGE	Describes the percentage of the candidature effort applying to the nominated field of study. The percentage entered must total 100% at all times.

Student System - IGS_RE_GV_FLD_OF_SDY	This entity describes the Government set of fields of study.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GOVT_FIELD_OF_STUDY	The unique identifier for the Government defined field of study. A field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program.
DESCRIPTION	Describes the Government field of study
RES_FCD_CLASS_IND	Indicates and specifies if it is a government classification code
CLOSED_IND	Indicates and specifies if the Government field of study is open or closed. Selecting the check box to 'closed' prevents use of the Government field of study in new or modified field of study records.

Student System - IGS_RE_GV_SEO_CLS_CD	This field describes the government Socio-Objective Classifications applied to the candidature.
Column Name	Descritpion
GOVT_SEO_CLASS_CD	A code representing the government socio-economic objective classification
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Describes the government socio-economic objective classification
RES_FCD_CLASS_IND	Indicates and specifies if the socio-economic objective classification is a government classification or not
CLOSED_IND	Indicates and specifies if the classification code is open or closed from future use. Selecting the check box closes the record.

Student System - IGS_RE_GV_TOA_CLS_CD	This table describes the government 'Type of Activity' classification codes that are attributed to research candidatures.
Column Name	Descritpion
GOVT_TOA_CLASS_CD	A code describing the type of research and development activity
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Describes one of the types of research and development activity
CLOSED_IND	Indicates and specifies if the record is open or closed. Selecting the check box closes the record.

Student System - IGS_RE_SEO_CLASS_CD	This table describes the user-defined Socio-Economic Objective classifications. These must be mapped onto one the current government classifications.
Column Name	Descritpion
SEO_CLASS_CD	Describes the institution-defined socio-economic classification code
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GOVT_SEO_CLASS_CD	Describes the government socio-economic objective classification that the institution-defined value is mapped onto
DESCRIPTION	Describes the institution-defined socio-economic classification code
CLOSED_IND	Indicates and specifies if the classification code is open or closed. Selecting the checkbox closes the record and prevents its use in new or modified records.

Student System - IGS_RE_SPRVSR	This entity describes a research student's supervisor.
Column Name	Descritpion
CA_PERSON_ID	Describes the candidate person identifier number.
REPLACED_PERSON_ID	Describes the unique person ID of the replaced supervisor allowing creation and maintenance of a supervision history for the candidature
REPLACED_SEQUENCE_NUMBER	Describes the unique identifier of the supervisor being replaced
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
PERSON_ID	Describes the person identifier number of the research supervisor
COMMENTS	Describes any comments relating to the supervision arrangements between the candidate and supervisor
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SEQUENCE_NUMBER	Uniquely defines the research supervisor for a person identifier number
START_DT	Describes the date a supervisor becomes effective for the student candidature
END_DT	If recorded, this field indicates the date of which the person stopped supervising the candidate
RESEARCH_SUPERVISOR_TYPE	Describes the supervisor type. For example, include principal supervisor, associate supervisor, external supervisor.
SUPERVISOR_PROFESSION	Describes the supervisor's profession
SUPERVISION_PERCENTAGE	Describes the supervision percentage of the person. This is entered for the purposes of calculating the research load incurred by supervisors within an institution.
FUNDING_PERCENTAGE	Describes the percentage of the research load that is apportioned for funding purposes to the specified organizational unit.
ORG_UNIT_CD	Describes the organizational unit code for whom the supervisor is working when performing the supervision
OU_START_DT	Describes the organizational unit start date

Student System - IGS_RE_SPRVSR_TYPE	This entity describes the various types of supervisors for research students.
Column Name	Descritpion
RESEARCH_SUPERVISOR_TYPE	Describes the available types of supervisors for research students
DESCRIPTION	This field provides an explanation of the research supervisor type.
PRINCIPAL_SUPERVISOR_IND	Describes if the supervisor type represents a principal supervisor. This can control that items of correspondence the supervisor is sent.
CLOSED_IND	Indicates and specifies if the supervisor type is open or closed. Selecting the checkbox closes the record and prevents further use in new or modified records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RE_S_RES_CAL_CON	This entity gives us information about the System Research Calendar Configuration.
Column Name	Descritpion
S_CONTROL_NUM	Stores a number, that can uniquely identify a research calendar configuration
EFFECTIVE_STRT_DT_ALIAS	Contains the alias for the effective start date of a research teaching calendar. The equivalent full time days for a research teaching period is determined by the number of days between the research effective start and end date aliases.
EFFECTIVE_END_DT_ALIAS	Contains the alias for the effective end date of a research teaching calendar. The equivalent full time days for a research teaching period is determined by the number of days between the research effective start and end date aliases.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RE_THESIS_EXAM	This entity describes the thesis examination and its actions
Column Name	Descritpion
PERSON_ID	Describes the person identifier number of the research candidate whose thesis is under examination
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
THE_SEQUENCE_NUMBER	Describes the thesis sequence number
CREATION_DT	Describes the date the panel was created for the thesis examination
SUBMISSION_DT	Describes the date that the thesis was submitted for examination
THESIS_EXAM_TYPE	Describes the type of examination which is being undertaken. For example, written, performance, oral.
THESIS_PANEL_TYPE	Describes the type of panel used for the thesis examination
TRACKING_ID	The system generated identification number of the tracking item associated with the thesis examination process
THESIS_RESULT_CD	Describes the thesis result that is an outcome of the panel members having provided their recommended results
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_RE_THS_EXAM_TYPE	This table describes the type of thesis examination which can be undertaken. eg. Written, performance, oral.
Column Name	Descritpion
THESIS_EXAM_TYPE	Describes the thesis examination type. For example, written, performance, oral.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Describes the thesis examination type
CLOSED_IND	Indicates and specifies if the thesis exam type is open or closed. Selecting the check box closes the thesis exam type and prevents further examinations of this type.

Student System - IGS_RE_THS_PNL_MBR	This entity describes the selected members of a thesis panel.
Column Name	Descritpion
CA_PERSON_ID	Describes the candidate person identifier number who is the subject of the examination
PAID_DT	The date the panel member was paid
TRACKING_ID	The system generated identification number of the tracking item associated with contact with the thesis panel member
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
THE_SEQUENCE_NUMBER	Describes the thesis sequence number
CREATION_DT	Describes the thesis examination creation date
RECOMMENDATION_SUMMARY	Contains a summary of the examiner's comments in support of their recommended result
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Describes the person identifier number of the examiner
PANEL_MEMBER_TYPE	Describes the role of the panel member
CONFIRMED_DT	Describes the date the thesis panel member was selected to become a member of the thesis panel
DECLINED_DT	Indicates that the proposed panel member has declined the place on the panel
ANONYMITY_IND	Indicates and specifies if the panel member has requested anonymity. Selecting the indicator means that the panel member wishes to remain anonymous as far as the candidate is concerned.
THESIS_RESULT_CD	Contains the recommended result submitted by the examiner of the thesis

Student System - IGS_RE_THS_PNL_TYPE	This table describes the types of thesis panels which can be used for thesis examinations.
Column Name	Descritpion
THESIS_PANEL_TYPE	Describes the type of thesis panel
DESCRIPTION	Describes the thesis panel type
SELECTION_CRITERIA	Describes textually the selection criteria for members of the examination pane. For example, include required qualifications, years of experience.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CLOSED_IND	Indicates and specifies if the thesis panel type is open or closed. Selecting the check box closes the thesis panel type and prevents further thesis examinations being assigned the thesis panel type.
RECOMMENDED_PANEL_SIZE	The recommended size of the relevant type of thesis examination panel
TRACKING_TYPE	Describes the tracking type to be used for tracking of thesis examination processes and documents. Only tracking types that have been mapped to the system tracking type of RES_TEX provide functionality.

Student System - IGS_RE_CANDIDATURE_ALL	This entity describes the candidature details of a research student.
Column Name	Descritpion
PERSON_ID	Describes the candidate person identification number
GOVT_TYPE_OF_ACTIVITY_CD	Describes the Government type of activity code that best reflects the research undertaken by the candidate
SEQUENCE_NUMBER	Describes a unique sequence number used to
MAX_SUBMISSION_DT	Describes the latest date the thesis can be submitted. This system derived value can be overridden.
MIN_SUBMISSION_DT	Describes the earliest date the thesis can be submitted. This system date can be overridden.
SCA_COURSE_CD	Describes the student program attempt program code within the research is being performed. This link is populated when a student is pre-enrolled in a new program attempt.
RESEARCH_TOPIC	Describes the broad research topic of the candidature. More detailed descriptions are entered against the thesis details. This field is required for candidature details.
INDUSTRY_LINKS	Describes any industries associated with the thesis
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record
PROGRAM_ID	Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
ORG_ID	Operating unit identifier
ACAI_ADMISSION_APPL_NUMBER	Describes the admissions application number from that the candidature originated
ACAI_NOMINATED_COURSE_CD	Describes the admissions nominated program code from that the candidature originated
ACAI_SEQUENCE_NUMBER	Describes the admissions application sequence number that resulted in the candidature
ATTENDANCE_PERCENTAGE	Describes the current attendance percentage of the candidate. The attendance percentage represents the total attendance of the research candidature and program work unit attempts. Default percentages for each attendance type are entered in

Student System - IGS_RE_CDT_ATT_HIST_ALL	This table describes the history of the attendance of a research student for the duration of their candidature. It stores details of both attendance type and attendance percentage details in a consolidated view.
Column Name	Descritpion
PERSON_ID	Describes the person identifier number for whom the history is entered
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating Unit Identifier
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
SEQUENCE_NUMBER	Describes an unique identifier for the candidature attendance history
HIST_START_DT	Describes the start date and time of the attendance history.
HIST_END_DT	Describes the end date and time of the attendance history
ATTENDANCE_TYPE	Describes the attendance type represented in the history
ATTENDANCE_PERCENTAGE	Describes the attendance percentage represented in the history.

Student System - IGS_RE_CDT_HIST_ALL	This entity describes the history of a candidature. The histories are stored with an effective start and end date during which the details applied.
Column Name	Descritpion
GOVT_TYPE_OF_ACTIVITY_CD	Describes the government code describing the type of research activity that is being performed by the candidate.
PERSON_ID	Describes the candidate person identification number
MAX_SUBMISSION_DT	Describes the latest date a thesis can be submitted. This date, if selected, will override the value derived by the system.
MIN_SUBMISSION_DT	Describes the earliest date a thesis can be submitted. This date, if selected, will override the value derived by the system.
SEQUENCE_NUMBER	Describes a unique sequence number used to differentiate between different candidatures, where a student has more than one.
HIST_START_DT	The effective start date and time of the history record.
HIST_END_DT	The effective end date and /time of the history record.
HIST_WHO	The 'updated by' person at the time of the history
RESEARCH_TOPIC	Describes the broad research topic of the candidature. More detailed descriptions are entered against the thesis details.
INDUSTRY_LINKS	Describes any industries associated with the thesis
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
SCA_COURSE_CD	Describes the student program attempt program code within that the research is being performed. This link is populated when a student is pre-enrolled in a new program attempt.
ACAI_ADMISSION_APPL_NUMBER	Describes the admissions application number from that the candidature originated.
ACAI_NOMINATED_COURSE_CD	Describes the admissions nominated program code from that the candidature originated.
ACAI_SEQUENCE_NUMBER	Describes the admissions application sequence number that resulted in the candidature.
ATTENDANCE_PERCENTAGE	Describes the attendance percentage value of the student. For example, a part time student can have a 30% attendance.

Student System - IGS_RE_DFLT_MS_SET_ALL	This entity describes the default milestones for a research course
Column Name	Descritpion
COURSE_CD	Describes the program code to that the default milestones apply
VERSION_NUMBER	Describes the program version to that the default milestones apply
COMMENTS	Provides any comments about the default milestone set
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
MILESTONE_TYPE	Describes the type of default milestone
ATTENDANCE_TYPE	The code of an institution-defined attendance type. An attendance type identifies if a student is classified as part-time or full-time in the program, based on their study load in the reference year.
ATTENDANCE_MODE	Code of an institution-defined attendance mode
SEQUENCE_NUMBER	Describes the system generated number to make a unique milestone set
OFFSET_DAYS	Describes the number of days the default milestone will be offset from the candidate's commencement date

Student System - IGS_RE_SCHL_TYPE_ALL	This entity describes user-defined scholarship types that can be requested at admission e.g. Co-operative, DEET Industry Postgraduate Award (external), Churchill Memorial Scholarship (external)
Column Name	Descritpion
SCHOLARSHIP_TYPE	The unique code to identify scholarship types. These must be mapped either to an organization unit or to a person identifier number.
DESCRIPTION	Provides an explanation of the scholarship type
ORG_UNIT_CD_FROM	The code for the organization unit providing the scholarship
OU_START_DT_FROM	The date from which the organizational unit is effective. The organizational unit is uniquely identified by the combination of its code and start date.
PERSON_ID_FROM	The unique identification code of the person providing the scholarship
CLOSED_IND	Indicates and specifies if the scholarship type is open or closed. Selecting the check box closes the scholarship type and prevents new or modified scholarships being assigned the scholarship type.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier

Student System - IGS_RE_SCHOLARSHIP_ALL	This entity describes the details of scholarships
Column Name	Descritpion
PERSON_ID	Describes the unique person identifier number of the candidate
DESCRIPTION	Contains text details of a scholarship
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
SCHOLARSHIP_TYPE	Describes the scholarship type that the candidate has been granted
OTHER_BENEFITS	Describes any other benefits that result from the scholarship. No system functionality is implied.
CONDITIONS	Describes any conditions that must be met to retain the scholarship. For example, maintenance of a minimum rate of progress may be a requirement of the scholarship. No system functionality is implied.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
START_DT	Describes the start date of the scholarship
END_DT	Describes the end date of the scholarship
DOLLAR_VALUE	Describes the currency value of the scholarship, in the case that it is a monetary scholarship

Student System - IGS_RE_THESIS_ALL	This entity describes the thesis details for a research student.
Column Name	Descritpion
PERSON_ID	Describes the person identifier number of the candidate preparing the thesis
THESIS_RESULT_CD	Describes the final result that has been allocated to the thesis. This result must be mapped to a system result of type final.
EXPECTED_SUBMISSION_DT	The date that the thesis is expected to be submitted. This field would be entered once the student had given notification of intention to submit.
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
LIBRARY_LODGEMENT_DT	Contains the date the research students thesis was lodged in the library
LIBRARY_CATALOGUE_NUMBER	Contains the library catalogue number of the thesis
EMBARGO_EXPIRY_DT	The expiry date of any embargo placed on the release of the thesis
SEQUENCE_NUMBER	Describes the sequence number allocated to the thesis to give it uniqueness
THESIS_FORMAT	Describes the format of the thesis
LOGICAL_DELETE_DT	Contains the date the record was logically deleted
TITLE	Describes the title of the research student's thesis
EMBARGO_DETAILS	Records the details of any embargo placed on the release of the thesis
THESIS_TOPIC	Describes the topic of the thesis
CITATION	Contains citation information to be read during a graduation ceremony
COMMENTS	Provides any comments about the thesis for the research student
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
FINAL_TITLE_IND	Indicates and specifies if the nominated title is the final title for the thesis, or a working title. Selecting the check box indicates the thesis title is final.
SHORT_TITLE	Describes the short title of the thesis
ABBREVIATED_TITLE	Contains the abbreviated title of the thesis

Student System - IGS_RE_THESIS_HIST_ALL	This entity describes the history of statuses of a thesis
Column Name	Descritpion
ABBREVIATED_TITLE	Contains the abbreviated title of the thesis
THESIS_RESULT_CD	Describes the final result which has been allocated to the thesis. This result must be mapped to a system result of type final
EXPECTED_SUBMISSION_DT	The date on that the thesis is expected to be submitted. This field would be entered once the student had given notification of intention to submit.
DATE_OF_LIBRARY_LODGEMENT	Contains the date the research student's thesis was lodged in the library
LIBRARY_CATALOGUE_NUMBER	Contains the library catalogue number of the thesis
PERSON_ID	Describes the person identifier number of the candidate preparing the thesis
EMBARGO_EXPIRY_DT	The expiry date of any embargo placed on the release of the thesis
THESIS_FORMAT	Describes the format of the thesis
LOGICAL_DELETE_DT	Contains the date the record was logically deleted
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
SEQUENCE_NUMBER	Describes the sequence number allocated to the thesis to give it uniqueness
HIST_START_DT	The effective start date and time of the history record
EMBARGO_DETAILS	Records the details of any embargo placed on the release of the thesis
THESIS_TOPIC	Describes the topic of the thesis
CITATION	Contains citation information to be read during a graduation ceremony
COMMENTS	Provides any comments about the thesis for the research student
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
HIST_END_DT	The effective end date and time of the history record
HIST_WHO	The 'updated by' person at the time of the history
TITLE	Describes the title of the research student's thesis
FINAL_TITLE_IND	Indicates and specifies if the nominated title is the final title for the thesis, or a working title. Selecting the check box indicates the thesis title is final
SHORT_TITLE	Describes the short title of the thesis

Student System - IGS_RE_THESIS_RESULT_ALL	This table describes the available thesis result codes which can be attributed to panel members, examinations or as final outcomes against a thesis.
Column Name	Descritpion
THESIS_RESULT_CD	The code of an institution-defined thesis result code. Institution-defined codes must be mapped to system equivalents.
DESCRIPTION	Describes an institution-defined thesis result code
COMMENTS	A comments field for entering observations about the context thesis result.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
S_THESIS_RESULT_CD	Select one of the system-defined thesis result codes to map to an equivalent institution value. The system values are as fail, fail-all, minor-rev, no result, pass and rev-major. The system results of minor-rev and rev-major are defined as
CLOSED_IND	Indicates and specifies if the record is open or closed. Selecting the indicator closes the record. Closed thesis results are not able to be allocated to future thesis.

Student System - IGS_RE_THS_EXAM_HIST_ALL	This entity describes the history of statuses of the thesis examination
Column Name	Descritpion
PERSON_ID	Describes the person identifier number of the research candidate whose thesis is under examination
THESIS_PANEL_TYPE	Describes the type of panel used for the thesis examination
TRACKING_ID	The system generated identification number of the tracking item associated with the thesis examination process
THESIS_RESULT_CD	Describes the thesis result that is an outcome of the panel members having returned their recommended outcomes
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
THE_SEQUENCE_NUMBER	Describes the thesis sequence number
CREATION_DT	Describes the date the panel was created for the thesis examination
HIST_START_DT	The effective start date and time of the history record
HIST_END_DT	The effective end date and time of the history record
HIST_WHO	The 'updated by' person at the time of the history
SUBMISSION_DT	Describes the date on the thesis has been submitted for examination
THESIS_EXAM_TYPE	Describes the type of examination that is being undertaken. For example, written, performance, oral.

Student System - IGS_RE_THS_PNL_MR_HS_ALL	This entity describes the history of the selected members of a thesis panel.
Column Name	Descritpion
CA_PERSON_ID	Describes the candidate person identification number who is the subject of the examination
PAID_DT	Records the date the panel member when paid
TRACKING_ID	The system generated identification number of the tracking item associated with contact with the thesis panel member
CA_SEQUENCE_NUMBER	Describes the candidature sequence number
THE_SEQUENCE_NUMBER	Describes the thesis sequence number
CREATION_DT	Describes the thesis examination creation date
RECOMMENDATION_SUMMARY	Contains a summary of the examiner's comments in support of their recommended result
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
PERSON_ID	Describes the person identifier number of the examiner
HIST_START_DT	The effective start date and time of the history record
HIST_END_DT	The effective end date and time of the history record
HIST_WHO	The 'updated by' person at the time of the history
PANEL_MEMBER_TYPE	Describes the role of the panel member
CONFIRMED_DT	Describes the date the thesis panel member was selected to become a member of the thesis panel
DECLINED_DT	Indicates that the proposed panel member has declined the place on the panel
ANONYMITY_IND	Indicates and specifies if the panel member has requested anonymity. Selecting the indicator means that the panel member wishes to remain anonymous as far as the candidate is concerned.
THESIS_RESULT_CD	Contains the recommended result submitted by the examiner of the thesis

Student System - IGS_RE_THS_PNL_MR_TP_ALL	This entity describes the various member types of a thesis examination panel
Column Name	Descritpion
PANEL_MEMBER_TYPE	Describes the various user-defined types of members on a thesis panel. For example, include chair, ordinary, reserve.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
DESCRIPTION	Provides an explanation of the thesis panel member type
PANEL_CHAIR_IND	Describes if a panel member of this type is the chair person of the panel
CLOSED_IND	Indicates and specifies if the thesis panel member type is open or closed. Selecting the check box closes the thesis panel member type and prevents further panel members being assigned the thesis panel member type.
TRACKING_TYPE	Describes the tracking type used to track processes or documents associated with the thesis panel member type

Student System - IGS_RU_CALL	Rule call name
Column Name	Descritpion
SELECT_GROUP	Contains the rule group number
TRUE_MESSAGE	True message
FALSE_MESSAGE	False message
DEFAULT_RULE	Default rule
S_RULE_TYPE_CD	Code of a system rule type
RUG_SEQUENCE_NUMBER	The sequence number of a system rule group.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
S_RULE_CALL_CD	The code of a system rule cal. For example PRG-UFAIL is a system rule used in the calculation of program progression rules based on unit failures or PRG-GPA is a system rule used in the calculation of program progression rules involving a
RUD_SEQUENCE_NUMBER	Sequence number of a system rule

Student System - IGS_RU_CALL_RULE	This table contains system reference codes for rules.
Column Name	Descritpion
CALLED_RULE_CD	Contains a unique rule call code
NR_RUL_SEQUENCE_NUMBER	Contains the called rule number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RU_DESCRIPTION	This entity displays description of rule
Column Name	Descritpion
SEQUENCE_NUMBER	Rule description number
PARENTHESIS_IND	Indicates that parenthesis is to be added when displaying
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
S_RETURN_TYPE	Rule return type
RULE_DESCRIPTION	Holds the definition of the rule as it will be used in the implementation
DESCRIPTION	Holds the comments on the rules
S_TURIN_FUNCTION	Determines the associated turing function

Student System - IGS_RU_GROUP	Rule Group
Column Name	Descritpion
SEQUENCE_NUMBER	Contains the rule group number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GROUP_NAME	Contains the unique group name

Student System - IGS_RU_GROUP_ITEM	Rules Group Items
Column Name	Descritpion
RUG_SEQUENCE_NUMBER	Contains the rule group number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION_NUMBER	Contains the description number
DESCRIPTION_TYPE	Contains the description type like Rud or Rug

Student System - IGS_RU_GROUP_SET	Rule Group Set
Column Name	Descritpion
RUG_SEQUENCE_NUMBER	Contains the rule group number
RUD_SEQUENCE_NUMBER	Contains the rule description number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RU_ITEM	Rule items
Column Name	Descritpion
RUL_SEQUENCE_NUMBER	Rule sequence number
DERIVED_RULE	Derived rule
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ITEM	Item
TURIN_FUNCTION	Turin function name
NAMED_RULE	Named rule pointer
RULE_NUMBER	Rule number
SET_NUMBER	Set number
VALUE	Value

Student System - IGS_RU_LOV	Rule list of values
Column Name	Descritpion
SEQUENCE_NUMBER	Contains a sequence number
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Contains valid rule options. Rule options may be allowable operators, as determined by the Rule Group or Sub Group. like.AND, OR, IF, THEN, ELSE, or may be other rules. By selecting the button next to the partial rule, the desired partial r
HELP_TEXT	Contains the description of the valid rule options. If the option is another rule, the rule description is displayed.
SELECTABLE	Select flag
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_RU_NAMED_RULE	Named rules.
Column Name	Descritpion
RUL_SEQUENCE_NUMBER	Rule sequence number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RUD_SEQUENCE_NUMBER	Rule description number
MESSAGE_RULE	Contains the optional message rule number
RUG_SEQUENCE_NUMBER	Determines the rule group for this rule
RULE_TEXT	Rule text

Student System - IGS_RU_NAMED_RULE_GR	Named Rule Group.
Column Name	Descritpion
GROUP_CD	Group code
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
NAME_CD	Name code
DESCRIPTION	Description about name code
S_RETURN_TYPE	Return type
RUG_SEQUENCE_NUMBER	Determines the rule group of the rule
SELECT_GROUP	Rule group number
MESSAGE_GROUP	Message group number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_USEC_CHARGE	Table for storing the data for additional charges for a Unit Section - Obsolete
Column Name	Descritpion
UOO_ID	This is the Unit Section Id coming from IGS_PS_UNIT_OFR_OPT_ALL
USEC_CHARGE_CODE	This value will come from the IGS_LOOKUPS where the lookup_ type is 'IGS_PS_USEC_CHARGE'
AMOUNT	This field will contain the amount for the Unit Section
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
USEC_CHARGE_ID	This is a sequence generated id.The sequence to be created for this table is IGS_PS_USEC_CHARGE_S.

Student System - IGS_PS_US_UNSCHED_CL	This table contains information about Unit Section Unscheduled Contact List.
Column Name	Descritpion
US_UNSCHEDULED_CL_ID	Unscheduled Contact List ID
INSTRUCTOR_ID	Instructor ID
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
UOO_ID	Unit Offering Option ID ( Unit Section ID )
ACTIVITY_TYPE_ID	Unit Section Activity Type ID
LOCATION_CD	Location ID
BUILDING_ID	Building ID
ROOM_ID	Room ID
NUMBER_OF_STUDENTS	Number of Students
HOURS_PER_STUDENT	Hours per Student
HOURS_PER_FACULTY	Hours per Faculty

Student System - IGS_PS_USEC_RU	This table is used to store Unit Section Version Rules
Column Name	Descritpion
USECRU_ID	Unique identifier for unit section rules
UOO_ID	Unit Section ID
S_RULE_CALL_CD	The Code of a system rule call
RUL_SEQUENCE_NUMBER	Rule Sequence Number
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Student System - IGS_PS_UNIT_SUBTITLE	Describes the subtitles for units.
Column Name	Descritpion
SUBTITLE_ID	Unique sequence generated number, gets value from IGS_PS_UNIT_SUBTITLE_S
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	The code of unit to which subtitle is assigned
VERSION_NUMBER	The version of unit to which subtitle is assigned
SUBTITLE	Another title for the unit
APPROVED_IND	Official subtitle that has been approved by the institution or an organizational unit
CLOSED_IND	The subtitle is available for use or not
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_USEC_CATEGORY	This table records the categories for unit sections.
Column Name	Descritpion
USEC_CAT_ID	Unique sequence generated number, gets value from IGS_PS_USEC_CAT_S
UOO_ID	Unique identifier for unit section to which category is being assigned
UNIT_CAT	An institution-defined unit category. It is used to group units which have a common characteristics
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNT_CRCLM_ALL	Describes the master unit identifier for units.
Column Name	Descritpion
CURRICULUM_ID	Master unit Identifier. Links different versions of unit when then unit code changes. Also required for mandated reporting by some states.
DESCRIPTION	The description for the curriculum id.
CLOSED_IND	This indicates id curriculum id is available for use or not.
ORG_ID	Operating Unit Identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNIT_TYPE_LVL	This table stores the unit program type level code and description. These would be associated with units.
Column Name	Descritpion
UNIT_TYPE_ID	Unique System generated number to identify the repeat details. Populated by IGS_PS_UNIT_TYPE_LVL_S
LEVEL_CODE	Indicates the unit type level to which unit may be assigned.
DESCRIPTION	Description for unit type level
CLOSED_IND	It indicates if the unit program type level code is available for use or not.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_UNITREQREF_CD	This table contains information about Unit Requirements Reference Codes
Column Name	Descritpion
UNIT_REQ_REF_CD_ID	Unit Requirements Reference Code ID
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
UNIT_CD	Unit Code
VERSION_NUMBER	Version Number
REFERENCE_CD_TYPE	Reference Code Type
REFERENCE_CODE	This column stores requirement reference code of a unit version.
REFERENCE_CODE_DESC	This column stores the description of the requirement reference code of a unit version.
REFERENCE_CODE_ID	Reference Code ID- Obsolete
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_PS_UNIT_X_GRP	This table contains information about Unit Cross - Listed Groups
Column Name	Descritpion
UNIT_X_LISTED_GROUP_ID	Unit Cross-Listed Group ID
MAX_OVR_GROUP	Maximum Override Allowed for Unit Cross-Listed Group
UNIT_X_LISTED_GROUP_NAME	Unit Cross-Listed Group Name
LOCATION_INHERITANCE	Location Inheritance Indicator
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
MAX_ENR_GROUP	Maximum Enrollment Allowed for Unit Cross-Listed Group

Student System - IGS_PS_UNIT_X_GRPMEM	This table contains information about Units that are part of the Unit Cross-Listed Group
Column Name	Descritpion
UNIT_X_LISTED_GROUP_MEM_ID	Unit Cross - Listed Group Member ID
LAST_UPDATE_LOGIN	Standard WHO column
UNIT_X_LISTED_GROUP_ID	Unit Cross- Listed Group ID
UNIT_CD	Unit Code
VERSION_NUMBER	Unit Version
PARENT	Parent (Valid Values 'Y', 'N')
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Student System - IGS_PS_USEC_X_GRP	This table contains information about captures Unit Section Cross-Listed Groups.
Column Name	Descritpion
USEC_X_LISTED_GROUP_ID	Unit Section Cross - Listed Group Code
LAST_UPDATE_LOGIN	Standard WHO column
MAX_ENR_GROUP	Maximum Enrollment Allowed for Unit Section Cross-Listed Group
MAX_OVR_GROUP	Maximum Override Allowed for Unit Section Cross-Listed Group
USEC_X_LISTED_GROUP_NAME	Unit Section Cross - Listed Group Name
LOCATION_INHERITANCE	Location Inheritance Indicator
CAL_TYPE	Calendar Type
CI_SEQUENCE_NUMBER	Calendar Instance Sequence Number
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Student System - IGS_PS_USEC_X_GRPMEM	This table contains information about Unit Sections that are part of the Unit Section Cross-Listed Group.
Column Name	Descritpion
USEC_X_LISTED_GROUP_MEM_ID	Unit Section Cross-Listed Group Member ID
USEC_X_LISTED_GROUP_ID	Unit Section Cross-Listed Group ID
UOO_ID	Unit Section ID
PARENT	Parent (Valid Values 'Y', 'N')
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_USO_CLAS_MEET	This table contains all Unit Section Occurrences that are part of the Class Meet Group.
Column Name	Descritpion
CLASS_MEET_ID	Sequence generated number to uniquely identify a Class Meet Group Member.
CLASS_MEET_GROUP_ID	Class Meet Group ID this member belongs to
UNIT_SECTION_OCCURRENCE_ID	OBSOLETE
HOST	Host (Valid Values 'Y', 'N')
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
UOO_ID	Unit Section ID within Meet with Classes Group

Student System - IGS_PS_USO_CM_GRP	This table contains information about all Class Meet Groups created in Oracle Student System.
Column Name	Descritpion
CLASS_MEET_GROUP_ID	Sequence generated number to uniquely identify a Class Meet group.
MAX_ENR_GROUP	Maximum Enrollment Allowed for Meet with Class Group
MAX_OVR_GROUP	Maximum Override Allowed for Meet With Class Group
CLASS_MEET_GROUP_NAME	Class Meet Group Name
CAL_TYPE	Calendar Type
CI_SEQUENCE_NUMBER	Calendar Instance Sequence Number
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_USO_FACILITY	This table contains information about Unit Section Occurrence Facilities.
Column Name	Descritpion
USO_FACILITY_ID	Unit Section Occurrence Facility ID
UNIT_SECTION_OCCURRENCE_ID	Unit Section Occurrence ID
FACILITY_CODE	Facility Code
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_USO_INSTRCTRS	This table contains information about all Unit Section Occurrence Instructors.
Column Name	Descritpion
USO_INSTRUCTOR_ID	Unit Section Occurrence Instructor Sequence ID
UNIT_SECTION_OCCURRENCE_ID	Unit Section Occurrence ID
INSTRUCTOR_ID	Person ( Instructor ) ID
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_US_EM_GRP	This table contains information about Meet With Exam Groups
Column Name	Descritpion
EXAM_MEET_GROUP_ID	Exam Meet Group ID
EXAM_MEET_GROUP_NAME	Exam Meet Group Name
CAL_TYPE	Calendar Type
CI_SEQUENCE_NUMBER	Calendar Instance Sequence Number
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_US_EXAM_MEET	This table contains Unit Sections that are part of the Meet With Exam Group.
Column Name	Descritpion
EXAM_MEET_ID	Exam Meet ID
EXAM_MEET_GROUP_ID	Exam Meet Group ID
UOO_ID	Unit Section ID
HOST	Host (Valid Values 'Y','N')
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_US_REQ_REF_CD	This table contains information about Unit Section Requirements Reference Codes.
Column Name	Descritpion
UNIT_SECTION_REQ_REF_CD_ID	Unit Section Requirements Reference Code ID
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
UNIT_SECTION_REFERENCE_ID	Unit Section Reference ID
REFERENCE_CD_TYPE	Reference Code Type
REFERENCE_CODE	This column stores requirement reference code of a unit section.
REFERENCE_CODE_DESC	This column stores the description of the requirement reference code of a unit section.
REFERENCE_CODE_ID	Reference Code ID -Obsolete
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Student System - IGS_PS_USEC_ACT_TYPE	This table contains information about Unit Section Activity Types
Column Name	Descritpion
ACTIVITY_TYPE_ID	Unit Section Activity Type ID
ACTIVITY_TYPE_CODE	Activity Type Code
ACTIVITY_TYPE_DESCRIPTION	Activity Type Description
CLOSED_IND	Closed Indicator
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PT_CUSTM	This table is used in portal module to store customization parameters
Column Name	Descritpion
CUS_ID	Sequence generated PK
PERSON_ID	The person for whom this customization record exists
CUSTM_NAME	Customization param name
CUSTM_VALUE	Customization param value
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_UNIT_ACCTS_ALL	This table contains revenue account segment values at the unit level
Column Name	Descritpion
UNIT_ACCOUNT_ID	Sequence generated primary key column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Unit code
VERSION_NUMBER	Unit code version number
SEGMENT	GL accounting flex field accounting structure segment name
SEGMENT_NUM	GL accounting flex field structure segment number
SEGMENT_VALUE	GL accounting flex field structure segment value
ORG_ID	Multi Org unit operating ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_USEC_ACCTS_ALL	This table holds revenue account segment values for a unit section
Column Name	Descritpion
USEC_ACCOUNT_ID	Sequence generated primary key column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UOO_ID	Unit offering option ID
SEGMENT	GL Accounting flex field structure segment name
SEGMENT_NUM	GL accounting flexfield structure segment number
SEGMENT_VALUE	GL accounting flexfield structure segment value
ORG_ID	Multi unit operating ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_US_PRENR_CFG	Used for storing pre-enrollment configuration details for Year of Program.
Column Name	Descritpion
SEQUENCE_NO	Used to specify the order of sequence .
UNIT_SET_CD	Unit set code
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
MAPPING_SET_CD	Mapping set code for unit set code.

Student System - IGS_PS_WL_OVER_RESN	This table stores Override reasons, which will be used when Expected workload is overridden.
Column Name	Descritpion
OVERRIDE_REASON	Institution defined Override Reason
DESCRIPTION	Description of Override Reason
CLOSED_IND	Indictor which determines whether the given Override Reason is valid (open) or not
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_RC_IS_ACAD	Holds Self Service Staging Academic Interests
Column Name	Descritpion
INQ_ACAD_ID	Unique Identifier for Inquiry Academic Information
SELFREP_INST_GPA	Self Reported GPA
SELFREP_RANK_IN_CLASS	Self Reported Rank In Class
SELFREP_CLASSSIZE	Self Reported Class Size
SELFREP_TOTAL_CP_EARNED	Self Reported Total Credit Points Earned
STATUS	Status
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
INQ_PERSON_ID	Inquiry Person ID
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INSTITUTION_CD	Institution Code
CURRENT_INST	Current Institution Id
START_DATE	Start Date in this Institution
END_DATE	End Date in this Institution
PLANNED_COMPLETION_DATE	Planned Completion Date
PROGRAM_TYPE_EARNED	Degree Earned
COURSE_MAJOR	Previous Major

Student System - IGS_RC_IS_ADDRESS	Holds Self Service Staging Inquiry Address
Column Name	Descritpion
INQ_ADDR_ID	Unique Address Identifier
COUNTY	County
PROVINCE	Province
COUNTRY	Country
POSTCODE	Postal Code
START_DATE	Start Date for the Address
END_DATE	End Date for the Address
STATUS	Status
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
INQ_PERSON_ID	Inquiry Person ID
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
ADDR_USAGE	Address Usage
ADDR_LINE_1	Address Line 1
ADDR_LINE_2	Address Line 2
ADDR_LINE_3	Address Line 3
ADDR_LINE_4	Address Line 4
CITY	City
STATE	State

Student System - IGS_RC_IS_CONTACT	Holds Self Service Staging Contact records
Column Name	Descritpion
INQ_CONTACT_ID	Unique Identifier for Contact ID
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INQ_PERSON_ID	Inquiry Person ID
PHONE_COUNTRY_CODE	Phone Country Code
PHONE_AREA_CODE	Phone Area Code
PHONE_NUMBER	Phone Number
PHONE_EXTENSION	Phone Extension
PHONE_LINE_TYPE	Phone Line Type
EMAIL_ADDRESS	Email Address
STATUS	Status

Student System - IGS_RC_IS_EXTRACURR	Holds Self Service Staging Extracurricular activities
Column Name	Descritpion
INQ_EXTRACURR_ID	Inquiry Extracurricular Identifier
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
START_DATE	Start Date of the activity
END_DATE	End Date of the activity
INQ_PERSON_ID	Inquiry Person Id
INTEREST_TYPE_CODE	Extracurricular Activity Type
INTEREST_NAME	Extracurricular Activity Name
STATUS	Status
ACTIVITY_SOURCE_CD	Activity Source Code
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Student System - IGS_RC_IS_INFO_REQ	Holds Self Service Staging Information requested records
Column Name	Descritpion
INQ_INFO_REQ_ID	Inquiry Information Required Id
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INQ_INQ_ID	Inquiry Information Id
PACKAGE_ITEM_ID	Foreign Key to Packge Item table
STATUS	Status
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RC_IS_INQUIRY	Holds Self Service Staging Inquiry records
Column Name	Descritpion
INQ_INQ_ID	Unique Identifier for Inquiry Id
ADM_CAL_TYPE	Admission Calendar Type
ADM_CI_SEQUENCE_NUMBER	Admission Calendar Sequence Number
HOW_KNOWUS_ID	How Do You Learn About Us
WHO_INFLUENCED_ID	Who Influenced Your Decision
COMMENTS	Comments
STATUS	Status
IMP_SOURCE_TYPE_ID	Import Source Type Id
INQUIRY_SOURCE_TYPE_ID	Inquiry Source Type Id
ATTRIBUTE_CATEGORY	Attribute Category For Descriptive Flex field
ATTRIBUTE1	Descriptive Flex Field Column
INQ_PERSON_ID	Inquiry Person Id
ATTRIBUTE2	Descriptive Flex Field Column
ATTRIBUTE3	Descriptive Flex Field Column
ATTRIBUTE4	Descriptive Flex Field Column
ATTRIBUTE5	Descriptive Flex Field Column
ATTRIBUTE6	Descriptive Flex Field Column
ATTRIBUTE7	Descriptive Flex Field Column
ATTRIBUTE8	Descriptive Flex Field Column
ATTRIBUTE9	Descriptive Flex Field Column
ATTRIBUTE10	Descriptive Flex Field Column
ATTRIBUTE11	Descriptive Flex Field Column
INQ_ENTRY_STAT_ID	Inquiry Entry Status Id
ATTRIBUTE12	Descriptive Flex Field Column
ATTRIBUTE13	Descriptive Flex Field Column
ATTRIBUTE14	Descriptive Flex Field Column
ATTRIBUTE15	Descriptive Flex Field Column
ATTRIBUTE16	Descriptive Flex Field Column
ATTRIBUTE17	Descriptive Flex Field Column
ATTRIBUTE18	Descriptive Flex Field Column
ATTRIBUTE19	Descriptive Flex Field Column
ATTRIBUTE20	Descriptive Flex Field Column
CREATED_BY	Standard Who Column
INQ_ENTRY_LEVEL_ID	Inquiry Entry Level Id
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
SOURCE_PROMOTION_ID	Storing the identifier for OMO campaigns or events
INQUIRY_DATE	Inquiry Date
EDU_GOAL_ID	Education Goal Id
SCHOOL_OF_INTEREST_ID	School Of Interest Id
ACAD_CAL_TYPE	Academic Calendar Type
ACAD_CI_SEQUENCE_NUMBER	Academic Calendar Sequence Number

Student System - IGS_RC_IS_PER_ALL	Holds Self Service Staging Inquiry person
Column Name	Descritpion
ORG_ID	Multi-Org Id
BIRTH_DT	Birth Date
SEX	Gender
ETHNIC_ORIGIN	Ethnic Origin ID
CITIZENSHIP1_ID	Citizenship ID - 1
CITIZENSHIP2_ID	Citizenship ID - 2
STATUS	Status
IMP_SOURCE_TYPE_ID	Import Source Type ID
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
INQ_PERSON_ID	Inquiry Person ID
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
GIVEN_NAME	Given Name
MIDDLE_NAME	Middle Name
SURNAME	Last Name
PREFERRED_GIVEN_NAME	Preferred Given Name
TITLE	Title
SUFFIX	Suffix
PRE_NAME_ADJUNCT	Prefix

Student System - IGS_RC_IS_TEST	Holds Self Service Staging Inquiry Test records
Column Name	Descritpion
INQ_TEST_ID	Test Identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INQ_PERSON_ID	Inquiry Person Id
ADMISSION_TEST_TYPE	Admission Test Type
COMP_TEST_SCORE	Composite Test Score
TEST_DATE	Test Date
STATUS	Status
TEST_SOURCE_ID	Test Source Identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_RC_IS_TESTSEG	Holds Self Service Staging Inquiry Test Segments
Column Name	Descritpion
INQ_TEST_SEG_ID	Unique Id for Test Segment
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INQ_TEST_ID	Inquiry Test Identifier
TEST_SEGMENT_ID	Test Segment ID
TEST_SCORE	Test Score
STATUS	Status
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_RC_I_APPL_ALL	Describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information.
Column Name	Descritpion
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COMMENTS	Additional information relating to the enquiry
ORG_ID	Organization ID
INQ_ENTRY_LEVEL_ID	Unique Identifier for Entry Level
EDU_GOAL_ID	Unique Identifier for Educational Goal
PARTY_ID	Unique Identifier for Organization Unit related to Inquiry School of Interest
HOW_KNOWUS_ID	Unique Identifier for How Do You Know Us
WHO_INFLUENCED_ID	Unique Identifier for Who Influenced your decision
ATTRIBUTE_CATEGORY	Attribute Category For Descriptive Flex field
ENQUIRY_APPL_NUMBER	Number identifying the Inquiry made by a person
ATTRIBUTE1	Descriptive Flex Field Column
ATTRIBUTE2	Descriptive Flex Field Column
ATTRIBUTE3	Descriptive Flex Field Column
ATTRIBUTE4	Descriptive Flex Field Column
ATTRIBUTE5	Descriptive Flex Field Column
ATTRIBUTE6	Descriptive Flex Field Column
ATTRIBUTE7	Descriptive Flex Field Column
ATTRIBUTE8	Descriptive Flex Field Column
ATTRIBUTE9	Descriptive Flex Field Column
ATTRIBUTE10	Descriptive Flex Field Column
SALES_LEAD_ID	Foreign Key to Sales Leads table
ATTRIBUTE11	Descriptive Flex Field Column
ATTRIBUTE12	Descriptive Flex Field Column
ATTRIBUTE13	Descriptive Flex Field Column
ATTRIBUTE14	Descriptive Flex Field Column
ATTRIBUTE15	Descriptive Flex Field Column
ATTRIBUTE16	Descriptive Flex Field Column
ATTRIBUTE17	Descriptive Flex Field Column
ATTRIBUTE18	Descriptive Flex Field Column
ATTRIBUTE19	Descriptive Flex Field Column
ATTRIBUTE20	Descriptive Flex Field Column
ACAD_CAL_TYPE	Describes the academic calendar type that the admission enquiry application relates
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record.
ACAD_CI_SEQUENCE_NUMBER	A unique number that identifies the academic calendar instance that the enquiry application refers to
PROGRAM_ID	Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
ADM_CAL_TYPE	Describes the admission calendar type that the admission enquiry application applies
ADM_CI_SEQUENCE_NUMBER	A unique number that identifies the admission calendar instance that the enquiry application refers to
ENQUIRY_DT	Describes the date the enquiry was made
REGISTERING_PERSON_ID	Person who registered the enquiry
OVERRIDE_PROCESS_IND	Describes if the to force the processing of an incomplete package for the person. If selected, it will override any limitations placed on the processing routine.
INDICATED_MAILING_DT	Describes the promised mailing date of the enquiry to be used as an alert when packages are not mailed in satisfactory time frames
LAST_PROCESS_DT	Describes the latest processing date of the enquiry

Student System - IGS_RC_I_APPL_INT	Holds admission inquiry instance interface records.
Column Name	Descritpion
INTERFACE_INQ_APPL_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
INQUIRY_STATUS	Inquiry Status. 'MAILED', 'INQUIRED'
INQUIRY_DT	Inquiry Date
INQUIRY_SOURCE_TYPE	Inquiry Source Type. 'Web Inquiry'
INQUIRY_ENTRY_STATUS_ID	Inquiry Status(First time freshman, transfer, new graduate)
INQUIRY_ENTRY_LEVEL_ID	Inquiry Entry Level. First year, second year, junior , senior
REGISTERING_PERSON_ID	Registering Person Identifier
OVERRIDE_PROCESS_IND	Override Process Indicator.
INDICATED_MAILING_DT	Indicated Mailing Date
INTERFACE_ID	Interface Identifier
LAST_PROCESS_DT	Last Processed Date
COMMENTS	Comments
EDU_GOAL_ID	Educational Career Goal. Medicine, business, law
INQUIRY_SCHOOL_OF_INTEREST_ID	Inquiry School Of Interest
LEARN_SOURCE_ID	Inquiry Learning Source
SALES_LEAD_ID	Used internally by the import process for processing inquiry child records
INFLUENCE_SOURCE_ID	Inquiry Influence Id
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' -- Match reviewed and do not import
ERROR_CODE	Error Code
ATTRIBUTE_CATEGORY	Descriptive flex field structure defining column
ENQUIRY_APPL_NUMBER	Enquiry Application Number
ATTRIBUTE1	Descriptive flex field segment Column
ATTRIBUTE2	Descriptive flex field segment Column
ATTRIBUTE3	Descriptive flex field segment Column
ATTRIBUTE4	Descriptive flex field segment Column
ATTRIBUTE5	Descriptive flex field segment Column
ATTRIBUTE6	Descriptive flex field segment Column
ATTRIBUTE7	Descriptive flex field segment Column
ATTRIBUTE8	Descriptive flex field segment Column
ATTRIBUTE9	Descriptive flex field segment Column
ATTRIBUTE10	Descriptive flex field segment Column
ACAD_CAL_TYPE	Academic Calendar type in which the Inquiry is made
ATTRIBUTE11	Descriptive flex field segment Column
ATTRIBUTE12	Descriptive flex field segment Column
ATTRIBUTE13	Descriptive flex field segment Column
ATTRIBUTE14	Descriptive flex field segment Column
ATTRIBUTE15	Descriptive flex field segment Column
ATTRIBUTE16	Descriptive flex field segment Column
ATTRIBUTE17	Descriptive flex field segment Column
ATTRIBUTE18	Descriptive flex field segment Column
ATTRIBUTE19	Descriptive flex field segment Column
ATTRIBUTE20	Descriptive flex field segment Column
ACAD_CI_SEQUENCE_NUMBER	Academic Sequence Number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
SOURCE_PROMOTION_ID	Storing the identifier for OMO campaigns or events
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
ADM_CAL_TYPE	Admission Calendar Type
ERROR_TEXT	Error Text
PERSON_ID	Person Identifier. This column will be populated by the import process
ADM_CI_SEQUENCE_NUMBER	Admission Calendar Sequence Number

Student System - IGS_RC_I_A_CHARTYP	Stores the type of enquiry made by a person.
Column Name	Descritpion
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ENQUIRY_APPL_NUMBER	Number identifying the enquiry made by a person
ENQUIRY_CHARACTERISTIC_TYPE	Describes the user-defined types of characteristic of an enquiry. Examples are school leaver, TAFE graduate, domestic, international.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_RC_I_A_ITYPE	Describes the types of information requested with an enquiry
Column Name	Descritpion
PERSON_ID	Describes the ID code that uniquely identifies a person
ENQUIRY_APPL_NUMBER	Number identifying the enquiry made by a person
INFO_TYPE_ID	Foreign Key to Package Item table
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RC_I_A_PKGITM	Stores the details of enquiry package.
Column Name	Descritpion
PERSON_ID	Describes the ID code that uniquely identifies a person
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record
PROGRAM_ID	Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
ENQUIRY_APPL_NUMBER	Number identifying the inquiry made by a person
PACKAGE_ITEM_ID	Foreign Key to Package Item table
MAILED_DT	The date that the enquiry package item was mailed
DONOT_MAIL_IND	Do Not Mail Indicator
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_RC_I_CHAR_INT	Holds admission inquiry characteristics interface records
Column Name	Descritpion
INTERFACE_INQ_CHAR_ID	A unique identifier to identify each record of the table.
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Concurrent Program Standard Who Column
PROGRAM_APPLICATION_ID	Concurrent Program Standard Who Column
PROGRAM_ID	Concurrent Program Standard Who Column
PROGRAM_UPDATE_DATE	Concurrent Program Standard Who Column
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
ERROR_TEXT	Error Text
PERSON_ID	Person Identifier. This column will be populated by the import process
ENQUIRY_APPL_NUMBER	Enquiry Application Number. This column will be populated by the import process
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier
INQUIRY_CHARACTERISTIC_TYPE	Inquiry Characteristic Type
STATUS	Status of the record1-'Completed'2-'Pending'3-'Error'4-'Warning'
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' - Match reviewed and do not import '11' - No match
ERROR_CODE	Error Code
CREATED_BY	Standard Who Column

Student System - IGS_RC_I_ENTRY_LVLS	Stores inquiry entry levels
Column Name	Descritpion
INQ_ENTRY_LEVEL_ID	Unique identifier of a inquiry entry level
INQ_ENTRY_LEVEL	Inquiry entry level
DESCRIPTION	Description
CLOSED_IND	Closed indicator
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard who column

Student System - IGS_RC_I_ENT_STATS	Stores inquiry entry statuses
Column Name	Descritpion
INQ_ENTRY_STAT_ID	Unique identifier of a inquiry entry status
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
INTEREST_TYPE_ID	Interest Type Identifier from OSO Interest Type table
INSTITUTION_TYPE	Institution type
IMP_SOURCE_TYPE_ID	Import source type id
EMAIL_LINK	Email address
PKG_ITEM_REDUC_CD	Package item reduction code
CONFIGURABILITY_FUNC_NAME	Configurability function name
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Student System - IGS_RC_I_E_CHARTYP	Describes the characteristics of an enquirer to the institution.
Column Name	Descritpion
ENQUIRY_CHARACTERISTIC_TYPE	Describes the user-defined types of characteristic of an enquiry .Examples are school leaver, TAFE graduate, domestic, international.
DESCRIPTION	Provides an explanation of the enquiry characteristic type
CLOSED_IND	Indicates if the enquiry characteristic type is active. Selecting the checkbox ticked will prevent its use in new or modified enquiry records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_RC_I_E_ORGUNITS	Stores organization units corresponding to inquiry entry status
Column Name	Descritpion
ENT_ORG_UNIT_ID	Unique identifier of an inquiry organizational unit corresponding to an entry status
INQ_ENTRY_STAT_ID	Unique identifier for inquiry entry status
PARTY_ID	Unique identifier for organizational unit
CLOSED_IND	Closed indicator
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Student System - IGS_RC_I_E_TESTTYPS	Stores test types corresponding to inquiry entry status
Column Name	Descritpion
ENT_TEST_TYPE_ID	Unique identifier of an inquiry test type corresponding to an entry status
INQ_ENTRY_STAT_ID	Unique identifier for inquiry entry status
ADMISSION_TEST_TYPE	Admission test type
CLOSED_IND	Closed indicator
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Student System - IGS_RC_I_INFO_INT	Holds admission inquiry information type interface records.
Column Name	Descritpion
INTERFACE_INQ_INFO_ID	A unique identifier assigned to identify each row of the interface table contents. This ID should be populated when the rows are inserted in to this table.
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
ERROR_TEXT	Error Text
PERSON_ID	Person Identifier. This column will be populated by the import process
ENQUIRY_APPL_NUMBER	Enquiry Application Number. This column will be populated by the import process
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier.
INFO_TYPE_ID	Foreign Key to information type table
STATUS	Status of the record 1-'Completed' 2-'Pending' 3-'Error' 4-'Warning'
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' - Match reviewed and do not import '11' - No match
ERROR_CODE	Error Code
CREATED_BY	Standard WHO Column

Student System - IGS_RC_I_PKG_INT	Holds admission inquiry package item interface records.
Column Name	Descritpion
INTERFACE_INQ_PKG_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
DONOT_MAIL_IND	Do Not Mail Indicator
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
ERROR_TEXT	Error Text
PERSON_ID	Person Identifier. This column will be populated by the import process
ENQUIRY_APPL_NUMBER	Enquiry Application Number. This column will be populated by the import process
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier
INQUIRY_ENTRY_STATUS_ID	Inquiry Entry Status Identifier. This column will be populated by the import process
SALES_LEAD_ID	Sales Lead Identifier. This column will be populated by the import process
PACKAGE_ITEM_ID	Foreign Key to package item table
STATUS	1- Completed 2- Pending 3 - Error 4 - Warning
MATCH_IND	Match indicator.
ERROR_CODE	Error Code
CREATED_BY	Standard Who column

Student System - IGS_RC_I_PKG_ITEM	Junction table to OMO deliverables table, used to store both Package Item and information Type.
Column Name	Descritpion
PACKAGE_ITEM_ID	Foreign Key to the Deliverable or Kit in OMO AMS_DELIVERABLE_ALL table.
PUBLISH_SS_IND	Flag indicating whether to publish the package item for Self Service Inquiry flow or not.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_RC_I_PKG_REDUCT	Sroring the reduction relationship between Package item and Inquiry Entry Status, Program and Unit Set.
Column Name	Descritpion
PKG_ITEM_REDUCT_ID	Primary Key generated from sequence
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
REDUCTION_TYPE	Lookup Type 'INQ_REDUCT_TYPE', 'ENTRY_STATUS' , 'PROGRAM' and 'UNIT_SET'
ENABLED_FLAG	Flag indicating whether the reduction rule is enabled. 'Y' or 'N'.
INQ_ENTRY_STAT_ID	ID for Inquiry Entry status, which is used to reduce package item
INQ_PROG_ID	ID for Inquiry Program, which is used to reduce package item
INQ_USET_ID	ID for Inquiry Unitset, which is used to reduce package item
PACKAGE_ITEM_ID	ID for Package Item, which is reduced by Inquiry Entry Status, Program or Unit Set
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column

Student System - IGS_RC_IS_I_LINES	Stores Academic Interests for the Self Service Inquiry
Column Name	Descritpion
INQ_LINES_ID	Primary Key generated from sequence
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
REQUEST_ID	Request Identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update this record
PROGRAM_ID	Program Identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
INQ_INQ_ID	Inquiry instance ID
PREFERENCE	Preference for the Inquiry Program and unit set pair
INQ_PROG_CODE_ID	Inquiry Program ID
INQ_UNIT_SET_CODE_ID	Inquiry Unit Set ID
STATUS	Import Status
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_RC_I_A_LINES	Junction table for Sales Lead Line table
Column Name	Descritpion
PERSON_ID	Person Identifier
REQUEST_ID	Request ID of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to update this record
PROGRAM_ID	Program Identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last Update Date of this record by a concurrent program
ENQUIRY_APPL_NUMBER	Inquiry Application Number
SALES_LEAD_LINE_ID	Foreign Key to Sales Lead Lines table
PREFERENCE	Preference for the Inquiry Program and Unit Set pair
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_RC_I_LINES_INT	Stores academic interests for the inquiry interface
Column Name	Descritpion
INTERFACE_LINES_ID	Interface Lines ID Generated from sequence
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
REQUEST_ID	Request Identifier of Last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application Identifier of Last concurrent program to update this record
PROGRAM_ID	Program Identifier of Last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
ERROR_TEXT	Error Text
PERSON_ID	Person Identifier. This column will be populated by the import process
INTERFACE_INQ_APPL_ID	Inquiry Instance ID
ENQUIRY_APPL_NUMBER	Enquiry Application Number. This column will be populated by the import process
INQUIRY_ENTRY_STATUS_ID	Inquiry Entry Status Identifier. This column will be populated by the import process
SALES_LEAD_ID	Sales Lead Identifier. This column will be populated by the import process
INQUIRY_DATE	Inquiry Date. This column will be populated by the import process
INQUIRY_SOURCE_TYPE	Inquiry Source Type. This column will be populated by the import process
PREFERENCE	Preference for the Inquiry Program and Unit Set pair
PROGRAM_CODE_ID	Inquiry Program ID
UNIT_SET_CODE_ID	Inquiry Unit Set ID
STATUS	Importing Status
MATCH_IND	Import Matching Indicator
ERROR_CODE	Import Error Code

Student System - IGS_RC_IS_RACE	Stores the Race information of an inquirer
Column Name	Descritpion
INQ_RACE_ID	Primary Key. Unique ID generated from sequence
REQUEST_ID	Request Identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application Identifier of last concurrent program to updated this record
PROGRAM_ID	Program Identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last Update Date of this record by a concurrent program
PERSON_ID	Unique Identifier of an Inquirer
RACE_CD	Race Code
STATUS	Import Status
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_RE_LGCY_SPR_INT	Contains Research Supervisor information to be imported into the IGS_RE_SPRVSR table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
SUPERVISION_PERCENTAGE	The supervision percentage of the person. This is entered for the purposes of calculating the research load incurred by supervisors within an institution.
FUNDING_PERCENTAGE	The percentage of the research load that is apportioned for funding purposes to the specified organizational unit.
ORG_UNIT_CD	The organizational unit code for whom the supervisor is working when performing the supervision.
REPLACED_PERSON_NUMBER	The person number of the replaced supervisor allowing creation and maintenance of a supervision history for the candidature.
COMMENTS	General comments.
IMPORT_STATUS	Record's Import status
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LEGACY_RE_SPRVSR_INT_ID	Unique identifier of the Research Supervisor record.
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard concurrent program who column
PROGRAM_ID	Standard concurrent program who column
PROGRAM_APPLICATION_ID	Standard concurrent program who column
PROGRAM_UPDATE_DATE	Standard concurrent program who column
CA_PERSON_NUMBER	The Person number of the research candidate.
PROGRAM_CD	The program code in which the research activity is occurring.
PERSON_NUMBER	The person number of the supervisor.
START_DT	Describes the date a supervisor becomes effective for the student candidature.
END_DT	If recorded, this field indicates the date of which the person stopped supervising the candidate.
RESEARCH_SUPERVISOR_TYPE	The supervisor type. For example, include principal supervisor, associate supervisor, external supervisor.
SUPERVISOR_PROFESSION	The supervisor's profession.

Student System - IGS_RE_LGCY_THE_INT	Contains Research Thesis information to be imported into the IGS_RE_THESIS_ALL table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
EXPECTED_SUBMISSION_DT	The date that the thesis is expected to be submitted. This field would be entered once the student had given notification of intention to submit.
LIBRARY_LODGEMENT_DT	Contains the date the research students thesis was lodged in the library.
LIBRARY_CATALOGUE_NUMBER	Contains the library catalogue number of the thesis.
EMBARGO_EXPIRY_DT	The expiry date of any embargo placed on the release of the thesis.
THESIS_FORMAT	Describes the format of the thesis.
EMBARGO_DETAILS	Records the details of any embargo placed on the release of the thesis.
THESIS_TOPIC	Describes the topic of the thesis.
CITATION	Contains citation information to be read during a graduation ceremony.
COMMENTS	General comments.
SUBMISSION_DT	The date that the thesis was submitted for examination.
LEGACY_RE_THE_INT_ID	Unique identifier of the Thesis and Thesis Exam record.
THESIS_EXAM_TYPE	The type of examination that is being undertaken. For example, written, performance, oral. Must be an uppercase value.
THESIS_PANEL_TYPE	The type of panel used for the thesis examination. Must be an uppercase value.
THESIS_RESULT_CD	The thesis result that is an outcome of the panel members having provided their recommended results. Must be an uppercase value.
IMPORT_STATUS	Record's Import status.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard concurrent program who column
PERSON_NUMBER	Person number of the research candidate.
PROGRAM_ID	Standard concurrent program who column
PROGRAM_APPLICATION_ID	Standard concurrent program who column
PROGRAM_UPDATE_DATE	Standard concurrent program who column
PROGRAM_CD	The program code in which research is being conducted.
TITLE	Describes the title of the research student's thesis.
FINAL_TITLE_IND	Indicates and specifies if the nominated title is the final title for the thesis, or a working title. Selecting the check box indicates the thesis title is final
SHORT_TITLE	The short title of the thesis.
ABBREVIATED_TITLE	The abbreviated title of the thesis.
FINAL_THESIS_RESULT_CD	Describes the final result that has been allocated to the thesis. This result must be mapped to a system result of type final.

Student System - IGS_PS_US_FLD_STUDY	This entity describes the field of study details for unit set.
Column Name	Descritpion
UNIT_SET_CD	Unit Set Code
VERSION_NUMBER	This field is used to uniquely identify each version of a unit set.
FIELD_OF_STUDY	Unique Identifier for field of study for particular unit set.
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns

Student System - IGS_PS_USEC_SP_FEES	Table for storing special fee associated with a unit section
Column Name	Descritpion
USEC_SP_FEES_ID	Unique identifier for the special fee associated with a unit section
LAST_UPDATE_LOGIN	Standard Who Column
UOO_ID	The identifier of the associated unit section
FEE_TYPE	Special Fee Type
SP_FEE_AMT	Amount of special fee
CLOSED_FLAG	Closed Flag
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column