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.AddFederatedIdMapping("event_id");
m.AddFederatedIdMapping("slot_id");
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("attend_time_id");
m.AddFederatedIdMapping("activity_id");
m.AddStudentIdAndNameMapping(c);
m.AddAuditMapping(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.AddExamIdAndNameMapping();
m.AddFederatedIdMapping("event_id");
m.AddRoomIdAndNameMapping(c);
m.AddRoomLayoutIdAndNameMapping(c);
m.AddFederatedIdMapping("slot_id");
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 {
EventExpansion = EventExpansionDefinition.Standard
};
m.AddSimpleMapping("timetable_id", "src_timetable_id");
m.AddSimpleMapping("timetable_event_id", "event_id"); // must come before "event_id" mapping
m.AddFederatedIdMapping("event_id");
m.AddEventStartEndTimeMapping("start_time");
m.AddEventStartEndTimeMapping("end_time");
m.AddSpanIdAndNameMapping();
m.AddEventCatIdAndNameMapping(c);
m.AddDeptIdAndNameMapping(c);
m.AddFacultyIdAndNameMapping(c);
m.AddBooleanMapping("global_event");
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.AddFederatedIdMapping("booking_id");
m.AddResourceIdAndNameMapping();
m.AddBooleanMapping("send_email");
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("activity_id");
m.AddEventInstanceMapping();
m.AddFederatedIdMapping("event_id");
m.AddSimpleMapping("timetable_week", "week");
m.AddBooleanMapping("closed");
m.AddStaffIdAndNameMapping(c);
m.AddBooleanMapping("staff_present");
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 {
EventExpansion = EventExpansionDefinition.Standard
};
m.AddModuleIdAndNameMapping(c);
m.AddFederatedIdMapping("event_id");
m.AddEventStartEndTimeMapping("start_time");
m.AddEventStartEndTimeMapping("end_time");
return(m);
}
public override TableColumnMappings GetColumnMappingsFromStage(DataStoreConfiguration c)
{
var m = new TableColumnMappings {
SpanExpansionRequired = true
};
m.AddFederatedIdMapping("span_id");
m.AddSimpleMapping("timetable_id", "src_timetable_id");
m.AddSimpleMapping("span_name", "name");
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("booking_id");
m.AddUserIdAndNameMapping(c);
m.AddDeptIdAndNameMapping(c);
m.AddEventCatIdAndNameMapping(c);
m.AddBooleanMapping("add_me");
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.AddFederatedIdMapping("mark_id");
m.AddDescriptionMapping();
m.AddMarkDefinition();
m.AddOriginMapping();
m.AddBooleanMapping("precedence");
m.AddBooleanMapping("card");
m.AddBooleanMapping("send_notification");
m.AddRemainingSimpleMappings(Columns);
return(m);
}
