Top of ENR Index Table of Contents Feedback

ENRF5900 - Merge Person with Two IDs

Purpose To merge the records of a student with two ID numbers into one ID number.
SubSystem Enrolments
Normally Run By Enrolment Specialist
Anticipated Frequency As required
Structure  Blocks Merge IDs
Merge Table Name
Information
Action Choice
Buttons Determine Actions
Preview Merged Data
Merge Person IDs

  

A person may be inadvertently recorded in the system under two (or more) ID numbers. This form is used to run a process which copies data from one of the ID numbers (Obsolete ID) into a single set of data under the other number (Current ID).

Merge IDs block

The Merge IDs block is used to record the two ID numbers that are to be merged. Click on the Determine Actions button to display details of the data to be merged and available actions about how the data can be merged.
Users of this function should have an understanding of the data being merged.

Merge Table Name block

When the Determine Actions button is selected, Callista determines which database tables from both ID numbers are involved in the merge process and displays their Descriptions in this block. Each of these tables can be selected in turn to view the actions to be performed on the data they contain.

Information block

The Information block describes the information contained under both IDs prior to the merge process. Based on the information displayed here, choices are made as to the actions to be performed during the merge process. Not all data has to be merged. Where data relating to two students is recorded under one ID, it is possible to selectively merge this data into the two correct IDs by performing this process twice, once for each current ID.

The block contains four fields, the fields on the left displaying information about data under the obsolete ID, the fields on the right displaying information about data under the current ID. The scroll bar on the extreme left is active when more than two information records exist for a merge table. The scroll bars to the right of each field are active when an information record occupies more than three lines of text.

Action Choice block

When information is highlighted in the Information block, the proposed actions to be performed are displayed in the Action Choice block. The choice is then made as to whether or not to perform the action by selecting or deselecting the Perform Action check box. (Default is selected for all actions). Where the system determines that an action is not possible, the reason is displayed in the Action Choice block and the Perform Action check box is deselected.

Data that has been marked to be merged (via the Perform Action checkbox) can be viewed by clicking on the Preview Merge Data button which generates a CSV file that can be opened by any spreadsheet program. The CSV file will contain data to be merged for the tables displayed in the Information block, along with data to be merged on their associated child tables. A user can then analyse the contents of the CSV file to assist them with merge decisions.

The CSV has the following columns with values separated by a comma:

  • Table
  • Child Table
  • Obsolete ID
  • Obsolete ID Row Information
  • Current ID
  • Current ID Row Information
  • Action

The CSV file is named ENRF5900_preview_<Obsolete ID>_<Current ID>_<Current Date>_<Current Time>.csv

When all actions have been decided, the Merge Person IDs button is selected to perform the process. Successfully merged records are automatically saved and cannot be 'undone'.

If the merge is unsuccessful, it is most likely because some data under the Obsolete ID conflicts with data under the Current ID. Callista provides detailed messages which enable the user to determine the reasons for the failed merge and take action to either:

  • Modify data to enable the merge to proceed, or
  • Deselect the Perform Action check box so that conflicting data is not merged.

Where a merge is unsuccessful, the Obsolete and Current Records remain in their pre-merge state.
 

The Merge IDs block contains:

  • Obsolete ID
  • Current ID

    Button

    • Determine Actions

The Merge Table Name block contains:

  • Table

The Information block contains:

  • Obsolete ID Row Information
  • Current ID Row Information

The Action Choice block contains:

  • Action Text
  • Perform Action check box

    Button

    • Preview Merge Data
    • Merge Person IDs

Rules/Notes:

  • Click on the Preview Merge Data button generates a CSV file that that provides a preview of all data to be merged.
  • The Preview file name/directory cannot contain a space.
