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

Student System - IGS_PR_SDT_PR_UNT_ST	This table contains unit sets from which the student will be excluded in a course attempt
Column Name	Descritpion
PERSON_ID	Unique person identifier of the student program attempt applicable to the excluded unit set
VERSION_NUMBER	The version number of the excluded unit set
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	The code of the student program attempt applicable to the excluded unit set
SPO_SEQUENCE_NUMBER	A unique sequence number identifying the student progression outcome
UNIT_SET_CD	Code of the excluded unit set

Student System - IGS_PR_SDT_PS_PR_MSR	This entity describes the result of the calculation of a progression measure against the nominated student course attempt. For example, the result of a Grade Point Average (GPA) or Weighted Average Mark (WAM) calculation.
Column Name	Descritpion
PERSON_ID	Describes the person identifier for whom the progression measure was calculated
VALUE	Describes the actual value achieved for the progression measure
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Describes the program version for that the progression measure was calculated
PRG_CAL_TYPE	Describes the progression calendar type used for progression measure
PRG_CI_SEQUENCE_NUMBER	Describes the progression calendar sequence number in that the measure was calculated
S_PRG_MEASURE_TYPE	Describes the type of the progression measure
CALCULATION_DT	Describes the date that the progression measure was performed

Student System - IGS_PR_STDNT_PR_CK	This table describes a progression rule check performed on the related student course attempt. The check may consist of one or more rules and is stored against a date/time.
Column Name	Descritpion
PERSON_ID	Describes the person identifier on whom the progression check was performed
COURSE_CD	Describes the code from the program attempt on that the check was performed
PRG_CAL_TYPE	Describes the progression calendar type that was checked
PRG_CI_SEQUENCE_NUMBER	Describes the progression calendar sequence number in that the check was performed
RULE_CHECK_DT	Describes the date that the rule check was performed
S_PRG_CHECK_TYPE	Describes the check type of the check. For example, system or manual.
CREATED_BY	Standard Who 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_STDNT_PR_PS	This entity describes the programs that a student is required to enroll as part of their probation due to failing a progression rule.
Column Name	Descritpion
PERSON_ID	The person identifier of the excluded student program attempt
LAST_UPDATE_LOGIN	Standard Who column
SPO_COURSE_CD	The code of the student program attempt for the contextprogression outcome
SPO_SEQUENCE_NUMBER	A unique sequence number describing the student progressionoutcome
COURSE_CD	The code of the excluded program
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_STDNT_PR_UNIT	This entity describes the units that a student is required to enroll in as part of their probation due to failing a progression rule.
Column Name	Descritpion
PERSON_ID	The person identifier of the student program attempt applicable to the excluded or reguired
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	The code of the student program attempt applicable to the excluded or required.
SPO_SEQUENCE_NUMBER	A unique sequence number identifying the student progression outcome
UNIT_CD	The code of the excluded or required unit
S_UNIT_TYPE	A system value of either excluded or require
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_S_CRV_PRG_CAL	This table describes the program version progression calendar configuration options. All progression calendars must be established here (or at system level or organizational unit) for rules within the calendars to be considered.
Column Name	Descritpion
COURSE_CD	The code of the program that the progression calendar applies
VERSION_NUMBER	The version number of the program that the progressioncalendar applies
PRG_CAL_TYPE	Describes the progression calendar type applicable to the course version
STREAM_NUM	A number used to identify a stream, or sequence, of progression calendars within an academic period. Calendars with the same stream number are considered to be a sequential group. For example, institutions that evaluate program progression
SHOW_CAUSE_LENGTH	Describes the length of the show cause period in days within the specified progression calendar type
APPEAL_LENGTH	Describes the length of the appeal period in days within the specified progression calendar type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PR_S_CRV_PRG_CON	This table describes the system configuration parameters for a nominated course version. This record when created overrides the system defaults or organizational unit values which would have been applicable to the course version.
Column Name	Descritpion
COURSE_CD	The code of the program version for that parameters are being specified
APPLY_BEFORE_SHOW_IND	Indicates and specifies if the automated system processing applies progression rule outcomes to the student's enrollment prior to the show cause period commencing or after the period has expired. Typically progression outcomes are applied
APPEAL_IND	Indicates and specifies if the students are permitted to appeal progression outcomes for the nominated program version. Selecting the indicator checked allows appeal.
APPLY_BEFORE_APPEAL_IND	Indicates and specifies if the automated system processing applies progression rule outcomes to the student's enrollment prior to the appeal period commencing or after the period has expired .Typically progression outcomes are applied befor
COUNT_SUS_IN_TIME_IND	Indicates and specifies if the or not periods of suspensionare counted in elapsed time calculations. Selecting the check box ticked includes periods of suspension in calculations.
COUNT_EXC_IN_TIME_IND	Indicates and specifies if the or not periods of exclusion are counted in elapsed time calculations. Selecting the check box ticked includes periods of exclusion in calculations.
CALCULATE_WAM_IND	Indicates and specifies if the a WAM weighted average mark value is calculated for students in the context course version and displayed in relevant reports and system forms. Selecting the checkbox ticked causes a WAM to be calculated .Note
CALCULATE_GPA_IND	Indicates and specifies if the a GPA grade point average value is calculated for students in the context course version and displayed in relevant reports and system windows. Selecting the check box ticked causes a GPA grade point average to
OUTCOME_CHECK_TYPE	Describes the outcome check 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
VERSION_NUMBER	The version of the program that progression parameters are being specified
APPLY_START_DT_ALIAS	Describes the date alias within a progression calendar on that automatic application of progression rules commences.
APPLY_END_DT_ALIAS	Describes the date alias within a progression calendar used to specify the last date that a student program attempt can be automatically checked for the first time within a progression period. Note Once a student program attempt has been ch
END_BENEFIT_DT_ALIAS	Describes the date alias within a progression calendar used to limit the period when progression rule outcomes that would benefit the student are automatically applied to their program attempt. For example, the original application of a pro
END_PENALTY_DT_ALIAS	Describes the date alias within a progression calendar used to limit the period when progression rule outcomes that would have a negative effect on the student's enrollment are automatically applied or recommended for application. For exam
SHOW_CAUSE_CUTOFF_DT_ALIAS	Describes the date alias within a progression period used to define the last date upon that a student can submit a show cause application. By default, no show cause period can end beyond this date for outcomes applied in the period. Note m
APPEAL_CUTOFF_DT_ALIAS	Describes the date alias within a progression period used to define the last date upon that a student can submit an appeal application. By default, no appeal period can end beyond this date for outcomes applied in the period. Note manual ov
SHOW_CAUSE_IND	Indicates and specifies if the concept of a show cause period is permitted for the program version. Selecting the check box ticked indicates that a show cause period is permitted. Typically, progression outcomes are applied only after the

Student System - IGS_PR_S_OU_PRG_CAL	This table describes the organizational unit progression calendar configuration options. All progression calendars must be established here (or at system level or course version level) for rules within the calendars to be considered.
Column Name	Descritpion
ORG_UNIT_CD	The code of the organizational unit to that the progression calendar applies
OU_START_DT	The date from that the organizational unit is effective. The organizational unit is uniquely identified by the combinationof its code and start date.
PRG_CAL_TYPE	Describes the progression calendar type applicable to the organisational unit
STREAM_NUM	A number used to identify a stream, or sequence, of progression calendars within an academic period. Calendars with the same stream number are considered to be a sequential group. For example, institutions that evaluate program progression
SHOW_CAUSE_LENGTH	Describes the length of the show cause period in days within the specified progression calendar type
APPEAL_LENGTH	Describes the length of the appeal period in days within the specified progression calendar type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PR_S_OU_PRG_CONF	This table describes the system configuration parameters for a nominated organizational unit. This record when created overrides the system defaults for only the organizational unit linked.
Column Name	Descritpion
ORG_UNIT_CD	The code of the organizational unit for that parameters are being specified
SHOW_CAUSE_IND	Indicates and specifies if the the concept of a show cause period is permitted for programs within the orgranizational unit. Setting the check box ticked indicates that a show cause period is permitted. Typically progression outcomes are
APPLY_BEFORE_SHOW_IND	Indicates and specifies if the automated system processing applies progression rule outcomes to the student's enrollment prior to the show cause period commencing or after the period has expired. Typically progression outcomes are applied a
APPEAL_IND	Indicates and specifies if the students are permitted to appeal progression outcomes for program that are the responsibility of the context organizational unit. Selecting the indicator checked allows appeal but can be overridden at the pro
APPLY_BEFORE_APPEAL_IND	Indicates that specifies if automated system processing applies progression rule outcomes to the student's enrollment prior to the appeal period commencing or after the period has expired. Typically progression outcomes are applied before t
COUNT_SUS_IN_TIME_IND	Indicates and specifies if the or not periods of suspension are counted in elapsed time calculations. Selecting the check box ticked includes periods of suspension in calculations.
COUNT_EXC_IN_TIME_IND	Indicates and specifies if the or not periods of exclusion are counted in elapsed time calculations. Selecting the check box ticked includes periods of exclusion in calculations.
CALCULATE_WAM_IND	Indicates and specifies if a WAM weighted average mark value is calculated for students in programs that are the responsibility of the context organizational unit and displayed in relevant reports and system windows. Selecting the check box
CALCULATE_GPA_IND	Indicates and specifies if the a GPA grade point average value is calculated for students in courses that are the responsibility of the context organizational unit and displayed in relevant reports and systemwindows. Selecting the check bo
OUTCOME_CHECK_TYPE	Indicates the outcome check type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
OU_START_DT	The date from which the organizational unit is effective. The organizational unit is uniquely identified by the combination of its code and start date.
LAST_UPDATE_LOGIN	Standard Who column
APPLY_START_DT_ALIAS	Describes the date alias within a progression calendar on that automatic application of progression rules commences
APPLY_END_DT_ALIAS	Describes the date alias within a progression calendar used to specify the last date that a student program attempt can be automatically checked for the first time within a progression period. Note Once a student program attempt has been ch
END_BENEFIT_DT_ALIAS	Describes the date alias within a progression calendar used to limit the period when progression rule outcomes that would benefit the student are automatically applied to their program attempt. For example, the original application of a pro
END_PENALTY_DT_ALIAS	Describes the date alias within a progression calendar used to limit the period when progression rule outcomes that would have a negative effect on the student's enrollment are automatically applied or recommended for application. For exam
SHOW_CAUSE_CUTOFF_DT_ALIAS	Describes the date alias within a progression period used to define the last date upon that a student can submit a show cause application. By default, no show cause period can end beyond this date for outcomes applied in the period. Note o
APPEAL_CUTOFF_DT_ALIAS	Describes the date alias within a progression period used to define the last date upon that a student can submit an appeal application. By default, no appeal period can end beyond this date for outcomes applied in the period. Note manual ov

Student System - IGS_PR_S_PRG_CAL	This table describes the standard progression calendar configuration options. All progression calendars must be established here (or at organization unit or course version) for rules within the calendars to be considered.
Column Name	Descritpion
S_CONTROL_NUM	Describes the control number of the record. Always 1
PRG_CAL_TYPE	Describes the progression calendar type to that the configuration applies
STREAM_NUM	Describes the stream number of the progression calendar type. All calendars with the same stream number will be considered a sequential group throughout the academic period. For example, semester 1 & 2 progression calendars should be setup
SHOW_CAUSE_LENGTH	Describes the length of the show cause period within the specified progression calendar type
APPEAL_LENGTH	Describes the length of the appeal period within the specified progression calendar type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PR_S_PRG_CONF	This table describes the system progression configuration information. This information will act as the default settings unless overridden for particular organizational units or course versions.
Column Name	Descritpion
S_CONTROL_NUM	Describes the control number of the configuration record. Always 1.
APPLY_BEFORE_SHOW_IND	Indicates and specifies if the automated system processing applies progression rule outcomes to the student's enrollment prior to the show cause period commencing or after the period has expired. Typically progression outcomes are applied a
APPEAL_IND	Indicates and specifies if the students are permitted to appeal progression outcomes. Selecting the indicator allows appeals. Note the indicator can be overridden at either the organizational unit level or program version level.
APPLY_BEFORE_APPEAL_IND	Indicates and specifies if the automated system processing applies progression rule outcomes to the student's enrollment prior to the appeal period commencing or after the period has expired. Typically progression outcomes are applied befor
COUNT_SUS_IN_TIME_IND	Indicates and specifies if the or not periods of suspensionare counted in elapsed time calculations. Selecting the checkbox includes periods of suspension in calculations.
COUNT_EXC_IN_TIME_IND	Indicates and specifies if the or not periods of exclusion are counted in elapsed time calculations. Selecting the check box includes periods of exclusion in calculations.
CALCULATE_WAM_IND	Indicates and specifies if the a WAM weighted average mark value is calculated for all program of the institution and displayed in relevant reports and system windows. Selecting the check box causes a WAM to be calculated. Note The selectin
CALCULATE_GPA_IND	Indicates and specifies if the a GPA gradepoint average value is calculated for all program of the institution and displayed in relevant reports and system windows. Selecting the check box ticked causes a GPA to be calculated. Note The sel
ENCUMB_END_DT_ALIAS	Indicates the hold end date alias
OUTCOME_CHECK_TYPE	Indicates the outcome check type
CREATED_BY	Standard Who column
EFFECTIVE_END_DT_ALIAS	Describes the cutoff date for discontinuations or early results considered to contribute to the associated progression period.For example, a semester 1 progression period would contain a cutoffdate around the middle of the year signifying t
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
APPLY_START_DT_ALIAS	Describes the date alias within a progression calendar on that automatic application of progression rules commences
APPLY_END_DT_ALIAS	Describes the date alias within a progression calendar used to specify the last date that a student program attempt can be automatically checked for the first time within a progression period. Note Once a student program attempt has been ch
END_BENEFIT_DT_ALIAS	Describes the date alias within a progression calendar used to limit the period when progression rule outcomes that would benefit the student are automatically applied to their program attempt. For example, the original application of a pro
END_PENALTY_DT_ALIAS	Describes the date alias within a progression calendar used to limit the period when progression rule outcomes that would have a negative effect on the student's enrollment are automatically applied or recommended for application. For exam
SHOW_CAUSE_CUTOFF_DT_ALIAS	Describes the date alias within a progression period used to define the last date upon that a student can submit a show cause application. By default, no show cause period can end beyond this date for outcomes applied in the period. Note ov
APPEAL_CUTOFF_DT_ALIAS	Describes the date alias within a progression period used to define the last date upon that a student can submit an appeal application. By default, no appeal period can end beyond this date for outcomes applied in the period. Note manual ov
SHOW_CAUSE_IND	Indicates and specifies if the concept of a show cause period is permitted across the institution. Selecting the check box ticked indicates that a show cause period is permitted. Typically, progression outcomes are applied only after th

Student System - IGS_PR_RU_CA_TYPE_ALL	This table contains the progression calendar types in which the progression rule is to be tested. The testing may be conditional on a starting and number of tests allowing control.
Column Name	Descritpion
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 more th
PRA_SEQUENCE_NUMBER	Describes the progression rule sequence number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
PRG_CAL_TYPE	Describes the calendar type of type progression in that the rule is to be applied
START_SEQUENCE_NUMBER	Sequence number of the context progression calendar instance
END_SEQUENCE_NUMBER	The sequence number of the context progression calendar instance
START_EFFECTIVE_PERIOD	Records the number of the effective progression period for a given student program attempt that the progression rule is first tested in. If progression is evaluated twice a year, setting the start effective period to '2' will cause the rule
NUM_OF_APPLICATIONS	Describes the number of times the rule can be applied to any particular student. For example, setting the number to '2' restricts application of the rule to two progression periods.

Student System - IGS_PR_RU_OU_ALL	This table describes the outcomes applicable to failure of the related progression rule in the way described by the attributes of the outcome. A given rule may have multiple outcomes for any given failure type if required.
Column Name	Descritpion
PROGRESSION_RULE_CAT	Describes the progression rule category to that the outcome applies
DURATION	Describes the duration of the outcome in progression periods. Expulsion and exclusion outcomes must be open ended. Suspension outcomes must have a defined end period. Probation outcomes can be either open ended or have a defined end period.
DURATION_TYPE	The type of outcome duration either effective or normal.The duration of a penalty can be specified either in terms of effectively enrolled progression periods meaning effective or simply as a number of successive progression periods meanin
RANK	Describes the rank of a progression outcome in relation to other outcomes in certain circumstances can be applied as a importance is factored in when streamlining the bulk approval or waiving consequence of failure of the rule. By default,
ENCMB_COURSE_GROUP_CD	The code of a default program group from that the student is to be excluded from as a result of the progression rule outcome. A program group code is only applicable ifthe related hold type results in a program group exclusion EXC_CRS_GP.
PRA_SEQUENCE_NUMBER	Describes the progression rule sequence number to that the outcome applies
RESTRICTED_ENROLMENT_CP	The 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 if the related hold type results in either the RSTR_
RESTRICTED_ATTENDANCE_TYPE	The 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 if the related holdtype results in a RSTR_AT_TY system hold effect
SEQUENCE_NUMBER	Describes the unique sequence number attributed to the outcome
NUMBER_OF_FAILURES	Required number of failures of the nominated progression rule that would cause the associated outcome to apply. The number of failures can be stipulated as either simple repeat failures of the rule repeat or consecutive repeat failures cons
PROGRESSION_OUTCOME_TYPE	The code of a progression outcome type that can be applied as a consequence of failure of the context rule. For example, exclusion or probation. If applicable, progression outcome types are mapped via hold to system hold effects that can be
COMMENTS	A text-based facility for entering additional information about the circumstances under that the context progression rule outcome is applicable.
CREATED_BY	Standard Who 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
LOGICAL_DELETE_DT	Indicates whether the rule outcome is logically deleted or not
APPLY_AUTOMATICALLY_IND	Indicates and specifies if the outcome is applied automatically to the student's program attempt, or simply created as are commended outcome that requires approval prior to its application. For example, probation outcomes are frequently app
PRG_RULE_REPEAT_FAIL_TYPE	Describes the repeat failure type causing the outcome. The type can be stipulated as either simple repeat failures of the rule repeat or consecutive repeat failures consecrpt.
OVERRIDE_SHOW_CAUSE_IND	Indicates and allows the default value of the show cause indicator to be overidden at an individual rule outcome level. For example, if probation rules do not allow a period of show cause prior to the application of outcomes, selecting the
OVERRIDE_APPEAL_IND	Indicates that allows the default value of the appeal indicator to be overridden at an individual rule outcome level. For example, if probation rules do not allow a period of appeal following the application of outcomes, selecting the ind

Student System - IGS_PR_SDT_PR_RU_CK_ALL	This table contains details of progression rules which have been checked against the related student course attempt. Details of each rule are stored along with the result.
Column Name	Descritpion
PERSON_ID	Describes the unique person identifier against whom the check was performed
PASSED_IND	Indicates that specifies if the progression rule was passed or failed
RULE_MESSAGE_TEXT	A text based facilty to add optional message to the rule description 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	Operating unit identifier
COURSE_CD	Describes the code of the program attempt againstthat the rule was tested
PRG_CAL_TYPE	Describes the progression calendar type that the rule was checked
PRG_CI_SEQUENCE_NUMBER	Describes the unique identifer associated with progression calendar in that the rule was checked
RULE_CHECK_DT	Describes the date and time that the progression check was performed
PROGRESSION_RULE_CAT	The institution-defined category of the progression rule that was checked
PRA_SEQUENCE_NUMBER	Describes the unique identifier associated with progression rule

