Outdated: Stage IIa jobs

The Stage IIa jobs are not structurally different from the Stage II jobs.

The following changes are made: 


  • The new warehouse tables Ids, Races, and Relationships replace the use of the temporary export tables XId, XRace, and XRelation in the Extract 2 job.
  • The movement of race data into the AnalyticsMaster table is no longer done. 
  • The new warehouse table OpportunityRequirement is added to the Extract 2 job.
  • The population of the StaffAssignment_Local table is replaced by an update of the OpportunityPerson_Local.