To merge the records from two ID numbers under one of those numbers using this form:
  • Enter the Obsolete ID number and tab. The student's name, as recorded for this number, is displayed.
  • Enter the Current ID number and tab. The student's name, as recorded for this number, is displayed.
  • Select the Determine Actions button. Descriptions of database tables from which data is to be considered for merging are displayed in the Merge Table Name block.
  • Select each table name, in turn, to display details of the information contained under both IDs prior to the merge process.
  • For each table name, select each record in the Information block, in turn, to display the proposed action(s) to be performed on that record.
  • The Perform Action check box is selected by default. If you do not wish to perform an action, deselect the check box.
  • Select the Merge Person IDs button when ready.
  • If the merge is successful you are prompted to open a CSV file to do a post-merge review.

If the merge process is unsuccessful, error messages are displayed advising of the problem. Either:

  • Fix any problems with conflicting data and then repeat all steps in this process.

Or:

  • Deselect the Perform Action check box for the offending data to remove this data from the merge process.
  • Save, and then:
  • Select the Merge Person IDs button again. Manual action is then required if this data is to be included under the current ID.
  		Rules/Notes:

It is not possible to merge two IDs in BOTH directions, and an obsolete ID cannot subsequently be merged with another ID.

When the merge process fails to copy any part of the obsolete data to the current ID, the whole process 'fails' and no obsolete data is transferred.

Callista can identify many instances where data cannot be merged and reports on each in the Action Choice block. The Perform Action check box is automatically deselected in these cases. If the merge process fails, solutions should be sought from those action choices with the Perform Action check box selected.

In most cases validations are disabled when merge data is inserted.

Some tables can only be merged after other related tables have been successfully merged, for example, Student Unit Attempt data must be merged before Student Unit Attempt Outcomes can be merged.

When some tables are merged their related child records will also be merged, for example, Admission Application data.

The data that is merged (i.e. data that is copied from the Obsolete ID to the Current ID) is written to the log.
Not all data for each record is logged - just enough to identify the record that is logged.

There is also a 'Post-Merge Review' CSV file that can be generated at this stage as well.
After the merge is complete, the user is presented with a message asking them if they want to review the merged data. If they click the Yes button in response, the merge data is downloaded and a ‘Save As’ dialog allows the user to specify the location to which to save the file. The default file name is: ENRF5900_post_merge_review_<Obsolete ID>_<Current ID>_<Current Date>_<Current Time>.csv

For tables that include Start and End Date fields, options may be available to allow the records to be be merged in various ways. See the Tables with Effective Dates section, below.

Note:

  • Campus Transfer Applications will not be merged. This means that any pending Campus Transfer Applications for the person that is being merged, should be processed prior to the merge.
  • eCAF records will not be merged.

Typical Merge

Copy Disability Type details from Obsolete to Current:

PERSON_ID   DISABILITY TYPE  
1234 MOBILITY Obsolete ID
2468     SIGHT Current ID

The merged records will be:

PERSON_ID DISABILITY TYPE  
1234 MOBILITY Obsolete
2468 MOBILITY  Current ID
2468 SIGHT Current ID

An Alternate ID record of Person ID Type OBSOLETE will be created for the Current Student.
An Alternate ID record of Person ID Type M-I will be created for the Obsolete Student.

Tables with Effective Dates (e.g. Person Addresses)

Person Addresses are effective-dated and cannot be merged if the merge would result in a date overlap within an Address Type or within Correspondence Addresses. The merge process manages this by automatically end-dating Person Addresses during the merge.

If both the obsolete person and current person records have open-ended dates and the obsolete record start date is before the current record start date date then the option is available to copy the obsolete person data and end-date it (as day before Current Person Address Start Date ).

Obsolete Person Address
ADDR TYPE START_DT END_DT ADDR_LINE_1
HOME    01/01/2009   Level 1, 17 Madden St.

Current Person
ADDR TYPE START_DT END_DT ADDR_LINE_1
HOME    01/01/2010   Level 4, 27 Brougham St.

The merged records will be:
ADDR TYPE START_DT END_DT ADDR_LINE_1
HOME    01/01/2009 31/12/2009 Level 1, 17 Madden St.
HOME    01/01/2010   Level 4, 27 Brougham St.

If both the obsolete person and current person records have open-ended dates and the current record start date is before the obsolete start date date then the option is available to copy the obsolete person data and end-date the current date (as the day before the obsolete person address start date).

