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

Student System - IGS_AD_ACAD_HONORS	Holds information about applicant's academic honors details
Column Name	Descritpion
ACAD_HONOR_ID	Describes a unique identifier for the academic honors
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 number which is assigned to an applicant when the person details of the applicant is created.
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	--Obsolete in 2177686
SEQUENCE_NUMBER	--Obsolete in 2177686
ACAD_HONOR_TYPE_ID	Academic honor type identifier
COMMENTS	Comments
HONOR_DATE	Stores the date the person received the academic honors
CREATED_BY	Standard who column

Student System - IGS_AD_ACAD_INTEREST	Holds information about applicant's academic interests
Column Name	Descritpion
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	Describes the Person Identifier Number which is assigned to an applicant when the person details of the applicant is created.
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	--Obsolete in 2177686
ACAD_INTEREST_ID	Describes a unique identifier for the academic interest
SEQUENCE_NUMBER	Obsolete in 2177686
FIELD_OF_STUDY	A classification of programs based on similarity in terms of the vocational field of specialization or principal subject matter of the program
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column

Student System - IGS_AD_ADM_UT_STA_GD	Describes grading schema code grades applicable to an administrative unit status
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
ADMINISTRATIVE_UNIT_STATUS	Describes user-defined administrative statuses. For example, withdrawn early, supplementary exam granted.
GRADING_SCHEMA_CD	Code of the grading schema containing the default grade for the specified administrative unit status.
VERSION_NUMBER	Version number of the grading schema code containing the grade associated with the specified administrative unit status.
GRADE	Default grade for the specified administrative unit status AUS. This grade is created by the system as the student unit attempt outcome when the associated AUS is assigned to the unit attempt. At any point in time, an AUS can be associated

Student System - IGS_AD_ADM_UT_STT_LD	Describes load calendar type relationship to administrative unit status to determine load incurred
Column Name	Descritpion
ADMINISTRATIVE_UNIT_STATUS	An administrative unit status AUS associated with the specified load calendar instance or teaching calendar combination. An AUS is assigned to a unit attempt when it is discontinued, that adds further definition to the unit attempt status.
CAL_TYPE	Describes the load calendar type relating to an administrative unit status to determine load incurred.
CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance
TEACH_CAL_TYPE	Describes the available teaching calendar types for that, in combination with load period, load may be incurred.
LOAD_INCURRED_IND	Specifies whether or not load is incurred when the administrative unit status is assigned to a discontinued student unit attempt in the specified load calendar instance or teaching period combination. Setting the checkbox ticked causes 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_APPL_LTR_PHR	Describes special phrases used in correspondence produced for admission application
Column Name	Descritpion
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
CORRESPONDENCE_TYPE	Code for the type of correspondence
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
AAL_SEQUENCE_NUMBER	The unique identifier for admission application letter
SEQUENCE_NUMBER	The unique identifier for admission application letter phrase
PHRASE_CD	The unique institution defined code used to identify a phrase
PHRASE_ORDER_NUMBER	Identifies the order in which letter phrases should appear
LETTER_PARAMETER_TYPE	Contains the unique institution defined parameter type code that can be merged with letter templates
PHRASE_TEXT	Text that will be substituted in place of the letter phrase text for this admission application
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_APPL_PGMAPPRV	Holds details of program representatives assigned to various applications for program review
Column Name	Descritpion
APPL_PGMAPPRV_ID	Unique identifier assigned to each of the program representative assigned to an application, for program approval.
PROGRAM_APPROVAL_STATUS	Describes the approval status. The approval status can be Approved, Pending, Rejected. It is based on IGS_LOOKUPS where LOOKUP_TYPE is 'PROGRAM_APPROVAL_STATUS'
APPROVAL_NOTES	Program representative comments about approval
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
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	Describes the program code of the program for that the applicant is seeking admission
SEQUENCE_NUMBER	Describes the sequence number of the application
PGM_APPROVER_ID	stores the evaluator person ID
ASSIGN_TYPE	Describes the assign type, for example, M- Manual and A- Automatic.
ASSIGN_DATE	Date the application was assigned to an evaluator
PROGRAM_APPROVAL_DATE	Evaluation date

Student System - IGS_AD_APP_INTENT	Holds applicant's intent details
Column Name	Descritpion
APP_INTENT_ID	Unique identifier for the applicant's intent details
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
ATTRIBUTE_CATEGORY	Standard DFF Column
ATTRIBUTE1	Standard DFF Column
ATTRIBUTE2	Standard DFF Column
ATTRIBUTE3	Standard DFF Column
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
ATTRIBUTE4	Standard DFF Column
ATTRIBUTE5	Standard DFF Column
ATTRIBUTE6	Standard DFF Column
ATTRIBUTE7	Standard DFF Column
ATTRIBUTE8	Standard DFF Column
ATTRIBUTE9	Standard DFF Column
ATTRIBUTE10	Standard DFF Column
ATTRIBUTE11	Standard DFF Column
ATTRIBUTE12	Standard DFF Column
ATTRIBUTE13	Standard DFF Column
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
ATTRIBUTE14	Standard DFF Column
ATTRIBUTE15	Standard DFF Column
ATTRIBUTE16	Standard DFF Column
ATTRIBUTE17	Standard DFF Column
ATTRIBUTE18	Standard DFF Column
ATTRIBUTE19	Standard DFF Column
ATTRIBUTE20	Standard DFF Column
NOMINATED_COURSE_CD	--Obsolete in 2177686
SEQUENCE_NUMBER	Obsolete in 2177686
INTENT_TYPE_ID	Stores the applicant intent type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_ATHLETICS	Table made obsolete in Enh. 2101696
Column Name	Descritpion
ATHLETICS_ID	Unique Identifier for applicant's athletic details
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
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	Contains the institution-defined number that uniquely identifies a person
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	Describes the program code of the program for that the applicant is seeking admission
SEQUENCE_NUMBER	Describes the sequence number of the application
ATHLETICS_SPORT_ID	Stores the sports identifier associated with a particular sports type. It is taken from the Code Classes table if the class is 'SPORTS_TYPE'
RATING	Applicant's sport rating
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_AUSE_ED_OT_SC	Describes additional scores required by states for secondary education scoring
Column Name	Descritpion
SCORE_TYPE	Type of additional score, for example, WA Murdoch aggregate or TES.
SCORE	Score as recognized by individual states
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	Contains the institution-defined number that uniquely identifies a person
ASE_SEQUENCE_NUMBER	Identifies uniquely an Australian Secondary Education record for a person.
RESULT_OBTAINED_YR	The year the other secondary education score was obtained

Student System - IGS_AD_CNDNL_OFRSTAT	Describes user-defined admission conditional offer statuses which map to system-defined admission conditional offer statuses
Column Name	Descritpion
ADM_CNDTNL_OFFER_STATUS	Contains the institution-defined status assigned to an admission conditional offer to describe whether the conditions attached to the offer of admission have been met. These must be mapped on to a system-defined conditional offer status.
CLOSED_IND	Specifies if the admission conditional offer status is open or closed. Setting the checkbox to 'closed' prevents use of the admission conditional offer status in new or modified admission application records.
CREATED_BY	Standard Who column
DESCRIPTION	Provides an explanation of the admission conditional offer status
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_CNDTNL_OFFER_STATUS	Contains the system-defined status assigned to an admission conditional offer to describe whether the conditions attached to the offer of admission have been met. For example, - Pending, Satisfied, Waived.
SYSTEM_DEFAULT_IND	Specifies if the admission conditional offer status is the default institution-defined status that the system should use when referred to from a system-defined admission conditional offer status.

Student System - IGS_AD_CD	Describes user-defined admission codes used to define matriculation qualifications of program admission application
Column Name	Descritpion
ADMISSION_CD	Contains the institution-defined admission code used to describe the matriculation category assigned to an applicant on the basis of their current qualifications.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
DESCRIPTION	Provides an explanation of the admission code matriculation category
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
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. For example, V10 OVERSEAS APPLICANT WITH VCE OR IB
BASIS_FOR_ADMISSION_TYPE	Contains the institution-defined code that identifies the main criterion used in granting an applicant admission to a program of study based on their current qualifications or experience.
CLOSED_IND	Specifies if the admission code is open or closed .Setting the checkbox to 'closed' prevents use of the admission code in new or modified admission application records.

Student System - IGS_AD_CAT_PS_TYPE	Describes admission category course types used to validate program offering option admission category mapping
Column Name	Descritpion
ADMISSION_CAT	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.
COURSE_TYPE	Institution-defined program type. Program type indicates the type of higher education program. Each program type must map to a Government program type DETYA element reference number 310- For example, 1 higher doctorate, 21 diploma, 50 n
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_AD_CAT	This entity describes the user-defined categories of applicant that identify different processing requirements of applicants to the institution e.g. undergraduate - HECS (on-campus), postgraduate - international.
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 via a common set of admission procedure steps.
DESCRIPTION	The description of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed via a common set of admission procedure steps.
S_CITIZENSHIP_TYPE	This field describes the citizenship type of the admission category. The citizenship type may be INTERNATIONAL, DOMESTIC or ALL. For example, an admission category 'UG-INTER', intended for international student admissions, would be rest
CLOSED_IND	An indicator which specifies whether the admission category is open or closed. Setting the indicator to 'closed' (ticked) prevents use of the code in new or modified records.
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Student System - IGS_AD_CAL_CONF	Stores dates aliases required for Admissions
Column Name	Descritpion
S_CONTROL_NUM	Describes the control number of the admission calendar configuration table. There will only be one row on this table, hence the control number will always be set to 1.
INITIALISE_ADM_PERD_DT_ALIAS	Describes the date in the admission period on that initialization processes are to be run, for example, switching applications to be reconsidered to pending, re-activating deferred applications.
ADM_APPL_ENCMB_CHK_DT_ALIAS	Describes the date alias used to check for the existence of program and unit encumbrances. This will be linked to an admission period
ADM_APPL_COURSE_STRT_DT_ALIAS	Describes the program start date alias. It will be linked to admission periods. An example of its use is for the enrollment fee assessment contract start date.
ADM_APPL_SHORT_STRT_DT_ALIAS	Describes the date the short admission process becomes effective. This will be linked to an admission period. Use of the short admission process, for example, SHORT-ADM, will not be allowed unless this date exists, and the application is be
ADM_APPL_DUE_DT_ALIAS	Describes the date alias within an admission period when admission applications are due. Late fees may be charged after this date.
ADM_APPL_FINAL_DT_ALIAS	Describes the date alias within an admission period by which admission applications must be received.
ADM_APPL_CHNG_OF_PREF_DT_ALIAS	Describes the date alias within an admission period until which preferences may be changed for an admission application.
ADM_APPL_OFFER_RESP_DT_ALIAS	Describes the date alias within an admission period by which all offers of admission must be responded to.
ADM_APPL_E_COMP_PERD_DT_ALIAS	Describes the date alias within an academic period that allows determination of the expected period of completion. This date alias identifies the 'End' of year expected completion period.
ADM_APPL_M_COMP_PERD_DT_ALIAS	Describes the date alias within an academic period that allows determination of the expected period of completion. This date alias identifies the 'Mid' - year expected completion period.
ADM_APPL_S_COMP_PERD_DT_ALIAS	Describes the date alias within an academic period that allows determination of the expected period of completion. This date alias identifies the 'Summer' expected completion period.
ADM_PRC_TRK_DT_ALIAS	Admission Processing Tracking Date Alias
POST_ADM_TRK_DT_ALIAS	Post Admission Tracking Date Alias
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INQ_CAL_TYPE	Inquiry Calendar Type

Student System - IGS_AD_BASIS_FOR_AD	Describes user-defined basis for admissions for application for program admission
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
BASIS_FOR_ADMISSION_TYPE	Contains the institution-defined code that identifies the main criterion used in granting an applicant admission to a program of study based on their current qualifications or experience. These may be optionally mapped onto a Government bas
DESCRIPTION	Provides an explanation of the basis for admission type
GOVT_BASIS_FOR_ADM_TYPE	Contains a unique Government defined code that identifies the main criterion used in granting an applicant admission to a program of study. For example, 11 - Completed Higher Education, 14 - Completed Secondary Education at School.
CLOSED_IND	Specifies if the basis for admission type is open or closed. Setting the checkbox to 'closed' prevents use of the basis for admission type in new or modified admission application records.