Student System - IGS_PR_STDNT_PR_OU_ALL	This table describes a progression outcome applied to a student, either manually or by the system, as a result of failing a progression rule. This detail is subject to approval, waiving etc. prior to application to the student.
Column Name	Descritpion
PERSON_ID	Describes the person identifier to whom the outcome has been applied
PROGRESSION_OUTCOME_TYPE	The code of the progression rule outcome type exclusion, expulsion, manual, nopenalty, probation or suspension. If applicable, the outcome type is linked to an hold with one or more system defined hold effect types and a restricted credit p
DURATION	Describes the duration of the outcome in progression periods. Expulsion and Exclusion outcomes must be open ended. Suspension outcomes must have a defined end period. Probation outcomes can be either open ended or have a defined end period.
DURATION_TYPE	The type of outcome duration either effective or normal. The duration of a penalty can be specified either in terms of effectively enrolled progression periods effective or simply as a number of successive progression periods normal.
DECISION_STATUS	Describes the decision status of the outcome. Values are pending a recommended outcome has been created by the system. Approved a progression outcome has been approved and will be applied as a result of a progression rule failure. No dec
DECISION_DT	Describes the date on that the current decision status was made, like the decision to recommend, approve, waive, cancel or remove the progression outcome.
DECISION_ORG_UNIT_CD	The code of the organizational unit responsible for the current progression outcome decision status.
DECISION_OU_START_DT	Describes the organizational unit start date
APPLIED_DT	The date on that the progression outcome was applied to the student program attempt, through either hold or enrollment functionality like discontinuation.
SHOW_CAUSE_EXPIRY_DT	Describes the expiry date of the show cause period. This date is set on approval of the outcome based on the appropriate offset or cut-off dates and can be overridden by authorized users.
SHOW_CAUSE_DT	The date on that the student submitted their show cause application.
COURSE_CD	Describes the code of the program attempt to thatthe outcome has been applied
SHOW_CAUSE_OUTCOME_DT	The date on that the decision was made in respect ofthe student's show cause application
SHOW_CAUSE_OUTCOME_TYPE	Describes the outcome of the student's show cause application. The value will be either upheld or dismissed.
APPEAL_EXPIRY_DT	The expiry date for lodgment of an appeal. The date is set in one of two ways.1. Where both show cause and appeal processes are available to the student, the date is set following the decision to dismiss the show cause application. 2. Whe
APPEAL_DT	Describes the date on tjat the student appealed the outcome
APPEAL_OUTCOME_DT	The date on that the decision was made in respect ofthe student's appeal application
APPEAL_OUTCOME_TYPE	Describes the outcome of the student's appeal application. The value will be either upheld or dismissed.
ENCMB_COURSE_GROUP_CD	The code of a default course group from which the student is to be excluded from as a result of the progression rule outcome. A program group code is only applicable if the related hold type results in a program group exclusion EXC_CRS_GP.
RESTRICTED_ENROLMENT_CP	The 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 if the related hold type results in either the RSTR_
RESTRICTED_ATTENDANCE_TYPE	The 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 if the related hold type results in a RSTR_AT_TY systemhold effect
COMMENTS	A text based facility for entering additional comments about the student program attempt progression outcome
SEQUENCE_NUMBER	Describes the unique sequence number of the outcome
SHOW_CAUSE_COMMENTS	A text-based facility for entering additional information about the student's show cause application
APPEAL_COMMENTS	A text-based facility for entering additional information about thestudent's appeal application
EXPIRY_DT	Indicates the expiry date
PRO_PRA_SEQUENCE_NUMBER	Idicates the relation between the progression rule sequence number and the progression rule outcome number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
PRG_CAL_TYPE	Describes the progression calendar type that the rulewas tested and from that the outcome originates
PRG_CI_SEQUENCE_NUMBER	Describes the progression calendar sequence number
RULE_CHECK_DT	Date of the progression rule failure
PROGRESSION_RULE_CAT	Code of an institution-defined category of program progression rules
PRA_SEQUENCE_NUMBER	Describes the progression rule sequence number
PRO_SEQUENCE_NUMBER	Describes the progression outcome sequence number

Student System - IGS_PR_STU_OU_HIST_ALL	This entity describes the student outcome history
Column Name	Descritpion
PERSON_ID	Describes the person identifier to whom the outcome has been applied
APPLIED_DT	The date on that the progression outcome was applied to the student program attempt, through either holds or enrollment functionality like discontinuation
COMMENTS	A text based facility for entering additional comments about the student program attempt progression outcome.
DECISION_DT	Describes the date that the current decision status was made. The decision to recommend, approve, waive, cancel or remove the progression outcome.
DECISION_ORG_UNIT_CD	The code of the organizational unit responsible for the current progression outcome decision status.
DECISION_OU_START_DT	Describes the organizational unit start date
DECISION_STATUS	Describes the decision status of the outcome. Values are pending a recommended outcome has been created by the system. Approved a progression outcome has been approved and will be applied as a result of a progression rule failure. No decis
DURATION	Describes the duration of the outcome in progression periods. Expulsion and exclusion outcomes must be open ended. Suspension outcomes must have a defined end period. Probation outcomes can be either open ended or have a defined end perio
DURATION_TYPE	The type of outcome duration either effective or normal. The duration of a penalty can be specified either in terms of effectively enrolled progression periods effective or simply as a number of successive progression periods normal.
ENCMB_COURSE_GROUP_CD	The code of a default program group from that the student is to be excluded from as a result of the progression rule outcome. A program group code is only applicable if the related hold type results in a program group exclusion.
EXPIRY_DT	Indicates the expiry date
COURSE_CD	Describes the code of the program attempt to that the outcome has been applied
HIST_END_DT	Indicates the history end date
HIST_WHO	Indicates the user who modified this record
PRA_SEQUENCE_NUMBER	Describes the progression rule sequence number
PRG_CAL_TYPE	Describes the progression calendar type in that the rule was tested and from that the outcome originates
PRG_CI_SEQUENCE_NUMBER	Describes the progression calendar sequence number
PROGRESSION_OUTCOME_TYPE	The code of the progression rule outcome type exclusion, expulsion, manual, nopenalty, probation or suspension. If applicable, the outcome type is linked to hold with one or more system defined hold effect types and a restricted credit poi
PROGRESSION_RULE_CAT	The code of an institution-defined category of program progression rules
PRO_PRA_SEQUENCE_NUMBER	Iindicates the relation between progression rule sequence number and the progression rule outcome number
PRO_SEQUENCE_NUMBER	Describes the progression outcome sequence number
RESTRICTED_ATTENDANCE_TYPE	The 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 if the related hold type results in a RSTR_AT_TY system hold effect
SEQUENCE_NUMBER	Describes the unique sequence number of the outcome
RESTRICTED_ENROLMENT_CP	The 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 if the related hold type results in either the RSTR_
RULE_CHECK_DT	Date of the progression rule failure
SHOW_CAUSE_COMMENTS	A text-based facility for entering additional information about the student's show cause application
SHOW_CAUSE_DT	The date that the student submitted their show cause application
SHOW_CAUSE_EXPIRY_DT	Describes the expiry date of the show cause period. This date is set on approval of the outcome based on the appropriate offset or cut-off dates and can be overridden by authorized users.
SHOW_CAUSE_OUTCOME_DT	The date that the decision was made in respect of the student's show cause application.
SHOW_CAUSE_OUTCOME_TYPE	Describes the outcome of the student's show cause application. The value will be either upheld or dismissed.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
HIST_START_DT	Iindicates the history start date
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
APPEAL_COMMENTS	Indicates the appeal comments
APPEAL_DT	Describes the date on that the student appealed the outcome
APPEAL_EXPIRY_DT	The expiry date for lodgment of an appeal. The date is set in one of two ways. 1 Where both show cause and appeal processes are available to the student, the date is set following the decision to dismiss the show cause application. 2 Where
APPEAL_OUTCOME_DT	The date on that the decision was made in respect of the student's appeal application
APPEAL_OUTCOME_TYPE	Describes the outcome of the student's appeal application. The value will be either upheld or dismissed

Student System - IGS_PR_S_SCRATCH_PAD_ALL	This table is used to hold intermediate data during progression calculations.
Column Name	Descritpion
SEQUENCE_NUMBER	Indicates the progression sequence number
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
CREATION_DT	Indicates the creation date
KEY	Indicates the key that corresponds to a message
MESSAGE_NAME	Indicates the message related to the key
TEXT	Indicates the text related to the key
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_ANL_LOAD	This entity describes the annual load for each year of a program. Units are linked to this load defining the standard load for their EFTSU calculation.
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version of the program for that the annual load is being specified.
CREATION_DATE	Standard Who column
COURSE_CD	Program for that the annual load figure is being specified.
YR_NUM	Year to that the annual load figure applies. For example, 1,2,3,4.
EFFECTIVE_START_DT	The date from which the annual load figure becomes effective. The load values which were in existence when the student commenced the program will be the ones used for the duration of the student's program attempt.
EFFECTIVE_END_DT	Date from that the annual load figure is no longer effective.
ANNUAL_LOAD_VAL	Standard load in credit points used to calculate equivalent full time student unit for the nominated year of the program. Used only where the annual load is not constant over all years of the program.
CREATED_BY	Standard Who column

Student System - IGS_PS_ANL_LOAD_U_LN	This entity describes a unit, which is linked to an annual load figure for the purposes of calculating its EFTSU. For example, a unit may be linked to the load for the first year of the program.
Column Name	Descritpion
COURSE_CD	Program for that the annual load figure is being specified.
UNIT_CD	Unique identifier of the unit being linked to the annual load figure.
UV_VERSION_NUMBER	Version number of the unit that is being linked to the annual load figure.
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
CRV_VERSION_NUMBER	Version of the program for which the annual load figure is being specified.
YR_NUM	The year to which the annual load figure applies. For example 1,2,3,4.
EFFECTIVE_START_DT	Date from that the annual load unit link becomes effective.

Student System - IGS_PS_AWARD	This entity describes the awards which completion of the program will attain for the student. The allowance has been made for zero to many awards per program.
Column Name	Descritpion
COURSE_CD	Describes the program code for that the award is being specified.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Describes the version number of the program for that the award is being specified.
DEFAULT_IND	Indicates the default Award for the program.
CLOSED_IND	Closed Indicator, indicates the program award is closed or not. Once the program award is closed then corresponding program award is not displayed in LOV of forms and not considered for processing.
AWARD_CD	Unique identifier for the award.
AWARD_TITLE	No longer Used

Student System - IGS_PS_AWD	This entity describes an award offered by the university.
Column Name	Descritpion
AWARD_CD	Code for an award offered by the institution.
NOTES	Enables the entering of any additional information or details about the award.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
AWARD_TITLE	Name of an award offered by the institution. For example, bachelor of arts, graduate diploma of education.
GRADING_SCHEMA_CD	The Grading Schema for the award
GS_VERSION_NUMBER	The grading schema version number for the award
S_AWARD_TYPE	System defined award type that is program, honorary, prize, medal.
TESTAMUR_TYPE	Institution defined degree type to that the award is mapped. Enables student system to produce the correct degree type for each graduate. For example, university, entrepreneurial.
CLOSED_IND	Indicator that specifies if the award is open or closed. Setting the checkbox to closed prevents use of the award in new or modified records in other parts of the system, such as program awards in IGSPS017 and special awards in IGSGR012.

Student System - IGS_PS_AWD_OWN	This entity describes the owner organizational unit of a program award.
Column Name	Descritpion
OU_START_DT	Date from that the organizational unit is effective. The organizational unit is uniquely identified by the combination of its code and start date.
PERCENTAGE	Percentage of the program award owned by the organizational 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
COURSE_CD	Identifies the program for that the program award ownership is being specified.
VERSION_NUMBER	Unique identifier for the version of the program for that award ownership is being specified.
AWARD_CD	Describes the code of the award for that ownership is being specified.
ORG_UNIT_CD	Identifies the organizational unit that owns part or all of the program award.

Student System - IGS_PS_CAT	This entity describes user-definable program categories, which are applied to all programs offered by the university.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column
COURSE_CAT	Unique identifier for the institution-defined program categories that might be assigned to programs offered by the institution.
DESCRIPTION	Describes the institution-defined program categories that might be assigned to programs offered by the institution.
CLOSED_IND	Indicator that specifies if the program category is open or closed. Setting the checkbox to closed prevents use of the program category in new or modified program categorization records.

Student System - IGS_PS_COO_AD_UNIT_S	This entity describes the admission categories assigned to a program offering option unit set.
Column Name	Descritpion
COURSE_CD	Describes the program code
CRV_VERSION_NUMBER	Uniquely identifies each version of a program.
CAL_TYPE	Academic calendar type in that the program is offered.
LOCATION_CD	Location name or code. The location represents a geographical location and can be used to indicate if programs and units can be offered.
ATTENDANCE_MODE	Describes the institution-defined attendance modes in that the program is being offered. For example, on campus, off campus.
ATTENDANCE_TYPE	Describes the attendance types for a program. For example, full-time, part-time.
ADMISSION_CAT	Code of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed via a common set of admission procedure steps.
UNIT_SET_CD	Describes the user-defined code used to identify a set of units. Unit sets contain lists of units or rules that make up a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams, lists.
US_VERSION_NUMBER	Uniquely identifies each version of a unit set.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_COURSE	This entity describes the programs which are offered by the university, covering both award and non-award programs.
Column Name	Descritpion
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Unique identifier for a program of study.
CREATED_BY	Standard Who column

Student System - IGS_PS_CR_PT_DSCR	This entity describes the type of credit points which exist on the system. eg. Credit Points, Annual Student Contact Hours (ASCH).
Column Name	Descritpion
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREDIT_POINT_DESCRIPTOR	The institution-defined name for credit points.
DESCRIPTION	The institution-defined description for credit points.
CLOSED_IND	An indicator which specifies if the credit point descriptor is open or closed. Setting the checkbox to 'closed' (ticked) prevents use of the credit point descriptor in new or modified records.

Student System - IGS_PS_DEGREES	This entity describes the various degrees offered by the university
Column Name	Descritpion
DEGREE_CD	Unique identifier for a degree.
DESCRIPTION	Institution-defined description for degrees.
CLOSED_IND	Indicator that specifies if the credit point descriptor is open or closed. Setting the checkbox to closed prevents use of the credit point descriptor in new or modified records.
PROGRAM_TYPE	Program Type associated to the Degree Code.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_DIC_OCC_TITLS	The entity describes all the occupational titles after passing from the university
Column Name	Descritpion
OCCUPATIONAL_TITLE_CODE	unique identifier for occupational titles.
OCCUPATIONAL_TITLE	Institution - defined description occupational titles.
ALTERNATE_TITLE	Institution- defined alternative title occupational titles.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_ENT_PT_REF_CD	This entity describes a reference code(s) that relate to the program offering entry point e.g. TAC codes, CRICOS codes.
Column Name	Descritpion
COURSE_CD	Code of the program version being offered.
US_VERSION_NUMBER	Describes the unit set to that the reference code applies.
REFERENCE_CD	Program entry point reference code for the program offering option. A program entry point reference code is an alternative code for a program used during the tertiary admission centres admissions process.
COO_ID	Unique system identifier for the program offering option.
DESCRIPTION	Description of the reference code. A program entry point reference code is an alternative code for a program used by the tertiary admissions centres during the admissions process.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the program version being offered.
CAL_TYPE	Calendar type for the program offering option.
LOCATION_CD	Location of the program offering option.
ATTENDANCE_MODE	Institution-defined attendance mode. Identifies the mode of attendance by that a student undertakes a program.
ATTENDANCE_TYPE	Institution-defined attendance type. Identifies whether a student in a program is part-time or full-time for the year.
REFERENCE_CD_TYPE	Institution-defined reference code type, that defines the use of a program entry point reference code.
SEQUENCE_NUMBER	Uniquely identifies the entry point reference code. This is required due to the optional link to the unit set code.
UNIT_SET_CD	Describes the unit set to that the reference code applies.

Student System - IGS_PS_FACLTY_DEGRS	Entity to capture the faculty's degree details
Column Name	Descritpion
FACLTY_DEGRD_ID	Unique identifier for faculty's degree
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERSON_ID	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
DEGREE_CD	Unique degree code faculty's degree
PROGRAM	Program for faculty's degree.
INSTITUTION_CD	Institution code for faculty's degree.
DEGREE_DATE	Degree date for faculty's degree.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_FACLTY_DISP	Entity to capture the faculty's discipline details
Column Name	Descritpion
DISPLN_UNIT_ID	Unique identifier for faculty's discipline unit
DISPLN_UNIT_TYPE	Discipline unit type for faculty's discipline unit.
PERSON_ID	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
DISPLN_UNIT_CD	Discipline unit code for faculty's discipline unit
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_FEE_TRG	This entity describes the program based fee triggers. It is used during fee assessment processing to indicate a program-based fee applies for a fee type.
Column Name	Descritpion
FEE_CAT	Describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
SEQUENCE_NUMBER	Uniquely identifies the program fee trigger.
VERSION_NUMBER	Version number of the program. Entering a version number will limit the fee to students whose student program attempt version number matches the version number.
CAL_TYPE	Institution-defined name of a type academic of calendar used within the institution. Programs can only be offered in instances of calendar types that are categorized as academic.
LOCATION_CD	Code of a physical location owned or used by an institution. Entering a location code will limit the fee to students whose program and nominated location match the trigger.
ATTENDANCE_MODE	Code of an institution-defined attendance mode. Entering an attendance mode value will limit the fee to students whose derived attendance mode matches the value.
ATTENDANCE_TYPE	Code of an institution-defined attendance type. Entering an attendance type value will limit the fee to students whose derived attendance type matches the value.
CREATE_DT	Contains the data and time the program fee trigger was created.
FEE_TRIGGER_GROUP_NUMBER	Describes the number that uniquely identifies the fee trigger group.
LOGICAL_DELETE_DT	Date the fee trigger was logically deleted.
FEE_CAL_TYPE	Calendar type with calendar category fee used in the assessment of student fees.
CREATED_BY	Standard Who 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
FEE_CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance.
FEE_TYPE	Describes the fee types used for the purpose of applying fees and charges. A fee type can be used with many fee categories, permitting a single system wide fee definition to be used.
COURSE_CD	Code of a program that will trigger a fee assessment.

Student System - IGS_PS_FIELD_STUDY	This entity describes the fields of study, which apply to a program.
Column Name	Descritpion
COURSE_CD	Identifies the program for that the field of study is being specified.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the program for that the field of study is being specified.
FIELD_OF_STUDY	Unique identifier for the institution-defined field of study. A field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program.
MAJOR_FIELD_IND	Describes nominated fields of study that is major one.
PERCENTAGE	Details the percentage split between multiple fields of study, or will be 100% if there is only one field of study.

Student System - IGS_PS_GOVT_ATD_MODE	This entity describes the DETYA set of attendance modes. E.g. 1 - Internal, 2 - External.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GOVT_ATTENDANCE_MODE	Unique code for a government attendance mode. An attendance mode identifies the mode of attendance by that a student undertakes a program. For example, 1 - internal mode of attendance, 2 - external mode of attendance.
DESCRIPTION	Description of a government attendance mode. An attendance mode identifies the mode of attendance by that a student undertakes a program. For example, 1 - Internal mode of attendance, 2 - external mode of attendance.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed, prevents use of the government attendance mode in new or modified institution- defined attendance mode records.

