db/queries/pipeline
Interfaces
- ActiveEnrollment
- DueTask
- FacilityEnrollment
- FacilityForLead
- FacilityScoringRow
- FacilityTimelineEntry
- FollowUpEmailContext
- InboxSignal
- ProspectRow
- ScoringSignalRow
- SequenceForEnroll
- SequenceStep
- SequenceSummary
Functions
- countTier1Facilities
- deactivateExpiredSignals
- deleteStep
- findActiveEnrollment
- findOpenLeadIdForFacility
- findRecentSiblingSignal
- findSignalByJobUrl
- findSignalBySourceExternal
- getFacilityForLead
- getFacilityScoringRow
- getFollowUpTask
- getFollowUpTaskForEmail
- getMaxStepNo
- getPrimaryCompanyId
- getSequenceForEnroll
- getSignalById
- getTierCutoffs
- insertEnrollment
- insertFacilityAlias
- insertFollowUpTasks
- insertJobSignal
- insertLead
- insertOutboundEmail
- insertSequence
- insertStep
- listActiveEnrollments
- listActiveTargetSignals
- listDueFollowUpTasks
- listEnrollmentsForFacility
- listFacilitiesForScoring
- listFacilityAliases
- listFacilityMatchCandidates
- listFacilityTargetSignals
- listFacilityTimeline
- listProspectFacilityIdsWithSignal
- listProspectsWithoutPosting
- listProspectTier1FacilityIds
- listSequencesWithSteps
- listSignalInboxView
- listSignalsForFacility
- listSignalsForInbox
- listTasksForEnrollment
- listUnmatchedSignals
- setTierCutoffs
- updateEnrollment
- updateFacilityScore
- updateFollowUpTask
- updateJobSignal
- updateSequence
- updateStep
- upsertJobRaw