Student System - IGS_AD_AUS_SEC_ED_SU	Describes person's subject results relating to Australian secondary education information
Column Name	Descritpion
ASE_SEQUENCE_NUMBER	Defines uniquely an Australian Secondary Education record for a person
SUBJECT_RESULT_YR	The year the subject result was obtained
SUBJECT_CD	Contains the code that identifies a subject
SUBJECT_DESC	Provides a description of the subject
SUBJECT_MARK	Contains the subject mark
SUBJECT_MARK_LEVEL	Subject level, for example, ACT 'T' or 'A', TAS 'II' or 'III'.
SUBJECT_WEIGHTING	Subject weighting as recognized by individual states
SUBJECT_ASS_TYPE	Type of subject assessment, for example, VCE, IB, YR12.
NOTES	Text-based facility for recording and maintaining notes of up to 2,000 characters regarding the A.S.E. subject
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	Contains the institution-defined number that uniquely identifies a person

Student System - IGS_AD_AUS_SEC_ED_SC	Describes secondary education schools within Australia
Column Name	Descritpion
SECONDARY_SCHOOL_CD	Contains the code that uniquely identifies a secondary education school
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
SECONDARY_SCHOOL_NAME	Contains the name of the secondary school referred to by the secondary school code. For example, Geelong High School, Camberwell A.G.G.S, King Khalid Islamic College.
LAST_UPDATE_LOGIN	Standard Who column
STATE_CD	Describes the Australian state of the secondary school referred to by the secondary school code. For example, ACT, NSW, NT, QLD, SA, TAS, VIC, WA.
S_SCNDRY_SCHOOL_TYPE	Contains the system-defined type of secondary school. For example, State, Independ, other.
CLOSED_IND	Specifies if the Australian secondary school code is open or closed. Setting the checkbox to 'closed' prevents use of the Australian secondary school code in new or modified records.

Student System - IGS_AD_AUS_SEC_EDU	Describes secondary education in Australia that is required for assessment of admissions application
Column Name	Descritpion
SEQUENCE_NUMBER	Identifies uniquely an Australian Secondary Education record for a person
STATE_CD	Describes the Australian state the Secondary Education School is in, for example, VIC, QLD, WA, SA.
RESULT_OBTAINED_YR	The year the secondary result was obtained.
SCORE	Score as recognized by individual states
AUS_SCNDRY_EDU_ASS_TYPE	Contains a code that identifies the applicant type of Secondary Education assessment, for example, - VCE, IB, YR12-ACT.
CANDIDATE_NUMBER	Contains a number that uniquely identifies an applicant and is issued by the appropriate tertiary admissions center
SECONDARY_SCHOOL_CD	Describes the code that uniquely identifies an Australian Secondary Education school.
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	Contains the institution-defined number that uniquely identifies a person

Student System - IGS_AD_GOV_BAS_FR_TY	Describes the DETYA basis for admission codes
Column Name	Descritpion
GOVT_BASIS_FOR_ADM_TYPE	Contains a unique Government defined code that identifies the main criterion used in granting an applicant admission to a program of study -DETYA element 327. For example, 11 - Completed Higher Education Course, 14 - Completed Secondary Ed
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 Government basis for admission type
CLOSED_IND	Specifies if the Government basis for admission type is open or closed. Setting the checkbox to 'closed, prevents use of the Government basis for admission type in new or modified basis for admission records.
CREATED_BY	Standard Who column

Student System - IGS_AD_FEE_STAT	Describes user-defined admission fee statuses which map to system-defined admission fee statuses
Column Name	Descritpion
ADM_FEE_STATUS	Contains the institution-defined status assigned to an admission application to describe the state of the applicant's admission fee. These must be mapped onto a relevant system-defined admission fee status. For example, Exempt- Application
CLOSED_IND	Specifies if the admission fee status is open or closed. Setting the checkbox to 'closed' prevents use of the admission fee status in new or modified admission application records.
CREATED_BY	Standard Who column
DESCRIPTION	Provides an explanation of the admission fee status
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_FEE_STATUS	Contains the system-defined status assigned to an admission application to describe the state of the applicant's required admission fee. For example, - Exempt, Assessed, Received.
SYSTEM_DEFAULT_IND	Specifies if the admission fee status is the default institution-defined status that the system should use when referred to from a system-defined admission fee status.

Student System - IGS_AD_ENT_QF_STAT	Describes user-defined admission entry qualification statuses which map to system-defined admission entry qualification statuses
Column Name	Descritpion
ADM_ENTRY_QUAL_STATUS	Contains the institution-defined status assigned to an admission application to describe the state of the applicant's required entry qualifications. These must be mapped onto a relevant system-defined admission entry qualification status.
CLOSED_IND	Specifies if the admission entry qualification status is open or closed. Setting the checkbox to 'closed' prevents use of the admission entry qualification status in new or modified admission application records.
DESCRIPTION	Provides an explanation of the admission entry qualification 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_ENTRY_QUAL_STATUS	Contains the system-defined status assigned to an admission application to describe the state of the applicant's required entry qualifications. For example, NOT-APPLIC, NOT-QUAL, QUALIFIED.
SYSTEM_DEFAULT_IND	Specifies if the admission entry qualification status is the default institution-defined status that the system should use when referred to from a system-defined admission entry qualification status. Setting the checkbox to 'system default'

Student System - IGS_AD_EDUGOAL	Stores data about person's educational goal
Column Name	Descritpion
POST_EDUGOAL_ID	Post educational unit identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Person id
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	Nominated course code
SEQUENCE_NUMBER	Sequence number
EDU_GOAL_ID	Educational goal identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_DOC_STAT	Describes user-defined admission documentation statuses which map to system-defined admission documentation statuses
Column Name	Descritpion
ADM_DOC_STATUS	Contains the institution-defined status assigned to an admission application to describe the state of the applicant's documentary evidence that is required. These must be mapped onto a relevant system-defined admission documentation status.
CLOSED_IND	Specifies if the admission documentation status is open or closed. Setting the checkbox to 'closed' prevents use of the admission documentation status in new or modified admission application records.
DESCRIPTION	Provides an explanation of the admission documentation 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_DOC_STATUS	Contains the system-defined status assigned to an admission application to describe the state of the applicant's documentary evidence that is required. For example, NOT-APPLIC, PENDING, SATISFIED.
SYSTEM_DEFAULT_IND	Specifies if the admission documentation status is the default institution-defined status that the system should use when referred to from a system-defined admission documentation status.

Student System - IGS_AD_DISBL_TYPE	Describes types of disabilities
Column Name	Descritpion
DISABILITY_TYPE	Institution-defined disability type code. The code must map to one of the Government-defined disability types described in DETYA element no. 386 or to the value of 'NONE'.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
GOVT_DISABILITY_TYPE	Government-defined disability type code described in DETYA element no. 386
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description of an institution-defined disability type code
CLOSED_IND	Specifies whether the disability type is open or closed. Setting the indicator closes the disability type and removes it from the list of allowable values displayed in ENRF3040.

Student System - IGS_AD_CT_HECS_PAYOP	Describes admission HECS payment option, which enables fees to be assessed from admission fees category
Column Name	Descritpion
HECS_PAYMENT_OPTION	Describes the possible HECS payment options available to the admission category, for example, 10 - deferred,11 - up-front. These options will enable fees to be assessed from the admission fee category.
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	Institution-defined admission category code. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.

Student System - IGS_AD_CRED_TYPES	Holds credential types details
Column Name	Descritpion
CREDENTIAL_TYPE_ID	Unique identifier of a person
LAST_UPDATE_LOGIN	Standard Who column
CREDENTIAL_TYPE	Note type
SYSTEM_TYPE	System type
DESCRIPTION	Description
CLOSED_IND	Closed indicator
STEP_CODE	This column corresponds to the step catalog code defined in the Tracking Step Catalog
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_CREDENTIALS	Table made obsolete in Enh. 2177686
Column Name	Descritpion
CREDENTIAL_ID	Unique Identifier of a person's credential
REVIEWER_NOTES	Reviewer notes
RECOMMENDER_NAME	Recommender name
RECOMMENDER_TITLE	Recommender title
RECOMMENDER_ORGANIZATION	Organization
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	Person ID
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	Nominated course code
SEQUENCE_NUMBER	Sequence number
CREDENTIAL_TYPE_ID	Credential type ID
DATE_RECEIVED	Date received
RATING	Rating
REVIEWER_ID	Reviewer ID

Student System - IGS_AD_CONV_GS_VALS	Holds the conversion details from one grading scale type to another grading scale type
Column Name	Descritpion
CONV_GS_VALUES_ID	Unique identifier for each conversion from or to pair
CONV_GS_TYPES_ID	Unique identifier for each conversion
FROM_GPA	From GPA
TO_GPA	From GPA
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_CONV_GS_TYPES	Holds conversion details from one grading scale type to another grading scale type
Column Name	Descritpion
CONV_GS_TYPES_ID	Unique identifier for each conversion
FROM_CODE_ID	Converted from grading scale id
TO_CODE_ID	Converted to grading scale id
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_AD_COLLEGE_ACT	Contains person identifier and person's college interests
Column Name	Descritpion
COLLEGE_ACT_ID	Unique identifier for the intended college activities
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	Application 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 id
INTEREST_TYPE_CODE	Extracurricular activity type
SUB_INTEREST_TYPE_CODE	Sub extracurricular activity type
INTEREST_NAME	Extracurricular activity name
COMMENTS	Comments
ACTIVITY_SOURCE_CD	Identifier for Activity Source
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_CODE_CLASSES	Holds information about different codes, class to which code belongs, and description
Column Name	Descritpion
CODE_ID	Unique identifier for each code
LAST_UPDATE_LOGIN	Standard Who column
SYSTEM_STATUS	This column is used to indicated the system status with which the user defined status is associated
SYSTEM_DEFAULT	This column is used to indicate if a particular code is the system default. Valid values can be 'Y' and 'N'
CLASS_TYPE_CODE	The qualifying type defined for the class
NAME	Name of the code
DESCRIPTION	Description of the code
CLASS	Class that this code belongs to
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_APPL_HIST_ALL	Describes history of changes to admission application
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
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
APPL_DT	Describes the date the admission application was made
PERSON_ID	Describes the ID of the person that the admission application is for
ACAD_CAL_TYPE	Describes the academic calendar type to which the admission application applies
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
ACAD_CI_SEQUENCE_NUMBER	Describes the academic calendar sequence number that the admission application is for
ADM_CAL_TYPE	Describes the admission calendar type that the admission application is for
ORG_ID	Operating unit identifier
ADM_CI_SEQUENCE_NUMBER	Describes the admission calendar sequence number that the admission application is for
ADMISSION_CAT	Describes the institution-defined admission category of the admission application
S_ADMISSION_PROCESS_TYPE	Describes the system-defined admission process type of the admission application
ADM_APPL_STATUS	Describes the institution-defined application status of the admission application
ADM_FEE_STATUS	Describes the institution-defined fee status of the admission application
TAC_APPL_IND	Describes whether or not the application has been made via the tertiary admission center
HIST_START_DT	The effective start date or time of the history record

Student System - IGS_AD_APPL_ALL	Describes admission of applicant to institution
Column Name	Descritpion
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
APPLICATION_TYPE	Admission Application Type
CHOICE_NUMBER	Choice number
ROUTEB_PREF	Route B preference
APPLICATION_ID	A unique identifier to identify an application
ALT_APPL_ID	Alternate Application Identifier
APPL_FEE_AMT	Application Fee Amount
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
APPL_DT	Describes the date the admission application was made
ACAD_CAL_TYPE	Describes the academic calendar type to which the admission application relates
ACAD_CI_SEQUENCE_NUMBER	Describes the academic calendar sequence number that the admission application is for
ADM_CAL_TYPE	Describes the admission calendar type to which the admission application applies
ADM_CI_SEQUENCE_NUMBER	Describes the admission calendar sequence number that the admission application is for
ADMISSION_CAT	Describes the institution-defined admission category of the admission application
S_ADMISSION_PROCESS_TYPE	Describes the system-defined admission process type of the admission application
ORG_ID	Operating unit identifier
ADM_APPL_STATUS	Describes the institution-defined application status of the admission application
ADM_FEE_STATUS	Describes the institution-defined fee status of the admission application
SPCL_GRP_1	Special Group under which the application falls.
SPCL_GRP_2	Special Group under which the application falls.
COMMON_APP	Common Application
TAC_APPL_IND	Describes whether or not the application has been made through the tertiary admission center
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
PERSON_ID	Describes the ID of the person that the admission application is for
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

