C# Class org.newpointe.CompositeScoresJob.CompositeScoresJob

Inheritance: IJob
Exibir arquivo Open project: NewPointe/Rockit

Public Properties

Property Type Description
AttendanceLastWeekCampus string
AttendanceLastWeekLastYearAll string
AttendanceLastWeekLastYearCampus string
CompositeScore double?
CurrentMonthInFiscalYear int
FinancialEndDate string
FinancialEndDateLastWeek string
FinancialStartDate string
FinancialStartDateLastWeek string
FiscalYearEndDate string
FiscalYearStartDate string
GoalMultiplier double?
GoalOffsetMultiplier double
GoalTarget double
Last6WkEndDate string
Last6WkEndDateLy string
Last6WkStartDate string
Last6WkStartDateLy string
Last8WkEndDate string
Last8WkEndDateLy string
Last8WkStartDate string
Last8WkStartDateLy string
LastPeriodEndDate string
LastPeriodStartDate string
PeriodEndDate string
PeriodStartDate string
SecondaryGoalOffsetMultiplier double
SelectedCampus string
SundayDate string
SundayDateSQLFormatted string
UseGlobalAttributeGoal bool
dAllCommitments8WkProgress double?
dCampusGroups8WkProgress double
dDiscoverGroups8WkProgress double
dNewHere8WkProgress double
dNewtoNewPointe8WkProgress double
expenses double
giving double
iAllCommitments int?
iAllCommitments8Wk int?
iAllCommitments8WkLy int?
iAllCommitmentsGoal2020 int?
iAllCommitmentsGoalCurrent int?
iAllCommitmentsGoalProgress double
iAllCommitmentsLastYear int?
iAttendanceAll int?
iAttendanceAllGoal2020 int?
iAttendanceAllGoalCurrent int?
iAttendanceAllGoalProgress double?
iAttendanceAllLastYear int?
iAttendanceAud int?
iAttendanceAudGoal2020 int?
iAttendanceAudGoalCurrent int?
iAttendanceAudGoalProgress double?
iAttendanceAudLastYear int?
iAttendanceAverage int?
iAttendanceAveragePast6Weeks int?
iAttendanceChildGoal2020 int?
iAttendanceChildGoalCurrent int?
iAttendanceChildGoalProgress double?
iAttendanceGoal2020 int?
iAttendanceGoalCurrent int?
iAttendanceGoalProgress int?
iAttendanceHighSchool int?
iAttendanceHighSchoolGoal2020 int?
iAttendanceHighSchoolGoalCurrent int?
iAttendanceHighSchoolGoalProgress double?
iAttendanceHighSchoolLastYear int?
iAttendanceKids int?
iAttendanceKidsLastYear int?
iAttendanceLastWeekAll int?
iAttendanceLastWeekAud int?
iAttendanceLastWeekChild int?
iAttendanceLastWeekStudent int?
iAttendanceStudentGoal2020 int?
iAttendanceStudentGoalCurrent int?
iAttendanceStudentGoalProgress double?
iAttendanceStudents int?
iAttendanceStudentsLastYear int?
iBaptisms int?
iBaptisms8Wk int?
iBaptisms8WkLy int?
iBaptisms8WkProgress double?
iBaptismsGoal2020 int?
iBaptismsGoalCurrent int?
iBaptismsGoalProgress double
iBaptismsLastYear int?
iCampusGroups int?
iCampusGroups8Wk int?
iCampusGroups8WkLy int?
iCampusGroupsGoal2020 int?
iCampusGroupsGoalCurrent int?
iCampusGroupsGoalProgress double
iCampusGroupsLastYear int?
iCommitments int?
iCommitments8Wk int?
iCommitments8WkLy int?
iCommitmentsGoal2020 int?
iCommitmentsGoalCurrent int?
iCommitmentsGoalProgress double
iCommitmentsLastYear int?
iDiscoverGroups int?
iDiscoverGroups8Wk int?
iDiscoverGroups8WkLy int?
iDiscoverGroupsGoal2020 int?
iDiscoverGroupsGoalCurrent int?
iDiscoverGroupsGoalProgress double
iDiscoverGroupsLastYear int?
iInactiveFollowup int?
iInactiveFollowupComplete int?
iInactiveFollowupIncomplete int?
iInactiveFollowupProgress double
iInvolvement int?
iInvolvementGoal2020 int?
iInvolvementGoalCurrent int?
iInvolvementGoalProgress double
iInvolvementLastYear int?
iNewHere int?
iNewHere8Wk int?
iNewHere8WkLy int?
iNewHereGoal2020 int?
iNewHereGoalCurrent int?
iNewHereGoalProgress double
iNewHereLastYear int?
iNewtoNewPointe int?
iNewtoNewPointe8Wk int?
iNewtoNewPointe8WkLy int?
iNewtoNewPointeGoal2020 int?
iNewtoNewPointeGoalCurrent int?
iNewtoNewPointeGoalProgress double
iNewtoNewPointeLastYear int?
iPartners int?
iPartnersGoal2020 int?
iPartnersGoalCurrent int?
iPartnersGoalProgress double
iPartnersLastYear int?
iRecommitments int?
iRecommitments8Wk int?
iRecommitments8WkLy int?
iRecommitmentsGoal2020 int?
iRecommitmentsGoalCurrent int?
iRecommitmentsGoalProgress double
iRecommitmentsLastYear int?
iSmallGroupLeaders int?
iSmallGroupLeadersGoal2020 int?
iSmallGroupLeadersGoalCurrent int?
iSmallGroupLeadersGoalProgress double
iSmallGroupLeadersLastYear int?
iSmallGroupParticipants int?
iSmallGroupParticipantsGoal2020 int?
iSmallGroupParticipantsGoalCurrent int?
iSmallGroupParticipantsGoalProgress double
iSmallGroupParticipantsLastYear int?
iSmallGroups int?
iSmallGroupsGoal2020 int?
iSmallGroupsGoalCurrent int?
iSmallGroupsGoalProgress double
iSmallGroupsLastYear int?
iVolunteers int?
iVolunteersGoal2020 int?
iVolunteersGoalCurrent int?
iVolunteersGoalProgress double
iVolunteersLastYear int?
sMonth string
sYear string

