FEDPASS: System Integrations and Scheduled Jobs

System Integrations

Through its functionality and integrations, FEDPASS ties together disparate systems and datasets to provide full traceability for IT Portfolio Management on one platform, working to- 

• Streamline data management
• Reduce redundancies/inefficiencies
• Improve efficacy
   

Scheduled Jobs:

In conjunction with the aforementioned system integrations, the following jobs are scheduled within FEDPASS:

Title	Description	Frequency
ActualsDataImport	Imports the Contract and FTE actuals data	At 3:30 AM, Everyday
BudgetItems.AwaitingReviewEmail Schedule	Sends out the 'New Budget Items created in FEDPASS are Awaiting Review' email	At 05:00 PM, only on Tuesday and Friday
CPMAdjustments.ApprovalReminderEmail	Sends out the 'CPM Adjustments awaiting approval' email	At 6:00 AM, Everyday
CPMAdjustments.AutoApprovedListEmail	Sends out the 'Adjustments Have Been Auto-Approved' email	At 03:00 PM, only on Friday
CPMImport.Read.Schedule	Imports the CPM Transactions data sent from BFS	At 1:00 AM, Everyday
DataAsset.RequestForPeriodicDataAssetValidation	Sends out the 'Request for Periodic Data Asset Validation' email	At 6:00 AM, on the 1st day of the month, every 3 months
DomainUsersImport	Imports the domain users data (add new, delete removed, and update existing)	At 4:30 AM, Everyday
DSC.RequestorContactDateReminderEmail	Sends out the 'Next Planned Contact with the Requestor is Due in 5 Days' email	At 6:00 AM, Everyday
FAIMISSpendPlanLoad.Schedule	Imports the FAIMIS Spend Plan data (Funding Alignments, Funding Lines, Contract Tasks, etc.)	At 1:00 AM, Everyday
Import Contracts From BFS	Imports the contracts data from BFS	At 5:00 AM, Everyday
MDMOrganizationsImport.Read.Schedule	Imports the MDM Organizations data sent from BFS	At 1:00 AM, Everyday
PrepareForMonthlySubmissions.ReminderEmail.Schedule	Sends out the 'Update Investment Data Ahead of CPIC Monthly Submissions' email	At 03:00 AM, on day 14 and 21 of the month
ProjectHealthIndicatorLog.Delete	Clears data from the ProjectHealthIndicatorLog table after a set number of days	At 03:00 AM, Everyday
ProjectHealthIndicatorLog.Update	Updates the ProjectHealthIndicators table with the latest data	At 03:00 AM, Everyday
PublishStatusFeed	Clears Status Feed and Publishes the snapshot of the status feed at the set time	6pm, every other Monday
Recalculate PMM Project Health Indicators	Recalculates the Project Health Indicators for PMM Project/Activity	At 05:30 AM, Everyday
RecalculateAllLedgers	Recalculates all ledgers for all investments	At 11:00 PM, Everyday
Update BFSComponentOrganizationFinancialData Table	Update BFSComponentOrganizationFinancialData Table	At 02:50 AM, Everyday
Update BudgetRecordDetailView	Update BudgetRecordDetailView View	At 06:30 AM, Everyday
Update PMMProjectList Table	Update PMMProjectList Table	At 05:50 AM, Everyday
Update UserEPIDAndCAC Table	Update UserEPIDAndCAC Table	At 05:50 AM, Everyday