Feeds
Table of Contents
Overview
A feed is a workflow used by our client to bulk-load data into our applications. This document provides information on the various feeds you may encounter while working at PBC.
Each night(?) feed jobs are automatically run via SSIS packages. Data is transferred from the SOBI and Vista tables to our PBC tables so the client can view it in our applications.
QUAD Feed
Relevant Files
SSIS Packages
- QUAD_Load_Sample.dtsx: This is the main package involved in this particular feed job. It triggers the execution of the other four packages in this list.
- CIM_IntakeForm_BenefitInventory.dtsx
- CIM_IntakeForm_CDS.dtsx
- CIM_IntakeForm_E2E.dtsx
- CIM_IntakeForm_OnBase.dtsx
SQL
Tables
CEM
- smart.p11_CIM_IntakeForm_BenefitInventory
- smart.p11_CIM_IntakeForm_CDS
- smart.p11_CDS_IntakeForm
- dbo.CDS_FundType_Excel
- dbo.CDS_FundType_QUAD
- dbo.CDS_FundType_Arrangement
- smart.p11_CIM_IntakeForm_E2E
- smart.p11_CIM_IntakeForm_OnBase
- smart.p11_CIM_IntakeForm_OnBase_NoBO
- smart.p11_CIM_IntakeForm_Fallout
- smart.p11_CIM_FeedLog
SOBI
- CIM_IntakeForm_CDS
Other (Raw Vista Feed)
- dbo.CIM_IntakeForm_BenefitInventory
- CaseInstall.Account
- CDB.AccountProductFunding
- CDB.FundingArrangement
- dbo.QUAD_OnBase
Stored Procedures
CEM
- smart.p11_Update_BenefitInventory_Population
- smart.p11_Update_CDS_Population
- smart.p11_Update_E2E_Population
- smart.p11_Update_OnBase_Population
Other (Raw Vista Feed)
- dbo.QUAD_Update_OnBase