Public Methods

Method Description
CompositeScoresJob ( ) : System
Execute ( IJobExecutionContext context ) : void

Protected Methods

Method Description
CalculateCompositeScore ( ) : double?
CalulateMetrics ( int CampusId ) : void
Get6WkAttendanceAll ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
Get6WkAttendanceAuditorium ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
Get6WkAttendanceHighSchool ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
Get6WkAttendanceKids ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
Get6WkAttendanceStudents ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
GetMetrics ( int metricId, int campusId, System.DateTime startDate, System.DateTime endDate, int type ) : int?
GetMetricsLatest ( int metricId, int campusId, System.DateTime startDate, System.DateTime endDate, int type ) : int?
SaveMetrics ( ) : void

Method Details

CalculateCompositeScore() protected method

protected CalculateCompositeScore ( ) : double?
return double?

CalulateMetrics() protected method

protected CalulateMetrics ( int CampusId ) : void
CampusId int
return void

CompositeScoresJob() public method

public CompositeScoresJob ( ) : System
return System

Execute() public method

public Execute ( IJobExecutionContext context ) : void
context IJobExecutionContext
return void

Get6WkAttendanceAll() protected method

protected Get6WkAttendanceAll ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
campusId int
startDate System.DateTime
endDate System.DateTime
return int?

Get6WkAttendanceAuditorium() protected method

protected Get6WkAttendanceAuditorium ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
campusId int
startDate System.DateTime
endDate System.DateTime
return int?

Get6WkAttendanceHighSchool() protected method

protected Get6WkAttendanceHighSchool ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
campusId int
startDate System.DateTime
endDate System.DateTime
return int?

Get6WkAttendanceKids() protected method

protected Get6WkAttendanceKids ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
campusId int
startDate System.DateTime
endDate System.DateTime
return int?

Get6WkAttendanceStudents() protected method