Obsolete Person Address
ADDR TYPE START_DT END_DT ADDR_LINE_1
HOME    01/01/2010   Level 1, 17 Madden St.

Current Person
ADDR TYPE START_DT END_DT ADDR_LINE_1
HOME    01/01/2009   Level 4, 27 Brougham St.

The merged records will be:
ADDR TYPE START_DT END_DT ADDR_LINE_1
HOME    01/01/2009 31/12/2009 Level 4, 27 Brougham St.
HOME    01/01/2010   Level 1, 17 Madden St.

Note: There are many other tables with effective dates are they are typically managed in a similar way to Person Addresses.

Applicant Records

Alternate Person ID Applicant IDs for the Obsolete Person are removed once they have been copied to the Current Person.

CHESSN Details

If the Current ID has a CHESSN with a status of Active or Provisional, the Obsolete student  CHESSN will not be copied across to the current person ID regardless of the status of the obsolete ID.
If the current ID doesn't already have a CHESSN of Provisional or Active but the obsolete ID does, then the CHESSN against the obsolete ID is set to Inactive and the CHESSN in it's pre-inactive state is copied to the current ID.
If the chessn for the obsolete person is inactive then it is not copied to the current ID.
If the current ID has a government citizenship status of 4,5 or 9 then the CHESSN is not copied from the obsolete ID. The CHESSN should remain as it is against the obsolete ID and so no actions are taken.
If a CHESSN has an outstanding request it is not copied from the obsolete to the current id.  It is left against the obsolete id in it's current form.
For further details on CHESSN processing in Callista, go to the CHESSN/HEIMS pages listed in the Admissions Subsystem page.

Merged Data

Data from the following tables may be merged during this process. In some cases data in child tables will also be merged.
e.g. When data from the STUDENT_PROGRESSION_CHECK table is merged then data from the related STUDENT_PRG_COURSE, STUDENT_PRG_UNIT_SET, STUDENT_PRG_UNIT and STUDENT_PRG_RULE_CHECK may also be merged.

The following table lists the database tables included in the merge process along with actions available for data on each of the tables. Tables are listed in the order they are processed

Description

Table

Action Outcomes

Student Todo

STUDENT_TODO
  1. Copy the Student Todo record for the Obsolete ID to the Current ID.
  2. Cannot copy the Student Todo record because a similar record for the Current ID already exists.

Student Course Attempt

STUDENT_COURSE_ATTEMPT
  1. Copy the Student Course Attempt record for the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Attempt because the Current ID already contains the same Student Course Attempt.

Student Status

STUDENT_COURSE_HECS_OPTION
  1. Copy the Student Course HECS Option record for the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course HECS Option record because a record with the same Course Code and Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Student Course Attempt Enrolment

STUDENT_CRS_ATMPT_ENR
  1. Copy the Student Course Attempt Enrolment record for the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Attempt Enrolment record because a similar record for the Current ID already exists.

SCA_ENR_STEP

No action choices; part of STUDENT_CRS_ATMPT_ENR.

SCA_ENR_STEP_METHOD

Alternate Person ID

ALTERNATE_PERSON_ID

  1. Copy the Alternate Person ID for the Obsolete ID to the Current ID.
  2. Cannot copy the Alternate Person ID because it already exists for the Current ID.
  3. Create Alternate Person Record for the Obsolete ID referring to the Current ID.
  4. Cannot create an Alternate Person Record for the Obsolete ID because a record referring to the Current ID already exists.
  5. Create Alternate Person Record for the Current ID referring to the Obsolete ID.
  6. Cannot create an Alternate Person Record for the Current ID because a record referring to the Obsolete ID already exists.
  7. Copy the Alternate Person ID for the Obsolete ID to the Current ID and delete from the Obsolete ID.

Person Alias