Student System - IGS_AD_APPINT_INT_ALL	Holds information about person's applicant intent details
Column Name	Descritpion
INTERFACE_APPINT_ID	Interface applicant intent 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
INTERFACE_APPL_ID	Interface applicant identifier
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
ATTRIBUTE_CATEGORY	Standard DFF column
ATTRIBUTE1	Standard DFF column
ATTRIBUTE2	Standard DFF column
ATTRIBUTE3	Standard DFF column
INTERFACE_ID	Interface identifier
ATTRIBUTE4	Standard DFF column
ATTRIBUTE5	Standard DFF column
ATTRIBUTE6	Standard DFF column
ATTRIBUTE7	Standard DFF column
ATTRIBUTE8	Standard DFF column
ATTRIBUTE9	Standard DFF column
ATTRIBUTE10	Standard DFF column
ATTRIBUTE11	Standard DFF column
ATTRIBUTE12	Standard DFF column
ATTRIBUTE13	Standard DFF column
INTENT_TYPE_ID	Applicant intent type
ATTRIBUTE14	Standard DFF column
ATTRIBUTE15	Standard DFF column
ATTRIBUTE16	Standard DFF column
ATTRIBUTE17	Standard DFF column
ATTRIBUTE18	Standard DFF column
ATTRIBUTE19	Standard DFF column
ATTRIBUTE20	Standard DFF column
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_API_INT_ALL	Holds information about person's alternate person identifiers
Column Name	Descritpion
INTERFACE_API_ID	Interface alternate person 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
ATTRIBUTE_CATEGORY	Flex Field Structure defining Column
ATTRIBUTE1	Descriptive Flex Field Segment Column
ATTRIBUTE2	Descriptive Flex Field Segment Column
INTERFACE_ID	Interface identifier
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
ATTRIBUTE19	Descriptive Flex Field Segment Column
ATTRIBUTE20	Descriptive Flex Field Segment Column
REGION_CD	Optional Region Code
PERSON_ID_TYPE	Person identifier type
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
ALTERNATE_ID	Alternate identifier
ORG_ID	Operating unit identifier
START_DT	Start date
END_DT	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_ALIAS_INT_ALL	This table contains person's alias details to be imported.
Column Name	Descritpion
INTERFACE_ALIAS_ID	Interface alias 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
DUP_SEQUENCE_NUMBER	Duplicate 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	Request identifier of last concurrent program to update this record
INTERFACE_ID	Interface identifier
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
ALIAS_TYPE	Alias type
SURNAME	Surname
ORG_ID	Operating unit identifier
GIVEN_NAMES	Given names
TITLE	Title
ALIAS_COMMENT	Alias Comment
START_DT	Alias start date
END_DT	Alias end date

Student System - IGS_AD_ADM_UNIT_STAT_ALL	Describes user-defined administrative unit statuses that map to system-defined unit statues, which are system and manually applied
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
ADMINISTRATIVE_UNIT_STATUS	Institution-defined administrative unit status. Each administrative unit status is mapped to a system unit attempt status and enables further definition of unit attempt statuses. For example, WD-EARLY withdrawn early, WD-LATE withdrawn lat
UNIT_ATTEMPT_STATUS	System-defined unit attempt status that is mapped to the specified administrative unit status. Unit attempt statuses are applied to student unit attempt by the system when defined processes occur.
DESCRIPTION	Administrative unit status AUS. Each AUS is mapped to a system unit attempt status and enables further definition of unit attempt statuses. For example Withdrawn Early, Withdrawn Late.
SHOW_ON_OFFIC_NTFCTN_IND	Specifies whether or not unit attempts with this administrative unit status AUS should be shown on official notifications such as academic transcripts. Setting the checkbox ticked enables unit attempts with the specified AUS to be included
EFFECTIVE_PROGRESSION_IND	Specifies whether or not unit attempts with this administrative unit status AUS are considered to be effectively enrolled for progression rule checks. When the checkbox is ticked, unit attempts with the specified AUS are deemed to be effect
EFFECTIVE_TIME_ELAPSED_IND	Specifies whether or not unit attempts with this administrative unit status AUS are considered to be effectively enrolled for progression time elapsed calculations. When the checkbox is set ticked, unit attempts with the specified AUS are d
ORG_ID	Operating unit identifier
CLOSED_IND	Specifies whether or not the administrative unit status AUS is closed. Setting the checkbox closes the AUS, making it unavailable for use in new records such as Administrative Unit Status Load.

Student System - IGS_AD_ADDR_INT_ALL	Holds information about person's address details
Column Name	Descritpion
INTERFACE_ADDR_ID	Interface address identifier
CITY	City
STATE	State
COUNTY	County
PROVINCE	Province
COUNTRY	Country
OTHER_DETAILS	Other details
OTHER_DETAILS_1	Other details 1
OTHER_DETAILS_2	Other details 2
DELIVERY_POINT_CODE	Delivery point code
OTHER_DETAILS_3	Other details 3
INTERFACE_ID	Interface identifier
CORRESPONDENCE_FLAG	Flag for correspondence
CONTACT_PERSON_ID	Whom the person should contact
DATE_LAST_VERIFIED	Date address was last verified
START_DATE	Start date of address
END_DATE	End date of address
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning
ERROR_CODE	Error code for the record
DUP_PARTY_SITE_ID	Duplicate party site 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_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
ADDR_LINE_1	Address line 1
ADDR_LINE_2	Address line 2
ADDR_LINE_3	Address line 3
ADDR_LINE_4	Address line 4
POSTCODE	Postal code

Student System - IGS_AD_ADDRUSAGE_INT_ALL	Holds information about person's address usages
Column Name	Descritpion
INTERFACE_ADDRUSAGE_ID	Interface address usage 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_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
INTERFACE_ADDR_ID	Interface address identifier
SITE_USE_CODE	Party site use type
COMMENTS	Comments
STATUS	Status of the record whether it is imported, pending, error or warning
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
ORG_ID	Operating unit identifier
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Student System - IGS_AD_ACADINT_INT_ALL	Holds information about person's academic interests
Column Name	Descritpion
INTERFACE_ACADINT_ID	Interface academic interest 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
FIELD_OF_STUDY	Academic field of study
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_IMP_NEAR_MTCH_ALL	Holds details about the near match between the imported data and existing data
Column Name	Descritpion
NEAR_MTCH_ID	A unique identifier to identify each of the near match 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
INTERFACE_RELATIONS_ID	Interface Relation Identifier
INTERFACE_ID	Interface ID
PERSON_ID	Person ID for whom the data is imported
MATCH_IND	E - Exact Match P - Partial Match
ORG_ID	Organization unit identifier
ACTION	I - Import D - Don't Import
ADDR_TYPE	Address type
PARTY_SITE_ID	Party site identifier
PERSON_ID_TYPE	Person ID type
MATCH_SET_ID	Match criteria
CREATED_BY	Standard Who column

Student System - IGS_AD_HZ_EXTRACURR_ACT	This table holds details of person's extracurricular activities or interests that are not present in existing TCA table HZ_INTEREST.
Column Name	Descritpion
HZ_EXTRACURR_ACT_ID	Person activity or interest identifier
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Identifier for request
PROGRAM_APPLICATION_ID	Identifier for program application
PROGRAM_ID	Identifier for program
PROGRAM_UPDATE_DATE	Program update date
PERSON_INTEREST_ID	Foreign Key to HZ_PERSON_INTEREST
END_DATE	End date
HOURS_PER_WEEK	Hours per week
WEEKS_PER_YEAR	Weeks per year
ACTIVITY_SOURCE_CD	Person Interest Source Code
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_AD_HZ_EMP_DTL	Holds details of person's employment that are not present in existing TCA table HZ_EMPLOYMENT_HISTORY
Column Name	Descritpion
HZ_EMP_DTL_ID	Employment details identifier
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
EMPLOYMENT_HISTORY_ID	Foreign key to HZ_EMPLOYMENT_HISTORY
TYPE_OF_EMPLOYMENT	Obsolete. Migrated to HZ_EMPLOYMENT_HISTORY.
FRACION_OF_EMPLOYMENT	Obsolete. Migrated to HZ_EMPLOYMENT_HISTORY.
TENURE_OF_EMPLOYMENT	Obsolete. Migrated to HZ_EMPLOYMENT_HISTORY.
OCCUPATIONAL_TITLE_CODE	Occupational code ID
WEEKLY_WORK_HOURS	Obsolete. Migrated to HZ_EMPLOYMENT_HISTORY.
COMMENTS	Obsolete. Migrated to HZ_EMPLOYMENT_HISTORY.
CREATED_BY	Standard Who column

Student System - IGS_AD_HZ_ACAD_HIST	Holds details of person's academic history that are not present in existing TCA table HZ_EDUCATION
Column Name	Descritpion
HZ_ACAD_HIST_ID	Academic history details identifier
RECALC_TOT_GPA_UTS_ATTEMPTED	Recalculated total GPA units attempted
RECALC_INST_GPA	Institution grade point average
RECALC_GRADING_SCALE_ID	Recalculated grade point average scale type
SELFREP_TOTAL_CP_ATTEMPTED	Self reported total credit points attempted
SELFREP_TOTAL_CP_EARNED	Self reported total credit points earned
SELFREP_TOTAL_UNIT_GP	Self reported total unit grade points
SELFREP_TOT_GPA_UTS_ATTEMP	Self reported total GPA units attempted
SELFREP_INST_GPA	Self reported institution grade point average
SELFREP_GRADING_SCALE_ID	Self reported grade point average scale type
SELFREP_WEIGHTED_GPA	Y or N
EDUCATION_ID	Foreign key to HZ_EDUCATION
SELFREP_RANK_IN_CLASS	Self reported rank in class
SELFREP_WEIGHED_RANK	Y or N
SELFREP_CLASS_SIZE	Self Reported Class Size
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
CURRENT_INST	Current institution
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
PROGRAM_TYPE_ATTEMPTED	Degree attempted - Obsolete
ATTRIBUTE18	Descriptive Flex Field segment column
ATTRIBUTE19	Descriptive Flex Field segment column
ATTRIBUTE20	Descriptive Flex Field segment column
TRANSCRIPT_REQUIRED	This column is used to indicate if the transcript from the institution is required for Application Completion
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	Identifier for request
PROGRAM_APPLICATION_ID	Identifier for program application
COMMENTS	Comments. In case the program code is not known, the comments fields can be made use to record the program details.
PROGRAM_ID	Identifier for program
PROGRAM_UPDATE_DATE	Program update date
DEGREE_ATTEMPTED	Degree Attempted
PLANNED_COMPLETION_DATE	Planned completion date
RECALC_TOTAL_CP_ATTEMPTED	Recalculated total credit points attempted
RECALC_TOTAL_CP_EARNED	Recalculated total credit points earned
RECALC_TOTAL_UNIT_GP	Recalculated total unit grade points

Student System - IGS_AD_HLTH_INS_INT_ALL	This table contains person's health and insurance details to be imported.
Column Name	Descritpion
INTERFACE_HLTH_ID	Interface health record identifier
ERROR_CODE	Error code of the record
DUP_HLTH_INS_ID	Duplicate health and insurance 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
INSURANCE_CD	Insurance code.
ATTRIBUTE_CATEGORY	Stores context for the Flex Field
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.
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.
INSURANCE_ID	Insurance identifier
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.
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
INSURANCE_PROVIDER	Insurance provider
ORG_ID	Operating unit identifier
POLICY_NUMBER	Insurance policy details
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

