This page contains information about PAHMA's data migration of Object Production Information.
See parent page on PAHMA data migration ETL work.
Production Dates extract
field mapping
TMS table name |
TMS field name |
CSpace field name |
notes |
---|---|---|---|
ObjDates |
DateText |
objectProductionDate_dateDisplayDate |
|
ObjDates |
DateBegSearch |
objectProductionDate_dateEarliestSingleYear |
|
ObjDates |
DateEndSearch |
objectProductionDate_dateLatestYear |
|
ObjDates |
DayBegSearch |
objectProductionDate_dateEarliestSingleDay |
|
ObjDates |
DayEndSearch |
objectProductionDate_dateLatestDay |
|
ObjDates |
MonthBegSearch |
objectProductionDate_dateEarliestSingleMonth |
|
ObjDates |
MonthEndSearch |
objectProductionDate_dateLatestMonth |
|
ObjDates |
Remarks |
objectProductionNote |
|
sql query
view: cs_productiondates
SELECT CAST(d.objectID AS VARCHAR) objectID, d.dateText objectProductionDate_dateDisplayDate, (CASE WHEN d.dateBegSearch != '0' THEN d.dateBegSearch END) objectProductionDate_dateEarliestSingleYear, (CASE WHEN d.dateEndSearch != '0' THEN d.dateEndSearch END) objectProductionDate_dateLatestYear, d.dayBegSearch objectProductionDate_dateEarliestSingleDay, d.dayEndSearch objectProductionDate_dateLatestDay, d.monthBegSearch objectProductionDate_dateEarliestSingleMonth, d.monthEndSearch objectProductionDate_dateLatestMonth, d.remarks objectProductionNote FROM ObjDates d WHERE lower(d.eventType) = 'date made' ;