PERSON_ALIAS
  1. Copy the Person Alias record for the Obsolete ID to the Current ID.
  2. Cannot copy the Person Alias for the Obsolete ID to the Current ID because a similar record for the Current ID already exists.
  3. Cannot copy the Person Alias for the Obsolete ID because the details match those already recorded in the Person record for the Current ID.
  4. Create Person Alias record for the Obsolete ID referring to the Current ID.
  5. Cannot create a Person Alias record for the Obsolete ID because a record referring to the Current ID already exists.
  6. Cannot create the Person Alias for the Obsolete ID because the details of the Current ID match the details recorded in the Person record for the Obsolete ID.
  7. Create a Person Alias record for the Current ID referring to the Obsolete ID.
  8. Cannot create a Person Alias record for the Current ID because a record referring to the Obsolete ID already exists.
  9. Cannot create the Person Alias record for the Current ID because details of the Obsolete ID match the details recorded in the Person record for the Current ID.

Outgoing Correspondence

OUTGOING_CORRESPONDENCE
  1. Copy Outgoing Correspondence record for the Obsolete ID to the Current ID.
  2. Cannot copy the Outgoing Correspondence record because an identical record for the Current ID already exists.

Person Notes

PERSON_NOTE
  1. Move the Person Note record for the Obsolete ID to the Current ID.

Student Unit Attempt

STUDENT_UNIT_ATTEMPT
  1. Copy the Student Unit Attempt record for the Obsolete ID to the Current ID.
  2. Cannot copy the Student Unit Attempt record because an identical record for the Current ID already exists.

Person Statistics

PERSON_STATISTICS

  1. Copy the Person Statistics record for the Obsolete ID to the Current ID.
  2. Cannot copy the Person Statistics record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Student Progression Check

STUDENT_PROGRESSION_CHECK
  1. Copy the Student Progression Check record for the Obsolete ID to the Current ID.
  2. Cannot copy the Student Progression Check record because an identical record for the Current ID already exists.

STUDENT_PRG_RULE_CHECK

No action choices; part of STUDENT_PROGRESSION_CHECK.

STUDENT_PROGRESSION_OUTCOME

STUDENT_PRG_COURSE

STUDENT_PRG_UNIT_SET

STUDENT_PRG_UNIT

Student Progression Outcome

STUDENT_PROGRESSION_OUTCOME
  1. Copy the Student Progression Outcome record from the Obsolete ID to the Current ID.
  2. Cannot copy the Progression Outcome record for the Obsolete ID to the Current ID because a similar record for the Current ID already exists.

STUDENT_PRG_COURSE

No action choices; part of STUDENT_PROGRESSION_OUTCOME.

STUDENT_PRG_UNIT_SET

STUDENT_PRG_UNIT

Person Document

PERSON_DOCUMENT
  1. Copy the Person Document from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Document because it already exists for the Current ID.

Student Unit Set Attempt

STUDENT_UNIT_SET_ATTEMPT
  1. Copy the Student Unit Set Attempt from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Unit Set Attempt because it already exists for the Current ID.

Advanced Standing

ADVANCED_STANDING
  1. Copy the Advanced Standing from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing because it already exists for the Current ID.

Advanced Standing Unit

ADV_STND_UNIT
  1. Copy the Advanced Standing Unit from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing Unit because it already exists for the Current ID.

ADV_STND_UNIT_PRECEDENT

No action choices; part of ADV_STND_UNIT.

Advanced Standing Unit Basis

ADV_STND_UNIT_BASIS
  1. Copy the Advanced Standing Unit Basis from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing Unit Basis because it already exists for the Current ID.

Advanced Standing Unit Level

ADV_STND_UNIT_LEVEL
  1. Copy the Advanced Standing Unit Level from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing Unit Level because it already exists for the Current ID.

ADV_STND_UN_LVL_PRECEDENT

No action choices; part of ADV_STND_UNIT_LEVEL.

Advanced Standing Unit Level Basis

ADV_STND_UNIT_LEVEL_BASIS
  1. Copy the Advanced Standing Unit Level Basis from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing Unit Level Basis because it already exists for the Current ID.

Advanced Standing Alternate Unit

ADV_STND_ALT_UNIT
  1. Copy the Advanced Standing Alternate Unit from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing Alternate Unit because it already exists for the Current ID.

Advanced Standing Origin Instance

