Content Comparison

...

• Remove duplicate rows from Employment_file.

• Verify unique information for each set of IDsContact ID. If there are discrepancies, the file should be reviewed by the requester.

...

• Map values from the file to the correct picklist values contained in the specified field.

  • For the Industry field, please map to USYD_Global_Industry__c.

  • Do not forget:

    • AQB__SetAsPrimary__c = TRUE

    • AQB__Status__c = Current or Retired (in accordance the person’s circumstances).

    • AQB__StartDate__c = If information is not given by the requester, the field should be populated with the day the data was received followed by AQB__Started__c = On or Before`.

    • AQB__Source__c = File source + year.

    • AQB__EmployerName__c: If it is blank, replace with “Not Provided”

    • AQB__Title__c: If it is blank, replace with “Not Provided”.

Action Folder Instructions

• Insert Employment folder:

1. Create

...

1. a folder named “Insert Employment.”

2. Filter the Employment_file

...

1. by “Insert Data” from the Action Column

...

1. .

2. Save the filtered file as Employment_file_insert_data

...

1. .

• Data Matching folder:

1. Create

...

1. a folder named “Data Matching.”

2. Filter the Employment_file

...

1. by “Data Matching” from the Action Column

...

1. .

2. Save the filtered file as Employment_file_data_matching

...

1. .

Data Matching Instructions

...

• 100% Match: Use the employment ID to update Jarvis employment data if necessary (e.g., new information from Employment_file_data_matching where the field in Jarvis is blank).
  No further action is needed if the data is already complete.

• > 80% Match or Between 60-80% Match: Conduct a sanity check.

  • If it’s a match, follow the process outlined in step 1.

  • If it’s not a match, add it to Employment_file_insert_data.

• Between 60-80% Match or Isolate for Review: Likely not a match. Manually review to confirm the results and follow the appropriate process as mentioned in step 2.

...

1. Check Employer Account in Jarvis:

   • Before inserting new employment data in Jarvis, verify if the employer has an account in Jarvis to determine the Record Type (Linked Employer or Non-Linked Employer).

2. Input Employer Name:

   • Use the Employment Name Template to input Employer Name from Employment_file_insert_data and Row Number . It’s recommended to use the =UNIQUE function to ensure only unique Employer Names are included.

3. Perform Data Matching:

   • Utilize the Employment Data Matching dashboard to perform data matching. Change the source in the transform data step and refresh the table as per the usual process.

4. Retrieve Data Matching Input File:

   • Obtain the Data Matching input file, which should include the Row Number, Employer Name, Jarvis Account, Jarvis Account ID, Result Comparison, and Record Type ID.

5. Review Matching Results:

   • If the name is not an exact match, the Matching Result column will display “Review”. Filter by this result to determine the appropriate Record Type and Record Type ID.

Getting Information to

...

“Insert Data” and Upload

1. Linked Employer:

   • Use the VLOOKUP function with Employer Name as the key.

   • Retrieve Account ID, and add Linked Employer Record Type ID.
     
     e.g. Data Loader Mapping:

     

...