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