Student System - IGS_PS_GOVT_ATD_TYPE	This entity describes the DETYA set of attendance types. E.g. 1 - Full-time, 2 - Part-Time.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GOVT_ATTENDANCE_TYPE	Unique code for a government attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year.
DESCRIPTION	Description of a government attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution-defined attendance mode records.

Student System - IGS_PS_GOVT_DSCP	This entity describes the DEET set of discipline group codes.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GOVT_DISCIPLINE_GROUP_CD	Describes the government discipline group to that a unit of study belongs, as classified by the institution.
DESCRIPTION	Provides an explanation of the discipline group code.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution-defined attendance mode records.

Student System - IGS_PS_GOVT_SPL_TYPE	This entity describes the Government set of special program types.
Column Name	Descritpion
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution- defined attendance mode 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
GOVT_SPECIAL_COURSE_TYPE	A unique code that identifies programs of special interest. For example, 1 is for 'Not a program of special interest', 11 is for 'Basic nurse education program'.
DESCRIPTION	Description of the government special program type.

Student System - IGS_PS_GOVT_TYPE	This entity describes the Government set of program types.
Column Name	Descritpion
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GOVT_COURSE_TYPE	Unique code for the government program type. Government program types describe types of higher education programs. Each institution- defined program type is mapped to a Government program type.
DESCRIPTION	Description of the government program type.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution-defined attendance mode records.

Student System - IGS_PS_GRP_FEE_TRG	This entity describes the program group based fee triggers. It is used during fee assessment processing to indicate a program group based fee applies for a fee type.
Column Name	Descritpion
FEE_CAT	Describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
CREATE_DT	Contains the data and time the program group fee trigger was created.
LOGICAL_DELETE_DT	Date the fee trigger was logically deleted.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
FEE_CAL_TYPE	Calendar type with calendar category Fee used in the assessment of student fees.
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.
FEE_CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance.
FEE_TYPE	Describes the fee types used for the purpose of applying fees and charges. A fee type can be used with many fee categories, permitting a single system wide fee definition to be used.
COURSE_GROUP_CD	Describes the code that is used to identify a group of programs. Program groups are used to link programs with user-defined common properties such as academic organizational unit.

Student System - IGS_PS_GRP_MBR	This entity describes the programs, which are members in a program grouping.
Column Name	Descritpion
COURSE_CD	Unique identifier for a program assigned to a program group.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of a program assigned to a program group.
COURSE_GROUP_CD	Unique identifier for a group of programs. Program groups are used to link programs with user-defined common properties. They can be used for purposes such as student progression and permitted double degree combinations.
CREATED_BY	Standard Who column

Student System - IGS_PS_GRP_TYPE	This entity describes the available types of program groups that can be defined on the system. E.g. Equivalents, available double programs, common entrance requirements.
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
COURSE_GROUP_TYPE	Unique identifier for a program group type. Each program group must be mapped to a system program group type. Program group types are assigned to program groups to give them further definition.
DESCRIPTION	Description of the program group type. Each program group must be mapped to a system program group type. Program group types are assigned to program groups to give them further definition.
S_COURSE_GROUP_TYPE	Unique identifier for a system-defined program group type. Each program group type must be mapped to a system program group type.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution-defined attendance mode records.

Student System - IGS_PS_IN_PKG_ITM	This entity describes the package correspondence items which makeup an enquiry package for a program. This may include system and non-system generated items of correspondence. Obsolete
Column Name	Descritpion
COURSE_CD	Unique identifier for the program being offered.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
ENQUIRY_PACKAGE_ITEM	Describes the items that can be included in an inquiry package.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_NOTE_TYPES	Entity to capture the catalog versions.
Column Name	Descritpion
NOTE_TYPE_ID	Unique identifier for the note types.
LAST_UPDATE_LOGIN	Standard Who column
NOTE_TYPE	Type of Notes. For example, Word, Notepad.
DESCRIPTION	Description for the note types.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution- defined attendance mode records.
CATALOG_SCHEDULE	Schedule of the catalog.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_OFR_INST	This entity describes the instances of a calendar type in which a particular program is on offer.
Column Name	Descritpion
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance.
CI_START_DT	Date from that the calendar instance becomes effective.
CI_END_DT	Date from that the calendar instance is no longer effective.
MIN_ENTRY_ASS_SCORE	Minimum entry assessment score required by an applicant to be considered for an offer of admission to the program offering.
GUARANTEED_ENTRY_ASS_SCR	Entry assessment score that, if achieved, guarantees an applicant a firm offer of admission to the program offering.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Unique identifier for the program being offered.
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.
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
CAL_TYPE	Academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization.

Student System - IGS_PS_OFR_NOTE	This table describes the notes associated with a program offering.
Column Name	Descritpion
COURSE_CD	Unique identifier for the program for that the program offering note is being specified.
REFERENCE_NUMBER	Identifies the reference number of a particular note.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types can be defined for any purpose. For example, institutions can define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version of the program for that the program offering note is being created.
CAL_TYPE	Calendar type of the calendar instance included in the program offering note.

Student System - IGS_PS_OFR_OPT_NOTE	This table describes the notes associated with a program offering option.
Column Name	Descritpion
VERSION_NUMBER	Version number of the program for that the program offering option note is being created.
CAL_TYPE	Calendar type of the calendar instance included in the program offering option note.
LOCATION_CD	Location at that a particular program offering option is available.
ATTENDANCE_MODE	Attendance mode of a particular program offering option.
ATTENDANCE_TYPE	Attendance type of a particular program offering option.
REFERENCE_NUMBER	Identifies the reference number of a particular note.
COO_ID	Describes a unique number for referencing a program offering option.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types can be defined for any purpose. For example, institutions can define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Unique identifier for the program for that the program offering option note is being specified.

Student System - IGS_PS_OFR_PAT	This entity describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available.
Column Name	Descritpion
ADM_ASS_OFFICER_PERSON_ID	Person ID of a staff member recognized as the admission assessment officer responsible for the program offering pattern.
ADM_CONTACT_PERSON_ID	Person ID of a staff member recognized as the contact person responsible for the program offering pattern.
COURSE_CD	Unique identifier for the program being offered.
GRADING_SCHEMA_CD	Code that identifies the grading schema. A grading schema describes the set of available marks and grades that can be used in the assessment of student unit attempts. There can be multiple grading schemas for any one institution.
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
GS_VERSION_NUMBER	System generated number used to identify the version of the grading schema.
CAL_TYPE	Academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the 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
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.
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance.
LOCATION_CD	Location name or code. The location represents a geographical location and can be used to indicate if programs and units can be offered.
ATTENDANCE_MODE	Mode of attendance of the program offering pattern.
ATTENDANCE_TYPE	Attendance type of the program offering pattern.
COP_ID	Unique number for referencing the program offering pattern.
COO_ID	Unique number for referencing the program offering option.
OFFERED_IND	Indicator that specifies whether the program offering pattern is currently offered. Setting the checkbox ticked makes the program offering pattern available.
CONFIRMED_OFFERING_IND	Indicator that specifies whether the offering detail has been checked and confirmed subsequent to being rolled over from a previous version of the calendar. The confirmed checkbox can be set by default or left for manual checking.
ENTRY_POINT_IND	Indicator that specifies whether the program offering pattern is an admission entry point to the program. Setting the checkbox ticked makes the program offering pattern an entry point.
PRE_ENROL_UNITS_IND	Indicator that specifies whether student unit attempts for the program offering pattern should be pre-enrolled as part of the pre-enrollment function.
ENROLLABLE_IND	Indicator that specifies whether the program offering pattern is available for student enrollment. Setting the checkbox ticked makes the program offering pattern available.
IVRS_AVAILABLE_IND	Indicator that specifies whether the program offering pattern is available through the Interactive Voice Response system (IVRS).
MIN_ENTRY_ASS_SCORE	Minimum entry assessment score required by an applicant to be considered for an offer of admission to a program offering pattern.
GUARANTEED_ENTRY_ASS_SCR	This score guarantees the applicant a firm offer of admission to the program. A program offering pattern assessment score takes precedence over a guaranteed assessment score established at the program offering instance level.
MAX_CROSS_FACULTY_CP	Maximum number of credit points in that a student can enroll, in an academic calendar, in units owned by faculties other than the faculty owning the student's program.
MAX_CROSS_LOCATION_CP	Maximum number of credit points in that a student may enroll, in an academic calendar, outside of their enrolled program location..
MAX_CROSS_MODE_CP	Maximum number of credit points in that a student may enroll, in an academic calendar, outside of their enrolled program attendance mode.
MAX_HIST_CROSS_FACULTY_CP	Maximum number of credit points in that a student can enroll, over the duration of the program, in units owned by faculties other than the faculty owning the student's program.

Student System - IGS_PS_OFR_PAT_NOTE	This table describes the notes associated with a Program Offering Pattern.
Column Name	Descritpion
COURSE_CD	Unique identifier for the program for that the program offering pattern note is being specified.
REFERENCE_NUMBER	Identifies the reference number of a particular note.
VERSION_NUMBER	Version number of the program for that the program offering pattern note is being created.
COP_ID	Describes a unique number for referencing a program offering pattern.
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types can be defined for any purpose. For example, institutions can define Handbook note types as items for publication in the institution's official handbook.
CAL_TYPE	Calendar type of the calendar instance included in the program offering pattern note.
CI_SEQUENCE_NUMBER	Unique identifier for the calendar instance.
LOCATION_CD	Location at that a particular program offering pattern is available.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTENDANCE_MODE	Attendance mode of a particular program offering pattern.
ATTENDANCE_TYPE	Attendance type of a particular program offering pattern.

Student System - IGS_PS_OFR_UNIT_SET	This entity describes the link between unit sets and programs. E.g. it would link the possible majors to a program
Column Name	Descritpion
COURSE_CD	Describes the program 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
CRV_VERSION_NUMBER	Version number of the program. There can only be one version of a program with a system status of Active and an unset Expiry Date.
CAL_TYPE	Describes the calendar type of the program offering to that the unit set is linked.
UNIT_SET_CD	Code of a unit set. Unit sets consists lists of units or rules that constitute a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams and lists.
US_VERSION_NUMBER	Used to uniquely identify each version of a unit set. There can only be one version of a unit set with a system status of Active and an unset Expiry date.
OVERRIDE_TITLE	Override title of a unit set when selected within the context program version.
ONLY_AS_SUB_IND	Indicator that specifies whether the unit set can only be selected as a subordinate unit set within the related program offering. If checked, the unit set must always be selected within an already selected or completed parent unit set.
SHOW_ON_OFFICIAL_NTFCTN_IND	Indicator that specifies whether the unit set should appear on official notifications to the student, such as academic transcripts and degree. The indicator defaults to checked ticked for academic unit sets and defaults to unchecked for ad

Student System - IGS_PS_OF_OPT_AD_CAT	This entity describes the set of admission categories, which may enroll in the particular program offering option.
Column Name	Descritpion
LOCATION_CD	Describes the location code, or campus, of the program offering option.
ATTENDANCE_MODE	Code of an institution-defined attendance mode. An attendance mode identifies the mode of attendance in that a student undertakes a program. Each attendance mode must be mapped to a government attendance type.
ATTENDANCE_TYPE	Code of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year.
ADMISSION_CAT	Code of an institution-defined admission category. An admission category is used to group a set of applicants whose applications are be processed via a common set of admission procedure steps.
COURSE_CD	Unique identifier for the program being offered.
COO_ID	Describes a unique number for referencing a program offering option.
SYSTEM_DEFAULT_IND	Indicates whether the admission category is to be used by the system as a default. Setting the checkbox ticked means that the Admission Category is used as the system default for Tertiary Admissions Centre Offer Load Process purposes.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CAL_TYPE	The academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization.

Student System - IGS_PS_OF_OPT_UNT_ST	This entity describes the program unit sets, which are available to the particular program offering option. If there are no values in this entity for a program, it will assume that all program unit sets are available.
Column Name	Descritpion
COURSE_CD	Describes the program code.
CRV_VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry 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
CAL_TYPE	Academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization.
LOCATION_CD	Describes the location code. The location code can be used to indicate if programs and units are offered.
ATTENDANCE_MODE	Describes the attendance modes in that the program is being offered. These modes are institution-defined. For example, On Campus, Off Campus.
ATTENDANCE_TYPE	Describes the attendance types in that the program is being offered. These types are institution-defined. For example, Full-Time, Part-Time.
UNIT_SET_CD	Code of a unit set. Unit sets consists lists of units or rules that constitute a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams, and lists.
US_VERSION_NUMBER	Used to uniquely identify each version of a unit set.
COO_ID	Describes a unique number for referencing the program offering option.

Student System - IGS_PS_OF_UNT_SET_RL	This table describes the relationship between two unit sets within a program. This relationship restricts the parent/child relationships between students selected unit sets.
Column Name	Descritpion
COURSE_CD	Describes the program code to that the related unit sets are linked.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CRV_VERSION_NUMBER	Describes the program version number to that the related unit sets are linked.
CAL_TYPE	Describes the calendar type in that the related program is offered.
SUP_UNIT_SET_CD	Describes the superior unit set code.
SUP_US_VERSION_NUMBER	Describes the superior unit set version number.
SUB_UNIT_SET_CD	Describes the subordinate unit set code.
SUB_US_VERSION_NUMBER	Describes the subordinate unit set version number.

Student System - IGS_PS_OWN	This entity describes the organizational units, which own a program and the percentage ownership division.
Column Name	Descritpion
PERCENTAGE	Details the percentage split between multiple owners of a program, or will be 100% if there is only one owner.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Unique identifier for the program code for that ownership is being specified.
VERSION_NUMBER	Version number of a program for that ownership is being specified.
ORG_UNIT_CD	Unique identifier for an organizational unit that is designated as an owner of a program version.
OU_START_DT	Start date of an organizational unit designated as an owner of a program version.

Student System - IGS_PS_PAT_OF_STUDY	This entity describes a pattern of study, which applies to a program offering.
Column Name	Descritpion
COURSE_CD	Describes the program code to that the pattern applies.
ADMISSION_CAT	Code of the admission category to that the pattern of study applies. If an admission category is specified, the applicability of the pattern of study is restricted to students with the same program admission category.
APRVD_CI_SEQUENCE_NUMBER	Describes the latest instance of the program offering academic calendar to that the pattern of study applies. If pre-enrollment is being performed for a later academic calendar, then the pattern of study is not applied.
NUMBER_OF_PERIODS	Number of academic periods or academic years in that students are pre-enrolled each time the pre-enrollment process is run .
ALWAYS_PRE_ENROL_IND	Indicator that specifies whether or not pre-enrollment in pattern of study units should always occur. When the checkbox is set ticked , unit pre-enrollment always takes place, regardless of the student's progress in the program.
ACAD_PERD_UNIT_SET	Academic Period within Unit Set
VERSION_NUMBER	Describes the program version number to that the pattern applies.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CAL_TYPE	Describes the academic calendar type to that the pattern applies.
SEQUENCE_NUMBER	Allows uniqueness of different patterns of study for a single program offering.
LOCATION_CD	Location code to that the pattern of study applies. If a location is specified, the applicability of the pattern of study is restricted to program attempts with a matching location.
ATTENDANCE_MODE	Attendance mode to that the pattern of study applies. If an attendance mode is specified, the applicability of the pattern of study is restricted to program attempts with a matching attendance mode.
ATTENDANCE_TYPE	Attendance type to that the pattern of study applies. If an attendance type is specified, the applicability of the pattern of study is restricted to program attempts with a matching attendance type.
UNIT_SET_CD	Code of the unit set to that the pattern of study applies. If a unit set is specified, the applicability of the pattern of study is restricted to students enrolled in the same unit set within the program.
ADMISSION_CAL_TYPE	Admission calendar type to that the pattern of study applies. If a calendar type is specified, the applicability of the pattern of study is restricted to students admitted to the program via an instance of the specified calendar type.

Student System - IGS_PS_PAT_STUDY_PRD	This entity describes the periods of a pattern of study. Each period is represented by an academic period number (which is equivalent to the students academic period) and a teaching calendar type.
Column Name	Descritpion
COURSE_CD	Describes the program code to that the pattern applies.
VERSION_NUMBER	Describes the program version number to that the pattern applies.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CAL_TYPE	Describes the program calendar type to that the pattern applies.
POS_SEQUENCE_NUMBER	Describes the pattern of study sequence number in that the period exists.
SEQUENCE_NUMBER	Uniquely identifies the period within the pattern of study.
ACAD_PERIOD_NUM	Numeric value for the academic period or year within the pattern of study. Each academic period number corresponds to an academic year. 1 represents the first year of enrollment. 2 represents the second year, and so on.
TEACH_CAL_TYPE	Teaching calendar type or teaching periods within the specified academic period academic period number. It is used to record the teaching periods, within that units are pre-enrolled in each academic period in the pattern of study.
DESCRIPTION	Optional description of the pattern of study teaching period. For example, Year 1 - Semester 1.

Student System - IGS_PS_PAT_STUDY_UNT	This entity describes the units, which exist within a pattern of study period.
Column Name	Descritpion
COURSE_CD	Describes the program code to that the pattern applies.
UNIT_LOCATION_CD	Location at that the pattern of study unit is pre-enrolled. If a location is specified, the pre-enrollment process if matching unit offering options exist uses it to select the unit offering option in that to pre-enroll.
UNIT_CLASS	Class in that the pattern of study unit is pre-enrolled. If a class is specified, the pre-enrollment process if matching unit offering options exist uses it to select the unit offering option in that to pre-enroll.
DESCRIPTION	Description can be recorded for non-specific pattern of study units, such as electives and options . When recording pattern of study units, either a unit code or description must be entered, but not both.
VERSION_NUMBER	Describes the program version number to that the pattern applies.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CORE_IND	Core Unit Indicator.
CAL_TYPE	Describes the calendar type to that the pattern applies.
POS_SEQUENCE_NUMBER	Describes the pattern of study sequence number.
POSP_SEQUENCE_NUMBER	Describes the pattern of study period sequence number.
SEQUENCE_NUMBER	Uniquely identifies each unit within the pattern of study period.
UNIT_CD	Code for a unit in that students should be pre-enrolled in the specified academic period or teaching period. For example, pre-enroll students in the unit ABC123 in semester 1 of their second year of enrollment.

Student System - IGS_PS_REF_CD	This entity describes a reference code(s), which relate to the program. E.g. IVRS code.
Column Name	Descritpion
DESCRIPTION	Provides an explanation of the program reference code.
CREATED_BY	Standard Who column
COURSE_CD	Identifies the program for that the reference code is being specified.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the program for that the program reference code is being specified.
REFERENCE_CD_TYPE	Type or classification of an other system program reference code.
REFERENCE_CD	Other system reference code for a program. For example, an IVRS code used to represent a program.

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

Student System - IGS_PS_STAGE	This entity describes program stages within a program version, which are represented by a code. These stages are evaluated through relationships to rules within the rules sub-system and are measured through Progression.
Column Name	Descritpion
COURSE_CD	Describes the program code to that the stage is attached.
VERSION_NUMBER	Describes the program version number to that the stage is attached.
SEQUENCE_NUMBER	Describes the sequence number that uniquely identifies the program stage. This allows the stage code to be changed without re-creating the stage.
COURSE_STAGE_TYPE	Identifies a program version stage. A program can consist of one or many stages. Each stage is defined via a program stage rule created in the Maintain Rule form. Program stage rules are evaluated in the program progression sub-system.
COMMENTS	Can be used to enter information about the context program stage.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Provides an explanation of the program stage.

