Student System - IGS_GE_EXCEPTIONS | IGS_GE_EXCEPTIONS is used to store details from exceptions raised from constraint violations. |
---|---|
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 |
EXCPT_ID | Contains the exception ID that is raised because of violation of a constraint |
ROW_ID | Contains the row ID of a row that violated a constraint |
OWNER | Contains the owner of the violated constraint |
TABLE_NAME | Contains the table on that violates the constraint was created |
CONSTRAINT | Contains the constraint violated by the row |
Student System - IGS_GE_EXT_REF_TYPE | IGS_GE_EXCT_REF_TYPE describes the types of external reference that may exist with external systems. |
---|---|
Column Name | Descritpion |
EXTERNAL_REFERENCE_TYPE | The external reference type assigned to any external reference for a fee assessment. For example, Debtor ID, Invoice, Debit Note, Credit Note, Refund Cheque, Journal. |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Provides an explaination of the external reference type |
CLOSED_IND | Indicates and specifies if the external reference typeis open or closed. Selecting the checkbox to 'closed' means to checked, prevents use of the external reference type in new records. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_GE_MEASUREMENT | IGS_GE_MEASUREMENT describes measurements |
---|---|
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 |
MEASUREMENT_CD | An institution defined size for an academic gown or hat, used for conferral ceremonies. For example, XL, L, M, S. |
DESCRIPTION | An explanation of the institution defined academic gown or hat size. |
MEASUREMENT_TYPE | This institution-defined academic dress type. For example, gown, hat. |
CLOSED_IND | Indicates and specifies if or not the measurement is closed. Selecting the checkbox to checked the measurement, making it unavailable for use in new or modified graduand award ceremony enteres in GRDF4210. |
Student System - IGS_GE_NOTE | This table is used to store notes that may be recorded against many major entities for example courses, units, persons. The note may be an OLE object like word document, excel spreadsheet, and so on. |
---|---|
Column Name | Descritpion |
REFERENCE_NUMBER | The reference number of a particular note. |
S_NOTE_FORMAT_TYPE | A system defined note format, including OLE and text type notes. |
NOTE_OLE | An OLE-formatted note. |
NOTE_TEXT | A text-formatted note. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Student System - IGS_GE_REF_CD | IGS_GE_REF_CD holds the reference codes for a particular reference code type |
---|---|
Column Name | Descritpion |
REFERENCE_CODE_ID | This entity uniquely identifies each and every institution-defined reference code type. Each reference code is assigned a reference code type, which defines its use in the system. |
LAST_UPDATE_LOGIN | Standard Who column |
REFERENCE_CD_TYPE | The name of an institution-defined reference code type. Each referencecode is assigned a reference code type, which defines its use in the system. For example, IVRS CODE. |
REFERENCE_CD | This entity contains an 'other system' reference code for a unit. For example, an IVRS code used to represent a unit. |
DESCRIPTION | Describes the reference code |
DEFAULT_FLAG | For a given reference code type there can be a number of reference code |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
Student System - IGS_GE_SPL_REQ | IGS_GE_SPL_REQ describes special requirements that are used within the university. For example First-aid certificate, computer literacy test. |
---|---|
Column Name | Descritpion |
SPECIAL_REQUIREMENT_CD | The code of a special requirement. Special requirements are institution-defined and can include for example, first aid. In this instance, the completion of a first aid certificate is required in addition to unit requirements, before the st |
DESCRIPTION | Describes the special requirement |
CLOSED_IND | Indicates and specifies if the special requirement is open orclosed. Selecting the checkbox to 'closed' prevents further use of the special requirement. |
COMMENTS | Provides any additional information or details about the special requirement |
CREATED_BY | Standard Who 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_GE_S_DSB_TAB_TRG | Describes the table name and session id for which the triggers of the table are to be disabled |
---|---|
Column Name | Descritpion |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
TABLE_NAME | Table name for which the triggers are to be disabled. |
SESSION_ID | The session ID for which the triggers of the table are to be disabled. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_GE_S_ERROR_LOG | Contains errors that have been logged by PL/SQL procedures or functions that have unhandled exception |
---|---|
Column Name | Descritpion |
SQL_ERROR_MESSAGE | Contains message of the SQL error which is displayed due to the unhandled exception |
OTHER_DETAIL | Contains details of the SQL error other than the error number and error message, that is displayed due to the unhandled exception. |
CREATED_BY | Standard Who 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. |
SEQUENCE_NUMBER | Identifies each and every row uniquely. It contains sequence generated data |
PROGRAM_UNIT | Contains name of the PLSQL procedures and functions |
SQL_ERROR_NUM | Contains number of the SQL error that is displayed due to the unhandled exception |
Student System - IGS_GE_S_GEN_CAL_CON | Describes the date alias representing the cutoff date and teaching period census for an academic period. |
---|---|
Column Name | Descritpion |
S_CONTROL_NUM | Contains internal sequence number |
CENSUS_DT_ALIAS | Describes the date alias representing the teaching period census |
CRS_COMPLETION_CUTOFF_DT_ALIAS | Describes the date alias representing the cutoff date for course completion for an academic period |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Student System - IGS_GE_S_HELP_CTRL | Describes the base URL location of your online documentation |
---|---|
Column Name | Descritpion |
INDEX_URL | Describes the index URL - this is the full URL |
LINK1_BUTTON_LABEL | Describes the label to be put on the first user-defined button |
LINK1_BASE_URL | Describes the base URL for the first user-defined link |
LINK2_BUTTON_LABEL | Describes the label to be put on the second user-defined button |
LINK2_BASE_URL | Describes the base URL for the second user-defined link |
S_CONTROL_NUM | Internal sequence number - there should only ever be one record in this table |
LINK3_BUTTON_LABEL | Describes the label to be put on the third user-defined |
LINK3_BASE_URL | Describes the base URL for the third user-defined link |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
BASE_URL | Describes the base URL location of your online documentation. This is a prefix to all other URL's specified for specific windows and blocks. |
OWS_ENABLED_IND | Indicates and specifies if the Oracle Web Server is enabled. If it is enabled, security will be enabled. Note - this field should only be set when using an Oracle Web Server as defined in the 'base URL'. |
TOC_URL | Describes the table of contents URL - this is the full URL |
Student System - IGS_GE_S_LOG | Describes the system log details. |
---|---|
Column Name | Descritpion |
S_LOG_TYPE | Describes the type of system log which the record is against |
CREATION_DT | Desribes the creation date of the log |
KEY | Describes the optional key record for the log. This is inserted by the process keeping the log, and is typically concatenated information used to identify the log. For example, calendar type and sequencenumber may be stored as ACAD-YR, 28. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Request identifier of last concurrent program to update this record |
PROGRAM_APPLICATION_ID | Application identifier of last concurrent program to update this record |
PROGRAM_ID | Program identifier of last concurrent program to update this record |
PROGRAM_UPDATE_DATE | Last update date of this record by a concurrent program |
Student System - IGS_GE_S_LOG_ENTRY | Describes the log entry details. |
---|---|
Column Name | Descritpion |
S_LOG_TYPE | Describes the log type for which the entry exists |
CREATION_DT | Describes the creation date of the log |
SEQUENCE_NUMBER | Describes the internal sequence number of the log entry |
KEY | Describes the key of the log entry. This is a concatenated string created by the process entering records into the log. For example, it can be the concatenation of person ID, course code and unit code.For example, 9876543, A300, ABC123. |
MESSAGE_NAME | Describes the optional message number of the log entry. If the entry is a system message then the message number is entered rather than entering the text for every record. |
TEXT | Describes the text of the log entry |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Request identifier of last concurrent program to update this record |
PROGRAM_APPLICATION_ID | Application identifier of last concurrent program to update this record |
PROGRAM_ID | Program identifier of last concurrent program to update this record |
PROGRAM_UPDATE_DATE | Last update date of this record by a concurrent program |
Student System - IGS_LOOKUPS_IND | This table has a foreign key relationship with FND_LOOKUPS_TYPE. The join is based on the column LOOKUP_TYPE. The existing system tables from the original data model were merged into the FND_LOOKUPS table. |
---|---|
Column Name | Descritpion |
LOOKUP_TYPE | QuickCode lookup type |
SECURITY_ALLOWED_IND | A flag that indicates the security allowed details of a lookup type. |
STEP_GROUP_TYPE_IND | Flag that indicates the step group type of the lookup type |
FINAL_RESULT_IND | A flag that indicates the final result of a lookup type. |
S_TRACKING_TYPE_IND | Obsolete |
SYSTEM_GENERATED_IND | A flag which indicates whether the lookup type is system generated. |
TRANSACTION_CAT_IND | A flag that indicates the transaction category of a lookup type. |
ENCUMBRANCE_LEVEL_IND | A flag that indicates the hold level of the lookup type. |
OPEN_FOR_ENROLLMENTS_IND | A flag to indicate that the unit section is open for enrollments. |
SYSTEM_CALCULATED_IND | A flag to indicate that the unit section status code is system calculated. |
SYSTEM_MANDATORY_IND | Indicates the column usage for the given lookup type |
DEFAULT_DISPLAY_SEQ_IND | Indicates the column usage for the given lookup type |
TRACKING_USED_BY_IND | Obsolete |
AV_TRANSCRIPT_DISP_OPTIONS_IND | This will have value if the Academic_Transcript_Ind is set to YES. It will have CPT,CPE,PUE for the respective options. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
STEP_TYPE_RESTRICTION_NUM_IND | This is the step type restriction number flag of a lookup type. |
UNIT_OUTCOME_IND | This is the unit outcome flag of the lookup type. |
DISPLAY_NAME_IND | Displays name flag of a lookup type. |
DISPLAY_ORDER_IND | Displays order flag of a lookup type |
STEP_ORDER_APPLICABLE_IND | This is the step order applicable flag of a lookup type |
ACADEMIC_TRANSCRIPT_IND | This is the academic transcript flag of a lookup type. |
CMPLTN_REQUIREMENTS_IND | A flag that indicates the completion requirements of a lookup type. |
FEE_AS_IND | A flag which indicates the fee assessment of a lookup type. |
Student System - IGS_LOOKUPS_VAL | This table has a foreign key relationship with FND_LOOKUPS_VAL. The join is based on the columns LOOKUP_TYPE and LOOKUP_CODE. |
---|---|
Column Name | Descritpion |
LOOKUP_TYPE | QuickCode lookup type |
ACADEMIC_TRANSCRIPT_IND | A flag to indicate the academic transcript associated with the lookup type. |
CMPLTN_REQUIREMENTS_IND | A flag to indicate the completion requirements of a lookup type. |
FEE_ASS_IND | A flag to indicate the fee assessment of a lookup type. |
STEP_GROUP_TYPE | A step group type of a lookupt type |
FINAL_RESULT_IND | A flag that indicates the final result of the lookup type. |
S_TRACKING_TYPE | Obsolete |
SYSTEM_GENERATED_IND | A flag indicating if the lookup type is system generated. |
TRANSACTION_CAT | A transaction category of the lookup type |
ENCUMBRANCE_LEVEL | The hold level of the lookup type |
OPEN_FOR_ENROLLMENTS | Indicates that the unit section is open for enrollments. |
SYSTEM_CALCULATED | Indicates that the unit section status code is system calculated |
SYSTEM_MANDATORY_IND | Indicator to designate whether the region is mandatory in the self service form |
DEFAULT_DISPLAY_SEQ | Default display sequence for attributes for a region |
TRACKING_USED_BY | Obsolete |
AV_TRANSCRIPT_DISP_OPTIONS | This will have value if the Academic_Transcript_Ind is set to YES. It will have CPT,CPE,PUE for the respective options. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LOOKUP_CODE | QuickCode code |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CLOSED_IND | A flag for determining if the lookup type is closed. |
SECURITY_ALLOWED_IND | A flag to control if the lookup type has security allowed |
STEP_TYPE_RESTRICTION_NUM_IND | A flag to control the step type restriction number of the lookup type |
UNIT_OUTCOME_IND | A flag to control the unit outcome of a lookup type. |
DISPLAY_NAME | Displays name of the lookup type |
DISPLAY_ORDER | Displays order of the lookup type |
STEP_ORDER_APPLICABLE_IND | A step order applicable flag for the lookup type. |
Student System - IGS_GE_JOB_TEXT_ALL | IGS_GE_JOB_TEXT_ALL describes the job text used within reports on the system. Users may enter 'standard' text which is selected at the point of running reports through the job scheduler processing. |
---|---|
Column Name | Descritpion |
SEQUENCE_NUMBER | Identifies each and every row uniquely. It contains sequence generated data. |
JOB_EXECUTION_NAME | Describes the job that can be selected at the point of running reports through the job scheduler processing |
DESCRIPTION | Contains meaning of a job execution name |
TEXT | Contains notes for the description of a job execution |
CREATED_BY | Standard Who 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_GE_REF_CD_TYPE_ALL | IGS_GE_REF_CD_TYPE_ALL describes the types of reference codes which are applied to the course offering options. For example TAC, CRICOS, IVRS. |
---|---|
Column Name | Descritpion |
SELF_SERVICE_FLAG | The reference code type used in self service modules. |
S_REFERENCE_CD_TYPE | The system-defined reference code type assigned to the institution-defined reference code type. This code defines system functionality. |
CLOSED_IND | Indicates and specifies if the reference code type is open or closed. Selecting the checkbox to 'closed' prevents use of the reference code type in new or modified records. |
PROGRAM_OFFERING_OPTION_FLAG | The reference Code type applicable at Program offering option level. |
UNIT_FLAG | The reference code type applicable at unit level. |
UNIT_SECTION_FLAG | The reference code type applicable at unit section level. |
UNIT_SECTION_OCCURRENCE_FLAG | The reference code type applicable at unit section occurence level. |
PROGRAM_FLAG | The reference code type applicable at program level. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REFERENCE_CD_TYPE | The name of an institution-defined reference code type. Each referencecode is assigned a reference code type, which defines its use in thesystem. For example, IVRS CODE. |
ORG_ID | Operating Unit Identifier |
DESCRIPTION | Describes the reference code type |
MANDATORY_FLAG | This field indicates if the reference code type is mandatory for all the applicable levels selected i.e. program, program offering option, unit, unit section and unit section occurrence |
RESTRICTED_FLAG | This flag indicates whether reference codes need to be set up for the reference code type or whether the user can add in the reference code directly in the reference code form within PSP. |
Student System - IGS_GR_APRV_STAT | Describes the statuses of a graduand being approved to graduate |
---|---|
Column Name | Descritpion |
GRADUAND_APPR_STATUS | The institution-defined status used to indicate the progress of a graduand's approval to graduate. Each status is mapped to a system graduand approval status. For example, pending that is mapped to waiting and confirmed that is mapped to |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Explains institution-defined graduand approval status |
S_GRADUAND_APPR_STATUS | The system graduand approval status to which the institution-defined approval status is mapped. System statuses enable specific functionality in the graduation subsystem. |
CLOSED_IND | Indicates and specifies if the graduand approval status is closed. Selecting the checkbox closes the status, making it unavailable for use in new or modified graduand records. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_GR_AWD_CRMN | This entity contains graduand details associated with an award ceremony. |
---|---|
Column Name | Descritpion |
AWARD_CRS_VERSION_NUMBER | Describes the version number of the course for that the award is being specified |
AWARD_CD | The unique identifier for the award |
US_GROUP_NUMBER | The number of the unit set group to that the graduand has been allocated within their award at the ceremony. |
ORDER_IN_PRESENTATION | The graduand's order in presentation at the graduation ceremony. Ensures that graduands will be in the correct order and seat. An Order in presentation is allocated to each attending graduand viathe job GRDF5200. |
GRADUAND_SEAT_NUMBER | The seat number allocated to the graduand for the graduation ceremony. |
GAC_ID | Unique numberthat identifies each row of this table |
NAME_PRONUNCIATION | Guide to the pronunciation of the graduand 's name at the graduationceremony. |
NAME_ANNOUNCED | Graduand name to be announced at the ceremony. If no name is specified, the person's recorded given names and surname are used. |
PERSON_ID | The person ID of the graduand |
ACADEMIC_DRESS_RQRD_IND | Indicates and specifies if or not the graduand requires academic regalia for the graduation ceremony. When the checkbox is selected, regalia is required. |
ACADEMIC_GOWN_SIZE | Size of the academic gown required by the graduand. |
ACADEMIC_HAT_SIZE | Size of the academic headwear required by the graduand. |
CREATE_DT | Describes the date this graduand record was created. This with the person ID uniquely identifies a graduand. |
GUEST_TICKETS_REQUESTED | The number of guest tickets requested by the graduand for the graduation ceremony. |
GUEST_TICKETS_ALLOCATED | The number of guest tickets allocated to the graduand for the graduation ceremony. |
GUEST_SEATS | The seat numbers allocated to the graduand's guests at the graduation ceremony. |
FEES_PAID_IND | Indicates and specifies if or not the graduand has paid the fees associated with graduation. When the checkbox is selected, the fees have been paid. |
GRD_CAL_TYPE | The ceremony round containing the graduand's award ceremony |
SPECIAL_REQUIREMENTS | A text field forentering any special graduand requirements at the graduation ceremony. For example, wheelchair access required, seat off stage, helper required. |
COMMENTS | A text field forentering any additional details about the graduand award ceremony. |
CREATED_BY | Standard Who column |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
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 |
CEREMONY_NUMBER | The number of the ceremony to that the graduand has been allocated |
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 |
AWARD_COURSE_CD | Describes the course code for that the award is being specified |
Student System - IGS_GR_AWD_CRMN_HIST | This entity describes the link between a graduand, a student course attempt and a ceremony. |
---|---|
Column Name | Descritpion |
COMMENTS | Any additional detail for the graduand award ceremony |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CEREMONY_NUMBER | Describes the number uniquely identifying the graduation ceremony |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
AWARD_COURSE_CD | Describes the course code for that the award is being specified |
GACH_ID | Unique number that identifies each row of this table |
AWARD_CRS_VERSION_NUMBER | Describes the version number of the course for that the award is being specified |
AWARD_CD | The unique identifier for the award |
PERSON_ID | Person ID of the graduand |
HIST_START_DT | Effective start date and time of the history record |
HIST_END_DT | Effective end date and time of the history record |
CREATE_DT | Describes the date this graduand record was created. This with the person ID uniquely identifies a graduand. |
HIST_WHO | The Oracle username of the person who created the history record |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony round is for |
US_GROUP_NUMBER | Uniquely identifies a group of one or more unit sets being awarded at a course award ceremony. |
ORDER_IN_PRESENTATION | Describes the graduands order in the presentation of graduates at the graduation ceremony. The order in presentation will ensure graduates will be in the correct seats to receive the correct award. Graduands being awarded in absentia will |
GRADUAND_SEAT_NUMBER | Describes the seat number allocated to the graduand for the graduation ceremony |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
NAME_PRONUNCIATION | Describes how to pronounce the graduands name, if pronunciation would cause a problem |
NAME_ANNOUNCED | Describes the name to be announced at the ceremony if different to person name |
ACADEMIC_DRESS_RQRD_IND | Describes if or not academic dress is required |
ACADEMIC_GOWN_SIZE | Describes the size of the academic gown required by the graduand |
ACADEMIC_HAT_SIZE | Describes the size of the academic headwear required by the graduand |
GUEST_TICKETS_REQUESTED | Describes the number of guest tickets requested by the graduand for the the graduation ceremony |
GUEST_TICKETS_ALLOCATED | Describes the number of guest tickets allocated for the graduand for the graduation ceremony. This will depend on theavailability of tickets. |
GUEST_SEATS | Describes the seat numbers at the graduation ceremony for the graduands guests |
FEES_PAID_IND | Describes if or not the graduand has paid their fees |
SPECIAL_REQUIREMENTS | Describes any special requirements by the graduand forceremony attendance. For example, wheelchair access, seat off stage, helper required. |
Student System - IGS_GR_AWD_CRM_US_GP | This entity describes the groups of unit sets which are being processed during the nominated graduation ceremony. |
---|---|
Column Name | Descritpion |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony roundis for |
US_GROUP_NUMBER | Uniquely identifies a group of one or more unit sets being awarded at a program award ceremony |
ORDER_IN_AWARD | The order in graduation ceremony presentation assigned to the unit set group within the program award. For example, iIf the unit set group is assigned an order in award of '2', graduands in the unit set group are grouped together and pres |
OVERRIDE_TITLE | Title for the unit set group that will override the default title. The default title is derived from the names of the unit sets within the unit set group. For example, the default title for the group can be 'ACCOUNTING MAJOR AND FINANCE MAJ |
CLOSED_IND | Indicates and specifies if the award ceremony unit set group is open or closed. Selecting the checkbox to 'closed' prevents use of the award ceremony unit set group and will prompt the graduand award ceremony allocation process to allocate |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CEREMONY_NUMBER | Describes the number uniquely identifying the graduation ceremony |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
AWARD_COURSE_CD | Describes the course code for the award is being specified |
AWARD_CRS_VERSION_NUMBER | Describes the version number of the course for that the award is being specified |
AWARD_CD | The unique identifier for the award |
Student System - IGS_GR_AWD_CRM_UT_ST | This entity describes the unit sets which make up the unit set groups which are being processed during the nominated graduation ceremony. |
---|---|
Column Name | Descritpion |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony round is for |
US_GROUP_NUMBER | Uniquely identifies a group of one or more unit sets being awarded at. |
UNIT_SET_CD | The code of a unit set assigned to the unit set group.Typically, USG's contain only a single unit set. However, if it is necessary to identify and allocate graduands to a ceremony based on enrolment in or completion of multiple primary unit |
US_VERSION_NUMBER | Unit set version number |
ORDER_IN_GROUP | Order of unit sets within the unit set group default title. This value does not control the order of graduands within the unit set group. |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CEREMONY_NUMBER | Describes the number uniquely identifying the graduation ceremony. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
AWARD_COURSE_CD | Describes the program code that the award is being specified |
AWARD_CRS_VERSION_NUMBER | Describes the version number of the program that the award is being specified |
AWARD_CD | Unique identifier for the award |
Student System - IGS_GR_CRM_ROUND_PRD | This entity describes which completion year and period the parent ceremony round will process gradunds for. |
---|---|
Column Name | Descritpion |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony round is for |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
COMPLETION_YEAR | The nominated or derived completion year used to identify graduands associated with the context ceremony round. Multiple completion years can be associated with each ceremony round. The graduand indentification and creation process selects |
COMPLETION_PERIOD | The nominated or derived completion period used to identify graduands associated with the context ceremony round. Multiple completion periods can be associated with each ceremony round. The graduand indentification and creation process sele |
Student System - IGS_GR_GOVT_HNS_LVL | This entity describes the list of government defined honors levels granted to students as part of graduation. |
---|---|
Column Name | Descritpion |
DESCRIPTION | Provides an explanation of the government honours levels. The government honours level is a code indicating the level of bachelor honours award which has been granted to a student. DETYA element 352. |
CLOSED_IND | Indicates and specifies if the Government honours level is openor closed. Selecting the checkbox to 'closed' prevents use of the Government honours level. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
GOVT_HONOURS_LEVEL | Describes the code indicating the level of bachelor honours award that has been granted to a student. DETYA element 352. |
Student System - IGS_GR_NOTE_TYPE | This entity describes the available graduation note types. |
---|---|
Column Name | Descritpion |
GRD_NOTE_TYPE | An institution-defined note type relating to a graduation ceremony. These note types are used when creating notes in GRDF2510. |
DESCRIPTION | Describes an institution defined note type, relating to a graduation ceremony. These note types are used when creating notes in. |
CREATED_BY | Standard Who 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_GR_STAT | This entity describes the statuses of a graduand. |
---|---|
Column Name | Descritpion |
GRADUAND_STATUS | The institution-defined graduand statuses used to indicate the progress of a graduand record. Each status is mapped to a system graduand status. For example, prospectv - mapped to potential and complete - mapped to eligible. |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Explains the institution-defined graduand status |
S_GRADUAND_STATUS | The system graduand status that the institution-defined status is mapped. System statuses enable specific functionality in thegraduation subsystem. |
CLOSED_IND | Indicates and specifies if or not the graduand status is closed. Selecting the checkbox closes the status, making it unavailable for use in new or modified graduand records. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_GR_TESTAMUR_TYPE | This entity describes the types of a testamur e.g. the style could be for the University or for an entrepreneurial client. |
---|---|
Column Name | Descritpion |
TESTAMUR_TYPE | The institution-defined testamur type. Each institution may define multiple types of testamurs, that each type typically representing a different style and or different content. For example, UNIVERSITY - for standard awards and JOINT - for |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Explains of the testamur type |
CORRESPONDENCE_TYPE | The code of an institution-defined type of correspondence to that thetestamur type is linked. Used by the correspondence facility when testamurs for mailing are generated. |
CLOSED_IND | Indicates and specifies if or not the testamur type is closed. Selecting the checkbox closes the testamur type, making it unavailable for use in new or modified award records. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_GR_AWD_CEREMONY_ALL | This entity describes the awards which are being processed during the nominated graduation ceremony. |
---|---|
Column Name | Descritpion |
ORDER_IN_CEREMONY | The order in graduation ceremony presentation assigned to the award or course award. For example, if the course award is assigned an order in ceremony value of '1', graduands in that course award are presented first. |
CLOSED_IND | Indicates and specifies if the award ceremony is open or closed. Selecting the checkbox to 'closed' prevents use of the award ceremony and will cause the graduand award ceremony allocation process to allocate the graduand_award_ceremony rec |
AWC_ID | Unique number which identifies each row of this table |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony round is for |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | Operating unit identifier |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
CEREMONY_NUMBER | Describes the number uniquely identifying the graduation ceremony |
AWARD_COURSE_CD | The course award course code |
AWARD_CRS_VERSION_NUMBER | The course award course version number |
AWARD_CD | The award code for the award or course award |
Student System - IGS_GR_CRMN_ALL | This entity describes a graduation ceremony |
---|---|
Column Name | Descritpion |
GRD_CAL_TYPE | Calendar type of the graduation calendar used for the ceremony round. |
CEREMONY_START_TIME | Start time of the graduation ceremony |
CEREMONY_END_TIME | Estimated end time of the graduation ceremony |
CEREMONY_FEE | Fee to be paid by each graduand attending the ceremony |
NUMBER_OF_GUESTS | Maximum number of guests allowed for each graduand at thegraduation ceremony |
CREATED_BY | Standard Who column |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CEREMONY_NUMBER | Number uniquely identifying the graduation ceremony. Once a graduation ceremony has been created, its number can not be modified. |
ORG_ID | Operating unit identifier |
VENUE_CD | Code for the venue the ceremony is to be held |
CEREMONY_DT_ALIAS | Date alias representing the date of the graduation ceremony. The date alias selected must exist within the graduation calendar instance used for the ceremony round. |
CEREMONY_DAI_SEQUENCE_NUMBER | Describes the date alias instance of the graduation ceremony. The date alias is related to the graduation calendar type and calendar instance of the ceremony round. |
CLOSING_DT_ALIAS | Date alias used to represent the closing date for graduands applying to graduate at the context ceremony. Oracle Student System uses this date to raise a warning if new graduand records are created and associated with the context ceremony |
CLOSING_DAI_SEQUENCE_NUMBER | Sequence number of the ceremony closing date alias instance |
Student System - IGS_GR_CRMN_NOTE_ALL | This entity describes mappings of notes to graduation ceremonies. |
---|---|
Column Name | Descritpion |
GRD_NOTE_TYPE | An institution-defined note type relating to a graduation ceremony. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony round is for |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | Operating unit identifier |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
CEREMONY_NUMBER | Describes the number uniquely identifying the graduation ceremony |
REFERENCE_NUMBER | Identifies the reference number of a particular note |
Student System - IGS_GR_CRMN_ROUND_ALL | This entity describes a round of graduation ceremonies. |
---|---|
Column Name | Descritpion |
GRD_CAL_TYPE | The calendar type of the graduation calendar used for the ceremony round. Each graduation ceremony round is a pre-existing graduation calendar instance, created in CALF0220. |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | Operating unit identifier |
START_DT_ALIAS | The date alias used to represent the date that processing to identify graduands for the context ceremony round can commence. The date alias selected, must exist within calendar instance of the ceremony round. |
CONFERRAL_START_DATE | The Conferral Start and End Date are used to identify Student Program Attempt Award records that have a Conferral Date that falls within this range. |
CONFERRAL_END_DATE | The Conferral Start and End Date are used to identify Student Program Attempt Award records that have a Conferral Date that falls within this range |
START_DAI_SEQUENCE_NUMBER | Describes the date alias instance for the start of processing to identify graduands for this ceremony round. The date alias is related to the graduation calendar type and calendar instance of the ceremony round. |
COMPLETION_START_DATE | The Program Completion Start and End Date are used to identify Student Program Attempt records that have a Program Requirements Complete Date that falls within this range |
COMPLETION_END_DATE | The Program Completion Start and End Date are used to identify Student Program Attempt records that have a Program Requirements Complete Date that falls within this range. |
END_DT_ALIAS | The date alias used to represent the date on which the graduand identification and creation process ends for the context ceremony round. The date alias selected, must exist within the calendar instance of the ceremony round. |
END_DAI_SEQUENCE_NUMBER | Describes the date alias instance for the end of processing to identify graduands for this ceremony round. The date alias is related to the graduation calendar type and calendar instance of the ceremony round. |
Student System - IGS_GR_GRADUAND_ALL | This entity describes graduand details |
---|---|
Column Name | Descritpion |
PERSON_ID | The person ID of the graduand |
AWARD_CRS_VERSION_NUMBER | Describes the version number of the program for the award which the graduand is receiving |
ATTRIBUTE6 | Standard DFF Column |
ATTRIBUTE7 | Standard DFF Column |
AWARD_CD | The code for the award the graduand is receiving |
ATTRIBUTE8 | Standard DFF Column |
ATTRIBUTE9 | Standard DFF Column |
HONOURS_LEVEL | The honours level granted to the graduand. The honours level list of values can contain other levels of achievement in addition to the standard honours levels. For example, pass with distinction and pass with merit. --Obsolete |
ATTRIBUTE10 | Standard DFF Column |
ATTRIBUTE11 | Standard DFF Column |
CONFERRAL_DT | The date the award is conferred. An award can be conferred when council approves a graduand for graduation, or when the graduation ceremony is held. --Obsolete |
ATTRIBUTE12 | Standard DFF Column |
ATTRIBUTE13 | Standard DFF Column |
GRADUAND_STATUS | The current progress status of the graduand. For example, are potential-course requirements are not yet completed, eligible - courserequirements completed and graduated - award conferred. |
ATTRIBUTE14 | Standard DFF Column |
ATTRIBUTE15 | Standard DFF Column |
GRADUAND_APPR_STATUS | The status of the graduand's approval to graduate. Approval is institution-defined. For example, it can be defined as University Council approval of graduands to graduate, or academic organisational unit confirmation of eligible or potentia |
ATTRIBUTE16 | Standard DFF Column |
ATTRIBUTE17 | Standard DFF Column |
S_GRADUAND_TYPE | The type assigned to the graduand, that defines their graduation 'intentions'. The available set of graduand types are attending - will attend graduation ceremony to receive award inabsentia - wishes to receive award, but will not attend ce |
ATTRIBUTE18 | Standard DFF Column |
ATTRIBUTE19 | Standard DFF Column |
ATTRIBUTE20 | Standard DFF Column |
GRADUATION_NAME | The graduand name to appear on the testamur or certificate. The default graduand name is derived from the person's given names and surname, but it can be overridden. |
PROXY_AWARD_IND | Indicates and specifies if or not the award is to be presented to a proxy - identified by the proxy award person ID. Selecting the checkbox, indicates that the award is to be received by a proxy. The indicator must be set if the graduand is |
CREATE_DT | The date and time the graduand record was created. This value, together with the person ID, uniquely identifies a graduand. |
PROXY_AWARD_PERSON_ID | The ID of the person acting as the proxy. For example, if the award is posthumous, the ID of the person receiving the award must be entered. If the proxy does not have an existing person record in the database, a record must first be create |
PREVIOUS_QUALIFICATIONS | A text field for entering any previous qualifications obtained by the graduand. Details can be announced or included in reports, such as the ceremony programme extract. |
CONVOCATION_MEMBERSHIP_IND | Indicates and specifies if the graduand's desire for convocation membership. The indicator is set if the graduand requests membership. |
SUR_FOR_COURSE_CD | The code of the course for that the graduand is surrendering a received award, or for which an articulating graduand is declining an eligible award. This detail must be provided when the graduand status is set to surrender or the graduand |
SUR_FOR_CRS_VERSION_NUMBER | The version of the program for that the graduand is surrendering a a received award, or for which an articulating graduand is declining an eligible award. |
SUR_FOR_AWARD_CD | An award that the graduand is surrendering a received award, or or that an articulating graduand is declining an eligible award. This detail must be provided when the graduand status is set to surrender or the graduand type is set to artic |
GRD_CAL_TYPE | The graduation calendar type of the ceremony round the graduand is associated. The ceremony round can be modified ifgraduation is deferred. |
COMMENTS | A text field forentering any additional detail about the graduand. For examples, AOU reason for not approving a graduand, notes on acceptance of an alternative exit program 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 |
REQUEST_ID | Request identifier of last concurrent program to update this record |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
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 |
COURSE_CD | The graduand's course attempt code. A course code is not required for recipients of honorary awards. |
ATTRIBUTE_CATEGORY | Standard DFF Column |
ATTRIBUTE1 | Standard DFF Column |
ATTRIBUTE2 | Standard DFF Column |
ATTRIBUTE3 | Standard DFF Column |
AWARD_COURSE_CD | The course code associated with the graduand's award. This code is typically the same as the graduand course code, but is different if the award is associated with an alternative exit. For example, the graduand's course attempt code is EA47 |
ATTRIBUTE4 | Standard DFF Column |
ATTRIBUTE5 | Standard DFF Column |
Student System - IGS_GR_GRADUAND_HIST_ALL | This entity describes graduand details |
---|---|
Column Name | Descritpion |
PERSON_ID | The person ID of the graduand |
COURSE_CD | Describes the course code for the student program attempt the graduandis completing |
AWARD_COURSE_CD | Describes the program code for the award that the graduand is receiving |
AWARD_CRS_VERSION_NUMBER | Describes the version number of the program for the award that the graduand is receiving |
AWARD_CD | The unique identifier for the award that the graduand is receiving |
HONOURS_LEVEL | Describes the honors level granted to a graduating student. --Obsolete |
CONFERRAL_DT | Describes the date the award is conferred. --Obsolete |
CREATE_DT | Describes the date this graduand record was created. This with the person ID uniquely identifies a graduand. |
GRADUAND_STATUS | Describes the current status of this graduand |
GRADUAND_APPR_STATUS | Describes the status of the graduands approval to graduate. |
S_GRADUAND_TYPE | This is the type of graduand. This has system defined types of unknown, attending, inabsentia, deferred, surrenderd and renounced. This is determined by the graduands reponse and has a default value of unknown. |
GRADUATION_NAME | The graduand name to appear on the testamur or certificate. The default graduand name is derived from the person's given names and surname, but it can be overridden. |
PROXY_AWARD_IND | Indicates if or not the award is to be presented to a proxy that is identified by the proxy award person ID |
PROXY_AWARD_PERSON_ID | Describes the ID of the person to collect the award by proxy |
HIST_START_DT | The effective start date and time of the history record. |
PREVIOUS_QUALIFICATIONS | Describes any previous degree to thesis title obtained by the graduand. Details will be announced or included with the award. |
CONVOCATION_MEMBERSHIP_IND | Describes if or not the granduate wants to have convocation membership |
HIST_END_DT | The effective end date and time of the history record |
SUR_FOR_COURSE_CD | Describes the program code for the award that the graduand issurrendering this award for |
SUR_FOR_CRS_VERSION_NUMBER | Describes the program version for the award that the graduand is surrendering this award for. |
SUR_FOR_AWARD_CD | Describes the award code that the graduand is surrendering this award for |
HIST_WHO | The Oracle username of the person who created the history record |
COMMENTS | Any additional detail for this graduand. For example, AOU reason for rejecting a graduand, notes on acceptance of early exit or awards not linked to a student program attempt. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
GRD_CAL_TYPE | Describes the graduation calendar type the ceremony round is for |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | Operating unit identifier |
GRD_CI_SEQUENCE_NUMBER | Describes the calendar instance of the graduation calendar the ceremony round is for |
Student System - IGS_GR_HONOURS_LEVEL_ALL | This entity describes the user-defined level of honours granted to a student as part of graduation. These will map back onto the DEET level of honours. |
---|---|
Column Name | Descritpion |
HONOURS_LEVEL | An institution-defined code that defines the honours level granted to a graduating student. For example, 'H1' - first class honors. Honors level can also be used to indicate other windows of achievement by graduating students such as 'pass |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Describes honors level code. The honors level code is an institution-defined code that defines the honors level granted to a graduating student. For example, 'H1' - first class honors. |
ORG_ID | Operating unit identifier |
GOVT_HONOURS_LEVEL | The government-defined honors level code that the institution defined honors level is mapped. Used for reporting purposes. It indicates the level of bachelor honors award which has been granted to a student. |
RANK | The rank of the honors level in relation to other honors levels. Rank is used for comparison of honors level in sort ordering on reports and for ordering of graduands in conferral ceremonies |
CLOSED_IND | Indicates and specifies if the honors level is open or closed. Selecting the indicator to 'closed' prevents use of the code in new or modified graduand records. |
Student System - IGS_GR_SPECIAL_AWARD_ALL | This entity describes special awards that may be awarded to a graduand. |
---|---|
Column Name | Descritpion |
PERSON_ID | The person ID of the graduand |
COURSE_CD | Describes the program code for the student program attempt the graduand is receiving the special award for |
COMMENTS | A text field for enterng any additional details about the special award. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
AWARD_CD | The award code for the special award to be presented to the student or graduand. Special awards are either prizes or medals and can or can not be announced at a graduation ceremony. |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | Operating unit identifier |
AWARD_DT | The date the special award was presented |
CEREMONY_ANNOUNCED_IND | Indicates and specifies if or not the special award is to be announced at a graduation ceremony. When the checkbox is selected ,the special award is to be announced at a ceremony. It is expected that details of such awards will be included |
Student System - IGS_GR_VENUE_ALL | This entity describes the physical venue where an examination, graduation ceremony, etc can be accommodated. A venue can exist within a location (e.g. campus) or examination location (e.g. Town Hall). |
---|---|
Column Name | Descritpion |
VENUE_CD | The code that uniquely identifies the examination or graduation venue. |
COORD_PERSON_ID | The ID of the person responsible for the co-ordination of the venue.This person can be different from the contact person's recorded as part of the address details, and can or can not be the parent location co-ordinator. |
CLOSED_IND | Indicates and specifies if or not the venue is closed. Selecting the checkbox, closes the venue and prevents further use. |
EXAM_LOCATION_CD | The code of the venue's parent examination location. An open venue must always have an open parent exam location. |
DESCRIPTION | The full name of the venue |
NUMBER_OF_SEATS | The maximum number of seats in the venue. A value must be entered in this field. |
COMMENTS | A text facility for entering any additional comments about the venue |
RESOURCES_AVAILABLE | A text facility for entering the resources available at the venue. For example, chairs, tables, and heating. |
ANNOUNCEMENTS | A text facility for entering any venue specific announcements to be made before examinations. |
BOOKING_INFORMATION | A text facility for entering any information relating to the booking of the venue. For example, contact details. |
SEATING_INFORMATION | A text facility for entering any additional information about the seating at the venue. For example, seating layout, seat number range. |
INSTRUCTIONS | A text facility to enter any venue specific instructions. |
CREATED_BY | Standard Who 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 |
BOOKING_COST | The cost of hiring the venue |
PRIORITY_CD | The priority assigned to the venue indicating an order of preference when allocating examinations. There is no associated system functionality. |
SUPERVISOR_LIMIT | The maximum number of supervisors that should normally be allocated to the venue. When allocating supervisors to a venue for an exam session, the system raises a warning if the limit is about to be exceeded. |
Student System - IGS_IN_APPLINFO_TYPE | This entity describes the types of information requested with an enquiry - Obsolete |
---|---|
Column Name | Descritpion |
LAST_UPDATE_LOGIN | Standard Who column |
PERSON_ID | Describes the ID code that uniquely identifies a person |
ENQUIRY_APPL_NUMBER | Number identifying the enquiry made by a person |
ENQUIRY_INFORMATION_TYPE | Describes the user-defined types of enquiry that are likely to be made. For exxample, travel, accommodation, fees. |
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_IN_APPLML_PKGITM | This table stores the details of enquiry package - Obsolete |
---|---|
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 |
PERSON_ID | Describes the ID code that uniquely identifies a person |
ENQUIRY_APPL_NUMBER | Number identifying the enquiry made by a person |
ENQUIRY_PACKAGE_ITEM | Describes the items that can be included in an enquiry package |
MAILED_DT | The date that the enquiry package item was mailed |
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 |
DONOT_MAIL_IND | Do Not Mail Indicator |
Student System - IGS_IN_APPL_CHAR_TYP | This table stores the type of enquiry made by a person - Obsolete |
---|---|
Column Name | Descritpion |
ENQUIRY_APPL_NUMBER | Number identifying the enquiry made by a person |
ENQUIRY_CHARACTERISTIC_TYPE | Describes the user-defined types of characteristic of an enquiry. Examples are school leaver, TAFE graduate, domestic, international. |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
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. |
Student System - IGS_IN_APPL_COURSE | This entity describes the courses of interest to an enquiry application - Obsolete |
---|---|
Column Name | Descritpion |
LAST_UPDATE_LOGIN | Standard Who column |
PERSON_ID | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
ENQUIRY_APPL_NUMBER | Number identifying the enquiry made by a person |
COURSE_CD | A code used to identify the program which the student has made an enquiry about |
VERSION_NUMBER | A number signifying the version of the course which the student has enquired about |
LOCATION_CD | The location, typically a campus, from where the course being enquired about, is offered |
ATTENDANCE_MODE | The institution-defined attendance modes that the program is offered. Institution-defined attendance modes can include, for example, N-on campus, F-off campus and M-multi-modal. |
ATTENDANCE_TYPE | The institution-defined attendance type that theprogram is offered. Institution-defined attendance types can include, for example, F-full-time and P-part-time. |
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_IN_ENQ_CHAR_TYPE | This entity describes the characteristics of an enquirer to the institution. Examples School leaver, Graduate, Domestic or International. Used for statistical purposes and to allow for tailoring of packages - Obsolete |
---|---|
Column Name | Descritpion |
CREATION_DATE | Standard Who column |
ENQUIRY_CHARACTERISTIC_TYPE | Describes the user-defined types of characteristic of an enquiry .Examples are school leaver, TAFE graduate, domestic, international. |
DESCRIPTION | Provides an explanation of the enquiry characteristic type |
CLOSED_IND | Indicates if the enquiry characteristic type is active. Selecting the checkbox ticked will prevent its use in new or modified enquiry records. |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CREATED_BY | Standard Who column |
Student System - IGS_IN_ENQ_INFO_TYPE | This entity describes the types of enquiry made e.g. travel, fees, accommodation, course, faculty. The types of enquiry are user-defined with the exception of system-defined 'all information' - Obsolete |
---|---|
Column Name | Descritpion |
CREATED_BY | Standard Who column |
ENQUIRY_INFORMATION_TYPE | Describes the user-defined types of enquiry that are likely to be made. Examples are travel, accommodation, fees. |
DESCRIPTION | Provides an explanation of the enquiry information type |
CLOSED_IND | Indicates if the enquiry information type is active .Se;ecting the 'closed' indicator means that the enquiry information type can no longer be used when registering admission enquiry records. |
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_IN_ENQ_PKG_ITEM | This entity describes correspondence, either system or non-system generated, which can be included in an enquiry package - Obsolete |
---|---|
Column Name | Descritpion |
CREATION_DATE | Standard Who column |
ENQUIRY_PACKAGE_ITEM | Describes the items that can be included in an enquiry package |
DESCRIPTION | Provides an explanation of the enquiry package item |
CLOSED_IND | An indicator that specifies if the enquiry package item is open orclosed. Selecting the checkbox to 'closed' ticked prevents use of the enquiry package item in new or modified enquiry package records. |
SYS_GENERATED_IND | Indicates if the enquiry package item is system generated or not |
AVAILABLE_IND | Indicates if the package item is available |
AVAILABLE_DT | The estimated date for availability of the package item. This is used as an informative guide only and has no functionality attached. Note this data is required to be manually maintained. |
ATTENDANCE_MODE | Indicates if the enquiry package item is directed at a particular attendance mode. Examples include N on-campus mode of attendance, F off-campus mode of attendance and M Multi-modal mode of attendance. Note- where no attendance mode is spe |
LAST_UPDATED_BY | Standard Who column |
PUBLISH_SS_IND | Publish In Self Service Indicator |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
CREATED_BY | Standard Who column |
Student System - IGS_IN_ENQ_SRC_TYPE | This entity describes the sources of an enquiry to the institution Examples newspaper advertising, school liaison activity - Obsolete |
---|---|
Column Name | Descritpion |
LAST_UPDATE_LOGIN | Standard Who column |
ENQUIRY_SOURCE_TYPE | Describes the type of source responsible for an admission enquiry being made. Examples newspaper advertisement, school liaison activity. |
DESCRIPTION | Provides an explanation of the enquiry source type |
CLOSED_IND | An indicator that specifies if the enquiry source type is open or closed. Selecting the checkbox to 'closed' - ticked prevents use of the enquiry source type in new or modified admission enquiry records. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Student System - IGS_IN_ENQ_STATUS | This entity describes the user defined enquiry statuses relating to an enquiry to the institution Examples registered,acknowledged. These map onto system defined enquiry statuses - Obsolete |
---|---|
Column Name | Descritpion |
CREATED_BY | Standard Who column |
ENQUIRY_STATUS | Enquiry status is a value attributed to an admission enquiry to indicate the state of the institution's response to the enquiry. These statuses are institution-defined, but must map back to the system-defined statuses of registered, acknowl |
DESCRIPTION | Gives further explanation of an enquiry status |
LAST_UPDATE_DATE | Standard Who column |
S_ENQUIRY_STATUS | System-defined enquiry status for example, acknowledged, registered or complete. |
CLOSED_IND | An indicator that specifies if the enquiry status is open or closed. Selecting the checkbox to 'closed' ticked prevents use of the enquiry status in new or modified enquiry records. |
LAST_UPDATE_LOGIN | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Student System - IGS_IN_INFTYP_PKG_IT | This entity describes the enquiry package items available to a particular information type, example. fees information may be for a course or fees enquiry - Obsolete |
---|---|
Column Name | Descritpion |
LAST_UPDATE_LOGIN | Standard Who column |
ENQUIRY_INFORMATION_TYPE | The user-defined types of enquiry that are likely to be made. Examples are travel, accommodation, fees. |
ENQUIRY_PACKAGE_ITEM | Describes the correspondence, either system or non-system generated, hat is to be included in an enquiry package for a particular information type. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
Student System - IGS_IN_LVLTYP_PKG_IT | This entity describes package items available to a particular level of enquiry Examples . fees information may be relevant to a faculty, and institution level enquiry - Obsolete |
---|---|
Column Name | Descritpion |
LAST_UPDATE_LOGIN | Standard Who column |
S_ENQUIRY_LEVEL_TYPE | The system-defined levels of enquiry. Examples are institution, organisational unit, discipline, course. |
ENQUIRY_PACKAGE_ITEM | Describes the correspondence, either system or non-system generated, that is to be included in an enquiry package for a particular level type. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
Student System - IGS_IN_ENQUIRY_APPL_ALL | This entity describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information - Obsolete |
---|---|
Column Name | Descritpion |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Request identifier of last concurrent program to update this record. |
PROGRAM_APPLICATION_ID | Application identifier of last concurrent program to update this record. |
PROGRAM_ID | Program identifier of last concurrent program to update this record. |
PROGRAM_UPDATE_DATE | Last update date of this record by a concurrent program. |
PERSON_ID | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
ENQUIRY_APPL_NUMBER | Number identifying the enquiry made by a person |
ACAD_CAL_TYPE | Describes the academic calendar type that the admission enquiry application relates |
ACAD_CI_SEQUENCE_NUMBER | A unique number that identifies the academic calendar instance that the enquiry application refers to |
ADM_CAL_TYPE | Describes the admission calendar type that the admission enquiry application applies |
ADM_CI_SEQUENCE_NUMBER | A unique number that identifies the admission calendar instance that the enquiry application refers to |
ENQUIRY_STATUS | Describes the user-defined status of the enquiry |
ENQUIRY_DT | Describes the date the enquiry was made |
ENQUIRY_SOURCE_TYPE | Describes the type of source responsible for an admission enquiry being made. Examples newspaper advertisement, school liaison activity. |
REGISTERING_PERSON_ID | Person who registered the enquiry |
OVERRIDE_PROCESS_IND | Describes if the to force the processing of an incomplete package for the person. If selected, it will override any limitations placed on the processing routine. |
INDICATED_MAILING_DT | Describes the promised mailing date of the enquiry to be used as an alert when packages are not mailed in satisfactory time frames |
LAST_PROCESS_DT | Describes the latest processing date of the enquiry |
COMMENTS | Additional information relating to the enquiry |
INQ_ENTRY_STAT_ID | Unique Identifier for Entry Status |
INQ_ENTRY_LEVEL_ID | Unique Identifier for Entry Level |
EDU_GOAL_ID | Unique Identifier for Educational Goal |
PARTY_ID | Unique Identifier for Organization Unit related to Inquiry School of Interest |
HOW_KNOWUS_ID | Unique Identifier for How Do You Know Us |
WHO_INFLUENCED_ID | Unique Identifier for Who Influenced your decision |
ATTRIBUTE_CATEGORY | Attribute Category For Descriptive Flex field |
ATTRIBUTE1 | Descriptive Flex Field Column |
ATTRIBUTE2 | Descriptive Flex Field Column |
ATTRIBUTE3 | Descriptive Flex Field Column |
ATTRIBUTE4 | Descriptive Flex Field Column |
ATTRIBUTE5 | Descriptive Flex Field Column |
ATTRIBUTE6 | Descriptive Flex Field Column |
ATTRIBUTE7 | Descriptive Flex Field Column |
ATTRIBUTE8 | Descriptive Flex Field Column |
ATTRIBUTE9 | Descriptive Flex Field Column |
ATTRIBUTE10 | Descriptive Flex Field Column |
ATTRIBUTE11 | Descriptive Flex Field Column |
ATTRIBUTE12 | Descriptive Flex Field Column |
ATTRIBUTE13 | Descriptive Flex Field Column |
ATTRIBUTE14 | Descriptive Flex Field Column |
ATTRIBUTE15 | Descriptive Flex Field Column |
ATTRIBUTE16 | Descriptive Flex Field Column |
ATTRIBUTE17 | Descriptive Flex Field Column |
ATTRIBUTE18 | Descriptive Flex Field Column |
ATTRIBUTE19 | Descriptive Flex Field Column |
ATTRIBUTE20 | Descriptive Flex Field Column |
ORG_ID | Operating unit identifier. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
Student System - IGS_OR_GOVT_INST_CD | This entity describes the DEET set of institution codes. |
---|---|
Column Name | Descritpion |
GOVT_INSTITUTION_CD | The unique DETYA defined code for a tertiary institution. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
DESCRIPTION | The name of a DETYA specified tertiary institution matching the DETYA institution code. Institution names usually match the names listed in Appendix A of the DETYA higher education student collection documentation. |
LAST_UPDATE_LOGIN | Standard Who column |
CLOSED_IND | Indicates and specifies if the government institution code is open or closed. Selecting the checkbox to 'closed' prevents use of the code in new or modified records in other parts of the system. For example, in institution records. |
Student System - IGS_OR_INST_STAT | This entity describes the user-defined institution statuses. These map back onto the system institution 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 |
INSTITUTION_STATUS | A status that indicates the level of activity of an institution record. Each must be mapped to a system status of active or inactive. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Describes institution status. An institution status indicates the level of activity of an institution record. Each must be mapped to a system status of active or inactive. |
S_INSTITUTION_STATUS | A system-recognized institution status. Each user-defined institution status must be mapped to a system status as inactive or active. |
CLOSED_IND | Indicates and specifies if the institution status is open or closed. Selecting the checkbox to 'closed' prevents use of the status in new or modified institution records. |
Student System - IGS_OR_MEMBER_TYPE | This entity describes the membership within the organisationa lstructure. It represents the type of organisational unit as a structure leveled grouping. |
---|---|
Column Name | Descritpion |
MEMBER_TYPE | The name of a member type. A member type is a classification of organizational units by structure level. Each organizational unit must be assigned a member type. Examples are faculty, school, department and division. |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Describes a member type. A member type is a classification of organizational units by structure level. Eachorganizational unit must be assigned a member type. Examples are faculty, school, department and division. |
CLOSED_IND | An indicator which specifies if the member type is open or closed. Selecting the checkbox to 'closed' prevents use of the member type in new or modified organizational unit records. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_OR_ORG_ACCR_DTLS | This entity describes accreditation details. |
---|---|
Column Name | Descritpion |
ORG_STRUCTURE_ID | An organization structure ID |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_STRUCTURE_TYPE | An organization structure type |
ORG_AGENCY_ID | An organization agency ID |
ORG_ACCR_STATUS | An organization accreditation status like active, inactive or planned. |
START_DATE | The start date from that the accreditation details is applicable. |
END_DATE | The end date from that the accreditation details are applicable. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_OR_ORG_ACCR_STAT | This entity stores organization accreditation and Description for it. |
---|---|
Column Name | Descritpion |
ORG_ACCR_STATUS | An organization accreditation status like active, inactive or planned. |
ACCR_STATUS_DESCRIPTION | Describes an organization accreditation status |
CLOSE_IND | The flag to indicate if to use this status further or not |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Student System - IGS_OR_ORG_ALT_IDS | This entity contains alternate IDs for institutions or organizational units. |
---|---|
Column Name | Descritpion |
ORG_STRUCTURE_ID | An organization structure ID |
CREATED_BY | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_STRUCTURE_TYPE | An organization structure type |
ORG_ALTERNATE_ID_TYPE | An organization alternate ID type |
ORG_ALTERNATE_ID | An organization alternate ID |
START_DATE | The start date from which alternate ID is applicable. |
END_DATE | The end date when alternate ID will get expired. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_OR_ORG_ALT_IDTYP | This entity stores user defined other agencies or systems for which alternate ID codes are maintained. |
---|---|
Column Name | Descritpion |
ORG_ALTERNATE_ID_TYPE | An organization alternate ID type |
LAST_UPDATE_LOGIN | Standard Who column |
ID_TYPE_DESCRIPTION | Describes an organization alternate ID type |
INST_FLAG | Indicates if this is unit alternate ID type or Institution alternate ID type |
UNIT_FLAG | Indicates if this is unit alternate ID type or institution alternate ID type |
CLOSE_IND | Indicate if to use this further in system or not |
SYSTEM_ID_TYPE | System ID Type |
PREF_INST_IND | To Indicate a Preferred Alternate ID Type for Institution |
PREF_UNIT_IND | To Indicate a Preferred Alternate ID Type for Organization Unit |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Student System - IGS_OR_ORG_NOTES | This entity contains notes about institutions, organizational units or locations. |
---|---|
Column Name | Descritpion |
ORG_STRUCTURE_ID | An organization structure ID |
END_DATE | The end date till when this will be applicable in the system. |
NOTE_TEXT | This is note text for this note |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_STRUCTURE_TYPE | The structure type that distinguishes if it is a location note type or organization type or institution type. |
ORG_NOTE_SEQUENCE | A note sequence generated by sequence |
ORG_NOTE_TYPE | This is note type |
START_DATE | The start date from when this will be applicable in the system. |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Student System - IGS_OR_ORG_NOTE_TYPE | This entity stores users defined structure or classification to descriptive information note types which are available for organizational structure entities like institutions, organizational units or locations. |
---|---|
Column Name | Descritpion |
ORG_NOTES_TYPE | A note type for organization, institution or location |
LAST_UPDATE_LOGIN | Standard Who column |
NOTE_TYPE_DESCRIPTION | Describes a note type for organization, institution or location |
INST_FLAG | To check if this is for institution or location or organization |
UNIT_FLAG | To check if this is for institution or location or organization |
LOCATION_FLAG | To check if this is for institution or location or organization |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CREATED_BY | Standard Who column |
Student System - IGS_OR_REL_PS_TYPE | This table contains the course type restrictions used in the organization unit relationship for the purposes of committee structures used within Progression and in future to be used in other areas. |
---|---|
Column Name | Descritpion |
PARENT_ORG_UNIT_CD | Describes the parent organizational unit code of the relationship |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
PARENT_START_DT | Describes the parent start date |
CHILD_ORG_UNIT_CD | Describes the child organizational unit code of the relationship |
CHILD_START_DT | Describes the child start date |
OUR_CREATE_DT | Describes the creation date of the organizational unit relationship |
COURSE_TYPE | Describes the program type qualifying the organizational unit relationship. |
Student System - IGS_OR_STATUS | This entity describes the user-defined organization statuses. E.g. Current, Suspended. |
---|---|
Column Name | Descritpion |
ORG_STATUS | The name of the organizational unit status. An organizational unit status indicates the level of activity of an organizational unit record. Each must be mapped to a system status active or inactive. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Describes of the organizational unit status. An organizational unit status indicates the level of activity of an organizational unit record. Each must be mapped to a system status active or inactive. |
S_ORG_STATUS | A system-recognized organizational unit status. Each organizational unit status must be mapped to a system status of inactive or active. |
CLOSED_IND | Indicates and specifies if the organizational unit status is open or closed. Selecting the checkbox to 'closed' prevents use of the status in new or modified organizational unit records. |
Student System - IGS_OR_TYPE | This entity describes the recognised organisational types. The organisation type classifies the organisational unit into for example academic or administrative, internal or external. |
---|---|
Column Name | Descritpion |
ORG_TYPE | The name of the organizational type. Organizational types arebusiness category classifications of organizational units. Eachorganizational unit must be assigned an organizational type. Examplesare academic and administrative. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
DESCRIPTION | Describes the organizational type. Organizational types are business category classifications of organizational units. Each unit must be assigned an organizational type. Examples are academic and administrative. |
CLOSED_IND | Indicates and specifies if the organizational type is open or closed. Selecting the checkbox to 'closed' prevents use of the organizational type in new or modified organizational unit records. |
Student System - IGS_OR_UNIT_AC | This entity describes the accounts in which funds are held for the nominated organisational unit. |
---|---|
Column Name | Descritpion |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
FIN_CAL_TYPE | This column is made obsolete |
FIN_CI_SEQUENCE_NUMBER | This column is made obsolete |
ACCOUNT_CD | The general ledger account code specific to a financial reporting period. It is used when recording assessments, receipting payments and disbursing income. Each account is linked to an instance of the 'financial period' calendar. |
ORG_UNIT_CD | The code for the organizational unit. An organizational unit is uniquely identified by the combination of its code and start date. An organizational unit is a business unit of an institution ororganization. Common organizational units in te |
OU_START_DT | The date from which the organizational unit is effective. Theorganizational unit is uniquely identified by the combinationof its code and start date. |
CLASSIFICATION_CD | An institution-defined classification code that is used to mark organizational unit accounts for specific fee income disbursement. Each disbursement formula is assigned a specific classification code which is mapped to organizational unit a |
Student System - IGS_OR_UNIT_LOC | This entity describes the intersection between organizational unit and location. |
---|---|
Column Name | Descritpion |
ORG_UNIT_CD | The code for the organizational unit. An organizational unit is uniquely identified by the combination of its code and start date. An organizational unit is a business unit of an institution or organization. Common organizational units in t |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
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. |
LOCATION_CD | The code for a location associated with the organizational unit. An organizational unit may be associated with multiple locations. Each location has a location type, such as campus,that defines its use in the system. |
CREATED_BY | Standard Who column |
Student System - IGS_OR_UNIT_REL | This entity describes parent and child relationships between organizational units. An organizational unit may have many parents and many children. |
---|---|
Column Name | Descritpion |
PARENT_ORG_UNIT_CD | The organizational unit code for a parent organizational unit in an organizational unit relationship. An organizational unit may have multiple parent organizational units. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
PARENT_START_DT | The start date of a parent organizational unit in an organizational unit relationship. An organizational unit can have multiple parent organizational units. |
CHILD_ORG_UNIT_CD | The organizational unit code for a child organizational unit in an organizational unit relationship. An organizational unit can have multiple child organizational units. |
CHILD_START_DT | The start date of a child organizational unit in an organizational unit relationship. An organizational unit may have multiple child organizational units. |
CREATE_DT | The date from that the organizational unit relationship is effective. |
LOGICAL_DELETE_DT | The date the organizational unit relationship was deleted. Relationships are logically deleted. It is possible to inquire on logically deleted relationships. |
Student System - IGS_OR_INST_HIST_ALL | This entity describes the history of Institution changes |
---|---|
Column Name | Descritpion |
INSTITUTION_CD | The code for the institution with the dependent history record. Normally relates to the DETYA set of institutions, however other institutions relevant to the business of the organization can also be created. An institution is optionally map |
HIST_END_DT | The effective end date and time of the institution history record. It is the date and time the subsequent history record was created. |
HIST_WHO | The Oracle username of the person who created the institution history record. |
NAME | The name of the institution during the creation of the history record. There will be a value in this field only if the name was changed when the subsequent history record was created. |
INSTITUTION_STATUS | The status of the institution during the creation of the history record. |
LOCAL_INSTITUTION_IND | The value of the 'Local Institution' indicator during the creation of the history record. 'Y' means that the indicator was set and 'N' means that it was not set. |
OS_IND | The value of the 'Overseas' indicator during the creation of the history record. 'Y' means that the indicator was set and 'N' means that it was not set. |
GOVT_INSTITUTION_CD | The unique identifier for the government institution code to which the institution was mapped during the creation of the history record. |
DESCRIPTION | Describes the DETYA government institution code to that the institution was mapped during the creation of the history record. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | An organization ID |
INSTITUTION_TYPE | Type of the institution during the creation of the history record. |
INST_CONTROL_TYPE | Control type of the institution during the creation of the history record. |
HIST_START_DT | The effective start date and time of the institution history record. It is the date and time the previous history record was ended. |
INST_PHONE_COUNTRY_CODE | Country code of telephone number of the institution during the creation of the history record. |
INST_PHONE_AREA_CODE | Area code of the telephone number of institution during the creation of the history record. |
INST_PHONE_NUMBER | Telephone number of the institution during the creation of the history record. |
EPS_CODE | Market code of the institution during the creation of the history record. |
INST_PRIORITY_CD | Institution Priority Code. |
INST_PRIORITY_CODE_ID | Priority code of the institution during the creation of the history record. There will be a value in this field only if the priority code was changed when the subsequent history record was created - OBSOLETE |
Student System - IGS_OR_ORG_INST_TYPE_ALL | This entity holds different institution type and its description. |
---|---|
Column Name | Descritpion |
INSTITUTION_TYPE | The institution type |
DESCRIPTION | Describes the institution type |
SYSTEM_INST_TYPE | System Institution Type |
CLOSE_IND | Indicates if to use this further in system or not |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | An organization ID |
Student System - IGS_OR_ORG_IN_CTLTYP_ALL | This entity holds different institution control type and its description. |
---|---|
Column Name | Descritpion |
INST_CONTROL_TYPE | A institution control type |
DESCRIPTION | Describes a institution control type |
CLOSE_IND | Indicates if to use this further in system or not |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | An oganization ID |
Student System - IGS_OR_UNIT_HIST_ALL | This entity describes the history of changes to an organizational unit. |
---|---|
Column Name | Descritpion |
ORG_UNIT_CD | The code for the organizational unit. An organizational unit is uniquely identified by the combination of its code and start date. An organizational unit is a business unit of an institution or organization. |
MEMBER_TYPE | The member type of the organizational unit during the creation of the history record. |
INSTITUTION_CD | The code for the institution the organizational unit was associated with during the creation of the history record. |
NAME | The description, or name of the institution the organizational unit was associated with. |
CREATED_BY | Standard Who column |
CREATION_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_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_ID | An organization ID |
HIST_START_DT | The effective start date and time of the organizational unit history record. It is the date and time the previous history record was ended. |
HIST_END_DT | The effective end date and time of the organizational unit history record. |
HIST_WHO | The Oracle username of the person who created the history record |
OU_END_DT | The end date value for the organizational unit during the creation of the history record. |
DESCRIPTION | Describes the organizational unit during the creation of the history record. |
ORG_STATUS | The status of the organizational unit during the creation of the history record. |
ORG_TYPE | The organizational type of the organizational unit during the creation of the history record. |
Student System - IGS_PE_ABORG_TORESCD | This entity describes the available user-defined list of aboriginal and torres strait islander codes. |
---|---|
Column Name | Descritpion |
ABORIG_TORRES_CD | Describes the available list of user-defined aboriginal and Torres Strait Islander codes. DETYA element reference 316. |
GOVT_ABORIG_TORRES_CD | Describes whether or not the student identifies herself or himself as being of Australian Aboriginal or Torres Strait Islander descent DETYA element 316. For example- 1 - Aboriginal or Torres Strait Islander descent, 2 - Not Aboriginal or |
NOTES | A text-based facility for recording and maintaining notes of up to 2,000 characters. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
DESCRIPTION | Provides an explanation of the aboriginal and Torres Strait Islander Code |
LAST_UPDATE_LOGIN | Standard Who column |
CLOSED_IND | Indicates whether a user-defined aboriginal and Torres Strait Islander code is available for use. Setting the indicator means that the aboriginal and Torres Strait Islander code is no longer available to be selected. |
Student System - IGS_HE_CODE_ASSOC | Holds all the Association Codes defined for use in the HESA system |
---|---|
Column Name | Descritpion |
ASSOCIATION_CODE | Holds the Association Code name defined in the HESA system |
DESCRIPTION | Contains the Description of each defined Association Code |
DISPLAY_TITLE | Contains the short Display Title for each Association 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_HE_CODE_ASS_VAL | Holds Code Association Values for all the associated HESA Association Codes |
---|---|
Column Name | Descritpion |
ASSOCIATION_CODE | Holds the Association Code name defined in the HESA system |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
SEQUENCE | Defines the sequence in which Association code is defined |
ASSOCIATION_TYPE | Defines the Association Type like whether the association is direct / indirect with the Oracle Student System |
MAIN_SOURCE | Contains the source table name or the code name depending on the Association Code type |
SECONDARY_SOURCE | Holds the database table column, if the main source contains database table |
CONDITION | Determines the extra condition to obtain correct values from the database table and column |
DISPLAY_TITLE | Contains the short title used for Association Code |
SYSTEM_DEFINED | Indicates whether this association is a seeded one or user defined |
CREATED_BY | Standard WHO Column |
Student System - IGS_HE_CODE_TYPES | Determines all the Code Types defined for use in the HESA system |
---|---|
Column Name | Descritpion |
CODE_TYPE | Contains the Code Names defined in the HESA system |
DISPLAY_TITLE | Describes the Code Title for the given Code Type |
DESCRIPTION | Holds the Code Description for the given Code 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_HE_EXT_RUN_DTLS | Contains all the Extract Run Details for each run of the Extract process |
---|---|
Column Name | Descritpion |
EXTRACT_RUN_ID | Sequence generated column used to uniquely identify the extract run details |
EXTRACT_RUN_DATE | Determines the Extract process execution date |
FILE_NAME | Determines the Data File Name |
FILE_LOCATION | Contains the location where data file can be found |
DATE_FILE_SENT | Indicates the date on which data file was sent |
EXTRACT_OVERRIDE | Flag to indicate whether the Extract data has been manually overwritten. |
VALIDATION_KIT_RESULT | Manually entered field to indicate the Validation Kit Result |
HESA_VALIDATION_RESULT | Manually entered field to indicate the HESA Validation Result |
CREATED_BY | Standard WHO Column |
SUBMISSION_NAME | Holds the Submission Name for the Extract process |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
USER_RETURN_SUBCLASS | User Defined Return Name |
RETURN_NAME | Holds the Return Name of the Extract process |
EXTRACT_PHASE | Indicates whether the Extract Phase is Internal or External |
STUDENT_EXT_RUN_ID | This contains the Extract run id for the student return. |
CONC_REQUEST_ID | Holds Run Concurrent Request Id |
CONC_REQUEST_STATUS | Holds the Run Concurrent Request Status.Could be NEW, UPDATED, RUNNING, ERRORED, COMPLETED |
Student System - IGS_HE_EX_RN_DAT_FD | Determines the field level details of each extract line comes from the Extract run process |
---|---|
Column Name | Descritpion |
RN_DAT_FD_ID | Sequence generated column used to uniquely identify the Extract run data fields |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
EXTRACT_RUN_ID | Sequence generated column used to uniquely identify the extract process |
LINE_NUMBER | Indicates the Line Number after the extraction process |
FIELD_NUMBER | Indicates the Field Number after extraction process |
VALUE | Holds the Value of the extracted field |
OVERRIDE_VALUE | Contains the overridden value, if the value is overridden after extraction process is complete |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
Student System - IGS_HE_EXT_RUN_EXCP | HESA Extract Run Exceptions Table. Will hold errors encountered during extract run |
---|---|
Column Name | Descritpion |
EXT_EXCEPTION_ID | Sequence generated identifier for each record. Based on Oracle Sequence IGS_HE_EXT_RUN_EXCEPT_S |
FIELD_NUMBER | Field number of the HESA extract run identifier |
EXCEPTION_REASON | Exception message |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
EXTRACT_RUN_ID | Run Identifier of the submission extract process |
PERSON_ID | Person Identifier |
PERSON_NUMBER | Person Number |
COURSE_CD | Program Code |
CRV_VERSION_NUMBER | Program Version Number |
UNIT_CD | Unit Code |
UV_VERSION_NUMBER | Unit Version Number |
LINE_NUMBER | Line number of the HESA extract run identifier |
Student System - IGS_HE_FTE_PROPRT | To hold FTE calendar proportions. |
---|---|
Column Name | Descritpion |
CI_SEQUENCE_NUMBER | Academic calendar type sequence number |
YEAR_OF_PROGRAM | Year of program for which FTE is to be calculated. |
FTE_CAL_TYPE | Academic calendar for which FTE is to be calculated. |
FTE_SEQUENCE_NUM | Academic calendar sequence number for which FTE is to be calculated. |
FTE_PERC | Percentage contribution of academic calendar to FTE calculation. |
CLOSED_IND | Closed indicator |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
CAL_TYPE | Academic calendar type contained within FTE calculation period. |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Student System - IGS_HE_FTE_CAL_PRD | To store FTE calculation setup data. |
---|---|
Column Name | Descritpion |
FTE_SEQUENCE_NUM | Academic calendar sequence number for which FTE is to be calculated. |
TEACH_CAL_TYPE | Default teaching calendar associated with the FTE calculation period. |
TEACH_SEQUENCE_NUM | Sequence number of default teaching calendar associated with FTE calculation period. |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
FTE_CAL_TYPE | Academic calendar period for which FTE is to be calculated. |
Student System - IGS_HE_EXT_RUN_INTERIM | HESA Extract Run Interim Table. Will store records temporarily whilst they are getting processed by the Generate Extract Process |
---|---|
Column Name | Descritpion |
EXT_INTERIM_ID | Based on Oracle Sequence IGS_HE_EXT_RUN_INTERIM_S |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
LINE_NUMBER | Line Number |
EXTRACT_RUN_ID | Extract Run Id |
PERSON_ID | Person Identifier |
COURSE_CD | Program Code |
CRV_VERSION_NUMBER | Version Number |
UNIT_CD | Unit Code |
UV_VERSION_NUMBER | Unit Version |
STUDENT_INST_NUMBER | Student Instance Number |
CREATED_BY | Standard WHO Column |
Student System - IGS_HE_ST_UNT_VS_ALL | stores HESA information on Units. |
---|---|
Column Name | Descritpion |
HESA_ST_UNT_VS_ID | Unique identifier. From Sequence IGS_HE_ST_UNT_VS_ALL_S |
CREATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
EXCLUDE_FLAG | Flag to identify record for exclusion from HESA extract |
ORG_ID | Organization Id |
UNIT_CD | Unit Code |
VERSION_NUMBER | Unit Version |
PROP_OF_TEACHING_IN_WELSH | Proportion of teaching in Welsh |
CREDIT_TRANSFER_SCHEME | Credit Transfer Scheme |
MODULE_LENGTH | Module Length |
PROPORTION_OF_FTE | Proportion of FTE |
LOCATION_CD | Location code |
CREATION_DATE | Standard WHO Column |
Student System - IGS_HE_ST_SPA_UT_ALL | This table stores UCAS tariff information for a student program attempt |
---|---|
Column Name | Descritpion |
HESA_ST_SPAU_ID | Unique identifier. From Sequence IGS_HE_ST_SPA_UT_ALL _S |
CREATION_DATE | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
ORG_ID | Organization Id |
PERSON_ID | Person Identifier |
COURSE_CD | Program Code |
VERSION_NUMBER | Version Number |
QUALIFICATION_LEVEL | Qualification Level |
NUMBER_OF_QUAL | Number of Qualifications |
TARIFF_SCORE | Tariff Score |
CREATED_BY | Standard WHO Column |
Student System - IGS_HE_ST_PROG_ALL | Stores the Program Version HESA details |
---|---|
Column Name | Descritpion |
HESA_ST_PROG_ID | Sequence generated identifier for each record |
TEACHING_QUAL_SOUGHT_SUBJ2 | Teaching qualification sought for subject |
TEACHING_QUAL_SOUGHT_SUBJ3 | Teaching qualification sought for subject |
LOCATION_OF_STUDY | Location of study |
OTHER_INST_PROV_TEACHING1 | Other institution teaching this unit |
OTHER_INST_PROV_TEACHING2 | Other institution teaching this unit |
PROP_TEACHING_IN_WELSH | Proportion taught in Welsh |
PROP_NOT_TAUGHT | Proportion of unit not Taught at this institution |
CREDIT_TRANSFER_SCHEME | Credit Transfer Scheme |
RETURN_TYPE | Return type of the submission |
DEFAULT_AWARD | Award Code |
PROGRAM_CALC | Indicator of whether calculation should be at Program level or at Unit level |
ORG_ID | Org Identifier |
LEVEL_APPLICABLE_TO_FUNDING | Level of Funding |
FRANCHISING_ACTIVITY | Franchising Activity |
NHS_FUNDING_SOURCE | Funding Source code |
FE_PROGRAM_MARKER | Fresh Entrant Program Marker, code which identifies if this program is an FE program or not |
FEE_BAND | Fee Band |
FUNDABILITY | Fundability Code |
FTE_INTENSITY | Full Time Equivalent Intensity |
TEACH_PERIOD_START_DT | Teaching Period start date |
TEACH_PERIOD_END_DT | Teaching Period end date |
CREATION_DATE | Standard WHO Column |
CREATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
COURSE_CD | Program Code |
LAST_UPDATE_LOGIN | Standard WHO Column |
IMPLIED_FUND_RATE | Implied rate of Council partial funding |
GOV_INITIATIVES_CD | Government initiatives code |
UNITS_FOR_QUAL | Number of units to achieve full qualification |
DISADV_UPLIFT_ELIG_CD | Disadvantage uplift factor code |
FRANCH_PARTNER_CD | Franchise Partner code |
FRANCH_OUT_ARR_CD | Franchised out arrangements code |
EXCLUDE_FLAG | Flag to identify record for exclusion from HESA extract |
VERSION_NUMBER | Program Version Number |
TEACHER_TRAIN_PROG_ID | Teacher training program Identifier |
ITT_PHASE | ITT phase |
BILINGUAL_ITT_MARKER | Bilingual ITT marker |
TEACHING_QUAL_SOUGHT_SECTOR | Teaching qualification sought sector |
TEACHING_QUAL_SOUGHT_SUBJ1 | Teaching qualification sought for subject |
Student System - IGS_HE_POOUS_OU_ALL | stores HESA Org. Unit information for Program Offering Option Unit Sets |
---|---|
Column Name | Descritpion |
HESA_POOUS_OU_ID | Unique sequence identifier |
US_VERSION_NUMBER | Used to uniquely identify each version of a unit set. |
ORGANIZATION_UNIT | Organization Unit |
PROPORTION | Proportion |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
ORG_ID | Organization Id |
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. |
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. |
Student System - IGS_HE_POOUS_CC_ALL | Stores HESA Cost Center information for Program Offering Option Unit Sets |
---|---|
Column Name | Descritpion |
HESA_POOUS_CC_ID | Unique sequence identifier |
US_VERSION_NUMBER | Used to uniquely identify each version of a unit set. |
COST_CENTRE | Cost Center |
SUBJECT | Subject |
PROPORTION | Proportion |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
ORG_ID | Organization Id |
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. |
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. |
Student System - IGS_HE_POOUS_ALL | Program Offering Option Unit Set HESA Details |
---|---|
Column Name | Descritpion |
HESA_POOUS_ID | Unique sequence identifier (PK) |
LOCATION_OF_STUDY | Location of Study |
MODE_OF_STUDY | Mode of Study |
UFI_PLACE | UFI Place |
FRANCHISING_ACTIVITY | Franchising Activity |
TYPE_OF_YEAR | Type of Year of Program |
LENG_CURRENT_YEAR | Length of the Current Year of Program |
GRADING_SCHEMA_CD | Grading Schema |
GS_VERSION_NUMBER | Grading Schema Version Number |
CREDIT_VALUE_YOP1 | Credit Value for Year of Program field #1 |
LEVEL_CREDIT1 | Level of Credit field #1 |
ORG_ID | Organization Id |
CREDIT_VALUE_YOP2 | Credit Value for Year of Program field #2 |
LEVEL_CREDIT2 | Level of Credit field #2 |
FTE_INTENSITY | FTE Intensity |
FTE_CALC_TYPE | FTE Calculation Type flag.Can take values I and U. |
TEACH_PERIOD_START_DT | Teaching period start date |
TEACH_PERIOD_END_DT | Teaching period end date |
OTHER_INSTIT_TEACH1 | Other institutions providing teaching field #1 |
OTHER_INSTIT_TEACH2 | Other institutions providing teaching field #2 |
PROP_NOT_TAUGHT | Proportion not taught |
FUNDABILITY_CD | Fundability Code |
FEE_BAND | Fee Band |
LEVEL_APPLICABLE_TO_FUNDING | Level Applicable to Funding Council HESES |
FUNDING_SOURCE | Institution defined Funding Source |
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 |
CREDIT_VALUE_YOP3 | Credit value of year of programme 3 |
LEVEL_CREDIT3 | Level of credit 3 |
CREDIT_VALUE_YOP4 | Credit value of year of programme 4 |
LEVEL_CREDIT4 | Level of credit 4 |
CRV_VERSION_NUMBER | Version number of the program being offered. |
CAL_TYPE | Academic calendar type in that the program is offered. |
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. |
Student System - IGS_HE_EN_SUSA | This table stores HESA information acquired during enrolment of a student on to a program unit set attempt |
---|---|
Column Name | Descritpion |
HESA_EN_SUSA_ID | Sequence generated identifier for each record |
SLDD_DISCRETE_PROV | HESA related SLDD Discrete Provision |
STUDY_MODE | HESA Mode of Study |
STUDY_LOCATION | HESA Location of Study |
FTE_PERC_OVERRIDE | Full time equivalent study percentage override |
FRANCHISING_ACTIVITY | HESA Franchising Activity |
COMPLETION_STATUS | HESA Completion Status |
GOOD_STAND_MARKER | HESA Good Standing Marker |
COMPLETE_PYR_STUDY_CD | HESA Completion of Year of Program of Study |
CREDIT_VALUE_YOP1 | HESA Credit Value of Year of Program 1 |
PERSON_ID | Person Identifier |
CREDIT_VALUE_YOP2 | HESA Credit Value of Year of Program 2 |
CREDIT_LEVEL_ACHIEVED1 | HESA Level of Credit Points Obtained 1 |
CREDIT_LEVEL_ACHIEVED2 | HESA Level of Credit Points Obtained 2 |
CREDIT_PT_ACHIEVED1 | HESA Number of Credit Points Obtained 1 |
CREDIT_PT_ACHIEVED2 | HESA Number of Credit Points Obtained 2 |
CREDIT_LEVEL1 | HESA Level of Credit 1 |
CREDIT_LEVEL2 | HESA Level of Credit 2 |
GRAD_SCH_GRADE | Grade |
MARK | Mark obtained |
TEACHING_INST1 | HESA Code of Other Institutions providing Teaching 1 |
COURSE_CD | Program code |
TEACHING_INST2 | HESA Code of Other Institutions providing Teaching 2 |
PRO_NOT_TAUGHT | Proportion not taught by this institution |
FUNDABILITY_CODE | HESA related Fundability Code |
FEE_ELIGIBILITY | HESA related Fee Eligibility |
FEE_BAND | HESA related Fee Band |
NON_PAYMENT_REASON | HESA related reason for Partial or Full non-payment of tuition fees |
STUDENT_FEE | HESA related Student Fee |
FTE_INTENSITY | Full time equivalent study intensity |
CALCULATED_FTE | Calculated Full time equivalent study |
FTE_CALC_TYPE | Full time equivalent study calculation type flag.Can take values I,B and U |
CREATION_DATE | Standard WHO Column |
CREATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
UNIT_SET_CD | Unit Set Code |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
TYPE_OF_YEAR | The code that identifies the type of program year as applies to the student |
YEAR_STU | Year of student on this programme |
CREDIT_VALUE_YOP3 | Credit value of year of programme 3 |
CREDIT_LEVEL3 | Level of credit 3 |
CREDIT_VALUE_YOP4 | Credit value of year of programme 4 |
CREDIT_LEVEL4 | Level of credit 4 |
CREDIT_PT_ACHIEVED3 | Number of credit points obtained 3 |
CREDIT_PT_ACHIEVED4 | Number of credit points obtained 4 |
US_VERSION_NUMBER | Used to uniquely identify each version of a unit set |
CREDIT_LEVEL_ACHIEVED3 | Level of credit points obtained 3 |
CREDIT_LEVEL_ACHIEVED4 | Level of credit points obtained 4 |
ENH_FUND_ELIG_CD | Eligibility for enhanced funding code |
ADDITIONAL_SUP_COST | Additional support cost |
DISADV_UPLIFT_FACTOR | Disadvantage uplift factor |
SEQUENCE_NUMBER | Describes the Sequence Number for Student Unit Set Attempt |
NEW_HE_ENTRANT_CD | New higher education entrant code |
TERM_TIME_ACCOM | HESA related Term Time Accommodation |
DISABILITY_ALLOW | HESA related Disability Allowance |
ADDITIONAL_SUP_BAND | HESA related Additional Support Band |
Student System - IGS_HE_ST_UV_CC_ALL | HESA UK statistics unit cost center details |
---|---|
Column Name | Descritpion |
HESA_ST_UV_CC_ID | Sequence generated identifier for each record |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
ORG_ID | Org Identifier |
UNIT_CD | Unit Code |
VERSION_NUMBER | Unit Version Number |
COST_CENTRE | Cost Center Code |
SUBJECT | Subject Code |
PROPORTION | Proportion contributed by this cost center towards this unit |
CREATION_DATE | Standard WHO Column |
CREATED_BY | Standard WHO Column |
Student System - IGS_HE_ST_SPA_ALL | stores HESA information on a student program attempt |
---|---|
Column Name | Descritpion |
HESA_ST_SPA_ID | Unique identifier. From Sequence IGS_HE_ST_SPA_ALL _S |
HIGHEST_QUAL_ON_ENTRY | Highest Qualification on Entry |
DATE_QUAL_ON_ENTRY_CALC | Date Qualification on Entry was calculated. |
A_LEVEL_POINT_SCORE | A/AS Level Points Score |
HIGHERS_POINTS_SCORES | Highers Points Scores |
OCCUPATION_CODE | Occupation Code |
COMMENCEMENT_DT | Date of Commencement of Program |
SPECIAL_STUDENT | Special Student |
STUDENT_QUAL_AIM | General Qualification Aim of Student |
STUDENT_FE_QUAL_AIM | FE General Qualification Aim of Student |
TEACHER_TRAIN_PROG_ID | Teacher Training Program Identifier |
ORG_ID | Organization Id |
ITT_PHASE | ITT phase/scope |
BILINGUAL_ITT_MARKER | Bilingual ITT Marker |
TEACHING_QUAL_GAIN_SECTOR | Teaching Qualification Gained Sector |
TEACHING_QUAL_GAIN_SUBJ1 | Teaching Qualification Gained Subject 1 |
TEACHING_QUAL_GAIN_SUBJ2 | Teaching Qualification Gained Subject 2 |
TEACHING_QUAL_GAIN_SUBJ3 | Teaching Qualification Gained Subject 3 |
STUDENT_INST_NUMBER | Student instance number |
DESTINATION | Destination |
ITT_PROG_OUTCOME | Outcome of ITT Program |
HESA_RETURN_NAME | HESA Return Name |
PERSON_ID | Person Identifier |
HESA_RETURN_ID | HESA Return ID |
HESA_SUBMISSION_NAME | Submission |
ASSOCIATE_UCAS_NUMBER | Associate UCAS Number |
ASSOCIATE_SCOTT_CAND | Associate Scottish Candidate Number |
ASSOCIATE_TEACH_REF_NUM | Associate Teacher Reference Number |
ASSOCIATE_NHS_REG_NUM | Associate Nurse Reference Number |
NHS_FUNDING_SOURCE | NHS Funding Source |
UFI_PLACE | UFI Place |
POSTCODE | Postcode |
SOCIAL_CLASS_IND | Social Class Indicator |
COURSE_CD | Program Code |
OCCCODE | Occupation Code - Old Structure of Occupation Code used by HESA. Stored for reference purpose. |
TOTAL_UCAS_TARIFF | Total UCAS Tariff |
NHS_EMPLOYER | NHS Employer Code |
CREATION_DATE | Standard WHO Column |
CREATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
RETURN_TYPE | Reduced Return Type that this attempt should be included in |
CALCULATED_FTE | Calculated FTE |
QUAL_AIM_SUBJ1 | The Subject1 of qualification aim |
VERSION_NUMBER | Version Number |
QUAL_AIM_SUBJ2 | The Subject2 of qualification aim |
QUAL_AIM_SUBJ3 | The Subject3 of qualification aim |
QUAL_AIM_PROPORTION | The code which identifies whether the qualification aim is balance or a major or minor |
DEPENDANTS_CD | Dependants code |
IMPLIED_FUND_RATE | Implied rate of Council partial funding |
GOV_INITIATIVES_CD | Government initiatives code |
UNITS_FOR_QUAL | Number of units to achieve full qualification |
DISADV_UPLIFT_ELIG_CD | Disadvantage uplift factor code |
FRANCH_PARTNER_CD | Franchise Partner code |
UNITS_COMPLETED | Number of units completed |
FRANCH_OUT_ARR_CD | Franchised out arrangements code |
FE_STUDENT_MARKER | FE Student Marker |
EMPLOYER_ROLE_CD | Employer role code |
DISADV_UPLIFT_FACTOR | Disadvantage uplift factor |
ENH_FUND_ELIG_CD | Eligibility for enhanced funding code |
EXCLUDE_FLAG | Flag to identify record for exclusion from HESA extract |
DOMICILE_CD | Domicile |
INST_LAST_ATTENDED | School /FE/HE Inst. Last attended |
YEAR_LEFT_LAST_INST | Year Left Last Institute |
Student System - IGS_HE_AD_DTL_ALL | Stores the Student Admission Application HESA details |
---|---|
Column Name | Descritpion |
ORG_ID | Operating Unit Identifier |
SPECIAL_STUDENT_CD | Describes Special Student details for a particular program admission application instance |
CREATION_DATE | Standard WHO Column |
CREATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
HESA_AD_DTL_ID | Unique Record Identifier |
PERSON_ID | Person Identifier |
ADMISSION_APPL_NUMBER | Identifies uniquely an Admission Application for a Person |
NOMINATED_COURSE_CD | Describes the program code of the program offering instance to that the person is applying for admission. |
SEQUENCE_NUMBER | Describes the Unique Identifier of an Admission Program Application Instance. |
OCCUPATION_CD | Describes the Occupation Code for a student for a particular program admission application instance |
DOMICILE_CD | Describes the Domicile Code for a student for a particular program admission application instance |
SOCIAL_CLASS_CD | Describes the Social Class Code for a student for a particular program admission application instance |
Student System - IGS_HE_USR_RT_CL_FLD | Holds the fields that the user wants to include in the User Defined Return Class. The fields are normally a sub set of the fields defined for the System Return Class |
---|---|
Column Name | Descritpion |
USR_RT_CL_FLD_ID | Sequence generated column for uniquely identifying the return class fields. |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
USER_RETURN_SUBCLASS | Contains the User Defined Return Sub Class |
FIELD_NUMBER | Contains the user defined Field Number |
CONSTANT_VAL | A constant value for the field which is to be used irrespective of whether the field has an actual value in the database |
DEFAULT_VAL | Default Value assigned to a null field |
INCLUDE_FLAG | Indicator as to whether field should be included in returns. |
REPORT_NULL_FLAG | Identifies records that should be included in the exception report if it has a NULL value. |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
Student System - IGS_HE_USR_RTN_CLAS | Holds user defined return classes which can be considered as a sub class of the system return classes |
---|---|
Column Name | Descritpion |
USR_RTN_CLAS_ID | Sequence generated column for uniquely identifying the return classes |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
SYSTEM_RETURN_CLASS_TYPE | System Defined Return Class |
USER_RETURN_SUBCLASS | User Defined Return Sub Class |
DESCRIPTION | Description of the User defined return Sub Class |
RECORD_ID | Holds the Record ID for determining the record segments |
REC_ID_SEG1 | This will typically contain the Year identifier |
REC_ID_SEG2 | This is used to indicate sub sets of the main record |
REC_ID_SEG3 | This holds the identifier of the system return class - 11, 12 or 13 |
Student System - IGS_HE_SYS_RT_CL_FLD | Holds the fields defined for each of the system return type |
---|---|
Column Name | Descritpion |
SYSTEM_RETURN_CLASS_TYPE | System Return Class Type |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
FIELD_NUMBER | Contains the system return type Field Number |
FIELD_NAME | Contains the system return type Field Name |
FIELD_DESCRIPTION | Contains the system return type Field Description |
DATATYPE | Indicates the system return Field Data type |
LENGTH | Indicate the Field Length |
MANDATORY_FLAG | Indicates whether field is system mandatory |
CLOSED_FLAG | Indicates whether HESA field is used or not |
CREATED_BY | Standard Who Column |
Student System - IGS_HE_SYS_RTN_CLAS | Holds the predefined Return Classes - Student Return, Module Return, Combined Return |
---|---|
Column Name | Descritpion |
SYSTEM_RETURN_CLASS_TYPE | Indicates the system return class type |
SYSTEM_RETURN_CLASS_RECID | Indicates the system return class record id |
DESCRIPTION | Description of the System Return Class |
CREATED_BY | Standard Who 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_HE_SUB_RTN_CAL | Holds all the Calendars that the user wants to be taken into consideration for this Submission Return. |
---|---|
Column Name | Descritpion |
SUB_RTN_CAL_ID | Sequence generated column used to uniquely identify the submission return calendar |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
SUBMISSION_NAME | Contains the Submission Name |
USER_RETURN_SUBCLASS | Holds the User Defined Return Sub Class information |
RETURN_NAME | Contains the name of this return sub class |
CAL_TYPE | Academic Calendar Name |
CI_SEQUENCE_NUMBER | Calendar Instance Sequence Number |
FTE_PROG_PCNT | Holds the FTE Program percent value |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
Student System - IGS_HE_SUBMSN_RETURN | Holds all the returns that the user wants to define for a Submission. |
---|---|
Column Name | Descritpion |
SUB_RTN_ID | Sequence generated column used to uniquely identify the submission returns |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
SUBMISSION_NAME | Contains the Submission Name |
USER_RETURN_SUBCLASS | Holds the User Defined Return Sub Class information |
RETURN_NAME | Contains the name of this return sub class |
LRR_START_DATE | Holds the Late Return Period Start Date. This will be populated only if it is a Late Return |
LRR_END_DATE | Holds the Late Return Period End Date. This will be populated only if it is a Late Return |
RECORD_ID | Record Identifier. De-normalized value held here purely to facilitate query |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
Student System - IGS_HE_SUBMSN_HEADER | Holds the information about the Submission headers i.e. parameters that need to be applied across all the returns included in the Submission. |
---|---|
Column Name | Descritpion |
SUB_HDR_ID | Sequence generated column for uniquely identifying the submission headers |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
VALIDATION_COUNTRY | The code that identifies the validation country to be used when running the HESA validation kit |
SUBMISSION_NAME | Contains the Submission Name |
DESCRIPTION | Description of the Submission |
ENROLMENT_START_DATE | Indicates the start date of the Enrollment period for which this submission is being defined |
ENROLMENT_END_DATE | Indicates the end date of the Enrollment period for which this submission is being defined |
OFFSET_DAYS | Offset Days that need be applied to the filter |
APPLY_TO_ATMPT_ST_DT | Indicates whether offset days are to be applied to Program Attempt Start Date |
APPLY_TO_INST_ST_DT | Indicate whether offset days are to be applied to Calendar Instance Start Date |
COMPLETE_FLAG | Indicates whether the submission has been completed. A submission is marked as completed if it has been sent and verified by HESA successfully. |
Student System - IGS_HE_EX_RN_DAT_LN | Holds the line level information of the data extracted from the Extract process. Each line in the actual extract file will exist as a record in this table |
---|---|
Column Name | Descritpion |
RN_DAT_LN_ID | Sequence generated column used to uniquely identify the Extract run data line |
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 | Course Version Number |
STUDENT_INST_NUMBER | Student Instance Number |
UNIT_CD | Unit Code |
UV_VERSION_NUMBER | Unit Version Number |
RECALCULATE_FLAG | Recalculate Flag, Valid values 'Y', 'N' |
EXTRACT_RUN_ID | Sequence generated column used to uniquely identify the extract process |
RECORD_ID | Record Identifier used to indicate the sub-sets of the main record |
LINE_NUMBER | Indicates the Line Number of the extraction process data |
PERSON_ID | Contains the person id for which the extraction process was done and is used for updating the Student Program Attempt Records |
COURSE_CD | Indicates the Course code of the person for which this line is being generated and used to update the Student Program Attempt Records |
MANUALLY_INSERTED | Indicates whether the line has been manually inserted. Default value will be NO |
EXCLUDE_FROM_FILE | Indicates whether this line should be excluded from the physical file. Default value will be NO |
CREATED_BY | Standard WHO Column |
Student System - IGS_HE_EXT_RUN_PRMS | Holds the Extract Run Parameters details for each run while extracting data from the database |
---|---|
Column Name | Descritpion |
RUN_PRMS_ID | Sequence generated column used to uniquely identify the Extract run parameters |
LAST_UPDATE_LOGIN | Standard WHO Column |
EXTRACT_RUN_ID | Sequence generated column used to uniquely identify the extract run parameters |
PARAM_TYPE | Indicates the type of Parameter whose data we are trying to restrict |
EXCLUDE | Contains the value need to be excluded depending on the Parameter Type defined |
ONLY | Indicates the field for which the data will be extracted depending on the parameter type |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
Student System - IGS_HE_CODE_VALUES | Holds the Code Values for each defined HESA Code type in the system |
---|---|
Column Name | Descritpion |
CODE_TYPE | Contains the Code Names defined in the HESA system |
VALUE | Holds the Code Value for the given Code Type |
VALUE_DESCRIPTION | Holds the value description |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
CLOSED_IND | Indicates whether the HESA code value is closed or not . Takes Y - Yes and N - No |
Student System - IGS_HE_CODE_MAP_VAL | Holds the Oracle Student System mapping values for the corresponding associated HESA Association Codes |
---|---|
Column Name | Descritpion |
ASSOCIATION_CODE | Holds the Association Code name defined in the HESA system |
MAP7 | Contains the mapping of Association 7 |
MAP8 | Contains the mapping of Association 8 |
MAP9 | Contains the mapping of Association 9 |
MAP10 | Contains the mapping of Association 10 |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
SEQUENCE | Defines the sequence in which Association code is defined |
MAP_DESCRIPTION | Holds the Mapping Description for all the mapping columns |
MAP1 | Contains the mapping of Association 1 |
MAP2 | Contains the mapping of Association 2 |
MAP3 | Contains the mapping of Association 3 |
MAP4 | Contains the mapping of Association 4 |
MAP5 | Contains the mapping of Association 5 |
MAP6 | Contains the mapping of Association 6 |
Student System - IGS_OR_INST_STAT_DTL | Describes Institution Statistic Detail Records Details. |
---|---|
Column Name | Descritpion |
INST_STAT_DTL_ID | Institution Statistics Detail Identifier. Primary Key column for this table |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
INST_STAT_ID | Institution Statistics Identifier |
YEAR | Statistic Year |
VALUE | Statistic 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_OR_INST_STAT_INT | Describes Interface Institution Statistic Master Details. |
---|---|
Column Name | Descritpion |
INTERFACE_INST_STAT_ID | Interface Institution Statistics Identifier. Primary key for this table |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
INTERFACE_ID | Interface Identifier |
STAT_TYPE_CD | Statistics Type Code |
STAT_TYPE_ID | Statistics Type |
STATUS | Status of the Record |
ERROR_CODE | Error Code for the Interface Record |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
Student System - IGS_OR_ADRUSGE_INT | Describes Interface Institution Address Usage Details. |
---|---|
Column Name | Descritpion |
INTERFACE_ADDRUSAGE_ID | Interface Address Usage Identifier. Logical Primary key for this table |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
INTERFACE_ADDR_ID | Interface Address Identifier |
SITE_USE_CODE | Site Usage Code |
COMMENTS | Comments for the Usage |
STATUS | Status of the Record. For E.g. '1'- Completed '2' - Pending '3' - Error |
ERROR_CODE | Error Code for the Interface Record |
ERROR_TEXT | Error Text for the Interface Record while creating/updating the record. |
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_OR_ADR_INT | Describes Interface Institution Address Details |
---|---|
Column Name | Descritpion |
INTERFACE_ADDR_ID | Interface Address Identifier. Logical Primary Key for this table |
COUNTY | county |
PROVINCE | Province |
COUNTRY | Country |
OTHER_DETAILS | Other Details |
OTHER_DETAILS_1 | Other Details 1 |
OTHER_DETAILS_2 | Other Details 2 |
DELIVERY_POINT_CODE | Delivery Point Code |
OTHER_DETAILS_3 | Other Details 3 |
CORRESPONDENCE_FLAG | Correspondence Flag |
CONTACT_PERSON_ID | Contact Person Identifier |
INTERFACE_ID | Interface Identifier |
DATE_LAST_VERIFIED | Date Last Verified this address |
START_DATE | Start Date of the Address |
END_DATE | End Date of the Address |
STATUS | Status of the Record. For E.g. '1'- Completed '2' - Pending '3' - Error |
ERROR_CODE | Error Code for the Interface Record |
ERROR_TEXT | Error Text for the Interface Record while creating/updating the record. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
ADDR_LINE_1 | Address Line 1 |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
ADDR_LINE_2 | Address Line 2 |
ADDR_LINE_3 | Address Line 3 |
ADDR_LINE_4 | Address Line 4 |
POSTCODE | Post Code |
CITY | City |
STATE | State |
Student System - IGS_OR_CWLK | Describes OSS crosswalk Master details |
---|---|
Column Name | Descritpion |
CROSSWALK_ID | Cross Walk Identifier. Primary Key for this table. |
PROGRAM_APPLICATION_ID | Standard Who column for concurrent programs |
PROGRAM_ID | Standard Who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard Who column for concurrent programs |
INSTITUTION_CODE | Institution Code or Party Number |
INSTITUTION_NAME | Name of the Institution |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard Who column for concurrent programs |
Student System - IGS_OR_CWLK_DTL | Describes OSS institution crosswalk Detail Records details |
---|---|
Column Name | Descritpion |
CROSSWALK_DTL_ID | Crosswalk Detail Identifier. Primary key for this table. |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
CROSSWALK_ID | Crosswalk Identifier. Foreign Key to IGS_OR_CROSSWALK |
ALT_ID_TYPE | Alternate Identifier Type |
ALT_ID_VALUE | Alternate Identifier 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_OR_CWLK_DTL_INT | Describes Interface institution Crosswalk Detail Records details |
---|---|
Column Name | Descritpion |
INTERFACE_CROSSWALK_DTL_ID | Interface Crosswalk Detail Identifier. Logical Primary key for this table. |
REQUEST_ID | Standard Who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard Who column for concurrent programs |
PROGRAM_ID | Standard Who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard Who column for concurrent programs |
INTERFACE_CROSSWALK_ID | Interface Crosswalk Detail Identifier. Logical Foreign key reference from IGS_OR_CROSSWALK_INT |
ALT_ID_TYPE | Alternate Identifier Type |
ALT_ID_VALUE | Alternate Identifier 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_OR_CWLK_INT | Describes Interface institution Crosswalk Master Records details |
---|---|
Column Name | Descritpion |
INTERFACE_CROSSWALK_ID | Interface Crosswalk Identifier. Logical Primary key for this table |
PROGRAM_APPLICATION_ID | Standard Who column for concurrent programs |
PROGRAM_ID | Standard Who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard Who column for concurrent programs |
INSTITUTION_NAME | Name of the Institution |
STATUS | Status of the Record. '1' - Pending '2' - Completed '3' - Error |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard Who column for concurrent programs |
Student System - IGS_OR_INST_BTCH_INT | Describes Interface Institution Batch Description Details |
---|---|
Column Name | Descritpion |
BATCH_ID | Batch Identifier. Logical Primary Key for this table |
PROGRAM_ID | Standard Who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard Who column for concurrent programs |
BATCH_DESCRIPTION | Description for the Batch. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard Who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard Who column for concurrent programs |
Student System - IGS_OR_INST_CON_INT | Describes Interface Institution Contact Details |
---|---|
Column Name | Descritpion |
INTERFACE_CONTACTS_ID | Interface Institution Contacts Identifier. Unique Identifier for this Table |
ATTRIBUTE_CATEGORY | Descriptive flex field structure defining column |
ATTRIBUTE1 | Descriptive flex field segment column |
ATTRIBUTE2 | Descriptive flex field segment column |
ATTRIBUTE3 | Descriptive flex field segment column |
ATTRIBUTE4 | Descriptive flex field segment column |
ATTRIBUTE5 | Descriptive flex field segment column |
ATTRIBUTE6 | Descriptive flex field segment column |
ATTRIBUTE7 | Descriptive flex field segment column |
ATTRIBUTE8 | Descriptive flex field segment column |
ATTRIBUTE9 | Descriptive flex field segment column |
INTERFACE_ID | Interface Identifier |
ATTRIBUTE10 | Descriptive flex field segment column |
ATTRIBUTE11 | Descriptive flex field segment column |
ATTRIBUTE12 | Descriptive flex field segment column |
ATTRIBUTE13 | Descriptive flex field segment column |
ATTRIBUTE14 | Descriptive flex field segment column |
ATTRIBUTE15 | Descriptive flex field segment column |
ATTRIBUTE16 | Descriptive flex field segment column |
ATTRIBUTE17 | Descriptive flex field segment column |
ATTRIBUTE18 | Descriptive flex field segment column |
ATTRIBUTE19 | Descriptive flex field segment column |
CONTACT_PARTY_ID | Contact Party Identifier |
ATTRIBUTE20 | Descriptive flex field segment column |
ERROR_CODE | Error Code for the Interface Record |
ERROR_TEXT | Error Text for the Interface Record while creating/updating the record. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
TITLE | Title of the Party |
MAIL_STOP | Mail Stop for the Party |
REFERENCE | Reference to the Party |
Email Address | |
ACTIVE | Active Flag |
STATUS | Status of the Record |
Student System - IGS_OR_INST_CPHN_INT | Describes Interface Institution Contact Phone Details |
---|---|
Column Name | Descritpion |
INTERFACE_INST_CONT_PHONE_ID | Interface Institution Contact Phone Identifier. Unique Identifier for this Table |
ATTRIBUTE_CATEGORY | Descriptive flex field structure defining column |
ATTRIBUTE1 | Descriptive flex field segment column |
ATTRIBUTE2 | Descriptive flex field segment column |
ATTRIBUTE3 | Descriptive flex field segment column |
ATTRIBUTE4 | Descriptive flex field segment column |
ATTRIBUTE5 | Descriptive flex field segment column |
ATTRIBUTE6 | Descriptive flex field segment column |
ATTRIBUTE7 | Descriptive flex field segment column |
ATTRIBUTE8 | Descriptive flex field segment column |
ATTRIBUTE9 | Descriptive flex field segment column |
INTERFACE_CONT_ID | Interface Identifier |
ATTRIBUTE10 | Descriptive flex field segment column |
ATTRIBUTE11 | Descriptive flex field segment column |
ATTRIBUTE12 | Descriptive flex field segment column |
ATTRIBUTE13 | Descriptive flex field segment column |
ATTRIBUTE14 | Descriptive flex field segment column |
ATTRIBUTE15 | Descriptive flex field segment column |
ATTRIBUTE16 | Descriptive flex field segment column |
ATTRIBUTE17 | Descriptive flex field segment column |
ATTRIBUTE18 | Descriptive flex field segment column |
ATTRIBUTE19 | Descriptive flex field segment column |
COUNTRY_CODE | Country Code for the Phone Number |
ATTRIBUTE20 | Descriptive flex field segment column |
ERROR_CODE | Error Code for the Interface Record |
ERROR_TEXT | Error Text for the Interface Record while creating/updating the record. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
AREA_CODE | Area Code for the Phone Number |
PHONE_NUMBER | Phone Number |
EXTENSION | Extension for the Phone Number |
TYPE | Type of the Phone |
ACTIVE | Active Flag |
STATUS | Status of the Record |
Student System - IGS_OR_INST_INT | Describes Institution Interface Details. |
---|---|
Column Name | Descritpion |
INTERFACE_ID | Interface Identifier. Logical Primary Key for this table |
LOCAL_INSTITUTION_IND | Local Institution Indicator |
OS_IND | OS Indicator |
GOVT_INSTITUTION_CD | Government Institution Code |
INSTITUTION_TYPE | Type of the Institution |
INST_CONTROL_TYPE | Control type for the Institution |
PRIORITY_CODE_ID | Institution Priority Code Identifier |
INST_PRIORITY_CD | Institution Priority Code |
EPS_CODE | Market Code |
ADV_STUDIES_CLASSES | Number of Advanced Studies Classes Offered |
HONORS_CLASSES | Number of Honors Classes Offered |
CLASS_SIZE | Size of the Class |
BATCH_ID | Batch Identifier |
SEC_SCHOOL_LOCATION_ID | Secondary School Location Identifier |
PERCENT_PLAN_HIGHER_EDU | Planning to Pursue Higher Education Percentage |
PHONE_COUNTRY | Phone Country Code |
PHONE_AREA | Phone Area Code |
PHONE_NUMBER | Phone Number |
ACCOUNT_NUMBER | Obsolete this Column- Account Number |
DATA_SOURCE_ID | Data Source Identifier |
DATA_SOURCE_VALUE | Data Source Value |
ATTRIBUTE_CATEGORY | Descriptive flex field structure defining column |
ATTRIBUTE1 | Descriptive flex field segment column |
ATTRIBUTE2 | Descriptive flex field segment column |
ATTRIBUTE3 | Descriptive flex field segment column |
ATTRIBUTE4 | Descriptive flex field segment column |
STATUS | Status of the Record. For E.g. '1'- Completed '2' - Pending '3' - Error |
ATTRIBUTE5 | Descriptive flex field segment column |
ATTRIBUTE6 | Descriptive flex field segment column |
ATTRIBUTE7 | Descriptive flex field segment column |
ATTRIBUTE8 | Descriptive flex field segment column |
ATTRIBUTE9 | Descriptive flex field segment column |
ATTRIBUTE10 | Descriptive flex field segment column |
ATTRIBUTE11 | Descriptive flex field segment column |
ATTRIBUTE12 | Descriptive flex field segment column |
ATTRIBUTE13 | Descriptive flex field segment column |
ATTRIBUTE14 | Descriptive flex field segment column |
NEW_INSTITUTION_CD | New Institution Code |
ATTRIBUTE15 | Descriptive flex field segment column |
ATTRIBUTE16 | Descriptive flex field segment column |
ATTRIBUTE17 | Descriptive flex field segment column |
ATTRIBUTE18 | Descriptive flex field segment column |
ATTRIBUTE19 | Descriptive flex field segment column |
ATTRIBUTE20 | Descriptive flex field segment column |
ERROR_CODE | Error Code for the Interface Record |
ERROR_TEXT | Error Text for the Interface Record while creating/updating the record. |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
EXST_INSTITUTION_CD | Existing Institution Code for Match |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
ATTRIBUTE21 | Descriptive flex field segment column |
ATTRIBUTE22 | Descriptive flex field segment column |
ATTRIBUTE23 | Descriptive flex field segment column |
ATTRIBUTE24 | Descriptive flex field segment column |
NAME | Name of the Institution |
ALT_ID_TYPE | Alternate Identifier Type |
ALT_ID_VALUE | Alternate Identifier Value |
INSTITUTION_STATUS | Status of the Institution |
Student System - IGS_OR_INST_NTS_INT | Describes Interface Institution Notes Details |
---|---|
Column Name | Descritpion |
INTERFACE_INST_NOTES_ID | Interface Institution Notes Identifier. Unique Identifier for this Table |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
INTERFACE_ID | Interface Identifier |
ORG_NOTE_SEQUENCE | Institution Note Sequence |
ORG_NOTE_TYPE | Institution Note Type |
START_DATE | Start Date |
END_DATE | End Date |
NOTE_TEXT | Notes |
STATUS | Status of the Record |
ERROR_CODE | Error Code for the Interface Record |
CREATED_BY | Standard Who column |
Student System - IGS_OR_INST_SDTL_INT | Describes Interface Institution Statistic Detail Records Details. |
---|---|
Column Name | Descritpion |
INTERFACE_INST_STAT_DTL_ID | Interface Institution Statistics Detail Identifier. Primary key for this table |
LAST_UPDATE_LOGIN | Standard Who column |
REQUEST_ID | Standard who column for concurrent programs |
PROGRAM_APPLICATION_ID | Standard who column for concurrent programs |
PROGRAM_ID | Standard who column for concurrent programs |
PROGRAM_UPDATE_DATE | Standard who column for concurrent programs |
INTERFACE_INST_STAT_ID | Interface Institution Statistic Identifier |
YEAR | Statistics Year |
VALUE | Statistics Value |
STATUS | Status of the Record |
ERROR_CODE | Error Code for the Interface Record |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
LAST_UPDATE_DATE | Standard Who column |
Student System - IGS_OR_UNIT_ACCTS_ALL | This table captures the entities and their respective orders in the account hierarchy defined in the table |
---|---|
Column Name | Descritpion |
ORG_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 |
ORG_UNIT_CD | Organization Unit code |
START_DT | Organization Unit code start date |
SEGMENT | GL segment name in the accounting flex field structure |
SEGMENT_NUM | GL segment number in the accounting flex field structure |
SEGMENT_VALUE | GL segment value in the accounting flex field structure |
ORG_ID | Multi org unit operating ID |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
Student System - IGS_OR_UNIT_ACCT_CD_ALL | This table contains revenue account string information for an organization unit |
---|---|
Column Name | Descritpion |
ORG_ACCOUNT_CD_ID | Sequence generated primary key column |
LAST_UPDATE_LOGIN | Standard Who column |
ORG_UNIT_CD | Organization unit code |
START_DT | Organization Unit code start date |
REV_ACCOUNT_CD | Revenue account code |
ORG_ID | Multi org unit operating ID |
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_OR_INST_STATS | Describes Institution Statistic Details |
---|---|
Column Name | Descritpion |
INST_STAT_ID | Unique Identifier of Institution Statistics |
PROGRAM_APPLICATION_ID | Standard WHO Column for Concurrent programs |
PROGRAM_ID | Standard WHO Column for Concurrent programs |
PROGRAM_UPDATE_DATE | Standard WHO Column for Concurrent programs |
STAT_TYPE_ID | Obsolete |
PARTY_ID | Institution Identifier or Party Identifier |
CREATED_BY | Standard WHO Column |
STAT_TYPE_CD | Statistics Type Code |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
REQUEST_ID | Standard WHO Column for Concurrent programs |
Student System - IGS_GE_CFG_FORM | This table is used for the storing of form configuration detail records. |
---|---|
Column Name | Descritpion |
RESPONSIBILITY_ID | FND Application Responsibility Identifier |
FORM_CODE | Form code that is being configured. |
QUERY_ONLY_IND | Indicator to determine if the form is query only or not |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
Student System - IGS_GE_CFG_NAV | Table storing the form navigation configurations. |
---|---|
Column Name | Descritpion |
RESPONSIBILITY_ID | FND Application responsibility identifier |
LAST_UPDATE_LOGIN | Standard who column |
FORM_CODE | Form code being configured. |
SEQ_NUMBER | Sequence number of configured item |
SUBFORM_CODE | Subform code that is being configured. |
BUT_LABEL | Button label code on the form being configured. |
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_GE_CFG_TAB | Table storing the form tab configuration details. |
---|---|
Column Name | Descritpion |
RESPONSIBILITY_ID | FND Application responsibility identifier. |
FORM_CODE | Form code value that is being configured. |
TAB_CODE | Form tab code that is being configured. |
CONFIG_OPT | Configuration option chosen for the tab on form. |
CREATED_BY | Standard who 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_GR_LGCY_GRD_INT | Interface table to store Graduation Legacy data |
---|---|
Column Name | Descritpion |
LEGACY_GR_INT_ID | Uniquely identify each record in the interface table. |
HONOURS_LEVEL | Honours level granted to the graduand. --Obsolete |
CONFERRAL_DT | Date when the award was conferred. --Obsolete |
GRADUAND_STATUS | Current progress status of the graduand |
GRADUAND_APPR_STATUS | Status of the graduands approval to graduate. |
S_GRADUAND_TYPE | Type assigned to the graduand that defines the graduation intentions. |
GRADUATION_NAME | Graduands name, as appearing on the testamur or certificate. |
PROXY_AWARD_PERSON_NUMBER | Person number of the person acting as the proxy. |
PREVIOUS_QUALIFICATIONS | Previous qualifications obtained by the graduand. |
CONVOCATION_MEMBERSHIP_IND | Specifies the graduands desire for convocation membership. |
SUR_FOR_PROGRAM_CD | Code of the program for which the graduand is surrendering a received award, or for which an articulating graduand is declining an eligible award. |
BATCH_ID | Batch identifier |
SUR_FOR_PROG_VERSION_NUMBER | Version of the program for which the graduand is surrendering a received award, or for which an articulating graduand is declining an eligible award. |
SUR_FOR_AWARD_CD | Award for which the graduand is surrendering a received award, or that an articulating graduand is declining an eligible award. |
COMMENTS | A text field for entering any additional detail about the graduand. |
ATTRIBUTE_CATEGORY | Standard Descriptive Flexfield Column |
ATTRIBUTE1 | Standard Descriptive Flexfield Column |
ATTRIBUTE2 | Standard Descriptive Flexfield Column |
ATTRIBUTE3 | Standard Descriptive Flexfield Column |
ATTRIBUTE4 | Standard Descriptive Flexfield Column |
ATTRIBUTE5 | Standard Descriptive Flexfield Column |
ATTRIBUTE6 | Standard Descriptive Flexfield Column |
PERSON_NUMBER | The person number of the graduand |
ATTRIBUTE7 | Standard Descriptive Flexfield Column |
ATTRIBUTE8 | Standard Descriptive Flexfield Column |
ATTRIBUTE9 | Standard Descriptive Flexfield Column |
ATTRIBUTE10 | Standard Descriptive Flexfield Column |
ATTRIBUTE11 | Standard Descriptive Flexfield Column |
ATTRIBUTE12 | Standard Descriptive Flexfield Column |
ATTRIBUTE13 | Standard Descriptive Flexfield Column |
ATTRIBUTE14 | Standard Descriptive Flexfield Column |
ATTRIBUTE15 | Standard Descriptive Flexfield Column |
ATTRIBUTE16 | Standard Descriptive Flexfield Column |
CREATE_DT | Date and time the graduand record was created. |
ATTRIBUTE17 | Standard Descriptive Flexfield Column |
ATTRIBUTE18 | Standard Descriptive Flexfield Column |
ATTRIBUTE19 | Standard Descriptive Flexfield Column |
ATTRIBUTE20 | Standard Descriptive Flexfield Column |
IMPORT_STATUS | Record Import Status, Allowable values are U - Unprocessed (Default) R - Ready For Re-Processing E - Error W - Warning I - Imported |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
GRD_CAL_ALT_CODE | Graduation calendar alternate code type of the ceremony round the graduand is associated. |
REQUEST_ID | Standard concurrent program who column |
PROGRAM_ID | Standard concurrent program who column |
PROGRAM_APPLICATION_ID | Standard concurrent program who column |
PROGRAM_UPDATE_DATE | Standard concurrent program who column |
PROGRAM_CD | Graduands program attempt code. |
AWARD_PROGRAM_CD | Program code associated with the graduands award. |
AWARD_PROG_VERSION_NUMBER | Program code associated with the graduands award. |
AWARD_CD | Code for the award the graduand is receiving |
Student System - IGS_HE_BATCH_INT | Stores the batch definitions for the HESA import student details process |
---|---|
Column Name | Descritpion |
DESCRIPTION | Batch description |
BATCH_ID | Batch Identifier which is a sequence generated number |
Student System - IGS_HE_LGCY_SPA_INT | Interface table for HESA Student program attempt statistics. |
---|---|
Column Name | Descritpion |
BATCH_ID | Batch Identifier, used to identify the set of records to be processed. |
SPECIAL_STUDENT | Special Student |
STUDENT_QUAL_AIM | Student qualification aim |
STUDENT_FE_QUAL_AIM | Student Further Education qualification aim |
TEACHER_TRAIN_PROG_ID | Teacher Training Program ID |
ITT_PHASE | Initial teacher training Phase |
BILINGUAL_ITT_MARKER | Bilingual Initial teacher training Marker |
TEACHING_QUAL_GAIN_SECTOR | Teaching Qualification Gain Sector |
TEACHING_QUAL_GAIN_SUBJ1 | Teaching Qualification Gain Subject 1 |
TEACHING_QUAL_GAIN_SUBJ2 | Teaching Qualification Gain Subject 2 |
TEACHING_QUAL_GAIN_SUBJ3 | Teaching Qualification Gain Subject 3 |
LEGACY_HESA_SPA_INT_ID | Unique identifier of the HESA Student program attempt statistics record. |
STUDENT_INST_NUMBER | Student Instance Number |
DESTINATION | Destination |
ITT_PROG_OUTCOME | Initial teacher training Program Outcome |
ASSOCIATE_UCAS_NUMBER | Associate UCAS number |
ASSOCIATE_SCOTT_CAND | Associate Scottish Candidate |
ASSOCIATE_TEACH_REF_NUM | Associate Teaching reference number |
ASSOCIATE_NHS_REG_NUM | Associate National Health Service registration number |
NHS_FUNDING_SOURCE | National Health Service Funding Source |
UFI_PLACE | University for Industry Place |
POSTCODE | Post code |
PERSON_NUMBER | Person Number |
SOCIAL_CLASS_IND | Social Class Indicator |
OCCCODE | Pre-2000 Parental Occupation |
NHS_EMPLOYER | National Health Service Employer |
RETURN_TYPE | Return type |
SUBJ_QUALAIM1 | Subject Qualification Aim 1 |
SUBJ_QUALAIM2 | Subject Qualification Aim 2 |
SUBJ_QUALAIM3 | Subject Qualification Aim 3 |
QUALAIM_PROPORTION | Qualification Aim Proportion |
IMPORT_STATUS | Record's Import status, allowable values are 'U' - Unprocessed (Default),'R' - Ready for Reprocessing,'E' - Error,'W' - Warning and 'I' - Imported |
CREATED_BY | Standard who column |
PROGRAM_CD | Program Code |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
REQUEST_ID | Standard concurrent program who column |
PROGRAM_ID | Standard concurrent program who column |
PROGRAM_APPLICATION_ID | Standard concurrent program who column |
PROGRAM_UPDATE_DATE | Standard concurrent program who column |
DEPENDANTS_CD | Dependants code |
IMPLIED_FUND_RATE | Implied rate of Council partial funding |
FE_STUDENT_MARKER | Further Education Student Marker |
GOV_INITIATIVES_CD | Government initiatives code |
UNITS_FOR_QUAL | Number of units to achieve full qualification |
DISADV_UPLIFT_ELIG_CD | Disadvantage uplift factor code |
FRANCH_PARTNER_CD | Franchise Partner code |
UNITS_COMPLETED | Number of units completed |
FRANCH_OUT_ARR_CD | Franchised out arrangements code |
EMPLOYER_ROLE_CD | Employer role code |
DISADV_UPLIFT_FACTOR | Disadvantage uplift factor |
ENH_FUND_ELIG_CD | Eligibility for enhanced funding code |
DOMICILE_CD | Domicile code |
HIGHEST_QUAL_ON_ENTRY | Highest qualification on entry |
OCCUPATION_CODE | Parental Occupation |
COMMENCEMENT_DT | Commencement date |
Student System - IGS_HE_LGY_SUSA_INT | Interface table for HESA Student Unit Set Details. |
---|---|
Column Name | Descritpion |
BATCH_ID | Batch Identifier, used to identify the set of records to be processed. |
SLDD_DISCRETE_PROV | SLDD Discrete Provision |
STUDY_MODE | Study Mode |
STUDY_LOCATION | Study Location |
FTE_PERC_OVERRIDE | FTE Percentage Override |
FRANCHISING_ACTIVITY | Franchising Activity |
COMPLETION_STATUS | Completion Status |
GOOD_STAND_MARKER | Good Standing Marker |
COMPLETE_PYR_STUDY_CD | Complete Program year Study Code |
CREDIT_VALUE_YOP1 | Credit Value YOP 1 |
CREDIT_VALUE_YOP2 | Credit Value YOP 2 |
LEGACY_HESA_SUSA_INT_ID | Unique identifier of the HESA Student Unit set details record. |
CREDIT_LEVEL_ACHIEVED1 | Credit Level Achieved 1 |
CREDIT_LEVEL_ACHIEVED2 | Credit Level Achieved 2 |
CREDIT_PT_ACHIEVED1 | Credit Point Achieved 1 |
CREDIT_PT_ACHIEVED2 | Credit Point Achieved 2 |
CREDIT_LEVEL1 | Credit Level 1 |
CREDIT_LEVEL2 | Credit Level 2 |
GRAD_SCH_GRADE | Grading Schema Grade |
MARK | Marks |
TEACHING_INST1 | Teaching Institution 1 |
TEACHING_INST2 | Teaching Institution 2 |
PERSON_NUMBER | Person Number |
PRO_NOT_TAUGHT | Proportion not taught |
FUNDABILITY_CODE | Fundability Code |
FEE_ELIGIBILITY | Fee Eligibility |
FEE_BAND | Fee Band |
NON_PAYMENT_REASON | Non Payment Reason |
STUDENT_FEE | Student Fee |
FTE_INTENSITY | FTE Intensity |
CALCULATED_FTE | Calculated FTE |
FTE_CALC_TYPE | FTE Calculation Type |
TYPE_OF_YEAR | Type of Program Year |
PROGRAM_CD | Program Code |
IMPORT_STATUS | Record's Import status, allowable values are 'U' - Unprocessed (Default),'R' - Ready for Reprocessing,'E' - Error,'W' - Warning and 'I' - Imported |
CREATED_BY | Standard who column |
CREATION_DATE | Standard who column |
LAST_UPDATED_BY | Standard who column |
LAST_UPDATE_DATE | Standard who column |
LAST_UPDATE_LOGIN | Standard who column |
REQUEST_ID | Standard concurrent program who column |
PROGRAM_ID | Standard concurrent program who column |
PROGRAM_APPLICATION_ID | Standard concurrent program who column |
PROGRAM_UPDATE_DATE | Standard concurrent program who column |
UNIT_SET_CD | Unit Set Code |
YEAR_STU | Year of student on this programme |
CREDIT_VALUE_YOP3 | Credit value of year of programme 3 |
CREDIT_LEVEL3 | Level of credit 3 |
CREDIT_VALUE_YOP4 | Credit value of year of programme 4 |
CREDIT_LEVEL4 | Level of credit 4 |
CREDIT_PT_ACHIEVED3 | Number of credit points obtained 3 |
CREDIT_PT_ACHIEVED4 | Number of credit points obtained 4 |
CREDIT_LEVEL_ACHIEVED3 | Level of credit points obtained 3 |
CREDIT_LEVEL_ACHIEVED4 | Level of credit points obtained 4 |
ENH_FUND_ELIG_CD | Eligibility for enhanced funding code |
NEW_HE_ENTRANT_CD | New HE Entrant code |
ADDITIONAL_SUP_COST | Additional support cost |
DISADV_UPLIFT_FACTOR | Disadvantage uplift factor |
TERM_TIME_ACCOM | Term Time Accommodation |
DISABILITY_ALLOW | Disability Allowance |
ADDITIONAL_SUP_BAND | Additional Support Band |
Student System - IGS_HE_UCAS_IMP_ERR | Stores the errors encountered during import of HESA student details to OSS |
---|---|
Column Name | Descritpion |
BATCH_ID | Batch Identifier |
INTERFACE_HESA_ID | Interface record identifier |
ERROR_CODE | Error code |
ERROR_TEXT | Error text |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
ERROR_INTERFACE_ID | Sequence generated number used to uniquely identify a record |
LAST_UPDATE_LOGIN | Standard WHO column |
Student System - IGS_HE_UCAS_IMP_INT | Interface table to store the HESA student details from UCAS and other legacy systems |
---|---|
Column Name | Descritpion |
BATCH_ID | Batch identifier to identify the data set |
SUBJECT_QUALAIM1 | Subject of qualification aim 1 |
SUBJECT_QUALAIM2 | Subject of qualification aim 2 |
SUBJECT_QUALAIM3 | Subject of qualification aim 3 |
QUALAIM_PROPORTION | Qualification Aim proportion HESA code |
FEE_ELIGIBILITY | Fee eligibility HESA Code |
POSTCODE | Postcode |
SOCIAL_CLASS_IND | Social class indicator HESA code |
OCCUPATION_CODE | HESA Occupation code |
INST_CODE | Institution code |
GCEASN | Number of GCE AS levels |
HUSID | HESA unique student identifier |
GCEASTS | GCE AS levels tariff score |
VCEASN | Number of VCE AS levels |
VCEASTS | VCE AS levels tariff score |
GCEAN | Number of GCE A levels |
GCEATS | GCE A levels tariff score |
VCEAN | Number of VCE A levels |
VCEATS | VCE A levels tariff score |
KSQN | Number of Key Skills |
KSQTS | Key skills tariff score |
UKSAN | Number of Unit key skills |
PERSON_NUMBER | OSS Person Number |
UKSATS | Unit key skills tariff score |
SAHN | Number of advanced Highers |
SAHTS | Advanced Highers tariff score |
SHN | Number of Highers |
SHTS | Highers tariff score |
SI2N | Number of intermediates |
SI2TS | Intermediates tariff score |
SSGCN | Number of standard grades |
SSGCTS | Standard grade tariff score |
SCSN | Number of Scottish core skills |
COURSE_CD | OSS Program code |
SCSTS | Scottish core skills tariff score |
AEAN | Number of Advanced extension awards |
AEATS | Advanced extension awards tariff score |
TOTAL_UCAS_TARIFF | Total UCAS tariff score |
PREV_INST_LEFT_DATE | Holds the date the Student left the Previous Institution |
UNIT_SET_CD | OSS Unit set code |
UCASNUM | UCAS Applicant number |
SCOTVEC | Scottish Candidate Number |
SURNAME | Surnames |
INTERFACE_HESA_ID | Interface record identifier , sequence generated number |
GIVEN_NAMES | Given names |
BIRTH_DT | Date of birth |
SEX | HESA Gender code |
DOMICILE_CD | HESA Domicile code |
COUNTRY_CODE | HESA country code |
ETHNIC_ORIGIN | HESA Ethnicity code |
DISABILITY_TYPE | HESA Disability code |
YEAR_LEFT | Year left last institution , stored as YYYY. Case and Seed Document: UC_2893542_UCFD210_Acad history Streamlining_CS_DP1.doc - Obsolete |
OCCCODE | Occupation code |
HIGHEST_QUAL_ON_ENTRY | Highest Qualification on entry HESA code |
Student System - IGS_HE_UT_CALC_TYPE | Holds the UCAS Tariff Calculation Types |
---|---|
Column Name | Descritpion |
TARIFF_CALC_TYPE_DESC | Tariff Calculation Type Description |
EXTERNAL_CALC_IND | External Calculation Type Indicator |
CLOSED_IND | Closed Indicator, takes values Y and N |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
TARIFF_CALC_TYPE_CD | Tariff Calculation Type Code |
REPORT_ALL_HIERARCHY_FLAG | Report all awards in tariff breakdown |
Student System - IGS_HE_UT_CALC_LVL | Contains HESA Tariff Levels for a UCAS Tariff Calculation Type |
---|---|
Column Name | Descritpion |
TARIFF_LEVEL_CD | HESA Tariff Level Code from lookups |
CLOSED_IND | Closed Indicator |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
TARIFF_CALC_TYPE_CD | Tariff Calculation Type Code |
Student System - IGS_HE_UT_LVL_AWARD | Contains OSS Awards mapped to Tariff Levels |
---|---|
Column Name | Descritpion |
TARIFF_LEVEL_CD | HESA Tariff Level Code from lookups |
AWARD_CD | OSS Award Code |
DEFAULT_AWARD_IND | Default Award Code indicator |
CLOSED_IND | Closed Indicator |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
TARIFF_CALC_TYPE_CD | Tariff Calculation Type Code |
LAST_UPDATE_LOGIN | Standard Who Column |
Student System - IGS_HE_UT_PRT_AWARD | Holds the parent child Award relationships for a Calculation Type |
---|---|
Column Name | Descritpion |
AWARD_CD | OSS Award Code |
PARENT_AWARD_CD | Parent OSS 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 |
TARIFF_CALC_TYPE_CD | Tariff Calculation Type Code |
Student System - IGS_OR_FUNC_FLTR | Organization Function Filter Details |
---|---|
Column Name | Descritpion |
FUNC_CODE | Form Code |
ATTR_TYPE | Attribute Type Code |
ATTR_VAL | Attribute Type Value |
ATTR_VAL_DESC | Description Of Attribute Value |
INST_ORG_VAL | Stores whether the Form to be filtered on Organization/Institution. Valid Values - I/O. |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
FUNC_FLTR_ID | Unique Identifier Of Record |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
Student System - IGS_PE_ACAD_HONORS | Holds information about the Academic Honors fora Person |
---|---|
Column Name | Descritpion |
PERSON_ID | Person Identifier for the person whose Academic Honors are being stored |
ACAD_HONOR_TYPE | Academic Honor Type Identifier |
COMMENTS | Additional comments for the record |
HONOR_DATE | Date on which the person received the honor |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
ACAD_HONOR_ID | Unique Identifier for the record |
LAST_UPDATE_LOGIN | Standard WHO column |
REQUEST_ID | Concurrent program standard WHO column |
PROGRAM_APPLICATION_ID | Concurrent program standard WHO column |
PROGRAM_ID | Concurrent program standard WHO column |
PROGRAM_UPDATE_DATE | Concurrent program standard WHO column |
Student System - IGS_HE_SUB_RTN_QUAL | Stores the Qualifying Period details for a DLHE Submission Return |
---|---|
Column Name | Descritpion |
USER_RETURN_SUBCLASS | User Return Subclass |
RETURN_NAME | Return Name |
QUAL_PERIOD_CODE | Qualifying Period Code |
QUAL_PERIOD_DESC | Qualifying Period Description |
QUAL_PERIOD_TYPE | Indicates the type of Students to be picked up for this Qualifying Period. L (Leaver) , R (Research) , M (Manual) |
QUAL_PERIOD_START_DATE | Effective Start Date of the Qualifying Period |
QUAL_PERIOD_END_DATE | Effective End Date of the Qualifying Period |
CENSUS_DATE | Census Date of the Qualifying Period |
SUBMISSION_NAME | Submission Name |
SURVEY_START_DATE | Survey Start Date of the Qualifying Period |
SURVEY_END_DATE | Survey End Date of the Qualifying Period |
CLOSED_IND | Indicates if this Qualifying Period is open or closed. Takes values Y or N |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
Student System - IGS_OR_LOC_REGION | Stores the Region Information for a Location. |
---|---|
Column Name | Descritpion |
REGION_CD | Region Code |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
LOCATION_CD | Location Code |
Student System - IGS_HE_STDNT_DLHE | Stores the Student DLHE details for each Submission Return Qualifying Period |
---|---|
Column Name | Descritpion |
SUBMISSION_NAME | Submission Name |
EMPLOYER_POSTCODE | Related to question Q5.3 and HESA field LOCEMP (9) |
EMPLOYER_COUNTRY | Related to question Q5.2 and HESA field LOCEMP (9) |
JOB_TITLE | Related to question Q6 and HESA field JOBTITLE (10) |
JOB_DUTIES | Related to question Q7 |
JOB_CLASSIFICATION | Related to HESA field SOCDLHE (11) |
EMPLOYER_SIZE | Related to question Q8 and HESA field EMPSIZE (12) |
JOB_DURATION | Related to question Q9 and HESA field DURATION (13) |
JOB_SALARY | Related to question Q10 and HESA field SALARY (14) |
SALARY_REFUSED | Related to question Q10 |
QUALIFICATION_REQUIREMENT | Related to question Q11 and HESA field QUALREQ (15) |
USER_RETURN_SUBCLASS | User Return Subclass |
QUALIFICATION_IMPORTANCE | Related to question Q12 and HESA field EMPIMP (16) |
JOB_REASON1 | Related to question Q13.1 and HESA field CAREER1 (17) |
JOB_REASON2 | Related to question Q13.2 and HESA field CAREER2 (18) |
JOB_REASON3 | Related to question Q13.3 and HESA field CAREER3 (19) |
JOB_REASON4 | Related to question Q13.4 and HESA field CAREER4 (20) |
JOB_REASON5 | Related to question Q13.5 and HESA field CAREER5 (21) |
JOB_REASON6 | Related to question Q13.6 and HESA field CAREER6 (22) |
JOB_REASON7 | Related to question Q13.7 and HESA field CAREER7 (23) |
JOB_REASON8 | Related to question Q13.8 and HESA field CAREER8 (24) |
OTHER_JOB_REASON | Related to question Q14.1 |
RETURN_NAME | Return Name |
NO_OTHER_JOB_REASON | Related to question Q14.2 |
JOB_SOURCE | Related to question Q15 and HESA field JOBFND (25) |
OTHER_JOB_SOURCE | Related to question Q16.1 |
NO_OTHER_JOB_SOURCE | Related to question Q16.2 |
PREVIOUS_JOB | Related to question Q17 and HESA field PREVEMP (26) |
PREVIOUS_JOBTYPE1 | Related to question Q18.1 and HESA field PREVCAT1 (27) |
PREVIOUS_JOBTYPE2 | Related to question Q18.2 and HESA field PREVCAT2 (28) |
PREVIOUS_JOBTYPE3 | Related to question Q18.3 and HESA field PREVCAT3 (29) |
PREVIOUS_JOBTYPE4 | Related to question Q18.4 and HESA field PREVCAT4 (30) |
PREVIOUS_JOBTYPE5 | Related to question Q18.5 and HESA field PREVCAT5 (31) |
QUAL_PERIOD_CODE | Qualifying Period Code |
PREVIOUS_JOBTYPE6 | Related to question Q18.6 and HESA field PREVCAT6 (32) |
FURTHER_STUDY_TYPE | Related to question Q19 and HESA field NATSTUDY (33) |
COURSE_NAME | Related to question Q20.1 |
COURSE_TRAINING_SUBJECT | Related to question Q20.2 and HESA field PROFSOCT (34) |
RESEARCH_SUBJECT | Related to question Q21.1 |
RESEARCH_TRAINING_SUBJECT | Related to question Q21.2 and HESA field PROFSOCT (34) |
FURTHER_STUDY_PROVIDER | Related to question Q22 and HESA field INSTPROV (35) |
FURTHER_STUDY_QUALAIM | Related to question Q23 and HESA field TYPEQUAL (36) |
PROFESSIONAL_QUALIFICATION | Related to question Q24 not returned to HESA |
STUDY_REASON1 | Related to question Q25 and HESA field SECINT1 (37) |
DLHE_RECORD_STATUS | Status of this student record during Survey. Can take values NST, EXC, SUB, SAV, REV |
STUDY_REASON2 | Related to question Q27.1 and HESA field SECINT2 (38) |
STUDY_REASON3 | Related to question Q27.2 and HESA field SECINT3 (39) |
STUDY_REASON4 | Related to question Q27.3 and HESA field SECINT4 (40) |
STUDY_REASON5 | Related to question Q27.4 and HESA field SECINT5 (41) |
STUDY_REASON6 | Related to question Q27.5 and HESA field SECINT6 (42) |
STUDY_REASON7 | Related to question Q27.6 and HESA field SECINT7 (43) |
OTHER_STUDY_REASON | Related to question Q28.1 and HESA field SECINT8 (44) |
NO_OTHER_STUDY_REASON | Related to question Q28.2 and HESA field SECINT8 (44) |
EMPLOYER_SPONSORED | Related to question Q26 and HESA field EMPPAID (45) |
FUNDING_SOURCE | Related to question Q29 and HESA field FUNDSTDY (46) |
PARTICIPANT_SOURCE | Qualification Type . Either L (Leaver) , R (Research) or M (Manual) |
TEACHER_TEACHING | Related to question Q30 and HESA field TCHEMP (47) |
TEACHER_SEEKING | Related to question Q33 and HESA field TCHEMP (47) |
TEACHING_SECTOR | Related to question Q31 and HESA field TEACHSCT (48) |
TEACHING_LEVEL | Related to question Q32 and HESA field TEACHPHS(49) |
REASON_FOR_PTCOURSE | Related to question Q34 and HESA field INTENT (50) |
JOB_WHILE_STUDYING | Related to question Q35 and HESA field EMPCRSE (51) |
EMPLOYER_SUPPORT1 | Related to question Q36.1 and HESA field EMSPNS1 (52) |
EMPLOYER_SUPPORT2 | Related to question Q36.2 and HESA field EMSPNS2 (53) |
EMPLOYER_SUPPORT3 | Related to question Q36.3 and HESA field EMSPNS3 (54) |
EMPLOYER_SUPPORT4 | Related to question Q36.4 and HESA field EMSPNS4 (55) |
DATE_STATUS_CHANGED | Latest date when this record's DLHE record status has changed |
EMPLOYER_SUPPORT5 | Related to question Q36.5 and HESA field EMSPNS5 (56) |
POPDLHE_FLAG | Flag to identify records included in POPDLHE. |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
VALIDATION_STATUS | Indicates if this DLHE record satisfies all the validations in Self Service |
PERSON_ID | Person Identifier |
ADMIN_CODING | Indicates if validations related to Employer Details are satisfied |
SURVEY_METHOD | Related to HESA field METHOD (4) |
EMPLOYMENT | Related to question Q1 and HESA field EMPCIR (5) |
FURTHER_STUDY | Related to question Q2 and HESA field MODSTUDY (6) |
QUALIFIED_TEACHER | Related to questionnaire Section D |
PT_STUDY | Related to questionnaire Section E |
EMPLOYER_BUSINESS | Related to question Q3.1 and HESA field MAKEDO (7) |
EMPLOYER_NAME | Related to question Q4 |
EMPLOYER_CLASSIFICATION | Related to question Q3.2 and HESA field SIC (8) |
EMPLOYER_LOCATION | Related to question Q5.1 |
Student System - IGS_HE_EN_SUSA_CC | Holds HESA Cost Center details defined at StudentUnit Set Attempt level |
---|---|
Column Name | Descritpion |
HE_SUSA_CC_ID | Sequence generated Primary Key |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
PERSON_ID | Person Identifier |
COURSE_CD | Program Code |
UNIT_SET_CD | Unit Set Code |
SEQUENCE_NUMBER | Unit Set Sequence Number |
COST_CENTRE | Cost Centre code |
SUBJECT | Subject Code |
PROPORTION | Holds the Percentage Proportion of this Cost centre and Subject |
CREATED_BY | Standard WHO column |
Student System - IGS_HE_ST_PROG_CC | Holds HESA Cost Center details defined at Program version level |
---|---|
Column Name | Descritpion |
COURSE_CD | Program Code |
VERSION_NUMBER | Program Version Number |
COST_CENTRE | Cost Centre code |
SUBJECT | Subject Code |
PROPORTION | Holds the Percentage Proportion of this Cost centre and Subject |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
HE_PROG_CC_ID | Sequence generated Primary Key |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
Student System - IGS_HE_ST_SPA_CC | Holds HESA Cost Center details defined at Student Program Attempt level |
---|---|
Column Name | Descritpion |
HE_SPA_CC_ID | Sequence generated Primary Key |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
PERSON_ID | Person Identifier |
COURSE_CD | Program Code |
COST_CENTRE | Cost Centre code |
SUBJECT | Subject Code |
PROPORTION | Holds the Percentage Proportion of this Cost centre and Subject |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
Student System - IGS_HE_UT_EXCL_QALS | Holds the details of the Qualifications to be excluded from a particular Tariff Calculation |
---|---|
Column Name | Descritpion |
EXCL_QUAL_ID | Sequence generated Primary Key |
TARIFF_CALC_TYPE_CD | User defined code to Uniquely identify the calculation ( FK) |
AWARD_CD | Identifies the Student System Award to be excluded from the Calculation |
FIELD_OF_STUDY | Identifies the Field of Study to be excluded from the Calculation |
CREATED_BY | Standard WHO Column |
CREATION_DATE | Standard WHO Column |
LAST_UPDATED_BY | Standard WHO Column |
LAST_UPDATE_DATE | Standard WHO Column |
LAST_UPDATE_LOGIN | Standard WHO Column |
Student System - IGS_HE_UT_PRS_CALCS | Holds Summary details of Tariff Calculations for a Person |
---|---|
Column Name | Descritpion |
TARIFF_CALC_TYPE_CD | User defined code to Uniquely identify the calculation ( FK) |
PERSON_ID | Person Identifier (FK) |
CALC_DATE | The date that the Calculation was run |
CREATED_BY | Standard WHO 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_HE_UT_PRS_DTLS | Holds Tariff Calculation details for a Person |
---|---|
Column Name | Descritpion |
TARIFF_CALC_TYPE_CD | User defined code to Uniquely identify the calculation ( FK) |
LAST_UPDATE_LOGIN | Standard WHO Column |
PERSON_ID | Person Identifier (FK) |
AWARD_CD | The OSS Award which counts towards the Tariff for the Tariff Level |
NUMBER_OF_QUAL | The number of qualifications of the Specified Award |
TARIFF_SCORE | Total Tariff for Qualifications of the specified Award |
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_HE_VERIFY_DATA_T | Temp table to store data during the 'Verify HESA Return' concurrent process |
---|---|
Column Name | Descritpion |
PERSON_ID | Person ID |
UNIT_CD | Unit Code |
U_VERSION_NUMBER | Unit version number |
FIELDS_AFFECTED | Fields affected by the association code |
ASSOCIATION_CODE | Association Code |
DISPLAY_TITLE | Display Title of Code |
OSS_VALUE | Unmapped OSS value |
SPA_FLAG | Flag to indicate existence of HESA SPA details |
QUALAIM_FLAG | Flag to indicate existence of HESA SPA Qualaim details |
SIN_FLAG | Flag to indicate existence of Student Instance Number |
SUSA_FLAG | Flag to indicate existence of HESA SUSA details |
COURSE_CD | Course code |
PROG_FLAG | Flag to indicate existence of HESA PROG details |
POOUS_FLAG | Flag to indicate existence of HESA POOUS Flag |
UNIT_FLAG | Flag to indicate existence of HESA Unit details |
CREATION_DATE | Standard WHO column |
CREATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
CRV_VERSION_NUMBER | Course version number |
CAL_TYPE | Calendar type |
LOCATION_CD | Location code |
ATTENDANCE_MODE | Attendance mode |
ATTENDANCE_TYPE | Attendance type |
UNIT_SET_CD | Unit set code |
US_VERSION_NUMBER | Unit set version number |
Student System - IGS_HE_OU_CC | A new table to hold HESA cost center, subject and proportion details defined for an organizational unit. |
---|---|
Column Name | Descritpion |
HESA_OU_CC_ID | Unique record ID |
LAST_UPDATE_LOGIN | Standard WHO column |
ORG_UNIT_CD | Value for Organizational Unit Code |
COST_CENTRE | Value for Cost Center |
SUBJECT | Value for Subject |
PROPORTION | Value for Proportion |
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_HE_POOUS_OU_CC | A new table to replace the existing cost center table at year of program level to allow users to record org unit details along with the cost center details for a year of program |
---|---|
Column Name | Descritpion |
HESA_POOUS_CC_ID | Unique record ID |
LAST_UPDATE_LOGIN | Standard WHO column |
HESA_POOUS_OU_ID | Unique value for referencing the program offering option unit set organizational unit |
COST_CENTRE | Value for Cost Center |
SUBJECT | Value for Subject |
PROPORTION | Value for Proportion |
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_HE_PROG_OU_CC | A new table to replace the existing cost center table at program level to allow users to record org unit details along with the cost center details for a program/version |
---|---|
Column Name | Descritpion |
HESA_PROG_CC_ID | Unique record ID |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
COURSE_CD | Value for Program Code |
VERSION_NUMBER | Value for Version Number |
ORG_UNIT_CD | Value for Organizational Unit Code |
COST_CENTRE | Value for Cost Center |
SUBJECT | Value for Subject |
PROPORTION | Value for Proportion |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
Student System - IGS_HE_UNT_OU_CC | A new table to replace the existing cost center table at unit level to allow users to record org unit details along with the cost center details for a unit/version |
---|---|
Column Name | Descritpion |
HESA_UNIT_CC_ID | Unique record ID |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
UNIT_CD | Value for Unit Code |
VERSION_NUMBER | Value for Version Number |
ORG_UNIT_CD | Value for Organizational Unit Code |
COST_CENTRE | Value for Cost Center |
SUBJECT | Value for Subject |
PROPORTION | Value for Proportion |
CREATED_BY | Standard WHO column |
CREATION_DATE | Standard WHO column |
Student System - IGS_HE_POPDLHE_INTS | Interface table to hold records loaded from the POPDLHE file supplied by HESA. |
---|---|
Column Name | Descritpion |
HOME | Home / Other EU Flag |
CREATION_DATE | Standard WHO column indicates when this record was created |
LAST_UPDATED_BY | Standard WHO column indicates who updated this record last |
LAST_UPDATE_DATE | Standard WHO column indicates when this record was last updated |
LAST_UPDATE_LOGIN | Standard WHO column |
LVLQUAL | Level of qualification obtained |
LINE | Data Transaction and Line Number |
HUSID | Unique HESA ID |
HIGHQUAL | DLHE Highest qualification obtained |
SURNAME | Surname |
FNAMES | Forenames |
XQMODE01 | Qualification mode of study |
POPDLHE_ID | Unique record ID |
PTITLE | Program of study title |
QUAL1 | Qualification obtained 1 |
QUAL2 | Qualification obtained 2 |
TTCID | Teacher training course identifier |
OWNSTU | Institution's own student identifier |
OWNPSD | Institution's own program identifier |
POPDLHE | DLHE population identifier |
RCIDENT | Research Council population identifier |
CENSUS | Census (APR/JAN) |
CREATED_BY | Standard WHO column indicates who created this record |
Student System - IGS_HE_SYS_RT_CL_ASS | Stores associations codes for each field in a system return class |
---|---|
Column Name | Descritpion |
IGS_HE_SYS_RT_CL_ASS_ID | Unique ID |
LAST_UPDATED_BY | Standard WHO column |
LAST_UPDATE_LOGIN | Standard WHO column |
SYSTEM_RETURN_CLASS_TYPE | System Return Class Type |
FIELD_NUMBER | Field Number |
ASSOCIATION_CODE | Association code for extract field |
OSS_SEQ | Sequence number of OSS map |
HESA_SEQ | Sequence number of HESA map |
CREATION_DATE | Standard WHO column |
CREATED_BY | Standard WHO column |
LAST_UPDATE_DATE | Standard WHO column |
Student System - IGS_HE_SUBMSN_AWD | HESA Submission Award Periods Table |
---|---|
Column Name | Descritpion |
SUB_AWD_ID | Internal primary key |
CREATION_DATE | Creation Date WHO Column |
LAST_UPDATED_BY | Last Updated By WHO Column |
LAST_UPDATE_DATE | Last Update Date WHO Column |
LAST_UPDATE_LOGIN | Last Update Login WHO Column |
SUBMISSION_NAME | HESA Submission name |
TYPE | Award Conferral Key Type |
KEY1 | Key Value 1 |
KEY2 | Key Value 2 |
KEY3 | Key Value 3 |
AWARD_START_DATE | Award Conferral Start Date |
AWARD_END_DATE | Award Conferral End Date |
CREATED_BY | Created By WHO Column |
Student System - IGS_FI_WAIVER_PGMS | Stores the Waiver Programs defined in the system and the related information. |
---|---|
Column Name | Descritpion |
FEE_CAL_TYPE | Fee Calendar Type under for which the Waiver Program is applicable. |
WAIVER_METHOD_CODE | Waiver Creation Method. Valid values are 'Manual' and 'Computation Rule'. |
WAIVER_MODE_CODE | Manual waiver levels. Valid values are 'Fee Level' and 'Charge Level' |
WAIVER_CRITERIA_CODE | Computation Criteria for the Waiver Program. Valid values are either 'Fee Balance' or 'Computed Amount' |
WAIVER_PERCENT_ALLOC | Percentage allocation for the Waiver Program. Percentage based upon which the waiver amount would be computed. |
RULE_FEE_TYPE | Computation Fee Type of the Waiver Program when the Waiver Method is Computation based. |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
FEE_CI_SEQUENCE_NUMBER | Fee Calendar Instance Sequence Number for which the Waiver is applicable. |
WAIVER_NAME | Waiver Program Name |
OBJECT_VERSION_NUMBER | This column is used for locking rows in the database. |
WAIVER_DESC | Description of the Waiver Program |
WAIVER_STATUS_CODE | Status of the Waiver Program. The valid values are Active or Inactive |
CREDIT_TYPE_ID | Credit Type Identifier of the Credit Type attached to the Waiver Program. |
ADJUSTMENT_FEE_TYPE | Adjustment Fee Type attached to the Waiver Program |
TARGET_FEE_TYPE | Target Fee Type of the Waiver Program. |
Student System - IGS_FI_WAV_STD_PGMS | Stores the Waiver Programs assigned to Students |
---|---|
Column Name | Descritpion |
WAIVER_STUDENT_ID | Sequence generated Student Waiver Identifier |
LAST_UPDATE_DATE | Standard Who Column |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
OBJECT_VERSION_NUMBER | This column is used for locking rows in the database |
FEE_CAL_TYPE | Fee Calendar Type under for which the Waiver Program is applicable |
FEE_CI_SEQUENCE_NUMBER | Fee Calendar Instance Sequence Number for which the Waiver is applicable |
WAIVER_NAME | Waiver Program Name |
PERSON_ID | Student Identifier |
ASSIGNMENT_STATUS_CODE | Status of the student waiver assignments. Would be Active or Inactive |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
Student System - IGS_FI_WAV_PR_PREQS | Stores the Pre-requisite Waiver Programs for a given Waiver Program and Fee Period. |
---|---|
Column Name | Descritpion |
WAIVER_RELATION_ID | Sequence-generated Waiver Relationship Identifier. |
LAST_UPDATED_BY | Standard Who Column |
LAST_UPDATE_LOGIN | Standard Who Column |
OBJECT_VERSION_NUMBER | This column is used for locking rows in the database |
FEE_CAL_TYPE | Fee Calendar Type |
FEE_CI_SEQUENCE_NUMBER | Fee Calendar Instance Sequence Number |
SUP_WAIVER_NAME | Pre-requisite Waiver Program for the given Waiver Program and Fee Period. |
SUB_WAIVER_NAME | Waiver Program for the given Fee Period. |
CREATED_BY | Standard Who Column |
CREATION_DATE | Standard Who Column |
LAST_UPDATE_DATE | Standard Who Column |
Student System - IGS_PE_ACAD_INTENTS | Student Academic Intent |
---|---|
Column Name | Descritpion |
PERSON_ID | Person unique Identifier |
CAL_TYPE | Name of a type of calendar used within the organization |
SEQUENCE_NUMBER | Unique identifier for the calendar instance. |
ACAD_INTENT_CODE | Academic Intent |
ACTIVE_FLAG | Active Flag (Y or N). Only one record for a term can be active |
CREATED_BY | Standard Who column |
CREATION_DATE | Standard Who column |
LAST_UPDATED_BY | Standard Who column |
ACAD_INTENT_ID | Academic Intent Unique Identifier |
LAST_UPDATE_DATE | Standard Who column |
LAST_UPDATE_LOGIN | Standard Who column |
No hay comentarios:
Publicar un comentario