protected Get6WkAttendanceStudents ( int campusId, System.DateTime startDate, System.DateTime endDate ) : int?
campusId int
startDate System.DateTime
endDate System.DateTime
return int?

GetMetrics() protected method

protected GetMetrics ( int metricId, int campusId, System.DateTime startDate, System.DateTime endDate, int type ) : int?
metricId int
campusId int
startDate System.DateTime
endDate System.DateTime
type int
return int?

GetMetricsLatest() protected method

protected GetMetricsLatest ( int metricId, int campusId, System.DateTime startDate, System.DateTime endDate, int type ) : int?
metricId int
campusId int
startDate System.DateTime
endDate System.DateTime
type int
return int?

SaveMetrics() protected method

protected SaveMetrics ( ) : void
return void

Property Details

AttendanceLastWeekCampus public_oe property

public string AttendanceLastWeekCampus
return string

AttendanceLastWeekLastYearAll public_oe property

public string AttendanceLastWeekLastYearAll
return string

AttendanceLastWeekLastYearCampus public_oe property

public string AttendanceLastWeekLastYearCampus
return string

CompositeScore public_oe property

public double? CompositeScore
return double?

CurrentMonthInFiscalYear public_oe property

public int CurrentMonthInFiscalYear
return int

FinancialEndDate public_oe property

public string FinancialEndDate
return string

FinancialEndDateLastWeek public_oe property

public string FinancialEndDateLastWeek
return string

FinancialStartDate public_oe property

public string FinancialStartDate
return string

FinancialStartDateLastWeek public_oe property

public string FinancialStartDateLastWeek
return string

FiscalYearEndDate public_oe property

public string FiscalYearEndDate
return string

FiscalYearStartDate public_oe property

public string FiscalYearStartDate
return string

GoalMultiplier public_oe property

public double? GoalMultiplier
return double?

GoalOffsetMultiplier public_oe property

public double GoalOffsetMultiplier
return double

GoalTarget public_oe property

public double GoalTarget
return double

Last6WkEndDate public_oe property

public string Last6WkEndDate
return string

Last6WkEndDateLy public_oe property

public string Last6WkEndDateLy
return string

Last6WkStartDate public_oe property

public string Last6WkStartDate
return string

Last6WkStartDateLy public_oe property

public string Last6WkStartDateLy
return string

Last8WkEndDate public_oe property

public string Last8WkEndDate
return string

Last8WkEndDateLy public_oe property

public string Last8WkEndDateLy
return string

Last8WkStartDate public_oe property

public string Last8WkStartDate
return string

Last8WkStartDateLy public_oe property

public string Last8WkStartDateLy
return string

LastPeriodEndDate public_oe property

public string LastPeriodEndDate
return string

LastPeriodStartDate public_oe property

public string LastPeriodStartDate
return string

PeriodEndDate public_oe property

public string PeriodEndDate
return string

PeriodStartDate public_oe property

public string PeriodStartDate
return string

SecondaryGoalOffsetMultiplier public_oe property

public double SecondaryGoalOffsetMultiplier
return double

SelectedCampus public_oe property

public string SelectedCampus
return string

SundayDate public_oe property

public string SundayDate
return string

SundayDateSQLFormatted public_oe property

public string SundayDateSQLFormatted
return string

UseGlobalAttributeGoal public_oe property

public bool UseGlobalAttributeGoal
return bool

dAllCommitments8WkProgress public_oe property

public double? dAllCommitments8WkProgress
return double?

dCampusGroups8WkProgress public_oe property

public double dCampusGroups8WkProgress
return double

dDiscoverGroups8WkProgress public_oe property

public double dDiscoverGroups8WkProgress
return double

dNewHere8WkProgress public_oe property

public double dNewHere8WkProgress
return double

dNewtoNewPointe8WkProgress public_oe property

public double dNewtoNewPointe8WkProgress
return double

expenses public_oe property

public double expenses
return double

giving public_oe property

public double giving
return double

iAllCommitments public_oe property

public int? iAllCommitments
return int?

iAllCommitments8Wk public_oe property

