C# Class org.newpointe.CompositeScoresJob.CompositeScoresJob

Inheritance: IJob

Show file 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 property

public string AttendanceLastWeekCampus
return	string

AttendanceLastWeekLastYearAll public property

public string AttendanceLastWeekLastYearAll
return	string

AttendanceLastWeekLastYearCampus public property

public string AttendanceLastWeekLastYearCampus
return	string

CompositeScore public property

public double? CompositeScore
return	double?

CurrentMonthInFiscalYear public property

public int CurrentMonthInFiscalYear
return	int

FinancialEndDate public property

public string FinancialEndDate
return	string

FinancialEndDateLastWeek public property

public string FinancialEndDateLastWeek
return	string

FinancialStartDate public property

public string FinancialStartDate
return	string

FinancialStartDateLastWeek public property

public string FinancialStartDateLastWeek
return	string

FiscalYearEndDate public property

public string FiscalYearEndDate
return	string

FiscalYearStartDate public property

public string FiscalYearStartDate
return	string

GoalMultiplier public property

public double? GoalMultiplier
return	double?

GoalOffsetMultiplier public property

public double GoalOffsetMultiplier
return	double

GoalTarget public property

public double GoalTarget
return	double

Last6WkEndDate public property

public string Last6WkEndDate
return	string

Last6WkEndDateLy public property

public string Last6WkEndDateLy
return	string

Last6WkStartDate public property

public string Last6WkStartDate
return	string

Last6WkStartDateLy public property

public string Last6WkStartDateLy
return	string

Last8WkEndDate public property

public string Last8WkEndDate
return	string

Last8WkEndDateLy public property

public string Last8WkEndDateLy
return	string

Last8WkStartDate public property

public string Last8WkStartDate
return	string

Last8WkStartDateLy public property

public string Last8WkStartDateLy
return	string

LastPeriodEndDate public property

public string LastPeriodEndDate
return	string

LastPeriodStartDate public property

public string LastPeriodStartDate
return	string

PeriodEndDate public property

public string PeriodEndDate
return	string

PeriodStartDate public property

public string PeriodStartDate
return	string

SecondaryGoalOffsetMultiplier public property

public double SecondaryGoalOffsetMultiplier
return	double

SelectedCampus public property

public string SelectedCampus
return	string

SundayDate public property

public string SundayDate
return	string

SundayDateSQLFormatted public property

public string SundayDateSQLFormatted
return	string

UseGlobalAttributeGoal public property

public bool UseGlobalAttributeGoal
return	bool

dAllCommitments8WkProgress public property

public double? dAllCommitments8WkProgress
return	double?

dCampusGroups8WkProgress public property

public double dCampusGroups8WkProgress
return	double

dDiscoverGroups8WkProgress public property

public double dDiscoverGroups8WkProgress
return	double

dNewHere8WkProgress public property

public double dNewHere8WkProgress
return	double

dNewtoNewPointe8WkProgress public property

public double dNewtoNewPointe8WkProgress
return	double

expenses public property

public double expenses
return	double

giving public property

public double giving
return	double

iAllCommitments public property

public int? iAllCommitments
return	int?

iAllCommitments8Wk public property

public int? iAllCommitments8Wk
return	int?

iAllCommitments8WkLy public property

public int? iAllCommitments8WkLy
return	int?

iAllCommitmentsGoal2020 public property

public int? iAllCommitmentsGoal2020
return	int?

iAllCommitmentsGoalCurrent public property

public int? iAllCommitmentsGoalCurrent
return	int?

iAllCommitmentsGoalProgress public property

public double iAllCommitmentsGoalProgress
return	double

iAllCommitmentsLastYear public property

public int? iAllCommitmentsLastYear
return	int?

iAttendanceAll public property

public int? iAttendanceAll
return	int?

iAttendanceAllGoal2020 public property

public int? iAttendanceAllGoal2020
return	int?

iAttendanceAllGoalCurrent public property

public int? iAttendanceAllGoalCurrent
return	int?

iAttendanceAllGoalProgress public property

public double? iAttendanceAllGoalProgress
return	double?

iAttendanceAllLastYear public property

public int? iAttendanceAllLastYear
return	int?

iAttendanceAud public property

public int? iAttendanceAud
return	int?

iAttendanceAudGoal2020 public property

public int? iAttendanceAudGoal2020
return	int?

iAttendanceAudGoalCurrent public property

public int? iAttendanceAudGoalCurrent
return	int?

iAttendanceAudGoalProgress public property

public double? iAttendanceAudGoalProgress
return	double?

iAttendanceAudLastYear public property

public int? iAttendanceAudLastYear
return	int?

iAttendanceAverage public property

public int? iAttendanceAverage
return	int?

iAttendanceAveragePast6Weeks public property

public int? iAttendanceAveragePast6Weeks
return	int?

iAttendanceChildGoal2020 public property

