Spreadsheet: 733491d1621600356-trying-to-pull-additional-source-data-using-ssn-as-the-common-value-from-source-sampleworkbook
Sheet: BuildSheet

FIRST.NAME | LAST.NAME | MIDDLE.INIT | BIRTH.DATE | COMPANY.ID | EMPLOYER.ID | ETHNIC.CODE | MARITAL.STATUS | TOBACCO/SMOKER | ADDR.ONE | [NAME] | ZIP.CODE | CITY | STATE | TELEPHONE | HANDICAPPED | BLIND | VIETNAM.VET | DISABLED.VET | CITIZEN | GENDER | EMERGENCY.CONTACT | EMERGENCY.PHONE | EMERGENCY.RELATION | SOC.SEC.NUM | STATUS.CODE | TYPE.CODE | LOCATION.CODE | JOB.CODE | ORIG.HIRE | LAST.HIRE | PEO.START.DT | EMPLOYEE.NO | WORK.PHONE | WORK.EXT | MAIL.ADDR.ONE | MAIL.ADDR.TWO | [NAME] | MAIL.STATE | MAIL.ZIP | SHIFT.CODE | WORK.GROUP | PAY.METHOD | EXT.PAY.RATE | STD HOURS | EIC.FILING.STATUS | FEDERAL.STATUS | FEDERAL.ALLOWS | EXTRA.FEDERAL | HOME.STATE STATUS | HOME.STATE.ALLOWS | HOME.STATE.ADDITONAL.AMOUNT | WORK.STATE.STATUS | WORK.STATE.ALLOWS | WORK.STATE.ADDITIONAL.AMOUNT | OFFICER | DEPT.CODE | TERM.DATE | TERM. CODE | EMAIL.ADDRESS | BENEFIT.GROUP | USER.FIELD.1 | USER.FIELD.2 | USER.FIELD.3 | USER.FIELD.4 | USER.FIELD.5 | ZIP SUFFIX | ALT CALC  HOME STATE CODE | ALT CALC WORKSTATE CODE | 1099 EMPLOYEE | PAY.GROUP | DIVISION.CODE | PROJECT.CODE | AUTO.PAY | AUTO.PAY.HOURS | HOME.STATE.EXEMPT.AMOUNT | HOME.STATE.SECONDARY.ALLOWS | HOME.STATE.SUPP.AMOUNT | WORK.STATE.EXEMPT.AMOUNT | WORK.STATE.SECONDARY.ALLOWS | WS.SUPP.AMOUNT | PAY.PERIOD | VETERAN | NEWLY.SEPARATED.VET | SERVICE.MEDAL.VET | [NAME] | I9.DOCUMENT.TITLE.A | I9.DOCUMENT.NUMBER.A | I9.ISSUING.AUTHORITY.A | I9.EXPIRATION.DATE.A | I9.DOCUMENT.TITLE.B | I9.DOCUMENT.NUMBER.B | I9.ISSUING.AUTHORITY.B | I9.EXPIRATION.DATE.B | ALIEN.REG.NO | FICA.EXEMPT | UNION.CODE | SUPERVISOR.ID | BENE.THRU.DATE | SCHOOL.DISTRICT | AGRICULTURAL | HOME.PHONE.2 | [NAME] | [NAME] | ALT.PAYRATE.3 | ALT.PAYRATE.4 | ALT.PAYRATE.5 | ALT.PAYRATE.6 | ALT.PAYRATE.7 | ALT.PAYRATE.8 | ALT.PAYRATE.9 | ALT.PAYRATE.10 | NEW.HIRE.RPT.DATE | MAIL.CHECK.HOME | W2.ADDRESS.ONE | W2.ADDRESS.TWO | W2.CITY | W2.STATE | W2.ZIP.CODE | [NAME] | LICENSE.EXPIRE.DATE | LICENSE.STATE | S.CORP.PRINCIPAL | ELECTRONIC.PAY.STUB | ELECTRONIC.W2.FORM | [NAME] | ALLOC.LOCATION.2 | [NAME] | ALLOC.LOCATION.4 | ALLOC.LOCATION.5 | [NAME] | ALLOC.DIVISION.2 | [NAME] | ALLOC.DIVISION.4 | ALLOC.DIVISION.5 | ALLOC.DEPARTMENT.1 | ALLOC.DEPARTMENT.2 | ALLOC.DEPARTMENT.3 | ALLOC.DEPARTMENT.4 | ALLOC.DEPARTMENT.5 | ALLOC.PROJECT.1 | ALLOC.PROJECT.2 | ALLOC.PROJECT.3 | ALLOC.PROJECT.4 | ALLOC.PROJECT.5 | ALLOC.JOBS.1 | ALLOC.JOBS.2 | ALLOC.JOBS.3 | ALLOC.JOBS.4 | ALLOC.JOBS.5 | ALLOC.PERCENTS.1 | ALLOC.PERCENTS.2 | ALLOC.PERCENTS.3 | ALLOC.PERCENTS.4 | ALLOC.PERCENTS.5 | ONHRP.ONBOARDED | HANDBK.RCD | LAST.REVIEW | NEXT.REVIEW | NICKNAME | WORK.EMAIL | BEN.EMAIL.OPT.IN.DATE | BENEFITS.EMAIL.ADDRESS | USE.ADDED.I9.VALUES | FED.W4.FILE | FED.W4.YEAR | FED.W5.FILE | FED.W5.YEAR | FORM.I9 | I9.FROM.OB | I9.RENEW.DATE | I9.START.DATE | I9.LAST.NAME | I9.FIRST.NAME | [NAME] | I9.OTHER.NAME.USED | I9.SSN | I9.DOB | I9.ELIG2.DOCMNT | I9.ELIG2.AUTH.NAME | I9.ELIG2.DOCNO | I9.ELIG2.DOC.EXP | I9.ELIG3.DOCMNT | I9.ELIG3.AUTH.NAME | I9.ELIG3.DOCNO | I9.ELIG3.DOC.EXP | CITIZEN.STATUS | FOREIGN.PASSPORT.NO | FOREIGN.PASSPORT.COUNTRY | I94.ADMISSION.NO | ALIEN.REG.EXP | NONRES.ALIEN | HNDBK.MAILED | BCKGRND.TEST.DATE | BCKGRND.TEST.DONE | FORM.C112.SIGNED | PSD.CODE | IGNORE.STATE.TAX.ERRORS.FLAG | CROSS.COMPANY.EID | MULTIPLE.JOBS.FED | CLAIM.DEPENDENTS.FED | OTHER.INCOME.FED | DEDUCTIONS.FED | WS.MULTIPLE.JOBS | WS.CLAIM.DEPENDENTS | WS.OTHER.INCOME | WS.DEDUCTIONS | HS.MULTIPLE.JOBS | HS.CLAIM.DEPENDENTS | HS.OTHER.INCOME | HS.DEDUCTIONS | SENIORITY.DATE | CLOCK.NO