Database Changes for 4.38
This section contains details of database changes between the 4.37 and 4.38 releases.
Table changes:

The following tables have been added.
Table Name | Description |
---|---|
AUTHORITY_TO_DELIVER | A table to specify which enrolment locations have authority to deliver which products. |
INTEGRATION_SYNC_LOG | New table to store meta data about integration processing. |
LLWR_WAGESUBSIDY | Learner wage subsidies for the JGW+ programme. |
LOAN_PERCENTAGE | Defines loan fee percentage for FEE-HELP/VSL loans. |
OUTCOME_CODE_MAPPINGS | Table to store mapping of combinations of ebs enrolment progress codes and/or progress reasons to TCSI Course Outcome Codes. |
PROGRESS_CODE_TCSI_MAPPINGS | TCSI return student statuses mapped to ebs progress codes. Only one set of mappings can exist for a progress code. |
REG_EVENT_SELF_ATTENDEES | The learner mark once his PIN has been submitted and details about the context at the moment of submission. |
REGISTER_EVENT_PIN | A generated self-attendance pin for a single event in time, which the learners can use to self attend. |
UI_REPLACEMENTS | Replacement information for a unit instance code. |
UIO_DAYS_TIMES | Days of week and time of day linked to an offering. |

The following columns have been added.
Table Name | Column Name | Type (Size) | Nullable | Description |
---|---|---|---|---|
COHORTS | START_DATE | datetime | Y | The start date for course enrolments to which this cohort group applies. |
COHORTS | END_DATE | datetime | Y | The end date for course enrolments to which this cohort group applies. |
COHORTS | IS_ACTIVE | nvarchar(1) | N | Specifies whether the cohort group is active or not (Y/N) [DEFAULT=Y]. |
COMMUNICATIONS | RECIPIENT_TYPE | nvarchar(1) | Y | Recipient type of the correspondence. E for Employers and NULL for not specified. |
COMMUNICATIONS | RECIPIENT_ID | numeric(10, 0) | Y | ID of the recipient for which the correspondence was sent [FK=ORGANISATION_UNITS.ID when RECIPIENT_TYPE=E]. |
COMMUNICATIONS | RECIPIENT_CONTACT_ID | numeric(10, 0) | Y | ID of the contact linked to the recipient that the correspondence was sent to [FK=PEOPLE.PERSON_CODE when RECIPIENT_TYPE=E]. |
CONFIGURABLE_STATUSES | IS_TGA | nvarchar(1) | N | Boolean (Y/N) [Default=N]. Whether the status refers to a product downloaded from TGA or not |
EDGE_DATA_SYNC_HASH | EDGE_IDENTIFIER | nvarchar(250) | Y | Unique identifier generated by ebs and used to identify ebs data objects in Edge for a specified interface and instance. The same ebs object can be synced with Edge for a different interface and instance. |
EDGE_INTEGRATION_HISTORY | EDGE_IDENTIFIER | nvarchar(250) | N | Unique identifier generated by ebs and used to identify ebs data objects in Edge for a specified interface and instance. The same ebs object can be synced with Edge for a different interface and instance. |
ELWA_ERR_LOGS | WAGE_SUBSIDY_ID | numeric(10, 0) | Y | The Wage Subsidy with an error, associated to [FK=LLWR_WAGESUBSIDY.ID]. |
FEE_CATEGORIES | AVETMISS_CATEGORY | nvarchar(1) | Y | Allows a fee category to be flagged as a tuition or a resource fee for AVETMISS reporting purposes. R = Resource, T = Tuition |
GRADUATE_OUTCOME_SURVEY | XCAH01_1 | varchar(5) | Y | The Common Aggregation Hierarchy, first level grouping 1. |
GRADUATE_OUTCOME_SURVEY | XCAH01_2 | varchar(5) | Y | The Common Aggregation Hierarchy, first level grouping 2. |
GRADUATE_OUTCOME_SURVEY | XCAH01_3 | varchar(5) | Y | The Common Aggregation Hierarchy, first level grouping 3. |
GRADUATE_OUTCOME_SURVEY | XCAH01_4 | varchar(5) | Y | The Common Aggregation Hierarchy, first level grouping 4. |
GRADUATE_OUTCOME_SURVEY | XCAH01_5 | varchar(5) | Y | The Common Aggregation Hierarchy, first level grouping 5. |
GRADUATE_OUTCOME_SURVEY | XCAH03_1 | varchar(11) | Y | The Common Aggregation Hierarchy, third level grouping 1. |
GRADUATE_OUTCOME_SURVEY | XCAH03_2 | varchar(11) | Y | The Common Aggregation Hierarchy, third level grouping 2. |
GRADUATE_OUTCOME_SURVEY | XCAH03_3 | varchar(11) | Y | The Common Aggregation Hierarchy, third level grouping 3. |
GRADUATE_OUTCOME_SURVEY | XCAH03_4 | varchar(11) | Y | The Common Aggregation Hierarchy, third level grouping 4. |
GRADUATE_OUTCOME_SURVEY | XCAH03_5 | varchar(11) | Y | The Common Aggregation Hierarchy, third level grouping 5. |
ILP_INSTANCE_REVIEWS | HEADER_SNAPSHOT | nvarchar(4000) | Y | A JSON snapshot of the header data for an ILP instance review once it has been completed. |
LEARNING_ACT | JGWACTIVITYDESCRIPTORS | numeric(2, 0) | Y | The activity descriptions for learners on the JGW+ programme [LA49]. |
LEARNING_ACT | EMPLOYERID | numeric(10, 0) | Y | The unique ID allocated to the employer by the lead contractor [LA50]. |
PEOPLE_DEDUPLICATION_AUDIT | EXTERNAL_REF | nvarchar(256) | Y | A copy of the value from the user record for the source learner in the de-duplication process. |
PEOPLE_UNITS | HIGHEST_ATTAINMENT_CODE | nvarchar(40) | Y | Learner's highest level of prior educational achievement. [FK=VERIFIERS.LOW_VALUE(RV_DOMAIN=PRIOR_EDUCATION_IDENTIFIER)] |
PEOPLE_UNITS_VSL | ORIGINAL_AMOUNT_CHARGED | numeric(7, 2) | Y | The amount charged to the student prior to withdrawal. |
PEOPLE_UNITS_VSL | ORIGINAL_AMOUNT_PAID_UPFRONT | numeric(7, 2) | Y | The amount the student paid upfront prior to withdrawal. |
PEOPLE_UNITS_VSL | ORIGINAL_LOAN_AMOUNT | numeric(7, 2) | Y | The loan amount for the student prior to withdrawal. |
PEOPLE_UNITS_VSL | ORIGINAL_LOAN_FEE | numeric(7, 2) | Y | The loan fee for the student prior to withdrawal. |
PEOPLE_UNITS_VSL | ATTENDANCE_MODE | nvarchar(40) | Y | VSL/HELP Attendance Mode (E329) [FK=VERIFIERS.LOW_VALUE(RV_DOMAIN=VFH_DELIVERY_MODE)] |
PERSON_FUNCTIONS | IS_ILP | nvarchar(1) | N | Enables the identification of ILP staff when used in registers (Y/N) [DEFAULT=N]. |
PROGRESS_CODES | AVETMISS_PROGRAM_STATUS | nvarchar(40) | Y | The AVETMISS Program Status Identifier that this progress code maps to for the AVETMISS return. [FK=VERIFIERS.LOW_VALUE(RV_DOMAIN=AVETMISS_PROGRAM_STATUS)] |
REGISTER_EVENT_DETAILS | CANCEL_REASON | nvarchar(40) | Y | Interview cancel reason [FK=VERIFIERS.LOW_VALUE(RV_DOMAIN=INTERVIEW_CANCEL_REASON)]. |
ROLE_DEFS | IS_VISIBLE | nvarchar(1) | N | Whether the role is visible in the application or not [Y/N, Default value = Y] |
THIRDPARTY_LINKS | IS_USE_EXTERNAL | varchar(1) | N | Specifies whether to open the link on an external webview (Y/N) [DEFAULT=N]. |
UNIT_INSTANCE_OCCURRENCES | ATTENDANCE_TYPE | nvarchar(40) | Y | Type of Attendance for the Course [FK=VERIFIERS.LOW_VALUE(RV_DOMAIN=DEEWR_TYPE_OF_ATTENDANCE)] |
UNIT_INSTANCES | TRAINING_PACKAGE_CODE | nvarchar(20) | Y | The code for the training package that this unit instance belongs to. [FK=VERIFIERS.LOW_VALUE(RV_DOMAIN=NATIONAL_CODE)] |
UNIT_INSTANCES | TRAINING_PACKAGE_TITLE | nvarchar(100) | Y | The title for the training package that this unit instance belongs to. |
UNIT_INSTANCES | TGA_RECOMMENDED_USAGE | nvarchar(100) | Y | The recommended usage for this unit instance as specified by TGA download. |
UNIT_INSTANCES | OBSOLETE_FROM_DATE | datetime | Y | The date when this unit instance becomes obsolete. |
WORKFLOW_LAST_EXECUTION | LAST_SYNC_TIMESTAMP | datetimeoffset(7) | Y | Last timestamp when the workflow identified by WORKFLOW_REFERENCE was successful. |