ADV_STND_ORIGIN_INSTANCE
  1. Copy the Advanced Standing Origin Instance from the Obsolete ID to the Current ID.
  2. Cannot copy the Advanced Standing Origin Instance because it already exists for the Current ID.

Admission Application

ADMISSION_APPL
  1. Copy the Admission Application from the Obsolete ID to the Current ID.

ADM_COURSE_APPL

No action choices; part of ADMISSION_APPL.

ADM_COURSE_APPL_INSTANCE

ADM_APPL_ADM_STEP

ADM_CRS_APPL_INST_CMNT

ADM_CRS_APPL_INST_NOTE

ADM_COURSE_APPL_INSTANCE_UNIT

ACAI_ADVANCED_STANDING

ACAI_ADV_STND_UNIT

ACAI_ADV_STND_ALT_UNIT

ADV_STND_ORIGIN_INSTANCE

ACAI_ADV_STND_UNIT_PRECEDENT

ACAI_ADV_STND_UNIT_LEVEL

ACAI_ADV_STND_UN_LVL_PRECEDENT

ADMISSION_TEST_RESULT

ADMISSION_TEST_SUBSCORE

ENROLMENT_CONFIRMATION

ADM_APPL_ACCESS_EQUITY

ADM_APPL_ADM_STEP

S_PERSON_LETTER

ADMISSION_APPL_LETTER

ADM_APPL_LETTER_PHRASE

OUT_CORRESPONDENCE_REF

ADMISSION_TEST_RESULT

ADMISSION_TEST_SUBSCORE

ADMISSION_INTERNATIONAL_AGENT

ADMISSION_INTERNATIONAL

Student Unit Attempt Outcome

STDNT_UNIT_ATMPT_OUTCOME
  1. Copy the Student Unit Attempt Outcome from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Unit Attempt Outcome because it already exists for the Current ID.

Student Unit Attempt Assessment Item

STDNT_UNIT_ATMPT_ASS_ITEM
  1. Copy the Student Unit Attempt Assessment Item from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Unit Attempt Assessment Item because it already exists for the Current ID.

Applicant Portal Person Match

AP_PERSON_MATCH
  1. Create an Applicant Person Match record to link the CONFIRMED and POTENTIAL Obsolete ID Applicant IDs to the Current ID.
  2. Cannot create the Applicant Person Match record because it already exists for the Current ID.

Person Address

PERSON_ADDR

  1. Copy the Person Address from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Address record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Person Image

PERSON_IMAGE
  1. Copy the Person Image from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Image because it already exists for the Current ID.

Person Concession

PERSON_CONCESSION
  1. Copy the Person Concession from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Concession record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Person Disability

PERSON_DISABILITY
  1. Copy the Person Disability from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Disability record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Person Prior Education

PERSON_PRIOR_EDUCATION
  1. Copy the Person Prior Education from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Prior Education because it already exists for the Current ID.

Person Statistics VET

PERSON_STATISTICS_VET
  1. Copy the Person Statistics VET from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Statistics VET record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Person Encumbrance

PERSON_ENCUMBRANCE
  1. Copy the Person Encumbrance from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Encumbrance record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.
  6. Unable to merge the record as copied as the Obsolete Person Encumbrance child record Start Date is invalid.
  7. Unable to merge the record as Current Person Encumbrance child record Start Date is invalid.

PERSON_ENCUMBRANCE_EFFECT

No action choices; part of PERSON_ENCUMBRANCE.

PERSON_CRS_GRP_EXCLUSION

PERSON_COURSE_EXCLUSION

PERSON_UNIT_EXCLUSION

PERSON_UNIT_REQUIREMENT

PERSON_UNIT_SET_EXCLUSION

Person Service

PERSON_SERVICE
  1. Copy the Person Service from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Service record because a record with the same Start Date for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

PERSON_SERVICE_MULTI_CHC_RESP

No action choices; part of PERSON_SERVICE.

Duplicate Person ID

DUPLICATE_PERSON_ID
  1. Copy the Duplicate Person ID from the Obsolete ID to the Current ID.
  2. Cannot copy the Duplicate Person ID because it already exists for the Current ID.

