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

Student System - IGS_PE_ALTERNATV_EXT	This entity describes the possible alternative exit points from a course. This consists of another course, often of a lower level (where an early exit is granted).
Column Name	Descritpion
COURSE_CD	Unique identifier for the program of study
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Unique identifier for the version of the program
EXIT_COURSE_CD	The unique code of the program that is an approved alternative exit.
EXIT_VERSION_SET	The valid version numbers of the alternative exit program. This information is used by the progression subsystem.

Student System - IGS_PE_ALT_PERS_ID	This entity describes the other ids by which a person is known. eg. OLAA id, VTAC id, old id.
Column Name	Descritpion
START_DT	Indicates the start of the period for that the alternate person ID record applies
ATTRIBUTE13	Attribute of Descriptive Flex Field
ATTRIBUTE14	Attribute of Descriptive Flex Field
END_DT	A date which indicates the end of the period for which the Alternate Person ID record applies.
ATTRIBUTE15	Attribute of Descriptive Flex Field
ATTRIBUTE16	Attribute of Descriptive Flex Field
ATTRIBUTE17	Attribute of Descriptive Flex Field
ATTRIBUTE18	Attribute of Descriptive Flex Field
ATTRIBUTE19	Attribute of Descriptive Flex Field
ATTRIBUTE20	Attribute of Descriptive Flex Field
API_PERSON_ID_UF	Stored the unformatted Alternate Person ID
REGION_CD	Optional Region 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	Request Idnetifier of the last concurrent program to update this record
PROGRAM_APPLICATION_ID	Program Application Identifier of the last concurrent program to update this record
PROGRAM_ID	Program Identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of the concurrent program
ATTRIBUTE_CATEGORY	Attribute Category of Descriptive Flex Field
ATTRIBUTE1	Attribute of Descriptive Flex Field
ATTRIBUTE2	Attribute of Descriptive Flex Field
ATTRIBUTE3	Attribute of Descriptive Flex Field
ATTRIBUTE4	Attribute of Descriptive Flex Field
ATTRIBUTE5	Attribute of Descriptive Flex Field
ATTRIBUTE6	Attribute of Descriptive Flex Field
PE_PERSON_ID	Describes the ID that uniquely identifies a person
ATTRIBUTE7	Attribute of Descriptive Flex Field
ATTRIBUTE8	Attribute of Descriptive Flex Field
API_PERSON_ID	Another identification number by that the person is recognized by other systems or organizations
ATTRIBUTE9	Attribute of Descriptive Flex Field
ATTRIBUTE10	Attribute of Descriptive Flex Field
PERSON_ID_TYPE	Identifies the system or organization to that the alternate person ID belongs
ATTRIBUTE11	Attribute of Descriptive Flex Field
ATTRIBUTE12	Attribute of Descriptive Flex Field

Student System - IGS_PE_CODE_CLASSES	This entity describes the various code classes.
Column Name	Descritpion
CODE_CLASSES_ID	Unique identifier of each code class
LAST_UPDATE_LOGIN	Standard Who column
CLASS	Describes the class for that the codes are getting added
CODE	Code that is added for a class
DESCRIPTION	Description of the code
CLOSED_IND	Closed indicator that describes whether code is active 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_PE_COUNTRY_CD	This entity describes the available list of user-defined country codes.
Column Name	Descritpion
COUNTRY_CD	Identifies the institution-defined code for a country
GOVT_COUNTRY_CD	Defined in the set of Government country codes. See Appendix C Higher Education Student Data Collection Documentation 1997, DETYA.
NOTES	A text-based facility for entering and maintaining notes of up to 2,000 characters regarding the country code.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
DESCRIPTION	Describes the institution-defined code that identifies a country DETYA element reference 346
LAST_UPDATE_LOGIN	Standard Who column
CLOSED_IND	Describes whether the country code is open or closed

Student System - IGS_PE_COUNTY_CD	This entity describes the available list of user-defined country
Column Name	Descritpion
COUNTY_CD	User defined county code
DESCRIPTION	Description of the county code
CLOSED_IND	Indicates whether the county code is close or open
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_PE_COURSE_EXCL	This entity defines a course which a student has been excluded from. e.g. block admission to a course for an applicant.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	ID of the person who is the subject of the hold
ENCUMBRANCE_TYPE	The institution-defined hold type that has been applied to a person. An hold type incorporates one or more system-defined hold effect types.
PEN_START_DT	The date that the student's hold type became effective.
S_ENCMB_EFFECT_TYPE	The system hold effect that is placed on a person or one of their program as part of a hold.
PEE_START_DT	Date that the system effect associated with an hold became effective
PEE_SEQUENCE_NUMBER	A unique number for referencing person hold effects
COURSE_CD	The code of the program from that the person is excluded from admission and enrollment.
PCE_START_DT	Date that the student's program exclusion became effective
CREATED_BY	Standard Who column
EXPIRY_DT	Date that the student's program exclusion expired. If no date is entered, the exclusion remains current.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_CRS_GRP_EXCL	This entity describes a course group from which a person has been excluded.
Column Name	Descritpion
PERSON_ID	ID of the person who is the subject of the hold
LAST_UPDATE_LOGIN	Standard Who column
ENCUMBRANCE_TYPE	The institution-defined hold type that has been applied to a person. A hold type incorporates one or more system-defined hold effect types.
PEN_START_DT	Date that the student's hold type became effective.
S_ENCMB_EFFECT_TYPE	Describes the effect that is placed on a person or one of their programs as part of a hold
PEE_START_DT	Date that the system effect associated with an hold became effective
PEE_SEQUENCE_NUMBER	A unique number for referencing person hold effects
COURSE_GROUP_CD	Code of the program group that the person is excluded from admission and enrollment. Application of a program group exclusion prevents the student from gaining admission or enrollment in any of the program that are members of the program gr
PCGE_START_DT	Date that the student's program group exclusion became effective
EXPIRY_DT	Date that the student's program group exclusion expired. If no date is entered, the exclusion remains current.
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_PE_DATA_ELEMENT	This entity describes the data elements which will be set as Mandatory/Preferred for each person types.
Column Name	Descritpion
DATA_ELEMENT	User data element
TABLE_NAME	Table name the data element belongs to
COLUMN_NAME	The column name corresponding to the data element in the table
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PE_GOVCITIZEN_CD	This entity describes the allowable DEET citizenship values. This is recorded for each student in the person statistics entity. eg. 1 - Australian Citizen, 2 - New Zealand Citizen, etc.
Column Name	Descritpion
GOVT_CITIZENSHIP_CD	A unique government code indicating a student's citizenship and residency status, DETYA Higher Education Student Data Collection 1997, Element No. 358.
DESCRIPTION	Describes a Government code indicating a student's citizenship and residency status, DETYA Higher Education Student Data Collection 1997, Element No. 358.
CLOSED_IND	Specifies if the Government Citizenship code is open or closed. Selecting the checkbox to closed prevents use of the Government Citizenship code in new or modified institution-defined Citizenship code 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_PE_GOV_ABRGRESCD	This entity describes the available values for the DEET aboriginal and torres strait islander question. eg. 1 - Aboriginal or Torres Strait Islander descent, 2 - Not Aboriginal or Torres Strait slander descent, 9 - No information.
Column Name	Descritpion
GOVT_ABORIG_TORRES_CD	Describes whether or not the student identifies herself or himself as being of Australian Aboriginal or Torres Strait Islander descent. See Element 316 Higher Education Student Data CollectionDocumentation 1997, DETYA.
DESCRIPTION	Description of the code that describes whether or not the student identifies herself or himself as being of Australian Aboriginal or Torres Strait Islander descent. See Element 316 Higher Education Student Data Collection Documentation 1997
CLOSED_IND	An indicator which specifies whether the Government ATSI code is open or closed. Setting the checkbox to closed prevents the Government code from being mapped to institution defined ATSI codes.
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_PE_GOV_COUNTRYCD	This entity describes the DEET set of country codes e.g. 0011 Albania, 0208 Zambia.
Column Name	Descritpion
GOVT_COUNTRY_CD	A code defined in the set of Government country codes. See Appendix C Higher Education Student Data Collection Documentation 1997, DETYA.
DESCRIPTION	The name of a country coded in Appendix C of the Higher Education Student Data Collection Documentation 1997, DETYA.
CLOSED_IND	Specifies whether the Government country code is open or closed. Setting the checkbox to closed prevents the Government code from being mapped to institution-defined country codes.
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_PE_GOV_LANG_CD	This entity describes the available set of DEET language codes. eg. 02 - Afghani, 21 - Fijian.
Column Name	Descritpion
GOVT_LANGUAGE_CD	Describes the use of a language other than English at the student's permanent home residence. DETYA element no. 348.
DESCRIPTION	Provides an explanation of the DETYA language code
CLOSED_IND	Specifies if the Government language code is open or closed. Selecting the checkbox to closed prevents use of the Government language code in new or modified institution-defined language code 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_PE_GOV_PER_RESCD	This entity describes the government permanent residence codes
Column Name	Descritpion
GOVT_PERM_RESIDENT_CD	A unique Government code indicating a student's permanent residency status, DETYA Higher Education Student Data Collection 1997, Element No. 390.
DESCRIPTION	Describes the code which identifies the permanent residency status of a student, DETYA Higher Education Student Data Collection 1997,Element No. 390.
CLOSED_IND	Specifies if the Government permanent residence code is open or closed. Selecting the checkbox to 'closed' prevents use of the Government Permanent Residence code in new or modified institution-defined permanent residence code 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_PE_LANGUAGE_CD	This entity describes the available list of user-defined language codes.
Column Name	Descritpion
LANGUAGE_CD	An institution-defined language code. Language codes are used for languages other than English when entering student statistical details. Each language code must map to one of the set ofGovernment-defined language codes. See Appendix F Hi
GOVT_LANGUAGE_CD	A Government language code to that the institution-defined language code is mapped.
NOTES	A text-based facility for entering additional details or comments about the language code. Up to 2000 characters are allowed.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
DESCRIPTION	A description of the language code. Language codes are used for languages other than English when recording student statistical details. Each language code must map to one of the set ofGovernment-defined language codes. See Appendix F High
LAST_UPDATE_LOGIN	Standard Who column
CLOSED_IND	Specifies whether the language code is open or closed. If closed, the code cannot be linked to any further person statistics records.

Student System - IGS_PE_NOTE_TYPE	This entity describes the types of notes which can be recorded against a person.
Column Name	Descritpion
PE_NOTE_TYPE	An institution-defined note type pertaining to a student. For example, academic, admin, and discipline.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description of an institution-defined note type, for example, academic - academic record notation
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PE_OTHER_REL_TPS
Column Name	Descritpion
RELATIONSHIP_TYPE
OTHER_RELATIONSHIP_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Student System - IGS_PE_PERM_RES_CD	This entity describes the permanent residence code
Column Name	Descritpion
PERM_RESIDENT_CD	A unique institution-defined permanent resident status code. The code must map to one of the Government-defined permanent resident status codes defined in DETYA element no. 390.
GOVT_PERM_RESIDENT_CD	A unique Government code indicating a student's permanent residency status, DETYA Higher Education Student Data Collection 1997, Element No. 390.
NOTES	A facility for recording text-based comments about a permanent resident code, of up to 2,000 characters.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
DESCRIPTION	Describes an institution-defined permanent resident status code. The code must map to one of the Government-defined permanent resident status codes defined in DETYA element no. 390.
LAST_UPDATE_LOGIN	Standard Who column
CLOSED_IND	Specifies if the permanent residence code is open or closed. Selecting the checkbox to 'closed' prevents use of the permanent residence code in new or modified person statistics records.

Student System - IGS_PE_PERSENC_EFFCT	This entity describes the effects which are imposed on a person (or one or their courses) as part on an encumbrance. eg. course exclusion, suppression of transcript.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	The identification number of the person who has had one or more hold effects imposed upon them.
ENCUMBRANCE_TYPE	Code of an institution-defined hold type incorporating one or more system hold effect types
PEN_START_DT	Describes the date the hold on a person becomes effective
S_ENCMB_EFFECT_TYPE	System-defined hold effect applied to a person or one of their programs as part of a hold
PEE_START_DT	Date a system hold effect type applied as a default effect becomes effective for a person
SEQUENCE_NUMBER	Describes a unique number for referencing person hold effect
EXPIRY_DT	Date a system hold effect type applied to a person expires. If no date is entered, the exclusion remains current.
COURSE_CD	The student's program code that is the subject of a system hold effect type applied as a result of an institution defined hold type
RESTRICTED_ENROLMENT_CP	The minimum or maximum number of credit points the student's enrollment is restricted to as a result of the application of a hold effect. The restriction operates as a warning which is displayed if the student's enrollment would breach the
CREATED_BY	Standard Who column
RESTRICTED_ATTENDANCE_TYPE	The attendance type a student is restricted to in a particular program as a result of a hold effect. The restriction operates as a warning that is displayed if the student's enrollment would breach the nominated attendance type.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_PERSON_ALIAS	This entity describes aliases by which a person may be known.
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	A unique identification number, incorporating a check digit, used to identify a particular person.
SEQUENCE_NUMBER	Uniquely identifies a person alias
ALIAS_TYPE	Type of alias
START_DT	Date from that the person alias applies
END_DT	Date that the person alias ceases to be effective
SURNAME	Alias or former surname of the person
GIVEN_NAMES	Alias or former given names of the person
TITLE	Alias or former title of the person
ALIAS_COMMENT	A text-based facility for entering additional information or details about the person alias, for example, name changed by Deedpoll.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PE_PERSON_ID_TYP	This entity describes the type of person ids which may be attributed to a person. eg. OLAA id, VTAC id, old id.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID_TYPE	Describes the type of person IDs that may be assigned to a person. For example, OLAA ID, VTAC ID.
DESCRIPTION	Provides an explanation of the person ID Type
S_PERSON_ID_TYPE	System-defined person ID type, for example, Staff, Vtac, Qtac.
INSTITUTION_CD	Shows the code that uniquely identifies the institution associated with this person ID type
PREFERRED_IND	Flag indicates whether this person ID type is preferred or not
CREATED_BY	Standard Who column
UNIQUE_IND	Flag indicates the person ID type is unique or not
FORMAT_MASK	Format Mask
REGION_IND	Region code indicator
CLOSED_IND	Closed Indicator
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_PERSON_IMAGE	Contains a persons image
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	A unique student information system identification number, typically incorporating a check digit, used to identify a particular person..
IMAGE_DT	This field is the date on which the image was captured.
PERSON_IMAGE	No Longer Used
PERSON_IMAGE_LOB	Content of the Image, which is a binary LOB
CREATED_BY	Standard Who column
IMAGE_CONTENT_TYPE	Content type as specified during the uploading process. This string is an unparsed entity-header for the entity "Content-Type", and specifies the content type, and any additional parameters (such as character set) that describe the stored c
IMAGE_FILE_NAME	Name for the file as provided during the uploading process
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_PERSON_TYPES	Captures the different person types. This table is modified to capture the enrollment method type related to self service.
Column Name	Descritpion
PERSON_TYPE_CODE	Unique Code for a Person Type.
DESCRIPTION	Description of a Person Type.
SYSTEM_TYPE	The System Type associated with a Person Type.
CLOSED_IND	An Indicator which indicates if the Person Type is closed for further usage.
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
RANK	Indicates what is the rank of the person type associated with self service enrollment staff users.

Student System - IGS_PE_PERS_DISABLTY	Describes the disabilities that a person has, as well as details pertaining to special requirements for the person.
Column Name	Descritpion
DISABILITY_TYPE	Used to enter special needs for the person whose record is displayed. Special need types are institution-defined values.
ATTRIBUTE4	Standard attribute column used in Flexfields
ATTRIBUTE5	Standard attribute column used in Flexfields
ATTRIBUTE6	Standard attribute column used in Flexfields
ATTRIBUTE7	Standard attribute column used in Flexfields
ATTRIBUTE8	Standard attribute column used in Flexfields
ATTRIBUTE9	Standard attribute column used in Flexfields
ATTRIBUTE10	Standard attribute column used in Flexfields
ATTRIBUTE11	Standard attribute column used in Flexfields
ATTRIBUTE12	Standard attribute column used in Flexfields
ATTRIBUTE13	Standard attribute column used in Flexfields
CONTACT_IND	The contact indicator shows whether the student wishes to be contacted by the University's Disabilities Resources office(Obsolete).
ATTRIBUTE14	Standard attribute column used in Flexfields
ATTRIBUTE15	Standard attribute column used in Flexfields
ATTRIBUTE16	Standard attribute column used in Flexfields
ATTRIBUTE17	Standard attribute column used in Flexfields
ATTRIBUTE18	Standard attribute column used in Flexfields
ATTRIBUTE19	Standard attribute column used in Flexfields
ATTRIBUTE20	Standard attribute column used in Flexfields
SPECIAL_ALLOW_CD	Special allowed code.
SUPPORT_LEVEL_CD	Support level code.
SPECIAL_ALLOW_ID	OBSOLETED. Gives the unique identifier for the special allowance availed by the person
SUPPORT_LEVEL_ID	OBSOLETED. Identifies the support level availed by the person
DOCUMENTED	An indicator that indicates if the special need is documented or not(Obsolete)
SPECIAL_SERVICE_ID	OBSOLETED. An identifier that uniquely identifies the special service availed by the disabled person
IGS_PE_PERS_DISABLTY_ID	Unique Identifier, PK
ELIG_EARLY_REG_IND	Eligible for Early Registration Indicator(Y/N)
PERSON_ID	Describes the identifier that uniquely identifies a person
START_DATE	Start date
END_DATE	End Date
INFO_SOURCE	Source of Information, Free format text
INTERVIEWER_ID	PID of Interviewer
INTERVIEWER_DATE	Date of Interview
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	The attribute category field is used for Flexfields.
ATTRIBUTE1	Standard attribute column used in Flexfields
ATTRIBUTE2	Standard attribute column used in Flexfields
ATTRIBUTE3	Standard attribute column used in Flexfields