Student System - IGS_PS_STAGE_RU	Entity to capture the Program stage rules.
Column Name	Descritpion
COURSE_CD	Unique identifier for the program being offered.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
CST_SEQUENCE_NUMBER	Unique identifier for calendar stages.
S_RULE_CALL_CD	Unique identifier for the rule codes.
RUL_SEQUENCE_NUMBER	Unique identifier for the rule sequence codes.

Student System - IGS_PS_STAGE_TYPE	This table describes the standard types of program stages, which may be created against a program. E.g. 1STYEAR, 2NDYEAR, MISC.
Column Name	Descritpion
COURSE_STAGE_TYPE	Institution defined program stage type. Program stages typically correspond with the years of a program. A three year bachelor degree typically consists three stages Year-01, Year-02, and Year-03.
CREATED_BY	Standard Who 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 a program stage type. Program stages typically correspond with the years of a Program. A three year bachelor degree typically consists of three stages. Year-01, Year-02 and Year-03.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution- defined attendance mode records.

Student System - IGS_PS_STAT	This entity describes the user-defined program statuses. These map back onto the system program statuses, to provide the system with the ability to have a large number of statuses which tie back to the system functionality.
Column Name	Descritpion
COURSE_STATUS	Describes the institution-defined program statuses. A program status indicates the level of activity of a program version. Each status must map back to the system program status that will define its functionality.
S_COURSE_STATUS	Unique identifier for a system-defined program status. For example, ACTIVE, INACTIVE.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution- defined attendance mode records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Provides an explanation of the program status. A program status indicates the level of activity of a program version. Each status must map back to the system program status that will define its functionality.

Student System - IGS_PS_STDNT_APV_ALT	Entity to capture the exit details from a program.
Column Name	Descritpion
PERSON_ID	Describes the ID code that uniquely identifies a person.
COURSE_CD	Code used to identify the program in that the student is enrolled. See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
EXIT_COURSE_CD	Unique code of the program that is approved.
EXIT_VERSION_NUMBER	Number signifying the version of the alternate exit program.
VERSION_NUMBER	Number signifying the version of the program in that the student enrolls.
RQRMNTS_COMPLETE_IND	Indicates whether the requirements of the exit program have been completed by the student. This can be set by either the system or manually, as indicated by the source type.
RQRMNTS_COMPLETE_DT	Date on that the exit program requirements were complete.
S_COMPLETED_SOURCE_TYPE	Source of the completion flag. It can be either system applied or manually 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

Student System - IGS_PS_STDNT_SPL_REQ	This entity describes a student's satisfaction of a special requirement within a nominated student program attempt. For example, first-aid certificate.
Column Name	Descritpion
PERSON_ID	Describes the ID code that uniquely identifies a person.
COURSE_CD	Code used to identify the program in that the student is enrolled. See also Element 307 Higher Education Student Data Collection.
SPECIAL_REQUIREMENT_CD	Code of a special requirement. Special requirements are institution- defined and might include for example, First Aid. In this instance, the completion of a first aid certificate is required in addition to unit requirements, to graduate.
COMMENTS	Provides any comments about a student's satisfaction of a special requirement within a nominated program attempt.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COMPLETED_DT	Date on that the special requirements were completed.
EXPIRY_DT	Date on that the special requirement expires. For example, a first aid certificate might only be valid for 12 months.
REFERENCE	Generic reference number of the special requirement. For example, the first aid certificate number.

Student System - IGS_PS_STDNT_TRN	This entity describes the link between two programs, which were involved in a program transfer.
Column Name	Descritpion
PERSON_ID	Describes ID code that uniquely identifies a person.
COURSE_CD	Code used to identify the program in that the student is enrolled. See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
COMMENTS	Provides any comments about the link between the Transfer to program and the transfer from program associated with the student program attempt record transfer.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
APPROVED_DATE	Approved date
EFFECTIVE_TERM_CAL_TYPE	Effective term calendar type
EFFECTIVE_TERM_SEQUENCE_NUM	Effective term sequence number
DISCONTINUE_SOURCE_FLAG	Indicated whether to discontinue the source program after transfer.
TRANSFER_ADV_STAND_FLAG	Indicates whether to transfer advanced standing for future dated transfer
UOOIDS_TO_TRANSFER	Indiactes uooids to transfer for future dated transfer
TRANSFER_DT	Describes the date the student program attempt record transfer was processed.
SUSA_TO_TRANSFER	Indicates unit set attempts to transfer for future dated transfer
STATUS_FLAG	Indicates whether the transfer is processed/unprocessed/cleaned up
STATUS_DATE	Indicates when the transfer is actually done
TRANSFER_COURSE_CD	Program code that the student program attempt has been transferred from.

Student System - IGS_PS_STDNT_UNT_TRN	This table describes the link between two units, which were involved in a program transfer.
Column Name	Descritpion
PERSON_ID	Describes the ID code that uniquely identifies a person.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Program code that the student program attempt record has been.
TRANSFER_COURSE_CD	Program code that the student program attempt record has been Transferred from.
TRANSFER_DT	Date on that the unit was transferred to the new program attempt record.
UNIT_CD	Code used to identify a unit that has been included in a program.
CAL_TYPE	Name of a type of teaching calendar within the university. For example, SEM-1, YR-LONG.
CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance.
UOO_ID	Unit Section Identifier
CREATED_BY	Standard Who column

Student System - IGS_PS_SUB_UNIT_REL	This entity describes the relationships between units, which make up sub-units and super-units. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS_DP2.doc - Obsolete
Column Name	Descritpion
LOGICAL_DELETE_DT	Date on that the superior and sub-unit relationship was deleted. Logical deletion means that the relationship has been disabled without the data being physically deleted from the database.
AWARD_ON_SUPER_COMP_IND	An indicator which specifies whether credit is awarded upon completion of the sub-unit or only upon satisfaction of all of the requirements of the superior unit. Setting the indicator causes credit to be awarded upon completion of the sub-u
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUP_UNIT_CD	Code used to identify the unit.
SUP_VERSION_NUMBER	Version number of the superior unit.
SUB_UNIT_CD	The sub-unit code.
SUB_VERSION_NUMBER	Version number of the sub-unit.
CREATE_DT	Date upon that the superior and sub-unit relationship was created.

Student System - IGS_PS_TCH_RESP	This entity describes the breakdown of teaching responsibilities for a unit across organization units. This is divided using a percentage allocation.
Column Name	Descritpion
ORG_UNIT_CD	Describes the code that identifies an academic or administrative organizational unit operating within the university structure. DEET element reference 333.
OU_START_DT	Describes the date from that the organizational unit is effective.
PERCENTAGE	Percentage allocation of teaching responsibility to an organizational unit for a unit 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
UNIT_CD	Code used to identify the unit.
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.

Student System - IGS_PS_TYPE_FEE_TRG	This entity describes the program type based fee triggers. It is used during fee assessment processing to indicate a program type based fee applies for a fee type.
Column Name	Descritpion
FEE_CAT	Describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
CREATE_DT	Contains the data and time the program type fee trigger was created.
LOGICAL_DELETE_DT	Date the fee trigger was logically deleted.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
FEE_CAL_TYPE	Calendar type with calendar category Fee.
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.
FEE_CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance.
FEE_TYPE	Describes the fee types used for the purpose of applying fees and charges. A fee type can be used with many fee categories, permitting a single system wide fee definition to be used. For example, HECS, GUILD.
COURSE_TYPE	Institution-defined type of programs, with mappings to DETYA element 310. Creating a program type trigger causes a fee assessment to be undertaken for students enrolled in programs that match the program type.

Student System - IGS_PS_TYPE_GRP	This table describes a program grouping of program types relating to the way DEET funds (approved EFTSU) programs. E.g. Higher Degree by Research, Higher Degree by Coursework, Other Postgraduate.
Column Name	Descritpion
COURSE_TYPE_GROUP_CD	Unique code for an institution-defined grouping of program types. Program type groups are aggregations of program types used for internal estimations of census date enrollment statistics.
CREATED_BY	Standard Who 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 the program type group.
CLOSED_IND	Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records.

Student System - IGS_PS_UNIT	This attribute describes the code allocated to a unit offered by the university.
Column Name	Descritpion
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
UNIT_CD	Unique identifier of the unit being offered.
CREATED_BY	Standard Who column

Student System - IGS_PS_CATEGORISE_ALL	This entity describes the categories, which are applicable to a program. There may be multiple categories for each program.
Column Name	Descritpion
COURSE_CD	Unique code for a program assigned to a program category.
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number of a program assigned to a program category.
ORG_ID	Operating unit identifier
COURSE_CAT	Unique identifier for the institution-defined program category.
CREATED_BY	Standard Who column

Student System - IGS_PS_CATLG_NOTES_ALL	Describes all the catalogs note.
Column Name	Descritpion
CATALOG_NOTE_ID	Unique identifier for catalog notes.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
CATALOG_VERSION_ID	Unique identifier for catalog versions.
NOTE_TYPE_ID	Unique identifier for note types.
CREATE_DATE	Creation date of catalog notes.
END_DATE	End date of catalog notes.
SEQUENCE	Unique identifier for the combination of both catalog version & note type.
NOTE_TEXT	Text-formatted note
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_CATLG_VERS_ALL	Entity to capture the catalog versions.
Column Name	Descritpion
CATALOG_VERSION_ID	Unique identifier for the catalog versions.
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
CATALOG_VERSION	Version of the catalog.
DESCRIPTION	Description of the catalog version.
CLOSED_IND	Indicator that specifies if the program category is open or closed. Setting the checkbox to closed prevents use of the program category in new or modified program categorization records.
CATALOG_SCHEDULE	Schedule of the catalog
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_DSCP_ALL	This entity describes the university set of discipline group codes. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Column Name	Descritpion
GOVT_DISCIPLINE_GROUP_CD	Describes the government discipline group to that this discipline code belongs.
CLOSED_IND	Indicator that specifies if the discipline is open or closed. Setting the indicator to closed prevents use of the discipline in new or modified discipline 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
ORG_ID	Operating unit identifier
DISCIPLINE_GROUP_CD	Describes the discipline group to that a unit of study belongs, as classified by the institution.
DESCRIPTION	Provides an explanation of the discipline group code.
FUNDING_INDEX_1	Funding index is used for determining Weighted Equivalent Full Time Student Unit. WEFTSU is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index.
FUNDING_INDEX_2	Funding index is used for determining Weighted Equivalent Full Time Student Unit. WEFTSU is equal EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index level funding index.
FUNDING_INDEX_3	The funding index is used for determining Weighted Equivalent Full Time Student Unit. WEFTSU is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index.

Student System - IGS_PS_DSCP_HIST_ALL	This entity describes the history of changes for a discipline.
Column Name	Descritpion
DISCIPLINE_GROUP_CD	Describes the discipline group to that a unit of study is classified by the institution.
CLOSED_IND	Indicator that specifies if the discipline is open or closed. Setting the indicator to closed prevents use of the discipline in new or modified discipline records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
HIST_START_DT	Effective start date and time of the history record.
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Updated by person at the time of history.
DESCRIPTION	Provides an explanation of the discipline group code.
FUNDING_INDEX_1	Funding index is used for determining Weighted Equivalent Full Time Student Unit. WEFTSU is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index.
FUNDING_INDEX_2	Funding index is used for determining Weighted Equivalent Full Time Student Unit. WEFTSU is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index.
FUNDING_INDEX_3	Funding index is used for determining Weighted Equivalent Full Time Student Unit. WEFTSU is equal to EFTSU that is Equivalent Full Time Student Unit multiplied by discipline funding index and then multiplied by level funding index.
GOVT_DISCIPLINE_GROUP_CD	Describes the government discipline group to that this discipline code belongs.

Student System - IGS_PS_FEE_TRG_HIST_ALL	This entity describes the history of changes to a program type/program group/program/program offering option fee trigger.
Column Name	Descritpion
FEE_CAT	Describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
SEQUENCE_NUMBER	Uniquely identifies the program fee trigger.
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Updated by person at the time of the history.
VERSION_NUMBER	Version number of the program. There can only be one version of a program with a system status of ACTIVE and an unset EXPIRY DATE.
CAL_TYPE	Academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization.
LOCATION_CD	Location code, or campus, of the program offering option.
ATTENDANCE_MODE	Mode of attendance of the program offering option.
ATTENDANCE_TYPE	Attendance type of the program offering option.
CREATE_DT	Contains the data and time the fee trigger was created.
FEE_CAL_TYPE	Calendar type with calendar category fee.
FEE_TRIGGER_GROUP_NUMBER	Describes the number that uniquely identifies the fee trigger group.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FEE_CI_SEQUENCE_NUMBER	Uniquely identifies the calendar instance.
ORG_ID	Operating unit identifier
FEE_TYPE	Describes the fee types used for the purpose of applying fees and charges. A fee type can be used with many fee categories, permitting a single system wide fee definition to be used. For example, HECS, GUILD.
COURSE_CD	Unique identifier for the program.

Student System - IGS_PS_FLD_OF_STUDY_ALL	This entity describes the university set of fields of study. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Column Name	Descritpion
FIELD_OF_STUDY	Unique identifier for the institution-defined field of study. Field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program.
CREATED_BY	Standard Who 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
FOS_TYPE_CODE	Field of Study Type Code
DESCRIPTION	Description of an institution-defined field of study. A field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program.
GOVT_FIELD_OF_STUDY	Unique identifier for the government defined field of study. Each institution-defined field of study is mapped to a government field of study.
CLOSED_IND	Indicator that specifies if the field of study is open or closed. Setting the checkbox to closed prevents use of the field of study in new or modified field of study records.

Student System - IGS_PS_FLD_STDY_HIST_ALL	This entity describes the history of changes for a field of study.
Column Name	Descritpion
FIELD_OF_STUDY	Describes the fields of study offered by the university. For example, 02 Architecture, 0204 Urban, and Regional Planning.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
HIST_START_DT	Effective start date and time of the history record.
ORG_ID	Operating unit identifier
HIST_END_DT	Effective end date and time of the history record.
FOS_TYPE_CODE	Field of Study Type Code.
HIST_WHO	Updated by person at the time of the history.
DESCRIPTION	Description of an institution-defined field of study. A field of study is a classification of programs based on similarity in terms of the vocational field of specialization or the principal subject matter of the program.
GOVT_FIELD_OF_STUDY	Unique identifier for the government-defined field of study. Each institution-defined field of study is mapped to a government field of study.
CLOSED_IND	Indicator that specifies if the field of study is open or closed. Setting the checkbox to closed prevents use of the field of study in new or modified field of study records.

Student System - IGS_PS_FLD_STD_HIST_ALL	This entity describes the history of program field of study changes for a program version.
Column Name	Descritpion
COURSE_CD	Describes the program code.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
VERSION_NUMBER	Version number of the program for that the field of study is being specified.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FIELD_OF_STUDY	Describes the fields of study offered by the university. For example, 02 Architecture, 0204 Urban, and Regional Planning.
ORG_ID	Operating Unit Identifier
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Oracle username of the person who created the history record.
PERCENTAGE	Details the percentage split between multiple fields of study, or will be 100% if there is only one field of study.
MAJOR_FIELD_IND	Describes the nominated fields of study that are the major ones.

Student System - IGS_PS_GRP_ALL	This entity describes a grouping of programs, which are used for a variety of purposes within the system.
Column Name	Descritpion
COURSE_GROUP_TYPE	Unique identifier for the institution-defined type of program group. Each program group must be assigned a program group type. For example, Equivalents, Available Double Program, Common Entrance Requirements.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution- defined attendance mode 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
COURSE_GROUP_CD	Unique identifier for a group of programs. Program groups are used to link programs with common institution-defined properties. They can be used for purposes such as student progression and permitted double degree combinations.
ORG_ID	Operating unit identifier
DESCRIPTION	Description of the program group. Program groups are used to link programs with common institution-defined common properties. They can be used for purposes such as student progression and permitted double degree combinations.
RESPONSIBLE_ORG_UNIT_CD	Code of the organization unit responsible for the program group.
RESPONSIBLE_OU_START_DT	Start date of the organizational unit responsible for the program group.

Student System - IGS_PS_MEDIA_EQUIP_ALL	Entity to capture the Media and Equipment information
Column Name	Descritpion
MEDIA_CODE	Unique Identifier for the equipment information.
MEDIA_DESCRIPTION	Description for the equipment information.
CLOSED_IND	Indicator that specifies if the government attendance mode is open or closed. Setting the checkbox to closed prevents use of the government attendance mode in new or modified institution-defined attendance mode 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
ORG_ID	Operating unit identifier

Student System - IGS_PS_NOTE_TYPE_ALL	This entity describes the available program note types.
Column Name	Descritpion
CRS_NOTE_TYPE	Institution-defined note type relating to a program. Note types can be defined for any purpose. For example, institutions may define Handbook note types as items for publication in the institution's official handbook.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
DESCRIPTION	Description of an institution-defined note type relating to a program.

Student System - IGS_PS_OCCUP_TITLES_ALL	Entity to capture the relation between Programs and Dictionary of Occupational Titles.
Column Name	Descritpion
PROGRAM_OCCUPATIONAL_TITLE_ID	Unique Identifier for programs and dictionary of occupational titles.
PROGRAM_CODE	Code of the programs for dictionary of occupational titles.
OCCUPATIONAL_TITLE_CODE	Code of the occupational title for dictionary of occupational titles.
CREATED_BY	Standard Who 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_PS_OFR_ALL	This entity describes an offering of a university program within a calendar type.
Column Name	Descritpion
COURSE_CD	The unique identifier for a program being offered.
ATTRIBUTE18	Attribute for descriptive Flexfield
ATTRIBUTE19	Attribute for descriptive Flexfield
ATTRIBUTE20	Attribute for descriptive Flexfield
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE_CATEGORY	Category of the attribute for descriptive Flexfield
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
ATTRIBUTE1	Attribute for descriptive Flexfield
ATTRIBUTE2	Attribute for descriptive Flexfield
ATTRIBUTE3	Attribute for descriptive Flexfield
ATTRIBUTE4	Attribute for descriptive Flexfield
ATTRIBUTE5	Attribute for descriptive Flexfield
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset Expiry Date.
ATTRIBUTE6	Attribute for descriptive Flexfield
ATTRIBUTE7	Attribute for descriptive Flexfield
ATTRIBUTE8	Attribute for descriptive Flexfield
ATTRIBUTE9	Attribute for descriptive Flexfield
ATTRIBUTE10	Attribute for descriptive Flexfield
ATTRIBUTE11	Attribute for descriptive Flexfield
CAL_TYPE	Academic calendar type in that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization.
ATTRIBUTE12	Attribute for descriptive Flexfield
ATTRIBUTE13	Attribute for descriptive Flexfield
ATTRIBUTE14	Attribute for descriptive Flexfield
ATTRIBUTE15	Attribute for descriptive Flexfield
ATTRIBUTE16	Attribute for descriptive Flexfield
ATTRIBUTE17	Attribute for descriptive Flexfield