Student Course Transfer

STUDENT_COURSE_TRANSFER
  1. Copy the Student Course Transfer from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Transfer because it already exists for the Current ID.

Student Unit Transfer

STUDENT_UNIT_TRANSFER
  1. Copy the Student Unit Transfer from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Unit Transfer because it already exists for the Current ID.

Student CHESSN

PERSON_CHESSN
  1. Copy the Person Chessn from the Obsolete ID to the Current ID and set the Obsolete Chessn to INACTIVE.
  2. Cannot copy the Person Chessn because an ACTIVE or PROVISIONL CHESSN already exists for the current person.
  3. Cannot copy the Person Chessn because it is INACTIVE, NOT_APPLIC or INVALID.
  4. Cannot copy the Person Chessn to the current person because the government citizenship status is 4, 5 or 9.
  5. Cannot copy the Person Chessn to the current person because it is in an outstanding HEIMS request.

Student Course Intermission

STUDENT_COURSE_INTERMISSION
  1. Copy the Student Course Intermission from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Intermission because it already exists for the Current ID.

Student Course Attempt Note

STUDENT_CRS_ATMPT_NOTE
  1. Copy the Student Course Attempt Note from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Attempt Note because it already exists for the Current ID.

Student Unit Attempt Note

STUDENT_UNIT_ATMPT_NOTE
  1. Copy the Student Unit Attempt Note from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Unit Attempt Note because it already exists for the Current ID.

Proof Of Participation

PROOF_OF_PARTICIPATION
  1. Copy the Proof Of Participation from the Obsolete ID to the Current ID.
  2. Cannot copy the Proof Of Participation because it already exists for the Current ID.

Student Course Special Requirement

STUDENT_CRS_SPCL_RQRMNT
  1. Copy the Student Course Special Requirement from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Special Requirement because it already exists for the Current ID.

Enrolment Confirmation

ENROLMENT_CONFIRMATION
  1. Copy the Enrolment Confirmation from the Obsolete ID to the Current ID.
  2. Cannot copy the Enrolment Confirmation because it already exists for the Current ID.

Australian Secondary Education

AUS_SCNDRY_EDUCATION
  1. Copy the Australian Secondary Education from the Obsolete ID to the Current ID.
  2. Cannot copy the Australian Secondary Education because it already exists for the Current ID.

AUS_SCNDRY_EDU_SUBJECT

No action choices; part of AUS_SCNDRY_EDUCATION.

AUS_SCNDRY_EDU_OTH_SCORE

Overseas Secondary Education

OS_SCNDRY_EDUCATION
  1. Copy the Overseas Secondary Education from the Obsolete ID to the Current ID.
  2. Cannot copy the Overseas Secondary Education because it already exists for the Current ID.

OS_SCNDRY_EDU_SUBJECT

No action choices; part of OS_SCNDRY_EDUCATION.

Tertiary Education

TERTIARY_EDUCATION
  1. Copy the Tertiary Education from the Obsolete ID to the Current ID.
  2. Cannot copy the Tertiary Education because it already exists for the Current ID.

TERTIARY_EDU_UNIT_ATTEMPT

No action choices; part of TERTIARY_EDUCATION.

Previous Person Institution

PREV_PERSON_INSTN
  1. Copy the Previous Person Institution from the Obsolete ID to the Current ID.
  2. Cannot copy the Previous Person Institution because it already exists for the Current ID.

Employment Detail

EMPLOYMENT_DETAIL
  1. Copy the Employment Detail from the Obsolete ID to the Current ID.
  2. Cannot copy the Employment Detail because it already exists for the Current ID.

Person Other Qualification

PERSON_OTHER_QUALIFICATION
  1. Copy the Person Other Qualification from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Other Qualification because it already exists for the Current ID.

Health Care Cover

HEALTH_CARE_COVER
  1. Copy the Health Care Cover from the Obsolete ID to the Current ID.
  2. Cannot copy the Health Care Cover because it already exists for the Current ID.

International Visa