Student System - IGS_PE_PERS_ENCUMB	This entity describes the encumbrances placed on an applicant/student e.g. overdue parking fines, unpaid fees, failure to return library books.
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
SEQUENCE_NUMBER	Hold Academic Calendar Type - Seq Number
AUTH_RESP_ID	Authorizer Responsibility Identifier
EXTERNAL_REFERENCE	When ever external system applies a hold onto the student using Business Events, this field is the placeholder for the system, like PARKING, LIBRARY, CANTEEN etc.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Identification number of the person who has had the hold placed upon him
CREATED_BY	Standard Who column
ENCUMBRANCE_TYPE	Institution-defined hold type incorporating one or more system hold effect types
START_DT	Date a hold becomes effective for a person
EXPIRY_DT	Date a hold expires for a person. Expiring a hold type automatically expires the default effects.If no date is entered, the hold remains current.
AUTHORISING_PERSON_ID	The identification number of the staff member who authorized application of the hold.
COMMENTS	A text facility for entering any additional information or details about the person's hold.
SPO_COURSE_CD	Program Code
CREATION_DATE	Standard Who column
SPO_SEQUENCE_NUMBER	Sequence Number
CAL_TYPE	Hold Academic Calendar Type

Student System - IGS_PE_PERS_NOTE	This entity describes a note held against a person.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Unique identification number, incorporating a check digit, used to identify a particular student
REFERENCE_NUMBER	A system assigned number used to uniquely identify a particular note.
PE_NOTE_TYPE	An institution-defined note type pertaining to a student. For example, academic, admin, and discipline.
START_DATE	Start Date
CREATED_BY	Standard Who column
END_DATE	End Date
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_PERS_RELATION	This entity describes the relationship between two people recorded on the system. This relationship is of the nominated type.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Describes the ID that uniquely identifies a person
PERSON_ID_ALSO_RELATED_TO	Describes the ID that uniquely identifies a person that is related to another person
PERSON_RELATION_TYPE	Describes the type of relationships that can exist between people. For example, brother, mother and others.
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_PE_PERS_RELN_TYP	This entity describes the type of relationships which people can have recorded on the system. For example, brother, father.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_RELATION_TYPE	Describes the type of relationships that can exist between people. For example, sister, father, and others.
DESCRIPTION	Provides an explanation of the person relation type
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_PE_PERS_UNT_EXCL	This entity describes a unit which a student has been excluded from.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Identification number of the person who is the subject of the hold
ENCUMBRANCE_TYPE	The institution-defined hold type that has been applied to a person. A hold type incorporates one or more system-defined hold effect types.
PEN_START_DT	Describes the date a hold on a person becomes effective
S_ENCMB_EFFECT_TYPE	Describes the effect that is placed on a person or one of their programs as part of a hold
PEE_START_DT	Describes the date the effect of a hold on a person becomes effective
PEE_SEQUENCE_NUMBER	Describes a unique number for referencing person hold effect
UNIT_CD	Code used to identify the unit that is the subject of the unit exclusion
PUE_START_DT	Describes the date that a students exclusion from a unit is effective
CREATED_BY	Standard Who column
EXPIRY_DT	Describes the date on which a student's exclusion from a unit is no longer effective. If no date is entered, the unit exclusion remains current.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_PNDFEE_ENCSTA	This entity describes the user-defined pending fee encumbrance statuses. These statuses map back onto system pending fee encumbrance statuses, to provide the system with the ability to have a large number of statuses which tie back to the s
Column Name	Descritpion
PENDING_FEE_ENCMB_STATUS	An institution defined fee hold status. The status must map to one of the system-defined fee hold statuses. It is recommended that a 1 to 1 mapping exist between institution-defined and system-defined statuses.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description of an institution-defined fee hold status
S_PNDNG_FEE_ENCMB_STATUS	System-defined fee hold status
CLOSED_IND	Specifies whether or not the fee hold status is closed. Checking the indicator closes the fee hold status. A closed fee hold status cannot be applied to a new fee hold record.

Student System - IGS_PE_PND_FEE_ENCUM	This entity describes the pending fee encumbrances that may be heldfor a person. A pending fee encumbrance is the result of the persondefaulting on a fee category fee liability payment. It exists as anintermediate step between recognising t
Column Name	Descritpion
FEE_TYPE	Code of the fee type that is the subject of the hold. The fee is a liability of the fee category associated with the student program attempt.
FEE_CAL_TYPE	Code of a fee calendar type used in the assessment of student fees
FEE_CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance
FEE_ENCUMBRANCE_DT	Enters the date that the hold status was selected
FEE_CAT	The code of the fee category applicable to the student program attempt. The fee type that is the subject of the hold is a liability of the fee category.
COURSE_CD	Unique identifier for a program of study
PENDING_FEE_ENCMB_STATUS	The code of an institution-defined fee hold status. Each institution defined status must map to a system fee status.
ENCUMBRANCE_TYPE	Code of an institution-defined hold type incorporating one or more system hold effect types
DISCONTINUE_ENR_IND	Specifies whether the student's enrollment in one or all attempts must be discontinued prior to application of the hold. If the indicator is set enrollment must be discontinued. Note- the indicator is set in Define Fee Encumbrances.
WRITE_OFF_BAD_DEBT_IND	Specifies whether the debt associated with the hold should be regarded as a bad debt and written off. If the indicator is set , the debt is bad. Note-the indicator is set in Define Fee Encumbrances window. No automated system functionality
COMMENTS	Facility for information relating to the hold
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	A unique student information system identification number, typically incorporating a check digit, used to identify a particular person.

Student System - IGS_PE_PRIV_LEVEL	This entity describes the privacy levels of person
Column Name	Descritpion
PRIVACY_LEVEL_ID	Identifies the privacy level of the person
END_DATE	End date of military service type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Person identification number
DATA_GROUP	A group of data that is associated with a privacy level
DATA_GROUP_ID	Data group identification number that identifies a data group unique
LVL	Level associated with a private data group
ACTION	The action that has to be taken or has been taken for a privacy level
WHOM	The type of person relationship
REF_NOTES_ID	Reference note identification number of a privacy level
START_DATE	Start date for military service type

Student System - IGS_PE_PROVINCE_CD	This entity is used to capture the Province Code.
Column Name	Descritpion
PROVINCE_CD	A unique identifier for the province
DESCRIPTION	Description of the province
CLOSED_IND	Indicator that shows if the province is closed for future reference
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_PE_PRSID_GRP_SEC	This entity describes the occurrence of a person security grant in a person identification group.
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
GROUP_ID	Describes the group identification number sequence number that uniquely identifies the person identification group
PERSON_ID	A unique student information system identification number, typically incorporating a check digit, used to identify a particular person who has security access to the person identification group.
INSERT_IND	Controls whether the person has security permission to insert records in the person identifier group. Selecting the indicator grants permission.
UPDATE_IND	Controls whether the person has security permissions to update records in the person identifier group. Selecting the indicator grants permission.
DELETE_IND	Controls whether the person has security permission to delete records in the person identifier group. Selecting the indicator grants permission.
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

Student System - IGS_PE_STATE_CD	This table holds details of state codes.
Column Name	Descritpion
STATE_CD	User defined state code
DESCRIPTION	Description of the state
CLOSED_IND	Flag indicates whether state code 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
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PE_STATISTICS	This entity describes the statistical information collected about a person. eg. Aboriginal & Torres Strait Islander Indicator.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
YR_ARRIVAL	Describes the year in which a student who was not born in Australia first arrived in Australia, as described in Higher Education Student Data Collection DETYA 1997, Element No. 347.
PRIOR_UG_INST	Identifies, for a student commencing postgraduate work, the institution at which the undergraduate work was done, as described in Higher Education Student Data Collection DETYA 1997, Element No. 356.
PRIOR_OTHER_QUAL	Indicates whether the student had completed some other qualification or certificate of attainment or competence and the year in which the requirements were met, as described in the Higher Education Student Data Collection DETYA 1997
PERSON_ID	Describes the ID that uniquely identifies a person
PRIOR_POST_GRAD	Indicates whether student had commenced and completed a Higher Doctorate, Doctorate degree or other post-graduate program and the last year in which the student was enrolled in such a program
PRIOR_DEGREE	Indicates whether the student had commenced and completed a Bachelor degree program and the last year in which the student was enrolled in such a program, as described in the Higher EducationStudent Data Collection DETYA 1997, Element No. 3
PRIOR_SUBDEG_NOTAFE	Indicates whether student had commenced and completed a Diploma or Associate Diploma program at an institution other than a TAFE and the last year in which the student was enrolled in such a program
PRIOR_SUBDEG_TAFE	Indicates whether student had commenced and completed a Diploma or Associate Diploma program at a TAFE and the last year in which the student was enrolled in such a program, as described in the Higher Education Student Data Collection DETYA
PRIOR_SECED_TAFE	Indicates whether student had completed the final year of secondary schooling at a TAFE college, CAE. and the year in which study was completed, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 364.
PRIOR_TAFE_AWARD	Indicates whether student had commenced and completed a program other than a Diploma or an Associate Diploma at a TAFE and the last year in which the student was enrolled in such a program, as described in the Higher Education Student Data
PRIOR_SECED_SCHOOL	Indicates whether student had completed the final year of secondary schooling at a high school, technical school, secondary school or secondary college and the year in which study was completed, as described in the Higher Education Student
PERM_RESIDENT_CD	Describes the permanent residence status of the student. One of a set of Government-defined Permanent Resident codes described in the Higher Education Student Data CollectionDETYA 1997, Element No. 390.
CREATED_BY	Standard Who column
START_DT	Describes the date from that the statistical information collected about a person is effective
END_DT	Describes the date the statistical information collected about a person is no longer effective
CREATION_DATE	Standard Who column
ABORIG_TORRES_CD	Describes the Australian Aboriginal or Torres Strait Islander status of the student, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 316.
CITIZENSHIP_CD	Describes the Citizenship or Residence status in Australia of the student. One of the set of Government-defined Citizenship/Residency codes described in the Higher Education Student Data Collection DETYA 1997, Element No. 358.
LAST_UPDATED_BY	Standard Who column
BIRTH_COUNTRY_CD	Describes the student's Country of Birth. One of the set of Government-defined country codes described in the Higher Education Student Data Collection DETYA 1997, Element No. 346.
HOME_LANGUAGE_CD	Describes whether the student speaks a language other than English at their permanent home residence and gives the language code. One of the set of Government-defined language codesdescribed in the Higher Education Student Data Collection
LAST_UPDATE_DATE	Standard Who column
TERM_LOCATION_POSTCODE	Describes the Australian Postcode of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 319.
TERM_LOCATION_COUNTRY	Describes the overseas Country code of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 319.
HOME_LOCATION_POSTCODE	Describes the Australian Postcode of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 320.
HOME_LOCATION_COUNTRY	Describes the overseas Country code of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 320.

Student System - IGS_PE_STD_TODO	This table represents a to-do item placed against a student. For example, Re-assess Fees, Produce Outcome Notification. To-dos may have a date specified which they mustn't be actioned before.
Column Name	Descritpion
LOGICAL_DELETE_DT	Describes the date student to do item is logically deleted
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 person ID of the student, the to do item relates to.
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of last concurrentprogram 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
S_STUDENT_TODO_TYPE	Describes the 'to do' for a student
SEQUENCE_NUMBER	Uniquely identifies the student to do item
TODO_DT	Describes the date a student to do item is to be actioned

Student System - IGS_PE_STD_TODO_REF	This table represents reference information against a to-do item placed against a student. For example, the to-do action may be to assign default assessment items against a student in a unit for a particular teaching period. To-do items can
Column Name	Descritpion
PERSON_ID	Describes the person ID of the student the to do item relates to
S_STUDENT_TODO_TYPE	Describes the 'to do' for a student
SEQUENCE_NUMBER	Uniquely identifies the student to do item
REFERENCE_NUMBER	Uniquely identifies the student to do reference item
CAL_TYPE	The calendar type of the calendar instance in which the unit is offered. Units can only be offered in instances of calendar types that are categorised as teaching calendars. For examples include SEM - 1 semester 1 teaching period, SEM - 2 s
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance
COURSE_CD	Unique identifier for the program
UNIT_CD	Unique identifier of the unit
OTHER_REFERENCE	Any reference not specific to a calendar instance, program version or unit version
LOGICAL_DELETE_DT	Describes the date student to do reference item is logically deleted
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
UOO_ID	Unit Section identifier

Student System - IGS_PE_SUBURB_POSTCD	This entity is information obtained from Australia Post mapping suburbs to postcodes and will be loaded and updated annually. The data supplied is, as yet, undefined.
Column Name	Descritpion
POSTCODE	Australian postcode for the associated suburbs
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUBURBS	The suburb or set of suburbs that are associated with the particular postcode.
CLOSED_IND	Specifies whether the postcode is open or closed. Selecting the checkbox to 'closed' prevents use of the postcode in new address and statistical details records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PE_UNT_REQUIRMNT	Describes units that are required to be studied by the student as part of a hold
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Identification number of the person who has had one or more hold effects imposed upon them
ENCUMBRANCE_TYPE	Institution-defined hold type incorporating one or more system hold effect types
PEN_START_DT	Describes the date an hold on a person becomes effective
S_ENCMB_EFFECT_TYPE	Describes the effect that is placed on a person or one of their programs as part of a hold
PEE_START_DT	Describes the date the effect of a hold on a person becomes effective
PEE_SEQUENCE_NUMBER	Describes a unique number for referencing person hold effect
UNIT_CD	Code of the required unit
PUR_START_DT	Date that the person unit requirement become effective
CREATED_BY	Standard Who column
EXPIRY_DT	Describes the date that the requirement is no longer effective
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_UNT_SET_EXCL	This entity describes a unit set which a student has been excluded from.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ENCUMBRANCE_TYPE	The institution-defined hold type that has been applied
PEN_START_DT	Date that the student's hold type became effective
S_ENCMB_EFFECT_TYPE	System hold effect that is placed on a person
PEE_START_DT	Date that the system effect associated with a hold became effective
PEE_SEQUENCE_NUMBER	A unique number for referencing person hold effects
UNIT_SET_CD	Code of unit set
US_VERSION_NUMBER	Version number
PUSE_START_DT	Describes the date that the person unit set exclusion is effective from
CREATED_BY	Standard Who column
EXPIRY_DT	Describes the date that the person unit set exclusion is no longer effective
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PE_ALIAS_TYPES_ALL	This entity describes the available user-defined list of person alias types.
Column Name	Descritpion
ALIAS_TYPE	Describes the available list of user defined alias types
DESCRIPTION	Description of the alias type
CLOSED_IND	Closed indicator. Describes whether alias type is active 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
ORG_ID	Organization identifier

Student System - IGS_PE_CONTACT_DTLS	This entity describes the contact details of a location.
Column Name	Descritpion
CONTACT_POINT_ID	Unique identifier of contact details
PHONE_COUNTRY_CODE	Country code of the phone
PHONE_NUMBER	Phone number
PHONE_EXTENSION	Phone extension
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	Program Application Identifier of last concurrent program to update this record
LOCATION_VENUE_ADDR_ID	Location venue address identifier
PROGRAM_ID	Program Identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of the concurrent program
ATTRIBUTE_CATEGORY	Meant for Descriptive Flexfield
ATTRIBUTE1	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE2	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE3	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE4	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE5	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE6	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE7	Standard attribute column, meant for Descriptive Flexfield
CONTACT_POINT_TYPE	Describes the type of contact point
ATTRIBUTE8	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE9	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE10	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE11	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE12	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE13	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE14	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE15	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE16	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE17	Standard attribute column, meant for Descriptive Flexfield
STATUS	Describes the status of the contact details
ATTRIBUTE18	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE19	Standard attribute column, meant for Descriptive Flexfield
ATTRIBUTE20	Standard attribute column, meant for Descriptive Flexfield
PHONE_LINE_TYPE	Type of phone line
PRIMARY_FLAG	Shows whether this contact details is primary or not
EMAIL_FORMAT	Describes the format of the email
EMAIL_ADDRESS	Email address
TELEPHONE_TYPE	Type of the telephone
PHONE_AREA_CODE	Area code of the phone

