...

...

Employment

...

upload process

Identify Duplicates

• 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.

...

• Check if the primary employment of that Contact was created last modified before or after the Employment_file data Date collection.

1. Download all the data from the Employment object in an Excel sheet (where AQB__SetAsPrimary__c = TRUE) with Contact ID , Start Date, and Created and Last Modified Date.

2. Create a VLOOKUP column in Employment_file to retrieve the Created Last Modified Date from Employment object sheet by running a VLOOKUP on Contact IDs.

3. Create an “Action” column with the following criteria:

   If the Created Last Modified Date is greater than or equal to the Employment_file collection dateDate: No Action (remove from your sheet as newer data is recorded).

   If the Created Last Modified Date is less than the Employment_file collection dateDate: Data Matching.

   If the result is #N/A, it indicates no employment exists in the system for that Contact ID: Insert Data.
   
   * Correct date format if needed (dd/mm/yyyy)

...

• 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 (depends on 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”.

    • Started:On, On or Before

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

...

Instructions for “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:

     

...

Jira Ticket