Student System - IGS_AD_EXCURR_INT_ALL	This table contains person's extracurricular activities details to be imported.
Column Name	Descritpion
ORG_ID	Operating unit identifier
LEVEL_OF_INTEREST	A user defined level number or name to rate the amount of interest in the activity, for example, high, medium, low.
LEVEL_OF_PARTICIPATION	A user defined level number or name to indicate if the person participates and to what extent.
SPORT_INDICATOR	Y or N, indicates whether the activity is a sport
SUB_INTEREST_TYPE_CODE	A code to classify sub-interests of the interest type code
INTEREST_NAME	A text field that allows for assigning a descriptive name to an interest
TEAM	Any team of which the person is a member.
ACTIVITY_SOURCE_CD	Person Interest Source
RANK	Person Interest Rank
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warning
INTERFACE_EXCURR_ID	Person activity or interest identifier
ERROR_CODE	Error code of the record
DUP_PERSON_INTEREST_ID	Duplicate interest 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
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
INTEREST_TYPE_CODE	A code to classify interests for evaluation
COMMENTS	Comments about person's interest
START_DATE	Start date
END_DATE	End date
HOURS_PER_WEEK	Hours per week
WEEKS_PER_YEAR	Weeks per year

Student System - IGS_AD_EMP_INT_ALL	contains the person's employment details to be imported.
Column Name	Descritpion
INTERFACE_EMP_ID	Interface employment identifier
TENURE_OF_EMPLOYMENT	Will Now be validated against lookup HZ_TENURE_CODE
POSITION	Position
OCCUPATIONAL_TITLE_CODE	Occupational title code
WEEKLY_WORK_HRS	Weekly working hours
EMPLOYER	The name of the organization at which the person was employed. 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.
STATUS	Status of the record whether it is imported, pending, error or warning
MATCH_IND	Match indicator
ERROR_CODE	Error code of the record
DUP_EMPLOYMENT_NUMBER	Duplicate employment number
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
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
PARTY_TYPE	Obsolete. No longer used.
COMMENTS	General comments about the employment
CONTACT	Contact information
ORG_ID	Operating unit identifier
ORG_UNIT_CD	Obsolete. No longer used.
START_DATE	Joining date
END_DATE	End date
TYPE_OF_EMPLOYMENT	Will Now be validated against lookup HZ_EMPLOYMENT_TYPE
FRACTION_OF_EMPLOYMENT	Fraction of full time employment

Student System - IGS_AD_DISABLTY_INT_ALL	Holds information about person's disability details
Column Name	Descritpion
INTERFACE_DISABLTY_ID	Interface disability identifier
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
ATTRIBUTE19	Descriptive Flex Field Segment Column
ATTRIBUTE20	Descriptive Flex Field Segment Column
MATCH_IND	Match indicator
INTERFACE_ID	Interface 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
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
DISABILITY_TYPE	Disability type
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
SPL_SERVICE_ID	Special Service ID(Obsolete).
CONTACT_IND	Contact Indicator(Obsolete)
SPECIAL_ALLOW_CD	Special allow code.
SUPPORT_LEVEL_CD	Support level 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
DUP_DISABILITY_ID	Disability ID of the duplicate record in production table
ORG_ID	Operating unit identifier
SPL_ALLOW_ID	Special allowance identifier
SUPPORT_LEVEL_ID	Support level identifier
ELIG_EARLY_REG_IND	Early Registration Indicator
START_DATE	Start Date - defaulted to 01 Jan 1947, as this is a new column and is mandatory
END_DATE	End Date
INFO_SOURCE	Source of Information
INTERVIEWER_ID	Person ID of Interviewer
INTERVIEWER_DATE	Interview Date
ATTRIBUTE_CATEGORY	Flex Field Structure defining Column

Student System - IGS_AD_CONTACTS_INT_ALL	Holds information about contact details
Column Name	Descritpion
INTERFACE_CONTACTS_ID	Interface contacts identifier
PHONE_NUMBER	Phone number
PHONE_EXTENSION	Phone extension
STATUS	Status of the record whether it is 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_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	Application 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	Last update date of this record by a concurrent program
EMAIL_ADDRESS	Email address
ORG_ID	Operating unit identifier
EMAIL_FORMAT	Email format
PRIMARY_FLAG	Primary flag
PHONE_LINE_TYPE	Phone line type
PHONE_COUNTRY_CODE	Phone country code
PHONE_AREA_CODE	Phone area code

Student System - IGS_AD_COLLACT_INT_ALL
Column Name	Descritpion
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
DUP_COLLEGE_ACT_ID	Duplicate college activity 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
INTERFACE_COLLACT_ID	Interface college activity identifier
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
COLLEGE_ACTIVITY_TYPE	College activity type
COMMENTS
SUB_INTEREST_TYPE_CODE	A code to classify sub-interests of the interest type code
INTEREST_NAME	A text field that allows for assigning a descriptive name to an interest
ACTIVITY_SOURCE_CD	Extracurricular Activity Source
MATCH_IND	Match indicator

Student System - IGS_AD_CITIZEN_INT_ALL	Holds information about citizenship details
Column Name	Descritpion
INTERFACE_CITIZEN_ID	Interface citizen identifier
DUP_CITIZENSHIP_ID	Duplicate citizenship identifier
STATUS	Status of the record whether it is imported, pending, error or warning
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
INTERFACE_ID	Interface identifier
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
BIRTH_OR_SELECTED	Citizenship by birth or by naturalization
COUNTRY_CODE	Country code
ORG_ID	Operating unit identifier
DATE_DISOWNED	Date citizenship disowned
DATE_RECOGNIZED	Date citizenship recognized
DOCUMENT_TYPE	Document used to recognize citizenship
DOCUMENT_REFERENCE	Document reference to recognize citizenship
END_DATE	Citizenship end date

Student System - IGS_AD_CAT_ATTR	Holds data for categories - Obsolete
Column Name	Descritpion
SRC_CAT_ID	Identifier for the category
ATTR_NAME	Attribute name for different categories
INCLUDE_IND	Indicator to know whether a certain attribute has to be included in the category
MANDATORY_IND	These attributes are mandatory if checked
SYS_MANDATORY_IND	These are the system mandatory indicator
DISPLAY_SEQUENCE	Stores sequence number for the attributes
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CAT_ATTR_ID	Category unit identifier
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_AD_BUILDING_ALL	Contains building information
Column Name	Descritpion
BUILDING_ID	Building unit identifier
LAST_UPDATE_LOGIN	Standard Who column
LOCATION_CD	Location unit identifier
BUILDING_CD	Code for building unit identifier
DESCRIPTION	Description of the building
ORG_ID	Operating unit identifier
CLOSED_IND	Checkbox to indicate whether the building is closed or not.
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_ATHLETICS_INT_ALL	Holds information about applicant's athletic details
Column Name	Descritpion
INTERFACE_ATHLETICS_ID	Interface athletics 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_ID	Interface identifier
INTERFACE_APPL_ID	Interface Applicant Identifier
ATHLETICS_SPORT_ID	Athletics sport identifier
RATING	Rating
ORG_ID	Operating unit identifier
MATCH_IND	Match indicator
STATUS	Status of the record whether it is imported, pending, error or warnin.
ERROR_CODE	Error code of the record
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_APPL_INT_ALL	Obsolete
Column Name	Descritpion
INTERFACE_APPL_ID	Interface application identifier
S_ADMISSION_PROCESS_TYPE	System admission process type
TRANSFER_COURSE_CD	Transfer program code
LOCATION_CD	Location code
ATTENDANCE_TYPE	Attendance type
ATTENDANCE_MODE	Attendance mode
UNIT_SET_CD	Unit set code
US_VERSION_NUMBER	Unit set version number
PREFERENCE_NUMBER	Preference number
APP_SOURCE_ID	Application source identifier
ATHLETIC_GPA	Made obsolete in Enh. 2101696
ATHLETIC_ELIGIBILITY_STATUS	Made obsolete in Enh. 2101696
EDU_GOAL_PRIOR_ENROLL	Education goal prior to enrollment
ADMISSION_APPL_NUMBER	Admission application number
INTERFACE_ID	Interface identifier
APPLY_FOR_FINAID	Apply for financial aid
SEQUENCE_NUMBER	Sequence number
FINAID_APPLY_DATE	Financial aid application date
SS_APPLICATION_ID	Self Service Application Id
ATTRIBUTE_CATEGORY	Descriptive flex field 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
APP_SOURCE	Application source
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
NOMINATED_COURSE_CD	Program code applied
ATTRIBUTE17	Descriptive Flexfield segment column
ATTRIBUTE18	Descriptive Flexfield segment column
ATTRIBUTE19	Descriptive Flexfield segment column
ATTRIBUTE20	Descriptive Flexfield segment column
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
ORG_ID	Operating unit identifier
CRV_VERSION_NUMBER	Program code version number
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
ENTRY_STATUS	Entry Status
ENTRY_LEVEL	Entry Level
SCH_APL_TO_ID	Identifier of the school applied for
SPCL_GRP_1	Special Group
SPCL_GRP_2	Special Group
COMMON_APP	Common Application
APPL_DT	Application date
ACAD_CAL_TYPE	Academic calendar type
ACAD_SEQUENCE_NUMBER	Academic calendar sequence number
ADM_CAL_TYPE	Admission calendar type
ADM_SEQUENCE_NUMBER	Admission calendar type
ADMISSION_CAT	Admission category

Student System - IGS_AD_ACADHONOR_INT_ALL	Holds information about person's academic honors
Column Name	Descritpion
INTERFACE_ACADHONOR_ID	Interface academic honor 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
ACAD_HONOR_TYPE	Academic Honor Type
INTERFACE_ID	Interface record Identifier
DUP_ACAD_HONOR_ID	Identifier for the record in IGS_PE_ACAD_HONORS entity, which is duplicate of the interface record
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
INTERFACE_APPL_ID	Interface application identifier -Obsolete.
ACAD_HONOR_TYPE_ID	Academic honor type identifier -Obsolete.
COMMENTS	Comments
ORG_ID	Operating unit identifier
HONOR_DATE	Academic honor received 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

Student System - IGS_AD_ACADHIS_INT_ALL	Holds information about person's academic history
Column Name	Descritpion
START_DATE	Start date at institution
INTERFACE_ACADHIS_ID	Interface academic history identifier
END_DATE	End date at institution
PLANNED_COMPLETION_DATE	Planned completion date at institution
SELFREP_TOTAL_CP_ATTEMPTED	Self reported total credit points attempted
SELFREP_TOTAL_CP_EARNED	Self reported total credit points earned
SELFREP_TOTAL_GP_UNITS_ATTEMP	Self reported total grade points units attempted
SELFREP_INST_GPA	Self reported institution grade point average
SELFREP_GRADING_SCALE_ID	Self reported grading scale identifier
SELFREP_WEIGHTED_GPA	Self reported weighted GPA
SELFREP_RANK_IN_CLASS	Self reported class rank
SELFREP_WEIGHTED_RANK	Self reported weighted rank
INTERFACE_ID	Interface identifier
ATTRIBUTE_CATEGORY	Flexfield 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
INSTITUTION_CODE	Institution code
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
CURRENT_INST	Current institution indicator
ATTRIBUTE20	Descriptive Flex Field segment column
MATCH_IND	Match indicator
STATUS	Status of record. Imported, pending, error, or warning
ERROR_CODE	Error code of record
DUP_ACAD_HISTORY_ID	Duplicate academic history identifier
CLASS_SIZE	Class Size
EDUCATION_ID	Holds the unique identifier of HZ_EDUCATION table. Populated after record has been successfully created or updated
TRANSCRIPT_REQUIRED	Indicates if transcript is required for institution
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
PROGRAM_TYPE_ATTEMPTED	Program type attempted-Obsolete
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update record
PROGRAM_ID	Program identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	Last update date of 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
UPDATE_EDUCATION_ID	Unique identifier to identify the OSS record which will map to EDUCATION_ID
DEGREE_ATTEMPTED	Degree Attempted
ORG_ID	Operating unit identifier
DEGREE_EARNED	Degree Earned
PROGRAM_TYPE_EARNED	Program type earned-Obsolete
PROGRAM_CODE	Program code
TYPE_OF_SCHOOL	School type
COMMENTS	Comments

Student System - IGS_AD_AUSE_ED_AS_TY	Describes user-defined assessment types for secondary education
Column Name	Descritpion
GOVT_REPORTED_IND	Specifies whether the assessment type should be used to derive the government-reportable Tertiary Entrance Score TES value. To enable the reporting of a TES to DETYA, the assessment type must be 'flagged' as government reported. Setting t
CLOSED_IND	Specifies whether the Secondary Education Assessment Type is open or closed. Setting the indicator to 'closed' prevents use of the assessment type in new or modified Secondary Education records.
CREATED_BY	Standard Who column
AUS_SCNDRY_EDU_ASS_TYPE	Describes the system-defined Australian Secondary Education Assessment types, for example, VCE, IB, YR12-ACT.
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 Secondary Education Assessment Type
TAC_AUS_SCNDRY_EDU_ASS_TYPE	Describes the tertiary admissions center Australian Secondary Education Assessment Type, for example, 'V' - VCE, 'H' - HSC,'I' - IB.
STATE_CD	The State linked to the Secondary Education Assessment Type, for example, VIC, QLD, WA, SA.

Student System - IGS_AD_APP_REQ	Holds applicant's application requirements
Column Name	Descritpion
APP_REQ_ID	Unique identifier for the applicants application requirements id
FEE_AMOUNT	Stores the fee payment amount
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REFERENCE_NUM	This is used to store the authorization number for a credit transaction
CREDIT_CARD_CODE	Credit card Code
CREDIT_CARD_HOLDER_NAME	Credit card holder name
CREDIT_CARD_NUMBER	Credit card number
CREDIT_CARD_EXPIRATION_DATE	Credit card expiration date
REV_GL_CCID	Revenue general ledger code combination identifier
CASH_GL_CCID	Cash general ledger code combination identifier
REV_ACCOUNT_CD	Revenue account code
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
CASH_ACCOUNT_CD	Cash account code
GL_DATE	General ledger date
GL_POSTED_DATE	General ledger posted date
POSTING_CONTROL_ID	Posting control identifier
CREDIT_CARD_STATUS_CODE	Status of the Credit Card Transaction.
CREDIT_CARD_PAYEE_CD	Credit Card Payee
CREDIT_CARD_TANGIBLE_CD	Credit Card Tangible code, used to identify a credit card transaction.
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	OBSOLETE. Describes the program code of the program for that the applicant is seeking admission
SEQUENCE_NUMBER	Describes the sequence number of the application
APPLICANT_FEE_TYPE	Stores the name of a fee that the applicant opts for. For example, HECS, GSF, MEDIBANK. A fee type may be assigned as a fee liability of many fee categories.
APPLICANT_FEE_STATUS	Describes the applicant's fee status
FEE_DATE	Stores the fee payment date
FEE_PAYMENT_METHOD	Stores the fee payment method

Student System - IGS_AD_APPL_STAT	Describes user-defined admission application statuses which map to system-defined statuses. Values include received, withdrawn, under consideration, or complete.
Column Name	Descritpion
ADM_APPL_STATUS	Contains the institution-defined status assigned to an admission application to describe its state within the admission application process. These must be mapped onto a system-defined admission application status. For example, RECEIVED APP
S_ADM_APPL_STATUS	Contains the system-defined status assigned to an admission application to describe its state within the admission application process. For example, RECEIVED, COMPLETED, WITHDRAWN.
SYSTEM_DEFAULT_IND	An indicator that specifies if the admission application status is the default institution-defined status that the system should use when referred to from a system-defined admission application status.
CLOSED_IND	Specifies if the admission application status is open or closed. Setting the checkbox to 'closed' prevents use of the admission application status in new or modified admission application 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
DESCRIPTION	Provides an explanation of the admission application status

Student System - IGS_AD_APPL_NOTES	Holds details of applicant's notes
Column Name	Descritpion
APPL_NOTES_ID	Unique identifier for the application notes
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	Request identifier of last concurrent program to update this record
PROGRAM_ID	Request identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Request identifier of last concurrent program to update this record
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	Describes the program code of the program for which the applicant is seeking admission
SEQUENCE_NUMBER	Describes the sequence number of the application
NOTE_TYPE_ID	Identifier for the note types
REF_NOTES_ID	Reference notes identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_AD_APPL_LTR	Describes correspondence produced for admission application
Column Name	Descritpion
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
CORRESPONDENCE_TYPE	Code for the type of correspondence
SEQUENCE_NUMBER	Unique identifier for admission application letter
COMPOSED_IND	Specifies whether the letter is composed or not. Setting the checkbox ticked indicates the letter is composed, and may be run through a batch letter production. An unchecked box indicates the letter is not ready to be produced.
LETTER_REFERENCE_NUMBER	Unique identifier for a system letter
SPL_SEQUENCE_NUMBER	To identify uniquely a letter that has been sent to 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	Request identifier of last concurrent program to update this record
PROGRAM_ID	Request identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Request identifier of last concurrent program to update this record
PERSON_ID	Describes the ID of the person that the admission application is for

Student System - IGS_AD_APPL_EVAL	Holds details of evaluators assigned to various applications
Column Name	Descritpion
APPL_EVAL_ID	A unique identifier assigned to each of the evaluator assigned to an application
RATING_TYPE_ID	Describes the rating types. Its taken from the IGS_AD_CODE_CLASSES if the code type is 'RATING_TYPE'
RATING_VALUES_ID	Stores the rating values
RATING_NOTES	Evaluator's comments
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
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
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
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
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.
RATING_SCALE_ID	A unique identifier assigned to each of the rating scales.
CLOSED_IND	Closed Indicator
ADMISSION_APPL_NUMBER	Describes the admission application number associated with the applicant's application
NOMINATED_COURSE_CD	Describes the program code of the program for which the applicant is seeking admission
SEQUENCE_NUMBER	Describes the sequence number of the application
EVALUATOR_ID	Evaluator person ID
ASSIGN_TYPE	Describes the assign type, for example, M- Manual and A- Automatic
ASSIGN_DATE	Date the application was assigned to an evaluator
EVALUATION_DATE	The date the evaluation was performed

Student System - IGS_AD_ADV_PLACEMENT	Holds details of person's placement test exemption details
Column Name	Descritpion
TEST_EXEMPTION_ID	Unique identifier for the exemption details
PERSON_ID	Contains the institution-defined number that uniquely identifies a person
EXEMPTION_ID	Placement test exemptions ID
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Student System - IGS_AD_EDUGOAL_INT_ALL	Stores interface details for person's educational goals
Column Name	Descritpion
INTERFACE_APPL_ID	Obsolete
EDU_GOAL_ID	Educational Goal Identifier
MATCH_IND	Match Indicator
STATUS	Educational Goal Status
ERROR_CODE	Error Code
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
ORG_ID	Operating Unit 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_EDUGOAL_ID	Interface Educational Goal Identifier
INTERFACE_PS_APPL_INST_ID	Interface Program Application Instance Identifier

Student System - IGS_AD_CAT_ALL	Describes user-defined categories of applicant that identify different processing requirements of applicants to institution
Column Name	Descritpion
ADMISSION_CAT	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.
DESCRIPTION	Description 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_CITIZENSHIP_TYPE	Describes the citizenship type of the admission category. The citizenship type may be International, Domestic or All.
ORG_ID	Operating Unit Identifier
CLOSED_IND	Specifies whether the admission category is open or closed. Setting the indicator to 'closed' prevents use of the code in new or modified records
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

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

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

Student System - IGS_AD_INQ_UNIT_SETS	Stores inquiry unit set codes - Obsolete
Column Name	Descritpion
INQ_UNIT_SET_CODE_ID	Unique identifier of a inquiry unit set code
INQ_UNIT_SET_CODE	Inquiry unit set code
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_DSCP_ATTR	Holds information about attributes used with category
Column Name	Descritpion
DISCREPANCY_ATTR_ID	Unique identifier of discrepancy attribute.
SRC_CAT_ID	Unique identifier of admission source category
ATTRIBUTE_NAME	Attribute name for different categories
DISCREPANCY_RULE_CD	Discrepancy rule code
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_INQ_APPL_INT	This table holds admission inquiry instance interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_APPL_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
INQUIRY_STATUS	Inquiry Status. 'MAILED', 'INQUIRED'
INQUIRY_DT	Inquiry Date
DUP_PERSON_ID	Duplicate Person Identifier
DUP_ENQUIRY_APPL_NUMBER	Duplicate Inquiry Application Number
INQUIRY_SOURCE_TYPE	Inquiry Source Type. 'Web Inquiry'
INQUIRY_ENTRY_STATUS_ID	Inquiry Status(First time freshman, transfer, new graduate)
INQUIRY_ENTRY_LEVEL_ID	Inquiry Entry Level. First year, second year, junior , senior
REGISTERING_PERSON_ID	Registering Person Identifier
OVERRIDE_PROCESS_IND	Override Process Indicator.
INDICATED_MAILING_DT	Indicated Mailing Date
INTERFACE_ID	Interface Identifier
LAST_PROCESS_DT	Last Processed Date
COMMENTS	Comments
EDU_GOAL_ID	Educational Career Goal. Medicine, business, law
INQUIRY_SCHOOL_OF_INTEREST_ID	Inquiry School Of Interest
LEARN_SOURCE_ID	Inquiry Learning Source
INFLUENCE_SOURCE_ID	Inquiry Influence Id
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' -- Match reviewed and do not import
ERROR_CODE	Error Code
ATTRIBUTE_CATEGORY	Descriptive flex field structure defining column
ENQUIRY_APPL_NUMBER	Enquiry Application Number
ATTRIBUTE1	Descriptive flex field segment Column
ATTRIBUTE2	Descriptive flex field segment Column
ATTRIBUTE3	Descriptive flex field segment Column
ATTRIBUTE4	Descriptive flex field segment Column
ATTRIBUTE5	Descriptive flex field segment Column
ATTRIBUTE6	Descriptive flex field segment Column
ATTRIBUTE7	Descriptive flex field segment Column
ATTRIBUTE8	Descriptive flex field segment Column
ATTRIBUTE9	Descriptive flex field segment Column
ATTRIBUTE10	Descriptive flex field segment Column
ACAD_CAL_TYPE	Academic Calendar type in which the Inquiry is made
ATTRIBUTE11	Descriptive flex field segment Column
ATTRIBUTE12	Descriptive flex field segment Column
ATTRIBUTE13	Descriptive flex field segment Column
ATTRIBUTE14	Descriptive flex field segment Column
ATTRIBUTE15	Descriptive flex field segment Column
ATTRIBUTE16	Descriptive flex field segment Column
ATTRIBUTE17	Descriptive flex field segment Column
ATTRIBUTE18	Descriptive flex field segment Column
ATTRIBUTE19	Descriptive flex field segment Column
ATTRIBUTE20	Descriptive flex field segment Column
ACAD_CI_SEQUENCE_NUMBER	Academic Sequence Number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
ADM_CAL_TYPE	Admission Calendar Type
ADM_CI_SEQUENCE_NUMBER	Admission Calendar Sequence Number

Student System - IGS_AD_INQ_PRG_INT	Holds admission inquiry program interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_PRG_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier
PROGRAM_CODE_ID	Inquired Program Code(BA, BS)
PROGRAM_PREFERENCE	Program Preference (1,2,3)
DUP_INQ_PROG_PREF_ID	Duplicate Program Preference Identifier
STATUS	1- Completed 2- Pending 3 - Error 4 - Warning
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values'20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' - Match reviewed and do not import '11' - No match
ERROR_CODE	Error Code
CREATED_BY	Standard Who column

Student System - IGS_AD_INQ_UNT_INT	Holds admission inquiry unit interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_UNT_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier
UNIT_SET_CODE_ID	Inquired Unit Set Code( English, History, Biology)
UNIT_SET_PREFERENCE	Unit Set Preference (1, 2, 3)
DUP_INQ_UNIT_SET_PREF_ID	Duplicate Inquiry Unit set Preference Identifier
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
MATCH_IND	Match indicator
ERROR_CODE	Error Code
CREATED_BY	Standard Who column