Student System - IGS_PE_DATA_GROUPS_ALL	This entity describes the person data groups
Column Name	Descritpion
DATA_GROUP_ID	A unique identifier of the person data group
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
DATA_GROUP	Name of the data group
DESCRIPTION	Description of the exact data that is included in the grouping
LVL	Level associated with a private data group
LVL_DESCRIPTION	Description of privacy level
CLOSED_IND	Flag to indicate whether a data group is active or inactive
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PE_DELIVERY_CDS_ALL	This entity describes delivery codes
Column Name	Descritpion
DELIVERY_CODE	User defined delivery code
DESCRIPTION	Description of delivery code
CLOSED_IND	Flag that indicates the delivery code is active 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
ORG_ID	Operating unit identifier

Student System - IGS_PE_DUP_PAIRS_ALL	This entity describes the duplicate pair of persons in the system
Column Name	Descritpion
DUPLICATE_PAIR_ID	Unique identifier for the duplicate pair
PERSON_ID_TYPE	Person ID type of the duplicate alternate identifier of the duplicate person
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request Identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application identifier of the last concurrent program to update this record
PROGRAM_ID	Program Identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last Update Date of this record update by concurrent program
ORG_ID	Operating Unit Identifier
BATCH_ID	Identifier of the batch run
MATCH_SET_ID	Identifier of the duplicate match criteria selected for this batch run
ACTUAL_PERSON_ID	Person Identifier for that duplicate person is found
DUPLICATE_PERSON_ID	Identifier of the duplicate person
OBSOLETE_ID	Contains antiquated person identifier
MATCH_CATEGORY	Type of match whether exact match or partial match
DUP_STATUS	Status of the duplicate pair
ADDRESS_TYPE	Address type of duplicate address
LOCATION_ID	Location identifier of the duplicate pair

Student System - IGS_PE_HLTH_INS_ALL	This entity describes the health insurance details
Column Name	Descritpion
HEALTH_INS_ID	A unique identifier for each insurance type for a particular student
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
INSURANCE_CD	Insurance code
ATTRIBUTE_CATEGORY	Stores context information
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.
PERSON_ID	Person identification number
ATTRIBUTE13	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE14	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE15	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE16	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE17	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE18	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE19	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE20	Standard Attribute Column, meant for descriptive flex field.
INSURANCE_ID	OBSOLETED. Insurance identification number
INSURANCE_PROVIDER	Free text name of insurance company
POLICY_NUMBER	Insurance policy number
START_DATE	Effective start date of the insurance policy
END_DATE	Effective end date of the Insurance Policy
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PE_HZ_LOCATIONS	This entity describes the locations for a person
Column Name	Descritpion
LOCATION_ID	Unique identifier of the location
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_ID	Program Identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Program application identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update by concurrent program
OTHER_DETAILS_1	Free window text of Other Details 1
OTHER_DETAILS_2	Free window text of Other Details 2
OTHER_DETAILS_3	Free window text of Other Details 3
CORRESPONDENCE	(OBSOLETE)Flag indicates whether this location could be used for correspondence
DATE_LAST_VERIFIED	Last verified date
CONTACT_PERSON	Contact person of this location
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PE_HZ_PARTIES	This entity describes the attributes of a person.
Column Name	Descritpion
PARTY_ID	Unique identifier of the party
LEVEL_OF_QUAL	Identifier for level of qualification of the Person Party.
MILITARY_SERVICE_REG	Military service registration
VETERAN	Status indicating whether a person party should be considered as a Veteran and the Veteran Type.
INSTITUTION_CD	Identifier code of the institution
OI_LOCAL_INSTITUTION_IND	Flag indicates whether institution is local or not. Local institution is the install site of Oracle Student System.
OI_OS_IND	Overseas institution indicator
OI_GOVT_INSTITUTION_CD	Government institution code
OI_INST_CONTROL_TYPE	Organizational institute control type
OI_INSTITUTION_TYPE	Type of Institution. Applicable only for records of Institution Party.
OI_INSTITUTION_STATUS	Status of the Institution. Applicable only for records of Institution Party.
DECEASED_IND	Flag indicates whether the Person Party is deceased.
OU_START_DT	Start date of the organization unit
OU_END_DT	End date of the organization unit
OU_MEMBER_TYPE	Indicator for the Member Type for the Organization Party
OU_ORG_STATUS	Organization status
OU_ORG_TYPE	Organization type
INST_ORG_IND	Indicates whether the party is an Organization or an Institution for Oracle Student System.I- Institution, O- Organization and a Null indicates that the party is a Person Party.
INST_PRIORITY_CD	Institution Priority Code
INST_PRIORITY_CODE_ID	Indicates the Institution Priority Code - OBSOLETE
INST_EPS_CODE	Indicates the Institution Market Code
INST_PHONE_COUNTRY_CODE	Indicates the Institution Phone Country Code
INST_PHONE_AREA_CODE	Indicates the Institution Phone Area Code
INST_PHONE_NUMBER	Indicates the Institution Phone Number
ADV_STUDIES_CLASSES	Indicates the number of Advanced Studies Classes Offered
HONORS_CLASSES	Indicates the number of Honors classes offered
CLASS_SIZE	Indicates the class size
SEC_SCHOOL_LOCATION_ID	Indicates the secondary school location identifier
PERCENT_PLAN_HIGHER_EDU	Indicates the percentage of students planning to pursue higher education
ARCHIVE_EXCLUSION_IND	Flag indicates whether the Person Party is excluded from archive.
FUND_AUTHORIZATION	This identifies if the Person has Funds Authorization or not.
PE_INFO_VERIFY_TIME	Student's information verification Time. Self Service will use this information . Every Time the student logs into the system, this field will be used to check if he needs to verify again for the information corresponding to him
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	Program application identifier of the last concurrent program to update this record
PROGRAM_ID	Program identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date by the concurrent program
BIRTH_CITY	City of Birth
ARCHIVE_DT	Archive date of the person
BIRTH_COUNTRY	Country code of birth place
OSS_ORG_UNIT_CD	Code for the Organization or Institution that will be recognized by OSS. All tables referring to Organization will have Foreign Key with this column and Not HZ_PARTIES.PARTY_NUMBER
FELONY_CONVICTED_FLAG	Flag indicating whether the person is ever convicted of a Felony
PURGE_EXCLUSION_IND	Flag indicates whether Person Party is excluded from purging.
PURGE_DT	Purge date of the person
ORACLE_USERNAME	Oracle user name
PROOF_OF_INS	Proof of insurance
PROOF_OF_IMMU	Proof of immunization

Student System - IGS_PE_HZ_PARTY_REL	This entity describes the relationships of a person
Column Name	Descritpion
PARTY_RELATIONSHIP_ID	Unique identifier of party relationships
PROGRAM_ID	Program identifier of the last concurrent program
PROGRAM_UPDATE_DATE	Last update date of the concurrent program
OTHER_REL_TYPE	Other relationship type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request identifier of the last concurrent program
PROGRAM_APPLICATION_ID	Program application identifier of the last concurrent program

Student System - IGS_PE_INCOME_TAX_ALL	This entity describes the income tax details of a person
Column Name	Descritpion
TAX_ID	Unique identifier of the income tax details
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
TYPE_CODE_ID	Type Code Id
PERSON_ID	Unique identifier of a person
TAX_INFO	Free window text of income tax details
TYPE_CODE	Type of income details
START_DATE	Start date of the income details
END_DATE	End date of the income details
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PE_LOCVENUE_USE	This entity describes the location venue usages
Column Name	Descritpion
LOCVENUE_USE_ID	Location venue usage identifier
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Request Identifier of the concurrent program
PROGRAM_APPLICATION_ID	Program application identifier of the concurrent program
PROGRAM_ID	Program identifier of the concurrent program
PROGRAM_UPDATE_DATE	Last update date of the concurrent program
LOC_VENUE_ADDR_ID	Location venue address identifier
SITE_USE_CODE	Site usage type of the address
ACTIVE_IND	Flag indicates whether the usage is active or not
LOCATION	Location details
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_PE_MATCH_SETS_ALL	Describes the match set criteria configured by the user
Column Name	Descritpion
MATCH_SET_ID	Unique identifier of the match set criteria
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
PRIMARY_ADDR_FLAG	Flag indicates whether the match set considers only the primary address.
EXCLUDE_INACTIVE_IND	Column indicating whether Inactive Persons need to be excluded or included when performing a duplicate check.
SOURCE_TYPE_ID	Identifier of the source type
MATCH_SET_NAME	Name of the match set criteria
DESCRIPTION	Description of the match set criteria
CLOSED_IND	Flag indicates whether the match set is closed or open
PARTIAL_IF_NULL	Flag indicates whether partial match should be done if the value is null
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PE_MIL_SERVICES_ALL	This entity describes the Military services of a person
Column Name	Descritpion
MILIT_SERVICE_ID	Unique identifier of the military service details
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Standard Attibute Column. Meant for descriptiove flexfield.
ATTRIBUTE1	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE2	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE3	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE4	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE5	Standard attribute column, meant for Descriptive Flexfield.
PERSON_ID	Person identification number
ATTRIBUTE6	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE7	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE8	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE9	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE10	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE11	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE12	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE13	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE14	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE15	Standard attribute column, meant for Descriptive Flexfield.
MILITARY_TYPE_ID	OBSOLETED. Military service type ID
ATTRIBUTE16	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE17	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE18	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE19	Standard attribute column, meant for Descriptive Flexfield.
ATTRIBUTE20	Standard attribute column, meant for Descriptive Flexfield.
ORG_ID	Operating unit identifier
MILITARY_TYPE_CD	Military type code
SEPARATION_TYPE_CD	Separation type code.
ASSISTANCE_TYPE_CD	Assistance type code.
ASSISTANCE_STATUS_CD	Assistance status code
START_DATE	Start date for military service type
END_DATE	End date of military service type.
SEPARATION_TYPE_ID	OBSOLETED. Military separation type ID
ASSISTANCE_TYPE_ID	OBSOLETED. Military assistance type ID
ASSISTANCE_STATUS_ID	OBSOLETED. Military assistance status ID
CREATED_BY	Standard Who column

Student System - IGS_PE_MTCH_SET_DATA_ALL	This entity describes the data required for duplicate match set criteria
Column Name	Descritpion
MATCH_SET_DATA_ID	Unique identifier for match set data
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
MATCH_SET_ID	Identifier of the duplicate match set criteria
DATA_ELEMENT	The name of the data element
VALUE	Value of the data element
EXACT_INCLUDE	Flag indicates whether this data element should be included for exact match
PARTIAL_INCLUDE	Flag indicates whether this data element should be included for partial match
DROP_IF_NULL	Flag indicates whether this data element should be dropped from match if the value is null
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PE_PERSID_GROUP_ALL	This entity describes the available groups to which persons can be assigned for reporting purposes.
Column Name	Descritpion
CREATED_BY	Standard Who column
ATTRIBUTE8	Attribute of Descriptive Flex field
ATTRIBUTE9	Attribute of Descriptive Flex field
ATTRIBUTE10	Attribute of Descriptive Flex field
ATTRIBUTE11	Attribute of Descriptive Flex field
CREATION_DATE	Standard Who column
ATTRIBUTE12	Attribute of Descriptive Flex field
ATTRIBUTE13	Attribute of Descriptive Flex field
ATTRIBUTE14	Attribute of Descriptive Flex field
ATTRIBUTE15	Attribute of Descriptive Flex field
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE16	Attribute of Descriptive Flex field
ATTRIBUTE17	Attribute of Descriptive Flex field
ATTRIBUTE18	Attribute of Descriptive Flex field
ATTRIBUTE19	Attribute of Descriptive Flex field
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE20	Attribute of Descriptive Flex field
FILE_NAME	File Name
LAST_UPDATE_LOGIN	Standard Who column
GROUP_ID	Describes the group ID which uniquely identifies the person ID group
GROUP_CD	Code of a person ID group. A person ID group also has a unique system generated sequencenumber or group ID.
CREATOR_PERSON_ID	ID of the person who created the person ID Group
DESCRIPTION	Description of the person ID group
CREATE_DT	Records the date and time the person ID group was created
CLOSED_IND	Specifies whether or not the person ID group is open or closed. Selecting the checkbox closes the ID group.
COMMENTS	Used to record the purpose or other comments about the person ID group
REQUEST_ID	Request identifier of the last concurrent program to update this record
PROGRAM_APPLICATION_ID	Program application identifier of the last concurrent program to update this record
PROGRAM_ID	Program identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by concurrent program
ORG_ID	Operating unit identifier
ATTRIBUTE_CATEGORY	Attribute Category of Descriptive Flex field
ATTRIBUTE1	Attribute of Descriptive Flex field
ATTRIBUTE2	Attribute of Descriptive Flex field
ATTRIBUTE3	Attribute of Descriptive Flex field
ATTRIBUTE4	Attribute of Descriptive Flex field
ATTRIBUTE5	Attribute of Descriptive Flex field
ATTRIBUTE6	Attribute of Descriptive Flex field
ATTRIBUTE7	Attribute of Descriptive Flex field

Student System - IGS_PE_PERSON_REFS_ALL	Captures information about the references to a person
Column Name	Descritpion
PERSON_REFERENCE_ID	Unique Identifier of a Reference associated with a Person.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating Unit Identifier
PERSON_ID	Unique Identifier for a Person.
REFERENCE_TYPE_ID	Unique Idenifier for a Person Type.
DESCRIPTION	Description of reference type.
START_DATE	Start Date of the associated Reference.
END_DATE	End Date of the associated Reference.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PE_PERS_PREFS_ALL	This entity describes the preferences for a person within OSS. These preferences include the 'Record Enrolments Session Details'.
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
ENQ_ADM_CAL_TYPE	Captures an enquiry admission calendar type
ENQ_ADM_CI_SEQUENCE_NUMBER	Captures a unique admission sequence number
PERSON_ID	Identifier that uniquely identifies a person
SERVER_PRINTER_DFLT	Name of the networked printer to be used as the person's default for outputs generated by the job scheduler facility
ALLOW_STND_REQ_IND	Specifies whether or not the system user is permitted to submit standing requests when using job scheduler. Selecting the checkbox allows the system user to create standing requests.
ORG_ID	Operating unit identifier
CREATED_BY	Standard Who column
ENR_ACAD_CAL_TYPE	The last academic calendar type used through the record enrollments process
ENR_ACAD_SEQUENCE_NUMBER	Sequence number of the last academic calendar type used through the record enrollments process
CREATION_DATE	Standard Who column
ENR_ENROLMENT_CAT	The last enrollment category used through the record enrollments process
ENR_ENR_METHOD_TYPE	The last enrollment method used through the record enrollments process.
ADM_ACAD_CAL_TYPE	Describes the last academic calendar type used through the direct admissions process
LAST_UPDATED_BY	Standard Who column
ADM_ACAD_CI_SEQUENCE_NUMBER	Describes the sequence number of the last academic calendar instance used through the direct admissions process
ADM_ADM_CAL_TYPE	Describes the last admission calendar type used through the direct admissions process
ADM_ADM_CI_SEQUENCE_NUMBER	Describes the sequence number of the last admission calendar instance used through the direct admissions process
ADM_ADMISSION_CAT	Describes the last admission category used through the direct admissions process.
LAST_UPDATE_DATE	Standard Who column
ADM_S_ADMISSION_PROCESS_TYPE	Describes the last system admission process type used through the direct admissions process
ENQ_ACAD_CAL_TYPE	Captures information about the enquiry academic calendar type
ENQ_ACAD_CI_SEQUENCE_NUMBER	Sequence number that identifies an academic citation

Student System - IGS_PE_PRSID_GRP_MEM_ALL	This entity describes the occurrence of a person in a person id group.
Column Name	Descritpion
CREATED_BY	Standard Who column
END_DATE	The end date of a person identification group member.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GROUP_ID	Describes the group identification number sequence number that uniquely identifies the person identification group
PERSON_ID	A unique student information system identification number, typically incorporating a check digit, used to identify a particular person who is a member of the person identification 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
PROGRAM_ID	Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program
ORG_ID	Operating unit identifier
START_DATE	Starting date of a person identification group member