public int? iAllCommitments8Wk
return int?

iAllCommitments8WkLy public_oe property

public int? iAllCommitments8WkLy
return int?

iAllCommitmentsGoal2020 public_oe property

public int? iAllCommitmentsGoal2020
return int?

iAllCommitmentsGoalCurrent public_oe property

public int? iAllCommitmentsGoalCurrent
return int?

iAllCommitmentsGoalProgress public_oe property

public double iAllCommitmentsGoalProgress
return double

iAllCommitmentsLastYear public_oe property

public int? iAllCommitmentsLastYear
return int?

iAttendanceAll public_oe property

public int? iAttendanceAll
return int?

iAttendanceAllGoal2020 public_oe property

public int? iAttendanceAllGoal2020
return int?

iAttendanceAllGoalCurrent public_oe property

public int? iAttendanceAllGoalCurrent
return int?

iAttendanceAllGoalProgress public_oe property

public double? iAttendanceAllGoalProgress
return double?

iAttendanceAllLastYear public_oe property

public int? iAttendanceAllLastYear
return int?

iAttendanceAud public_oe property

public int? iAttendanceAud
return int?

iAttendanceAudGoal2020 public_oe property

public int? iAttendanceAudGoal2020
return int?

iAttendanceAudGoalCurrent public_oe property

public int? iAttendanceAudGoalCurrent
return int?

iAttendanceAudGoalProgress public_oe property

public double? iAttendanceAudGoalProgress
return double?

iAttendanceAudLastYear public_oe property

public int? iAttendanceAudLastYear
return int?

iAttendanceAverage public_oe property

public int? iAttendanceAverage
return int?

iAttendanceAveragePast6Weeks public_oe property

public int? iAttendanceAveragePast6Weeks
return int?

iAttendanceChildGoal2020 public_oe property

public int? iAttendanceChildGoal2020
return int?

iAttendanceChildGoalCurrent public_oe property

public int? iAttendanceChildGoalCurrent
return int?

iAttendanceChildGoalProgress public_oe property

public double? iAttendanceChildGoalProgress
return double?

iAttendanceGoal2020 public_oe property

public int? iAttendanceGoal2020
return int?

iAttendanceGoalCurrent public_oe property

public int? iAttendanceGoalCurrent
return int?

iAttendanceGoalProgress public_oe property

public int? iAttendanceGoalProgress
return int?

iAttendanceHighSchool public_oe property

public int? iAttendanceHighSchool
return int?

iAttendanceHighSchoolGoal2020 public_oe property

public int? iAttendanceHighSchoolGoal2020
return int?

iAttendanceHighSchoolGoalCurrent public_oe property

public int? iAttendanceHighSchoolGoalCurrent
return int?

iAttendanceHighSchoolGoalProgress public_oe property

public double? iAttendanceHighSchoolGoalProgress
return double?

iAttendanceHighSchoolLastYear public_oe property

public int? iAttendanceHighSchoolLastYear
return int?

iAttendanceKids public_oe property

public int? iAttendanceKids
return int?

iAttendanceKidsLastYear public_oe property

public int? iAttendanceKidsLastYear
return int?

iAttendanceLastWeekAll public_oe property

public int? iAttendanceLastWeekAll
return int?

iAttendanceLastWeekAud public_oe property

public int? iAttendanceLastWeekAud
return int?

iAttendanceLastWeekChild public_oe property

public int? iAttendanceLastWeekChild
return int?

iAttendanceLastWeekStudent public_oe property

public int? iAttendanceLastWeekStudent
return int?

iAttendanceStudentGoal2020 public_oe property

public int? iAttendanceStudentGoal2020
return int?

iAttendanceStudentGoalCurrent public_oe property

public int? iAttendanceStudentGoalCurrent
return int?

iAttendanceStudentGoalProgress public_oe property

public double? iAttendanceStudentGoalProgress
return double?

iAttendanceStudents public_oe property

public int? iAttendanceStudents
return int?

iAttendanceStudentsLastYear public_oe property

public int? iAttendanceStudentsLastYear
return int?