The following columns have been changed.
Table Name | Column Name | Type (Size) | Nullable | Previous Values Type (Size) [Nullable] |
---|---|---|---|---|
EMAIL_TEMPLATES | EMAIL_TYPE | nvarchar(40) | N | nvarchar(20) [N] |
MESSAGE_LOGS | DATA_1 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_2 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_3 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_4 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_5 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_6 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_7 | nvarchar(100) | Y | nvarchar(60) [Y] |
MESSAGE_LOGS | DATA_8 | nvarchar(100) | Y | nvarchar(60) [Y] |
PEOPLE_UNITS | AMNT_PRIOR_LRN_CREDIT_USED | numeric(7, 3) | Y | numeric(4, 0) [Y] |
PEOPLE_VSL | HAS_HS_OR_CERTIV | nvarchar(1) | N | nvarchar(1) [Y] |
PEOPLE_VSL | HAS_HS_OR_CERTIV_BEEN_VERIFIED | nvarchar(1) | N | nvarchar(1) [Y] |
PEOPLE_VSL | HAS_LLN_BEEN_VERIFIED | nvarchar(1) | N | nvarchar(1) [Y] |
REPORT_EVENTS | EMAIL_TYPE | nvarchar(40) | N | nvarchar(20) [N] |
UNIT_INSTANCE_OCCURRENCES | BOOKABLE_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_ACTIVE_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_FINISHED_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_MIN_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_NON_STARTER_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_TRANSFERRED_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_TRIGGER_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | FES_WITHDRAWN_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | PLACES_BOOKED | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | TARGET_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | TOTAL_PLACES | numeric(6, 0) | Y | numeric(4, 0) [Y] |
UNIT_INSTANCE_OCCURRENCES | TOTAL_PLACES_APPS | numeric(6, 0) | Y | numeric(4, 0) [Y] |