Student System - IGS_PE_REF_TYPES_ALL	This table holds the details for all person reference types. This will be a lookup
Column Name	Descritpion
REFERENCE_TYPE_ID	Unique Identifier of reference type
REFERENCE_TYPE	Type of reference
DESCRIPTION	Description of reference types
CLOSED_IND	Flag indicates whether refernce type 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
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier

Student System - IGS_PE_RES_DTLS_ALL	This table holds the details about the students residency details.
Column Name	Descritpion
RESIDENT_DETAILS_ID	A unique identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Attribute category
ATTRIBUTE1	Attribute for Descriptive Flexfields
ATTRIBUTE2	Attribute for Descriptive Flexfields
ATTRIBUTE3	Attribute for Descriptive Flexfields
ATTRIBUTE4	Attribute for Descriptive Flexfields
ATTRIBUTE5	Attribute for Descriptive Flexfields
ATTRIBUTE6	Attribute for Descriptive Flexfields
PERSON_ID	Person identification number
ATTRIBUTE7	Attribute for Descriptive Flexfields
ATTRIBUTE8	Attribute for Descriptive Flexfields
ATTRIBUTE9	Attribute for Descriptive Flexfields
ATTRIBUTE10	Attribute for Descriptive Flexfields
ATTRIBUTE11	Attribute for Descriptive Flexfields
ATTRIBUTE12	Attribute for Descriptive Flexfields
ATTRIBUTE13	Attribute for Descriptive Flexfields
ATTRIBUTE14	Attribute for Descriptive Flexfields
ATTRIBUTE15	Attribute for Descriptive Flexfields
ATTRIBUTE16	Attribute for Descriptive Flexfields
RESIDENCY_CLASS_ID	OBSOLETE. Residency class ID
ATTRIBUTE17	Attribute for Descriptive Flexfields
ATTRIBUTE18	Attribute for Descriptive Flexfields
ATTRIBUTE19	Attribute for Descriptive Flexfields
ATTRIBUTE20	Attribute for Descriptive Flexfields
ORG_ID	Operating unit identifier
RESIDENCY_CLASS_CD	Residency class code.
RESIDENCY_STATUS_CD	Residency status code
CAL_TYPE	Calendar Type
SEQUENCE_NUMBER	Calendar Sequence Number
RESIDENCY_STATUS_ID	OBSOLETE. Residency status ID
EVALUATION_DATE	Date that residency was evaluated or changed
EVALUATOR	ID and user name of person who evaluated or updated residency status
COMMENTS	Comments
START_DT	No longer used
END_DT	No longer used
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PE_SRC_TYPES_ALL	This table holds the data source types configured in the system.
Column Name	Descritpion
SOURCE_TYPE_ID	Unique identifier of source type
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
ADMISSION_CAT	Admission Category - Obsolete
PERSON_TYPE_CODE	Inquiry Person Type
ENQUIRY_SOURCE_TYPE	Inquiry Source
FUNNEL_STATUS	Inquiry Funnel Status
INQ_ENTRY_STAT_ID	Obsolete
FEE_TYPE_ID	Obsolete
FEE_CAL_TYPE	Obsolete
FEE_CI_SEQUENCE_NUMBER	Obsolete
INQUIRY_TYPE_ID	Inquiry Type ID
SOURCE_TYPE	Type of the source
DESCRIPTION	Description of the source
SYSTEM_SOURCE_TYPE	System source type
CLOSED_IND	Flag indicates whether source type 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_PE_STAT_DETAILS	Entity describes the statistics details of a person
Column Name	Descritpion
PERSON_PROFILE_ID	(OBSOLETE)Unique identifier of statistics details
RESID_STAT_ID	OBSOLETE. State of residence state identifier
SOCIO_ECO_ID	OBSOLETED. Socio economic identifier
NEXT_TO_KIN	Next to kin
IN_STATE_TUITION	Flag indicates whether the person is in state tuition
TUITION_ST_DATE	Tuition start date
TUITION_END_DATE	Tuition end date
FURTHER_EDUCATION_ID	OBSOLETED. Further education identifier
MATR_CAL_TYPE	Calendar Type for Matriculation Term
MATR_SEQUENCE_NUMBER	Sequence Number for Matriculation Term
INIT_CAL_TYPE	Calendar Type for Initial Admittance Term
INIT_SEQUENCE_NUMBER	Sequence Number for Initial Admittance Term
RECENT_CAL_TYPE	Calendar Type for Most Recent Admittance Term
RECENT_SEQUENCE_NUMBER	Sequence Number for Most Recent Admittance Term
CATALOG_CAL_TYPE	Calendar Type for Catalog Year
EFFECTIVE_START_DATE	Start date from that the statistics details are effective
CATALOG_SEQUENCE_NUMBER	Sequence Number for Catalog Year
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	Program Application Identifier of the last concurrent program to update this record
PROGRAM_ID	Program Identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	Last Update Date of the concurrent program
ATTRIBUTE_CATEGORY	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE1	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE2	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE3	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE4	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE5	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE6	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE7	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE8	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE9	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE10	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE11	Standard attribute columns meant for descriptive flex fields
EFFECTIVE_END_DATE	End date after which the statistics details are not effective
ATTRIBUTE12	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE13	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE14	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE15	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE16	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE17	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE18	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE19	Standard attribute columns meant for descriptive flex fields
ATTRIBUTE20	Standard attribute columns meant for descriptive flex fields
FURTHER_EDUCATION_CD	Further education code
RELIGION_CD	Religion code
SOCIO_ECO_CD	Social economic code.
BIRTH_CNTRY_RESN_CODE	Stores the birth country reason if the country of birth is US or US Territory
RELIGION_ID	OBSOLETED. Identifier of the religion
PERSON_ID	Unique Person Identifier for the Statistics Records
CRIMINAL_CONVICT	Flag indicates whether the person is criminal convict or not(Obsolete)
ACAD_DISMISSAL	Academic dismissal(Obsolete)
NON_ACAD_DISMISSAL	Non academic dismissal(Obsolete)
COUNTRY_CD3	Country code 3(Obsolete)
STATE_OF_RESIDENCE	State of residence(Obsolete)

Student System - IGS_PE_STUP_DATA_EMT_ALL	Entity describes the setup data element
Column Name	Descritpion
SETUP_DATA_ELEMENT_ID	Unique identifier of the setup data element
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
PERSON_TYPE_CODE	Code of the person type
DATA_ELEMENT	Name of the data element
VALUE	Value of the data element
REQUIRED_IND	Flag indicates whether the value for the data element is required or mandatory
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_PE_TEACH_PERIODS_ALL	This table holds details of a persons teaching periods
Column Name	Descritpion
TEACHING_PERIOD_ID	Unique identifier of the teaching period
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
TEACH_PERIOD_RESID_STAT_CD	Teaching period residency status code.
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
TEACH_PERIOD_RESID_STAT_ID	OBSOLETED. Indicates teaching period residence status
CAL_TYPE	Indicates calendar type
SEQUENCE_NUMBER	Indicates calendar sequence number
START_DATE	No longer used
END_DATE	No longer used
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PE_TYP_INSTANCES_ALL	Entity describes the various person type instances of a person
Column Name	Descritpion
TYPE_INSTANCE_ID	Unique identifier of the person type
START_DATE	Start date from that the person type is effective
END_DATE	End date after that the person type is not effective
CREATE_METHOD	Method used to create the person type
ENDED_BY	User ID of the user who ended the person type
END_METHOD	Method used to end the person type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
PERSON_TYPE_CODE	Code of person type
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
EMPLMNT_CATEGORY_CODE	Employment Category of the Person
PERSON_ID	Person identifier
COURSE_CD	Course code
CC_VERSION_NUMBER	Course code version number
FUNNEL_STATUS	Funnel status
ADMISSION_APPL_NUMBER	Admission application number
NOMINATED_COURSE_CD	Nominated program code
NCC_VERSION_NUMBER	Nominated course code version number
SEQUENCE_NUMBER	Sequence number

Student System - IGS_PE_VOTE_INFO_ALL	This table holds details of a persons voting rights.
Column Name	Descritpion
VOTER_ID	Identifies uniquely each and every person who has voting right
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
TYPE_CODE_ID	Type Code Id
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
VOTER_INFO	Indicates whether the voting ID is for province, state, county, or country.
TYPE_CODE	Indicates code for province, state, county, or country.
VOTER_REGN_ST_DATE	Indicates voter registration start date
VOTER_REGN_END_DATE	Indicates voter registration end date
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PR_MILESTONE_TYP	This table describes the types of milestones which can be recorded against a research candidate.
Column Name	Descritpion
MILESTONE_TYPE	Describes the set of institution-defined type used to describe milestones. Examples are six monthly report, literature review report, project selection, conference presentation, draft thesis available, and miscellaneous.
DESCRIPTION	Provides an explanation of the milestone types
NTFCTN_IMMINENT_DAYS	The number of days prior to a milestone due date of this type to trigger notification of the imminent milestone.
NTFCTN_REMINDER_DAYS	The number of days after a milestone due date of this type to trigger a reminder notification.
NTFCTN_RE_REMINDER_DAYS	Number of days after a previous reminder for a milestone of the type to trigger another reminder notice.
CLOSED_IND	Indicates and specifies if the milestone type is open or closed. Selecting the checkbox to 'closed' prevents use of the milestone type in new or modified records in other parts of the system.
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_PR_RU_CAT	This entity describes the categories of progression rules which are available for use within the progression sub-system. These progression rule categories must map back onto a system-defined rule type, which allows a little flexibility in t
Column Name	Descritpion
CLOSED_IND	Indicates and specifies if the categroy of rules is open or closed. Selecting the indicator to closed as selected prevents further application of all rules within the category.
MESSAGE	A text-based facility for entering additional information about the context institution-defined rule category, the default set of progression periods under that the rules of the context category are tested and the range of potential outcome
CREATED_BY	Standard Who column
PROGRESSION_RULE_CAT	The code of an institution-defined progression rule category. Each category of progression rules is mapped to one of the system rule call codes. To maintain flexibility in the application of rules, institutions are advised to create one tha
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
POSITIVE_RULE_IND	Indicates whether the rule is positive.
DESCRIPTION	The description of an institution defined progression rule category. Each category of progression rules is mapped to one of the system rule call codes. To maintain flexibility in the application of rules, institutions are advised to create
S_RULE_CALL_CD	The code of a sytem defined rule call to that the institution-defined category of progression rules is mapped. System rule call codes are used to limit the selection set of rule options maitained.

Student System - IGS_PR_MILESTONE_ALL	This entity describes the milestones that a research student must complete during the duration of their candidature.
Column Name	Descritpion
PERSON_ID	Contains the person identifier to whom the milestone applies
ACTUAL_REACHED_DT	Describes the date on that the milestone was completed, and if successfully or unsuccessfully
PRECED_SEQUENCE_NUMBER	Contains the unique sequence number of the preceding milestone
OVRD_NTFCTN_IMMINENT_DAYS	Contains the override offset imminent days for notification
OVRD_NTFCTN_REMINDER_DAYS	Contains the override offset days for reminder
OVRD_NTFCTN_RE_REMINDER_DAYS	Contains the override offset days for subsequent reminders
CA_SEQUENCE_NUMBER	Contains the candidature sequence number
SEQUENCE_NUMBER	Uniquely identifies the milestone, allowing multiple records for the same milestone type against the candidate.
MILESTONE_TYPE	Describes the type of milestone
COMMENTS	Contains any supervisor comments in reference to the milestone
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	Holds the information of the organization that entered this data. This field will be used for row level security in a multi-organization setup.
MILESTONE_STATUS	Contains the status of the milestone. For example, planned, achieved, moved.
DUE_DT	Contains the date on that the milestone is due to be achieved
DESCRIPTION	Contains a brief explanation of the milestone

Student System - IGS_PR_MILESTONE_HST_ALL	This entity describes the history of statuses of a milestone.
Column Name	Descritpion
PERSON_ID	Contains the person identifier to whom the milestone applies
DESCRIPTION	Contains a brief explanation of the milestone
ACTUAL_REACHED_DT	Describes the date the milestone was completed, if successfully or unsuccessfully
PRECED_SEQUENCE_NUMBER	Contains the unique sequence number of the preceding milestone
OVRD_NTFCTN_IMMINENT_DAYS	Contains the override offset imminent days for notification
OVRD_NTFCTN_REMINDER_DAYS	Contains the override offset days for reminder
OVRD_NTFCTN_RE_REMINDER_DAYS	Contains the override offset days for subsequent reminders
CA_SEQUENCE_NUMBER	Contains the candidature sequence number
SEQUENCE_NUMBER	Uniquely identifies the milestone, allowing multiple records for the same milestone type against the candidate
HIST_START_DT	The effective start date and time of the history record
COMMENTS	Contains any supervisor comments in reference to the milestone
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	Holds the information of the organization that is entered in this data. This field will be used for row level security in a multi-organization setup.
HIST_END_DT	The effective end date and time of the history record
HIST_WHO	The 'updated by' person at the time of the history
MILESTONE_TYPE	Describes the type of milestone
MILESTONE_STATUS	Contains the status of the milestone. For example, planned, achieved, moved.
DUE_DT	Contains the date on that the milestone is due to be achieved

Student System - IGS_PR_MS_STAT_ALL	This table describes the user-defined milestone statuses, which map onto one of the set of system defined values.
Column Name	Descritpion
MILESTONE_STATUS	Describes the institution-defined statuses that show the progress of a milestone. Examples are planned, achieved, not achieved, moved, withdrawn.
DESCRIPTION	Provides an explanation of the milestone status
S_MILESTONE_STATUS	Describes the system-defined status of a milestone onto that the institution-defined value maps
CLOSED_IND	Indicates and specifies if the milestone status is open or closed. Selecting the checkbox to 'closed' prevents use of the milestone status in new or modified records in the system.
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	Holds the information of the organization that entered this data

Student System - IGS_PR_OU_PS_ALL	This table contains the course codes that are used in encumbrances resulting from the outcome. For example, course exclusions.
Column Name	Descritpion
PROGRESSION_RULE_CAT	Describes the institution-defined category for a progression rule
PRA_SEQUENCE_NUMBER	Describes the progression rule sequence number of the related rule
PRO_SEQUENCE_NUMBER	Describes the progression outcome sequence number of the related outcome
COURSE_CD	Describes the program code to that the hold is applied
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	Holds the information of the organization that entered this data. This field will be used for row level security in a multi-organization setup.

Student System - IGS_PR_OU_TYPE_ALL	Describes the types of outcomes from a progression rule check. For example, suspended, excluded, successful, manual (where the outcome must be applied manually). These outcome types must map back onto system-defined outcome types.
Column Name	Descritpion
PROGRESSION_OUTCOME_TYPE	The code of an institution-defined outcome type for a progression rule such as program exclusion or program suspension. Each outcome type must be mapped to one of the set of system values comprising like expulsion, exclusion. A student's
S_PROGRESSION_OUTCOME_TYPE	The system outcome type for a progression rule onto that the institution-defined value has been mapped. The set of system statuses comprises expulsion system values. For example, exclusion, manual, probation and others.
DESCRIPTION	Describes an institution-defined progression rule outcome type such as program exclusion or program suspension. Each outcome type must be mapped to one of the set of system values comprising expulsion, exclusion and others.
ENCUMBRANCE_TYPE	Describes the type of hold that results from the context progression outcome. The default effects of the hold type must align with the system progression outcome type onto the record that is mapped. A progression outcome type of exclusion m
COMMENTS	A text-based facility for entering additional information about the context progression rule outcome type. For example, it can be appropriate to describe the circumstances under that the outcome would be applied together with any effects of
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	Holds the information of the organization that entered this data. This field will be used for row level security in a multi-organization setup.
DFLT_RESTRICTED_ENROLMENT_CP	Default number of credit points that the student program attempt is restricted to in a subsequent progression period as a consequence of the progression outcome. The number is only applicable where the related hold type results in either t
DFLT_RESTRICTED_ATT_TYPE	The default attendance type that the student program attempt is restricted to in a subsequent progression period as a consequence of the progression outcome. The value only applies where the related hold type results in a RSTR_AT_TY system
CLOSED_IND	Indicates and specifies if the progression type is open or closed. Selecting the indicator as checked closes the outcome type and prevents its further application in progression rule checks.
POSITIVE_OUTCOME_IND	Indicates whether the outcome is positive.