Student System - IGS_PS_OFR_OPT_ALL	This entity describes the available options for each program offering.
Column Name	Descritpion
ATTRIBUTE10	Attribute for descriptive Flexfield
ATTRIBUTE11	Attribute for descriptive Flexfield
ATTRIBUTE12	Attribute for descriptive Flexfield
ATTRIBUTE13	Attribute for descriptive Flexfield
VERSION_NUMBER	Version number of the program being offered. There can only be one version of a program with a system status of Active and an unset expiry date.
ATTRIBUTE14	Attribute for descriptive Flexfield
ATTRIBUTE15	Attribute for descriptive Flexfield
ATTRIBUTE16	Attribute for descriptive Flexfield
ATTRIBUTE17	Attribute for descriptive Flexfield
ATTRIBUTE18	Attribute for descriptive Flexfield
ATTRIBUTE19	Attribute for descriptive Flexfield
CAL_TYPE	Academic calendar type in that the program is offered. For example, ACAD-YR that is standard academic Year.
ATTRIBUTE20	Attribute for descriptive Flexfield
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
LOCATION_CD	Location code, or campus, of the program offering option.
PROGRAM_LENGTH	The time frame in which a student is expected to complete the program.
PROGRAM_LENGTH_MEASUREMENT	The measurement used to determine program length.
DELETE_FLAG	This indicator to indicate a record is logically deleted or not. If set to 'Y' the record is logically deleted else not.
ATTENDANCE_MODE	Mode of attendance of the program offering option.
ATTENDANCE_TYPE	Attendance type of the program offering option.
COO_ID	Unique number that references the particular program offering option.
FORCED_LOCATION_IND	Indicator that specifies whether the student program attempt location is forced or restricted.
FORCED_ATT_MODE_IND	Indicator that specifies whether the student program attempt attendance mode is forced or restricted.
FORCED_ATT_TYPE_IND	Indicator that specifies whether the student program attempt attendance type is forced or restricted.
TIME_LIMITATION	Time limit in years for completion of the program offering option. Students who exceed this limit can be asked to show cause why they should not be excluded from further enrollment in the program.
ENR_OFFICER_PERSON_ID	The ID of a staff member recognized as the enrollment officer for the program offering option.
ATTRIBUTE_CATEGORY	Attribute category for descriptive Flexfield
ATTRIBUTE1	Attribute for descriptive Flexfield
ATTRIBUTE2	Attribute for descriptive Flexfield
ATTRIBUTE3	Attribute for descriptive Flexfield
ATTRIBUTE4	Attribute for descriptive Flexfield
ATTRIBUTE5	Attribute for descriptive Flexfield
ATTRIBUTE6	Attribute for descriptive Flexfield
ATTRIBUTE7	Attribute for descriptive Flexfield
COURSE_CD	Code used to identify the program in that the student is enrolled.
ATTRIBUTE8	Attribute for descriptive Flexfield
ATTRIBUTE9	Attribute for descriptive Flexfield

Student System - IGS_PS_OWN_HIST_ALL	This entity describes the history of program ownership changes for a program version.
Column Name	Descritpion
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Updated by person at the time of the history.
PERCENTAGE	Details the percentage split between multiple owners of a program, or will be 100% if there is only one owner.
COURSE_CD	Describes the program code. DETYA element reference 307.
CREATED_BY	Standard Who 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
VERSION_NUMBER	Version number of a program for that ownership is being specified.
ORG_UNIT_CD	Describes the code that uniquely identifies an academic or administrative organizational unit operating within the university structure. DEET element reference 333.
OU_START_DT	Describes the date from that the organizational unit is effective.

Student System - IGS_PS_PREFS_SCH_INT_ALL	Describes the preferences of unit section occurrences of scheduling interface.
Column Name	Descritpion
REFERENCE_CD	This is the reference code for a Unit Section Occurrence.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REFERENCE_CD_TYPE	This identifies the reference type for an Unit Section Occurrence.
TRANSACTION_ID	Unique Identifier for Scheduling Interface - Obsolete.
UNIT_SECTION_OCCURRENCE_ID	Unique Identifier for Unit Section Occurrence - Obsolete
ORG_ID	Operating unit identifier
INT_PREFS_ID	Unique Identifier for Unit Section Occurrence Preference in the Scheduling Interface.
INT_OCCURS_ID	Unique identifier for the Unit Section Occurrence in Scheduling interface
REFERENCE_CODE_DESCRIPTION	Description of Reference code for the unit section occurrence.
REFERENCE_TYPE_DESCRIPTION	Description of Reference code type for the unit section occurrence.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Student System - IGS_PS_REF_CD_HIST_ALL	This entity describes the history of program reference code changes for a program version.
Column Name	Descritpion
COURSE_CD	Describes the program code DETYA Element Number 307.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
VERSION_NUMBER	Version number of the program for that the program reference code is being specified.
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
REFERENCE_CD_TYPE	Describes the type or classification of reference codes that are applied to the program version.
REFERENCE_CD	An Other System reference code for a program. For example, an IVRS code used to represent a program.
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Oracle username of the person who created the history record.
DESCRIPTION	Provides an explanation of the program reference code.

Student System - IGS_PS_SCH_HDR_INT_ALL	This entity is used to store master information of Scheduling Interface.
Column Name	Descritpion
TRANSACTION_ID	Unique identifier for a transaction in scheduling interface.
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORIGINATOR	The type source of the request made. For example, external, internal.
REQUEST_DATE	Date on that the request is made.
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
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_SCH_INT_ALL	This entity holds the interface objects for scheduler.
Column Name	Descritpion
CALENDAR_TYPE	Type of calendar used for scheduling - Obsolete
WEDNESDAY	Indicator to show if a Unit section occurrence can be scheduled Wednesday or not.
THURSDAY	Indicator to show if a Unit section occurrence can be scheduled Thursday or not.
FRIDAY	Indicator to show if a Unit section occurrence can be scheduled Friday or not.
SATURDAY	Indicator to show if a Unit section occurrence can be scheduled Saturday or not.
SUNDAY	Indicator to show if a Unit section occurrence can be scheduled Sunday or not.
UNIT_SECTION_START_DATE	Start date of the unit section - Obsolete
UNIT_SECTION_END_DATE	End date of the unit section - Obsolete
START_TIME	Start time of the unit section occurrence.
END_TIME	End time of the unit section occurrence.
ENROLLMENT_MAXIMUM	Maximum number of enrollments for the unit section that can be done - Obsolete
SEQUENCE_NUMBER	Sequence number of the unit section for that a scheduling is planned - Obsolete
ENROLLMENT_ACTUAL	Actual number of enrollments for the unit section -Obsolete
INSTRUCTOR_ID	Unique identifier of the lead instructor.
SURNAME	Surname of the lead instructor.
BUILDING_CODE	Scheduled Building Identifier-Obsolete
ROOM_CODE	Scheduled Room Identifier-Obsolete
LOCATION_CD	Code of the place where the unit offering is made - Obsolete
UNIT_SEC_CROSS_UNIT_SEC_ID	Unique identifier for cross-listed unit section occurrence - Obsolete
UOO_ID	Unique identifier of unit section - Obsolete
SCHEDULE_STATUS	Status of the unit section occurrence schedule. Values are: PROCESSING, ERROR, TBA, SCHEDULED, CANCELLED, USER_CANCEL, USER_UPDATE
ERROR_TEXT	Error message that is output after the scheduler runs.
TRANSACTION_TYPE	Transaction type for scheduling interface. Values are: REQUEST, UPDATE, CANCEL
TRANSACTION_ID	Unique identifier for transactions with scheduler - Obsolete
ORG_ID	Operating unit identifier
INT_OCCURS_ID	Unique identifier for a unit section occurrence in the Scheduler Interface.
INT_USEC_ID	Unique identifier for a Unit Section in the Scheduler Interface.
GIVEN_NAMES	The given names of the lead instructor
MIDDLE_NAME	Middle name of the lead instructor
DEDICATED_BUILDING_CODE	Dedicated Building Identifier-Obsolete
DEDICATED_ROOM_CODE	Dedicated Room Identifier-Obsolete
PREFERRED_BUILDING_CODE	Preferred Building Identifier-Obsolete
PREFERRED_ROOM_CODE	Preferred Room Identifier-Obsolete
TBA_STATUS	To Be Announced Unit Section Occurrence. If the value is 'Y' then it is to be announced unit section occurrence.
USO_START_DATE	Unit Section Occurrence Start Date
USO_END_DATE	Unit Section Occurrence End Date
BUILDING_ID	Scheduled Building Identifier.
ROOM_ID	Scheduled Room Identifier.
DEDICATED_BUILDING_ID	Dedicated Building Identifier.
DEDICATED_ROOM_ID	Dedicated Room Identifier.
PREFERRED_BUILDING_ID	Preferred Building Identifier.
PREFERRED_ROOM_ID	Preferred Room Identifier.
PREFERRED_REGION_CODE	User Preferred Region Code for the unit section occurrence. E.g. North Campus ,South Campus.
UNIT_SECTION_OCCURRENCE_ID	Unique identifier for each unit section occurrence.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ABORT_FLAG	Flag to indicate whether the occurrence is ABORTED.
IMPORT_DONE_FLAG	Flag to indicate whether the occurrence has been imported to production.
UNIT_CD	Code of the unit - Obsolete
OCCURRENCE_IDENTIFIER	Unique identity for an occurrence within a unit section.
VERSION_NUMBER	Version number of the unit for that the scheduling is planned - Obsolete
UNIT_TITLE	The name of the unit that is offered - Obsolete
OWNER_ORG_UNIT_CD	Identifier for the owner of the organizational unit section - Obsolete
UNIT_CLASS	Time and mode of availability of a class - Obsolete
MONDAY	Indicator to show if a Unit section occurrence can be scheduled on Monday or not.
TUESDAY	Indicator to show if a Unit section occurrence can be scheduled on Tuesday or not.

Student System - IGS_PS_TCH_RESP_HIST_ALL	This entity describes the history of changes to a unit version's teaching responsibility.
Column Name	Descritpion
UNIT_CD	Code used to identify the unit.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
ORG_ID	Operating unit identifier
ORG_UNIT_CD	Describes the code that uniquely identifies an academic or administrative organizational unit operating within the university structure. DEET element reference 333.
OU_START_DT	Describes the date from that the organizational unit is effective.
HIST_START_DT	Effective start date and time of the history record.
HIST_END_DT	Effective end date and time of the history record.
HIST_WHO	Updated by person at the time of history.
PERCENTAGE	Percentage allocation of teaching responsibility to an organizational unit for a unit of study.

Student System - IGS_PS_TCH_RESP_OVRD_ALL	This table describes the teaching responsibility override details for a given unit offering option. Where an override is specified, it must total 100% for any given unit offering option.
Column Name	Descritpion
UOO_ID	Identifier for unit offering option.
PERCENTAGE	Describes the percentage of the teaching responsibility that applies to the organizational 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
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
UNIT_CD	Describes the unit code to that the teaching responsibility applies.
VERSION_NUMBER	Describes the unit code to that the teaching responsibility applies.
CAL_TYPE	Describes the teaching calendar type to that the teaching responsibility override applies.
CI_SEQUENCE_NUMBER	Describes the teaching calendar sequence number to that the teaching responsibility override applies.
LOCATION_CD	Describes the location to that the teaching responsibility override applies.
UNIT_CLASS	Describes the unit class to that the teaching responsibility override applies.
ORG_UNIT_CD	Describes the organization unit responsible for teaching the unit offering option.
OU_START_DT	Describes the organization unit start date responsible for teaching the unit offering option.

Student System - IGS_PS_TCH_RSOV_HIST_ALL	This table describes the teaching responsibility override details for a given unit offering option. Where an override is specified, it must total 100% for any given unit offering option.
Column Name	Descritpion
UNIT_CD	Describes the unit code to that the teaching responsibility applies.
LAST_UPDATE_LOGIN	Standard Who column
ORG_ID	Operating unit identifier
VERSION_NUMBER	Describes the unit code to that the teaching responsibility applies.
CAL_TYPE	Describes the teaching calendar type to that the teaching responsibility override applies.
CI_SEQUENCE_NUMBER	Describes the teaching calendar sequence number to that the teaching responsibility override applies.
LOCATION_CD	Describes the location to that the teaching responsibility override applies.
UNIT_CLASS	Describes the unit class to that the teaching responsibility override applies.
ORG_UNIT_CD	Describes the organization unit responsible for teaching the unit offering option.
OU_START_DT	Describes the organization unit start date responsible for teaching the unit offering option.
HIST_START_DT	Describes the date from that the history started being effective.
HIST_END_DT	Describes the date on that the history stopped being effective.
HIST_WHO	Describes the oracle user who altered the record resulting in the history.
PERCENTAGE	Describes the percentage of the teaching responsibility that applies to the organizational unit.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_TYPE_ALL	This entity describes the university set of program types. This set is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Column Name	Descritpion
GOVT_COURSE_TYPE	Unique code for the government program type to that the institution-defined program type is mapped DETYA element reference number 310.
AWARD_COURSE_IND	Indicator that specifies whether the program is an award or non-award program. Setting the indicator ticked classifies the program as award program.
COURSE_TYPE_GROUP_CD	Unique code for an institution-defined grouping of program types. Program type groups are aggregations of program types used for internal estimations of census date enrollment statistics.
TAC_COURSE_LEVEL	Program level for the program type, as recognized by the Tertiary Admissions Centre.
RESEARCH_TYPE_IND	Indicator that specifies whether the program type is regarded by the institution as a research program for that candidature details are collected and maintained as part of the admission and or enrollment process.
CLOSED_IND	Indicator that specifies if the program type is open or closed. Setting the checkbox to Closed ticked prevents use of the program 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
ORG_ID	Operating unit identifier
PRIMARY_AUTO_SELECT	Indicates whether the program type will be assigned manually or by system itself. Default value is 'Y'
ENROLMENT_CAT	Default Enrollment Category
COURSE_TYPE	Institution-defined program type. Program type indicates the type of higher education program. Each program type must map to a government program type DETYA element reference number 310.
FIN_AID_PROGRAM_TYPE	A system defined program type that is used by Financial Aid.
DESCRIPTION	Description of the institution-defined program type. A program type indicates the type of higher education program. For example, Bachelor's Pass, Graduate Certificate, Higher Degree by Research.

Student System - IGS_PS_TYPE_HIST_ALL	This entity describes the history of changes for a program type.
Column Name	Descritpion
COURSE_TYPE	Describes the type of programs offered by the university. Program type is an element defined by DEET. However, the system is not limited to the DEET list. DEET element reference310. For example, 01 Higher Doctorate, 20 Diploma.
AWARD_COURSE_IND	Indicator that specifies if the program award is open or closed.
COURSE_TYPE_GROUP_CD	Unique code for an institution-defined grouping of program types. Program type groups are aggregations of program types used for internal estimations of census date enrollment statistics.
TAC_COURSE_LEVEL	Program level for the program type, as recognized by the Tertiary Admissions Centre.
RESEARCH_TYPE_IND	Indicator that specifies if the program is of research type or not.
HIST_START_DT	Effective start date and time of the history record.
CLOSED_IND	Indicator that specifies if the program type group is open or closed. Setting the checkbox to closed ticked prevents use of the program type group in new or modified program type records.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
HIST_END_DT	Effective end date and time of the history record.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
HIST_WHO	Updated by person at the time of the history.
ORG_ID	Operating unit identifier
DESCRIPTION	Description of the institution-defined program type.
PRIMARY_AUTO_SELECT	Primary Auto Select Y/N Field, Default 'Y'
FIN_AID_PROGRAM_TYPE	A program type that is used by Financial Aid.
GOVT_COURSE_TYPE	Unique code for the government program type to that the institution-defined program type is mapped.

Student System - IGS_PS_SCH_USEC_INT_ALL	Interface Table to capture the Scheduler Interface Unit Section Data
Column Name	Descritpion
CALENDAR_TYPE	Type of calendar used for scheduling.
ENROLLMENT_EXPECTED	Enrollment Expected at unit section level.
OVERRIDE_ENROLLMENT_MAX	Maximum Enrollment Number at unit section level.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
SEQUENCE_NUMBER	Sequence number of the unit section for that a scheduling is planned.
LAST_UPDATE_LOGIN	Standard Who column
IMPORT_DONE_FLAG	Flag to indicate whether the section has been imported to production.
INT_PAT_ID	Unique identifier for a Unit Offering Pattern in scheduling interface.
ABORT_FLAG	Flag to indicate whether the section is ABORTED.
UNIT_CD	Code of the unit.
CALL_NUMBER	Call Number value in the production table.
SUBTITLE	Subtitle of the unit section if exists else subtitle of the corresponding unit.
ORG_UNIT_DESCRIPTION	Description of the organizational unit.
TEACHING_CAL_ALTERNATE_CODE	Alternate code for the teaching calendar instance.
VERSION_NUMBER	Version number of the unit for that the scheduling is planned.
UNIT_TITLE	The name of the unit that is offered.
OWNER_ORG_UNIT_CD	Identifier for the owner of the organizational unit section.
UNIT_CLASS	Time and mode of availability of a class.
UNIT_SECTION_START_DATE	Start date of the unit section.
INT_USEC_ID	Unique identifier for each Unit Section in the Scheduler Interface
UNIT_SECTION_END_DATE	End date of the unit section.
UNIT_SECTION_STATUS	Status of the unit section occurrence. For example, planned , inactive.
ENROLLMENT_MAXIMUM	Maximum number of enrollments for the unit section.
ENROLLMENT_ACTUAL	Actual number of enrollments for the unit section.
LOCATION_CD	Code of the location where the unit section is held.
CAL_START_DT	Start Date of the Calendar Period
CAL_END_DT	End Date of the Calendar Period
UOO_ID	Unique identifier of unit section.
TRANSACTION_ID	No Longer Used
ORG_ID	Operating unit identifier

Student System - IGS_PS_SCH_X_USEC_INT_ALL	To capture the scheduler Interface Unit Section Cross Listings Data
Column Name	Descritpion
INT_USEC_ID	Unique identifier for each Unit Section in the Scheduler Interface Table
CLASS_MAX_ENROLLMENT_NUMBER	Maximum Enrollment Number
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
UNIT_SEC_CROSS_UNIT_SEC_ID	Unique identifier for the cross listed unit sections.
LAST_UPDATE_LOGIN	Standard Who column
PARENT_UOO_ID	Unique identifier for the parent unit section.
CHILD_UOO_ID	Unique identifier for the Child unit section.
CHILD_UNIT_CD	Code which identifies a Child Unit
CHILD_VERSION_NUMBER	Version number of the Child unit, which is cross listed
CHILD_TITLE	The name of the Child unit that is offered.
CHILD_CAL_TYPE	Type of Child calendar for which scheduling is done.
INT_USEC_X_USEC_ID	Unique identifier for each Unit Section Cross Listings in the Scheduler Interface Table
CHILD_ALTERNATE_CODE	Alternate Code of the calendar instance.
START_DT	Date on which this version of the unit becomes current.
END_DT	Date on which this version of the unit ends.
CHILD_CI_SEQUENCE_NUMBER	Sequence number for a calendar instance.
CHILD_UNIT_CLASS	Time and mode of availability of a child class
CHILD_UNIT_MODE	Mode in which the Child Unit is offered.
CHILD_LOCATION_CD	Code of the location where the Child unit offering is held.
CHILD_LOCATION_DESCRIPTION	Name of the Location at which the Child Unit is being offered.
ORG_ID	Operating Unit Identifier.
CROSS_LIST_GROUP_NAME	Cross Listed Group Name