iBaptisms public_oe property

public int? iBaptisms
return int?

iBaptisms8Wk public_oe property

public int? iBaptisms8Wk
return int?

iBaptisms8WkLy public_oe property

public int? iBaptisms8WkLy
return int?

iBaptisms8WkProgress public_oe property

public double? iBaptisms8WkProgress
return double?

iBaptismsGoal2020 public_oe property

public int? iBaptismsGoal2020
return int?

iBaptismsGoalCurrent public_oe property

public int? iBaptismsGoalCurrent
return int?

iBaptismsGoalProgress public_oe property

public double iBaptismsGoalProgress
return double

iBaptismsLastYear public_oe property

public int? iBaptismsLastYear
return int?

iCampusGroups public_oe property

public int? iCampusGroups
return int?

iCampusGroups8Wk public_oe property

public int? iCampusGroups8Wk
return int?

iCampusGroups8WkLy public_oe property

public int? iCampusGroups8WkLy
return int?

iCampusGroupsGoal2020 public_oe property

public int? iCampusGroupsGoal2020
return int?

iCampusGroupsGoalCurrent public_oe property

public int? iCampusGroupsGoalCurrent
return int?

iCampusGroupsGoalProgress public_oe property

public double iCampusGroupsGoalProgress
return double

iCampusGroupsLastYear public_oe property

public int? iCampusGroupsLastYear
return int?

iCommitments public_oe property

public int? iCommitments
return int?

iCommitments8Wk public_oe property

public int? iCommitments8Wk
return int?

iCommitments8WkLy public_oe property

public int? iCommitments8WkLy
return int?

iCommitmentsGoal2020 public_oe property

public int? iCommitmentsGoal2020
return int?

iCommitmentsGoalCurrent public_oe property

public int? iCommitmentsGoalCurrent
return int?

iCommitmentsGoalProgress public_oe property

public double iCommitmentsGoalProgress
return double

iCommitmentsLastYear public_oe property

public int? iCommitmentsLastYear
return int?

iDiscoverGroups public_oe property

public int? iDiscoverGroups
return int?

iDiscoverGroups8Wk public_oe property

public int? iDiscoverGroups8Wk
return int?

iDiscoverGroups8WkLy public_oe property

public int? iDiscoverGroups8WkLy
return int?

iDiscoverGroupsGoal2020 public_oe property

public int? iDiscoverGroupsGoal2020
return int?

iDiscoverGroupsGoalCurrent public_oe property

public int? iDiscoverGroupsGoalCurrent
return int?

iDiscoverGroupsGoalProgress public_oe property

public double iDiscoverGroupsGoalProgress
return double

iDiscoverGroupsLastYear public_oe property

public int? iDiscoverGroupsLastYear
return int?

iInactiveFollowup public_oe property

public int? iInactiveFollowup
return int?

iInactiveFollowupComplete public_oe property

public int? iInactiveFollowupComplete
return int?

iInactiveFollowupIncomplete public_oe property

public int? iInactiveFollowupIncomplete
return int?

iInactiveFollowupProgress public_oe property

public double iInactiveFollowupProgress
return double

iInvolvement public_oe property

public int? iInvolvement
return int?

iInvolvementGoal2020 public_oe property

public int? iInvolvementGoal2020
return int?

iInvolvementGoalCurrent public_oe property

public int? iInvolvementGoalCurrent
return int?

iInvolvementGoalProgress public_oe property

public double iInvolvementGoalProgress
return double

iInvolvementLastYear public_oe property

public int? iInvolvementLastYear
return int?

iNewHere public_oe property

public int? iNewHere
return int?

iNewHere8Wk public_oe property

public int? iNewHere8Wk
return int?

iNewHere8WkLy public_oe property

public int? iNewHere8WkLy
return int?

iNewHereGoal2020 public_oe property

public int? iNewHereGoal2020
return int?

iNewHereGoalCurrent public_oe property

public int? iNewHereGoalCurrent
return int?

iNewHereGoalProgress public_oe property

public double iNewHereGoalProgress
return double

