For more information, please refer to this announcement explaining best practices for getting answers to questions.
Help with Candidate HDL to ORC
Summary
Getting an error when trying to load Candidate Name update via HDLContent
Does anyone know what I'm doing wrong with this HDL Load or have a better way to load to the Nam_Information15 field for candidates?
HDL Template for Candidate Name:
METADATA|CandidateName|PersonNameId|EffectiveStartDate|EffectiveEndDate|PersonId|CandidateNumber|NameType|LegislationCode|CharSetContext|FirstName|LastName|MiddleNames|Suffix|Honors|KnownAs|PreNameAdjunct|MilitaryRank|PreviousLastName|Title|GUID|SourceSystemId|SourceSystemOwner|SourceRefTableName=<source-table-name>|SourceRef001=<source-column-001>|SourceRef002=<source-column-002>|SourceRef003=<source-column-003>|SourceRef004=<source-column-004>|SourceRef005=<source-column-005>|SourceRef006=<source-column-006>|SourceRef007=<source-column-007>|SourceRef008=<source-column-008>|SourceRef009=<source-column-009>|SourceRef010=<source-column-010>
My load attempts:
- METADATA|CandidateName|SourceRefTableName=PER_PERSON_NAMES|SourceRef001=PERSON_ID|SourceRef002=EFFECTIVE_START_DATE|SourceRef003=NAME_TYPE|SourceRef004=NAM_INFORMATION15|SourceRef005=PERSON_NAME_ID|SourceRef006=LEGISLATION_CODE|SourceRef007=LAST_NAME