...
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
ObjTitles | Title | title |
|
ObjTitles | LanguageID | titleLanguage | FK to Languages |
ObjTitles | TitleTypeID | titleNote titleType | FK to TitleTypes |
sql query
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT u.objectID, c.CSoptionID 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
...