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.AddConsolidatedOrFederatedIdMapping(c, Entity.StaffCat, "staff_cat_id");
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.Supervisor, "supervisor_id");
m.AddBooleanMapping("can_send_sms");
m.AddBooleanMapping("can_send_email");
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.Group, "group_id");
m.AddDeptIdAndNameMapping(c);
m.AddFacultyIdAndNameMapping(c);
m.AddStaff1And2IdAndNameMapping(c);
m.AddSchedulableMapping();
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;
}