Student System - IGS_PR_OU_UNIT_ALL	This table contains units from which the student will be excluded or in which the student is required to enroll in the next enrollment period.
Column Name	Descritpion
PROGRESSION_RULE_CAT	Describes the institution-defined categoryof the progression rule to that the exclusion or requirement applies.
PRA_SEQUENCE_NUMBER	Describes the sequence number of the progression rule
PRO_SEQUENCE_NUMBER	Describes the sequence number of progression outcome
UNIT_CD	Describes the unit code applicable to the exclusion or requirement.
S_UNIT_TYPE	Describes if the unit is to be excluded or whether it is a required unit
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Holds the information of the organization that entered this data. This field will be used for row level security in a multi-organization setup.

Student System - IGS_PR_OU_UNIT_SET_ALL	This table contains unit sets from which the student will be failed as a result of the related rule being failed.
Column Name	Descritpion
PROGRESSION_RULE_CAT	Describes the institution-defined category of the progression rule that the unit set exclusion applies
PRA_SEQUENCE_NUMBER	Describes the sequence number of the progression rule
PRO_SEQUENCE_NUMBER	Describes the sequence number of progression outcome
UNIT_SET_CD	Describes the code of the unit set that the student is to be excluded
US_VERSION_NUMBER	Describes the version number of unit set applicable at the time the exclusion is applied
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	Holds the information of the organization that entered this data. This field will be used for row level security in a multi-organization setup.

Student System - IGS_PR_RULE_ALL	This entity describes a standard progression rule which then can be applied to one of the allowable system elements - a course version, course type, org unit or individual student course attempt using progression rule application.
Column Name	Descritpion
CLOSED_IND	Indicates and specifies if the progression rule is open or closed. Selecting the checkbox to closed prevents further application of the progression rule.
MESSAGE	A text based facility for enteing additional information about the context rule code. For example, it can be appropriate to fully describe the rule definition, the cohort of students to whom the rule applies, the default set of progression
CREATED_BY	Standard Who column
PROGRESSION_RULE_CAT	The code of an institution-defined category for progression rule. Each category of progression rules is mapped to one of the system rule call codes. The system rule call codes are PRG-GPA, PRG-UFAIL, PRG-WAM. To maintain flexibility in th
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
PROGRESSION_RULE_CD	The code of an institution-defined program progression rule as it is applied to one of the allowable system elements.The allowable values are program version, program type, organizational unit or individual student program attempt. A progr
DESCRIPTION	The explaination of an institution-defined program progression rule as it is applied to one of the allowable system elements. The allowable system elements are program version, program type, organizational unit or individual student program
RUL_SEQUENCE_NUMBER	Describes the unique identifier for the rule

Student System - IGS_PR_RU_APPL_ALL	This entity describes a progression rule as it is applied to one of the allowable system elements - a course version, course type, org unit or individual student course attempt.
Column Name	Descritpion
REFERENCE_CD	Describes the reference code assigned to 'one-off' progression rules created at the point of finalizing a progression outcome. The reference replaces a rule code.
RUL_SEQUENCE_NUMBER	Describes the unique identifier for the rule
ATTENDANCE_TYPE	The code of an institution-defined attendance type that the program progression rule is restricted to
OU_ORG_UNIT_CD	The code of an organization unit that the progression rule is restricted to
OU_START_DT	The date from that the organizational unit is effective. An organizational unit is uniquely identified by the combination of its code and start date.
PROGRESSION_RULE_CAT	The code of an institution-defined category for progression rule. Each category of progression rules is mapped to one of the system rule call codes like PRG-GPA, PRG-UFAIL, PRG-WAM. To maintain flexibility in the application of rules, insti
COURSE_TYPE	The code of an institution-defined program type that the progression rule is restricted to
CRV_COURSE_CD	Code of a program that the progression rule is restricted to
CRV_VERSION_NUMBER	The version number of the program that the progression rule is restricted to
SCA_PERSON_ID	The person identifier of the individual student program attempt that the progression rule is restricted to
SCA_COURSE_CD	The code of the individual student program attempt that the progression rule is restricted to
PRO_PROGRESSION_RULE_CAT	The category of institution-defined progression rules that the progression rule outcome is linked
PRO_PRA_SEQUENCE_NUMBER	A unique sequence number linking the application of the progression rule to its outcome
PRO_SEQUENCE_NUMBER	A unique sequence number linking the progression outcome to a particular application of a progression rule
SPO_PERSON_ID	The person identifier of the student program attempt that the progression outcome applies
SPO_COURSE_CD	The code of the student program attempt that the progression outcome applies
SEQUENCE_NUMBER	Uniquely identifies the progression rule application
SPO_SEQUENCE_NUMBER	A unique sequence number linking the student progression outcome to a particular application of the progression rule.
LOGICAL_DELETE_DT	Identifies the date the record was logically deleted
MESSAGE	A text based facility for entering additional information about the context rule code. For example, it can be appropriate to fully describe the rule definition, the cohort of students to whom the rule applies and can be limited to either a
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_RELATION_TYPE	Identifies the entity that the progression rule applies. It can be either organizational unit, program type, program version or, if the outcome of failing one rule is the application of a subsequent rule, a student program attempt.
ORG_ID	Operating unit identifier
MIN_CP	Minimum of Credit Point Range
PROGRESSION_RULE_CD	The code of an institution-defined program progression rule as it is applied to one of the allowable system elements program version, program type, organizational unit or individual student program attempt. A progression rule is classified
MAX_CP	Maximum of Credit Point Range
IGS_PR_CLASS_STD_ID	Class Standing ID

Student System - IGS_PE_USR_ARG_ALL	Contains all the columns related to self service activity for record open and cutoff date alias and grading schema date alias
Column Name	Descritpion
USR_ACT_RE_GS_ID	System generated number to uniquely identify the User activity for Add and Grading schema
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
UPD_AUDIT_DT_ALIAS	Update Audit status date alias override value
PERSON_TYPE	Person type
RECORD_OPEN_DT_ALIAS	Record open deadline date alias
RECORD_CUTOFF_DT_ALIAS	Record cutoff deadline date alias
GRAD_SCH_DT_ALIAS	Grading schema deadline date alias
ORG_ID	Operating unit identifier
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_PE_USR_AVAL_ALL	Contains all the columns related to self service user activity setup for enrollment validations
Column Name	Descritpion
DENY_WARN	Indicate whether the Step has been Denied or Warned.
OVERRIDE_IND	Indicate whether the Step has been overridden or not.
USR_ACT_VAL_ID	System generated number to uniquely identify the self service user activity setup for enrollment validation
OVERRIDE_DT	The date on which step was overridden.
STEP_OVERRIDE_LIMIT	Override limit, used to create variable credit approval
PERSON_TYPE	Person type
VALIDATION	Validations to be enforced
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_PE_USR_ADISC_ALL	Obsolete - Contains all the columns related to self service user activity setup for discontinuation date alias
Column Name	Descritpion
USR_ACT_DISC_ID	System generated number to uniquely identify the activity setup for discontinuation dates
LAST_UPDATE_LOGIN	Standard WHO Column
PERSON_TYPE	Person type
ADMINISTRATIVE_UNIT_STATUS	Administrative Unit Status
DISC_DT_ALIAS	Discontinuation Date Alias
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

Student System - IGS_PE_ADDR_MAP	Holds the details of OSS 11.0.3 address types to TCA 11.5.4 address mapping
Column Name	Descritpion
ADDR_TYPE	Describes the address type for OSS to TCA address mapping
PHONE_LINE_TYPE2	Describes the Phone Line Type2 for OSS to TCA address mapping
PHONE_LINE_TYPE3	Describes the Phone Line Type3 for OSS to TCA address mapping
COUNTRY	Describes the Country Code incase the country was not a part of the mapping
OTHER_DETAILS	Describes the Other Details for OSS to TCA address mapping
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
USAGE_TYPE	Describes the Address usage type(corresponding address type in TCA)for OSS to TCA address mapping
ADDRESS1	Describes the Address Line1 Mapping(Different address mapped to TCA from OSS) for OSS to TCA address mapping
ADDRESS2	Describes the Address Line2 Mapping(Different address mapped to TCA from OSS) for OSS to TCA address mapping
ADDRESS3	Describes the Address Line3 Mapping(Different address mapped to TCA from OSS) for OSS to TCA address mapping
ADDRESS4	Describes the Address Line4 Mapping(Different address mapped to TCA from OSS) for OSS to TCA address mapping
ADDRESS5	Describes the Address Line5 Mapping(Different address mapped to TCA from OSS) for OSS to TCA address mapping
POSTAL_CODE	Describes the Postal Code Mapping for OSS to TCA address mapping
PHONE_LINE_TYPE1	Describes the Phone Line Type1 for OSS to TCA address mapping

Student System - IGS_PE_FAMILY_DTLS	Obsolete - Stores the family details
Column Name	Descritpion
FAMILY_DTL_ID	System generated number to uniquely identify the Family Details of a Person
CREATED_BY	WHO columns.
CREATION_DATE	WHO columns.
LAST_UPDATED_BY	WHO columns.
LAST_UPDATE_DATE	WHO columns.
LAST_UPDATE_LOGIN	WHO columns.
MEMBER_ID	Unique Key, The Id of the Family Member
PRIMARY	Indicator to indicate whether the Record is Primary
SECONDARY	Indicator to indicate whether the Record is Secondary
JOINT_SALUTATION	Salutation to be used during letter generation.
FACULTY	Indicator to indicate whether the Family Member is a Faculty member.
STAFF	Indicator to indicate whether the Family Member is a Staff member
ALUMNI	Indicator to indicate whether the Family Member is an Alumni
CURRENT_STUDENT	Indicator to indicate whether the Family Member is a current student

Student System - IGS_PE_HOLD_REL_OVR	Contains the Hold Override and Release information.
Column Name	Descritpion
HOLD_REL_OVR_ID	Unique Identifier for the Hold Override or Release step.
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
START_DATE	Start Date.
ELGB_OVERRIDE_ID	Unique Identifier for the Eligibility Override information.
HOLD_TYPE	The Hold Type for which the override is applied.
HOLD_REL_OR_OVR	Indicates the Hold is overridden or released. R-Release and O-Override are acceptable values
HOLD_OLD_END_DT	The original date of the Hold End date. Captured when the hold is released.
ACTION_DT	The date on which the hold release or override applied.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_PR_CSS_CLASS_STD	Maintains the Class Standing mapping for the credit point range and the academic years for each program type and a period
Column Name	Descritpion
IGS_PR_CSS_CLASS_STD_ID	Unique Identifier for Class Standing mapping
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
IGS_PR_CS_SCHDL_ID	Reference to Class Standing schedule
IGS_PR_CLASS_STD_ID	Reference to Class Standing code
MIN_CP	Minimum credit points used to determine the Class Standing
MAX_CP	Maximum credit points for determining the Class Standing
ACAD_YEAR	Academic years used for determining Class Standing
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_PR_CS_SCHDL	Maintains the schedule of Class Standing
Column Name	Descritpion
IGS_PR_CS_SCHDL_ID	Unique indentifier for Class Standing schedule
LAST_UPDATE_LOGIN	Standard WHO Column
COURSE_TYPE	Program type for Class Standing schedule
CONSIDER_CHANGES	Determines whether the Class Standing schedule should be considered immediately or by period
START_DT	Start date of the schedule
END_DT	End date of schedule
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_PR_CLASS_STD	Maintains the institution defined Class Standing set-up values
Column Name	Descritpion
IGS_PR_CLASS_STD_ID	Unique Identifier for Class Standing setup
CLASS_STANDING	Class Standing code
DESCRIPTION	Description of Class Standing code
CLOSED_IND	Indicator to specify if the Class Standing 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
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_PE_ATHLETIC_DTL	Holds details of person's additional athletic information
Column Name	Descritpion
ATHLETIC_DETAILS_ID	A unique identifier for the additional Athletic Details of a person
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ELIGIBILITY_STATUS_CD	Eligibility status code.
PERSON_ID	Person Identification Number
ATHLETIC_GPA	Athletic Grade Point Average
ELIGIBILITY_STATUS_ID	OBSOLETED. Eligibility Status
PREDICT_ELIG_CODE	Predicted Eligibility
TENTATIVE_ADM_CODE	Tentative Admission Type
REVIEW_DATE	Review Date
COMMENTS	Comments
CREATED_BY	Standard WHO Column

Student System - IGS_PE_ATHLETIC_PRG	Holds details of a person's athletic program information.
Column Name	Descritpion
ATHLETIC_PRG_ID	Unique identifier for a person's athletic program information
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
ATHLETIC_PRG_CODE	Athletic program code
PERSON_ID	Person Identifier Number
ATHLETIC_PRG_CD	OBSOLETED. Athletic Program Code
RATING	Rating
START_DATE	Start Date of Program
END_DATE	End Date of Program
RECRUITED_IND	Recruited Indicator
PARTICIPATING_IND	Participating Indicator
LAST_UPDATE_DT	User modifiable Date

Student System - IGS_PE_EIT	Holds details of a person's extra information
Column Name	Descritpion
PE_EIT_ID	A unique identifier
END_DATE	End Date
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 Identification Number
INFORMATION_TYPE	Extra Information Type
PEI_INFORMATION1	Extra Information 1
PEI_INFORMATION2	Extra Information 2
PEI_INFORMATION3	Extra Information 3
PEI_INFORMATION4	Extra Information 4
PEI_INFORMATION5	Extra Information 5
START_DATE	Start Date

Student System - IGS_PE_FELONY_DTLS	Holds details of a person's felony information
Column Name	Descritpion
FELONY_DETAILS_ID	Unique identifier
LAST_UPDATE_LOGIN	standard WHO column
DISP_ACTION_INFO	Disciplinary Action information
PERSON_ID	Person Identification Number
CRIME_NATURE	Crime Nature
CRIME_DATE	Crime date
CONVICT_IND	Criminal convict
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_PE_FUND_DEP	Holds details of a person's funding dependent information
Column Name	Descritpion
FUND_DEP_ID	Unique identifier
NOTES	Comments
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 Identification Number
SURNAME	Surname
GIVEN_NAME	Given Name
SUFFIX	Suffix
RELATIONSHIP_CODE	Relationship Type
BIRTH_DATE	Date of Birth
BIRTH_CITY	City of Birth
BIRTH_COUNTRY	Country of Birth

Student System - IGS_PE_FUND_SOURCE	Holds details of a person's funding source information
Column Name	Descritpion
FUND_SOURCE_ID	Unique Identifier
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 Identification Number
FUND_SOURCE_CODE	Fund Source Type
NAME	Name of Fund Source
AMOUNT	Fund Amount
RELATIONSHIP_CODE	Relationship Type
DOCUMENT_IND	Document Received Indicator(Y/N)
NOTES	Comments
CREATED_BY	Standard WHO column

Student System - IGS_PE_HEARING_DTLS	Holds details of a person's hearing information
Column Name	Descritpion
HEARING_DETAILS_ID	Unique Identifier
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 Identification Number
DESCRIPTION	Description of Hearing
START_DATE	Start Date
END_DATE	End Date
DSPL_FILE_IND	Disciplinary File Exists Indicator
ACAD_DISM_IND	Academic Dismissal Indicator
NON_ACAD_DISM_IND	Non Academic Dismissal Indicator
CREATED_BY	Standard WHO column

Student System - IGS_PE_IMMU_DTLS	Holds details of a person's immunization information
Column Name	Descritpion
IMMU_DETAILS_ID	Unique Identifier
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
ATTRIBUTE_CATEGORY	Stores Flexfield context
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.
PERSON_ID	Person Identification Number
ATTRIBUTE17	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE18	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE19	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE20	Standard Attribute Column, meant for descriptive flex field.
IMMUNIZATION_CODE	Immunization Type
STATUS_CODE	Immunization Status
START_DATE	Start date
END_DATE	End Date
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Student System - IGS_PE_SN_CONTACT	Holds details of a person's special need contact information
Column Name	Descritpion
SN_CONTACT_ID	Unique Identifier
LAST_UPDATE_LOGIN	Standard WHO Column
DISABILITY_ID	Disability ID
CONTACT_NAME	Contact Name, Free format
CONTACT_DATE	Date of Contact with time value
COMMENTS	Comment
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_PE_SN_SERVICE	Holds details of a person's special need service information
Column Name	Descritpion
SN_SERVICE_ID	Unique Identifier
START_DT	Start Date
END_DT	End Date
DISABILITY_ID	Disability ID
SPECIAL_SERVICE_CODE	OBSOLETED. Special Service Code
DOCUMENTED_IND	Documented Indicator(Y/N)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
SPECIAL_SERVICE_CD	Special service code.