The following columns have been dropped.
Table Name |
Column Name |
Type (Size) |
Nullable |
Description |
---|---|---|---|---|
SKILLS_LIST_ITEMS | IS_NAT_AVAIL_FND_SKILLS | nvarchar(1) | N | Whether the skill is nationally available for the Foundation Skills program stream [Y/N, Default value = N] |
SKILLS_LIST_ITEMS | IS_NAT_AVAIL_FULL_QUAL | nvarchar(1) | N | Whether the skill is nationally available for the Full Qualifications program stream [Y/N, Default value = N] |
SKILLS_LIST_ITEMS | IS_NAT_AVAIL_APPRENTICESHIP | nvarchar(1) | N | Whether the skill is nationally available for the Apprenticeship program stream [Y/N, Default value = N] |
SKILLS_LIST_ITEMS | IS_NAT_AVAIL_TRAINEESHIP | nvarchar(1) | N | Whether the skill is nationally available for the Traineeship program stream [Y/N, Default value = N] |
SKILLS_LIST_ITEMS | IS_NAT_AVAIL_TRGT_PRIORITY | nvarchar(1) | N | Whether the skill is nationally available for the Targeted Priority program stream [Y/N, Default value = N] |
SKILLS_LIST_ITEMS | IS_LOC_AVAIL_FULL_QUAL | nvarchar(1) | N | Whether the skill is locally available for the Full Qualifications program stream [Y/N, Default value = N] |
View changes:

The following views have been added:
-
EBS_ACTIVE_ROOMS_FOR_COL_NSW
-
EBS_ACTIVE_ROOMS_NSW
-
EBS_AGENT_PROGRESSIONS_NSW
-
EBS_ATMNTS_AWARD_OUTCOMES_NSW
-
EBS_ATTAINMENTS_NSW
-
EBS_ATTAINMENTS_OUTCOMES_NSW
-
EBS_ATTENDANCE_USAGE_CODES
-
EBS_BULK_ENROLMENT_NSW
-
EBS_BULK_USI_ACTIVITY_VIEWER
-
EBS_CAL_OCC_AWARD_LOC_NSW
-
EBS_CAL_OCC_CODES_NSW
-
EBS_CAL_OCC_SEARCH_NSW
-
EBS_CASHDESK_FEE_TYPES_NSW
-
EBS_CASHDESK_FEES_NSW
-
EBS_CORRESPONDENCE_EMPLOYERS
-
EBS_CORRESPONDENCE_ENROLMENTS
-
EBS_COURSE_ASMT_RESULTS_NSW
-
EBS_COURSE_OCC_APPLY_NSW
-
EBS_COURSE_OCCURRENCES_NSW
-
EBS_DOC_TEMPLATES_ENROLMENT
-
EBS_EDGE_ACTIVITY_VIEWER
-
EBS_ENROLMENT_FEE_TYPES_REGION
-
EBS_INSTALMENT_FEE_SUMMARY_NSW
-
EBS_INTERVIEW_STATUS
-
EBS_LEARNER_APP_SPECIAL_NSW
-
EBS_LEARNER_FEES_NSW
-
EBS_LLWR_LEARNER_WAGESUBSIDIES
-
EBS_LLWR_LEARNER_WAGESUBSIDIES_WIDEBOY
-
EBS_LOC_FOR_COLLEGE_BY_REGION
-
EBS_ORG_REGIONS_VERIFIER_PROP
-
EBS_ORGANISATION_REGIONS_FA
-
EBS_ORGANISATION_REGIONS_TS
-
EBS_ORGANISATIONS_REGIONS
-
EBS_PB_LINKED_ATTAINMENTS_NSW
-
EBS_PEOPLE_OWNER_REGION_NSW
-
EBS_PEOPLE_UNIT_PARENT_REGIONS
-
EBS_PRINT_BUREAU_EXPORT_NSW
-
EBS_RECEIPT_INSTALMENTS_NSW
-
EBS_REG_TASK_LIST_A_NSW
-
EBS_REGIONS_ORGANISATIONS
-
EBS_REPORTS_STORE_LITE
-
EBS_RESIDENTIAL_STATUS_UPDATED
-
EBS_ROOM_SEARCH_NSW
-
EBS_ROOMS_NSW
-
EBS_SDR_COURSE_COMPLETION_2022
-
EBS_SDR_COURSE_ENROLMENTS_2022
-
EBS_SDR_COURSE_REG_BASE_2022
-
EBS_SDR_COURSE_REGISTER_2022
-
EBS_SDR_QUAL_COMPLETIONS_2022
-
EBS_SDR_SETTINGS_2022
-
EBS_SDR_STUDENTS_2022
-
EBS_SDR_STUDENTS_BASE_2022
-
EBS_STAFF_QUICKSEARCH_NSW
-
EBS_STAFF_REGIONS
-
EBS_TESTAMUR_HISTORY
-
EBS_TGA_EMAIL_TEMPLATES
-
EBS_TGA_INT_ACTIVITY_VIEWER
-
EBS_TGA_INT_ADMINS
-
EBS_TGA_INT_BATCHES
-
EBS_TILLS_NSW
-
EBS_UI_REPLACEMENTS
-
EBS_UI_UIO_INPUTSEARCH_ANSW
-
EBS_UI_WITHUIO_INPUTSEARCH_NSW
-
EBS_UIO_CURR_WITH_CALOCC_NSW
-
EBS_UIO_DAYS_TIMES
-
EBS_UIO_SEARCH_ALL_NSW
-
EBS_VERIFIER_COSTCENTRE_REGION
-
EBS_VERIFIER_CREDITPROV_ANSW
-
EBS_ZREAD_BANKING_NSW
-
EDGE_AUCOMP_ADMISSION_BASIS
-
EDGE_AUCOMP_CAMPUS_COURSE_FEES
-
EDGE_AUCOMP_CAMPUSES
-
EDGE_AUCOMP_CITIZENSHIPS
-
EDGE_AUCOMP_COURSE_ADMISSION
-
EDGE_AUCOMP_COURSES_OF_STUDY
-
EDGE_AUCOMP_COURSES_ON_CAMPUS
-
EDGE_AUCOMP_CRS_PRIOR_CREDIT
-
EDGE_AUCOMP_DISABILITIES
-
EDGE_AUCOMP_FIELDS_OF_EDU
-
EDGE_AUCOMP_HE_COURSES
-
EDGE_AUCOMP_SPEC_INT_COURSES
-
EDGE_AUCOMP_STUDENTS
-
EDGE_AUCOMP_UNIT_ENROLMENTS
-
EDGE_AUCOMP_VET_COURSES