Student System - IGS_PS_SCH_FACLT_ALL	Contains information about the facilities associated with a unit section occurrence for a particular transaction.
Column Name	Descritpion
FACILITY_ID	Sequence generated number to uniquely identify a facility associated with a unit section occurrence.
LAST_UPDATE_LOGIN	Standard Who column
FACILITY_CODE	Code of Facility
FACILITY_DESCRIPTION	Description of Facility
ORG_ID	Operation unit identifier
INT_OCCURS_ID	Unique identifier for the Unit Section Occurrence in scheduling interface.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PS_SCH_MWC_ALL	Contains information about meet with group associated with a unit section occurrence for a particular transaction.
Column Name	Descritpion
MWC_GROUP_ID	Sequence generated number to uniquely identify a meet with group
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
HOST_UOO_ID	Identifier for Host Unit Section of Meet With Class Group
GUEST_UOO_ID	Identifier for Guest Unit Section of Meet with Class Group
INT_USEC_ID	Unique Identifier for the Unit Section in the Scheduling Interface
MEET_WITH_CLASS_GROUP_NAME	Meet With Class Group Name
HOST_USO_ID	Identifier of Host Unit Section Occurrence of Meet With Class Group - Obsolete
GUEST_USO_ID	Identifier of Guest Unit Section Occurrence of Meet With Class Group - Obsolete
MWC_MAX_ENROLLMENT_NUMBER	Maximum Enrollment associated with meet with group
ORG_ID	Operating unit identifier
INT_OCCURS_ID	Unique identifier for the Unit Section Occurrence in scheduling interface - Obsolete
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_SCH_INSTR_ALL	Contains information about all the instructors associated with a unit section occurrence for a particular transaction
Column Name	Descritpion
INT_INSTRUC_ID	Sequence generated number to uniquely identify an instructor
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INSTRUCTOR_ID	User Defined Instructor Identifier
SURNAME	Surname of the Instructor
PERSON_NAME	Full name of the Instructor
GIVEN_NAMES	Given Names of the Instructor
MIDDLE_NAME	Middle Name of the Instructor
INT_OCCURS_ID	Unique identifier for the Unit Section Occurrence in scheduling interface.
ORG_ID	Operating unit identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_RSV_EXT	Contains the seats used for each reserve seating category.
Column Name	Descritpion
RSV_EXT_ID	Primary Key
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
UOO_ID	Unit Section ID for which the actual enrollment against reservation is created.
PRIORITY_ID	Priority ID of Reserve Seating set up
PREFERENCE_ID	Preference ID of Reserve Seating set up
RSV_LEVEL	The level at which priority and preferences are defined.(USEC, UOPT, ORG)
ACTUAL_SEAT_ENROLLED	Actual number of seats enrolled against the priority and preference of reservation
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Student System - IGS_PS_RSV_TEMP	Contains the details for a short time to revert back the changes in the various system tables if the transaction is not complete in self service due to unexpected errors such as browser window is closed abruptly or client machine is shutdow
Column Name	Descritpion
RSV_TEMP_ID	Primary Key
UOO_ID	Unit Section ID for which the actual enrollment against reservation is created.
RSV_EXT_ID	Priority ID of Reserve Seating setup
TIME_STAMP	Date and time when the record was created.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_SH_USEC_OCCURS	This table is used to store the shadow table to Unit Section Occurrence Table.
Column Name	Descritpion
USECSH_ID	Unique Identifier for the Shadow Records
ROOM_CODE	Old value of Room Code
BUILDING_CODE	Old value of Building Code
START_TIME	Old value of Start Time of Unit Section Occurrence
END_TIME	Old value of End Time of Unit Section Occurrence
INSTRUCTOR_ID	Old value for Instructor
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
UNIT_SECTION_OCCURRENCE_ID	Unit Section Occurrence Id
MONDAY	Old value whether Unit Section Occurrence was on Monday
TUESDAY	Old value whether Unit Section Occurrence was on Tuesday
WEDNESDAY	Old value whether Unit Section Occurrence was on Wednesday
THURSDAY	Old value whether Unit Section Occurrence was on Thursday
FRIDAY	Old value whether Unit Section Occurrence was on Friday
SATURDAY	Old value whether Unit Section Occurrence was on Saturday
SUNDAY	Old value whether Unit Section Occurrence was on Sunday

Student System - IGS_PS_RSV_OGPRI_ALL	Describes priorities for the reserved seating at Organization level
Column Name	Descritpion
RSV_ORG_UNIT_PRI_ID	System generated sequence Number, uniquely identify the Reserved Seating Priorities at Organizational Unit level
LAST_UPDATE_LOGIN	Standard who column
ORG_UNIT_CD	Organizational Unit Code
PRIORITY_ORDER	Priority Order
PRIORITY_VALUE	Priority Value
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_PS_RSV_ORGUN_PRF	Describes the preferences for a given priority for reserved seating at Organization unit level
Column Name	Descritpion
RSV_ORG_UNIT_PRF_ID	System generated sequence Number, uniquely identify the Preference Code for corresponding Reserved Seating Priority at Organizational Unit level
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
RSV_ORG_UNIT_PRI_ID	Foreign key column to IGS_PS_RSV_ORGUN_PRI
PREFERENCE_ORDER	Preference Order
PREFERENCE_CODE	Preference code for the corresponding Priority
PREFERENCE_VERSION	Version of the Preference Code
PERCENTAGE_RESERVED	Percentage of reserved seating
GROUP_ID	The group id corresponding to person group code.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Student System - IGS_PS_RSV_UOP_PRF	Describes the preferences for a given priority for reserved seating at unit offering pattern level
Column Name	Descritpion
RSV_UOP_PRF_ID	System generated sequence Number, uniquely identify the Preference Code for corresponding Reserved Seating Priority at Organizational Unit level
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
RSV_UOP_PRI_ID	Foreign key column to IGS_PS_RSV_UOP_PRI
PREFERENCE_ORDER	Preference Order
PREFERENCE_CODE	Preference code for the corresponding Priority
PREFERENCE_VERSION	Version of the Preference Code
PERCENTAGE_RESERVED	Percentage of reserved seating
GROUP_ID	The group id corresponding to person group code.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Student System - IGS_PS_RSV_UOP_PRI	Describes priorities for the reserved seating at Unit Offering pattern level
Column Name	Descritpion
RSV_UOP_PRI_ID	System generated sequence Number, uniquely identify the Reserved Seating Priorities at Organizational Unit level
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
UNIT_CD	Unit Code
VERSION_NUMBER	Unit Version
CALENDER_TYPE	Calendar Type
CI_SEQUENCE_NUMBER	Sequence number of Calendar Type
PRIORITY_ORDER	Priority Order
PRIORITY_VALUE	Priority Value
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Student System - IGS_PS_RSV_USEC_PRF	Describes the preferences for a given priority for reserved seating at unit section level
Column Name	Descritpion
RSV_USEC_PRF_ID	System generated sequence Number, uniquely identify the Preference Code for corresponding Reserved Seating Priority at Organizational Unit level
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
RSV_USEC_PRI_ID	Foreign key column to IGS_PS_RSV_USEC_PRI
PREFERENCE_ORDER	Preference Order
PREFERENCE_CODE	Preference code for the corresponding Priority
PREFERENCE_VERSION	Version of the Preference Code
PERCENTAGE_RESERVED	Percentage of reserved seating
GROUP_ID	The group id corresponding to person group code.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column

Student System - IGS_PS_RSV_USEC_PRI	Describes priorities for the reserved seating at unit Section level
Column Name	Descritpion
RSV_USEC_PRI_ID	System generated sequence Number, uniquely identify the Reserved Seating Priorities at Organizational Unit level
UOO_ID	Unit Offering Option Code
PRIORITY_ORDER	Priority Order
PRIORITY_VALUE	Priority Value
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Student System - IGS_PS_RPT_FMLY_ALL	The units are to be grouped under common code to indicate they belong to same repeat family. This tables records the repeat code under which units are grouped together
Column Name	Descritpion
RPT_FMLY_ID	Unique System generated number to identify the repeat details. Populated by IGS_PS_RPT_FMLY_ALL_S
LAST_UPDATE_LOGIN	Standard Who column
REPEAT_CODE	The repeat code to indicate the repeat family
DESCRIPTION	Description for repeat code
CLOSED_IND	It indicates if the repeat code is available for use or not.
ORG_ID	Operating Unit Identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Student System - IGS_PR_STAT_TYPE	Defines the Statistics Types which will be used for a Particular Installation
Column Name	Descritpion
STAT_TYPE	Statistic Type
DESCRIPTION	Description of Statistic Type
CLOSED_IND	Closed Indicator (Y/N)
DERIVATION	Derivation of the Statistics Type (Calculated, Stored or Both)
CREATED_BY	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_PR_STA_TYPE_ELE	Defines the System Statistic Element which relate to a particular user defined Statistic Type
Column Name	Descritpion
STAT_TYPE	Statistic Type
DISPLAY_ORDER	OBSOLETE
S_STAT_ELEMENT	System Statistic Element
CREATED_BY	Standard WHO 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_STDNT_PR_AWD	Stores the awards associated with the positive outcome of the rule for a student's program attempt
Column Name	Descritpion
PERSON_ID	Person ID of the student
COURSE_CD	Program code of the program attempted for which the student is awarded.
SPO_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_SPO_INTERFACE	Student Progression Outcome Interface Table primarily using to import details entered in Web ADI for progression Outcomes.
Column Name	Descritpion
BATCH_DATE	The batch date .
PERSON_NUMBER	Student Number.
ANONYMOUS_ID	Anonymous Number.
COURSE_CD	Course Code.
PROGRESSION_OUTCOME_TYPE	Progression Outcome Type.
COMMENTS	Comments.
ERROR_CODE	Error code to be replaced by import process.
YOP_MARK	Year Of Program - Mark
YOP_GRADE	Year Of Program - Grade
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
USER_ID	User Identification Number.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_PS_ACCTS_ALL	This table contains account segment values for a program
Column Name	Descritpion
COURSE_ACCOUNT_ID	Sequence generated primary key column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COURSE_CD	Program code
VERSION_NUMBER	Program code version number
SEGMENT	GL accounting flex field structure segment name
SEGMENT_NUM	GL accounting flex field structure segment number
SEGMENT_VALUE	GL accounting flex field structure segment value
ORG_ID	Multi org unit operating ID
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Student System - IGS_PS_PRG_UNIT_REL	This table will store the relationship between Program type and unit type levels
Column Name	Descritpion
PS_PRUN_REL_ID	System generated number to uniquely identify the program and unit relationship.
LAST_UPDATE_LOGIN	Standard WHO Column
STUDENT_CAREER_LEVEL	Student program Type level
UNIT_TYPE_ID	ID for Program type level of unit
STUDENT_CAREER_TRANSCRIPT	Whether the unit should appear on transcript or not
STUDENT_CAREER_STATISTICS	Whether the unit should be considered for statistics 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_PS_EXP_WL	This table stores the set up data regarding expected workload in a given calendar category.
Column Name	Descritpion
CONTROL_NUM	No longer used.
CALENDAR_CAT	Calendar Category at which the Expected workload is set at institutional level. Permissible values are Term (Load) and Academic calendar categories
EXPECTED_WL	Expected Workload in the given Calendar Category - Obsolete
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_FAC_ASG_TASK	This table stores assigned task for the faculty
Column Name	Descritpion
FAC_WL_ID	Foreign key to the parent table IGS_PS_FAC_WL
LAST_UPDATE_LOGIN	Standard WHO column
FACULTY_TASK_TYPE	Task type assigned to the faculty
DEPT_BUDGET_CD	Department Budget code. The defaulted value can be overridden.
DEFAULT_WL	Default workload for the given Faculty Task type. The defaulted value can be overridden.
CONFIRMED_IND	Indictor which determines whether the given task has been confirmed or not. Only confirmed tasks are added to get the total workload
NUM_ROLLOVER_PERIOD	The number of times the task has to be rolled over. Valid values are 0 or greater than zero
ROLLOVER_FLAG	Denotes either the record has been sourced for rollover or the record has been created as a result of rollover. The permissible values are S,D or NULL.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Student System - IGS_PS_FAC_OVR_WL	This table stores assigned task for the faculty
Column Name	Descritpion
FAC_WL_ID	Foreign key to the parent table IGS_PS_FAC_WL
LAST_UPDATE_LOGIN	Standard WHO column
START_DATE	Start Date of the Overridden expected workload
END_DATE	End Date of the Overridden expected workload
NEW_EXP_WL	New expected workload for the period defined by the Start and end date
FAC_OVR_WL_ID	Sequence generated primary key
OVERRIDE_REASON	Reason for overriding the workload
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Student System - IGS_PS_FAC_TASK_TYP	This table stores Faculty Task types and corresponding default workloads
Column Name	Descritpion
FACULTY_TASK_TYPE	Institution defined Faculty Task Type
LAST_UPDATE_LOGIN	Standard WHO column
DESCRIPTION	Description of Faculty Task Type
DEPT_BUDGET_CD	Department Budget Code
DEFAULT_WL	Default Workload for the given Faculty Task Type
CLOSED_IND	Closed Indicator, indicates the faculty task type is closed or not. Once the faculty task type is closed then corresponding faculty task type is not displayed in LOV of forms and not considered for processing.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Student System - IGS_PS_FAC_TCFT_TMP	This is temporary table stores detail of the instructor and time conflicting unit section occurrences of the instructor, which will be used in Time conflict report
Column Name	Descritpion
PERSON_ID	Instructor ID for whom time conflicting unit section occurrence exist
USEC_OCCUR_ID1	First conflicting unit section occurrence
USEC_OCCUR_ID2	Second conflicting unit section occurrence
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_PS_FAC_WL	This table stores the workload for the faculty
Column Name	Descritpion
FAC_WL_ID	Sequence generated primary key
ATTRIBUTE3	Attribute of the DFF
ATTRIBUTE4	Attribute of the DFF
ATTRIBUTE5	Attribute of the DFF
ATTRIBUTE6	Attribute of the DFF
ATTRIBUTE7	Attribute of the DFF
ATTRIBUTE8	Attribute of the DFF
ATTRIBUTE9	Attribute of the DFF
ATTRIBUTE10	Attribute of the DFF
ATTRIBUTE11	Attribute of the DFF
ATTRIBUTE12	Attribute of the DFF
PERSON_ID	Person Id of the faculty
ATTRIBUTE13	Attribute of the DFF
ATTRIBUTE14	Attribute of the DFF
ATTRIBUTE15	Attribute of the DFF
ATTRIBUTE16	Attribute of the DFF
ATTRIBUTE17	Attribute of the DFF
ATTRIBUTE18	Attribute of the DFF
ATTRIBUTE19	Attribute of the DFF
ATTRIBUTE20	Attribute of the DFF
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
CALENDAR_CAT	Calendar category at which the Workload is set for a faculty. Permissible values are Term (Load) and Academic calendar categories
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CAL_TYPE	Calendar Type for which the Workload is set for the faculty
CI_SEQUENCE_NUMBER	Sequence Number for the calendar instance for which the Workload is set for the faculty
STD_EXP_WL	No Longer Used
ATTRIBUTE_CATEGORY	Descriptive flex field
ATTRIBUTE1	Attribute of the DFF
ATTRIBUTE2	Attribute of the DFF

Student System - IGS_PR_STU_ACAD_STAT	Stores Student Academic Statistics from External Sources
Column Name	Descritpion
PERSON_ID	Person Id of Student
EARNED_CREDIT_POINTS	Earned Credit Points
GPA	Grade Point Average
GPA_CREDIT_POINTS	Credit Point figure used to calculate the Grade Point Average
GPA_QUALITY_POINTS	Quality Point figure used to calculate the Grade Point Average
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
COURSE_CD	Program Code of the Student Attempt
CAL_TYPE	Calendar Type to define the Load Calendar Instance
CI_SEQUENCE_NUMBER	Sequence Number to define the Load Calendar Instance
STAT_TYPE	Statistic Type
TIMEFRAME	Timeframe (Cumulative or Period) for calculating GPA
SOURCE_TYPE	Source Type of the Statistic data (Degree Audit, Internal or Other)
SOURCE_REFERENCE	User Reference for the source of the Statistics data
ATTEMPTED_CREDIT_POINTS	Attempted Credit Points

Student System - IGS_PR_STU_ACAD_STAT_INT	Interface Table for Student Academic Statistics from External Sources
Column Name	Descritpion
BATCH_ID	Batch ID used to process related records
EARNED_CREDIT_POINTS	Earned Credit Points
GPA	Grade Point Average
GPA_CREDIT_POINTS	Credit Point figure used to calculate the Grade Point Average
GPA_QUALITY_POINTS	Quality Point figure used to calculate the Grade Point Average
ERROR_CODE	Error code generated by import process
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
COURSE_CD	Program Code of the Student Attempt
PERSON_NUMBER	Person Number of Student
ALTERNATE_CODE	Alternate code used to indentify the Load Calendar Instance
STAT_TYPE	Statistic Type
TIMEFRAME	Timeframe (Cumulative or Period) for calculating GPA
SOURCE_TYPE	Source Type of the Statistic data (Degree Audit, Internal or Other)
SOURCE_REFERENCE	User Reference for the source of the Statistics data
ATTEMPTED_CREDIT_POINTS	Attempted Credit Points

Student System - IGS_PR_STDNT_PR_FND	The entity stores the exclude fund codes related to a particular Student Progression Outcome record.
Column Name	Descritpion
PERSON_ID	Person Identifier
COURSE_CD	Program Code
SPO_SEQUENCE_NUMBER	Student Progression Outcome Sequence Number.
FUND_CODE	Indicates the excluded Financial Aid Fund Code related to a particular Student Progression 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_SPA_COMPLETE_INT	Interface table for Student Program Attempt Completion from external sources
Column Name	Descritpion
BATCH_ID	Batch ID used to process related records
LAST_UPDATE_LOGIN	Standard WHO Columns
PERSON_NUMBER	Person Number of student
COURSE_CD	Program Code of the student attempt
COMPLETE_DT	Date at which the Program completion requirements were met
ERROR_CODE	Error Code generated by import process.
CREATED_BY	Standard WHO Columns
CREATION_DATE	Standard WHO Columns
LAST_UPDATED_BY	Standard WHO Columns
LAST_UPDATE_DATE	Standard WHO Columns

Student System - IGS_PR_SUSA_COMPLETE_INT	Interface table to store the Student Unit Attempt Completion form external sources
Column Name	Descritpion
BATCH_ID	Batch ID used to process related records
LAST_UPDATE_DATE	Standard WHO Columns
LAST_UPDATE_LOGIN	Standard WHO Columns
PERSON_NUMBER	Person Number of student
COURSE_CD	Program Code of the student attempt
UNIT_SET_CD	Unit Set Code of the student unit set attempt
COMPLETE_DT	Date at which the Unit Set completion requirements were met
ERROR_CODE	Error Code generated by import process.
CREATED_BY	Standard WHO Columns
CREATION_DATE	Standard WHO Columns
LAST_UPDATED_BY	Standard WHO Columns

Student System - IGS_PS_LGCY_BAT_INT	Legacy Interface Batch table
Column Name	Descritpion
BATCH_ID	Unique Batch Identifier
PROGRAM_ID	Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
DESCRIPTION	Description about the batch
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	Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	Application identifier of last concurrent program to update this record.

Student System - IGS_PS_LGCY_ERR_INT	Legacy error message interface table.
Column Name	Descritpion
ERR_MESSAGE_ID	Legacy Message Id
LAST_UPDATE_LOGIN	Standard WHO columns
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.
INT_TABLE_CODE	Table code of the interface table, for which the current error message is being logged.
INT_TABLE_ID	The Interface table ID, which identifies a unique row in a particular interface table.
MESSAGE_NUM	Message Number
MESSAGE_TEXT	Message Text
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns

Student System - IGS_PS_LGCY_SG_INT	Legacy Unit Section Grading Schema Code Interface Table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
DEFAULT_FLAG	Indication of default grading schema. If null then set to 'Y' for the first record 'N' for all subsequent records for the unit section.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
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	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.
USEC_GRD_SCHM_INT_ID	Unique identifier of the Legacy Unit Section Grading Schema Interface Table.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
UNIT_CD	Code used to identify a unit.
VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
TEACH_CAL_ALTERNATE_CODE	Teaching Calendar alternate code that is passed in for the teaching period.
LOCATION_CD	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
UNIT_CLASS	Institution-defined code that identifies a unit class.
GRADING_SCHEMA_CODE	Grading schema code for the unit section.
GRD_SCHM_VERSION_NUMBER	Grading schema version number.

Student System - IGS_PS_LGCY_TR_INT	Legacy Teaching Responsibilities Interface Table.
Column Name	Descritpion
BATCH_ID	Batch identifier, used to identify the set of records to be processed.
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
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.
TEACH_RESP_INT_ID	Unique identifier of the legacy teaching responsibility interface table.
UNIT_CD	Code used to identify a unit.
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit.
ORG_UNIT_CD	Describe the code that identifies an academic or administrative organizational unit operating within the university structure.
PERCENTAGE	Percentage allocation of teaching responsibility to an organizational unit for a unit of study.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(default), 'R'-Ready for Reprocessing, 'E'- Error , 'W'-Warning , 'I'-Imported
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns

Student System - IGS_PS_LGCY_UD_INT	Legacy Unit Discipline Interface Table
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
LAST_UPDATED_BY	Standard WHO columns.
LAST_UPDATE_DATE	Standard WHO columns.
LAST_UPDATE_LOGIN	Standard WHO columns.
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.
UNIT_DISCIP_INT_ID	Unique identifier of the Legacy Unit Discipline Interface Table.
UNIT_CD	Code used to identify a unit.
VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
DISCIPLINE_GROUP_CD	Discipline group code. Discipline group are used to classify units of study in terms of the subject matter being taught and or researched.
PERCENTAGE	Describes the percentage allocation of unit discipline for a unit.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
CREATED_BY	Standard WHO columns.
CREATION_DATE	Standard WHO columns.

Student System - IGS_PS_LGCY_UG_INT	Legacy Unit Grading Schema Interface Table
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
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	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.
UV_GRD_SCHM_INT_ID	Unique identifier of the Legacy Unit Grading Schema Interface Table.
UNIT_CD	Code used to identify a unit.
UNIT_VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
GRADING_SCHEMA_CODE	Code of the grading method.
GRD_SCHM_VERSION_NUMBER	Version Number of the grading method done for the unit.
DEFAULT_FLAG	Indicator flag that holds a Y or a N.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
CREATED_BY	Standard WHO columns.

