Page Comparison

...

SELECT
 u.objectID, 
u c.fieldValueCSoptionID pahmaEthnographicFileCode
FROM
 ObjUserFields u
 JOIN MTB_EthnographicUseCodes c ON u.FieldValue = c.FieldValue
WHERE
 u.FieldTypeID = 17 
;

notes

...

• pahmaEthnographicFileCode is currently a static term list, but it will be changed to a Concept Authority reference once that authority is available
• TODO: add a few additional options to static term list

Associated Dates extract

this data cannot be imported until v2.1

...