The following columns have been added.
View Name | Column Name |
---|---|
DASHBOARDAPPLICATIONS | CALENDAR_TYPE |
DASHBOARDATTENDANCE | CALENDAR_TYPE |
DASHBOARDCOURSETARGETS | CALENDAR_TYPE |
DASHBOARDENROLMENTS | CALENDAR_TYPE |
DASHBOARDFEES | CALENDAR_TYPE |
EBS_AGENT_PROGRESSIONS | OFFERING_TYPE |
EBS_AGENT_PROGRESSIONS | REGION_ORGANISATION |
EBS_AGENT_PROGRESSIONS | SLOC_LOCATION_CODE |
EBS_AGENT_PROGRESSIONS | UI_LEVEL |
EBS_ASSESSMENTS_ANSW | REGION_ORGANISATION_DESC |
EBS_ATMNTS_AWARD_OUTCOMES_ANSW | OFFERING_TYPE |
EBS_ATMNTS_AWARD_OUTCOMES_ANSW | UI_LEVEL |
EBS_BULK_ENROLMENT | HE_CREDIT_PROVIDER_DESC |
EBS_BULK_ENROLMENT | REGION_ORGANISATION |
EBS_CLIENT_INTERVIEWS | CANCEL_REASON |
EBS_COURSE_ASMT_RESULTS_ANSW | ASSESSMENT_TYPE_OPS_MASTER |
EBS_ENROLMENT_LOCATIONS_NSW | COUNTRY_CODE |
EBS_EXTERNAL_REFUND_SUMMARY | REGION_CODE |
EBS_EXTERNAL_REFUND_SUMMARY | REGION_NAME |
EBS_LEARNER_APP_SPECIAL | REGION_ORGANISATION |
EBS_LEARNER_ATTAINMENTS_ANSW | INCLUDE_IN_HESA |
EBS_LEARNER_ATTAINMENTS_ANSW | OFFERING_TYPE |
EBS_LEARNER_ATTAINMENTS_ANSW | REGION_ORGANISATION |
EBS_LEARNER_ATTAINMENTS_ANSW | UI_LEVEL |
EBS_LEARNER_ENROLMENTS | ATTENDANCE_MODE |
EBS_LEARNER_ENROLMENTS | HIGHEST_ATTAINMENT_CODE |
EBS_LEARNER_ENROLMENTS | ORIGINAL_AMOUNT_CHARGED |
EBS_LEARNER_ENROLMENTS | ORIGINAL_AMOUNT_PAID_UPFRONT |
EBS_LEARNER_ENROLMENTS | ORIGINAL_LOAN_AMOUNT |
EBS_LEARNER_ENROLMENTS | ORIGINAL_LOAN_FEE |
EBS_LEARNER_ENROLMENTS | PRIOR_EDUCATION_ACHIEVEMENT |
EBS_LEARNERS | PRIMARYROLE |
EBS_LEARNERS | PRIMARYROLE_DESC |
EBS_LEARNERS | SECONDARYROLES |
EBS_LEARNERS | SECONDARYROLES_DESC |
EBS_LEARNERS_DEDUP | PRIMARYROLE |
EBS_LEARNERS_DEDUP | PRIMARYROLE_DESC |
EBS_LEARNERS_DEDUP | SECONDARYROLES |
EBS_LEARNERS_DEDUP | SECONDARYROLES_DESC |
EBS_LEARNERS_DEDUP_ANSW | PREV_BPAY_NOS |
EBS_LEARNERS_NSW | PREV_BPAY_NOS |
EBS_LLWR_LEARNING_ACT | EMPLOYERID |
EBS_LLWR_LEARNING_ACT | JGWACTIVITYDESCRIPTORS |
EBS_LLWR_LEARNING_ACT | TYPE_LPG |
EBS_LOAN_SUMMARY | REGION_ORGANISATION |
EBS_LOCATIONS | COUNTRY_CODE |
EBS_NON_PRINTED_LOAN_SUMMARY | REGION_ORGANISATION |
EBS_ORG_UNIT_PEOPLE_REGIONS | REGION_FES_ACTIVE |
EBS_ORG_UNITS_FACULTY_REGIONS | DEPARTMENT_HEAD_FORMATTED |
EBS_ORG_UNITS_FACULTY_REGIONS | EMPLOYER_REFERENCE_NUMBER |
EBS_ORG_UNITS_FACULTY_REGIONS | INSTITUTION_CONTEXT_ID |
EBS_ORG_UNITS_TS_LOCATIONS | DEPARTMENT_HEAD_FORMATTED |
EBS_ORG_UNITS_TS_LOCATIONS | EMPLOYER_REFERENCE_NUMBER |
EBS_ORG_UNITS_TS_LOCATIONS | INSTITUTION_CONTEXT_ID |
EBS_PEOPLE_REGIONS | FES_ACTIVE |
EBS_PEOPLE_UNIT_LINKS | HIGHEST_ATTAINMENT_CODE |
EBS_REG_EVENTS | REGION_ORGANISATION_UNIT_ID |
EBS_REG_EVENTS_SEARCH_VIEW | ORGANISATION_CODE |
EBS_REG_EVENTS_SEARCH_VIEW | REGION_ORGANISATION_UNIT_ID |
EBS_REG_TASK_LIST | REGION_CODE |
EBS_REG_TASK_LIST | REGION_DESCRIPTION |
EBS_REG_TASK_LIST | REGION_ID |
EBS_REGION_ORGANISATIONS | REGION_FES_ACTIVE |
EBS_REGIONS | FES_ACTIVE |
EBS_ROOMS | ROOM_TYPE_LONG_DESC |
EBS_ROOMS | ROOM_TYPE_SHORT_DESC |
EBS_SPONSOR_INVOICE_SUMM_ANSW | FES_VAT_AMOUNT |
EBS_STAFF_ALL_NSW | CURRENT_DATE |
EBS_STAFF_ALL_NSW | END_DATE |
EBS_STAFF_ALL_NSW | START_DATE |
EBS_STAFF_NSW | REGION_ID |
EBS_UI_LINKS | IS_MANAGED_BY_TGA |
EBS_UIO | ATTENDANCE_TYPE |
EBS_UIO | CALOCC_DESC |
EBS_UIO | LOCATION_DESCRIPTION |
EBS_UIO | NATIONAL_COURSE_CODE |
EBS_UIO | REGION_ORGANISATION_DESC |
EBS_UIO | UI_IS_FEE_HELP |
EBS_UIO | UI_IS_VET_FEE_HELP |
EBS_UIO_CHILD_LINKS | ATTENDANCE_TYPE |
EBS_UIO_FEES | REGION_ORGANISATION_DESC |
EBS_UIO_INPUTSEARCH_ANSW | AWARD_CATEGORY_CODE |
EBS_UIO_INPUTSEARCH_ANSW | NATIONAL_COURSE_CODE |
EBS_UIO_INPUTSEARCH_ANSW | REGION_ID |
EBS_UIO_INPUTSEARCH_ANSW | REGION_ORGANISATION |
EBS_UIO_INPUTSEARCH_ANSW | UI_DESCRIPTION |
EBS_UIO_LLWR | ATTENDANCE_TYPE |
EBS_UIO_LLWR | CALOCC_DESC |
EBS_UIO_LLWR | LOCATION_DESCRIPTION |
EBS_UIO_LLWR | NATIONAL_COURSE_CODE |
EBS_UIO_LLWR | REGION_ORGANISATION_DESC |
EBS_UIO_LLWR | UI_IS_FEE_HELP |
EBS_UIO_LLWR | UI_IS_VET_FEE_HELP |
EBS_UIO_PARENT_CHILD_DETAILS | CHILD_REGION_ORGANISATION |
EBS_UIO_PARENT_CHILD_DETAILS | PARENT_REGION_ORGANISATION |
EBS_UIO_PARENT_CHILD_DETAILS | YEAR_LONG_INDICATOR |
EBS_UNIT_INSTANCES | IS_MANAGED_BY_TGA |
EBS_UNIT_INSTANCES | IS_STATUS_TGA |
EBS_UNIT_INSTANCES | LAST_TGA_SYNC_DATE |
EBS_UNIT_INSTANCES | OBSOLETE_FROM_DATE |
EBS_UNIT_INSTANCES | SPECIAL_COURSE_INDICATOR |
EBS_UNIT_INSTANCES | TGA_RECOMMENDED_USAGE |
EBS_UNIT_INSTANCES | TRAINING_PACKAGE_CODE |
EBS_UNIT_INSTANCES | TRAINING_PACKAGE_TITLE |
EBS_UNIT_INSTANCES_ANSW | IS_MANAGED_BY_TGA |
EBS_UNIT_INSTANCES_ANSW | IS_STATUS_TGA |
EBS_UNIT_INSTANCES_ANSW | OBSOLETE_FROM_DATE |
EBS_UNIT_INSTANCES_ANSW | TGA_RECOMMENDED_USAGE |
EBS_UNIT_INSTANCES_ANSW | TRAINING_PACKAGE_CODE |
EBS_UNIT_INSTANCES_ANSW | TRAINING_PACKAGE_TITLE |
EBS_UNIT_INSTANCES_CANENROCCS | IS_MANAGED_BY_TGA |
EBS_UNIT_INSTANCES_CANENROCCS | IS_STATUS_TGA |
EBS_UNIT_INSTANCES_CANENROCCS | LAST_TGA_SYNC_DATE |
EBS_UNIT_INSTANCES_CANENROCCS | OBSOLETE_FROM_DATE |
EBS_UNIT_INSTANCES_CANENROCCS | SPECIAL_COURSE_INDICATOR |
EBS_UNIT_INSTANCES_CANENROCCS | TGA_RECOMMENDED_USAGE |
EBS_UNIT_INSTANCES_CANENROCCS | TRAINING_PACKAGE_CODE |
EBS_UNIT_INSTANCES_CANENROCCS | TRAINING_PACKAGE_TITLE |
EBS_VERIFIER_FEE_CATEGORIES | AVETMISS_CATEGORY |
EBS_VFH_INVOICE_NOTICE_SUMMARY | REGION_ORGANISATION |

The following columns have been dropped.
Table Name | Description |
---|---|
EBS_OWNERSHIPS_ACTIONS | context |
EBS_OWNERSHIPS_ACTIONS | institution_context_id |