public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c) { // establish the column mappings between the staging tables and this public table var m = new TableColumnMappings(); m.AddConsolidatedOrFederatedIdMapping(c, Entity.Site, "site_id1"); m.AddColumnMappingLookup("site_id1", "site_name1", ConsolidationType.Site, c); m.AddConsolidatedOrFederatedIdMapping(c, Entity.Site, "site_id2"); m.AddColumnMappingLookup("site_id2", "site_name2", ConsolidationType.Site, c); m.AddRemainingSimpleMappings(Columns); return(m); }
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); }
public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c) { // establish the column mappings between the staging tables and this public table var m = new TableColumnMappings(); m.AddConsolidatedOrFederatedIdMapping(c, Entity.EventCat, "event_cat_id"); m.AddColumnMappingLookup("event_cat_id", "name", ConsolidationType.EventCat, c); m.AddBooleanMapping("registers_req"); m.AddBooleanMapping(ColumnConstants.RegistersReqResolvedColumnName); m.AddAuditMapping(c); m.AddOriginMapping(); m.AddRemainingSimpleMappings(Columns); return(m); }
public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c) { // establish the column mappings between the staging tables and this public table var m = new TableColumnMappings(); m.AddConsolidatedOrFederatedIdMapping(c, Entity.User, "user_id"); m.AddColumnMappingLookup("user_id", "name", Entity.User, c); m.AddDeptIdAndNameMapping(c); m.AddFacultyIdAndNameMapping(c); m.AddStaffIdAndNameMapping(c); m.AddStudentIdAndNameMapping(c); m.AddBooleanMapping("active"); m.AddBooleanMapping("booking_admin"); m.AddAuditMapping(c); m.AddRemainingSimpleMappings(Columns); return m; }