Legacy Pipeline Atlas worker-1snapshot 2026-07-15

sub-job

PPRM · Load-Dimension-Members

Loads Dimension Members

called by Daily-Visit-Processing

sub-job PPRM/Load-Dimension-Members · db PPRM_ProdMirror · updated 2025-09-17

task tree

What the sub-job runs

Tasks in order, each with what it does — typed stepsfrom the MDClarity task docs (click to open the reference), sub-jobsyou can expand inline (▶) to reveal their own tasks, and SQL steps summarized by Gemini (✨). Every step shows the tables it writes/reads and which earlier step it feeds from(sqlglot lineage).

sub-job

Load-Dimension-Members

18 tasks · PPRM
sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc
  1. Load Insurance Categorysqlload_dimension_members__load_insurance_category.sqldisabled
    ✨ Loads insurance categories into the dimension member table to support reporting by commercial and non-commercial insurance types.
    writes DimensionMember · reads InsuranceCategory
  2. Load Insurancesqlload_dimension_members__load_insurance.sqldisabled
    ✨ Loads individual insurance plans into the dimension member table and maps them to their respective insurance categories.
    writes DimensionMember · reads InsuranceInsuranceCategory
  3. Load EligibilityInsurancesqlload_dimension_members__load_eligibilityinsurance.sqldisabled
    ✨ Updates the eligibility insurance dimension by filtering insurance records for those containing valid electronic benefit API references.
    writes DimensionMember · reads Insurance
  4. Load Facilitysqlload_dimension_members__load_facility.sql
    ✨ Loads facility and location information into the dimension member table to enable data filtering and reporting by service site.
    writes DimensionMember · reads FacilitySourceLocation
  5. Load VisitStatussqlload_dimension_members__load_visitstatus.sql
    ✨ Loads visit status members into the dimension table using appointment status values extracted from transformed visit data.
    writes DimensionMember · reads TransformVisit
  6. Load Provider Dimensionsqlload_dimension_members__load_provider_dimension.sql
    ✨ Builds and updates the Provider dimension by mapping source provider IDs to their respective specialty codes and display names.
    writes DimensionMember · reads ProviderSourceProvider
  7. Load ProviderType Dimensionsqlload_dimension_members__load_providertype_dimension.sql
    ✨ Builds the provider type dimension by extracting unique parent classifications from the existing provider dimension members.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load ChargeType, Load EligibilityServiceType, Load Facility, Load Modifier, Load PayerType Dimension, Load Procedure SubCategory, Load ProcedureCode, Load Provider Dimension, Load State, Load VisitStatus, Load VisitType DimensionMember
  8. Load ChargeTypesqlload_dimension_members__load_chargetype.sql
    ✨ Loads the ChargeType dimension, organizing charge IDs under parent CPT subcategories for reporting and analysis.
    writes DimensionMember · reads ChargeType
  9. Load Procedure SubCategorysqlload_dimension_members__load_procedure_subcategory.sql
    ✨ Builds the procedure subcategory dimension by extracting parent categories from existing charge type records.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load ChargeType, Load EligibilityServiceType, Load Facility, Load Modifier, Load PayerType Dimension, Load ProcedureCode, Load Provider Dimension, Load ProviderType Dimension, Load State, Load VisitStatus, Load VisitType DimensionMember
  10. Load ProcedureCodesqlload_dimension_members__load_procedurecode.sql
    ✨ Builds the ProcedureCode dimension by extracting unique procedure codes from the charge type source data.
    writes DimensionMember · reads ChargeType
  11. Load Modifiersqlload_dimension_members__load_modifier.sql
    ✨ Updates the modifier dimension with codes and descriptions sourced from common procedure modifier reference data.
    writes DimensionMember · reads ProcedureModifier
  12. Load Time - OLDsqlload_dimension_members__load_time_old.sqldisabled
    ✨ Populates time dimensions for days, months, and years based on the range of dates found in appointment records.
    writes DimensionMember · reads SourceAppointment
  13. Load Timesqlload_dimension_members__load_time.sql
    ✨ Executes a stored procedure to initialize and load time-based dimension members starting from a defined historical date.
    · reads load_TimeDimensions
  14. Load EligibilityServiceTypesqlload_dimension_members__load_eligibilityservicetype.sql
    ✨ Loads the EligibilityServiceType dimension with standardized medical service categories used for insurance benefit verification.
    writes DimensionMember
  15. Load PayerType Dimensionsqlload_dimension_members__load_payertype_dimension.sql
    ✨ Updates the PayerType dimension to include specific members for self-pay classifications within the reporting system.
    writes DimensionMember
  16. Load VisitType DimensionMembersqlload_dimension_members__load_visittype_dimensionmember.sql
    ✨ Builds the VisitType dimension from source event data while filtering out specific excluded event identifiers.
    writes DimensionMember · reads SourceEvent
  17. Load OAS Reasonsqlload_dimension_members__load_oas_reason.sqldisabled
    ✨ Builds a list of unique OAS reason codes and display names for use as custom property dimensions.
    writes CustomPropertyMember · reads TransformCustomProperties
  18. Load Statesqlload_dimension_members__load_state.sql
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility