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

Student System - IGS_AD_LOCATION_REL	Describes relationship between locations to determine geographical equivalence between locations
Column Name	Descritpion
LOCATION_CD	Code for the owning location in the relationship. A location may have multiple owning locations.
SUB_LOCATION_CD	Code for the sub location in the relationship. A location may have multiple sub locations.
DFLT_IND	Specifies if the sub location is the default sub-location. This relationship is used by the system to determine the default unit attempt examination location for students enrolled in on campus units. That is, unless otherwise specified, the
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_AD_INTL_VISA	Describes international student's details
Column Name	Descritpion
PERSON_ID	Describes the ID that uniquely identifies a person
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
ENTRY_DATE	Entry date
LAST_UPDATE_LOGIN	Standard Who column
PLACE_OF_ENTRY	Place of entry
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment column
ATTRIBUTE2	Descriptive Flexfield segment column
ATTRIBUTE3	Descriptive Flexfield segment column
ATTRIBUTE4	Descriptive Flexfield segment column
ATTRIBUTE5	Descriptive Flexfield segment column
ATTRIBUTE6	Descriptive Flexfield segment column
ATTRIBUTE7	Descriptive Flexfield segment column
ATTRIBUTE8	Descriptive Flexfield segment column
ATTRIBUTE9	Descriptive Flexfield segment column
ATTRIBUTE10	Descriptive Flexfield segment column
ATTRIBUTE11	Descriptive Flexfield segment column
ATTRIBUTE12	Descriptive Flexfield segment column
ATTRIBUTE13	Descriptive Flexfield segment column
ATTRIBUTE14	Descriptive Flexfield segment column
ATTRIBUTE15	Descriptive Flexfield segment column
ATTRIBUTE16	Descriptive Flexfield segment column
VISA_TYPE	Describes the types of visa associated with international applicants or students
ATTRIBUTE17	Descriptive Flexfield segment column
ATTRIBUTE18	Descriptive Flexfield segment column
ATTRIBUTE19	Descriptive Flexfield segment column
ATTRIBUTE20	Descriptive Flexfield segment column
VISA_NUMBER	Visa number
INTRNTNL_AGENT_ORG_UNIT_CD	Describes the code which uniquely identifies an academic or administrative organizational unit operating within the University structure. DETYA element reference 333.
VISA_CATEGORY	Visa category
INTRNTNL_AGENT_OU_START_DT	Describes the date from which the organizational unit is effective
INTRNTNL_AGENT_PERSON_ID	Describes the ID that uniquely identifies a person
INTRNTNL_AGENT_CONTACT_NAME	Describes the contact name within the international agent organization
VISA_EXPIRY_DT	Visa expiry date
PASSPORT_NUMBER	Passport number
PASSPORT_EXPIRY_DATE	Passport expiry date
PASSPORT_COUNTRY_CD	Describes the country of issue of the passport described in the record.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
VISA_ISSUE_DATE	Issue Date of Visa

Student System - IGS_AD_INTCAT_STATUS	This is the interface table that contains the status of the various categories for an interface id
Column Name	Descritpion
INTCAT_STATUS_ID	Assigned to identify each row of the interface table contents. This ID should be populated when the rows are inserted into this table.
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_ID	Interface ID
CATEGORY_NAME	Category name
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_AD_INTAK_TRG_TYP	Describes intake targets that may be required by institution, faculty, program, and program entry points for a submission period
Column Name	Descritpion
S_AMOUNT_TYPE	The amount type values indicate how the intake target type will be measured. The values available are 'EFTSU', 'PERCENTAGE', 'PERSON' and 'WEFTSU'.
CLOSED_IND	Specifies if the intake target type is open or closed. Setting the checkbox to 'closed' prevents further use of the intake target type in new or modified planning targets.
COMMENTS	Additional information relating to the intake target 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
INTAKE_TARGET_TYPE	Types of applicants or students that the institution has established targets for when offering programs, for example, school leavers, commencing students, regional entry.
DESCRIPTION	Provides an explanation of the intake target types
S_INTAKE_TARGET_TYPE	System defined intake target types are characterized as having system functionality. A user-defined intake target type is also allowable.

Student System - IGS_AD_SPL_ADM_CAT	Holds special admission category details
Column Name	Descritpion
SPL_ADM_CAT_ID	Unique identifier for the applicants special admission category details
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. It is a sequence.
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	Nominated program code
SEQUENCE_NUMBER	Sequence number
SPL_ADM_CAT	Special admission category type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_SBM_PS_FNTRGT	Holds program version funding source and optional components that have one or more targets for a submission period
Column Name	Descritpion
CRV_VERSION_NUMBER	The version number of the program for the submission period target
FUNDING_SOURCE	Describes the institution-defined funding source for the submission period program version target
SEQUENCE_NUMBER	A unique identifier to cater for submission period targets against the program version funding source that are further broken down by location, attendance mode, attendance type.
LOCATION_CD	Describes the location code for the submission period program version funding source target
ATTENDANCE_MODE	Describes the attendance mode for the submission period program version funding source target
ATTENDANCE_TYPE	Describes the attendance type for the submission period program version funding source target
UNIT_SET_CD	Describes the unit set code for the submission period program version funding source target
US_VERSION_NUMBER	Describes the unit set version number for the submission period program version funding source target
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
SUBMISSION_YR	The Higher Education Student Data Collection submission number<1 data-blogger-escaped-3="" data-blogger-escaped-or=""> for target collection.
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission year.
COURSE_CD	Describes the program code of the submission period target

Student System - IGS_AD_SBM_AOU_FNDTT	Holds submission period targets
Column Name	Descritpion
OU_START_DT	Describes the organizational unit start date for the submission period funding source target
FUNDING_SOURCE	Describes the funding source for the submission period organizational unit target
INTAKE_TARGET_TYPE	Describes the type of target that is required
TARGET	Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	Shows the maximum target figure
OVERRIDE_S_AMOUNT_TYPE	Allows an override of the amount type of the target. If the target is typically measured as, for example, persons, then the intake target type will define this. The override allows this to be changed to.
ACTUAL_ENROLMENT	Actual enrollment. This is included so that historical enrollment actual figures can be retained.
ACTUAL_ENR_EFFECTIVE_DT	Contains the date and time when the actual enrollment figures were calculated
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
SUBMISSION_YR	The Higher Education Student Data Collection submission year for target collection.
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission number<1 data-blogger-escaped-3="" data-blogger-escaped-or=""> for target collection.
ORG_UNIT_CD	Describes the organizational unit code for the submission period funding source target

Student System - IGS_AD_SBMPS_FN_ITTT	Holds intake target types and associated targets for submission period program version funding source.
Column Name	Descritpion
COURSE_CD	Describes the program code of the submission period target
CRV_VERSION_NUMBER	Describes the program code version number of the submission period target
FUNDING_SOURCE	Describes the institution-defined funding source for the submission period program version target
PRIORITY_OF_TARGET	Defines the order in which targets are to be met
SEQUENCE_NUMBER	A unique identifier to cater for submission period targets against the program version funding source that are further broken down by location, attendance mode, attendance type.
INTAKE_TARGET_TYPE	Describes the type of intake target required, for example, Commencing , Returning
TARGET	Intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	Shows the maximum target figure. Once a legitimate value is entered here the value recorded under target is defaulted as the minimum.
OVERRIDE_S_AMOUNT_TYPE	Allows an override of the amount type of the target. If the target is typically measured, for example, in Persons, then the intake target type will define this.
ACTUAL_ENROLMENT	Actual enrollment. This is included so that historical enrollment actual figures can be retained.
ACTUAL_ENR_EFFECTIVE_DT	Contains the date and time when the actual enrollment figures were calculated.
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
SUBMISSION_YR	The Higher Education Student Data Collection submission year.
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission number<1 data-blogger-escaped-3="" data-blogger-escaped-or=""> for target collection.

Student System - IGS_AD_SBMINTAK_TRGT	Holds intake targets for submission period
Column Name	Descritpion
INTAKE_TARGET_TYPE	Describes the type of student target required
PRIORITY_OF_TARGET	The priority defines the order in which targets are to be met.
TARGET	Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	Shows the maximum target figure
OVERRIDE_S_AMOUNT_TYPE	Allows an override of the amount type of the target. If the target is typically measured as, for example, in Persons, then the intake target type will define this. The override allows this to be changed to.
ACTUAL_ENROLMENT	Is included so that historical enrollment actual figures can be retained
ACTUAL_ENR_EFFECTIVE_DT	Contains the date and time when the actual enrollment figures were calculated
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
SUBMISSION_YR	The Higher Education Student Data Collection submission year for target collection.
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission number<1 data-blogger-escaped-3="" data-blogger-escaped-or=""> for target collection.

Student System - IGS_AD_SBMAO_FN_UITT	Describes academic organizational unit targets
Column Name	Descritpion
OU_START_DT	Describes the organizational unit start date for the submission period funding source unit internal program level target
FUNDING_SOURCE	Describes the funding source for the submission period organizational unit internal program level target
UNIT_INT_COURSE_LEVEL_CD	Describes the unit internal program level code for the submission period organizational unit funding source target
INTAKE_TARGET_TYPE	Describes the type of student target required
TARGET	Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	Shows the maximum target figure
OVERRIDE_S_AMOUNT_TYPE	Allows an override of the amount type of the target. If the target is typically measured as, for example, persons, then the intake target type will define this. The override allows this to be changed to, for example, EFTSU for an individual
ACTUAL_ENROLMENT	Is included so that historical enrollment actual figures can be retained
ACTUAL_ENR_EFFECTIVE_DT	Contains the date and time when the actual enrollment figures were calculated
CREATED_BY	Standard Who column
SUBMISSION_YR	The Higher Education Student Data Collection submission year for target collection.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission number<1 data-blogger-escaped-3="" data-blogger-escaped-or=""> for target collection.
ORG_UNIT_CD	Describes the organizational unit code for the submission period funding source target

Student System - IGS_AD_SBMAO_FN_CTTT	Describes submission period academic organizational unit targets
Column Name	Descritpion
OU_START_DT	Describes the organizational unit start date for the submission period funding source program type group target
FUNDING_SOURCE	Describes the funding source for the submission period organizational unit program type group target
TARGET	Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	Shows the maximum target figure
OVERRIDE_S_AMOUNT_TYPE	Allows an override of the amount type of the target. If the target is typically measured as, for example, persons, then the intake target type will define this. The override allows this to be changed to, for example, EFTSU for an individual
ACTUAL_ENROLMENT	Included so that historical enrollment actual figures can be retained
ACTUAL_ENR_EFFECTIVE_DT	Contains the date and time when the actual enrollment figures were calculated
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
INTAKE_TARGET_TYPE	Describes the type of student target required
COURSE_TYPE_GROUP_CD	Describes the program type group code for the submission period organizational unit funding source target
SUBMISSION_YR	The Higher Education Student Data Collection submission year for target collection.
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission number<1 data-blogger-escaped-3="" data-blogger-escaped-or=""> for target collection.
ORG_UNIT_CD	Describes the organizational unit code for the submission period funding source program type group target

Student System - IGS_AD_SBMAO_FN_AMTT	Describes submission period academic organizational unit targets
Column Name	Descritpion
FUNDING_SOURCE	Describes the funding source for the submission period organizational unit attendance mode target
ATTENDANCE_MODE	Describes the attendance mode for the submission period organizational unit funding source target
INTAKE_TARGET_TYPE	Describes the type of student target required
TARGET	Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	Shows the maximum target figure
OVERRIDE_S_AMOUNT_TYPE	Allows an override of the amount type of the target. If the target is typically measured as, for example, persons, then the intake target type will define this. The override allows this to be changed to, for example, EFTSU for an individual
ACTUAL_ENROLMENT	Included so that historical enrollment actual figures can be retained
ACTUAL_ENR_EFFECTIVE_DT	Contains the date and time when the actual enrollment figures were calculated
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_UNIT_CD	Describes the organizational unit code for the submission period funding source attendance mode target
OU_START_DT	Describes the organizational unit start date for the submission period funding source attendance mode target
SUBMISSION_YR	The Higher Education Student Data Collection submission year for target collection.
SUBMISSION_NUMBER	The Higher Education Student Data Collection submission number 1,2 or 3 for target collection.

Student System - IGS_AD_RS_VALUES	Holds details about rating scale values
Column Name	Descritpion
RATING_VALUES_ID	A unique identifier assigned to each of the rating scales values.
LAST_UPDATE_LOGIN	Standard Who column
RATING_SCALE_ID	Rating scale identifier
RATING_VALUE	Rating value
DESCRIPTION	Description of the rating scale
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

Student System - IGS_AD_TRANSCRIPT	Holds transcript details
Column Name	Descritpion
TRANSCRIPT_ID	Unique identifier for the transcript details
TERM_TYPE	Tells the type of attendance mode Q - Quarter, S - Semester, T - Trimester
RANK_IN_CLASS	Rank in class
CLASS_SIZE	Class size
APPROXIMATE_RANK	Y or Null
WEIGHTED_RANK	Y or Null
DECILE_RANK	Decile rank
QUARTILE_RANK	Quartile rank
QUINTILE_RANK	Quintile rank
PERCENTILE_RANK	Percentile rank
TRANSCRIPT_TYPE	This indicates if the Transcript is Official or Unofficial
CREATED_BY	Standard Who column
EDUCATION_ID	Academic history identifier
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
OVERRIDE	Override Indicator column to indicate manual override of formula values for Percentile, Decile, Quartile and Quintile.
OVERRIDE_ID	User ID of the person who has done the override.
OVERRIDE_DATE	Date on which override has been done.
DATE_OF_ISSUE	Date on which the transcript is issued
TRANSCRIPT_STATUS	Transcript status
CORE_CURRICULUM_VALUE	This value indicates the level a student has attained in high school toward the 'core curriculum'
TRANSCRIPT_SOURCE	Transcript source
DATE_OF_RECEIPT	Date of receipt of transcript
ENTERED_GPA	Grade point average for the institution
ENTERED_GS_ID	Grade point average scale type for the entered GPA
CONV_GPA	Grade point average for the institution as per the institutions gpa scale type
CONV_GS_ID	Institution grading scale

Student System - IGS_AD_TEST_TYPE	Describes valid admission test types
Column Name	Descritpion
ADMISSION_TEST_TYPE	Describes the types of admission test against that results may be recorded for an applicant
DESCRIPTION	Provides an explanation of the admission test type
SCORE_TYPE	Test Score Source
STEP_CODE	Step Catalog Code
CLOSED_IND	Specifies whether the admission test type is open or closed. Selecting the checkbox to 'closed' prevents use of the test type in new or modified admission program application test result 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_AD_TEST_SEGMENTS	Holds test segment details
Column Name	Descritpion
TEST_SEGMENT_ID	Unique identifier that identifies a test segment
PERCENTILE_IND	Whether this attribute is part of this test segment
NATIONAL_PERCENTILE_IND	Whether this attribute is part of this test segment
STATE_PERCENTILE_IND	Whether this attribute is part of this test segment
PERCENTILE_YEAR_RANK_IND	Whether this attribute is part of this test segment
SCORE_BAND_UPPER_IND	Whether this attribute is part of this test segment
SCORE_BAND_LOWER_IND	Whether this attribute is part of this test segment
IRREGULARITY_CODE_IND	Whether this attribute is part of this test segment
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
ADMISSION_TEST_TYPE	Admission test type
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SEGMENT_TYPE	Defines the segment type of the test segment. It can have values 'SCORE' and 'SUB SCORE'.
SEGMENT_GROUP	User defined number sequences. Matches the SCORE and SUB SCORE test segments.
TEST_SEGMENT_NAME	Test segment name
DESCRIPTION	Description of the test segment
CLOSED_IND	Closed indicator to prevent further use of a test segment
MIN_SCORE	Minimum score for this test segment
MAX_SCORE	Maximum score for this test segment
INCLUDE_IN_COMP_SCORE	Whether to include this test segment in the composite test score calculation
SCORE_IND	Whether this attribute is part of this test segment

Student System - IGS_AD_TEST_RESULTS	Holds admission test results
Column Name	Descritpion
TEST_RESULTS_ID	Unique identifier for the test results
COMP_TEST_SCORE	Composite Test Score
SPECIAL_CODE	Special Codes
REGISTRATION_NUMBER	Registration number
GRADE_ID	Grade.
ATTRIBUTE_CATEGORY	Descriptive flex field structure defining column
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
PERSON_ID	Person for whom the test results is stored
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
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
ADMISSION_TEST_TYPE	Admission Test Type
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
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
TEST_DATE	Date on which the test was administered
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
ACTIVE_IND	Active Indicator
SCORE_REPORT_DATE	Date on which the Test Scores were created at ETS
EDU_LEVEL_ID	Education Level of the person at the time the test was given
SCORE_TYPE	Test Score Type
SCORE_SOURCE_ID	Score Source Identifier
NON_STANDARD_ADMIN	Whether it is a Non Standard Admission

Student System - IGS_AD_TER_ED_UNI_AT	Describes unit attempts for tertiary education identified by an applicant in support of admission or advanced standing
Column Name	Descritpion
UNIT_CD	Describes the unit code of the unit studied as part of the prior tertiary education course.
SEQUENCE_NUMBER	This field describes an unique identifier for the tertiary education unit attempt.
ENROLLED_YR	The year of enrolment in the unit.
RESULT_TYPE	Describes the result type for the unit. This can be selected from the system result types with the addition of 'UNKNOWN'.
TITLE	Describes the title of the unit.
CREDIT_POINTS	The value of the unit within the course attempt, regardless of pass or fail. Credit Points is the standard descriptor for unit weighting.
GRADE	The grade obtained for the unit, as recognized by the institution.
DISCIPLINE_GROUP_CD	Describes the discipline group, to which a unit of study belongs, as classified by the institution.
PERSON_ID	The ID code 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
TE_SEQUENCE_NUMBER	Unique number used to identify tertiary education records for students.

Student System - IGS_AD_TER_ED_LV_COM	Describes applicant's previous tertiary education level of completion
Column Name	Descritpion
TERTIARY_EDU_LVL_COMP	Contains the institution-defined code that identifies the level of completion of tertiary education studies assigned to an applicant on the basis of their current qualifications. These may be optionally mapped onto a tertiary admission cent
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	Provides an explanation of the tertiary education level of completion code
TAC_LEVEL_OF_COMP	Contains a code recognized by the relevant tertiary admission center to define the level of completion of studies assigned to an applicant on the basis of their current qualifications
CLOSED_IND	An indicator that specifies if the tertiary education level of completion code is open or closed. Selecting the checkbox to 'closed' prevents use of the tertiary education level of completion code in new or modified records.

Student System - IGS_AD_TER_ED_LVL_QF	Describes user-defined level of qualification achieved by applicant's previous tertiary education
Column Name	Descritpion
TERTIARY_EDU_LVL_QUAL	Contains the institution-defined code that identifies the tertiary education level of qualification assigned to an applicant on the basis of their current qualifications. These may be optionally mapped onto a tertiary admission center level
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	Provides an explanation of the tertiary education level of qualification code
TAC_LEVEL_OF_QUAL	Contains a code recognized by the relevant tertiary admission center to define the level of qualification assigned to an applicant on the basis of their current qualifications
CLOSED_IND	Specifies if the tertiary education level of qualification code is open or closed. Selecting the checkbox to 'closed' prevents use of the tertiary education level of qualification code in new or modified records.

Student System - IGS_AD_TER_EDU	Holds tertiary education details from other institutions
Column Name	Descritpion
STATE_CD	Australian state where the tertiary education program was studied
SEQUENCE_NUMBER	The system-generated number used to uniquely identify a tertiary education record for a student
COUNTRY_CD	Identifies the institution-defined code for a country
TERTIARY_EDU_LVL_COMP	An institution-defined level of completion code that indicates the completion status of previous tertiary education identified by an applicant.
NOTES	Large text field used to record miscellaneous details or comments about the student's tertiary education
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
EXCLUSION_IND	Indicates whether the student has ever been refused enrollment in this program
INSTITUTION_CD	The unique code for an institution.
INSTITUTION_NAME	Origin of previous tertiary education if institution code is unknown, for example, Princeton University
ENROLMENT_FIRST_YR	First year of enrollment in this tertiary education program
ENROLMENT_LATEST_YR	Last year of enrollment in this tertiary education program
COURSE_CD	The program code of the issuing institution
COURSE_TITLE	The program title of the issuing institution
FIELD_OF_STUDY	The unique identifier for the institution-defined field of study.
LANGUAGE_COMPONENT	A language that is a significant component of the program studied.
STUDENT_ID	Identification number at the previous tertiary institution
EQUIV_FULL_TIME_YRS_ENR	Equivalent full-time years enrolled in this program
TERTIARY_EDU_LVL_QUAL	An institution-defined code used to quantify previous tertiary education identified by the applicant.
QUALIFICATION	Describes the name of the qualification, for example, B.A
HONOURS_LEVEL	Honors level granted to a graduating student, for example, 'H1'-First Class Honors
LEVEL_OF_ACHIEVEMENT_TYPE	Level of achievement for the tertiary education program
GRADE_POINT_AVERAGE	Describes the grade point average for the tertiary education program
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
LANGUAGE_OF_TUITION	Describes the language of tuition for the program studied

Student System - IGS_AD_TERM_UNITDTLS	Holds term unit details for institution
Column Name	Descritpion
UNIT_DETAILS_ID	Unique identifier for the term unit details
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
DEG_AUD_DETAIL_ID	Degree Audit Detail Identifier
TERM_DETAILS_ID	Unique identifier for the term details
UNIT	Unit code
UNIT_DIFFICULTY	Unit difficulty
UNIT_NAME	Unit name
CP_ATTEMPTED	Credit points attempted
CP_EARNED	Credit points earned
GRADE	Grade
UNIT_GRADE_POINTS	Unit grade points

Student System - IGS_AD_INTERFACE_CTL_ALL	Holds import interface run details when admissions data is imported into system
Column Name	Descritpion
INTERFACE_RUN_ID	Unique identifier assigned to identify each row of the interface table contents
ADM_SEQUENCE_NUMBER	Obsolete
STATUS	1 - Completed2 - Pending3 - Error
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 the last concurrent program, that updated this record
PROGRAM_APPLICATION_ID	Application Identifier of the last concurrent program, that updated this record
PROGRAM_ID	Program Identifier of the last concurrent program, that updated this record
SOURCE_TYPE_ID	Import source type
PROGRAM_UPDATE_DATE	Last Update Date of this record by a concurrent program
PERSON_TYPE_CODE	Obsolete
FUNNEL_STATUS	Obsolete
BATCH_ID	Batch ID
MATCH_SET_ID	Match criteria set name ID
ORG_ID	Organization unit identifier
ADMISSION_CAT	Obsolete
S_ADMISSION_PROCESS_TYPE	Obsolete
ACAD_CAL_TYPE	Obsolete
ACAD_SEQUENCE_NUMBER	Obsolete
ADM_CAL_TYPE	Obsolete

Student System - IGS_AD_INTERFACE_ALL	Holds person's import data received from different sources
Column Name	Descritpion
INTERFACE_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.
SUFFIX	Suffix
PRE_NAME_ADJUNCT	Prefix for person name
LEVEL_OF_QUAL	Level of qualification
PROOF_OF_INSURANCE	Proof of insurance provided
PROOF_OF_IMMUN	Proof of immunization provided
PREF_ALTERNATE_ID	Alternate Identifier
PERSON_NUMBER	Unique identifier for the person that is displayed to the user
PERSON_ID	Person identifier
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
MILITARY_SERVICE_REG	Military service registration
VETERAN	Veteran Status
MATCH_IND	Indicates the match between the interface record and the record present in the system
BATCH_ID	A unique identifier assigned to a group of records for a particular import source type
PERSON_MATCH_IND	Indicates the kind of action taken depending upon the Imported and Existing values, Whether to retain Imported value OR to retain the existing value.
ERROR_CODE	Error code
RECORD_STATUS	1 - Completed. 2 - Pending. 3 - Error
INTERFACE_RUN_ID	Interface run identification
ATTRIBUTE_CATEGORY	Descriptive Flex field structure defining column
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
SOURCE_TYPE_ID	Source type
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
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
SURNAME	Last name
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
MIDDLE_NAME	Middle name
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	Organization unit identifier
GIVEN_NAMES	First name
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
ACCOUNT_NUMBER	Obsolete this Column- Account Number id for Customer Account Number
PERSON_TYPE_CODE	Inquiry Person Type
FUNNEL_STATUS	Inquiry Funnel Status
BIRTH_CITY	City of Birth
BIRTH_COUNTRY	Country Code of Birth Place
FELONY_CONVICTED_FLAG	Flag indicating whether the person is ever convicted of a Felony. Valid values are Y, N, FND_API.G_MISS_CHAR and Null
ATTRIBUTE21	Descriptive Flex field segment column
ATTRIBUTE22	Descriptive Flex field segment column
ATTRIBUTE23	Descriptive Flex field segment column
ATTRIBUTE24	Descriptive Flex field segment column
PREFERRED_GIVEN_NAME	Preferred given name
SEX	Sex
BIRTH_DT	Birth date
TITLE	Title

Student System - IGS_AD_VISA_TYPE_ALL	Describes types of visas required for international applicants or students
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
VISA_TYPE	The code for the visa type. A visa type exists for each visa associated with international applicants or students. It is used to categorize visas.
ORG_ID	Operating unit identifier
DESCRIPTION	A description of the visa type. A visa type exists for each visa associated with international applicants or students. It is used to categorize visas.
CLOSED_IND	Specifies whether the visa type is open or closed ticked. If closed, it cannot be linked to any further person international visa records.

Student System - IGS_AD_UNITSETS_INT_ALL	Holds applicant's desired unit set details
Column Name	Descritpion
INTERFACE_UNITSETS_ID	A unique identifier assigned to identify each applicant desired unit set details record 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	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_PS_APPL_INST_ID	Interface Program Application Instance Identifier
INTERFACE_ID	Obsolete
INTERFACE_APPL_ID	Obsolete
UNIT_SET_CD	Unit set desired
VERSION_NUMBER	Unit set version number
ORG_ID	Operating unit identifier
RANK	Unit set rank
MATCH_IND	Match indicator
STATUS	Status of the record - imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column

Student System - IGS_AD_TEST_SEGS_INT_ALL	Holds person's test segment details.
Column Name	Descritpion
INTERFACE_TESTSEGS_ID	Unique identifier assigned to identify each test score details record of the interface table . This ID should be populated when the rows are inserted into this table
PERCENTILE_YEAR_RANK	Percentile year rank
SCORE_BAND_UPPER	Score band upper
SCORE_BAND_LOWER	Score band lower
IRREGULARITY_CODE	Irregularity code
MATCH_IND	Match indicator
STATUS	Status of the record - imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
INTERFACE_TEST_ID	Interface identifier of the test result record
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
ADMISSION_TEST_TYPE	Admission test type
TEST_SEGMENT_ID	Admission test type segment identifier
ORG_ID	Operating unit identifier
TEST_SCORE	Test score
PERCENTILE	Percentile
NATIONAL_PERCENTILE	National percentile
STATE_PERCENTILE	State percentile
LATEST_OFFICIAL_PERCENTILE	Latest official percentile

Student System - IGS_AD_TEST_INT_ALL	Holds test type details.
Column Name	Descritpion
INTERFACE_TEST_ID	A unique identifier assigned to identify each test results details record of the interface table . This ID should be populated when the rows are inserted into this table
NON_STANDARD_ADMIN	Non standard test administration
COMP_TEST_SCORE	Composite test score
SPECIAL_CODE	Special code
STATUS	Status of the record - imported, pending, error or warning
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
ACTIVE_IND	Indicator for Active Test Types
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
INTERFACE_ID	Interface identifier
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
ADMISSION_TEST_TYPE	Type of the admission test taken by the person, for example, TOEFL, UMAT and others
REGISTRATION_NUMBER	Registration number provided by the testing agency if the test is taken
ORG_ID	Operating unit identifier
TEST_DATE	Date that the test was administered
SCORE_REPORT_DATE	Date that the test scores were created
EDU_LEVEL_ID	Education level of the person at the time the test was given
SCORE_TYPE	Test score type
SCORE_SOURCE_ID	Score source

Student System - IGS_AD_SYSCAT_ATTR	Holds system categories and attribute mapping details - Obsolete
Column Name	Descritpion
CATEGORY_NAME	System category name
ATTR_NAME	Attribute name
SYS_MANDATORY_IND	System mandatory indicator
DISPLAY_SEQUENCE	Display Sequence of the attributes
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

Student System - IGS_AD_STAT_INT_ALL	Holds person's statistics records
Column Name	Descritpion
INTERFACE_STAT_ID	A unique identifier assigned to identify each person statistics record of the interface table. This ID should be populated when the rows are inserted into this table.
PLACE_OF_BIRTH	City of birth
MARITAL_STATUS_EFFECTIVE_DATE	Marital status effective date
INTERFACE_ID	Interface identifier
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
STATUS	Status of the record imported, pending, error or warning
ETHNIC_ORIGIN	Ethnicity or Race
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
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
RESID_STAT_ID	Residential Status ID(Obsolete)
COUNTRY_CD3	Country Code(Obsolete)
CRIMINAL_CONVICT	Criminal Convict Indicator(Obsolete)
ACAD_DISMISSAL	Academic Dismissal Indicator(Obsolete)
NON_ACAD_DISMISSAL	Non Academic Dismissal Indicator(Obsolete)
ATTRIBUTE_CATEGORY	Descriptive Flex field Structure Defining Column
ATTRIBUTE1	Descriptive Flex field Segment Column
ATTRIBUTE2	Descriptive Flex field Segment Column
ATTRIBUTE3	Descriptive Flex field Segment Column
MARITAL_STATUS	Marital status of the person
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
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
RELIGION_CD	Religion code.
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
ORG_ID	Operating unit identifier
RELIGION_ID	Religion

Student System - IGS_AD_SPLTAL_INT_ALL	Holds applicant special talents details
Column Name	Descritpion
INTERFACE_SPLTAL_ID	A unique identifier assigned to identify each special talent record of the interface table. This ID should be populated when the rows are inserted into this table.
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_ID	Interface identifier
INTERFACE_APPL_ID	Interface Applicant Identifier
SPECIAL_TALENT_TYPE_ID	Applicant special talent
MATCH_IND	Match indicator
ORG_ID	Operating unit identifier
STATUS	Status of the record whether it is imported pending error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_SPLINT_INT_ALL	Holds applicant special interest details
Column Name	Descritpion
INTERFACE_SPLINT_ID	A unique identifier assigned to identify each special interests record. This ID should be populated when the rows are inserted into this table.
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_ID	Interface identifier
INTERFACE_APPL_ID	Interface Applicant Identifier
SPECIAL_INTEREST_TYPE_ID	Applicant special interest
MATCH_IND	Match indicator
ORG_ID	Operating unit identifier
STATUS	Status of the record imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_SOURCE_CAT_ALL	Holds details for user source categories
Column Name	Descritpion
SRC_CAT_ID	Source category identifier is the unique identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_TYPE_ID	Source type identifier is the parent of the source category type contained in IGS_PE_SRC_TYPES.
CATEGORY_NAME	Name of the source category
MANDATORY_IND	Mandatory indicator to tell whether the source category is mandatory within a source type
ORG_ID	Operating unit identifier
INCLUDE_IND	Include indicator tells whether the source category is to be included if it is not mandatory
SS_MANDATORY_IND	Mandatory indicator for self service categories - Obsolete
DISCREPANCY_RULE_CD	Discrepancy rule code
SS_IND	Self Service Indicator - Obsolete
DISPLAY_SEQUENCE	Display Sequence - Obsolete
DETAIL_LEVEL_IND	Indicator for setting discrepancy rules at the Detail Level
AD_TAB_NAME	Corresponding Admission table name
INT_TAB_NAME	Corresponding Interface table name
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_ROOM_ALL	Contains room records
Column Name	Descritpion
ROOM_ID	Unique identifier of the room records
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
BUILDING_ID	Identifier of the building in which the room is located
ROOM_CD	Room code
DESCRIPTION	Detailed description of the room
ORG_ID	Operating unit identifier
PRIMARY_USE_CD	Primary use code
CAPACITY	Capacity of the room
CLOSED_IND	Indicator that shows if the room is used or not
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_REL_CON_INT_ALL	Holds person's relative'' contact details
Column Name	Descritpion
INTERFACE_REL_CON_ID	A unique identifier to identify each relation contact details record. This ID should be populated when the rows are inserted into this table.
PHONE_NUMBER	Phone number
PHONE_EXTENSION	Extension number
STATUS	Status of the record, imported, pending, error or warning
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
DUP_CONTACT_POINT_ID	Duplicate contact point identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
INTERFACE_RELATIONS_ID	A unique identifier assigned to identify each row of the master interface table contents.
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
CONTACT_POINT_TYPE	Represents the type of contact like Email, Phone
EMAIL_ADDRRESS	E-Mail address of the relation, for example, John@yahoo.com.
ORG_ID	Operating unit identifier
EMAIL_FORMAT	Indicates the preferred format for the email addressed to this address, for example, 'HTML', 'ASCII'
PRIMARY_FLAG	Primary flag
PHONE_LINE_TYPE	Indicates the phone line type, for example, Fax, General, Inbound Watts and others.
PHONE_COUNTRY_CODE	Country code for international phone numbers
PHONE_AREA_CODE	The area code within a country code

Student System - IGS_AD_RELEMP_INT_ALL	Contains information about person's relative's employment details to be imported.
Column Name	Descritpion
INTERFACE_RELEMP_ID	Interface relation employment identifier
OCCUPATIONAL_TITLE_CODE	Occupational code identifier
WEEKLY_WORK_HOURS	Weekly work hours
COMMENTS	Comments
EMPLOYER	The name of the organization that the person was employed with. Note that the name should not include the division name.
EMPLOYED_BY_DIVISION_NAME	The common name of a division or an organization in which the Person was employed.
BRANCH	Obsolete. No longer used.
MILITARY_RANK	Obsolete. No longer used.
SERVED	Obsolete. No longer used.
STATION	Obsolete. No longer used.
MATCH_IND	Match indicator
INTERFACE_RELATIONS_ID	Interface relation identifier
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record
DUP_EMPLOYMENT_HISTORY_ID	Duplicate employment history 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
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
CONTACT	Contact information
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
EMPLOYER_PARTY_NUMBER	Party Number Identifier of the employer for the person. This field may be used, when the Employer is a Party in the system. This field is MUTUALLY EXCLUSIVE with Employer field. Validated against HZ_PARTIES.PARTY_NUMBER
REASON_FOR_LEAVING	Reason for leaving the employment
START_DT	Start date of employment
ORG_ID	Operating unit identifier
END_DT	End date of employment
TYPE_OF_EMPLOYMENT	Will Now be validated against lookup HZ_EMPLOYMENT_TYPE
FRACTION_OF_EMPLOYMENT	Fraction of employment
TENURE_OF_EMPLOYMENT	Will Now be validated against lookup HZ_TENURE_CODE
POSITION	Position

Student System - IGS_AD_RELATIONS_INT_ALL	Contains information about person's relationship details
Column Name	Descritpion
INTERFACE_RELATIONS_ID	Interface relation identifier
SEX	Sex of the person
DECEASED	Deceased indicator
DECEASED_DATE	Deceased date
REL_PERSON_ID	Relation person identifier
MATCH_IND	Match indicator
ORG_ID	Operating unit identifier
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
INTERFACE_ID	Interface identifier
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.
PERSON_NUMBER	Person Number Id for Person Number
ACCOUNT_NUMBER	Obsolete this Column- Account Number id for Customer Account Number
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
RELATIONSHIP_TYPE	Relationship type
RELATIONSHIP_CODE	Code for Relationship that exists between the two concerned parties. The Values are pre-seeded for lookup type = 'PARTY_RELATIONS_TYPE'
OTH_RELATIONSHIP_TYPE	Other relationship type
SURNAME	Surname of the person
GIVEN_NAMES	Given names of the person
MIDDLE_NAME	Middle name of the person
TITLE	Title
PRE_NAME_ADJUNCT	Prefix name of the person
PREFERRED_GIVEN_NAME	Preferred given name
BIRTH_DT	Birth date
RECIPROCAL_FLAG	OBSOLETE(Reciprocal flag)

Student System - IGS_AD_RELADDR_INT_ALL	Contains information about person's relatives' address details
Column Name	Descritpion
INTERFACE_RELADDR_ID	Interface relation address Identifier
ADDR_LINE_4	Address line 4
CITY	City
STATE	State
PROVINCE	Province
COUNTY	County
COUNTRY	Country
POSTAL_CODE	Postal Code
OTHER_DETAILS_1	Other Details 1
OTHER_DETAILS_2	Other Details 2
OTHER_DETAILS_3	Other Details 3
SITE_USE_CODE_1	Site usage code 1
INTERFACE_RELATIONS_ID	Interface relation identifier
SITE_USE_CODE_2	Site usage code 2
LOCATION_1	Location 1
LOCATION_2	Location 2
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record
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
CORRESPONDENCE	Correspondence flag
ORG_ID	Operating unit identifier
START_DT	Start date
END_DT	End date
ADDR_LINE_1	Address line1
ADDR_LINE_2	Address line 2
ADDR_LINE_3	Address line 3

Student System - IGS_AD_RELACAD_INT_ALL	Contains information about person's relatives' academic history details
Column Name	Descritpion
INTERFACE_RELACAD_ID	Interface relation academic identifier
START_DATE	Start date at this institution
END_DATE	End date at this institution
PLAN_COMPLETION_DATE	Planned completion date
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
INTERFACE_RELATIONS_ID	Interface relation identifier
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
UPDATE_EDUCATION_ID	Unique identifier to identify which record need to be updated
DUP_ACAD_HISTORY_ID	Unique identifier to identify the duplicate OSS record.
DEGREE_ATTEMPTED	Degree Attempted
DEGREE_EARNED	Degree Earned
INSTITUTION_CODE	Institution code
CURRENT_INST	Current institution indicator
ORG_ID	Operating unit identifier
PROGRAM_TYPE_ATTEMPTED	Program type attempted-obsolete
PROGRAM_TYPE_EARNED	Program type earned-obsolete
PROGRAM_CODE	Program code
VERSION_NUMBER	Program code version number
COMMENTS	Comments

Student System - IGS_AD_REFS_INT_ALL	Holds information about person's reference details
Column Name	Descritpion
INTERFACE_REFS_ID	Interface reference identifier
DUP_PERSON_REFERENCE_ID	Duplicate person reference 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
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_ID	Interface identifier
REFERENCE_TYPE_ID	Reference type identifier
DESCRIPTION	Reference description
ORG_ID	Operating unit identifier
START_DATE	Start date
END_DATE	End date
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record

Student System - IGS_AD_PS_APPL_INST_ALL	Holds the request for program entry for an admission period
Column Name	Descritpion
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
APP_SOURCE_ID	Source of application
ATTRIBUTE40	Descriptive Flex field Column
FUTURE_ACAD_CAL_TYPE	Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUMBER	Future academic calendar type instance
FUTURE_ADM_CAL_TYPE	Future admission calendar type
FUTURE_ADM_CI_SEQUENCE_NUMBER	Future admission calendar type instance
PREVIOUS_TERM_ADM_APPL_NUMBER	Previous admission term application number reference
PREVIOUS_TERM_SEQUENCE_NUMBER	Previous admission term sequence number
FUTURE_TERM_ADM_APPL_NUMBER	Future admission term application number reference
FUTURE_TERM_SEQUENCE_NUMBER	Future admission term sequence number reference
DEF_ACAD_CAL_TYPE	Deferred Academic Calendar Type
DEF_ACAD_CI_SEQUENCE_NUM	Deferred Academic Calendar Sequence Number
DEF_PREV_TERM_ADM_APPL_NUM	Deferred Previous Term Admission Application Number
DEF_PREV_APPL_SEQUENCE_NUM	Deferred Previous Term Application Sequence Number
DEF_TERM_ADM_APPL_NUM	Deferred Term Admission Application Number
DEF_APPL_SEQUENCE_NUM	Deferred Term Application Sequence Number
APPL_INST_STATUS	Application Instance Status
AIS_REASON	Application Instance Status Reason
COURSE_CD	Describes the program code for the program admission application
DECLINE_OFR_REASON	Reason for declining offer
CRV_VERSION_NUMBER	Describes the program version number for the program admission application
ATHLETIC_GPA	Made obsolete in Enhancement bug 2101696
ATHLETIC_ELIGIBILITY_STATUS_ID	Made obsolete in Enhancement bug 2101696
WAITLIST_RANK	Wait list rank
LOCATION_CD	Describes the location code of the program admission application
ATTENT_OTHER_INST_CD	Intend to attend other institution code
ATTENDANCE_MODE	Describes the attendance mode of the program admission application
EDU_GOAL_PRIOR_ENROLL_ID	Education goal prior to enrollment
ATTENDANCE_TYPE	Describes the attendance type of the program admission application
DECISION_MAKE_ID	Decision maker person identifier
UNIT_SET_CD	Describes the unit set code of the program admission application
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
DECISION_DATE	Date when the decision is made
ATTRIBUTE_CATEGORY	Descriptive Flex field qualifier
ATTRIBUTE1	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE2	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE3	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE4	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE5	Standard attribute column. Meant for Descriptive Flex field.
NOMINATED_COURSE_CD	Describes the program code of the program offering instance to that the person is applying for admission
ATTRIBUTE6	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE7	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE8	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE9	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE10	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE11	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE12	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE13	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE14	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE15	Standard attribute column. Meant for Descriptive Flex field.
SEQUENCE_NUMBER	Describes the unique identifier of an admission program application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
ATTRIBUTE16	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE17	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE18	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE19	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE20	Standard attribute column. Meant for Descriptive Flex field.
DECISION_REASON_ID	Decision reason
US_VERSION_NUMBER	Describes the version number of the nominated unit set code of the program admission application
DECISION_NOTES	Decision notes
PENDING_REASON_ID	Pending reason
PREFERENCE_NUMBER	This field describes the applicant preference number of the course
ADM_DOC_STATUS	Describes the documentation status of the admission program application instance
ADM_ENTRY_QUAL_STATUS	Describes the entry qualification status of the admission program application instance
DEFICIENCY_IN_PREP	Deficiencies in preparation
LATE_ADM_FEE_STATUS	Describes the institution-defined fee status for a late program admission application instance
SPL_CONSIDER_COMMENTS	Special consideration comments
APPLY_FOR_FINAID	Indicates if the person has applied for financial aid
FINAID_APPLY_DATE	Date that financial aid application was submitted
ORG_ID	Operating unit identifier
PREDICTED_GPA	Predicted grade point average for the applicant
ADM_OUTCOME_STATUS	Describes the outcome status of the admission program application instance
ADM_OTCM_STATUS_AUTH_PERSON_ID	Describes the ID of the person who authorized the change to the admission outcome status
ADM_OUTCOME_STATUS_AUTH_DT	Describes the date that the change to the outcome status was authorized
ADM_OUTCOME_STATUS_REASON	A reason used to further describe a status, for example, an outcome status of 'Revoked' may have an associated reason for the revocation.
OFFER_DT	Describes the date that an offer of admission was made to the applicant
OFFER_RESPONSE_DT	Indicates the date by that an applicant must respond to the offer of admission. After this date, the offer would be expired by the process that changes the offer response status to Lapsed.
PRPSD_COMMENCEMENT_DT	Describes the proposed commencement date for an admission program application instance
ADM_CNDTNL_OFFER_STATUS	Describes the status assigned to an admission program application in relation to a conditional offer
CNDTNL_OFFER_SATISFIED_DT	Describes the date that a conditional offer was satisfied or waived
CNDTNL_OFFER_MUST_BE_STSFD_IND	Describes whether or not a conditional offer must be satisfied before the offer can be accepted.
ACADEMIC_INDEX	Academic index
ADM_OFFER_RESP_STATUS	Describes the offer response status of the admission program application instance
ACTUAL_RESPONSE_DT	Describes the actual date a response was made by an applicant to an offer
ADM_OFFER_DFRMNT_STATUS	Describes the offer deferment status of the admission program application instance
DEFERRED_ADM_CAL_TYPE	Describes the admission calendar type of the admission period to which the offer has been deferred
DEFERRED_ADM_CI_SEQUENCE_NUM	Describes the admission calendar sequence number of the admission period to which the offer has been deferred
DEFERRED_TRACKING_ID	Describes the tracking ID of a deferral request that has been forwarded for assessment
ASS_RANK	Rank of applicant if offers are determined by comparing all applicants and choosing the highest ranked to satisfy program quotas.
SECONDARY_ASS_RANK	Secondary ranking of an applicant if the desire is to force an offer, or restrict an offer when determining program offers by comparing all applicants.
INTRNTNL_ACCEPTANCE_ADVICE_NUM	The number of the Acceptance Advice form issued to the applicant with their letter of offer. The Acceptance advice form must be presented by the applicant when seeking a student visa.
ASS_TRACKING_ID	Describes the tracking ID of an application that has been forwarded for assessment
ADM_CAL_TYPE	Describes the calendar type of the admission period
FEE_CAT	The Fee Category applicable to the course admission. Fee categories are used to define the set of fees and charges applicable to a student studying a particular course.
HECS_PAYMENT_OPTION	Describes the HECS payment option associated with an offer. This will enable enrollment fee invoices to be produced.
EXPECTED_COMPLETION_YR	The year in which the assessor considers the applicant will have completed all course requirements.
EXPECTED_COMPLETION_PERD	The period, or part of the year, at which time the assessor considers the applicant will have completed all course requirements. The allowable values are Summer, Mid-year or End of Year.
CORRESPONDENCE_CAT	The Correspondence Category applicable to the student's course admission. Correspondence categories are used to define the set of system generated and non-system originated correspondence items which will be sent to the student.
ENROLMENT_CAT	A unique institution-defined code used to describe an Enrolment Category. Enrolment categories are used to define the processes and procedures involved in the enrolment of particular groups of students.
FUNDING_SOURCE	A unique identifier for the institution-defined funding source.
APPLICANT_ACPTNCE_CNDTN	Describes comments regarding the applicant's response to the offer.
CNDTNL_OFFER_CNDTN	Describes the conditions of a conditional offer. An assessor may use this field to list conditions the applicant must satisfy in order to satisfy the conditional offer.
SS_APPLICATION_ID	Self Service Application ID
SS_PWD	Self service Application Password
ENTRY_STATUS	The entry status of an applicant into a program.
ENTRY_LEVEL	The entry level of an applicant into a program.
SCH_APL_TO_ID	School to which a student is applying to, in an institution.
CREATED_BY	Standard Who column
APP_FILE_LOCATION	Application file location
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
AUTHORIZED_DT	Authorized Date
AUTHORIZING_PERS_ID	Authorizing Person ID
IDX_CALC_DATE	Index Calculation Date
WAITLIST_STATUS	This field will be populated only for Outcome Status of "Applicant has been added to a waitlist". Valid values for Waitlist Status are PENDING, ACTIVE and INACTIVE.
ADM_CI_SEQUENCE_NUMBER	Describes the calendar sequence number of the admission period
ATTRIBUTE21	Descriptive Flex field Column
ATTRIBUTE22	Descriptive Flex field Column
ATTRIBUTE23	Descriptive Flex field Column
ATTRIBUTE24	Descriptive Flex field Column
ATTRIBUTE25	Descriptive Flex field Column
ATTRIBUTE26	Descriptive Flex field Column
ATTRIBUTE27	Descriptive Flex field Column
ATTRIBUTE28	Descriptive Flex field Column
ATTRIBUTE29	Descriptive Flex field Column
ATTRIBUTE30	Descriptive Flex field Column
ATTRIBUTE31	Descriptive Flex field Column
ATTRIBUTE32	Descriptive Flex field Column
ATTRIBUTE33	Descriptive Flex field Column
ATTRIBUTE34	Descriptive Flex field Column
ATTRIBUTE35	Descriptive Flex field Column
ATTRIBUTE36	Descriptive Flex field Column
ATTRIBUTE37	Descriptive Flex field Column
ATTRIBUTE38	Descriptive Flex field Column
ATTRIBUTE39	Descriptive Flex field Column

Student System - IGS_AD_PS_APPL_HIST_ALL	Describes history of changes to admission program application
Column Name	Descritpion
REQ_FOR_ADV_STANDING_IND	Indicates a request for advanced standing has been made by the applicant
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
NOMINATED_COURSE_CD	Program code of the program offering instance to that the person is applying for admission
ORG_ID	Operating unit identifier
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 Oracle username of the person who created the history record.
TRANSFER_COURSE_CD	Program code of the student program attempt that the person is applying to transfer from
BASIS_FOR_ADMISSION_TYPE	Institution-defined basis for admission type of the admission program application
ADMISSION_CD	Institution-defined admission code of the admission program application
COURSE_RANK_SET	Describes the ranking of an applicant. The program rank set was identified via QTAC offer program reference data.
COURSE_RANK_SCHEDULE	TAC schedule that the program rank set was based upon
ADMISSION_APPL_NUMBER	Uniquely identifies an admission application for a person.
REQ_FOR_RECONSIDERATION_IND	Describes whether a request for reconsideration for the rejected application has been made.

Student System - IGS_AD_PS_APPL_ALL	Holds information about admission application program
Column Name	Descritpion
REQ_FOR_ADV_STANDING_IND	Indicates a request for advanced standing has been made by the applicant
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
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
NOMINATED_COURSE_CD	Program code of the program offering pattern to that the person is applying for admission.
ORG_ID	Operating unit identifier
TRANSFER_COURSE_CD	Program code of the student program attempt that the person is applying to transfer from.
BASIS_FOR_ADMISSION_TYPE	Institution-defined basis for admission type of the admission program application
ADMISSION_CD	Institution-defined admission code of the admission program application
COURSE_RANK_SET	Describes the ranking of an applicant. The program rank set was identified via QTAC offer course preference data.
COURSE_RANK_SCHEDULE	Tertiary admissions center schedule that the program rank set was based upon.
ADMISSION_APPL_NUMBER	Uniquely identifies an admission application for a person.
REQ_FOR_RECONSIDERATION_IND	Describes whether a request for reconsideration for the rejected application has been made .

Student System - IGS_AD_PS_APLINSTUNT_ALL	Describes admission program unit applications or admission non-award unit applications
Column Name	Descritpion
ASS_TRACKING_ID	Describes the tracking ID of an application that has been forwarded for assessment
RULE_WAIVED_DT	Describes the date on which a failed rule applying to the offered unit was waived.
RULE_WAIVED_PERSON_ID	Describes the person who waived the unit rule applicable to the offered unit
SUP_UNIT_CD	Describes the superior unit code of the unit version being offered
SUP_UV_VERSION_NUMBER	Describes the superior unit version number of the unit version being offered
ADMISSION_APPL_NUMBER	Uniquely identifies an admission application for 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
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
ADM_PS_APPL_INST_UNIT_ID	The value of this column will uniquely identify the record and is provided by oracle sequence IGS_AD_PS_APLINSTUNT_S
NOMINATED_COURSE_CD	Describes the program code of the program offering instance that the person is applying for admission to.
ACAI_SEQUENCE_NUMBER	Unique identifier of an admission program application. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
UNIT_CD	Describes the unit code of the unit offering pattern to that the person is applying for admission
UV_VERSION_NUMBER	Describes the unit version number of the unit offering pattern to that the person is applying for admission
ORG_ID	Operating unit identifier
CAL_TYPE	Describes the teaching calendar type of the unit offering pattern to that the person is applying for admission
CI_SEQUENCE_NUMBER	Describes the teaching calendar sequence number of the unit offering pattern to that the person is applying for admission
LOCATION_CD	Describes the location code of the unit within the admission program application instance
UNIT_CLASS	Describes the unit class of the unit within the admission program application instance. Only one of unit class or unit mode may be nominated.
UNIT_MODE	Describes the unit mode of the unit within the admission program application instance. Only one of unit class or unit mode may be nominated.
ADM_UNIT_OUTCOME_STATUS	Describes the outcome status of the admission program application instance unit
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.

Student System - IGS_AD_PS_APLINSTHST_ALL	Describes history of changes to admission program application instance
Column Name	Descritpion
PERSON_ID	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
US_VERSION_NUMBER	Describes the version number of the unit set code of the program admission application
PREFERENCE_NUMBER	Describes the applicant preference number of the program applied for
ADM_DOC_STATUS	Describes the documentation status of the admission program application instance
ADM_ENTRY_QUAL_STATUS	Describes the entry qualification status of the admission program application instance
LATE_ADM_FEE_STATUS	Describes the institution-defined fee status for a late program admission application instance
ADMISSION_APPL_NUMBER	Uniquely identifies an admission application for a person.
NOMINATED_COURSE_CD	Describes the program code of the program offering instance that the person is applying for admission to.
SEQUENCE_NUMBER	Unique identifier of an admission program application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
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.
ADM_OUTCOME_STATUS	Describes the outcome status of the admission program application instance
ADM_OTCM_STATUS_AUTH_PERSON_ID	Describes the ID of the person who authorized the outcome status
ADM_OUTCOME_STATUS_AUTH_DT	Describes the date that the outcome status was authorized
ADM_OUTCOME_STATUS_REASON	Used to further describe a status, for example, an outcome status of 'Revoked' may have associated reason for the revocation.
HIST_WHO	The Oracle username of the person who created the history record.
OFFER_DT	Describes the date that an offer of admission was made to the applicant
OFFER_RESPONSE_DT	Indicates the date by which an applicant must respond to the offer of admission. After this date, the offer would be expired by the process that changes the offer response status to LAPSED.
PRPSD_COMMENCEMENT_DT	Describes the proposed commencement date for an admission program application instance.
ADM_CNDTNL_OFFER_STATUS	Describes the status assigned to an admission program application in relation to a conditional offer
CNDTNL_OFFER_SATISFIED_DT	Describes the date that a conditional offer was satisfied or waived
HIST_OFFER_ROUND_NUMBER	Describes the number of the offer round the history was created for. This value will only be set as a result of offer round processing.
CNDTNL_OFFER_MUST_BE_STSFD_IND	Describes whether or not a conditional offer must be satisfied before the offer can be accepted
ADM_OFFER_RESP_STATUS	Describes the offer response status of the admission program application instance
ACTUAL_RESPONSE_DT	Describes the actual date a response was made by an applicant to an offer
ADM_OFFER_DFRMNT_STATUS	Describes the offer deferment status of the admission program application instance
DEFERRED_ADM_CAL_TYPE	Describes the admission calendar type of the admission period that the offer has been deferred to
DEFERRED_ADM_CI_SEQUENCE_NUM	Describes the academic calendar sequence number of the admission period that the offer has been deferred to
DEFERRED_TRACKING_ID	Describes the tracking ID of the deferral request that has been forwarded for assessment
ASS_RANK	Rank of applicant if offers are determined by comparing all applicants and choosing the highest ranked to satisfy program quotas.
SECONDARY_ASS_RANK	Secondary ranking of an applicant if the desire is to force an offer, or restrict an offer when determining program offers by comparing all applicants.
INTRNTNL_ACCEPTANCE_ADVICE_NUM	The number on the government window that goes with the offer letter for international applicants to take to the embassy overseas to get their visa.
ASS_TRACKING_ID	Describes the tracking ID of an application that has been forwarded for assessment
ADM_CAL_TYPE	Describes the calendar type of the admission period
ADM_CI_SEQUENCE_NUMBER	Describes the calendar sequence number of the admission period
COURSE_CD	Describes the program code of the admission application
CRV_VERSION_NUMBER	Describes the program version number of the admission application
FEE_CAT	The Fee Category applicable to the program admission. Fee categories are used to define the set of fees and charges applicable to a student studying a particular program.
HECS_PAYMENT_OPTION	Describes the HECS payment option associated with an offer. This will enable enrollment fee invoices to be produced.
EXPECTED_COMPLETION_YR	The year in which the assessor considers the applicant will have completed all program requirements. The assessor also nominates the expected period like Summer, Mid-year or End of Year of program completion. This information can be derive
EXPECTED_COMPLETION_PERD	The period, or part of the year, at which time the assessor considers the applicant will have completed all program requirements. The allowable values are Summer, Mid-year or End of Year.
CORRESPONDENCE_CAT	The correspondence category applicable to the student's program admission. Correspondence categories are used to define the set of system generated and non-system originated correspondence items that will be send to the student.
ENROLMENT_CAT	A unique institution-defined code used to describe an enrollment category. Enrollment categories are used to define the processes and procedures involved in the enrollment of particular groups of students.
FUNDING_SOURCE	A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source.
ORG_ID	Operating unit identifier
APPLICANT_ACPTNCE_CNDTN	Describes the conditions the applicant is requesting as part of their acceptance of an offer, for example, request for scholarship granted, advanced standing approved.
CNDTNL_OFFER_CNDTN	Describes the conditions of a conditional offer. An assessor may use this field to list conditions the applicant must satisfy in order to satisfy the conditional offer.
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
APPL_INST_STATUS	Application Instance Status
DECISION_DATE	Date when the decision is made
DECISION_MAKE_ID	Decision maker person identifier
DECISION_REASON_ID	Decision reason
PENDING_REASON_ID	Pending Reason
WAITLIST_STATUS	This field will be populated only for Outcome Status of "Applicant has been added to a waitlist". Valid values for Waitlist Status are PENDING, ACTIVE and INACTIVE
WAITLIST_RANK	Waitlist Rank
FUTURE_ACAD_CAL_TYPE	Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUM	Future academic calendar type instance
FUTURE_ADM_CAL_TYPE	Future admission calendar type
FUTURE_ADM_CI_SEQUENCE_NUM	Future Admission Calendar Type Instance
DEF_ACAD_CAL_TYPE	Deferred Academic Calendar Type
DEF_ACAD_CI_SEQUENCE_NUM	Deferred Academic Calendar Sequence number
RECONSIDER_FLAG	Reconsideration Flag
DECLINE_OFR_REASON	Reason for declining offer
LOCATION_CD	Describes the location code of the program admission application
ATTENDANCE_MODE	Describes the attendance mode of the program admission application
ATTENDANCE_TYPE	Describes the attendance type of the program admission application
UNIT_SET_CD	Describes the unit set code of the program admission application

Student System - IGS_AD_PS_APINTUNTHS_ALL	Describes history of changes to admission program application instance unit
Column Name	Descritpion
ASS_TRACKING_ID	Describes the tracking ID of an application that has been forwarded for assessment
RULE_WAIVED_DT	Describes the date on which a failed rule applying to the offered unit was waived
RULE_WAIVED_PERSON_ID	Describes the person who waived the unit rule applicable to the offered unit
SUP_UNIT_CD	Describes the superior unit code of the unit version being offered
SUP_UV_VERSION_NUMBER	Describes the superior unit version number of the unit version being offered
NOMINATED_COURSE_CD	Describes the program code of the program offering instance that the person is applying for admission 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
ADM_PS_APPL_INST_UNIT_HIST_ID	The value of this column will uniquely identify the record and is provided by oracle sequence IGS_AD_PS_APINTUNTHS_S
ADM_PS_APPL_INST_UNIT_ID	The value of this column will link the base transaction record
PERSON_ID	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ACAI_SEQUENCE_NUMBER	Unique identifier of an admission program application. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
UNIT_CD	Unit code of the unit offering pattern that the person is applying for admission to.
HIST_START_DT	The effective start date and time of the history record
HIST_END_DT	The effective end date or time of the history record.
HIST_WHO	The Oracle username of the person who created the history record
UV_VERSION_NUMBER	Unit version number of the unit offering pattern that the person is applying for admission to.
CAL_TYPE	Describes the teaching calendar type of the unit offering pattern that the person is applying for admission to.
ORG_ID	Operating unit identifier
CI_SEQUENCE_NUMBER	Describes the teaching calendar sequence number of the unit offering pattern that the person is applying for admission to.
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
LOCATION_CD	Describes the location code of the unit within the admission program application instance
UNIT_CLASS	Describes the unit class of the unit within the admission program application instance
UNIT_MODE	Describes the attendance mode of the admission program application instance unit.
ADM_UNIT_OUTCOME_STATUS	Describes the outcome status of the admission program application instance unit.

Student System - IGS_AD_PRCS_CAT_STEP_ALL	Describes step types which define processing for admission category or admission process type
Column Name	Descritpion
STEP_TYPE_RESTRICTION_NUM	Describes a number restriction on an admission step type. An example of a step type to which number restriction applies is the Limit Preferences step, where the maximum number of preferences may be set as '5'.
STEP_ORDER_NUM	Describes the sequence in which the admission steps are performed. The step order will not apply to certain step group types.
STEP_GROUP_TYPE	Step Group 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
ADMISSION_CAT	The code of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
S_ADMISSION_PROCESS_TYPE	Describes the system-defined processes available for direct admission. For example, Course - course admission, Transfer - course transfer, Re-Admit - re-admission.
ORG_ID	Unit organization identifier
S_ADMISSION_STEP_TYPE	Describes the system admission step types that define processing for the admission category and admission process type specified.
MANDATORY_STEP_IND	Describes whether the step is a mandatory step within the admission data collection process for the relevant admission process category.

Student System - IGS_AD_PRCS_CAT_ALL	Describes user-defined admission category for admission process
Column Name	Descritpion
ADMISSION_CAT	The code of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
LAST_UPDATE_LOGIN	Standard Who column
CLOSED_IND	Closed Indicator
S_ADMISSION_PROCESS_TYPE	Contains the code that identifies the system-defined processes available for direct admission. For example, Course - course admission, Transfer - course transfer, Re-Admit - re-admission.
ORG_ID	Organization unit identifier
OFFER_RESPONSE_OFFSET	Describes the number of days to be added to an applicant's offer date in order to calculate a default offer response date.
RATING_SCALE_ID	Unit rating scale identifier
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_AD_PAST_HISTORY_ALL	Holds details of person's previous educational details
Column Name	Descritpion
PAST_HISTORY_ID	Past history unique identifier
LAST_UPDATE_LOGIN	Standard Who column
YEARS_OF_STUDY	Years of study
SUBJECT_ID	Past subject of study
HONORS	Honors degree
ORG_ID	Organization unit identifier
PERSON_ID	Person Identifier
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_AD_OTHINST_INT_ALL	Contains information about other institutions in which the person is interested to be imported.
Column Name	Descritpion
INTERFACE_OTHINST_ID	Interface other institution details identifier
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_ID	Interface identifier
INTERFACE_APPL_ID	Interface Applicant Identifier
INSTITUTION_CD	Institution code
MATCH_IND	Match indicator
ORG_ID	Operating unit identifier
STATUS	Status of the record whether it is imported, pending, error or warning.
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_NOTES_INT_ALL	Holds information about applicant notes details
Column Name	Descritpion
INTERFACE_NOTES_ID	Interface notes identifier
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_PS_APPL_INST_ID	Interface Program Application Instance Identifier
INTERFACE_ID	Obsolete
INTERFACE_APPL_ID	Obsolete
NOTE_TYPE_ID	Note type identifier
NOTES	Notes
ORG_ID	Operating unit identifier
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_MILITARY_INT_ALL	Holds information about military service details
Column Name	Descritpion
INTERFACE_MILITARY_ID	Interface military identifier
ERROR_CODE	Error code of the record
DUP_MILIT_SERVICE_ID	Duplicate military service 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
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
INTERFACE_ID	Interface identifier
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
ATTRIBUTE_CATEGORY	Flex field Structure defining Column
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
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
MILITARY_TYPE_ID	Military type identifier
ATTRIBUTE19	Descriptive Flex field Segment Column
ATTRIBUTE20	Descriptive Flex field Segment Column
MILITARY_TYPE_CD	Military type code
SEPARATION_TYPE_CD	Separation type code
ASSISTANCE_TYPE_CD	Assistance type code.
ASSISTANCE_STATUS_CD	Assistance status code.
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
START_DATE	Start date
ORG_ID	Operating unit identifier
END_DATE	End date
ASSISTANCE_TYPE_ID	Military assistance type identifier
ASSISTANCE_STATUS_ID	Military assistance status identifier
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning

Student System - IGS_AD_LOCVENUE_ADDR	Contains location venue and address details
Column Name	Descritpion
LOCATION_VENUE_ADDR_ID	Unique identifier for the table
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
LOCATION_ID	Location identifier
LOCATION_VENUE_CD	Location venue code
SOURCE_TYPE	The source type L or V
IDENTIFYING_ADDRESS_FLAG	Address flag for identification - Y or 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_AD_LOCATION_TYPE_ALL	Describes locations used by institution
Column Name	Descritpion
LOCATION_TYPE	Location type. A location type is a classification or grouping of locations, such as Campus or Study center. Each location type is optionally mapped to a system location type to enable the system to determine any associated functionality.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description of a location type. A location type is a classification or grouping of locations, such as Campus or Study center. Each location type is optionally mapped to a system location type to enable the system to determine any associated
S_LOCATION_TYPE	The name of a system-defined location type, such as Campus. Each location type is optionally mapped to a system location type to enable the system to determine any associated functionality.
CLOSED_IND	Specifies if the location type is open or closed. Setting the checkbox to 'closed' prevents use of the location type in new or modified location records.
ORG_ID	Organization unit identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_LOCATION_ALL	Describes available geographic locations at which programs and units may be offered or taught
Column Name	Descritpion
LOCATION_CD	The institution-defined code of a physical location owned or used by the institution. Each location has a location type, such as Campus or Exam location, that defines its use in the system.
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
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
DESCRIPTION	The description of a physical location owned or used by an institution. Each location has a location type, such as Campus, that defines its use in the system.
LOCATION_TYPE	Location type of the location. A location type is a classification or grouping of locations, such as Campus or Examination location. Each location type is optionally mapped to a system location type to enable the system to determine any ass
MAIL_DLVRY_WRK_DAYS	The average number of working days required for correspondence to reach the location using standard mail. This information is of particular relevance for examination locations.
ORG_ID	Operating unit identifier
COORD_PERSON_ID	The person responsible for the coordination of the location. This person may be different from the contact person stored in the address details. In the case of examination locations, the coordinator may also be the supervisor-in-charge, par
CLOSED_IND	Specifies if the location is open or closed. Setting the checkbox to 'closed' prevents use of the location in new or modified records in other parts of the system, for example, in course offering option records.
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
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
ATTRIBUTE_CATEGORY	Descriptive Flex field structure defining column
ATTRIBUTE1	Descriptive Flex field segment column
ATTRIBUTE2	Descriptive Flex field segment column
ATTRIBUTE3	Descriptive Flex field segment column
ATTRIBUTE4	Descriptive Flex field segment column

Student System - IGS_AD_LANGUAGE_INT_ALL	Holds information about person's language details
Column Name	Descritpion
INTERFACE_LANGUAGE_ID	Interface language identifier
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
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
INTERFACE_ID	Interface identifier
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
LANG_STATUS	Language status indicator in reference with a person. Valid values are A and I. By Default taken as A.
UNDERSTANDS_LEVEL	Level of Understanding of the Language by the person. Validated against lookup HZ_LANGUAGE_PROFICIENCY
LANGUAGE_NAME	Language name
NATIVE_LANGUAGE	Native language
ORG_ID	Operating unit identifier
PRIMARY_LANGUAGE_INDICATOR	Primary language indicator
READS_LEVEL	Level of Reading of the Language by the Person. Validated against lookup HZ_LANGUAGE_PROFICIENCY
SPEAKS_LEVEL	Level of Speaking of the Language by the Person. Validated against lookup HZ_LANGUAGE_PROFICIENCY
WRITES_LEVEL	Level of Writting of the Language by the Person. Validated against lookup HZ_LANGUAGE_PROFICIENCY
STATUS	Status of the record whether it is imported, pending, error or warning

Student System - IGS_AD_INTL_INT_ALL	Holds information about international person details
Column Name	Descritpion
INTERFACE_INTL_ID	Interface international identifier
VISA_EXPIRY_DATE	Visa expiry date
ENTRY_DATE	Date of entry
PASSPORT_NUMBER	Passport number
PASSPORT_COUNTRY_CD	Passport country code
PLACE_OF_ENTRY	Place of entry
EXPIRY_DATE	Passport expiry date
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning.
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
INTERFACE_ID	Interface identifier
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
VISA_TYPE	Visa type
VISA_NUMBER	Visa number
ORG_ID	Operating unit identifier
INTRNTNL_AGENT_ORG_UNIT_CD	International agent organization unit code
INTRNTNL_AGENT_OU_START_DATE	Start date
INTRNTNL_AGENT_PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
INTRNTNL_AGENT_CONTACT_NAME	Agent contact name
VISA_ISSUE_DT	Visa issue date

Student System - IGS_AD_UP_HEADER	Holds unit placement header details
Column Name	Descritpion
UP_HEADER_ID	Unique identifier for the unit placement
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ADMISSION_TEST_TYPE	Admission test type
TEST_SEGMENT_ID	Test segment indicator
DEFINITION_LEVEL	Definition level
MIN_SCORE	Minimum score
MAX_SCORE	Maximum score
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_UP_DETAIL	Holds unit placement details
Column Name	Descritpion
UP_DETAIL_ID	Unique identifier for the unit placement details
LAST_UPDATE_LOGIN	Standard Who column
UP_HEADER_ID	Unit placement header ID
UNIT_CD	Unit code
VERSION_NUMBER	Unit code version
CLOSED_IND	Closed indicator that if checked will prevent any further use of the unit placement detail
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_AD_UNIT_SETS	Holds desired unit set details
Column Name	Descritpion
UNIT_SET_ID	Unique identifier for the applicants desired unit set details
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
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence.
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	Nominated program code
SEQUENCE_NUMBER	Sequence number
UNIT_SET_CD	Unit set desired
VERSION_NUMBER	Unit set version number
RANK	Unit set rank
CREATED_BY	Standard Who column

Student System - IGS_AD_UNIT_OU_STAT	Describes user-defined admission unit outcome statuses, which map to system admission outcome statuses
Column Name	Descritpion
ADM_UNIT_OUTCOME_STATUS	The institution-defined status assigned to an admission application for a unit of study to indicate the outcome of the application. These must map back onto the system-defined list.
CLOSED_IND	Specifies whether or not the admission unit outcome status is closed. Selecting the checkbox closes the admission unit outcome status and prevents further allocation of the status to an admission application unit.
DESCRIPTION	Explanation of the admission unit outcome 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
S_ADM_OUTCOME_STATUS	Describes the system-defined status to indicate the current state of an admission application in terms of the outcome of assessment of the application. For example, Offer to be made, Rejected.
SYSTEM_DEFAULT_IND	Specifies if the admission unit outcome status is the default for admissions. Selecting the checkbox signifies that the admission unit outcome status will be used as the default for admissions.

Student System - IGS_AD_TST_RSLT_DTLS	Holds test result details
Column Name	Descritpion
TST_RSLT_DTLS_ID	Unique identifier that identifies the test segments for a test
SCORE_BAND_UPPER	Score band upper
IRREGULARITY_CODE_ID	Any irregularity associated with the test conducted like data cancelled, candidate being absent or delayed in taking the test, candidate canceling the test.
ATTRIBUTE_CATEGORY	Descriptive Flex field structure defining column
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
TEST_RESULTS_ID	Unique identifier that identifies the test results
ATTRIBUTE8	Descriptive Flex field segment column
ATTRIBUTE9	Descriptive Flex field segment column
ATTRIBUTE10	Descriptive Flex field segment column
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
TEST_SEGMENT_ID	Unique identifier that identifies a test segment
ATTRIBUTE18	Descriptive Flex field segment column
ATTRIBUTE19	Descriptive Flex field segment column
ATTRIBUTE20	Descriptive Flex field segment column
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
TEST_SCORE	Test score for this test segment
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
PERCENTILE	Test score percentile
NATIONAL_PERCENTILE	Score percentile of national pool of test takers
STATE_PERCENTILE	Score percentile of state pool of test takers
PERCENTILE_YEAR_RANK	Percentile year rank
SCORE_BAND_LOWER	Score band lower

Student System - IGS_AD_TSTSCR_USED	Holds test scores used details
Column Name	Descritpion
TSTSCR_USED_ID	A unique identifier assigned to each of the test scores used details
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
ATTRIBUTE11	Descriptive Flex field segment column
ATTRIBUTE12	Descriptive Flex field segment column
COMMENTS	Comments
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
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	Nominated program code
SEQUENCE_NUMBER	Sequence number
ATTRIBUTE_CATEGORY	Descriptive Flex field structure defining column
ATTRIBUTE1	Descriptive Flex field segment column
ATTRIBUTE2	Descriptive Flex field segment column

Student System - IGS_AD_TERM_DETAILS	Holds term details
Column Name	Descritpion
TERM_DETAILS_ID	Unique identifier for the term details
GPA	Grade point average
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
TRANSCRIPT_ID	Transcript identifier
TERM	Term name
START_DATE	Term starting date
END_DATE	Term ending date
TOTAL_CP_ATTEMPTED	Total credit points attempted
TOTAL_CP_EARNED	Total credit points earned
TOTAL_UNIT_GP	Total unit grade points
TOTAL_GPA_UNITS	Total grade point average units

Student System - IGS_AD_TAC_LV_OF_COM	Describes levels of completion recognized by relevant TAC
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
TAC_LEVEL_OF_COMP	Contains a code recognized by the relevant tertiary admission center to define the level of completion of studies assigned to an applicant on the basis of their current qualifications
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Provides an explanation of the tertiary admission center level of completion
CLOSED_IND	Specifies if the tertiary admission center level of completion is open or closed. Selecting the checkbox to 'closed' prevents use of the tertiary admission center level of completion in new or modified level of completion records.

Student System - IGS_AD_TAC_LVL_OF_QF	Describes levels of completion recognized by relevant TAC
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
TAC_LEVEL_OF_QUAL	Contains a code recognized by the relevant tertiary admission center to define the level of qualification assigned to an applicant on the basis of their current qualifications. For example, TBABACHELORS DEGREE, TGD - GRADUATE DIPLOMA, TCM
DESCRIPTION	Provides an explanation of the tertiary admission center level of qualification
CLOSED_IND	Specifies if the tertiary admission center level of qualification is open or closed. Selecting the checkbox to 'closed' prevents use of the tertiary admission center level of qualification in new or modified level of qualification records.

Student System - IGS_AD_TAC_AUSCED_AS	Describes TAC assessment types for secondary education
Column Name	Descritpion
CLOSED_IND	Specifies whether the tertiary admissions center Australian Secondary Education Assessment Type code is open or closed. Selecting the indicator to 'closed' prevents use of the code in new or modified records.
TAC_AUS_SCNDRY_EDU_ASS_TYPE	Describes the tertiary admissions center Australian Secondary Education Assessment Type
DESCRIPTION	Provides an explanation of the Tertiary Admissions Center Australian Secondary Education Assessment 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

Student System - IGS_AD_TAC_AD_CD	Describes admission codes that are recognized by relevant TAC
Column Name	Descritpion
TAC_ADMISSION_CD	Contains an admission code recognized by the relevant tertiary admission center to define the matriculation category assigned to an applicant on the basis of their current qualifications.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Provides an explanation of the tertiary admission center admission code
CLOSED_IND	Specifies if the tertiary admission center admission code is open or closed. Selecting the checkbox to 'closed' < ticked > prevents use of the tertiary admission center admission code in new or modified admission code records.
CREATED_BY	Standard Who column

Student System - IGS_AD_SYSSRC_CAT	Holds system source categories
Column Name	Descritpion
SYSTEM_SOURCE_TYPE	User defined source type
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CLOSED_IND	Closed Indicator
CATEGORY_NAME	Source category
MANDATORY_IND	Mandatory indicator
SS_IND	Self Service Indicator - Obsolete
DISPLAY_SEQUENCE	Display Sequence - Obsolete
AD_TAB_NAME	Corresponding Admission table name
INT_TAB_NAME	Corresponding Interface table name
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_AD_SPL_TALENTS	Holds special talents details
Column Name	Descritpion
SPL_TALENT_ID	Unique identifier for the applicants special talents
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
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence.
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	--Obsolete in 2177686
SEQUENCE_NUMBER	--Obsolete in 2177686
SPECIAL_TALENT_TYPE_ID	Applicant special talent
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_SPL_INTERESTS	Holds special interests details
Column Name	Descritpion
SPL_INTEREST_ID	Unique identifier for the applicants specials interests
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
PERSON_ID	Person Identifier and foreign key to HZ_PARTIES. This is a sequence.
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	--Obsolete in 2177686
SEQUENCE_NUMBER	--Obsolete in 2177686
SPECIAL_INTEREST_TYPE_ID	Applicant special interest
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_RECRUITMENTS	Holds recruitment details
Column Name	Descritpion
RECRUITMENT_ID	Unique identifier of recruitment details record
INSTITUTION_CONTROL_ID	Desired institution control
INSTITUTION_SETTING_ID	Desired institution setting
INSTITUTION_LOCATION_ID	Desired institution location.
SPECIAL_SERVICES_ID	Desired special services
EMPLOYMENT_ID	Desired employment
HOUSING_ID	Desired housing
DEGREE_GOAL_ID	Desired degree goal
UNIT_SET_ID	Desired unit set
CERTAINTY_OF_CHOICE_ID	Certainty of choice of unit set
RELIGION_ID	OBSOLETED. Religion
PERSON_ID	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ADV_STUDIES_CLASSES	Number of advanced studies classes offered
HONORS_CLASSES	Number of honors classes offered
CLASS_SIZE	Class size
SEC_SCHOOL_LOCATION_ID	Secondary school location
PERCENT_PLAN_HIGHER_EDU	% Planning to pursue higher education
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
RELIGION_CD	Religion code
SPECIAL_INTEREST_ID	Person's special interest identifier
PRIORITY	Priority of the recruit
PROBABILITY	Probability of enrollment
VIP	Very important person
DEACTIVATE_RECRUIT_STATUS	Deactivate recruit status
PROGRAM_INTEREST_ID	Recruit program interest
INSTITUTION_SIZE_ID	Desired institution size

Student System - IGS_AD_RATING_SCALES	Holds rating scales used by evaluators to rate applications
Column Name	Descritpion
RATING_SCALE_ID	A unique identifier assigned to each of the rating scales.
LAST_UPDATE_LOGIN	Standard Who column
START_DATE	Start Date for Rating Scales
END_DATE	End Date for Rating Scales
RATING_SCALE_NAME	Rating scale name
DESCRIPTION	Rating scale description
CLOSED_IND	No longer used
DFLT	Default
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_AD_PS_APL_TST_RS	Holds test results for admission applications
Column Name	Descritpion
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
SECTION1	Contains the label for Section 1
SECTION1_SCORE	Contains the score for Section 1
SECTION2	Contains the label for Section 2
SECTION2_SCORE	Contains the score for Section 2
SECTION3	Contains the label for Section 3
SECTION3_SCORE	Contains the score for Section 3
SECTION4	Contains the label for Section 4
SECTION4_SCORE	Contains the score for Section 4
SECTION5	Contains the label for Section 5
SECTION5_SCORE	Contains the score for Section 5
SECTION6	Contains the label for Section 6
SECTION6_SCORE	Contains the score for Section 6
COMMENTS	Comments about the person's admission program application test result can be recorded in this field.
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
ADMISSION_APPL_NUMBER	Uniquely identifies an admission application for a person.
NOMINATED_COURSE_CD	Program code of the program offering instance to that the person is applying for admission
ADMISSION_TEST_TYPE	Types of admission test against which results may be recorded for an applicant
ACHIEVED_DT	Date that the admission test result was achieved
RESULT_SCORE	Describes the score the person achieved for the admission test. There must be a value for one of 'Result Type', 'Result Score' and 'Result Grade'.
RESULT_GRADE	Describes the grade the person achieved for the admission test. There must be a value for one of 'Result Type', 'Result Score' and 'Result Grade'
RESULT_TYPE	Describes the result the person achieved for the admission test. There must be a value for one of 'Result Type', 'Result Score' and 'Result Grade'.

Student System - IGS_AD_PRD_PS_OF_OPT	Describes the relationship among admission periods, admission process types, admission categories, and program offering options
Column Name	Descritpion
ADM_CI_SEQUENCE_NUMBER	Describes the sequence number which uniquely identifies the admission period calendar instance.
ADMISSION_CAT	Describes the admission category that the admission period is restricted to.
S_ADMISSION_PROCESS_TYPE	Describes the system admission process type that the admission period is restricted to.
COURSE_CD	Describes the program code that the admission period is restricted to.
VERSION_NUMBER	The program version number that the admission period is restricted to
ACAD_CAL_TYPE	Describes the program offering calendar type to which the admission period is restricted.
SEQUENCE_NUMBER	Defines the admission process type, admission category and program offering for the admission period. This combination can be repeated for location code, attendance mode and attendance type combinations.
LOCATION_CD	Describes the location code that the admission period is restricted to. If no value is entered, then all locations for available program offering patterns are entry points in this admission period for the specified admission process type, a
ATTENDANCE_MODE	Describes the attendance mode that the admission period is restricted to.
ATTENDANCE_TYPE	Describes the attendance type that the admission period is restricted to.
ROLLOVER_INCLUSION_IND	Indicates if the admission period program and components will be included in the admission calendar rollover process.
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
ADM_CAL_TYPE	Describes the calendar type relating to the admission period.

Student System - IGS_AD_PRD_AD_PRC_CA	Holds the record that describes the relationship among admission periods, admission process types, and admission categories
Column Name	Descritpion
ADM_CAL_TYPE	Describes the calendar type relating to the admission period.
CLOSED_IND	Closed Indicator
SINGLE_RESPONSE_FLAG	Single Offer Response Flag
INCLUDE_SR_IN_ROLLOVER_FLAG	Flag to indicate whether single response flag is to be included in the rollover process or not
ADM_CI_SEQUENCE_NUMBER	Describes the sequence number which uniquely identifies the admission period calendar instance.
ADMISSION_CAT	Describes the admission category that applies to this admission period.
S_ADMISSION_PROCESS_TYPE	Describes the system admission process type that applies to this admission period.
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_AD_PRCS_CAT_LTR	Describes system letters produced for specific admission process categories
Column Name	Descritpion
LETTER_REFERENCE_NUMBER	The unique identifier for a system letter.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
ADMISSION_CAT	Institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
S_ADMISSION_PROCESS_TYPE	Describes the system-defined processes available for direct admission. For example, Program Admission, Program Transfer, Re-admission, Short Admission, Admission to Non-Award Units Of Study.
CORRESPONDENCE_TYPE	Code for the type of correspondence

Student System - IGS_AD_PERD_AD_CAT	Describes admission category and admission calendar instance that define admission period
Column Name	Descritpion
ADM_CAL_TYPE	Describes the admission calendar type relating to the admission period.
ADM_CI_SEQUENCE_NUMBER	Describes the sequence number which uniquely identifies the admission period calendar instance.
ADMISSION_CAT	The code of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
CI_START_DT	Describes the start date of the admission period.
CI_END_DT	Describes the end date of the admission period
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

Student System - IGS_AD_PECRS_OFOP_DT	Describes program offering option specified by the admission period program offering option
Column Name	Descritpion
ADM_CAL_TYPE	Describes the calendar type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADM_CI_SEQUENCE_NUMBER	Describes the calendar sequence number of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ADMISSION_CAT	Describes the admission category of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
DT_ALIAS	Describes the admission date alias that requires further process type, admission category, program offering option restrictions.
DAI_SEQUENCE_NUMBER	Describes the sequence number that defines the admission date alias instance that requires further process type, admission category, program offering option restrictions.
SEQUENCE_NUMBER	Uniquely defines information in this table.
S_ADMISSION_PROCESS_TYPE	Describes the system admission process type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
COURSE_CD	Describes the program code of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
VERSION_NUMBER	Describes the program version number of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ACAD_CAL_TYPE	Describes the program offering calendar type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
LOCATION_CD	Describes the location code of the admission date alias instance that requires further process type ,admission category, program offering option restrictions.
ATTENDANCE_MODE	Describes the attendance mode of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ATTENDANCE_TYPE	Describes the attendance type of the admission date alias instance that requires further process type, admission category, program offering option restrictions.
ROLLOVER_INCLUSION_IND	Describes whether the admission period override date will be included in the admission calendar rollover process.
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_AD_OU_STAT	Describes user-defined admission outcome statuses, which map to system admission outcome statuses
Column Name	Descritpion
ADM_OUTCOME_STATUS	Contains the institution-defined status assigned to an admission application to describe the state of the applicant's request for admission. These must be mapped on to a relevant system-defined admission outcome status.
CLOSED_IND	Specifies if the admission outcome status is open or closed. Setting the checkbox to closed, prevents use of the admission outcome status in new or modified admission application records.
DESCRIPTION	Provides an explanation of the admission outcome 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
S_ADM_OUTCOME_STATUS	Contains the system-defined status assigned to an admission application to describe the state of the applicant's request for admission. For example, PENDING, OFFER, COND-OFFER etc..
SYSTEM_DEFAULT_IND	Specifies if the admission outcome status is the default institution-defined status that the system should use when referred to from a system-defined admission outcome status.

Student System - IGS_AD_OTHER_INST	Holds details about other institutions to which the applicant has applied
Column Name	Descritpion
OTHER_INST_ID	Unique identifier for the other institutions that the applicant has applied for
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.
NEW_INSTITUTION	New Institution
PERSON_ID	Person ID
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	--Obsolete in 2177686
SEQUENCE_NUMBER	--Obsolete in 2177686
INSTITUTION_CODE	Institution code
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_OS_SEC_ED_SUB	Describes secondary education subject details that are required for assessment of an admissions application.
Column Name	Descritpion
SUBJECT_DESC	Describes the overseas secondary education subject.
RESULT_TYPE	Type of result for the overseas secondary education subject attempt.
RESULT	Result of the applicant's overseas secondary education subject attempt.
SUBJECT_RESULT_YR	Year the result was given for an overseas secondary education subject attempt.
CREATED_BY	Standard Who column
PERSON_ID	Contains the institution-defined number that uniquely identifies a person.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OSE_SEQUENCE_NUMBER	Identifies uniquely an overseas secondary education subject record for a person.
SEQUENCE_NUMBER	Identifies uniquely an overseas secondary education subject record for a person.
SUBJECT_CD	Contains the code that identifies the subject

Student System - IGS_AD_OS_SEC_EDU_QF	Describes secondary education qualifications
Column Name	Descritpion
OS_SCNDRY_EDU_QUALIFICATION	Contains a code that identifies the type of overseas secondary education qualification
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Provides an explanation of the overseas secondary education qualification
COUNTRY_CD	Contains a code that identifies which countries award this particular overseas secondary education qualification. This is an optional requirement for overseas secondary education qualifications. However, once codes are recorded in this fie
CLOSED_IND	Specifies if the overseas secondary education qualification code is opened or closed. Setting the indicator to 'closed' prevents use of the code in new or modified secondary education records.
CREATED_BY	Standard Who column

Student System - IGS_AD_OS_SEC_EDU	Describes secondary education details that are required for assessment of an admissions application
Column Name	Descritpion
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
CANDIDATE_NUMBER	Contains the candidate number associated with the applicant's Overseas Secondary Education attempt
SCHOOL_NAME	Name of the school where the Overseas Secondary Education was undertaken
COUNTRY_CD	Identifies the institution-defined code for a country. These must be mapped to a Government country code - DETYA element reference 346.
SEQUENCE_NUMBER	Uniquely identifies an Overseas Secondary Education record for a person
COMMENTS	A text-based facility for recording and maintaining notes of up to 2,000 characters regarding the Overseas Secondary Education record.
CREATED_BY	Standard Who column
RESULT_OBTAINED_YR	The year in which the Overseas Secondary Education result was obtained by the applicant.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESULT	Contains the result obtained in the applicant's Overseas Secondary Education Qualification attempt.
OS_SCNDRY_EDU_QUALIFICATION	Contains a code that identifies the type of Overseas Secondary Education Qualification

Student System - IGS_AD_OFR_RESP_STAT	Describes user-defined admission offer response statuses, which map to system admission offer response statuses
Column Name	Descritpion
ADM_OFFER_RESP_STATUS	Contains the institution-defined status assigned to an admission application to describe the state of the applicant's response to an offer of admission. These must be mapped on to a relevant system-defined admission offer response status .F
CLOSED_IND	Specifies if the admission offer response status is open or closed. Setting the checkbox to 'closed' prevents use of the admission offer response status in new or modified admission application records.
DESCRIPTION	Provides an explanation of the admission offer response 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
S_ADM_OFFER_RESP_STATUS	Contains the system-defined status assigned to an admission application to describe the state of the applicant's response to an offer of admission. For example, Pending, Accepted, Lapsed.
SYSTEM_DEFAULT_IND	Specifies if the admission offer response status is the default institution-defined status that the system should use when referred to from a system-defined admission offer response status.

Student System - IGS_AD_OFRDFRMT_STAT	Describes user-defined admission offer deferment statuses, which map to system admission offer deferment statuses
Column Name	Descritpion
ADM_OFFER_DFRMNT_STATUS	Contains the institution-defined status assigned to an admission application to describe the state of a request by the applicant for deferral of their admission. These must be mapped on to a relevant system-defined admission offer deferment
CLOSED_IND	Specifies if the admission offer deferment status is open or closed. Setting the checkbox to 'closed' prevents use of the admission offer deferment status in new or modified admission application records.
DESCRIPTION	Provides an explanation of the admission offer deferment 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
S_ADM_OFFER_DFRMNT_STATUS	Contains the system-defined status assigned to an admission application to describe the state of a request by the applicant for deferral of their admission. For example, Pending, Approved, Rejected.
SYSTEM_DEFAULT_IND	Specifies if the admission offer deferment status is the default institution-defined status that the system should use when referred to from a system-defined admission offer deferment status. Setting the checkbox to 'system default' ensure

Student System - IGS_AD_NOTE_TYPES	Holds setup details about note types
Column Name	Descritpion
NOTES_TYPE_ID	Unique identifier for each notes type
LAST_UPDATE_LOGIN	Standard Who column
NOTES_CATEGORY	Stores the categories of notes. It is picked up from IGS_LOOKUPS where the LOOKUP_TYPE is equal to 'APPL_NOTE_CATEGORIES'.
NOTE_TYPE	Stores a unique value for each value of notes category
DESCRIPTION	Description for the note type
CLOSED_IND	An indicator that specifies if the note type is open or closed. Setting the checkbox to 'closed' prevents use of the note type in new records.
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_AD_RECRT_PI_INT_ALL	Contains information about recruitment probability index values
Column Name	Descritpion
PRBLTY_VAL_INT_ID	Sequence generated unique identifier for each record.
PRBLTY_SOURCE_CODE_ID	The Identifier of the Probability Source Class.
STATUS	Status of the Record.
MATCH_IND	Match Indicator.
ERROR_CODE	Error code of the record.
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
PRBLTY_VAL_BATCH_ID	Unique no for a batch processed by user, sequence generated to be provided by OSS IGS_AD_RECRT_PI_INT_S.
ORG_ID	Organization Identifier.
PERSON_ID	Person Identifier for whom the record is imported.
API_PERSON_ID	Alternate Person ID.
PERSON_ID_TYPE	Alternate Person ID type
PRBLTY_TYPE_CODE_ID	The identifier of the probability Type Class.
CALCULATION_DATE	Calculation Date.
PROBABILITY_VALUE	Probability values in Number.

Student System - IGS_AD_RECRT_PI_HDR_ALL	This table stores information about batch IDs for the probability import.
Column Name	Descritpion
PRBLTY_VAL_BATCH_ID	Unique number for a batch processed by user, sequence generated to be provided by OSS
DESCRIPTION	Description of the Batch
ORG_ID	Organization 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_AD_TXCPT_INT_ALL	Holds transcript details.
Column Name	Descritpion
INTERFACE_TRANSCRIPT_ID	Unique identifier for the transcript record
TRANSCRIPT_ID	Holds the unique identifier of the table which is populated by the interface table.
DATE_OF_RECEIPT	Indicates the date on which the record was received
ENTERED_GPA	Indicated the entered grade point average
CONV_GPA	Holds the converted grade point average
RANK_IN_CLASS	Rank in class for the student
CLASS_SIZE	Indicates the class size
APPROXIMATE_RANK	Indicates the approximate rank of the student
WEIGHTED_RANK	Indicates the weighted rank
DECILE_RANK	Indicates the decile rank
QUARTILE_RANK	Indicates the quartile rank
TRANSCRIPT_STATUS	Indicates the transcript status
QUINTILE_RANK	Indicates the quintile rank
PERCENTILE_RANK	Indicates the percentile rank
MATCH_IND	Indicates the match between the interface record and record present in the system.
ERROR_CODE	Indicates the error that occurred during the import process.
DUP_TRANSCRIPT_ID	Holds the duplicate transcript ID
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
TRANSCRIPT_TYPE	Indicates the transcript type
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
DATE_OF_ISSUE	Date on which the transcript is issued
TRANSCRIPT_SOURCE	Indicates the source of the transcript details.
INTERFACE_ACADHIS_ID	Refers to the link with Academic History table
STATUS	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
ENTERED_GS_ID	Holds the entered grading schema ID
CONV_GS_ID	Holds the converted grading schema ID
TERM_TYPE	Holds the term type

Student System - IGS_AD_RECRUIT_PI	Contains information about recruitment probability index values
Column Name	Descritpion
PROBABILITY_INDEX_ID	Sequence generated number that uniquely identifies the probability index line in the database.
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
PERSON_ID	Foreign key to main table HZ_PARTIES
PROBABILITY_TYPE_CODE_ID	Identifier of the probability type class
CALCULATION_DATE	Calculation Date
PROBABILITY_VALUE	Probability values in Number.
PROBABILITY_SOURCE_CODE_ID	The identifier of the Probability Source Class.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Student System - IGS_AD_TRMDT_INT_ALL	Contains student's term details.
Column Name	Descritpion
INTERFACE_TERM_DTLS_ID	Unique identifier for the table
TOTAL_UNIT_GP	Total unit grade points
TOTAL_GPA_UNITS	Total grade point average units
GPA	Grade point average of the student
MATCH_IND	Indicates the match between the interface record and record present in the system.
ERROR_CODE	Indicates the error, if any, that occurred in the import process
DUP_TERM_DTLS_ID	Duplicate Term Details ID
ORG_ID	Operating unit identifier
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
INTERFACE_TRANSCRIPT_ID	Indicates the link between transcript table
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	Indicates the term start date
END_DATE	Indicates the term end date
TERM	Indicates the term
STATUS	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
TERM_DETAILS_ID	The unique identifier of the system table which will be populated by the interface table.
TOTAL_CP_ATTEMPTED	Total credit points attempted
TOTAL_CP_EARNED	Total credit points earned

Student System - IGS_AD_TUNDT_INT_ALL	Contains term unit details.
Column Name	Descritpion
INTERFACE_TERM_UNITDTLS_ID	Unique identifier for the interface record.
GRADE	Indicates the grades earned.
UNIT_GRADE_POINTS	Unit grade points
MATCH_IND	Indicates the match between the interface record and record present in the system.
ERROR_CODE	Holds the error code for any error that occurred during processing.
DUP_TERM_UNITDTLS_ID	Duplicate Term Details ID
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
INTERFACE_TERM_DTLS_ID	Reference to the term details record
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard who column for concurrent program
PROGRAM_APPLICATION_ID	Standard who column for concurrent program
PROGRAM_ID	Standard who column for concurrent program
PROGRAM_UPDATE_DATE	Standard who column for concurrent program
UNIT	Indicates the unit for the term
UNIT_DIFFICULTY	Indicates the unit difficulty
UNIT_NAME	Holds the unit name
STATUS	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
UNIT_DETAILS_ID	Holds the unique identifier of the system table which is loaded by the interface table.
CP_ATTEMPTED	Credit points attempted
CP_EARNED	Credit points earned

Student System - IGS_AD_SCHL_APLY_TO	Stores information of school applied under different organization
Column Name	Descritpion
SCH_APL_TO_ID	The Unique identifier of the School Applying to
LAST_UPDATE_LOGIN	Standard WHO column
SCHOOL_APPLYING_TO	School Name
DESCRIPTION	Description of the school applying to
ORG_UNIT_CD	Identifier of the Organizational unit
CLOSED_IND	Indication for the current record. Value in Table would be 'Y'(Checked) if closed or 'N'(Unchecked) if open for use
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_AD_TSTDTL_UH_INT	This table contains admissions test result details interface records.
Column Name	Descritpion
INTERFACE_TST_ID	Interface Test Results Identifier
TEST_SEGMENT_ID	Interface Test Segment Identifier
TEST_SCORE	Test Segment Score
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
INTERFACE_TSTDTL_ID	Unique identifier of the Admissions Test Result Details interface record
REQUEST_ID	Standard WHO column for the concurrent program
PROGRAM_APPLICATION_ID	Standard WHO column for the concurrent program
PROGRAM_ID	Standard WHO column for the concurrent program
PROGRAM_UPDATE_DATE	Standard WHO column for the concurrent program

Student System - IGS_AD_I_USET_PREFS	Stores inquiry unit set preferences corresponding to person's inquiry instance - Obsolete
Column Name	Descritpion
INQ_UNIT_SET_PREF_ID	Unique identifier of a inquiry unit set preference 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
PERSON_ID	Unique identifier of a person
ENQUIRY_APPL_NUMBER	Unique identifier for an inquiry application
INQ_UNIT_SET_CODE_ID	Unit set code id
UNIT_SET_PREF_ID	Unit set preference id
REQUEST_ID	Id columns related to import process
PROGRAM_APPLICATION_ID	Id columns related to import process
PROGRAM_ID	Id columns related to import process
PROGRAM_UPDATE_DATE	Id columns related to import process

Student System - IGS_AD_I_UST_PKG_ITM	Stores inquiry package items corresponding to inquiry unit set code - Obsolete
Column Name	Descritpion
INQ_U_SET_PKG_ITEM_ID	Unique identifier of an inquiry package item corresponding to an inquiry unit set
INQ_UNIT_SET_CODE_ID	Unique identifier for inquiry unit set
ENQUIRY_PACKAGE_ITEM	Inquiry package item
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_AD_I_ENTRY_LVLS	Stores inquiry entry levels - Obsolete
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_AD_SS_REGIONS	(Obsolete Table) Stores entry regions corresponding to entry status identifier
Column Name	Descritpion
ENTRY_REGION_ID	Unique identifier of a region corresponding to an entry status
LAST_UPDATE_LOGIN	Standard who column
INQ_ENTRY_STAT_ID	Inquiry entry status identifier
REGION_CD	Unique id for a region
USAGE_TYPE	Usage for the region, used if region value is related to address
DISPLAY_IND	Display 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_AD_SS_REGN_ATTRS	(Obsolete Table) Stores entry region attributes corresponding to region identifier
Column Name	Descritpion
ENTRY_REGION_ATTR_ID	Unique identifier of an attribute corresponding to a region
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
ENTRY_REGION_ID	Unique identifier of a region corresponding to an entry status
ATTRIBUTE_CD	Unique id for an attribute
DISPLAY_IND	Display indicator
MANDATORY_IND	Mandatory indicator
DISPLAY_SEQ	Sequence in which the attributes will be displayed in the self service inquiry web page
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column

Student System - IGS_AD_I_PRG_PREFS	Stores inquiry program preferences corresponding to person's inquiry instance - Obsolete
Column Name	Descritpion
INQ_PROG_PREF_ID	Unique identifier of a inquiry program pref.
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	Unique identifier of a person
ENQUIRY_APPL_NUMBER	Unique identifier for an inquiry application
INQ_PROG_CODE_ID	Program code id
PROG_PREF_ID	Program preference id
REQUEST_ID	Id columns related to import process
PROGRAM_APPLICATION_ID	Id columns related to import process
PROGRAM_ID	Id columns related to import process
PROGRAM_UPDATE_DATE	Id columns related to import process

Student System - IGS_AD_I_PRG_PRF_UST	Stores inquiry unit set preferences corresponding to an inquiry program - Obsolete
Column Name	Descritpion
INQ_PRG_PREF_USET_ID	Unique identifier of a inquiry unit set preference corresponding to a inquiry program
INQ_PROG_PREF_ID	Unique identifier of a inquiry program preference
INQ_PROG_UNIT_SET_ID	Unique identifier of an inquiry unit set preference
UNIT_SET_PREF_ID	Unit set preference
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_AD_RECRUIT_INT	Holds recruitment details to be imported for a person.
Column Name	Descritpion
INTERFACE_RECRUITMENT_ID	Unique identifier of recruitment details record
PROGRAM_INTEREST_ID	Recruit program interest
INSTITUTION_SIZE_ID	Desired institution size
INSTITUTION_CONTROL_ID	Desired institution control
INSTITUTION_SETTING_ID	Desired institution setting
INSTITUTION_LOCATION_ID	Desired institution location
SPECIAL_SERVICES_ID	Desired special services
EMPLOYMENT_ID	Desired employment
HOUSING_ID	Desired housing
DEGREE_GOAL_ID	Desired degree goal
UNIT_SET_ID	Desired unit set
INTERFACE_ID	Interface identifier
CERTAINTY_OF_CHOICE_ID	Certainty of choice of unit set
RELIGION_ID	Religion
ADV_STUDIES_CLASSES	Number of advanced studies classes offered
HONORS_CLASSES	Number of honors classes offered
CLASS_SIZE	Class size
SEC_SCHOOL_LOCATION_ID	Secondary school location
PERCENT_PLAN_HIGHER_EDU	Percent Planning to pursue higher education
MATCH_IND	Match indicator
STATUS	1-Completed 2- Pending 3-Error 4-Warning
ERROR_CODE	Error code
DUP_RECRUITMENT_ID	Duplicate recruitment record
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
RELIGION_CD	Religion code
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ERROR_TEXT	Error Text
SPECIAL_INTEREST_ID	Person's special interest identifier
PRIORITY	Priority of the recruit
PROBABILITY	Probability of enrollment
VIP	Very important person
DEACTIVATE_RECRUIT_STATUS	Deactivate recruit status

Student System - IGS_AD_SYSDSCP_ATTR	Holds the system-defined attributes for each category - Obsolete
Column Name	Descritpion
SYSDISCREPANCY_ATTR_ID	Unique identifier of system discrepancy attribute
CATEGORY_NAME	System category name
ATTRIBUTE_NAME	Attribute name for different categories
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_I_PRG_U_SET	Stores inquiry unit set codes corresponding to an inquiry program code - Obsolete
Column Name	Descritpion
INQ_PROG_UNIT_SET_ID	Unique identifier of an inquiry unit set code corresponding to an inquiry program code
INQ_PROG_CODE_ID	Unique identifier for inquiry program code
INQ_UNIT_SET_CODE_ID	Inquiry unit set code id
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_AD_I_PRG_PKG_ITM	Stores inquiry package items corresponding to inquiry program codes - Obsolete
Column Name	Descritpion
INQ_PROG_PKG_ITEM_ID	Unique identifier of an inquiry package item corresponding to an inquiry program
INQ_PROG_CODE_ID	Unique identifier for inquiry program code
ENQUIRY_PACKAGE_ITEM	Inquiry package item
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_AD_I_ENTRY_STATS	Stores inquiry entry statuses - Obsolete
Column Name	Descritpion
INQ_ENTRY_STAT_ID	Unique identifier of a inquiry entry status
PROG_CODE_REDUC_CD	Program code reduction code
UNIT_SET_REDUC_CD	Unit set reduction code
PKG_ITEM_REDUC_CD	Package item reduction code
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
CONFIGURABILITY_FUNC_NAME	Configurability function name.
INQ_ENTRY_STAT	Inquiry entry status
DESCRIPTION	Description
HIERARCHY_CD	Hierarchy code
ENQUIRY_SOURCE_TYPE	Inquiry source
ACTIVITY_SOURCE_CD	Activity source code
INSTITUTION_TYPE	Institution type
TEST_SOURCE_ID	Self reported test source id
IMP_SOURCE_TYPE_ID	Import source type id
EMAIL_LINK	Email address

Student System - IGS_AD_TSTRST_UH_INT	This table contains admissions test results interface records.
Column Name	Descritpion
PERSON_ID	Person Identifier or Party Identifier
SESSION_ID	Session Identifier for this Record, populated by User Hook Procedure
TEST_TYPE	Admission Test Type
TEST_DATE	Test Date
ACTIVE_IND	Test Type Active Flag
STATUS	Status of the Record.
ERROR_CODE	Error Code of the interface record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
INTERFACE_TST_ID	Unique identifier of the interface test result record
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 program
PROGRAM_APPLICATION_ID	Standard WHO column for concurrent program
PROGRAM_ID	Standard WHO column for concurrent program
PROGRAM_UPDATE_DATE	Standard WHO column for concurrent program

Student System - IGS_AD_LOC_ACCTS_ALL	Stores information of user defined account hierarchy
Column Name	Descritpion
LOCATION_ACCOUNT_ID	Sequence generated primary key column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LOCATION_CD	The institution-defined code of a physical location owned or used by the institution. Each location has a location type, such as Campus or Exam location, that defines its use in the system.
SEGMENT	GL Accounting flexfield structure segment name
SEGMENT_NUM	GL Accounting flex field segment number
SEGMENT_VALUE	GL Accounting flex field segment value
ORG_ID	Multi Org operating unit ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_PS_APPL_INST_INT	Interface table that holds the application instance details for a person's application
Column Name	Descritpion
INTERFACE_PS_APPL_INST_ID	Interface Admission Program Application Instance Identifier
INTRNTNL_ACCEPTANCE_ADVICE_NUM	The number of the Acceptance Advice form issued to the applicant with their letter of offer. The Acceptance advice form must be presented by the applicant when seeking a student visa.
UPDATE_ADM_APPL_NUMBER	Update Admission Application Number
ASS_TRACKING_ID	Describes the tracking ID of an application that has been forwarded for assessment
FEE_CAT	The fee category applicable to the program admission. Fee categories are used to define the set of fees and charges applicable to a student studying a particular program.
HECS_PAYMENT_OPTION	Describes the HECS payment option associated with an offer. This will enable enrollment fee invoices to be produced.
EXPECTED_COMPLETION_PERD	The period, or part of the year, at which time the assessor considers the applicant will have completed all program requirements.
EXPECTED_COMPLETION_YR	The year in which the assessor considers the applicant will have completed all program requirements.
CORRESPONDENCE_CAT	The Correspondence Category applicable to the student's program admission.
ENROLMENT_CAT	Unique institution-defined code used to describe an Enrollment Category. Enrollment categories are used to define the processes and procedures involved in the enrollment of particular groups of students.
FUNDING_SOURCE	A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source.
NOMINATED_COURSE_CD	Nominated program Code
ATTRIBUTE_CATEGORY	Descriptive Flex field qualifier
ATTRIBUTE1	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE2	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE3	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE4	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE5	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE6	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE7	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE8	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE9	Standard attribute column. Meant for Descriptive Flex field.
DUP_NOMINATED_COURSE_CD	Duplicate Nominated Program Code
ATTRIBUTE10	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE11	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE12	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE13	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE14	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE15	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE16	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE17	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE18	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE19	Standard attribute column. Meant for Descriptive Flex field.
TRANSFER_COURSE_CD	Transfer Program Code
ATTRIBUTE20	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE21	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE22	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE23	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE24	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE25	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE26	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE27	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE28	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE29	Standard attribute column. Meant for Descriptive Flex field.
BASIS_FOR_ADMISSION_TYPE	This is the institution-defined basis for admission type of the admission program application.
ATTRIBUTE30	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE31	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE32	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE33	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE34	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE35	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE36	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE37	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE38	Standard attribute column. Meant for Descriptive Flex field.
ATTRIBUTE39	Standard attribute column. Meant for Descriptive Flex field.
ADMISSION_CD	This is the institution-defined admission code of the admission program application.
ATTRIBUTE40	Standard attribute column. Meant for Descriptive Flex field.
ENTRY_LEVEL	The entry level of an applicant into a program.
ENTRY_STATUS	The entry status of an applicant into a program.
FINAID_APPLY_DATE	Date that financial aid application was submitted
PREFERENCE_NUMBER	Describes the applicant preference number of the program applied for
SCH_APL_TO_ID	School to which a student is applying to, in an institution.
SS_APPLICATION_ID	Self Service Application ID
UNIT_SET_CD	Describes the unit set code of the program admission application
US_VERSION_NUMBER	Describes the version number of the nominated unit set code of the program admission application
COURSE_RANK_SET	This field describes the ranking of an applicant.
ERROR_CODE	Error Code for the Record
ERROR_TEXT	Error Text for the Record
MATCH_IND	Match Indicator for the Interface Record
STATUS	Status of the record whether it is imported, pending, error or warning
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
COURSE_RANK_SCHEDULE	Tertiary admissions center schedule that the program rank set was based upon.
REQUEST_ID	Concurrent Program WHO columns
PROGRAM_APPLICATION_ID	Concurrent Program WHO columns
PROGRAM_ID	Concurrent Program WHO columns
PROGRAM_UPDATE_DATE	Concurrent Program WHO columns
SEQUENCE_NUMBER	Sequence Number for the application instance
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
UPDATE_ADM_SEQ_NUMBER	The valid values for this column are the sequence_number queried from IGS_AD_PS_APPL_INST for the given course_cd , person_id , admission_appl_number.Import process will update the application instance with sequence_number as this column va
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
INTERFACE_APPL_ID	Interface Application
REQ_FOR_ADV_STANDING_IND	Indicates a request for advanced standing has been made by the
ADMISSION_APPLICATION_TYPE	Admission application type.This column will be populated by the import process.
APP_SOURCE_ID	Application Source Identifier
CRV_VERSION_NUMBER	Describes the program version number for the program admission application
LOCATION_CD	Describes the location code of the program admission application
ATTENDANCE_MODE	Describes the attendance mode of the program admission application
ATTENDANCE_TYPE	This is the attendance type of the program admission
EDU_GOAL_PRIOR_ENROLL_ID	Education goal prior to enrollment
APPLY_FOR_FINAID	Apply for financial Aid
ASS_RANK	Rank of applicant if offers are determined by comparing all applicants and choosing the highest ranked to satisfy program quotas.
SECONDARY_ASS_RANK	Secondary ranking of an applicant if the desire is to force an offer, or restrict an offer when determining program offers by comparing all applicants.

Student System - IGS_AD_PESTAT_GROUP	Admission Personal Statements Group
Column Name	Descritpion
ADMISSION_APPLICATION_TYPE	Admission Application Type
GROUP_MIN	Group Minimum number for Personal Statements
SELF_MESSAGE	Self Service Message for Personal Statements
CREATED_BY	WHO column
CREATION_DATE	WHO column
LAST_UPDATED_BY	WHO column
LAST_UPDATE_DATE	WHO column
LAST_UPDATE_LOGIN	WHO column
GROUP_NUMBER	Group Number for Personal Statements
GROUP_NAME	Group Name
GROUP_REQUIRED_FLAG	Group Required

Student System - IGS_AD_PER_STM_TYP	This table holds the Personal Statement Types
Column Name	Descritpion
PERSL_STAT_TYPE_DESC	Personal Statement Type description
STEP_CATALOG_CD	Step Catalog Code attached to Personal Statement Type
CLOSED_IND	Closed Indicator
CREATED_BY	WHO column
CREATION_DATE	WHO column
LAST_UPDATED_BY	WHO column
LAST_UPDATE_DATE	WHO column
LAST_UPDATE_LOGIN	WHO column
PERSL_STAT_TYPE	Unique Personal Statement Type identifier

Student System - IGS_AD_SS_TEST_CONF	This table stores the attributes of the Admission Test Types Configuration
Column Name	Descritpion
ADMISSION_APPLICATION_TYPE	Admission Application Type
INACTIVE	Admission Test Type Configuration Inactive indicator
CREATED_BY	WHO column
CREATION_DATE	WHO column
LAST_UPDATED_BY	WHO column
LAST_UPDATE_DATE	WHO column
LAST_UPDATE_LOGIN	WHO column
ADMISSION_TEST_TYPE	Admission Test Type attached to the Admission Application Type

Student System - IGS_AD_SS_APPL_TYP	Holds Admission Application Type details
Column Name	Descritpion
DESCRIPTION	Description of the Admission Application Type
USE_IN_APPL_SELF_SRVC	Specifies whether the application type should be displayed to the user in applicant self service or not
CRT_REV_INSTR	Create and Review Instruction
SUBMIT_INSTR	Submit Application Instruction
SUBMIT_ERR_INSTR	Submit Error Instruction
ADMISSION_CAT	Admission Category of the Admission Application Type
S_ADMISSION_PROCESS_TYPE	System Admission Process Type of the Admission Category of Admission Application type
CONFIGURABILITY_FUNC_NAME	Configurability Function Name attached to the Admission Application Type
APPLICATION_FEE_AMOUNT	Application Fee Amount attached to the application type
GL_REV_ACCT_CCID	General Ledger Revenue Account Code Identifier
GL_CASH_ACCT_CCID	General Ledger Cash Account Code Identifier
REV_ACCOUNT_CODE	User Defined Revenue Account Code
ADMISSION_APPLICATION_TYPE	This column stores the admission application types for admission applications created from the self service
CASH_ACCOUNT_CODE	User Defined Cash Account Code
CLOSED_IND	Admission Application Type Closed Indicator
CREATED_BY	WHO column
CREATION_DATE	WHO column
LAST_UPDATED_BY	WHO column
LAST_UPDATE_DATE	WHO column
LAST_UPDATE_LOGIN	WHO column
SYSTEM_DEFAULT	Indicates whether this application type is the system default.
ENROLL_DEPOSIT_AMOUNT	Enrollment Deposit Amount
ENROLL_DEPOSIT_LEVEL	Enrollment Deposit Level

Student System - IGS_AD_SS_APPL_PGS	Holds the Self Service Page Names attached to an Admission Application Type
Column Name	Descritpion
ADMISSION_APPLICATION_TYPE	Admission Application Type to which Page Name is attached
INCLUDE_IND	Self Service Page Name Include Indicator
CREATED_BY	WHO column
CREATION_DATE	WHO column
LAST_UPDATED_BY	WHO column
LAST_UPDATE_DATE	WHO column
LAST_UPDATE_LOGIN	WHO column
REQUIRED_IND	Self Service Page Name Required Indicator - Obsolete
DISP_ORDER	A unique identifier order the display sequence on the checklist page
PAGE_NAME	Self Service Page Name attached to an Admission Application Type
PAGE_DISP_NAME	The name displayed for the page in the self-service application page checklist and as the page header.

Student System - IGS_AD_RVGR_INC_EXC	Table to record all Application Review Group Include Exclude related information. Here the Review Group Include Exclude Indicator IDs will be generated and information like Start Value, End Value, Country, Postal Start value, Postal End Val
Column Name	Descritpion
REVGR_INCL_EXCL_ID	Unique Identifier of a Application Review Profile Review Group include or exclude record..
POSTAL_END_VALUE	End value for the inclusion/exclusion of postal code used at the time of evaluating the review group for assignment of applications through job.
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
APPL_REVPROF_REVGR_ID	Unique Identifier of a Application Review Profile Review Group.
INCL_EXCL_IND	Indicator to designate whether to include or exclude the Last name state code market code or organization code at the time of evaluating the review group for assignment of applications through job. Valid values can be Include - 'I' or Excl
START_VALUE	Start value for the inclusion/exclusion of Last name state code market code organization code and program code used at the time of evaluating the review group for assignment of applications through job.
END_VALUE	End value for the inclusion/exclusion of Last name state code market code organization code and program code used at the time of evaluating the review group for assignment of applications through job.
VERSION_NUMBER	Version number of the program code used for ARP review group 'Program of Study'.
COUNTRY	Country code used for the evaluation of inclusion/exclusion criteria for Review Group 'Geographical by Applicant Address'.
POSTAL_INCL_EXCL_IND	Indicator to designate whether to include or exclude the postal code at the time of evaluating the review group for assignment of applications through job. Valid values can be Include - 'I' or Exclude - 'E'.
POSTAL_START_VALUE	Start value for the inclusion/exclusion of postal code used at the time of evaluating the review group for assignment of applications through job.

Student System - IGS_AD_RVGR_EVALTR	Table where all Evaluator corresponding to Application Review Profile related information will be recorded.
Column Name	Descritpion
REVGR_EVALUATOR_ID	Unique Identifier of a Review Group Evaluator.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
APPL_REVPROF_REVGR_ID	Unique Identifier of a Application Review Profile Review Group.
PERSON_ID	Person ID of the person who is an evaluator for the current Review Group.
PERSON_NUMBER	Person Number of the person who is an evaluator for the current Review Group.
EVALUATION_SEQUENCE	Sequence number to designate the order in which evaluators should evaluate the applications for a sequential evaluation. For concurrent evaluation value for this field will be null.
PROGRAM_APPROVER_IND	Indicator to designate an evaluator who is also authorized to do program approval. Valid values can be Yes - 'Y' or No - 'N'.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AS_AIO_INTERFACE	Assessment Item Outcome Interface Table primarily used to import details entered in Web ADI for Assessment Item grades.
Column Name	Descritpion
BATCH_DATE	The batch date .
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Standard DFF Column
ATTRIBUTE1	Standard DFF Column
ATTRIBUTE2	Standard DFF Column
ATTRIBUTE3	Standard DFF Column
ATTRIBUTE4	Standard DFF Column
ATTRIBUTE5	Standard DFF Column
ATTRIBUTE6	Standard DFF Column
PERSON_NUMBER	Student Number.
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
ATTRIBUTE15	Standard DFF Column
ATTRIBUTE16	Standard DFF Column
ANONYMOUS_ID	Anonymous Number.
ATTRIBUTE17	Standard DFF Column
ATTRIBUTE18	Standard DFF Column
ATTRIBUTE19	Standard DFF Column
ATTRIBUTE20	Standard DFF Column
LOCATION_CD	Unit Section Location code
UNIT_CLASS	Unit Section Unit Class
WAIVED_FLAG	Allows the user to indicate that the assessment item is being waived for a particular student.
PENALTY_APPLIED_FLAG	Allows the user to indicate that the captured mark/grade have been subjected to a penalty.
OVERRIDE_DUE_DT	A user-defined date which overrides the default due date of the assessment item.
COURSE_CD	Course Code.
DUE_DT	Due date for completion or submission of the unit assessment item. Due dates are typically entered for non-examinable assessment items. Assignment due dates are used in the assignment tracking facility as the default action date for the Rec
SUBMITTED_DATE	Date on which the student submitted the assessment item for grading
UOO_ID	Unique identifier for a unit offering option.
UNIT_CD	Unit code.
CAL_TYPE	Calendar Type.
CI_SEQUENCE_NUMBER	Calendar Instance Sequence Number.
ALTERNATE_CODE	Alternate Code.
USER_ID	User Identification Number.
GRADE	Grade.
MARK	Mark.
ASS_ID	Assessment Identification Number.
ASSESSMENT_TYPE	Assessment Type.
REFERENCE	Reference.
OUTCOME_COMMENT_CODE	Outcome comments code from looksups.
CONTEXT	Context.
ERROR_CODE	Error code to be replaced by import process.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AS_ANON_ID_US	Holds the person with the assigned Anonymous Id for the method SECTION
Column Name	Descritpion
PERSON_ID	Person Id
LOAD_CI_SEQUENCE_NUMBER	Load Calendar 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 Column for Concurrent Job
PROGRAM_APPLICATION_ID	Standard Column for Concurrent Job
PROGRAM_ID	Standard Column for Concurrent Job
PROGRAM_UPDATE_DATE	Standard Column for Concurrent Job
ANONYMOUS_ID	Anonymous Id
SYSTEM_GENERATED_IND	Y / N Was the Anonymous ID created by the System or from the user hook
COURSE_CD	Course Code
UNIT_CD	Unit Code
TEACH_CAL_TYPE	Teaching Calendar Type
TEACH_CI_SEQUENCE_NUMBER	Teaching Calendar Sequence Number
UOO_ID	Unit Offering Option / Unit Section ID
LOAD_CAL_TYPE	Load Calendar Type

Student System - IGS_AS_ANON_ID_PS	Holds the person with the assigned Anonymous ID for the Method PROGRAM
Column Name	Descritpion
PERSON_ID	Person ID
REQUEST_ID	Standard Column for Concurrent Job
PROGRAM_APPLICATION_ID	Standard Column for Concurrent Job
PROGRAM_ID	Standard Column for Concurrent Job
PROGRAM_UPDATE_DATE	Standard Column for Concurrent Job
ANONYMOUS_ID	Anonymous ID
SYSTEM_GENERATED_IND	Y / N Was the Anonymous ID generated by the System or from the user hook
COURSE_CD	Course 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_AS_ANON_ID_ASS	Holds the person with the assigned Anonymous Id for the method ASSESSMENT
Column Name	Descritpion
PERSON_ID	Person ID
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Column for Concurrent Job
PROGRAM_APPLICATION_ID	Standard Column for Concurrent Job
PROGRAM_ID	Standard Column for Concurrent Job
PROGRAM_UPDATE_DATE	Standard Column for Concurrent Job
ANONYMOUS_ID	Anonymous ID
SYSTEM_GENERATED_IND	Y / N Was the Anonymous ID generated by the System or from the user hook
ASSESSMENT_TYPE	Assessment Type
LOAD_CAL_TYPE	Load Calendar Type
LOAD_CI_SEQUENCE_NUMBER	Load Calendar Sequence Number
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Student System - IGS_AS_ANON_METHOD	Holds methods defined for different Load Calendar Types
Column Name	Descritpion
LOAD_CAL_TYPE	Load Calendar Type
METHOD	Anonymous Grading Method ( PROGRAM ,SECTION , ASSESSMENT)
ASSESSMENT_TYPE	Unit Grading Assessment 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

Student System - IGS_AD_OFFRESP_BATCH	Holds details about offer response interface batch details.
Column Name	Descritpion
BATCH_ID	Batch Identifier
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
BATCH_DESC	Batch Description
REQUEST_ID	Request id of the last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
PROGRAM_ID	Program identifier of the last concurrent program to update this record
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column

Student System - IGS_AD_OFFRESP_ERR	Holds Offer Response Interface Error Details.
Column Name	Descritpion
OFFRESP_ERR_ID	An identifier to uniquely identify this row
REQUEST_ID	Request id of the last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
PROGRAM_ID	Program identifier of the last concurrent program to update this record
OFFRESP_INT_ID	Offer Response Interface Identifier
ERROR_CODE	Error Code
ERROR_TEXT	Error Text
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Student System - IGS_AD_OFFRESP_INT	Holds offer response interface details
Column Name	Descritpion
OFFRESP_INT_ID	An identifier to uniquely identify this row
APPLICANT_ACPTNCE_CNDTN	Offer Response Comments
DEF_ACAD_CAL_TYPE	Deferred Academic Calendar Type
DEF_ACAD_CI_SEQUENCE_NUMBER	Deferred Academic Calendar sequence number
DEF_ADM_CAL_TYPE	Deferred Admission Calendar Type
DEF_ADM_CI_SEQUENCE_NUMBER	Deferred Admission Calendar sequence number
STATUS	'1' - Completed '2' - Pending '3' - Error When the interface record is initially populated by the user, the status should be set to '2'.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
BATCH_ID	Batch Identifier
LAST_UPDATE_LOGIN	Standard who column
PROGRAM_APPLICATION_ID	Application identifier of the last concurrent program to update this record
PROGRAM_ID	Program identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
REQUEST_ID	Request id of the last concurrent program to update this record
PERSON_ID	Person identifier
PRPSD_COMMENCEMENT_DATE	Proposed Commencement Date
ADMISSION_APPL_NUMBER	Admission application number
DECLINE_OFR_REASON	Reason for declining offer
NOMINATED_COURSE_CD	Program code for the admission application
SEQUENCE_NUMBER	Sequence number for the admission application
ADM_OFFER_RESP_STATUS	Offer Response Status
ACTUAL_OFFER_RESPONSE_DT	Offer Response Date
ATTENT_OTHER_INST_CD	Attend other institution code

Student System - IGS_AS_ALIAS_TYPES	Contains Alias Types (i.e., "former names") that are to be shown on the transcript.
Column Name	Descritpion
ORDER_OF_DISPLAY	Order of Display on the Transcript
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
ALIAS_TYPE	Alias Type/Former Name to be displayed

Student System - IGS_AD_INSTHIST_INT	Holds the admission application instance history details that need to get imported for an application, during legacy import
Column Name	Descritpion
INTERFACE_INSTHIST_ID	A unique identifier to identify each row in this table
ADM_OUTCOME_STATUS_AUTH_DT	Describes the date that the outcome status was authorized. It should not be greater than system date
ADM_OUTCOME_STATUS_REASON	Used to further describe a status, for example, an outcome status of Revoked may have associated reason for the revocation
OFFER_DT	Describes the date that an offer of admission was made to the applicant. It should not be greater than system date
ADM_CNDTNL_OFFER_STATUS	Describes the status assigned to an admission program application in relation to a conditional offer
CNDTNL_OFFER_SATISFIED_DT	Describes the date that a conditional offer was satisfied or waived. It should not be greater than system date
CNDTNL_OFFER_MUST_BE_STSFD_IND	Describes whether or not a conditional offer must be satisfied before the offer can be accepted. It should be having value Y or N
ADM_OFFER_RESP_STATUS	Describes the offer response status of the admission program application instance
ACTUAL_RESPONSE_DT	Describes the actual date a response was made by an applicant to an offerIt should not be greater than system date
ADM_OFFER_DFRMNT_STATUS	Describes the offer deferment status of the admission program application instance
INTERFACE_PS_APPL_INST_ID	Interface Application Instance ID
DEFERRED_TRACKING_ID	Describes the tracking ID of the deferral request that has been forwarded for assessment
APPLICANT_ACPTNCE_CNDTN	Describes the conditions the applicant is requesting as part of their acceptance of an offer, for example, request for scholarship granted, advanced standing approved.
CNDTNL_OFFER_CNDTN	Describes the conditions of a conditional offer. An assessor may use this field to list conditions the applicant must satisfy in order to satisfy the conditional offer.
ATTENDANCE_TYPE	Describes the attendance type for the application
ATTENDANCE_MODE	Describes the attendance mode for the application
LOCATION_CD	Describes the Location code for the application
UNIT_SET_CD	Describes the Unit Set code for the application
HIST_START_DT	The effective start date and time of the history record. It should not be greater than system date
US_VERSION_NUMBER	Describes the Unit Set Code version number for the application
PREFERENCE_NUMBER	Describes the Preference Number of the application
OFFER_RESP_DATE	Describes the Offer Response Date of the ApplicantIt should not be greater than system date
PRPSD_COMMENCEMENT_DT	Describes the Proposed Commencement date for the courseIt should not be greater than system date
ASS_RANK	Assessment Rank.Value should be greater than 0.
SECONDARY_ASS_RANK	Secondary Assessment Rank.Value should be greater than 0.
INTRNTNL_ACCEPTANCE_ADVICE_NUM	International Acceptance Advice Number
ASS_TRACKING_ID	Assessment Tracking Identifier
FEE_CAT	Describes the Fee category for the Application
HECS_PAYMENT_OPTION	Describes the HECS Payment Option for the Application
HIST_END_DT	The effective end date and time of the history record. It should not be greater than system date and It should not be less than HIST_START_DT
EXPECTED_COMPLETION_YR	Describes the Expected Completion Year for the Course
EXPECTED_COMPLETION_PERD	Describes the Expected Completion Period for the course
ENROLMENT_CAT	Describes the Enrolment Category for the application
FUNDING_SOURCE	Describes the Funding Source for the application
ERROR_CODE	Error Code
STATUS	Status of the interface record
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
ADM_DOC_STATUS	Describes the documentation status of the admission program application instance
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
NOMINATED_COURSE_CD	Couse Code. This column will be populated by the import process.
SEQUENCE_NUMBER	Sequence number. This column will be populated by the import process.
ERROR_TEXT	Error Text
APPL_INST_STATUS	Application Instance Status
ADM_ENTRY_QUAL_STATUS	Describes the entry qualification status of the admission program application instance
LATE_ADM_FEE_STATUS	Describes the institution-defined fee status for a late program admission application instance
ADM_OUTCOME_STATUS	Describes the outcome status of the admission program application instance
ADM_OTCM_STAT_AUTH_PER_NUMBER	Describes the person who authorized the outcome status Valid Staff member

Student System - IGS_AD_PERSTMT_INT	Holds personal statement details that need to get imported for an application
Column Name	Descritpion
INTERFACE_PERSTMT_ID	A unique identifier to identify each row of the table
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
ERROR_TEXT	Error Text
INTERFACE_APPL_ID	Interface Application ID
PERSL_STAT_TYPE	Personal Statement type attached to application personal statement.
DATE_RECEIVED	Date Received. It should not be greater than system date
ERROR_CODE	Error Code
STATUS	Status of the interface record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_PNL_HIS_DTLS	This is an Audit history table, that holds the information about the panel decision changes
Column Name	Descritpion
HISTORY_DATE	The date when the Panel decision details got changed
FINAL_DECISION_CODE	Final Decision
FINAL_DECISION_TYPE	Final Decision 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
PANEL_DTLS_ID	Panel Details ID

Student System - IGS_AD_PNMEMBR_NOTS	Table that holds the details about the notes created by the members assigned to an application instance panel
Column Name	Descritpion
MEMBER_PERSON_ID	Panel Member Person Id
NOTES_VERSION_NUM	Notes Version Number
MEMBER_NOTES	Member Notes
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
PANEL_DTLS_ID	Panel Details ID

Student System - IGS_AD_INTVW_PNLS	Table that holds information about the screening or interview panels that have been created
Column Name	Descritpion
PANEL_TYPE_CODE	Interview Panel type
ATTRIBUTE14	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE15	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE16	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE17	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE18	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE19	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE20	Standard attribute column meant for Descriptive Flex Field
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
PANEL_DESC	Panel Description
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CLOSED_FLAG	Closed Indicator
PANEL_LEVEL_CODE	Panel Level
ATTRIBUTE_CATEGORY	Descriptive Flex Field qualifier
ATTRIBUTE1	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE2	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE3	Standard attribute column meant for Descriptive Flex Field
PANEL_CODE	Admission Panel code
ATTRIBUTE4	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE5	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE6	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE7	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE8	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE9	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE10	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE11	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE12	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE13	Standard attribute column meant for Descriptive Flex Field

Student System - IGS_AD_PANEL_DTLS	Table that holds the details about the application instances assigned to a panel
Column Name	Descritpion
PERSON_ID	Person Id
ATTRIBUTE5	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE6	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE7	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE8	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE9	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE10	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE11	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE12	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE13	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE14	Standard attribute column meant for Descriptive Flex Field
ADMISSION_APPL_NUMBER	Admission Application number
ATTRIBUTE15	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE16	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE17	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE18	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE19	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE20	Standard attribute column meant for Descriptive Flex Field
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
NOMINATED_COURSE_CD	Admission Application Course code
LAST_UPDATE_LOGIN	Standard WHO Column
SEQUENCE_NUMBER	Admission Application Sequence number
PANEL_CODE	Admission Panel Code
FINAL_DECISION_CODE	Panel Final Decision
FINAL_DECISION_TYPE	Panel Final Decision Type
CLOSED_FLAG	Closed Indicator
PANEL_DTLS_ID	Application Instance Panel ID. A unique identifier to identify each row in this table
INTERVIEW_DATE	Interview date
INTERVIEW_TIME	Interview time
LOCATION_CD	Interview Location
ROOM_ID	Building or Room in this Location
FINAL_DECISION_DATE	Panel Final Decision date
ATTRIBUTE_CATEGORY	Descriptive Flex Field qualifier
ATTRIBUTE1	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE2	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE3	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE4	Standard attribute column meant for Descriptive Flex Field

Student System - IGS_AD_PANEL_MEMBRS	Table that holds the details about the members in an admission panel
Column Name	Descritpion
MEMBER_PERSON_ID	Panel Member's person Id
ATTRIBUTE15	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE16	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE17	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE18	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE19	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE20	Standard attribute column meant for Descriptive Flex Field
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
ROLE_TYPE_CODE	Role of panel member in the panel
LAST_UPDATE_LOGIN	Standard WHO Column
PANEL_SEQ_NUM	Panel Member Sequence Number
ATTRIBUTE_CATEGORY	Descriptive Flex Field qualifier
ATTRIBUTE1	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE2	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE3	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE4	Standard attribute column meant for Descriptive Flex Field
PANEL_CODE	Admission Panel code
ATTRIBUTE5	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE6	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE7	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE8	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE9	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE10	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE11	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE12	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE13	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE14	Standard attribute column meant for Descriptive Flex Field

Student System - IGS_AD_PNMEMBR_DTLS	The table that holds the information about the members assigned to a panel instance
Column Name	Descritpion
ROLE_TYPE_CODE	Role Type
ATTRIBUTE9	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE10	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE11	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE12	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE13	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE14	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE15	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE16	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE17	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE18	Standard attribute column meant for Descriptive Flex Field
MEMBER_PERSON_ID	Panel Member's Person Id
ATTRIBUTE19	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE20	Standard attribute column meant for Descriptive Flex Field
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
MEMBER_DECISION_CODE	Panel Member Decision
MEMBER_DECISION_TYPE	Panel Member Decision Type
INTERVIEW_DATE	Interview Date
INTERVIEW_TIME	Interview Time
LOCATION_CD	Interview Location
ROOM_ID	Building or Room in this Location
PANEL_DTLS_ID	Panel Details Id
MEMBER_DECISION_DATE	Panel Member Decision Date
ATTRIBUTE_CATEGORY	Descriptive Flex Field qualifier
ATTRIBUTE1	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE2	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE3	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE4	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE5	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE6	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE7	Standard attribute column meant for Descriptive Flex Field
ATTRIBUTE8	Standard attribute column meant for Descriptive Flex Field

Student System - IGS_AD_INTERFACE_CTL	Holds import interface run details when admissions data is imported into system
Column Name	Descritpion
INTERFACE_RUN_ID	Unique identifier assigned to identify each row of the interface table contents
STATUS	1 - Completed2 - Pending3 - Error
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 the last concurrent program, that updated this record
PROGRAM_APPLICATION_ID	Application Identifier of the last concurrent program, that updated this record
PROGRAM_ID	Program Identifier of the last concurrent program, that updated this record
SOURCE_TYPE_ID	Import source type
PROGRAM_UPDATE_DATE	Last Update Date of this record by a concurrent program
BATCH_ID	Batch ID
MATCH_SET_ID	Match criteria set name ID

Student System - IGS_AD_NOTES_INT	Holds information about applicant notes details
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
INTERFACE_NOTES_ID	Interface notes identifier
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_PS_APPL_INST_ID	Interface Program Application Instance Identifier
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
NOMINATED_COURSE_CD	Couse Code. This column will be populated by the import process.
SEQUENCE_NUMBER	Sequence number. This column will be populated by the import process.
ERROR_TEXT	Error Text
ADMISSION_APPLICATION_TYPE	Admission application type. This column will be populated by the import process.
NOTE_TYPE_ID	Note type identifier
NOTES	Notes
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_OTHINST_INT	Contains information about other institutions in which the person is interested to be imported.
Column Name	Descritpion
INTERFACE_OTHINST_ID	Interface other institution details identifier
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
ERROR_TEXT	Error Text
ADMISSION_APPLICATION_TYPE	Admission application type. This column will be populated by the import process.
INTERFACE_APPL_ID	Interface Applicant Identifier
INSTITUTION_CD	Institution code
STATUS	Status of the record whether it is imported, pending, error or warning.
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_SPLINT_INT	Holds applicant special interest details
Column Name	Descritpion
INTERFACE_SPLINT_ID	A unique identifier assigned to identify each special interests record. This ID should be populated when the rows are inserted into this table.
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
ERROR_TEXT	Error Text
ADMISSION_APPLICATION_TYPE	Admission application type. This column will be populated by the import process.
INTERFACE_APPL_ID	Interface Applicant Identifier
SPECIAL_INTEREST_TYPE_ID	Applicant special interest
STATUS	Status of the record imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_SPLTAL_INT	Holds applicant special talents details
Column Name	Descritpion
INTERFACE_SPLTAL_ID	A unique identifier assigned to identify each special talent record of the interface table. This ID should be populated when the rows are inserted into this table.
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
ERROR_TEXT	Error Text
ADMISSION_APPLICATION_TYPE	Admission application type. This column will be populated by the import process.
INTERFACE_APPL_ID	Interface Applicant Identifier
SPECIAL_TALENT_TYPE_ID	Applicant special talent
STATUS	Status of the record whether it is imported pending error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_TEST_INT	Holds test type details.
Column Name	Descritpion
INTERFACE_TEST_ID	A unique identifier assigned to identify each test results details record of the interface table . This ID should be populated when the rows are inserted into this table
NON_STANDARD_ADMIN	Non standard test administration
SPECIAL_CODE	Special code
STATUS	Status of the record - imported, pending, error or warning
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
ACTIVE_IND	Indicator for Active Test Types
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
INTERFACE_ID	Interface identifier
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ERROR_TEXT	Error Text
GRADE_ID	Grade Identifier as defined in the Test Results Information -> Test Results Grade
TEST_RESULTS_ID	Test Results Identifier
DUP_TEST_RESULTS_ID	Unique identifier to identify duplicate test result record in OSS
ADMISSION_TEST_TYPE	Type of the admission test taken by the person, for example, TOEFL, UMAT and others
ATTRIBUTE_CATEGORY	Descriptive flex field structure defining column
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
REGISTRATION_NUMBER	Registration number provided by the testing agency if the test is taken
ATTRIBUTE10	Descriptive flex field segment column
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
TEST_DATE	Date that the test was administered
ATTRIBUTE20	Descriptive flex field segment column
SCORE_REPORT_DATE	Date that the test scores were created
EDU_LEVEL_ID	Education level of the person at the time the test was given
SCORE_TYPE	Test score type
SCORE_SOURCE_ID	Score source

Student System - IGS_AD_TEST_SEGS_INT	Holds person's test segment details.
Column Name	Descritpion
INTERFACE_TESTSEGS_ID	Unique identifier assigned to identify each test score details record of the interface table . This ID should be populated when the rows are inserted into this table
PERCENTILE_YEAR_RANK	Percentile year rank
SCORE_BAND_UPPER	Score band upper
SCORE_BAND_LOWER	Score band lower
IRREGULARITY_CODE	Irregularity code
MATCH_IND	Match indicator
STATUS	Status of the record - imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
INTERFACE_TEST_ID	Interface identifier of the test result record
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
TEST_RESULTS_ID	Test Results Identifier
ERROR_TEXT	Error Text
ATTRIBUTE_CATEGORY	Descriptive flex field structure defining column
ADMISSION_TEST_TYPE	Admission test type
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
TEST_SEGMENT_ID	Admission test type segment identifier
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
TEST_SCORE	Test score
PERCENTILE	Percentile
NATIONAL_PERCENTILE	National percentile
STATE_PERCENTILE	State percentile
LATEST_OFFICIAL_PERCENTILE	Latest official percentile

Student System - IGS_AD_TRMDT_INT	Contains student's term details.
Column Name	Descritpion
INTERFACE_TERM_DTLS_ID	Unique identifier for the table
TOTAL_UNIT_GP	Total unit grade points
TOTAL_GPA_UNITS	Total grade point average units
GPA	Grade point average of the student
MATCH_IND	Indicates the match between the interface record and record present in the system.
ERROR_CODE	Indicates the error, if any, that occurred in the import process
DUP_TERM_DTLS_ID	Duplicate Term Details ID
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
INTERFACE_TRANSCRIPT_ID	Indicates the link between transcript table
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
EDUCATION_ID	Education Identifier. This column will be populated by the import process
TRANSCRIPT_ID	Transcript Identifier. This column will be populated by the import process
ERROR_TEXT	Error Text
START_DATE	Indicates the term start date
END_DATE	Indicates the term end date
TERM	Indicates the term
STATUS	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
TERM_DETAILS_ID	The unique identifier of the system table which will be populated by the interface table.
TOTAL_CP_ATTEMPTED	Total credit points attempted
TOTAL_CP_EARNED	Total credit points earned

Student System - IGS_AD_TUNDT_INT	Contains term unit details.
Column Name	Descritpion
INTERFACE_TERM_UNITDTLS_ID	Unique identifier for the interface record.
GRADE	Indicates the grades earned.
UNIT_GRADE_POINTS	Unit grade points
MATCH_IND	Indicates the match between the interface record and record present in the system.
ERROR_CODE	Holds the error code for any error that occurred during processing.
DUP_TERM_UNITDTLS_ID	Duplicate Term Details ID
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
INTERFACE_TERM_DTLS_ID	Reference to the term details record
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard who column for concurrent program
PROGRAM_APPLICATION_ID	Standard who column for concurrent program
PROGRAM_ID	Standard who column for concurrent program
PROGRAM_UPDATE_DATE	Standard who column for 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
PERSON_ID	Person Identifier. This column will be populated by the import process.
EDUCATION_ID	Education Identifier. This column will be populated by the import process
TRANSCRIPT_ID	Transcript Identifier. This column will be populated by the import process
TERM_DETAILS_ID	Term Details Identifier
ERROR_TEXT	Error Text
UNIT	Indicates the unit for the term
UNIT_DIFFICULTY	Indicates the unit difficulty
UNIT_NAME	Holds the unit name
STATUS	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
UNIT_DETAILS_ID	Holds the unique identifier of the system table which is loaded by the interface table.
CP_ATTEMPTED	Credit points attempted
CP_EARNED	Credit points earned

Student System - IGS_AD_TXCPT_INT	Holds transcript details.
Column Name	Descritpion
INTERFACE_TRANSCRIPT_ID	Unique identifier for the transcript record
TRANSCRIPT_ID	Holds the unique identifier of the table which is populated by the interface table.
DATE_OF_RECEIPT	Indicates the date on which the record was received
ENTERED_GPA	Indicated the entered grade point average
CONV_GPA	Holds the converted grade point average
RANK_IN_CLASS	Rank in class for the student
CLASS_SIZE	Indicates the class size
APPROXIMATE_RANK	Indicates the approximate rank of the student
WEIGHTED_RANK	Indicates the weighted rank
DECILE_RANK	Indicates the decile rank
QUARTILE_RANK	Indicates the quartile rank
TRANSCRIPT_STATUS	Indicates the transcript status
QUINTILE_RANK	Indicates the quintile rank
PERCENTILE_RANK	Indicates the percentile rank
MATCH_IND	Indicates the match between the interface record and record present in the system.
ERROR_CODE	Indicates the error that occurred during the import process.
DUP_TRANSCRIPT_ID	Holds the duplicate transcript ID
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
TRANSCRIPT_TYPE	Indicates the transcript type
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
DATE_OF_ISSUE	Date on which the transcript is issued
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
EDUCATION_ID	Education Identifier. This column will be populated by the import process
OVERRIDE_IND	Override Indicator
ERROR_TEXT	Error Text
UPDATE_TRANSCRIPT_ID	Unique identifier to identify the OSS record which will map to EDUCATION_ID
TRANSCRIPT_SOURCE	Indicates the source of the transcript details.
INTERFACE_ACADHIS_ID	Refers to the link with Academic History table
STATUS	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
ENTERED_GS_ID	Holds the entered grading schema ID
CONV_GS_ID	Holds the converted grading schema ID
TERM_TYPE	Holds the term type

Student System - IGS_AD_UNITSETS_INT	Holds applicant's desired unit set details
Column Name	Descritpion
INTERFACE_UNITSETS_ID	A unique identifier assigned to identify each applicant desired unit set details record 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	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_PS_APPL_INST_ID	Interface Program Application Instance Identifier
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
PERSON_ID	Person Identifier. This column will be populated by the import process.
ADMISSION_APPL_NUMBER	Application Number. This column will be populated by the import process.
NOMINATED_COURSE_CD	Couse Code. This column will be populated by the import process.
SEQUENCE_NUMBER	Sequence number. This column will be populated by the import process.
ERROR_TEXT	Error Text
ADMISSION_APPLICATION_TYPE	Admission application type. This column will be populated by the import process.
UNIT_SET_CD	Unit set desired
VERSION_NUMBER	Unit set version number
RANK	Unit set rank
MATCH_IND	Match indicator
STATUS	Status of the record - imported, pending, error or warning
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column

Student System - IGS_AD_QUAL_TYPE	New Setup table to hold the qualification type each Admission category
Column Name	Descritpion
ADMISSION_CAT	Admission Category
S_ADMISSION_PROCESS_TYPE	System defined Admission Process Type
QUALIFYING_TYPE_CODE	The qualifying type from lookup values
CLOSED_FLAG	An Y/N indicator. When set to 'Y' closes off any further use of the Qualifying 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

Student System - IGS_AD_SS_APPL_COMPS	Holds the Self Service Page and its Components attached to an Admission Application Type
Column Name	Descritpion
ADMISSION_APPLICATION_TYPE	Admission Application Type to which Page Name is attached
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
PAGE_NAME	Self Service Page Name attached to an Admission Application Type
COMPONENT_CODE	Self Service Component Code attached to a Page of Admission Application Type
COMP_DISP_NAME	The name displayed for the component in the component header and the required components content container.
INCLUDE_FLAG	Indicate whether the component is to be included on the page.
REQUIRED_FLAG	Indicate whether the component is required to submit an application.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Student System - IGS_AD_SS_LOOKUPS	Application Type Self service Lookup Data
Column Name	Descritpion
ADMISSION_APPLICATION_TYPE	Admission Application Type to which Lookup Data is attached
SS_LOOKUP_TYPE	Lookup type unique identifier
SS_LOOKUP_CODE	Lookup type code.
CLOSED_FLAG	To close off any further use of the Lookup Code in self-service.
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_AD_SS_TERMS	Application Type Terms and Conditions
Column Name	Descritpion
ADMISSION_APPLICATION_TYPE	Admission Application Type to which Terms and Conditions are attached.
LAST_UPDATE_LOGIN	Standard Who column
COND_ID	A unique identifier for the component also used to order the display sequence on the terms and conditions page.
COND_DISP_NAME	Condition header of the Terms and conditions components.
COND_DISP_TEXT	Condition to be displayed to the applicant.
INCLUDE_FLAG	Indicate to include the term in the Terms and Conditions page.
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_AD_SS_APPL_CONF	Holds Application Type Seeded Configuration
Column Name	Descritpion
PAGE_CODE	Self Service Page Name attached to an Admission Application Type
COMPONENT_CODE	Self Service Component Name attached to a Page of Admission Application Type
INCLUDE_FLAG	Indicate whether the component is to be included on the page.
APC_STEP	Maps the Page component with the APC step
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