public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c) { // establish the column mappings between the staging tables and this public table var m = new TableColumnMappings(); m.AddFederatedIdMapping("exam_id"); m.AddExplicitColumnMappingLookup("federated_exam_id", "exam_id", "name", Entity.EsExam); m.AddExplicitColumnMappingLookup("federated_exam_id", "exam_id", "unique_name", Entity.EsExam); m.AddFederatedIdMapping("session_id"); m.AddColumnMappingLookup("session_id", "session_name", Entity.EsSession, c); m.AddEventCatIdAndNameMapping(c); m.AddDeptIdAndNameMapping(c); m.AddFacultyIdAndNameMapping(c); m.AddBooleanMapping("protected"); m.AddBooleanMapping("suspended"); m.AddBooleanMapping("registers_req"); m.AddBooleanMapping(ColumnConstants.RegistersReqResolvedColumnName); m.AddAuditMapping(c); m.AddOriginMapping(); m.AddRemainingSimpleMappings(Columns); return(m); }