iNewHereLastYear public_oe property

public int? iNewHereLastYear
return int?

iNewtoNewPointe public_oe property

public int? iNewtoNewPointe
return int?

iNewtoNewPointe8Wk public_oe property

public int? iNewtoNewPointe8Wk
return int?

iNewtoNewPointe8WkLy public_oe property

public int? iNewtoNewPointe8WkLy
return int?

iNewtoNewPointeGoal2020 public_oe property

public int? iNewtoNewPointeGoal2020
return int?

iNewtoNewPointeGoalCurrent public_oe property

public int? iNewtoNewPointeGoalCurrent
return int?

iNewtoNewPointeGoalProgress public_oe property

public double iNewtoNewPointeGoalProgress
return double

iNewtoNewPointeLastYear public_oe property

public int? iNewtoNewPointeLastYear
return int?

iPartners public_oe property

public int? iPartners
return int?

iPartnersGoal2020 public_oe property

public int? iPartnersGoal2020
return int?

iPartnersGoalCurrent public_oe property

public int? iPartnersGoalCurrent
return int?

iPartnersGoalProgress public_oe property

public double iPartnersGoalProgress
return double

iPartnersLastYear public_oe property

public int? iPartnersLastYear
return int?

iRecommitments public_oe property

public int? iRecommitments
return int?

iRecommitments8Wk public_oe property

public int? iRecommitments8Wk
return int?

iRecommitments8WkLy public_oe property

public int? iRecommitments8WkLy
return int?

iRecommitmentsGoal2020 public_oe property

public int? iRecommitmentsGoal2020
return int?

iRecommitmentsGoalCurrent public_oe property

public int? iRecommitmentsGoalCurrent
return int?

iRecommitmentsGoalProgress public_oe property

public double iRecommitmentsGoalProgress
return double

iRecommitmentsLastYear public_oe property

public int? iRecommitmentsLastYear
return int?

iSmallGroupLeaders public_oe property

public int? iSmallGroupLeaders
return int?

iSmallGroupLeadersGoal2020 public_oe property

public int? iSmallGroupLeadersGoal2020
return int?

iSmallGroupLeadersGoalCurrent public_oe property

public int? iSmallGroupLeadersGoalCurrent
return int?

iSmallGroupLeadersGoalProgress public_oe property

public double iSmallGroupLeadersGoalProgress
return double

iSmallGroupLeadersLastYear public_oe property

public int? iSmallGroupLeadersLastYear
return int?

iSmallGroupParticipants public_oe property

public int? iSmallGroupParticipants
return int?

iSmallGroupParticipantsGoal2020 public_oe property

public int? iSmallGroupParticipantsGoal2020
return int?

iSmallGroupParticipantsGoalCurrent public_oe property

public int? iSmallGroupParticipantsGoalCurrent
return int?

iSmallGroupParticipantsGoalProgress public_oe property

public double iSmallGroupParticipantsGoalProgress
return double

iSmallGroupParticipantsLastYear public_oe property

public int? iSmallGroupParticipantsLastYear
return int?

iSmallGroups public_oe property

public int? iSmallGroups
return int?

iSmallGroupsGoal2020 public_oe property

public int? iSmallGroupsGoal2020
return int?

iSmallGroupsGoalCurrent public_oe property

public int? iSmallGroupsGoalCurrent
return int?

iSmallGroupsGoalProgress public_oe property

public double iSmallGroupsGoalProgress
return double

iSmallGroupsLastYear public_oe property

public int? iSmallGroupsLastYear
return int?

iVolunteers public_oe property

public int? iVolunteers
return int?

iVolunteersGoal2020 public_oe property

public int? iVolunteersGoal2020
return int?

iVolunteersGoalCurrent public_oe property

public int? iVolunteersGoalCurrent
return int?

iVolunteersGoalProgress public_oe property

public double iVolunteersGoalProgress
return double

iVolunteersLastYear public_oe property

public int? iVolunteersLastYear
return int?

sMonth public_oe property

public string sMonth
return string

sYear public_oe property

public string sYear
return string