Student System - IGS_PE_ATH_DTL_INT	Contains the person athletic details to be imported to IGS_PE_ATHLETIC_DTL.
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ELIGIBILITY_STATUS_CD	Eligibility status code.
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the logic in the import process, and should not be populated by the user.
ATHLETIC_GPA	Athletic GPA
ELIGIBILITY_STATUS_ID	Eligibility Status (Lookup Code)
PREDICT_ELIG_CODE	Predicted Eligibility (Lookup Code)
TENTATIVE_ADM_CODE	Tentative Admission Type (Lookup Code)
REVIEW_DATE	Review Date
COMMENTS	Comments
INTERFACE_ATHLETIC_DTLS_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
MATCH_IND	Match indicator.
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
ERROR_CODE	Error Code
DUP_ATHLETIC_DETAILS_ID	Duplicate Athletic Details ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Student System - IGS_PE_ATH_PRG_INT	Contains the person athletic program details to be imported to IGS_PE_ATHLETIC_PRG.
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATHLETIC_PRG_CODE	Athletic program 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.
ATHLETIC_PRG_CD	Athletic Program Code
RATING	Rating
START_DATE	Start Date
END_DATE	End Date
RECRUITED_IND	Recruited Indicator (Y/N)
PARTICIPATING_IND	Participating Indicator (Y/N)
INTERFACE_ATHLETIC_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
MATCH_IND	Match indicator.
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
ERROR_CODE	Error Code
DUP_ATHLETIC_PRG_ID	Duplicate Athletic Program ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Student System - IGS_PE_CITIZEN_INT	contains the person citizenship records to be imported to HZ_CITIZENSHIP.
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATE_LOGIN	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.
COUNTRY_CODE	Country Code
DOCUMENT_TYPE	Document Type (Lookup Code)
DOCUMENT_REFERENCE	Document Reference
DATE_DISOWNED	Date Disowned
DATE_RECOGNIZED	Start Date
END_DATE	End Date
MATCH_IND	Match indicator.
INTERFACE_CITIZENSHIP_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
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
ERROR_CODE	Error Code
DUP_CITIZENSHIP_ID	Duplicate Citizenship ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
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_PE_EIT_INT	contains the person extra information (such as Country of Physical Residence, State of Residence, Citizenship/Residency Status) to be imported to IGS_PE_EIT.
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	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.
INFORMATION_TYPE	Extra Information Type
PEI_INFORMATION1	Extra Information1
PEI_INFORMATION2	Extra Information2
PEI_INFORMATION3	Extra Information3
PEI_INFORMATION4	Extra Information4
PEI_INFORMATION5	Extra Information5
START_DATE	Start Date of the record information
INTERFACE_EIT_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
END_DATE	End Date of the record information
MATCH_IND	Match indicator.
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
ERROR_CODE	Error Code
DUP_PE_EIT_ID	Duplicate Extra Information ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.

Student System - IGS_PE_FLNY_DTL_INT	contains the person felony details records to be imported to IGS_PE_FELONY_DTLS.
Column Name	Descritpion
INTERFACE_ID	Interface ID
CRIME_NATURE	Crime nature - Free format
CRIME_DATE	Crime date
CONVICT_IND	Convicted indicator (Y/N)
MATCH_IND	Match indicator.
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
ERROR_CODE	Error Code
DUP_FELONY_DETAILS_ID	Duplicate Felony Details ID
INTERFACE_FELONY_DTLS_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
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
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
DISP_ACTION_INFO	Disciplinary Action information
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.

Student System - IGS_PE_FUND_DEP_INT
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
SURNAME	Surname
GIVEN_NAME	Given Name
SUFFIX	Suffix
RELATIONSHIP_CODE	Relationship Type (Lookup Code)
BIRTH_DATE	Date of Birth
BIRTH_CITY	City of Birth
BIRTH_COUNTRY	Country of Birth
INTERFACE_FUND_DEP_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
NOTES	Comments
MATCH_IND
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
ERROR_CODE	Error Code
DUP_FUND_DEP_ID	Duplicate Fund Dep ID.
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Student System - IGS_PE_FUND_SRC_INT	contains the person's funding source records to be imported to IGS_PE_FUND_SOURCE.
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATE_LOGIN	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.
FUND_SOURCE_CODE	Fund Source Type (Lookup Code)
NAME	Name of Fund Source
AMOUNT	Fund Amount
RELATIONSHIP_CODE	Relationship Type (Lookup Code)
DOCUMENT_IND	Doc Received Indicator (Y/N); Default should be set to 'N'
NOTES	Comments
MATCH_IND	Match indicator.
INTERFACE_FUND_SOURCE_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
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
ERROR_CODE	Error Code
DUP_FUND_SOURCE_ID	Duplicate Fund Source ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
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_PE_HEAR_DTL_INT	contains the person hearing details records to be imported to IGS_PE_HEARING_DTLS.
Column Name	Descritpion
INTERFACE_ID	Interface ID
LAST_UPDATE_LOGIN	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.
DESCRIPTION	Description of Hearing
START_DATE	Start Date
END_DATE	End Date
DSPL_FILE_IND	Disciplinary File Exists Indicator
ACAD_DISM_IND	Academic Dismissal Indicator
NON_ACAD_DISM_IND	Non Academic Dismissal Indicator
MATCH_IND	Match indicator.
INTERFACE_HEARING_DTLS_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
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
ERROR_CODE	Error Code
DUP_HEARING_DETAILS_ID	Duplicate Hearing Details ID.
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
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_PE_HOUSING_INT	contains the person housing status to be imported to IGS_PE_TEACH_PERIODS.
Column Name	Descritpion
INTERFACE_ID	Interface ID
TEACH_PERIOD_RESID_STAT_CD	Teaching period residency status code.
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the logic in the import process, and should not be populated by the user.
TEACH_PERIOD_RESID_STAT_ID	Teaching Period Housing Status
CAL_TYPE	Calendar Type
SEQUENCE_NUMBER	Calendar Sequence Number
START_DATE	No longer used
END_DATE	No longer used
MATCH_IND	Match indicator.
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
INTERFACE_HOUSING_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
ERROR_CODE	Error Code
DUP_TEACHING_PERIOD_ID	Duplicate Teaching Period ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
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_PE_IMMU_DTL_INT	contains the person immunization details to be imported to IGS_PE_IMMU_DTLS.
Column Name	Descritpion
INTERFACE_IMMU_DTLS_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
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	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.
INTERFACE_ID	Interface ID
ATTRIBUTE14	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE15	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE16	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE17	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE18	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE19	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE20	Standard Attribute Column, meant for descriptive flex field.
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.
IMMUNIZATION_CODE	Immunization Type (Lookup Code)
STATUS_CODE	Immunization Status (Lookup Code)
START_DATE	Start Date
END_DATE	End Date
MATCH_IND	Match indicator.
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
ERROR_CODE	Error Code
DUP_IMMU_DETAILS_ID	Duplicate Immunization Details ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs

Student System - IGS_PE_SN_CONCT_INT	contains the person special needs contact to be imported to IGS_PE_SN_CONTACT.
Column Name	Descritpion
INTERFACE_DISABLTY_ID	Interface ID
CONTACT_NAME	Contact Name
CONTACT_DATE	Contact Date
COMMENTS	Comments
MATCH_IND	Match Indicator.
STATUS	1 - Completed 2 - Pending 3 - Error 4 - Warning
ERROR_CODE	Error Code
DUP_SN_CONTACT_ID	Duplicate Special Needs Contact ID
INTERFACE_SN_CONTACT_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
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
INTERFACE_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.

Student System - IGS_PE_SN_SRVCE_INT	contains the person special needs/service records to be imported to IGS_PE_SN_SERVICE.
Column Name	Descritpion
INTERFACE_DISABLTY_ID	Interface ID
END_DT	End Date
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.
SPECIAL_SERVICE_CODE	Special Service Code
DOCUMENTED_IND	Documented Indicator
MATCH_IND	Match indicator.
STATUS	1 - Completed2 - Pending3 - Error4 - Warning
ERROR_CODE	Error Code
DUP_SN_SERVICE_ID	Duplicate Special Needs Service ID
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
INTERFACE_SN_SERVICE_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
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
SPECIAL_SERVICE_CD	Special service code.
START_DT	Start Date

Student System - IGS_PE_CREDENTIALS	Holds credential details for a Person
Column Name	Descritpion
CREDENTIAL_ID	Unique Identifier for Person Credentials
RECOMMENDER_ORGANIZATION	Recommender 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
RATING_CODE	Rating code
PERSON_ID	Person Identifier
CREDENTIAL_TYPE_ID	Credential Type Id
DATE_RECEIVED	Date Received
RATING	OBSOLETED. Rating
REVIEWER_ID	Reviewer Identifier
REVIEWER_NOTES	Reviewer Notes
RECOMMENDER_NAME	Recommender Name
RECOMMENDER_TITLE	Recommender Title

Student System - IGS_PE_TYP_RSP_DFLT	Contains the mapping of System Person Types with Responsibility.
Column Name	Descritpion
S_PERSON_TYPE	System Person Type defined for Student System.
RESPONSIBILITY_KEY	Responsibility ID that the Person Type is assigned.
APPLICATION_SHORT_NAME	Application Short Name that Responsibility falls under.
CREATED_BY	Standard WHO column.
CREATION_DATE	Standard WHO column.
LAST_UPDATE_LOGIN	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
LAST_UPDATE_DATE	Standard WHO column.

Student System - IGS_PR_INST_STAT	Defines the Statistic Types which will be used by a particular Installation
Column Name	Descritpion
STAT_TYPE	Statistic Type
INCLUDE_OTHER_IND	Include Other Institution Advanced Standing Units (Y/N)
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
DISPLAY_ORDER	Display Order for Statistic Type
TIMEFRAME	Timeframe (Period, Cumulative or Both)
STANDARD_IND	Used as Standard Indicator (Y/N)
PROGRESSION_IND	OBSOLETE
FIN_AID_IND	OBSOLETE
DISPLAY_IND	Display in the Inquiry Form (Y/N)
INCLUDE_STANDARD_IND	Include Standard Units (Y/N)
INCLUDE_LOCAL_IND	Include Local Institution Advanced Standing Units (Y/N)

Student System - IGS_PR_INST_STA_REF	Defines which Unit Reference Codes are Included or Excluded for a user defined Institution Statistic Type
Column Name	Descritpion
STAT_TYPE	Statistic Type
UNIT_REF_CD	Indicates which Unit Reference Code is to be Included or Excluded from Calculation
INCLUDE_OR_EXCLUDE	Indicates whether to Include or Exclude units associated with Reference Codes from calculation of Credit Points and 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
REFERENCE_CD_TYPE	The reference code type

Student System - IGS_PR_ORG_STAT	Defines the Details of what a particular user defined Organizational Unit Statistic Type Includes and is used for
Column Name	Descritpion
STAT_TYPE	Statistic Type
INCLUDE_LOCAL_IND	Include Local Institution Advanced Units (Y/N)
INCLUDE_OTHER_IND	Include Other Institution Advanced Units (Y/N)
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ORG_UNIT_CD	Organizational Unit code
DISPLAY_ORDER	Display Order for the Statistic Type
TIMEFRAME	Timeframe (Period, Cumulative or Both)
STANDARD_IND	Use as Standard Statistics (Y/N)
PROGRESSION_IND	OBSOLETE
FIN_AID_IND	OBSOLETE
DISPLAY_IND	Display in Inquiry Form
INCLUDE_STANDARD_IND	Include Standard Units (Y/N)

Student System - IGS_PR_ORG_STAT_REF	Defines which unit Reference Code is Included or Excluded for a user defined Organizational Unit Statistic Type
Column Name	Descritpion
STAT_TYPE	Statistic Type
ORG_UNIT_CD	Organizational Unit Code
UNIT_REF_CD	Indicates which Unit Reference Code is to be Included or Excluded from Calculation
INCLUDE_OR_EXCLUDE	Indicates whether to Include or Exclude units associated with Reference Codes from calculation of Credit Points and 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_PR_OU_AWD	Stores the awards associated with the rule for positive outcomes.
Column Name	Descritpion
PROGRESSION_RULE_CAT	Progression rule Category.
PRA_SEQUENCE_NUMBER	Progression rule application sequence number.
PRO_SEQUENCE_NUMBER	Progression rule outcome sequence number.
AWARD_CD	Award Code
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PR_COHINST_RANK	Stores Class Rank Cohort Instance Rank
Column Name	Descritpion
COURSE_CD	Program Code of the student attempt
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.
COHORT_NAME	Name of the Cohort
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
LOAD_CAL_TYPE	Calendar type to define the cohort instance
LOAD_CI_SEQUENCE_NUMBER	Sequence Number to define the cohort instance
AS_OF_RANK_GPA	The as of GPA calculated at the time of ranking
COHORT_RANK	Rank in the given cohort
COHORT_OVERRIDE_RANK	Overridden rank in the given cohort
COMMENTS	Comments for overriding the cohort rank
PERSON_ID	Person Id of student
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PR_COHORT	Stores Class Rank Cohort
Column Name	Descritpion
DESCRIPTION	Description of the Cohort
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_UNIT_CD	Organizational Unit Name to which cohort belongs
STAT_TYPE	Statistic type used for calculating GPA
TIMEFRAME	Timeframe i.e. either Cumulative or Term
DFLT_DISPLAY_TYPE	Display format for the rank. Default value is n of N.
DENSE_RANK_IND	Indicates whether to allow dense rank or not. Default value is N.
INCL_ON_TRANSCRIPT_IND	Indicates whether to show rank on transcript or not. Default value is Y.
INCL_ON_STUD_ACAD_HIST_IND	Indicates whether to show rank on student Academic History page. Default value is Y.
COHORT_NAME	Name of the Cohort
RULE_SEQUENCE_NUMBER	Rule Sequence Number for the rule defined for the cohort
CLOSED_IND	Indicates whether the cohort is closed or not
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PR_COHORT_INST	Stores Class Rank Cohort Instances
Column Name	Descritpion
LOAD_CAL_TYPE	Calendar type to define the cohort instance
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.
LOAD_CI_SEQUENCE_NUMBER	Sequence Number to define the cohort instance
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
COHORT_STATUS	Status of cohort instance either Working or frozen
RANK_STATUS	Status of rank either Working or final
RUN_DATE	Date on which Ranking was done
COHORT_NAME	Name of the Cohort
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PR_OU_FND	The entity stores the exclude fund codes related to a particular progression rule outcome
Column Name	Descritpion
PROGRESSION_RULE_CAT	Progression rule category
PRA_SEQUENCE_NUMBER	Progression rule category sequence number.
PRO_SEQUENCE_NUMBER	Progression Outcome Sequence Number.
FUND_CODE	Indicates the excluded Financial Aid Fund Code related to a particular progression rule outcome.
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_PR_LGCY_SPO_INT	Interface table for Progression Outcomes
Column Name	Descritpion
LEGACY_PR_SPO_INT_ID	Unique identifier of the PR Progression Outcome record
DECISION_DT	Date on which the decision to recommend, approve, waive, cancel or remove the progression outcome was taken.
DECISION_ORG_UNIT_CD	Code of the organizational unit responsible for the current progression outcome decision status.
SHOW_CAUSE_EXPIRY_DT	Expiry date of the show cause period.
SHOW_CAUSE_DT	The date on which the student submitted their show cause application.
SHOW_CAUSE_OUTCOME_DT	The date on which the decision was made in respect of the students show cause application
SHOW_CAUSE_OUTCOME_TYPE	Outcome of the students show cause application.
APPEAL_EXPIRY_DT	The expiry date for lodgement of an appeal.
APPEAL_DT	Date on which the student raised an appeal against the outcome.
APPEAL_OUTCOME_DT	The date on which the decision was made in respect of the students appeal application
APPEAL_OUTCOME_TYPE	Outcome of the students appeal application.
BATCH_ID	Batch Identifier
ENCMB_PROGRAM_GROUP_CD	Encumbered Program group code from which the outcome is excluding.
RESTRICTED_ENROLMENT_CP	Credit points the program attempt is restricted to due to the progression outcome
RESTRICTED_ATTENDANCE_TYPE	Attendance type the program attempt is restricted to due to the progression outcome.
COMMENTS	Miscellaneous textual comments about the outcome.
SHOW_CAUSE_COMMENTS	Textual comments about the students show cause application
APPEAL_COMMENTS	Textual comments about the students appeal application
EXPIRY_DT	The expiry date of the outcome.
AWARD_CD	The award code granted to the student as a result of the outcome.
SPO_PROGRAM_CD	The program from which the outcome is suspending or excluding the student.
UNIT_CD	The unit code from which the outcome is excluding the student from, or requiring them to take.
PERSON_NUMBER	Person number of the progression outcome.
S_UNIT_TYPE	Indicates whether the unit is an exclusion or requirement.
UNIT_SET_CD	The Unit Set code from which the student is to be excluded.
US_VERSION_NUMBER	The Version number of the unit set applicable at the time the exclusion is applied.
IMPORT_STATUS	Record Import Status , Allowable values are U - Unprocessed (Default)R - Ready For ProcessingE - ErrorW - WarningI - Imported
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard concurrent program who column
PROGRAM_CD	Program code to which the progression outcome applies.
PROGRAM_ID	Standard concurrent program who column
PROGRAM_APPLICATION_ID	Standard concurrent program who column
PROGRAM_UPDATE_DATE	Standard concurrent program who column
FUND_CODE	Indicates the excluded Financial Aid Fund Code related to a particular Student Progression Outcome.
PRG_CAL_ALTERNATE_CODE	Progression calendar type in which the outcome is to be applied.
PROGRESSION_OUTCOME_TYPE	The code of the progression rule outcome type.
DURATION	Duration of the outcome, expressed in progression periods.
DURATION_TYPE	Outcome duration type.
DECISION_STATUS	Decision status of the outcome.