Student System - IGS_AD_INQ_PRUNT_INT	Holds admission inquiry combined program and unit set information interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_PRGUNT_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
INTERFACE_INQ_PRG_ID	Interface Inquiry Program Identifier.
UNIT_SET_CODE_ID	Inquired Unit Set Code( English, History, Biology)
UNIT_SET_PREFERENCE	Unit Set Preference (1, 2, 3)
DUP_INQ_PRG_PREF_USET_ID	Duplicate Inquiry Program Preference Unit Set Identifier
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
MATCH_IND	Match indicator
ERROR_CODE	Error Code
CREATED_BY	Standard Who column

Student System - IGS_AD_INQ_PKG_INT	Holds admission inquiry package item interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_PKG_ID	A unique identifier assigned to identify each row of the interface table contents. This id should be populated when the rows are inserted into this table
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
DONOT_MAIL_IND	Do Not Mail Indicator
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier
PACKAGE_ITEM	Inquired Package Item
DUP_PERSON_ID	Duplicate Person Identifier
DUP_ENQUIRY_APPL_NUMBER	Duplicate Inquiry Application Number
STATUS	1- Completed 2- Pending 3 - Error 4 - Warning
MATCH_IND	Match indicator.
ERROR_CODE	Error Code
CREATED_BY	Standard Who column

Student System - IGS_AD_INQ_INFO_INT	Holds admission inquiry information type interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_INFO_ID	A unique identifier assigned to identify each row of the interface table contents. This ID should be populated when the rows are inserted in to this table.
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
REQUEST_ID	Standard who column for concurrent Programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent Programs
PROGRAM_ID	Standard who column for concurrent Programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent Programs
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier.
INQUIRY_INFORMATION_TYPE	Inquiry Information Type
DUP_PERSON_ID	Duplicate Person Identifier
DUP_ENQUIRY_APPL_NUMBER	Duplicate Inquiry Application Number
STATUS	Status of the record1-'Completed'2-'Pending'3-'Error'4-'Warning'
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' - Match reviewed and do not import '11' - No match
ERROR_CODE	Error Code
CREATED_BY	Standard WHO Column

Student System - IGS_AD_INQ_CHAR_INT	Holds admission inquiry characteristics interface records - Obsolete
Column Name	Descritpion
INTERFACE_INQ_CHAR_ID	A unique identifier assigned to identify each row of the interface table contents. This ID should be populated when the rows are inserted in to this table.
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Concurrent Program Standard Who Column
PROGRAM_APPLICATION_ID	Concurrent Program Standard Who Column
PROGRAM_ID	Concurrent Program Standard Who Column
PROGRAM_UPDATE_DATE	Concurrent Program Standard Who Column
INTERFACE_INQ_APPL_ID	Interface Inquiry Application Identifier
INQUIRY_CHARACTERISTIC_TYPE	Inquiry Characteristic Type
DUP_INQUIRY_APPL_NUMBER	Duplicate Inquiry Application Number
DUP_PERSON_ID	Duplicate Inquiry Person Identifier
STATUS	Status of the record1-'Completed'2-'Pending'3-'Error'4-'Warning'
MATCH_IND	'18' - Match occurred and used import values '19' - Match exists and retained existing values '20' - Requires Review and is pending '21' - Match reviewed and to be imported '22' - Match reviewed and do not import '11' - No match
ERROR_CODE	Error Code
CREATED_BY	Standard Who Column

Student System - IGS_AD_INQ_PROGS	Stores inquiry program codes - Obsolete
Column Name	Descritpion
INQ_PROG_CODE_ID	Unique identifier of a inquiry program code
INQ_PROG_CODE	Inquiry program code
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_ENT_INQ_PROGS	Stores inquiry programs corresponding to inquiry entry status - Obsolete
Column Name	Descritpion
ENT_INQ_PROG_ID	Unique identifier of an inquiry program corresponding to an entry status
INQ_ENTRY_STAT_ID	Unique identifier for inquiry entry status
INQ_PROG_CODE_ID	Inquiry program 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

Student System - IGS_AD_ENT_INQ_USET	Stores inquiry unit sets corresponding to inquiry entry status - Obsolete
Column Name	Descritpion
ENT_INQ_UNIT_SET_ID	Unique identifier of an inquiry unit set corresponding to an entry status
INQ_ENTRY_STAT_ID	Unique identifier for inquiry entry status
INQ_UNIT_SET_CODE_ID	Inquiry unit set 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

Student System - IGS_AD_ENT_PKG_ITEMS	Stores inquiry package items corresponding to inquiry entry status - Obsolete
Column Name	Descritpion
ENT_PKG_ITEM_ID	Unique identifier of an inquiry package item corresponding to an entry status
INQ_ENTRY_STAT_ID	Unique identifier for inquiry entry status
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_APLINS_ADMREQ	Contains data used to link table for application instances and admission requirements related tracking types (application instance + tracking type = tracking item)
Column Name	Descritpion
APLINS_ADMREQ_ID	Sequence generated number to uniquely identify the admission requirements attached to an application instance.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
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
PERSON_ID	Person ID specified in the Program Application Instance
ADMISSION_APPL_NUMBER	Admission Application Number
COURSE_CD	Program Code for the program application instance
SEQUENCE_NUMBER	Unique application Instance Sequence Number
TRACKING_ID	Tracking ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_AD_APPL_ARP	Table where all Application Review Profile related information corresponding to an application instance will be recorded. This is expected to be a 'high transaction' table.
Column Name	Descritpion
APPL_ARP_ID	Unique Identifier of a Admission Application review profile.
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
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	This field describes the ID code of the person that the admission application is for.
ADMISSION_APPL_NUMBER	Identifies uniquely an admission application for a person
NOMINATED_COURSE_CD	This field describes the course code of the course offering instance that the person is applying for admission to.
SEQUENCE_NUMBER	This field describes the unique identifier of an admission course application instance. The unique identifier is required to allow for preferences on location code attendance mode attendance type and unit set code
APPL_REV_PROFILE_ID	Unique Identifier of a Application Review Profile Review Group.
APPL_REVPROF_REVGR_ID	Unique Identifier of a Application Review Profile Review Group.
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.

Student System - IGS_AD_APL_RVPF_RSL	Table where all Rating Scale related information corresponding to an Application Review Profile will be recorded.
Column Name	Descritpion
APPL_REVPROF_RTSCALE_ID	Unique Identifier of an Application Review Profile Rating Scale
APPL_REV_PROFILE_ID	Unique Identifier of a Application Review Profile Review Group.
RATING_TYPE_ID	Unique Identifier of a Rating Type.
RATING_SCALE_ID	Unique Identifier of a Rating Scale.
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_APL_RPRF_RGR	Table where the Application Review Group Code related information will be recorded. Here the Application Review Group IDs will be generated and information like Review Group Code, Review Group Name will be stored. This is not expected to b
Column Name	Descritpion
APPL_REVPROF_REVGR_ID	Unique Identifier of a Application Review Profile Review Group.
APPL_REV_PROFILE_ID	Unique Identifier of a Application Review Profile Group.
REVPROF_REVGR_CD	Application Review Profile Review Group Code.
REVPROF_REVGR_NAME	Application Review Profile Review Group 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

Student System - IGS_AD_APL_REV_PRF_ALL	Table where all Application Review Profile related information will be recorded. Here the Application Review Profile IDs will be generated and information like Review Profile Name, Start Date, End Date, whether program approval is required
Column Name	Descritpion
APPL_REV_PROFILE_ID	Unique Identifier of a Application Review Profile Group.
APPL_REV_PROFILE_GR_CD	Applications will be divided into Review Groups codes. User can select only one for each Application Review Profile Group.
SITE_USE_CODE	The user will establish an Application Review Profile Group and specify which institutional address usage they wish to have the system look at.
CLOSED_IND	Closed indicator for Application Review Profile Group. 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
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
ORG_ID	Operating unit identifier
REVIEW_PROFILE_NAME	User defined Application Review Profile Name.
START_DATE	Start Date for an Application Review Profile. Default value should be system date.
END_DATE	End Date for an Application Review Profile.
MIN_EVALUATOR	Minimum number of evaluator for Application Review Profile Group.
MAX_EVALUATOR	Maximum number of evaluator for Application Review Profile Group.
PROG_APPROVAL_REQUIRED	Indicator to designate whether Program Approval is required or not. Valid values can be Yes - 'Y' or No - 'N'.
SEQUENTIAL_CONCURRENT_IND	Indicator to designate whether Application instance evaluation will be sequential or concurrent in the Application Review Profile Group. Valid values can be Sequential - 'S' or Concurrent - 'C'.

Student System - IGS_AD_BATC_DEF_DET_ALL	This table contains information about batch default decision details information.
Column Name	Descritpion
DESCRIPTION	Description of the batch
ORG_ID	Multi Org Identifier
ACAD_CAL_TYPE	Academic Calendar Type
ACAD_CI_SEQUENCE_NUMBER	contains information about batch default decision details information.
ADM_CAL_TYPE	Admissions Calendar Type
ADM_CI_SEQUENCE_NUMBER	Admissions Calendar Instance Sequence Number
ADMISSION_CAT	Admission Category
S_ADMISSION_PROCESS_TYPE	System Admission Process Type
DECISION_MAKE_ID	Person Identifier of the person who has made the decision
BATCH_ID	Batch Identifier
DECISION_DATE	Date on which decision is taken
DECISION_REASON_ID	Identifier for the reason to make the decision
PENDING_REASON_ID	Identifier for the reason that the application is pending
OFFER_DT	Date on which the offer is made on the application
OFFER_RESPONSE_DT	Date before which the person has to respond to the offer made
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Student System - IGS_AD_ADMDE_INT_ALL	This table contains application interface records for which decision needs to be imported.
Column Name	Descritpion
INTERFACE_RUN_ID	Identifier of the batch process run for the automatic decision making.
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Concurrent Program Standard Who Column
PROGRAM_APPLICATION_ID	Concurrent Program Standard Who Column
PROGRAM_ID	Concurrent Program Standard Who Column
PROGRAM_UPDATE_DATE	Concurrent Program Standard Who Column
ORG_ID	Multi Org Identifier
RECONSIDER_FLAG	Reconsideration flag indicating whether the Application instance has to be reconsider or not.
PRPSD_COMMENCEMENT_DATE	Proposed Commencement Date
BATCH_ID	Batch Process Identifier
ERROR_TEXT	Holds the Error message text
PERSON_ID	Person Identifier
ADMISSION_APPL_NUMBER	Admission Application Number
NOMINATED_COURSE_CD	Program Code for which the person has applied
SEQUENCE_NUMBER	Sequence Number of the application instance
ADM_OUTCOME_STATUS	Outcome Status of the Admission Application
DECISION_MAKE_ID	Person Identifier of the person who has made the decision on the application
INTERFACE_MKDES_ID	Unique Identifier of the application instance interface record
DECISION_DATE	Date on which the admission decision is taken
DECISION_REASON_ID	Identifier of the reason to make such a decision
PENDING_REASON_ID	Identifier of the reason that the application is pending
OFFER_DT	Date on which the offer is made on the application
OFFER_RESPONSE_DT	Date the person to respond on the offer made
STATUS	Status of the Record.
ERROR_CODE	Error Code of the record.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column

Student System - IGS_AD_ACAD_IDX_INT_ALL	This table contains information about the admission interface academic index.
Column Name	Descritpion
ACADINDEX_ID	Sequence generated unique number for every record
ERROR_CODE	Error Code for the interface Record
ORG_ID	Operating Unit Identifier
CREATED_BY	Standard WHO Columns
CREATION_DATE	Standard WHO Columns
LAST_UPDATED_BY	Standard WHO Columns
LAST_UPDATE_DATE	Standard WHO Columns
LAST_UPDATE_LOGIN	Standard WHO Columns
ERROR_TEXT	Error Text
ACADINDEX_BATCH_ID	Batch identifier for this record
PERSON_ID	Person identifier or party identifier
ADMISSION_APPL_NUMBER	Application number for admission
NOMINATED_COURSE_CD	Program code specified in the application
SEQUENCE_NUMBER	Sequence Number for Application
CALCULATION_DATE	Calculation Date
ADMISSION_INDEX	Admission Index for the application
RECORD_STATUS	Status of the Record.

Student System - IGS_AD_ACIDX_HDR_ALL	This table contains information about the admission interface academic index header.
Column Name	Descritpion
ACADINDEX_BATCH_ID	Unique number for a batch processed by user sequence generated to be provided by OSS
DESCRIPTION	Description of the batch.
ORG_ID	Operating Unit Identifier
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_AD_APCTR_RU_ALL	Captures admission process category tracking rules
Column Name	Descritpion
APC_TRK_RU_ID	System generated number to uniquely identify the Admission Process Category Tracking rules
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ADMISSION_CAT	Admission Category
S_ADMISSION_PROCESS_TYPE	System defined Admission Process Type
S_RULE_CALL_CD	The rule call code to the rules engine which is holding the rule defined
RUL_SEQUENCE_NUMBER	Rule Sequence Number to identify the rule set up
ORG_ID	The organization identifier
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_AD_APL_INT	Interface table which holds the Application Details for the Person
Column Name	Descritpion
INTERFACE_ID	Interface Identifier
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
APPL_DT	Application Date
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
CHOICE_NUMBER	Choice number
ROUTEB_PREF	Route B preference
ADMISSION_APPLICATION_TYPE	Admission Application Type
ALT_APPL_ID	Alternate Application ID
ADMISSION_CAT	Admission Category
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.
APPL_FEE_AMT	Application fee amount
S_ADMISSION_PROCESS_TYPE	System Admission Process Type
ADMISSION_APPL_NUMBER	Admission Application Number
DUP_ADMISSION_APPL_NUMBER	Duplicate Admission Application Number
ACAD_CAL_TYPE	Academic Calendar Type
ACAD_CI_SEQUENCE_NUMBER	Academic Calendar Instance Sequence Number
INTERFACE_APPL_ID	Interface Application Identifier
ADM_CAL_TYPE	Admission Calendar Type
ADM_CI_SEQUENCE_NUMBER	Admission Calendar Instance Sequence Number
TAC_APPL_IND	TAC Application Indicator
SPCL_GRP_1	Special Group 1
SPCL_GRP_2	Special Group 2
COMMON_APP	Common Application
ERROR_CODE	Error Code for the Record
ERROR_TEXT	Error Text for the Record
MATCH_IND	Match Indicator for the Interface Record
UPDATE_ADM_APPL_NUMBER	Update Admission Application Number

Student System - IGS_AD_APTYP_PESTAT	Application Type Personal Statements
Column Name	Descritpion
PERSL_STAT_TYPE	Personal Statement Type
GROUP_NUMBER	Group Number for Personal Statements
MANDATORY	Mandatory Indicator 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
ADMISSION_APPLICATION_TYPE	Admission Application Type

Student System - IGS_AD_APPL_PERSTAT	This table holds the Admission Application Personal Statement details
Column Name	Descritpion
PERSON_ID	Person Identifier
ADMISSION_APPL_NUMBER	Admission Application Number
PERSL_STAT_TYPE	Personal Statement Type attached to application personal statement
DATE_RECEIVED	Date on which Application Statement was received
CREATED_BY	WHO column
CREATION_DATE	WHO column
LAST_UPDATED_BY	WHO column
LAST_UPDATE_DATE	WHO column
APPL_PERSTAT_ID	Unique Application Personal Statement identifier
LAST_UPDATE_LOGIN	WHO column
REQUEST_ID	Concurrent Program WHO column
PROGRAM_APPLICATION_ID	Concurrent Program WHO column
PROGRAM_ID	Concurrent Program WHO column
PROGRAM_UPDATE_DATE	Concurrent Program WHO column

Student System - IGS_AD_DEPLVL_PRG	Program Deposit Level Details For An Admission Application
Column Name	Descritpion
PROGRAM_CODE	Program Code
VERSION_NUMBER	Version Number
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
ADMISSION_APPLICATION_TYPE	Admission Application Type

Student System - IGS_AD_DEPLVL_PRGTY	Program Type Deposit Level Details For An Admission Application
Column Name	Descritpion
PROGRAM_TYPE	Program 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
ADMISSION_APPLICATION_TYPE	Admission Application Type

Student System - IGS_AD_IMP_BATCH_DET	Import Process Batch Description table
Column Name	Descritpion
BATCH_ID	Batch Identifier
PROGRAM_UPDATE_DATE	Last Update Date of this record by a concurrent program
PROGRAM_ID	Program Identifier of last concurrent program to update this record
BATCH_DESC	Batch Description
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 to update this record
PROGRAM_APPLICATION_ID	Application Identifier of the last concurrent program to update this record

Student System - IGS_AD_FEE_INT	Holds the admission fee details that need to get imported for an application
Column Name	Descritpion
INTERFACE_FEE_ID	A unique identifier to identify each row in this table
STATUS	Status of the interface record
DUP_APP_REQ_ID	Duplicate Application requirement Details id, used when the discrepancy rule is set to Review
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_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_APPL_ID	Interface Application ID
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record
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
APPLICANT_FEE_TYPE_ID	Applicant Fee Type Identifier
APPLICANT_FEE_STATUS_ID	Applicant Fee Status Identifier
FEE_DATE	Fee Date. Should be greater than Application Date
FEE_AMOUNT	Fee Amount. Should be greater than 0
REFERENCE_NUM	Reference Number
MATCH_IND	Match Indicator for the interface record 20 - Match to be reviewed for discrepancy 21 - Match reviewed and to be imported 22 - Match reviewed and do not import 23 - Match Reviewed, no discrepancy and retaining existing values
ERROR_CODE	Error Code

Student System - IGS_AD_APPHIST_INT	Hods the Admission application history details that need to get imported for an application, during legacy import
Column Name	Descritpion
INTERFACE_APPHIST_ID	Unique identifier to identify each row of this table
STATUS	Status of the record
ERROR_CODE	Error 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
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
INTERFACE_APPL_ID	Interface Application ID
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
HIST_START_DT	The effective start date and time of the interface record. Should not be greater than system date
HIST_END_DT	The effective end date and time of the interface record. Should not be greater than system date
ADM_APPL_STATUS	Describes the institution-defined application status of the admission application.
ADM_FEE_STATUS	Describes the institution-defined fee status of the admission application.
APPL_DT	Application Date
TAC_APPL_IND	TAC Application indicator. Should have the value 'Y' or 'N'

Student System - IGS_AD_IMP_STATS	This entity will hold the statistical information about the processing during a run of admisssion import process.
Column Name	Descritpion
INTERFACE_RUN_ID	Admission Import Process instance identifier. This will uniquely identify a particular run for import process.
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
REQUEST_ID	Concurrent Program WHO Column
PROGRAM_APPLICATION_ID	Concurrent Program WHO Column
PROGRAM_ID	Concurrent Program WHO Column
PROGRAM_UPDATE_DATE	Concurrent Program WHO Column
SRC_CAT_CODE	Source Category Code that was included in the particular run and for which the statistical information is being recorded.
ENTITY_NAME	Interface Entity Name for the source category for which the statistical information is being recorded
TOTAL_REC_NUM	Total No of records that were to be processed, ie those were in Status ='2' in this entity for the particular run of import process
TOTAL_WARN_NUM	Total No of records that had warning after the processing, those were in Status ='4' in this entity for the particular run of import process
TOTAL_SUCCESS_NUM	Total No of records that were successfully processed in this entity for the particular run of import process
TOTAL_ERROR_NUM	Total No of records that had errors after the processing, those were in Status ='3' in this entity for the particular run of import process
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_AD_ACADINT_INT	Holds information about person's academic interests
Column Name	Descritpion
INTERFACE_ACADINT_ID	Interface academic interest 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
FIELD_OF_STUDY	Academic field of study
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_APPINT_INT	Holds information about person's applicant intent details
Column Name	Descritpion
INTERFACE_APPINT_ID	Interface applicant intent 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
INTERFACE_APPL_ID	Interface applicant identifier
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
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
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
INTENT_TYPE_ID	Applicant intent type
ATTRIBUTE14	Standard DFF column
ATTRIBUTE15	Standard DFF column
ATTRIBUTE16	Standard DFF column
ATTRIBUTE17	Standard DFF column
ATTRIBUTE18	Standard DFF column
ATTRIBUTE19	Standard DFF column
ATTRIBUTE20	Standard DFF column
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
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.
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_EDUGOAL_INT	Stores interface details for person's educational goals
Column Name	Descritpion
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.
EDU_GOAL_ID	Educational Goal Identifier
STATUS	Educational Goal Status
ERROR_CODE	Error Code
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	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_EDUGOAL_ID	Interface Educational Goal Identifier
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.

Student System - IGS_AD_DFLT_OUDTLS	Default Outcome Decision Details
Column Name	Descritpion
ADM_OUTCOME_STATUS	Admission Outcome status
FUTURE_ADM_CI_SEQUENCE_NUMBER	Future admission calendar sequence number
DECISION_REASON_ID	Decision reason identifier
PENDING_REASON_ID	Pending reason identifier
WAITLIST_STATUS_CODE	Waitlist status
WAITLIST_RANK	Waitlist rank
UCAS_COND_CATEGORY	UCAS Condition category
UCAS_COND_NAME	UCAS Condition name
ADM_CNDTNL_OFFER_STATUS	Admission Conditional Offer Status
CNDTNL_OFFER_SATISFIED_DATE	Conditional Offer satisfied date
CNDNL_OFFER_MST_BE_STSFD_FLAG	Conditional Offer must be satisfied Indicator
CREATED_BY	Standard WHO Column
CNDTNL_OFFER_CNDTN_TXT	Condition for the Offer
ADM_OTCM_STATUS_AUTH_PERSON_ID	Admission outcome status Authorizing person Identifier
ADM_OUTCOME_STATUS_AUTH_DATE	Admission outcome status Authorized Date
ADM_OUTCOME_STATUS_REASON	Admission outcome status reason
DFLT_OFFERDATE_FLAG	Default Sysdate as Offer date
OFFER_DATE	Offer Date
OFFER_RESPONSE_DATE	Offer deadline Date
PRPSD_COMMENCEMENT_DATE	Proposed Commencement Date
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
DFLT_DECISIONDATE_FLAG	Whether system date should be defaulted in for outcome decision date or not
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
RECONSIDER_FLAG	Request for Reconsideration flag
DECISION_MAKER_ID	Decision maker identifier
DECISION_DATE	Decision Date
FUTURE_ACAD_CAL_TYPE	Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUMBER	Future academic calendar sequence number
FUTURE_ADM_CAL_TYPE	Future admission calendar type

Student System - IGS_AD_ACT_STATISTICS	ACT Statistical Test Components with statistic type and category details
Column Name	Descritpion
REPORTING_YEAR	Reporting year
NUMERIC_GRADE	Numeric Grade
STANDARD_SCORE	Standard score
PERCENTILE_RANK	Percentile rank
COURSE_STATUS	Course status
GRADE_EARNED	Grade earned
GRADE_POINT_AVERAGE	Grade point average
PROBABILITY	Probability
DESCRIPTION	Description
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
ACT_IDENTIFIER	Act ID
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
TEST_TYPE	Test type
TEST_DATE_TXT	Test date
STATISTIC_TYPE	Statistic type
STATISTIC_CATEGORY	Statistic category
SCORE	Score
NATIONAL_NORM	National norm
LOCAL_NORM	Local norm

Student System - IGS_AD_ACT_ASSESSMENTS	ACT assessment details of persons with Reporting Year, Test Date and Test Type
Column Name	Descritpion
REPORTING_YEAR	Reporting year
GENDER	Gender
DATE_OF_BIRTH_TXT	Date of birth
STREET_ADDRESS	Street address
CITY	City
STATE_CODE	State code
STATE_ABBREVIATION	State abbreviation
ZIP_CODE	Zip code
HOME_PHONE	Home phone number
GRADE_LEVEL	Grade level
HIGH_SCHOOL_CODE	High school code
ACT_IDENTIFIER	ACT ID
HIGH_SCHOOL_AVERAGE	High school average
HIGH_SCHOOL_GRADUATION	High school graduation
CORRECTED_REPORT_IND	Corrected report indicator
SUM_OF_SCALE_SCORES	Sum of scale scores
COLLEGE_CHOICE	College choice
COLLEGE_CODE	College code
LOCAL_IDENTIFIER	Local ID
RELEASE	Release
NORMS_TYPE	Norms type
CREATED_BY	Standard Who Column
TEST_TYPE	Test type
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_TXT	Test date
ACT_BATCH_ID	ACT Assessment Batch Identifier
INTERFACE_TRANSFER_DATE	Interface Transfer Date
LAST_NAME	Last Name
FIRST_NAME	First Name
MIDDLE_INITIAL	Middle initial

Student System - IGS_AD_ACT_PROFILES	ACT profile components with profile type and corresponding category details
Column Name	Descritpion
REPORTING_YEAR	Reporting Year
CODE4	Code 4
CODE5	Code 5
CODE6	Code 6
CODE7	Code 7
CODE8	Code 8
CODE9	Code 9
CODE10	Code 10
CODE11	Code 11
CODE12	Code 12
CODE13	Code 13
ACT_IDENTIFIER	ACT ID
CODE14	Code 14
CODE15	Code 15
CODE16	Code 16
CODE17	Code 17
CODE18	Code 18
CODE19	Code 19
CODE20	Code 20
CODE21	Code 21
EDUC_MAJOR	Education Major
VOC_CHOICE1	Vocabulary Choice 1
TEST_TYPE	Test Type
VOC_CHOICE2	Vocabulary Choice 2
CHOICE1	Choice 1
CHOICE2	Choice 2
CHOICE3	Choice 3
CHOICE4	Choice 4
CHOICE5	Choice 5
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
TEST_DATE_TXT	Test Date
LAST_UPDATE_LOGIN	Standard Who Column
PROFILE_TYPE	Profile Type
PROFILE_CATEGORY	Profile Category
CODE1	Code 1
CODE2	Code 2
CODE3	Code 3

Student System - IGS_AD_CRT_APPL_CFG	Stores the "Create application Page" configuration details
Column Name	Descritpion
RESPONSIBILITY	Responsibility
LAST_UPDATE_LOGIN	Standard WHO Column
COMPONENT_CODE	Code of the component
DISPLAY_NAME	Name which would be displayed in SS for the component
INCLUDED_FLAG	Included flag
REQUIRED_FLAG	Required flag
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_APPQUAL_CODE	New Transaction table to hold the qualification type and its value for each application instance
Column Name	Descritpion
PERSON_ID	Person ID
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 Course code
SEQUENCE_NUMBER	Sequence Number
QUALIFYING_TYPE_CODE	The qualifying type defined for the APC
QUALIFYING_CODE_ID	The qualifying code id. This can be the default value for the admission code class or entered via the customized workflow or manually from the LOV
QUALIFYING_VALUE	Free enterable text for Qualifying Type
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Student System - IGP_AC_ACCOUNTS	Table to store the portfolio account information
Column Name	Descritpion
PARTY_ID	Unique identifier of the person holding the account.
USER_ID	User ID of the FND_USER created for portfolio account
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
OBJECT_VERSION_NUMBER	Object version number
ACCOUNT_ID	Account ID, Sequence generated ID

Student System - IGP_AC_ACCOUNT_INTS	Table to store the staging information on portfolio account.
Column Name	Descritpion
INT_ACCOUNT_ID	Account Id, Sequence generated.
PARTY_ID	Unique identifier of the person holding the account.
ACC_CLASSIFICATION_CODE	Stores the classification code of the account, e.g. Faculty, Staff, Student or External.
ACCESS_EXPIRATION_DATE	Stores the expiration date of the account.
USER_ID	User id of the fnd_user associated with the party
USER_NAME	User Name of the fnd_user associated with the party
CREATED_BY	Standard WHO Column
ITEM_KEY	Item key of the workflow process submitted for the approval of the account creation request.
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 - IGP_AC_ACC_CLASSES	Table to store the account classification codes for a account
Column Name	Descritpion
ACCOUNT_ID	ID of the account.
ACC_CLASSIFICATION_CODE	Stores the classification code of the account, e.g. Faculty, Staff, Student or External.
ACCESS_EXPIRATION_DATE	Stores the expiration date of the account.
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
ACC_CLASSIFICATION_ID	Sequence generated primary key.
OBJECT_VERSION_NUMBER	To store the object version number

Student System - IGP_AS_RESP_MAPPINGS	Table to store the setup data for mapping between account classification and responsibility
Column Name	Descritpion
TAG	Stores the value of the Tab from which the record was created. Because we are not having the application id to segregate between the portfolio responsibility and OSS responsibility , so this value will help us to show the record in the same
RESPONSIBILITY_ID	Stores the responsibility id of the Portfolio Responsibility to which the mapping is being done
ACC_CLASSIFICATION_CODE	Stores the account classification against which the responsibility is being mapped
ENABLE_FLAG	Mapping is enabled or not
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
MAPPING_ID	Stores the sequence generated Mapping ID.
LAST_UPDATE_LOGIN	Standard WHO Column
OBJECT_VERSION_NUMBER	To store the object version number

Student System - IGP_US_ARTIFACTS	Table to store the Artifacts details
Column Name	Descritpion
ARTIFACT_NAME	Artifact Name
ARTIFACT_TYPE	Type of the artifact file e.g. application/msword, image/pjpeg
FILE_SIZE	File size of the artifact
ACCOUNT_ID	Account id indicating the author of the artifact
ARTIFACT_CONTENT	Content of the artifact
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
ARTIFACT_ID	Sequence generated Primary Key
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_US_NON_REG_VIEWERS	Stores the non-registered viewers who have portfolio assignments.
Column Name	Descritpion
PORTFOLIO_ID	Portfolio Id for which the grant is given
FIRST_NAME	First Name of the Non Registered User
LAST_NAME	Last Name of the Non Registered user
EMAIL_ADDRESS	Email Address of the Non Registered user
START_DATE	Start Date from which the access will be granted. Presently we are not taking this as a input from the user, we are defaulting it to the sysdate.
END_DATE	End Date till when the access should be valid.
PIN_CODE	Pin code on the bases of which the user will access the particular portfolio.
CREATED_BY	Standard Who column
NONREG_VIEWER_ID	Sequence generated Primary key
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_US_PAGES	Table to store the Portfolio Pages
Column Name	Descritpion
PORTFOLIO_ID	Portfolio Id to which the page will belong
PAGE_NAME	Name of the page
PAGE_TITLE	Title of the page.
PRIMARY_FLAG	Flag to indicate whether the page is the primary page in the portfolio
PAGE_CONTENT	Contents of the page
EXTERNAL_FLAG	Flag to indicate whether the page was created by the wizard or is a external uploaded page.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
PAGE_ID	Sequence generated Primary Key
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_US_PORTFOLIOS	Table to Store the details of the Portfolios
Column Name	Descritpion
ACCOUNT_ID	Account Id, indicating the author of the Portfolio
PORTFOLIO_NAME	Name of the Portfolio
PORTFOLIO_TYPE_CODE	Type of the Portfolio.
PUB_START_DATE	Portfolio publish start date
PUB_END_DATE	Portfolio publish end date
DESCRIPTION	Portfolio description
PUB_CAREER_SERVICES_FLAG	To indicate whether portfolio is published to career services or not.
ASSIGNED_FLAG	To indicate that whether the portfolio is assigned to any viewer or not irrespective of whether the assignment is done directly or through a career center person.
PORTFOLIO_ID	Sequence generated Primary Key
PURPOSE	Purpose of the portfolio to store the keywords
CAREER_OBJECTIVE	Career objective of the portfolio.
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
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_VW_PORT_ACTIVITIES	Table to store the Portfolio Activities
Column Name	Descritpion
PORTFOLIO_ID	Portfolio Id on which the comment is given
PARTY_ID	Unique identifier of the Viewer, who did the activity
PINCODE	This represents the NON-REGISTERED viewer
ORG_PARTY_ID	If the viewer is a registered viewer then this column represent that in respect of which organization viewer is giving the comment
ACCESS_DATE	Stores the date and time when the comment was given on a portfolio
ACCESS_TYPE_CODE	Identifier indicating the Activity done by the Viewer was a Public Activity or Assigned Activity. Public Activity is an activity when a Registered Viewer views a Portfolio not assigned to him/her. Valid values will be from lookup type IGP_V
NOTE	Actual comment given by the viewer
CREATED_BY	Standard Who column
ACTIVITY_ID	Sequence generated Primary Key
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_US_PUB_ARTIFACTS	Table to store the public Artifacts details
Column Name	Descritpion
ARTIFACT_NAME	Artifact Name
ARTIFACT_TYPE	Type of the artifact file e.g. application/msword, image/pjpeg
FILE_SIZE	File size of the artifact. [This column will not be used now, however in future we will be using it]
ACCOUNT_ID	Account id indicating the author of the artifact
ARTIFACT_CONTENT	Content of the artifact
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
ARTIFACT_ID	Sequence generated Primary Key
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_US_REG_VIEWERS	Stores the registered viewers who have portfolio assignments.
Column Name	Descritpion
PORTFOLIO_ID	Portfolio id for which the viewer is given access
PARTY_ID	Party id of the person to whom the access is given
ORG_PARTY_ID	Organization Party Id, if the person is a contact of any organization and access was given in respect to that organization
START_DATE	Start Date from when the access should be granted. Presently we are not taking any user input for this column. However, we are defaulting it to the sysdate.This is done just to absorb the future impact incase we plan to control start date a
END_DATE	End Date till when the access should be valid.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
REG_VIEWER_ID	Sequence generated primary key
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_VERSION_NUMBER	Standard Who column

Student System - IGP_WZ_TEMPLATES	Table to store the details of Templates.
Column Name	Descritpion
TEMPLATE_NAME	Name of the Template. This is unique irrespective of Case. E.g. Introduction.html and INTRODUCTION.html will be considered as same name.
TEMPLATE_STATUS_CODE	Status of the Template. This is validated with the lookup type IGP_WZ_TEMP_STATUS, Valid values are PUBLISH, DRAFT, PENDING
TEMPLATE_TITLE	Title of the Template
DESCRIPTION	Description of the Template
TEMPLATE_CONTENT	Contents of the Template, this will be XML contents.
TEMPLATE_TYPE_CODE	Type of the Template. This is validated with the lookup type IGP_WZ_TEMP_TYPE, Valid value is PRESENTATION
EXTERNAL_FLAG	Flag indicating that whether the template was created using the Wizard or it is uploaded.
EXPIRY_DATE	Expiry Date of the Template
TEMPLATE_ID	Sequence generated Primary Key
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
OBJECT_VERSION_NUMBER	Standard Who column

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

Student System - IGR_I_PKGITM_ASSIGN	This table holds the assignment of package item to academic interest product categories
Column Name	Descritpion
PKG_ITEM_ASSIGN_ID	Sequence generated Primary Key
LAST_UPDATE_LOGIN	Standard WHO Column
PRODUCT_CATEGORY_ID	Product Category ID mapping to Category ID of mtl_categories_b table.
PRODUCT_CATEGORY_SET_ID	The product catalog ID under which the OSS Academic Interest category is defined
PACKAGE_ITEM_ID	Package Item ID mapping to igr_I_pkg_item table
ENABLED_FLAG	Enabled Flag
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Student System - IGR_EPU_CATEGORY_UPG	This is a temporary table used for storing data for migration of Entry Status/ Program Code and Unit Sets into Product Category
Column Name	Descritpion
ENTRY_STATUS_ID	Entry Status ID
PROGRAM_CODE_ID	Program Code ID
UNIT_SET_ID	Unit Set ID
PRODUCT_CATEGORY_ID	Product Category ID
PRODUCT_CATEGORY_SET_ID	Product Category Set ID

Student System - IGR_I_INQUIRY_TYPES	Stores the Inquiry Type setup information
Column Name	Descritpion
INQUIRY_TYPE_ID	Sequence generated primary key
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
INQUIRY_TYPE_CD	Inquiry Type Code
INQUIRY_TYPE_DESC	Inquiry Type Description
ENABLED_FLAG	Enabled Flag
IMP_SOURCE_TYPE_ID	Import Source Type
INFO_TYPE_ID	Inquiry Information Type
CONFIGURABILITY_FUNC_NAME	Configurability Function Name
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column

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