public int? iAttendanceChildGoal2020
return	int?

iAttendanceChildGoalCurrent public property

public int? iAttendanceChildGoalCurrent
return	int?

iAttendanceChildGoalProgress public property

public double? iAttendanceChildGoalProgress
return	double?

iAttendanceGoal2020 public property

public int? iAttendanceGoal2020
return	int?

iAttendanceGoalCurrent public property

public int? iAttendanceGoalCurrent
return	int?

iAttendanceGoalProgress public property

public int? iAttendanceGoalProgress
return	int?

iAttendanceHighSchool public property

public int? iAttendanceHighSchool
return	int?

iAttendanceHighSchoolGoal2020 public property

public int? iAttendanceHighSchoolGoal2020
return	int?

iAttendanceHighSchoolGoalCurrent public property

public int? iAttendanceHighSchoolGoalCurrent
return	int?

iAttendanceHighSchoolGoalProgress public property

public double? iAttendanceHighSchoolGoalProgress
return	double?

iAttendanceHighSchoolLastYear public property

public int? iAttendanceHighSchoolLastYear
return	int?

iAttendanceKids public property

public int? iAttendanceKids
return	int?

iAttendanceKidsLastYear public property

public int? iAttendanceKidsLastYear
return	int?

iAttendanceLastWeekAll public property

public int? iAttendanceLastWeekAll
return	int?

iAttendanceLastWeekAud public property

public int? iAttendanceLastWeekAud
return	int?

iAttendanceLastWeekChild public property

public int? iAttendanceLastWeekChild
return	int?

iAttendanceLastWeekStudent public property

public int? iAttendanceLastWeekStudent
return	int?

iAttendanceStudentGoal2020 public property

public int? iAttendanceStudentGoal2020
return	int?

iAttendanceStudentGoalCurrent public property

public int? iAttendanceStudentGoalCurrent
return	int?

iAttendanceStudentGoalProgress public property

public double? iAttendanceStudentGoalProgress
return	double?

iAttendanceStudents public property

public int? iAttendanceStudents
return	int?

iAttendanceStudentsLastYear public property

public int? iAttendanceStudentsLastYear
return	int?

iBaptisms public property

public int? iBaptisms
return	int?

iBaptisms8Wk public property

public int? iBaptisms8Wk
return	int?

iBaptisms8WkLy public property

public int? iBaptisms8WkLy
return	int?

iBaptisms8WkProgress public property

public double? iBaptisms8WkProgress
return	double?

iBaptismsGoal2020 public property

public int? iBaptismsGoal2020
return	int?

iBaptismsGoalCurrent public property

public int? iBaptismsGoalCurrent
return	int?

iBaptismsGoalProgress public property

public double iBaptismsGoalProgress
return	double

iBaptismsLastYear public property

public int? iBaptismsLastYear
return	int?

iCampusGroups public property

public int? iCampusGroups
return	int?

iCampusGroups8Wk public property

public int? iCampusGroups8Wk
return	int?

iCampusGroups8WkLy public property

public int? iCampusGroups8WkLy
return	int?

iCampusGroupsGoal2020 public property

public int? iCampusGroupsGoal2020
return	int?

iCampusGroupsGoalCurrent public property

public int? iCampusGroupsGoalCurrent
return	int?

iCampusGroupsGoalProgress public property

public double iCampusGroupsGoalProgress
return	double

iCampusGroupsLastYear public property

public int? iCampusGroupsLastYear
return	int?

iCommitments public property

public int? iCommitments
return	int?

iCommitments8Wk public property

public int? iCommitments8Wk
return	int?

iCommitments8WkLy public property

public int? iCommitments8WkLy
return	int?

iCommitmentsGoal2020 public property

public int? iCommitmentsGoal2020
return	int?

iCommitmentsGoalCurrent public property

public int? iCommitmentsGoalCurrent
return	int?

iCommitmentsGoalProgress public property

public double iCommitmentsGoalProgress
return	double

iCommitmentsLastYear public property

public int? iCommitmentsLastYear
return	int?

iDiscoverGroups public property

public int? iDiscoverGroups
return	int?

iDiscoverGroups8Wk public property

public int? iDiscoverGroups8Wk
return	int?

iDiscoverGroups8WkLy public property

public int? iDiscoverGroups8WkLy
return	int?

iDiscoverGroupsGoal2020 public property

public int? iDiscoverGroupsGoal2020
return	int?

iDiscoverGroupsGoalCurrent public property

public int? iDiscoverGroupsGoalCurrent
return	int?

iDiscoverGroupsGoalProgress public property

public double iDiscoverGroupsGoalProgress
return	double

iDiscoverGroupsLastYear public property

public int? iDiscoverGroupsLastYear
return	int?

iInactiveFollowup public property

public int? iInactiveFollowup
return	int?

iInactiveFollowupComplete public property

public int? iInactiveFollowupComplete
return	int?