Student System - IGS_PR_LGY_CLSR_INT	Interface table to store the Class Rank legacy data
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
AS_OF_RANK_GPA	The GPA at the time of ranking.
IMPORT_STATUS	Records Import status, allowable values are U - Unprocessed (Default)R - Ready for ReprocessingE - ErrorW - WarningI - Imported
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard concurrent program who column
PROGRAM_ID	Standard concurrent program who column
PROGRAM_APPLICATION_ID	Standard concurrent program who column
LEGACY_CLS_RANK_INT_ID	Unique identifier of the legacy class rank details record.
PROGRAM_UPDATE_DATE	Standard concurrent program who column
PERSON_NUMBER	The person number of the ranking.
PROGRAM_CD	The program code of the student being ranked.
COHORT_NAME	The cohort name to which the ranking belongs.
CALENDAR_ALTERNATE_CODE	The alternate code of the calendar period in which the ranking is performed. This is an academic or term (load) calendar.
COHORT_RANK	The rank applied to the student.
COHORT_OVERRIDE_RANK	The overridden Rank
COMMENTS	The override rank applied to the student, where applicable.

Student System - IGS_PE_FUND_EXCL	Person Hold Effect Fund Exclusion Details.
Column Name	Descritpion
PERSON_ID	Person identifier
ENCUMBRANCE_TYPE	Hold type.
PEN_START_DT	Hold Type Start Date
S_ENCMB_EFFECT_TYPE	System Hold Effect Type
PEE_START_DT	Hold Effect Start Date
PEE_SEQUENCE_NUMBER	Hold Effect Sequence Number
FUND_CODE	Fund Code
PFE_START_DT	Person Fund Exclusion Start Date
FUND_EXCL_ID	Unique identifier for the record.
EXPIRY_DT	Person Fund Exclusion Expiration Date
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_PE_PER_TYPE_MAP	Stores mapping defined between OSS and HR Person Types
Column Name	Descritpion
SYSTEM_TYPE	System Person Type mapped to the user defined person type in Oracle Student System
PER_PERSON_TYPE_ID	Unique identifier of the Person Type defined in Oracle HRMS.
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_TYPE_CODE	User Defined Person Type in Oracle Student System

Student System - IGS_PE_RES_DTLS_INT	Interface Entity to store information about the residency details of a person which need to be imported.
Column Name	Descritpion
INTERFACE_RES_ID	Unique Identifier for the record
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.
RESIDENCY_STATUS_CD	Residency Status code
ATTRIBUTE11	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE12	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE13	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE14	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE15	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE16	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE17	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE18	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE19	Standard Attribute Column, meant for descriptive flex field.
ATTRIBUTE20	Standard Attribute Column, meant for descriptive flex field.
RESIDENCY_CLASS_CD	Residency Class code
STATUS	Stores the status of the interface record processing.
MATCH_IND	Match indicator. The following indicators are used for this process.
ERROR_CODE	Records the error codes for 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.
CAL_TYPE	Calendar Type
SEQUENCE_NUMBER	Calendar Sequence Number
EVALUATION_DATE	Evaluation Date
EVALUATOR	Evaluation Identifier
START_DT	No longer used
END_DT	No longer used
COMMENTS	Comments
INTERFACE_ID	Interface record 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
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
ATTRIBUTE_CATEGORY	Stores the context for flexfield

Student System - IGS_PE_ACT_SITE	Exchange Visitor Site of Activity
Column Name	Descritpion
ACTIVITY_SITE_CD	Site of Activity Code
LOCATION_ID	Location ID of address
START_DATE	Start Date
END_DATE	End Date
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
PERSON_ID	Person ID
LAST_UPDATE_LOGIN	Standard Who Column
REMARKS	Remarks on the site of activity updates being performed.
PRIMARY_FLAG	To indicate that a particular Site of Activity is Primary

Student System - IGS_PE_EV_FORM	This table is used to gather input that has been given by the user via the EV form. This is the main table for storing information on the student
Column Name	Descritpion
PERSONAL_FUNDS_AMT	Personal Funds for the student
EV_FORM_NUMBER	Exchange Visitor Form Number
PERSON_ID	Person ID for student
PRGM_START_DATE	Program Start Date
PRGM_END_DATE	Program End Date
LAST_REPRINT_DATE	Last time form was reprinted
REPRINT_REASON	Reprint Reason Code
REPRINT_REMARKS	Reprint Remarks
POSITION_CODE	Position Code of Exchange Visitor
POSITION_REMARKS	Position remarks
SUBJECT_FIELD_CODE	Subject code for the field of study
SUBJECT_FIELD_REMARKS	Subject remarks on field of study
MATRICULATION	Exchange Visitor matriculation
PRINT_FORM	Flag indicating if the form is to be printed
REMARKS	General Remarks
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CATEGORY_CODE	Category code for the Exchange Visitor
INIT_PRGM_START_DATE	The exchange visitor initial program date
NO_SHOW_FLAG	Used to capture information if an EV have not reported for program
GOVT_ORG1_OTHR_NAME	Capture the name of the organization if the funding org is selected as OTHER
FORM_EFFECTIVE_DATE	Form Effective Date
GOVT_ORG2_OTHR_NAME	Capture the name of the organization if the funding org is selected as OTHER
INTL_ORG1_OTHR_NAME	Capture the name of the organization if the funding org is selected as OTHER
INTL_ORG2_OTHR_NAME	Capture the name of the organization if the funding org is selected as OTHER
OTHER_GOVT_NAME	Captures the name of the other govt organization.
SEVIS_SCHOOL_IDENTIFIER	Party Id for a School Identifier
FORM_STATUS	Status of the form
CREATE_REASON	Reason for Exchange Visitor Form being created
IS_VALID	Flag indicating if student is valid
PRGM_SPONSOR_AMT	Program sponsor for the student
GOVT_ORG1_AMT	Financial support in US dollars for Exchange Visitor
GOVT_ORG1_CODE	US Government Agency code supporting
GOVT_ORG2_AMT	Financial support in US dollars for Exchange Visitor
EV_FORM_ID	A unique identifier
GOVT_ORG2_CODE	US Government Agency code supporting
INTL_ORG1_AMT	Financial support in US dollars for Exchange Visitor
INTL_ORG1_CODE	International government agency code supporting
INTL_ORG2_AMT	Financial support in US dollars for Exchange Visitor
INTL_ORG2_CODE	International government agency code supporting
EV_GOVT_AMT	Financial support in US dollars for Exchange Visitor from the Exchange Visitors country
BI_NATNL_COM_AMT	Financial support in US dollars for Exchange Visitor from Binational Commission of Exchange Visitors country
OTHER_GOVT_AMT	Financial support in US dollars for Exchange Visitor from all other organizations providing support

Student System - IGS_PE_EV_FORM_STAT	This table is used to determine the status of the form that has been entered by the student.
Column Name	Descritpion
EV_FORM_ID	EV form ID for Student
ACTION_DATE	Date of Action taken
ACTION_TYPE	Type of Action taken on status of form
PRGM_START_DATE	Exchange Visitor Program start date
PRGM_END_DATE	Exchange Visitor Program end date
REMARKS	Remarks on the action taken
TERMINATION_REASON	Termination Reason code for student
END_PROGRAM_REASON	End of Program reason code for student
EV_FORM_STAT_ID	Unique ID
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Student System - IGS_PE_VISA	This is the table that will contain all information related to the visa
Column Name	Descritpion
PERSON_ID	Person ID the VISA information is related to
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column
ATTRIBUTE11	Standard Attribute Column
ATTRIBUTE12	Standard Attribute Column
ATTRIBUTE13	Standard Attribute Column
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
ATTRIBUTE16	Standard Attribute Column
VISA_TYPE	Visa Type that the person has
ATTRIBUTE17	Standard Attribute Column
ATTRIBUTE18	Standard Attribute Column
ATTRIBUTE19	Standard Attribute Column
ATTRIBUTE20	Standard Attribute Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
VISA_NUMBER	Number on Visa
VISA_ISSUING_COUNTRY	Country Code where the visa was issued.
VISA_ISSUE_DATE	Date visa was issued
VISA_EXPIRY_DATE	Date visa expires
VISA_CATEGORY	Category type associated to J Visa Types
VISA_ISSUING_POST	Visa post issued
PASSPORT_ID	Passport that is associated to the Visa.
VISA_ID	A unique identifier
AGENT_ORG_UNIT_CD	International Agent Org Unit Code
AGENT_PERSON_ID	Person ID of the Agent
AGENT_CONTACT_NAME	Agents contact name
ATTRIBUTE_CATEGORY	Standard Context Column
ATTRIBUTE1	Standard Attribute Column
ATTRIBUTE2	Standard Attribute Column
ATTRIBUTE3	Standard Attribute Column
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column

Student System - IGS_PE_VISA_INT	Interface Table for IGS_PE_VISA
Column Name	Descritpion
INTERFACE_ID	Interface ID
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column
ATTRIBUTE11	Standard Attribute Column
ATTRIBUTE12	Standard Attribute Column
ATTRIBUTE13	Standard Attribute Column
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
ATTRIBUTE16	Standard Attribute Column
VISA_TYPE	Visa Type that the person has
ATTRIBUTE17	Standard Attribute Column
ATTRIBUTE18	Standard Attribute Column
ATTRIBUTE19	Standard Attribute Column
ATTRIBUTE20	Standard Attribute Column
MATCH_IND	18- Match occurred and imported values,19- Match exists and retained values,20- Requires review, 21-Match reviewed and to be imported,22- Match reviewed and do not import,23- Match to be reviewed,11- No match
STATUS	1-Completed ,2-Pending
ERROR_CODE	error code
DUP_VISA_ID	Duplicate Visa ID
REQUEST_ID	Standard Who Column for concurrent program
PROGRAM_ID	Standard Who Column for concurrent program
VISA_NUMBER	Number on Visa
PROGRAM_APPLICATION_ID	Standard Who Column for concurrent program
PROGRAM_UPDATE_DATE	Standard Who Column for concurrent program
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
VISA_ISSUING_COUNTRY	Country Code where the visa was issued. Valid values are from lookup type 'PER_US_COUNTRY_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.
VISA_ISSUE_DATE	Date visa was issued
VISA_EXPIRY_DATE	Date visa expires
VISA_CATEGORY	Category type associated to J Visa Types
VISA_ISSUING_POST	Visa post issued
PASSPORT_ID	Passport that is associated to the Visa.
INTERFACE_VISA_ID	A unique identifier
AGENT_ORG_UNIT_CD	International Agent Org Unit Code
AGENT_PERSON_ID	Person ID of the Agent
AGENT_CONTACT_NAME	Agents contact name
ATTRIBUTE_CATEGORY	Standard Context Column
ATTRIBUTE1	Standard Attribute Column
ATTRIBUTE2	Standard Attribute Column
ATTRIBUTE3	Standard Attribute Column
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column

Student System - IGS_PE_VISIT_HISTRY	This table is to keep track of the visits made on visa. This includes the port of entry.
Column Name	Descritpion
CNTRY_ENTRY_FORM_NUM	Form Number that is issued to enter country
ATTRIBUTE13	Standard Attribute Column
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
ATTRIBUTE16	Standard Attribute Column
ATTRIBUTE17	Standard Attribute Column
ATTRIBUTE18	Standard Attribute Column
ATTRIBUTE19	Standard Attribute Column
ATTRIBUTE20	Standard Attribute Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
VISA_ID	Visa ID
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
VISIT_START_DATE	Date entered into country
VISIT_END_DATE	Date that the visit ended
REMARKS	Remarks on port of entry
ATTRIBUTE_CATEGORY	Standard Context Column
ATTRIBUTE1	Standard Attribute Column
ATTRIBUTE2	Standard Attribute Column
PORT_OF_ENTRY	Port that person entered country from
ATTRIBUTE3	Standard Attribute Column
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column
ATTRIBUTE11	Standard Attribute Column
ATTRIBUTE12	Standard Attribute Column

Student System - IGS_PE_VST_HIST_INT	Interface table for IGS_PE_VISIT_HISTRY
Column Name	Descritpion
PORT_OF_ENTRY	Port that person entered country from
ATTRIBUTE12	Standard Attribute Column
ATTRIBUTE13	Standard Attribute Column
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
ATTRIBUTE16	Standard Attribute Column
ATTRIBUTE17	Standard Attribute Column
ATTRIBUTE18	Standard Attribute Column
ATTRIBUTE19	Standard Attribute Column
ATTRIBUTE20	Standard Attribute Column
MATCH_IND	18- Match occurred and imported values,19- Match exists and retained values,20- Requires review ,21-Match reviewed and to be imported,22- Match reviewed and do not import,23- Match to be reviewed,11- No match
CNTRY_ENTRY_FORM_NUM	Form Number that is issued to enter country
STATUS	1-Completed ,2-Pending
ERROR_CODE	Error Code
DUP_PORT_OF_ENTRY	Duplicate Port of Entry
DUP_CNTRY_ENTRY_FORM_NUM	Duplicate Country Entry Form Number
REQUEST_ID	Standard Who Column for concurrent program
PROGRAM_ID	Standard Who Column for concurrent program
PROGRAM_APPLICATION_ID	Standard Who Column for concurrent program
PROGRAM_UPDATE_DATE	Standard Who Column for concurrent program
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
INTERFACE_VISA_ID	Interface Visa ID
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	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.
VISIT_START_DATE	Date entered into country
VISIT_END_DATE	Date that the visit ended
REMARKS	Remarks on port of entry
ATTRIBUTE_CATEGORY	Standard Context Column
ATTRIBUTE1	Standard Attribute Column
INTERFACE_VISIT_HISTRY_ID	A Unique Identifier
ATTRIBUTE2	Standard Attribute Column
ATTRIBUTE3	Standard Attribute Column
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column
ATTRIBUTE11	Standard Attribute Column

Student System - IGS_PE_DEPD_ACTIVE	Person Dependent Relationship Active Information
Column Name	Descritpion
ACTION_CODE	Terminate or Activate
EFFECTIVE_DATE	Action Effective Date
REASON_CODE	(Termination) Reason
REMARKS	Remarks
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
RELATIONSHIP_ID	Relationship ID
LAST_UPDATE_LOGIN	Standard Who Column
OTHER_REASON_REMARKS	Reason for the OTHER termination reason or end dependent reason.

Student System - IGS_PE_PASSPORT	Table that holds all passport related information
Column Name	Descritpion
PERSON_ID	Person ID
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
ATTRIBUTE16	Standard Attribute Column
ATTRIBUTE17	Standard Attribute Column
ATTRIBUTE18	Standard Attribute Column
ATTRIBUTE19	Standard Attribute Column
ATTRIBUTE20	Standard Attribute Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
PASSPORT_NUMBER	Passport Number
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PASSPORT_EXPIRY_DATE	Date Passport Expires
PASSPORT_CNTRY_CODE	Passport Country Code
ATTRIBUTE_CATEGORY	Standard Context Column
ATTRIBUTE1	Standard Attribute Column
ATTRIBUTE2	Standard Attribute Column
ATTRIBUTE3	Standard Attribute Column
PASSPORT_ID	A unique identifier
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column
ATTRIBUTE11	Standard Attribute Column
ATTRIBUTE12	Standard Attribute Column
ATTRIBUTE13	Standard Attribute Column