Student System - IGS_PS_LGCY_US_INT	Legacy Unit Section Interface Table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
UNIT_SECTION_STATUS	Status of unit section. E.g. Cancelled, Closed, Hold and Open.
ENROLLED_CREDIT_POINTS	Number of credit points in which the student is considered to be enrolled.
NOT_MULTIPLE_SECTION_FLAG	Indicating whether this unit section should be excluded from multiple unit section.
SUP_UNIT_CD	Unit code for the superior unit section.
SUP_VERSION_NUMBER	Unit version number for the superior unit section.
SUP_TEACH_CAL_ALTERNATE_CODE	Teaching calendar alternate code for the superior unit section.
SUP_LOCATION_CD	Location code for the superior unit section.
SUP_UNIT_CLASS	Unit Class for the superior unit section.
DEFAULT_ENROLL_FLAG	Indicate whether to enroll the subordinate unit section when the superior unit section is enrolled.
BILLING_CREDIT_POINTS	Audit Credit Points
BILLING_HRS	Billable Credit Points
UNIT_SECTION_START_DATE	Start date of unit section is specified.
UNIT_SECTION_END_DATE	End date of unit section is specified.
OFFERED_IND	Indicator that specifies whether the unit offering option is available for offering. Setting the checkbox ticked makes the offering available.
STATE_FINANCIAL_AID	Indicator for eligibility of the unit section to qualify for state financial aid funding
FEDERAL_FINANCIAL_AID	Indicator for eligibility of the unit section to qualify for federal financial aid funding
GRADING_SCHEMA_PRCDNCE_IND	Indicator that specifies whether any grading schema attached to the unit offering option takes precedence over the grading schema attached to the enrolled student's program offering.
UNIT_QUOTA	An enrollment quota that restricts the number of students who might be enrolled in a particular unit offering.
UNIT_QUOTA_RESERVED_PLACES	Subset of the enrollment quota that is presently reserved.
INSTITUTIONAL_FINANCIAL_AID	Indicator for eligibility of the unit section to qualify for institutional financial aid funding.
UNIT_SECTION_INT_ID	Unique identifier of the Legacy Unit Version Interface Table.
GRADING_SCHEMA_CD	The code that identifies the grading schema. A grading schema describes the set of available marks and grades, which can be used in the assessment of student unit attempts. There may be multiple grading schemas for any one institution.
GS_VERSION_NUMBER	Version Number of the grading schema.
UNIT_CONTACT_NUMBER	Person identification number of a staff member who is the contact for a particular unit offering.
SS_ENROL_IND	Self Service Enrollment Indicator
OWNER_ORG_UNIT_CD	The responsible organization unit for the unit section.
ATTENDANCE_REQUIRED_IND	Indicator to control the unit sections for which Attendance self service roster are produced for faculty to enter/report Attendance Hours as per the date aliases set in Academic Records.
RESERVED_SEATING_ALLOWED	If value is 'Y' then Reserved seating will be allowed otherwise Reserved seating will not be allowed.
SPECIAL_PERMISSION_IND	Indicates if special permission is required for the unit.
SS_DISPLAY_IND	Excludes unit from displaying in unit search windows in self service enrollments.
REV_ACCOUNT_CD	Revenue Account Code (An alpha numeric string). It is populated with the revenue account code when GL is not installed and system uses any other external account.
UNIT_CD	Code used to identify a unit.
ANON_UNIT_GRADING_IND	Indicates whether anonymous unit grading is applicable to the unit section .
ANON_ASSESS_GRADING_IND	Indicates whether anonymous assessment item grading is applicable to the unit section.
NON_STD_USEC_IND	Indicates whether the Unit Section is Standard or Non Standard
AUDITABLE_IND	Indicates if the unit section can be audited.
AUDIT_PERMISSION_IND	Indicates whether permission is required for auditing.
WAITLIST_ALLOWED	Indicator to show whether waitlist is allowed for the unit or not.
MAX_STUDENTS_PER_WAITLIST	Maximum number of students who can be waitlisted is shown.
MINIMUM_CREDIT_POINTS	Minimum credit points
MAXIMUM_CREDIT_POINTS	Maximum credit points
VARIABLE_INCREMENT	Variable increment of credit points
VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
LECTURE_CREDIT_POINTS	Lecture credit points.
LAB_CREDIT_POINTS	Laboratory credit points.
OTHER_CREDIT_POINTS	Any other credit points.
CLOCK_HOURS	Number of clock hours.
WORK_LOAD_CP_LECTURE	Work load credit points on lecture
WORK_LOAD_CP_LAB	Work load credit point for laboratory.
CONTINUING_EDUCATION_UNITS	Units for continuing education.
WORK_LOAD_OTHER	Work load for any component other than lecture and laboratory.
CONTACT_HRS_LECTURE	Contact hours for Lecture.
CONTACT_HRS_LAB	Contact hours for Laboratory
TEACH_CAL_ALTERNATE_CODE	Teaching Calendar alternate code that is passed in for the teaching period.
CONTACT_HRS_OTHER	Contact hours for any component other than lecture and laboratory.
NON_SCHD_REQUIRED_HRS	Non Scheduled Required Hours
EXCLUDE_FROM_MAX_CP_LIMIT	Exclude a unit's achievable credit points from counting in a student's maximum credit point's limit.
CLAIMABLE_HOURS	The maximum hours that a student in a class can claim.
REFERENCE_SHORT_TITLE	Short title for unit section reference.
REFERENCE_SUBTITLE_MOD_FLAG	Subtitle modifiable flag for unit section.
REFERENCE_CLASS_SCH_EXCL_FLAG	Class schedule exclusion flag for the unit section.
REFERENCE_REC_EXCLUSION_FLAG	Exclude unit section from displaying in self service records windows and on transcripts and exclude unit section from Grade Point Average calculation.
REFERENCE_TITLE	Title for the unit section.
REFERENCE_SUBTITLE	Subtitle of the unit section.
LOCATION_CD	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
REFERENCE_ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column.
REFERENCE_ATTRIBUTE1	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE2	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE3	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE4	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE5	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE6	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE7	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE8	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE9	Descriptive Flexfield segment.
UNIT_CLASS	Institution-defined code that identifies a unit class. Also used to identify the unit section code.
REFERENCE_ATTRIBUTE10	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE11	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE12	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE13	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE14	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE15	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE16	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE17	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE18	Descriptive Flexfield segment.
REFERENCE_ATTRIBUTE19	Descriptive Flexfield segment.
CALL_NUMBER	This is a unique identifier needed to support Interactive Voice Response registration.
REFERENCE_ATTRIBUTE20	Descriptive Flexfield segment.
ENROLLMENT_EXPECTED	Expected number of enrollments.Validations performed while importing:Inherits from unit level if not provided (i.e., Enrollment Expected of this unit version).
ENROLLMENT_MINIMUM	Minimum number of enrollments.Validations performed while importing:Inherits from unit level if not provided (i.e., Enrollment Minimum of this unit version).Enrollment Minimum should not be greater than Enrollment Maximum.
ENROLLMENT_MAXIMUM	Maximum number of enrollments.Validations performed while importing:Inherits from unit level if not provided (i.e., Enrollment Maximum of this unit version).Enrollment Minimum should not be greater than Enrollment Maximum Enrollment Maximum
ADVANCE_MAXIMUM	Maximum number of advance enrollments.Validations performed while importing:Inherits from unit level if not provided. (i.e., Advance Maximum of this unit version). Advance Maximum should not be greater than Enrollment Maximum.
USEC_WAITLIST_ALLOWED	Waitlist allowed indicator.Validations performed while importing:Inherits from unit offering pattern level if not provided (i.e., waitlist allowed of this unit offering pattern). Waitlist can be allowed at unit section level only if it is a
USEC_MAX_STUDENTS_PER_WAITLIST	Maximum number of students per waitlist. Validations performed while importing:Inherits from unit offering pattern level if not provided (i.e., Maximum number of students per waitlist of this unit offering pattern). Maximum Students Per Wai
OVERRIDE_ENROLLMENT_MAXIMUM	This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased. Validations performed while importing:Inherits from unit level if not provided. (i.e., Override Enrollment
MAX_AUDITORS_ALLOWED	Indicates maximum number of auditors allowed. Validations performed while importing:Inherits from unit level if not provided. (i.e., Maximum Auditors Allowed of this unit version). Maximum auditors allowed should be null If the unit sectio
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
IVRS_AVAILABLE_IND	Unique identifier needed to support Interactive Voice Response System registration.
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.
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.
REQUEST_ID	Request identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	Last update date of this record by a concurrent program.
ACHIEVABLE_CREDIT_POINTS	Number of credit points awarded upon successful completion of the unit section.

Student System - IGS_PS_LGCY_UR_INT	Legacy Unit Reference Interface Table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
TUESDAY	No Longer Used
WEDNESDAY	No Longer Used
THURSDAY	No Longer Used
FRIDAY	No Longer Used
SATURDAY	No Longer Used
SUNDAY	No Longer Used
START_TIME	No Longer Used
END_TIME	No Longer Used
REFERENCE_CD_TYPE	Type or classification of a system unit reference code.
REFERENCE_CD	System reference code for a unit. For example, an Interactive Voice Response System code used to represent a unit.
UNIT_REFERENCE_INT_ID	Unique identifier of the Legacy Unit Reference Interface Table.
DESCRIPTION	Description, or name, of the unit reference code.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
USO_START_DATE	No Longer Used
USO_END_DATE	No Longer Used
NO_SET_DAY_IND	No Longer Used
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.
UNIT_CD	Code used to identify a unit.
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.
GEN_REF_FLAG	Flag to indicate the reference code is general reference code or specific (unit or unit section) requirements reference code. If the value is 'Y' then it is a generic reference code otherwise it is a specific (unit or unit section) referenc
OCCURRENCE_IDENTIFIER	Unique identity for an occurrence within a unit section.
PRODUCTION_USO_ID	Unique Identifier of Unit Section Occurrence in Production Table (IGS_PS_USEC_OCCURS_ALL).
VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
DATA_TYPE	Indicator to tell the process where the reference is to be loaded. Must be one of:'UNIT','SECTION' and 'OCCURRENCE'
TEACH_CAL_ALTERNATE_CODE	Teaching Calendar alternate code that is passed in for the teaching period. Must be specified if the data type is not UNIT.
LOCATION_CD	Institution-defined location code, typically of a campus, at that a unit offering option is offered. Must be specified if the data type is not UNIT.
UNIT_CLASS	Institution-defined code that identifies a unit class. Must be specified if the data type is not UNIT.
MONDAY	No Longer Used

Student System - IGS_PS_LGCY_UV_INT	Legacy Unit Version Interface Table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
TITLE	Title of the unit.
ATTRIBUTE15	Descriptive Flexfield segment.
ATTRIBUTE16	Descriptive Flexfield segment.
ATTRIBUTE17	Descriptive Flexfield segment.
ATTRIBUTE18	Descriptive Flexfield segment.
ATTRIBUTE19	Descriptive Flexfield segment.
ATTRIBUTE20	Descriptive Flexfield segment.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
CREATED_BY	Standard WHO columns.
CREATION_DATE	Standard WHO columns.
LAST_UPDATED_BY	Standard WHO columns.
SHORT_TITLE	Short name of the unit.
LAST_UPDATE_DATE	Standard WHO columns.
LAST_UPDATE_LOGIN	Standard WHO columns.
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.
BILLING_CREDIT_POINTS	Audit Credit Points
OVRD_WKLD_VAL_FLAG	Override workload validation flag
WORKLOAD_VAL_CODE	Workload validation type. SELECT lookup_code from igs_lookup_Values WHERE lookup_type = 'WKLD_VAL_TYPE'
BILLING_HRS	Billable Credit Points
TITLE_OVERRIDE_IND	Indicator that specifies whether the title of the unit can be overridden at the student unit attempt level. Setting the checkbox ticked allows the title to be overridden.
ABBREVIATION	Abbreviated name of the unit.
UNIT_LEVEL	Normal year level of the unit.
CREDIT_POINT_DESCRIPTOR	Institution's name for credit points.
SUPP_EXAM_PERMITTED_IND	Indicator that specifies whether a supplementary examination or other supplementary assessment can be granted in this unit. Setting the checkbox ticked allows supplementary assessment to be granted.
COORD_PERSON_NUMBER	Person number of the unit coordinator used to select the person id for the coordinator.
OWNER_ORG_UNIT_CD	Code of the organizational unit that owns the unit.
AWARD_COURSE_ONLY_IND	Indicator that specifies whether the unit is available only to award program students. Setting the checkbox ticked restricts enrollment to award program students.
UNIT_VERSION_INT_ID	Unique identifier of the Legacy Unit Version Interface Table.
RESEARCH_UNIT_IND	Indicator that specifies whether the unit is classified as a research unit. Setting the checkbox ticked classifies the unit as research. Research units are normally only available to students enrolled in research programs.
SUB_UNIT_ALLOWED_IND	Indicator that specifies whether this unit can be classified as a sub-unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a sub-unit. Case and Seed document: PS202_SuperiorStructure_PS_3052452_CS
SUP_UNIT_ALLOWED_IND	Indicator that specifies whether this unit can be classified as a superior unit in a superior or sub-unit relationship. Setting the checkbox ticked allows the unit to be a superior unit. Case and Seed document: PS202_SuperiorStructure_PS_
INDUSTRIAL_IND	Indicator that specifies whether this unit is classified as an industrial experience unit.
PRACTICAL_IND	Indicator that specifies whether this unit is classified as a practical experience unit.
REPEATABLE_IND	Indicator that specifies whether the unit can count more than once towards the satisfaction of program requirements. Setting the checkbox ticked enables a student to repeat an already passed unit.
ASSESSABLE_IND	Indicator that specifies whether the unit is assessed. Setting the checkbox ticked indicates that the unit is assessed.
ACHIEVABLE_CREDIT_POINTS	Number of credit points awarded upon successful completion of the unit.
ENROLLED_CREDIT_POINTS	Number of credit points in that the student is considered to be enrolled.
POINTS_OVERRIDE_IND	Indicator that specifies whether it is possible to override the number of credit points awarded upon successful completion on the unit. Setting the checkbox ticked allows the enrolled credit points and the enrolled EFTSU to be overridden.
UNIT_CD	Code used to identify a unit.
POINTS_INCREMENT	If the override credit points indicator is set , this field records the allowable credit point increment.
POINTS_MIN	If the override credits points indicator is set , this field records the minimum number of credit points that can be awarded upon successful completion of the unit.
POINTS_MAX	If the override credits points indicator is set , this field records the maximum number of credit points that can be awarded upon successful completion of the unit.
UNIT_INT_COURSE_LEVEL_CD	Internal program level grouping of the unit.
SUBTITLE	Another title for the unit.
SUBTITLE_APPROVED_IND	Official subtitle that has been approved by the institution or an organizational unit.
SUBTITLE_CLOSED_IND	The subtitle is available for use or not.
SUBTITLE_MODIFIABLE_FLAG	Sub Title modifiable indicator.
APPROVAL_DATE	Approval date.
LECTURE_CREDIT_POINTS	Lecture credit points.
VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
LAB_CREDIT_POINTS	Laboratory credit points.
OTHER_CREDIT_POINTS	Other credit points.
CLOCK_HOURS	Clock hours.
WORK_LOAD_CP_LECTURE	Lecture work load credit point
WORK_LOAD_CP_LAB	Lab wok load credit points.
CONTINUING_EDUCATION_UNITS	Continuing education units.
ENROLLMENT_EXPECTED	Expected enrollment
ENROLLMENT_MINIMUM	Minimum enrollment.
ENROLLMENT_MAXIMUM	Maximum enrollment.
ADVANCE_MAXIMUM	Maximum waitlist in advance
START_DT	Date on that this version of the unit became current.
STATE_FINANCIAL_AID	State financial aid.
FEDERAL_FINANCIAL_AID	Federal financial aid.
INSTITUTIONAL_FINANCIAL_AID	Institutional financial aid
SAME_TEACHING_PERIOD	Same teaching period indicator
MAX_REPEATS_FOR_CREDIT	Number of maximum repeats for credits.
MAX_REPEATS_FOR_FUNDING	Number of maximum repeats for funding
MAX_REPEAT_CREDIT_POINTS	Maximum repeat credit points
SAME_TEACH_PERIOD_REPEATS	Same teaching period repeats
SAME_TEACH_PERIOD_REPEATS_CP	Same teaching period repeats credit points.
IVR_ENROL_IND	Interactive Voice Response Enrollment Indicator
REVIEW_DT	Date on that this version of the unit is due for review.
SS_ENROL_IND	Self Service Enrollment Indicator
WORK_LOAD_OTHER	Work load for any component other than lecture and laboratory.
CONTACT_HRS_LECTURE	Contact hours for Lecture.
CONTACT_HRS_LAB	Contact hours for Laboratory
CONTACT_HRS_OTHER	Contact hours for any component other than lecture and laboratory.
NON_SCHD_REQUIRED_HRS	Non Scheduled Required Hours
EXCLUDE_FROM_MAX_CP_LIMIT	Exclude a unit's achievable credit points from counting in a student's maximum credit point's limit.
RECORD_EXCLUSION_FLAG	Excludes unit from displaying in self service records window and on transcripts, and excludes unit from Grade Point Average calculations.
SS_DISPLAY_IND	Excludes unit from displaying in unit search windows in self service enrollments.
ENROL_LOAD_ALT_CD	Load Calendar alternate code that is passed in for the last enrolled period.
EXPIRY_DT	Date on that the unit version expires. Students already studying this unit version may remain enrolled. No further enrollments are normally allowable.
OFFER_LOAD_ALT_CD	Load Calendar alternate code that is passed in for the last period that this unit was offered.
CURRICULUM_ID	Links different version of unit when then unit code changes. Also required for mandated reporting by some states.
CURRICULUM_DESCRIPTION	The description for the curriculum id.
CURRICULUM_CLOSED_IND	This indicates id curriculum id is available for use or not.
OVERRIDE_ENROLLMENT_MAX	This field stores the value till which the actual enrollment can increase without requiring that the maximum enrollment be increased.
REPEAT_CODE	Indicates the repeat family to which the unit belongs.
LEVEL_CODE	Indicates the unit type level to which unit may be assigned.
SPECIAL_PERMISSION_IND	Indicates if special permission is required for the unit
REV_ACCOUNT_CD	Revenue Account Code (An alpha numeric string). It is populated with the revenue account code when GL is not installed and system uses any other external account systems.
CLAIMABLE_HOURS	The maximum hours that a student in a class can claim.
END_DT	Date on that this version of the unit ends. No students can remain enrolled in unit after its end date has been reached.
ANON_UNIT_GRADING_IND	Anonymous Unit Grading
ANON_ASSESS_GRADING_IND	Anonymous Assessment Item Grading
AUDITABLE_IND	Indicates if a unit can be audited.
MAX_AUDITORS_ALLOWED	Indicates maximum number of allowed auditors.
AUDIT_PERMISSION_IND	Indicates if permitted to audit.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column. If entered the category must already exist.
ATTRIBUTE1	Descriptive Flexfield segment.
ATTRIBUTE2	Descriptive Flexfield segment.
ATTRIBUTE3	Descriptive Flexfield segment.
ATTRIBUTE4	Descriptive Flexfield segment.
UNIT_STATUS	Institution-defined status of a unit that maps to a system unit status.
ATTRIBUTE5	Descriptive Flexfield segment.
ATTRIBUTE6	Descriptive Flexfield segment.
ATTRIBUTE7	Descriptive Flexfield segment.
ATTRIBUTE8	Descriptive Flexfield segment.
ATTRIBUTE9	Descriptive Flexfield segment.
ATTRIBUTE10	Descriptive Flexfield segment.
ATTRIBUTE11	Descriptive Flexfield segment.
ATTRIBUTE12	Descriptive Flexfield segment.
ATTRIBUTE13	Descriptive Flexfield segment.
ATTRIBUTE14	Descriptive Flexfield segment.

Student System - IGS_PS_LGCY_OC_INT	Legacy Unit Section Occurrence Interface Table.
Column Name	Descritpion
BATCH_ID	Batch Identifier, used to identify the set of records to be processed.
TUESDAY	Indicates class is conducted on Tuesday.
WEDNESDAY	Indicates class is conducted on Wednesday.
THURSDAY	Indicates class is conducted on Thursday.
FRIDAY	Indicates class is conducted on Friday.
SATURDAY	Indicates class is conducted on Saturday.
SUNDAY	Indicates class is conducted on Sunday.
START_DATE	Unit Section Occurrence Start Date.
END_DATE	Unit Section Occurrence End Date.
START_TIME	Start time of the unit section occurrence.
END_TIME	End time of the unit section occurrence.
USEC_OCCUR_INT_ID	Unique identifier of the Legacy Unit Section Occurrence Interface Table.
BUILDING_CODE	The building code of the occurrence.
ROOM_CODE	The room code of the occurrence.
DEDICATED_BUILDING_CODE	The dedicated building code of the occurrence.
DEDICATED_ROOM_CODE	The dedicated room code of the occurrence.
PREFERRED_BUILDING_CODE	The preferred building code of the occurrence.
PREFERRED_ROOM_CODE	The preferred room code of the occurrence.
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column.
ATTRIBUTE1	Descriptive Flexfield segment.
ATTRIBUTE2	Descriptive Flexfield segment.
ATTRIBUTE3	Descriptive Flexfield segment.
UNIT_CD	Code used to identify a unit.
ATTRIBUTE4	Descriptive Flexfield segment.
ATTRIBUTE5	Descriptive Flexfield segment.
ATTRIBUTE6	Descriptive Flexfield segment.
ATTRIBUTE7	Descriptive Flexfield segment.
ATTRIBUTE8	Descriptive Flexfield segment.
ATTRIBUTE9	Descriptive Flexfield segment.
ATTRIBUTE10	Descriptive Flexfield segment.
ATTRIBUTE11	Descriptive Flexfield segment.
ATTRIBUTE12	Descriptive Flexfield segment.
ATTRIBUTE13	Descriptive Flexfield segment.
VERSION_NUMBER	Version Number is used to uniquely identify each version of a unit.
ATTRIBUTE14	Descriptive Flexfield segment.
ATTRIBUTE15	Descriptive Flexfield segment.
ATTRIBUTE16	Descriptive Flexfield segment.
ATTRIBUTE17	Descriptive Flexfield segment.
ATTRIBUTE18	Descriptive Flexfield segment.
ATTRIBUTE19	Descriptive Flexfield segment.
ATTRIBUTE20	Descriptive Flexfield segment.
IMPORT_STATUS	Record's Import status, allowable values are 'U'-Unprocessed(Default), 'R'-Ready for Reprocessing, 'E'-Error, 'W'-Warning, 'I'-Imported
PREFERRED_REGION_CODE	User Preferred Region Code for the unit section occurrence. E.g. North Campus, South Campus.
NO_SET_DAY_IND	Indicator to indicate the unit section occurrence is a no set day unit section occurrence or not. No set day unit section occurrence doesn't require scheduling information like (Building, Room etc.) e.g. web programs.
TEACH_CAL_ALTERNATE_CODE	Teaching Calendar alternate code that is passed in for the teaching period.
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	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.
OCCURRENCE_IDENTIFIER	Unique identity for an occurrence within a unit section.
LOCATION_CD	Institution-defined location code, typically of a campus, at that a unit offering option is offered.
UNIT_CLASS	Institution-defined code that identifies a unit class.
TO_BE_ANNOUNCED	Flag for Unit Section Occurrence.
MONDAY	Indicates class is conducted on Monday.

Student System - IGS_PR_UL_MARK_CNFG	Defines the configuration for calculating the marks at unit level.
Column Name	Descritpion
MARK_CONFIG_ID	This is the sequence generated primary key of the table.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
UNIT_LEVEL	Unit Level Code for the configuration
COURSE_CD	Program code for what the configuration is to be done.
VERSION_NUMBER	Program Version number.
TOTAL_UNIT_LEVEL_CREDITS	The total unit credits for the level.
SELECTION_METHOD_CODE	The unit selection method for the level, either Total Credits or Priority
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.

Student System - IGS_PR_UL_MARK_DTL	Defines the configuration details like core type indicator, priority in selecting the units for marks calculation etc.
Column Name	Descritpion
MARK_CONFIG_ID	Foreign key to the table IGS_PR_UL_MARK_CNFG.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CORE_INDICATOR_CODE	The type of unit attempt - core, optional, or elective.
TOTAL_CREDITS	The total credits to be selected for the core type.
REQUIRED_FLAG	Indicator that the Total Credit is required for the indicator type. Default value is 'N'
PRIORITY_NUM	The priority to select units.
UNIT_SELECTION_CODE	Defines the order to select unit attempts.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.

Student System - IGS_PS_LGCY_INS_INT	Legacy Unit Section Occurrence Instructors Interface table.
Column Name	Descritpion
USO_INSTRUCTOR_INT_ID	Unique Identifier of Unit Section Occurrence Instructor Interface table.
END_TIME	No Longer Used
CONFIRMED_FLAG	Indicates instructor is confirmed for teaching responsibility. Can have value either 'Y' or 'N'. The workload for the faculty will only be counted if the confirmed flag is 'Y'.
WL_PERCENTAGE_ALLOCATION	Percentage workload allocated for the instructor. Can have value in the range of 0.00 to 100.00. If percentage allocation of workload is provided then instructional lecture, laboratory and other load will be calculated.
INSTRUCTIONAL_LOAD_LECTURE	Instructional workload for lecture on the instructor. Instructional lecture workload provided should not constitute to more than 100% allocation of workload.
INSTRUCTIONAL_LOAD_LABORATORY	Instructional workload for laboratory on the instructor. Instructional laboratory workload provided should not constitute to more than 100% allocation of workload.
INSTRUCTIONAL_LOAD_OTHER	Other Instructional workload on the instructor. Other Instructional workload provided should not constitute to more than 100% allocation of workload.
LEAD_INSTRUCTOR_FLAG	Lead instructor flag to indicate the instructor is lead instructor of unit section.
IMPORT_STATUS	Record's Import status, allowable values are 'U' - Unprocessed, 'R' - Ready for Reprocessing, 'E' - Error, 'W' - Warning, 'I' - Imported
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
INSTRUCTOR_PERSON_NUMBER	Person Number of Instructor.Validation while importing:Person number is valid one in the system. Person number corresponds to valid Instructor (i.e. person type of either 'STAFF' or 'FACULTY'.)
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
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.
NO_SET_DAY_IND	No Longer Used
PRODUCTION_USO_ID	Unique Identifier of Unit Section Occurrence in Production Table (IGS_PS_USEC_OCCURS_ALL). If production unit section occurrence identifier is provided then no need to provide teaching calendar alternate code, location code , unit class, Su
OCCURRENCE_IDENTIFIER	Unique identity for an occurrence within a unit section.
UNIT_CD	Code used to identify the unit. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided.
VERSION_NUMBER	Version number is used to uniquely identify each version of a unit. Used in the process of identifying the unit section occurrence uniquely in the system, if production unit section occurrence identifier is not provided.
TEACH_CAL_ALTERNATE_CODE	Teaching Calendar alternate code that is passed in for the teaching period. Must be specified if Production unit section occurrence identifier is not provided. Used in the process of identifying the unit section occurrence uniquely in the s
LOCATION_CD	Institution-defined location code, typically of a campus, at that a unit offering option is offered. Must be specified if Production unit section occurrence identifier is not provided. Used in the process of identifying the unit section occ
UNIT_CLASS	Institution-defined code that identifies a unit class. Must be specified if Production unit section occurrence identifier is not provided. Used in the process of identifying the unit section occurrence uniquely in the system, if production
BATCH_ID	Batch Identifier, used to identify the set of records to be processed. The following select statement can be used for getting the list of valid batch id values "Select batch_id from IGS_PS_LGCY_BAT_INT".
MONDAY	No Longer Used
TUESDAY	No Longer Used
WEDNESDAY	No Longer Used
THURSDAY	No Longer Used
FRIDAY	No Longer Used
SATURDAY	No Longer Used
SUNDAY	No Longer Used
USO_START_DATE	No Longer Used
USO_END_DATE	No Longer Used
START_TIME	No Longer Used

Student System - IGS_PS_EMP_CATS_WL	This entity describes the workload for employment categories. Data will be fetch from Lookups of HR, if HR installed or else it will get the values from lookups of Student System
Column Name	Descritpion
CAL_CAT_CODE	Calendar Category at which expected workload is stored at institutional level. Permission values are Term(Load) and Academic calendar categories.
EMP_CAT_CODE	Employment category for a calendar category. Values for this field are populated from lookups either from HR (if HR is installed) or OSS (if HR is not installed).
EXPECTED_WL_NUM	Expected workload in the given calendar category.
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns

Student System - IGS_PS_AWD_HNR_BASE	Defines the basis on what the honors level of the student is to be derived. The definition will include the unit level and the weightage that is to be given to a particular unit level mark to arrive at the honors level of a student in a giv
Column Name	Descritpion
AWD_HNR_BASIS_ID	Sequence generated primary key of the table.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
AWARD_CD	Award Code that the Honors Basis is related to.
UNIT_LEVEL	Unit Level Code for deriving at the honors level in Program Centric installation.
WEIGHTED_AVERAGE	Weighted Average for the Unit Level.
STAT_TYPE	The statistic type for honors basis (Career Centric)
S_STAT_ELEMENT	Statistics element that will be used to calculate the statistics value.
TIMEFRAME	Time frame that will be used for arriving at the statistics value. Default is 'CUMULATIVE'.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.

Student System - IGS_PS_NSUS_RTN	This table stores the info about Retention master setup
Column Name	Descritpion
NON_STD_USEC_RTN_ID	System generated number to uniquely identify the non-standard unit section master setup
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
UOO_ID	Unit Section Identifier associated with retention
FEE_TYPE	Fee Type associated with retention
DEFINITION_CODE	The definition level for retention
FORMULA_METHOD	The formula for calculating the retention offset date. Valid values are D - Number of Duration days, P - Percentage of Duration Days, N - Number of Meeting Days, M - Percentage of Meeting days
ROUND_METHOD	The method of rounding off the result i.e. either S - Standard Round or A - Always Round Up
INCL_WKEND_DURATION_FLAG	This will indicate whether to consider weekends for formula method duration days
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_PS_NSUS_RTN_DTL	This table stores the info about Retention master setup
Column Name	Descritpion
NON_STD_USEC_RTN_DTL_ID	System generated number to uniquely identify the non-standard unit section detail setup
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
NON_STD_USEC_RTN_ID	System generated number to uniquely identify the non-standard unit section master setup. This column is used here to get the corresponding childs
OFFSET_VALUE	Offset Value set up for corresponding formula method.
RETENTION_PERCENT	Retention Percentage
RETENTION_AMOUNT	Retention Amount
OFFSET_DATE	Offset Date for retention
OVERRIDE_DATE_FLAG	This will indicate whether the offset date is system calculated or user entered.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_PS_SCH_OCR_CFIG	Table to capture occurrence rollover and override related information.
Column Name	Descritpion
OCR_CFIG_ID	Unique identifier for occurrence rollover and override configuration.
PREFERRED_ROOM_ROLL_FLAG	Preferred Room rollover flag.
DEDICATED_BLD_ROLL_FLAG	Dedicated Building rollover flag
DEDICATED_ROOM_ROLL_FLAG	Dedicated Room rollover flag.
SCHEDULED_BLD_ROLL_FLAG	Scheduled Building rollover flag
SCHEDULED_ROOM_ROLL_FLAG	Scheduled Room rollover flag.
PREFERRED_REGION_ROLL_FLAG	Preferred Region rollover flag.
OCCUR_FLEXFIELD_ROLL_FLAG	Occurrence Flexfields Rollover flag.
INC_INS_CHANGE_NOTFY_ROLL_FLAG	Include Instructor Change Notification rollover flag.
DATE_OVRD_FLAG	Date Override flag.
DAY_OVRD_FLAG	Days override flag.
TO_BE_ANNOUNCED_ROLL_FLAG	To be announced rollover flag
TIME_OVRD_FLAG	Time override flag.
INSTRUCTOR_OVRD_FLAG	Instructor override flag.
SCHEDULED_BLD_OVRD_FLAG	Scheduled building override flag.
SCHEDULED_ROOM_OVRD_FLAG	Scheduled room override flag.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
DAY_ROLL_FLAG	Days rollover flag
TIME_ROLL_FLAG	Time rollover flag
INSTRUCTOR_ROLL_FLAG	Instructors rollover flag
FACILITY_ROLL_FLAG	Facilities rollover flag
SCHD_NOT_RQD_ROLL_FLAG	Scheduling Not Required rollover flag
REF_CD_ROLL_FLAG	Reference Code rollover flag
PREFERRED_BLD_ROLL_FLAG	Preferred Building rollover flag

Student System - IGS_PS_SCH_PAT_INT	Interface table to capture scheduler interface Unit Offering Pattern data.
Column Name	Descritpion
INT_PAT_ID	Unique Identifier for each Unit Offering Pattern in the Scheduler Interface.
ENROLLMENT_EXPECTED	Enrollment Expected for the unit version.
ENROLLMENT_MAXIMUM	Enrollment maximum for the unit version.
OVERRIDE_ENROLLMENT_MAXIMUM	Override Enrollment maximum for the unit version
UNIT_STATUS	Status of the Unit Version.
ABORT_FLAG	Flag to indicate whether the Unit Offering Pattern is ABORTED.
IMPORT_DONE_FLAG	Flag to indicate whether the Unit Offering Pattern has been imported to production.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
TRANSACTION_ID	Identifier for a transaction in scheduling interface
LAST_UPDATE_LOGIN	Standard Who column.
CALENDAR_TYPE	Calendar Type for the Unit Offering Pattern.
SEQUENCE_NUMBER	Sequence Number for the Unit Offering Pattern
TEACHING_CAL_ALTERNATE_CODE	Alternate Code corresponding to the teaching calendar instance.
START_DATE	Start Date for the teaching calendar instance.
END_DATE	End Date for the teaching calendar instance.
UNIT_CD	Unit Code corresponding to the Unit Offering Pattern.
VERSION_NUMBER	Unit Version corresponding to the Unit Offering Pattern.

Student System - IGS_PS_SCH_FAC_INT	Interface table to capture scheduler interface Unit Facilities data.
Column Name	Descritpion
INT_FAC_ID	Unique Identifier for each Unit Offering Pattern facilities in the Scheduler Interface.
INT_PAT_ID	Identifier for a Unit Offering Pattern in scheduling interface
MEDIA_CODE	Media Code corresponding to the Unit Version of the Unit Offering Pattern.
MEDIA_DESCRIPTION	Media description corresponding to the Unit Version of the Unit Offering Pattern.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Student System - IGS_PS_SCH_LOC_INT	Interface table to capture scheduler interface Unit location data.
Column Name	Descritpion
INT_LOC_ID	Unique Identifier for each Unit Offering Pattern location in the Scheduler Interface.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
INT_PAT_ID	Identifier for a Unit Offering Pattern in scheduling interface.
LOCATION_CODE	Location Code corresponding to the Unit Version of the Unit Offering Pattern.
LOCATION_DESCRIPTION	Location description corresponding to the Unit Version of the Unit Offering Pattern.
BUILDING_CODE	Building Code corresponding to the Unit Version of the Unit Offering Pattern.
BUILDING_DESCRIPTION	Building description corresponding to the Unit Version of the Unit Offering Pattern.
ROOM_CODE	Room Code corresponding to the Unit Version of the Unit Offering Pattern.
ROOM_DESCRIPTION	Room description corresponding to the Unit Version of the Unit Offering Pattern.
CREATED_BY	Standard Who column.

Student System - IGS_PS_SCH_PRG_CFIG	Table to capture purge type related information for a teaching calendar type.
Column Name	Descritpion
PRG_CFIG_ID	Unique identifier for purge type configuration
PURGE_TYPE	Purge Type
TEACHING_CALENDAR_TYPE	Teaching calendar 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.