iInactiveFollowupIncomplete public property

public int? iInactiveFollowupIncomplete
return	int?

iInactiveFollowupProgress public property

public double iInactiveFollowupProgress
return	double

iInvolvement public property

public int? iInvolvement
return	int?

iInvolvementGoal2020 public property

public int? iInvolvementGoal2020
return	int?

iInvolvementGoalCurrent public property

public int? iInvolvementGoalCurrent
return	int?

iInvolvementGoalProgress public property

public double iInvolvementGoalProgress
return	double

iInvolvementLastYear public property

public int? iInvolvementLastYear
return	int?

iNewHere public property

public int? iNewHere
return	int?

iNewHere8Wk public property

public int? iNewHere8Wk
return	int?

iNewHere8WkLy public property

public int? iNewHere8WkLy
return	int?

iNewHereGoal2020 public property

public int? iNewHereGoal2020
return	int?

iNewHereGoalCurrent public property

public int? iNewHereGoalCurrent
return	int?

iNewHereGoalProgress public property

public double iNewHereGoalProgress
return	double

iNewHereLastYear public property

public int? iNewHereLastYear
return	int?

iNewtoNewPointe public property

public int? iNewtoNewPointe
return	int?

iNewtoNewPointe8Wk public property

public int? iNewtoNewPointe8Wk
return	int?

iNewtoNewPointe8WkLy public property

public int? iNewtoNewPointe8WkLy
return	int?

iNewtoNewPointeGoal2020 public property

public int? iNewtoNewPointeGoal2020
return	int?

iNewtoNewPointeGoalCurrent public property

public int? iNewtoNewPointeGoalCurrent
return	int?

iNewtoNewPointeGoalProgress public property

public double iNewtoNewPointeGoalProgress
return	double

iNewtoNewPointeLastYear public property

public int? iNewtoNewPointeLastYear
return	int?

iPartners public property

public int? iPartners
return	int?

iPartnersGoal2020 public property

public int? iPartnersGoal2020
return	int?

iPartnersGoalCurrent public property

public int? iPartnersGoalCurrent
return	int?

iPartnersGoalProgress public property

public double iPartnersGoalProgress
return	double

iPartnersLastYear public property

public int? iPartnersLastYear
return	int?

iRecommitments public property

public int? iRecommitments
return	int?

iRecommitments8Wk public property

public int? iRecommitments8Wk
return	int?

iRecommitments8WkLy public property

public int? iRecommitments8WkLy
return	int?

iRecommitmentsGoal2020 public property

public int? iRecommitmentsGoal2020
return	int?

iRecommitmentsGoalCurrent public property

public int? iRecommitmentsGoalCurrent
return	int?

iRecommitmentsGoalProgress public property

public double iRecommitmentsGoalProgress
return	double

iRecommitmentsLastYear public property

public int? iRecommitmentsLastYear
return	int?

iSmallGroupLeaders public property

public int? iSmallGroupLeaders
return	int?

iSmallGroupLeadersGoal2020 public property

public int? iSmallGroupLeadersGoal2020
return	int?

iSmallGroupLeadersGoalCurrent public property

public int? iSmallGroupLeadersGoalCurrent
return	int?

iSmallGroupLeadersGoalProgress public property

public double iSmallGroupLeadersGoalProgress
return	double

iSmallGroupLeadersLastYear public property

public int? iSmallGroupLeadersLastYear
return	int?

iSmallGroupParticipants public property

public int? iSmallGroupParticipants
return	int?

iSmallGroupParticipantsGoal2020 public property

public int? iSmallGroupParticipantsGoal2020
return	int?

iSmallGroupParticipantsGoalCurrent public property

public int? iSmallGroupParticipantsGoalCurrent
return	int?

iSmallGroupParticipantsGoalProgress public property

public double iSmallGroupParticipantsGoalProgress
return	double

iSmallGroupParticipantsLastYear public property

public int? iSmallGroupParticipantsLastYear
return	int?

iSmallGroups public property

public int? iSmallGroups
return	int?

iSmallGroupsGoal2020 public property

public int? iSmallGroupsGoal2020
return	int?

iSmallGroupsGoalCurrent public property

public int? iSmallGroupsGoalCurrent
return	int?

iSmallGroupsGoalProgress public property

public double iSmallGroupsGoalProgress
return	double

iSmallGroupsLastYear public property

public int? iSmallGroupsLastYear
return	int?

iVolunteers public property

public int? iVolunteers
return	int?

iVolunteersGoal2020 public property

public int? iVolunteersGoal2020
return	int?

iVolunteersGoalCurrent public property

public int? iVolunteersGoalCurrent
return	int?

iVolunteersGoalProgress public property

public double iVolunteersGoalProgress
return	double

iVolunteersLastYear public property

public int? iVolunteersLastYear
return	int?

sMonth public property

public string sMonth
return	string

sYear public property

public string sYear
return	string