Student System - IGS_PE_PASSPORT_INT	Interface Table for IGS_PE_PASSPORT
Column Name	Descritpion
INTERFACE_ID	Interface ID
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
ATTRIBUTE16	Standard Attribute Column
ATTRIBUTE17	Standard Attribute Column
ATTRIBUTE18	Standard Attribute Column
ATTRIBUTE19	Standard Attribute Column
ATTRIBUTE20	Standard Attribute Column
MATCH_IND	18- Match occurred and imported values,19- Match exists and retained values,20- Requires review ,21-Match reviewed and to be imported,22- Match reviewed and do not import,23- Match to be reviewed,11- No match
STATUS	1-Completed ,2-Pending
ERROR_CODE	Error Code
PASSPORT_NUMBER	Passport Number
DUP_PASSPORT_ID	Duplicate Passport ID
REQUEST_ID	Standard Who Column for concurrent program
PROGRAM_ID	Standard Who Column for concurrent program
PROGRAM_APPLICATION_ID	Standard Who Column for concurrent program
PROGRAM_UPDATE_DATE	Standard Who Column for concurrent program
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PASSPORT_EXPIRY_DATE	Date Passport Expires
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.
PASSPORT_CNTRY_CODE	Passport Country Code
ATTRIBUTE_CATEGORY	Standard Context Column
ATTRIBUTE1	Standard Attribute Column
ATTRIBUTE2	Standard Attribute Column
ATTRIBUTE3	Standard Attribute Column
INTERFACE_PASSPORT_ID	A unique identifier
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column
ATTRIBUTE11	Standard Attribute Column
ATTRIBUTE12	Standard Attribute Column
ATTRIBUTE13	Standard Attribute Column

Student System - IGS_PE_DYNAMIC_PERSID	Obsolete
Column Name	Descritpion
WORKBOOK_NAME	Name From Discoverer
ATTRIBUTE11	Standard Attribute Column
ATTRIBUTE12	Standard Attribute Column
ATTRIBUTE13	Standard Attribute Column
ATTRIBUTE14	Standard Attribute Column
ATTRIBUTE15	Standard Attribute Column
WORKSHEET_NAME	Name From Discoverer
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
GROUP_CD	Concatenate Value of Workbook Name and Worksheet Name
DESCRIPTION	Concatenate Value of Workbook Name and Worksheet Name
CREATOR_PERSON_ID	Workbook Owner
CLOSED_IND	Close Indicator Always 'N'
COMMENTS	Take Description from Discoverer for Business Area
ATTRIBUTE_CATEGORY	Standard Context Column
GROUP_ID	Sequence ID
ATTRIBUTE1	Standard Attribute Column
ATTRIBUTE2	Standard Attribute Column
ATTRIBUTE3	Standard Attribute Column
ATTRIBUTE4	Standard Attribute Column
ATTRIBUTE5	Standard Attribute Column
ATTRIBUTE6	Standard Attribute Column
ATTRIBUTE7	Standard Attribute Column
ATTRIBUTE8	Standard Attribute Column
ATTRIBUTE9	Standard Attribute Column
ATTRIBUTE10	Standard Attribute Column

Student System - IGS_PE_DYNAMIC_SQL	Obsolete
Column Name	Descritpion
SEGMENT_SEQUENCE	SQL Segment Number
SQL_SEGMENT	Static SQL Statement (Segment Value) from Discoverer
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
GROUP_ID	Group ID

Student System - IGS_PE_NONIMG_EMPL	This table is used for the holding of all student related employment information that is required by SEVIS
Column Name	Descritpion
NONIMG_FORM_ID	Non-Immigrant Form ID for student
EMPL_TYPE	Employment type code
RECOMMEND_EMPL	Recommend Employment
RESCIND_EMPL	Rescind Employment
REMARKS	Remarks on Student employment
EMPL_START_DATE	Employment Start date for the student
EMPL_END_DATE	Employment End date for the student
COURSE_RELEVANCE	Relevant student employment to course
NONIMG_EMPL_ID	A unique identifier
EMPL_TIME	Employment type of time FULL or PART
EMPL_PARTY_ID	Employer party ID.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PRINT_FLAG	To indicate that a NON IMG form is to be printed
ACTION_CODE	To capture the action code means, if it is a new record, to be deleted , to be modified. Accordingly this record will go in XML under a particular element.

Student System - IGS_PE_NONIMG_FORM	This table is to be used for storing the information of students that fall into the non-immigrant status based on Visa Type. The information here will be passed along to SEVIS.
Column Name	Descritpion
PERSON_ID	Party ID for person in OSS
OTHER_EXP_DESC	Other expenses description
SCHOOL_FUNDS_AMT	School funds amount
SCHOOL_FUNDS_DESC	School funds description for student
OTHER_FUNDS_AMT	Other funds amount
OTHER_FUNDS_DESC	Other funds description for student
EMPL_FUNDS_AMT	Employment funds amount
REMARKS	Remarks for student
CURR_SESSION_END_DATE	Current school sessions end date
NEXT_SESSION_START_DATE	Next school sessions start date
PRINT_FORM	Flag to indicate if the form is to be printed
TRANSFER_FROM_SCHOOL	School student transferred from
OTHER_REASON	Other reason for coming to school
LAST_REPRINT_DATE	Last date the form was requested reprint
REPRINT_REASON	Reason code for the reprint of form
REPRINT_REMARKS	Remarks on the reason code for reprint
SECONDARY_MAJOR	Secondary major for the student
MINOR	Minor for the student
ENGLISH_REQD_MET	English requirement met flag
NOT_REQD_REASON	Reason why requirement not needed to be met
CREATION_DATE	Standard Who Column
FORM_EFFECTIVE_DATE	Form Effective Date
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
EDUC_LVL_REMARKS	Education level remarks that are optional but is required if Education Level chosen is OTHER.
VISA_TYPE	Visa Type the student applies for.
LAST_SESSION_FLAG	To indicate that a NON IMG is in his last session
ADJUDICATED_FLAG	To indicate that a NON IMG has been Adjudicated
SEVIS_SCHOOL_IDENTIFIER	Party Id for a school
FORM_STATUS	Status of the form
ACAD_TERM_LENGTH	Length of the academic term
TUITION_AMT	Tuition expense for the student
LIVING_EXP_AMT	Living Expenses for the student
PERSONAL_FUNDS_AMT	Personal Funds for the student
NONIMG_FORM_ID	A unique identifier
ISSUE_REASON	Issue reason for the Form
COMMUTER_IND	Commuter Indicator
ENGLISH_REQD	English required for the student or not flag
LENGTH_OF_STUDY	Length of time for the student to finish
PRGM_START_DATE	Date that the program is starting
PRGM_END_DATE	Date that the program is ending
PRIMARY_MAJOR	Students primary major of study
EDUCATION_LEVEL	Students level of education
DEPDNT_EXP_AMT	Dependants expenses amount
OTHER_EXP_AMT	Any other expenses amount

Student System - IGS_PE_NONIMG_STAT	This table is used to gather the information related to the student status
Column Name	Descritpion
NONIMG_FORM_ID	Non-Immigrant Form ID for student
ACTION_DATE	Date that the action was taken on status
ACTION_TYPE	Type of action taken on student status
PRGM_START_DATE	New Program start date
PRGM_END_DATE	New Program end date
REMARKS	Remarks on student for action taken
TERMINATION_REASON	Reason why student has been terminated
CREATION_DATE	Standard Who Column
NONIMG_STAT_ID	A unique identifier
CREATED_BY	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PRINT_FLAG	To indicate that a print is required
CANCEL_FLAG	To indicate that a Program Extension is canceled.

Student System - IGS_PE_RACE	Stores the Race information of a person
Column Name	Descritpion
RACE_CD	Race 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
PERSON_ID	Unique Identifier of a Person

Student System - IGS_PE_RACE_INT	Stores the Race information of a person that will be imported to the system table IGS_PE_RACE
Column Name	Descritpion
INTERFACE_ID	Interface ID of the parent record.
RACE_CD	Race code
STATUS	1- Completed, 2-Pending, 3- Error, 4- Warning
MATCH_IND	Match Indicator
ERROR_CODE	Error code
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_RACE_ID	Unique Identifier of a Person
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
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.

Student System - IGS_PE_HZ_REL	Table to record family details of a person
Column Name	Descritpion
RELATIONSHIP_ID	Foreign Key from HZ_RELATIONSHIPS
REP_ALUMNI	Alumni information of the Relation reported by related person
CREATED_BY	Standar WHO Columns
CREATION_DATE	Standar WHO Columns
LAST_UPDATED_BY	Standar WHO Columns
LAST_UPDATE_DATE	Standar WHO Columns
LAST_UPDATE_LOGIN	Standar WHO Columns
EMERGENCY_CONTACT_FLAG	Flag indicating whether the person is an emergency contact
DIRECTIONAL_FLAG	Foreign Key from HZ_RELATIONSHIPS
PRIMARY	Indicator to indicate whether the record is primary
SECONDARY	Indicator to indicate whether the record is secondary
JOINT_SALUTATION	Salutation to be used during letter generation
NEXT_TO_KIN	Next of Kin
REP_FACULTY	Faculty Information of the Relation reported by related person
REP_STAFF	Staff Information of the relation reported by related person
REP_STUDENT	Student information of the Relation reported by related person

Student System - IGS_PE_TYPE_INT	Stores the Person Type Instances information of a person that will be imported to the transactional table IGS_PE_TYP_INSTANCES_ALL
Column Name	Descritpion
INTERFACE_ID	Interface ID of the parent record from table IGS_AD_INTERFACE_ALL.
EMPLMNT_CATEGORY_CODE	Employment Category of the Person
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_TYPE_CODE	Person Type Code. The valid values are as retrieved by the following select statement.SELECT person_type_code FROM igs_pe_person_types WHERE closed_ind = 'N' AND system_type IN ('ADVISOR', 'EVALUATOR', 'EXTERNAL_CONTACT', 'FACULTY', 'STAFF'
START_DATE	Start Date of the person type instance. It must not be less then the date of birth (if available) of the person.
END_DATE	End Date of the person type instance.If provided must be greater start date above.
STATUS	1 - Completed, 2 - Pending, 3 - Error, 4 - Warning
MATCH_IND	Match IndicatorValid values areSELECT lookup_code,meaning FROM igs_lookup_values WHERE lookup_type = 'IMPORT_MATCH_IND' AND enabled_flag = 'Y'
ERROR_CODE	Error Code
DUP_TYPE_INSTANCE_ID	Type Instance ID of the Duplicate record
INTERFACE_PERSON_TYPE_ID	Sequence generated unique Identifier of a Person Type interface record. Sequence IGS_PE_TYPE_INT_S should be used for this.
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
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs

Student System - IGS_PE_OFFICE_HRS	Extension table to HZ_CONTACT_PREFERENCES. This will be used to store office hours for a Staff, Faculty.
Column Name	Descritpion
CONTACT_PREFERENCE_ID	Parent Contact Preference Identifier
DAY_OF_WEEK_CODE	Day of the week
START_TM_DATE	Start time of visit, will be storing Date and Time component.
END_TM_DATE	End time of visit, will be storing Date and Time component.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
OFFICE_HRS_ID	Unique identifier for Office Hours.
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_PE_DYN_SQLSEGS	Contains info of SQL segments from Discover
Column Name	Descritpion
FILE_NAME	File Name
SEG_SEQUENCE_NUM	Segment Sequence Number
SQL_SEGMENT	SQL Segment Text
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
SQLSEGS_ID	Unique identifier for SQL Segments.

Student System - IGS_PE_CRED_INT	This interface table holds the credentials details that need to get imported for a person
Column Name	Descritpion
INTERFACE_CRED_ID	A unique identifier to identify each row in this table
RECOMMENDER_ORGANIZATION	Recommender Organization
MATCH_IND	Match indicator for the interface record20 - Match To Be Reviewed For Discrepancy21 - Match reviewed and to be imported22 - Match reviewed and do not import23 - Match reviewed, no discrepancy and retaining existing values
ERROR_CODE	Error Code
STATUS	Status of the interface record
DUP_CREDENTIAL_ID	Duplicate credentials 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
INTERFACE_ID	Interface identifier
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the logic in the import process, and should not be populated by the user.
ERROR_TEXT	Error Text
CREDENTIAL_TYPE_ID	Credential Type Id CREDENTIAL_TYPE_ID that is selected from SELECT CREDENTIAL_TYPE_ID FROM IGS_AD_CRED_TYPES WHERE CLOSED_IND = 'N'
DATE_RECEIVED	Date Received It should not be greater than system date
RATING_CODE	Rating Code, Rating code that is selected from SELECT LOOKUP_CODE FROM IGS_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PE_CRE_RATING' AND NVL(CLOSED_IND, 'N') = 'N' AND ENABLED_FLAG = 'Y'
REVIEWER_ID	Reviewer person id REVIEWER_ID that is selected from SELECT PTI.PERSON_ID FROM IGS_PE_PERSON_TYPES PT,IGS_PE_TYP_INSTANCES PTI WHERE PTI.PERSON_TYPE_CODE = PT.PERSON_TYPE_CODE AND PT.SYSTEM_TYPE = 'STAFF' AND SYSDATE BETWEEN PTI.START_DA
REVIEWER_NOTES	Reviewer Notes
RECOMMENDER_NAME	Recommender Name
RECOMMENDER_TITLE	Recommender Title

Student System - IGS_PE_RES_DTLS_H	No longer used
Column Name	Descritpion
RESIDENCY_CLASS_CD	Residency class code
ATTRIBUTE5	Attribute for Descriptive Flexfields
ATTRIBUTE6	Attribute for Descriptive Flexfields
ATTRIBUTE7	Attribute for Descriptive Flexfields
ATTRIBUTE8	Attribute for Descriptive Flexfields
ATTRIBUTE9	Attribute for Descriptive Flexfields
ATTRIBUTE10	Attribute for Descriptive Flexfields
ATTRIBUTE11	Attribute for Descriptive Flexfields
ATTRIBUTE12	Attribute for Descriptive Flexfields
ATTRIBUTE13	Attribute for Descriptive Flexfields
ATTRIBUTE14	Attribute for Descriptive Flexfields
HISTORY_START_DATE	Residency history start date
ATTRIBUTE15	Attribute for Descriptive Flexfields
ATTRIBUTE16	Attribute for Descriptive Flexfields
ATTRIBUTE17	Attribute for Descriptive Flexfields
ATTRIBUTE18	Attribute for Descriptive Flexfields
ATTRIBUTE19	Attribute for Descriptive Flexfields
ATTRIBUTE20	Attribute for Descriptive Flexfields
RESIDENCY_STATUS_CD	Residency status code
EVALUATION_DATE	Date that residency was evaluated or changed
EVALUATOR	Name of person who evaluated or updated residency
START_DT	Start date of residency
END_DT	End date of residency
COMMENTS	Comments
PERSON_ID	Unique identifier of 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
ATTRIBUTE_CATEGORY	Attribute category
ATTRIBUTE1	Attribute for Descriptive Flexfields
ATTRIBUTE2	Attribute for Descriptive Flexfields
ATTRIBUTE3	Attribute for Descriptive Flexfields
ATTRIBUTE4	Attribute for Descriptive Flexfields

Student System - IGS_PE_PIG_IMPORT_STG	Staging table for person ID group importing
Column Name	Descritpion
PERSON_ID	Person 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
SESSION_ID	Session Id

Student System - IGS_PE_HZ_PTY_SITES	OSS Extension table to HZ_PARTY_SITES. This entity is used to store effective dates of the address of a person, organization or institution
Column Name	Descritpion
START_DATE	Effective Start Date of the Address
END_DATE	Effective End Date of the Address
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
PARTY_SITE_ID	Unique Identifier for the record

Student System - IGS_PE_PRIVACY_INT	Stores the Privacy information of a person that will be imported to the transactional table IGS_PE_PRIV_LEVEL
Column Name	Descritpion
INTERFACE_ID	Interface ID of the parent record from table IGS_AD_INTERFACE_ALL.
PROGRAM_APPLICATION_ID	Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	Standard who column for concurrent programs
DATA_GROUP	Group of data. The valid values are as retrieved by the following select statement.SELECT data_groupFROM igs_pe_data_groupsWHERE closed_ind ='N'
ACTION_CODE	Action that has to be taken or has been taken for a privacy level.Valid values areSELECT lookup_code,meaning FROM igs_lookup_values WHERE lookup_type = ' PERSON_PRIVACY_ACTION' AND enabled_flag = 'Y'
TO_WHOM_CODE	Type of person relationship. Valid valuesSELECT DISTINCT lookup_code FROM igs_pe_privacy_rel_v WHERE related_from_id= OR related_from_id IS NULL
START_DATE	Start Date of the privacy detail. It must not be less than the current date.
END_DATE	End Date of the privacy detail. It must not be less than the start date.
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
STATUS	1 - Completed, 2 - Pending, 3 - Error, 4 - Warning
INTERFACE_PRIVACY_ID	Sequence generated unique Identifier of a Privacy Details interface record.
MATCH_IND	Match Indicator Valid values are SELECT lookup_code,meaning FROM igs_lookup_values WHERE lookup_type = 'IMPORT_MATCH_IND' AND enabled_flag = 'Y'
ERROR_CODE	Error code
DUP_PRIVACY_LEVEL_ID	Privacy Details ID of the Duplicate record
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
REQUEST_ID	Standard who column for concurrent programs
PROGRAM_ID	Standard who column for concurrent programs