INTERNATIONAL_VISA

  1. Copy the International Visa from the Obsolete ID to the Current ID.
  2. Cannot copy the International Visa record because a record with the same Start Date and Visa Type for the Current ID already exists.
  3. End Date the Obsolete ID record and copy it to the Current ID.
  4. End Date the Current ID record and copy the Open End Dated record of the Obsolete ID to the Current ID.
  5. Unable to merge the record as there would exist a date overlap.

Student Appeal

STUDENT_APPEAL
  1. Copy the Student Appeal from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Appeal because it already exists for the Current ID.

STUDENT_APPEAL_DCMNT

No action choices; part of STUDENT_APPEAL.

Student Course Attempt Delivery Group

STUDENT_CRS_ATMPT_DELIVERY_GRP
  1. Copy the Student Course Attempt Delivery Group from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Attempt Delivery Group because it already exists for the Current ID.

Student Course Delivery Period Override

STUDENT_CRS_ATMPT_DP_OVRD
  1. Copy the Student Course Delivery Period Override from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Delivery Period Override because it already exists for the Current ID.

Student Course Attempt Delivery Group UOO Override

STUDENT_CRS_ATMPT_DG_UOO_OVRD
  1. Copy the Student Course Attempt Delivery Group UOO Override from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Course Attempt Delivery Group UOO Override because it already exists for the Current ID.

Special Consideration Application

SPCL_CONSIDERATION_APPL
  1. Copy the Special Consideration Application from the Obsolete ID to the Current ID.
  2. Cannot copy the Special Consideration Application because it already exists for the Current ID.

Student Load Variation

STUDENT_LOAD_VARIATION
  1. Copy the Student Load Variation from the Obsolete ID to the Current ID.
  2. Cannot copy the Student Load Variation because it already exists for the Current ID.

STUDENT_LOAD_VARIATION_DCMNT

No action choices; part of STUDENT_LOAD_VARIATION.

Person Bank Account

PERSON_BANK_ACCOUNT

  1. Copy the Person Bank Account from the Obsolete ID to the Current ID.
  2. Cannot copy the Person Bank Account because a bank account already exists for the Current ID.

Person USI

PERSON_USI

  1. Copy the Person USI from the Obsolete ID to the Current ID.
  2. Cannot copy the Person USI because a verified USI already exists for the current person.
  3. Cannot copy the Person USI because a verified or exempt USI does not exist for the obsolete person.
USI_PERSONAL_DETAIL

No action choices; part of PERSON_USI

Graduand Details

GRADUAND

  1. Copy the Graduand Details from the Obsolete ID to the Current ID.
  2. Cannot copy the Graduand Details because a similar record for the Current ID already exists.

GRADUAND_AWARD_CEREMONY

No action choices; part of GRADUAND.


Last Modified on 11 September, 2023 9:10 AM

History Information

Release Information Project Changes to Document
25.0, 25.1 & 26.0 2603 - eCAF Portal Included note about eCAF records not being merged
24.1 & 25.0 2583 - Middle Name Added USI_PERSONAL_DETAIL under PERSON_USI 
24.1 & 25.0 2569 - Campus Transfer Application and Assessment Included note about Campus Transfer Applications not being merged.
24.1.0.0 2449 - Merge Enhancements Updated the table of database tables included in the merge process and added information for Preview Merge Data function.
New information also added for International Visa, Applicant ID, Correspondence Person Address, Person Statistics details and Post Merge Review
20.0.0.2 2330 - Discount on Offer Added PROMOTION_DISCOUNT_ID to list of merged tables
15.0.0.3 1871 - Precedents - Part 2 Added information about the merge process including Advanced Standing Precedent data.
15.0 1668 - Merge ID Process Added further information about the merge process including additional data that will now be merged
12.1.0.1 1400 - Calipso 28759 Updated link to Callista logo in Header
12.0.0.2 1617 - SV - VU FEE-HELP Added note about the inclusion of Fee Maintenance, Funding Source Exempt, and Funding Source Comments data.
12.0.0.2 1647 - AVETMISS Added Govt Industry Code field and note.
10.0.0.0.0.0 C20672 Added 'Note' in first 'Rules/Note' area