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

sub-job

SunLife · Load-Dimension-Members

Loads Dimension Members

called by Daily-Visits-Processing

sub-job SunLife/Load-Dimension-Members · db SunLife_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

16 tasks · SunLife
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.sql
    ✨ Loads insurance dimension members and categorizes them as medical or dental based on their display names.
    writes DimensionMember · reads Insurance
  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 dimension members from source facility data to maintain a consistent list of healthcare locations.
    writes DimensionMember · reads FacilitySourceFacilities
  5. Load VisitStatussqlload_dimension_members__load_visitstatus.sql
    ✨ Loads visit status dimension members to track and report on the current state of patient encounters.
    writes DimensionMember · reads SourceVisitStatus
  6. Load Provider Dimensionsqlload_dimension_members__load_provider_dimension.sql
    ✨ Loads provider dimension members and maps them to their respective medical specialties for organizational reporting.
    writes DimensionMember · reads ProviderSourceDoctors
  7. Load ProviderType Dimensionsqlload_dimension_members__load_providertype_dimension.sql
    ✨ Builds provider type dimension members by extracting unique specialty categories from the existing provider dimension.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load ChargeType, Load Facility, Load Insurance, Load Modifier, Load Procedure SubCategory, Load ProcedureCode, Load Provider Dimension, Load State DimensionMember, Load Time, Load VisitStatus, Load VisitType DimensionMember
  8. Load ChargeTypesqlload_dimension_members__load_chargetype.sql
    ✨ Loads charge type dimension members and assigns parent categories based on procedure code suffixes.
    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 Facility, Load Insurance, Load Modifier, Load ProcedureCode, Load Provider Dimension, Load ProviderType Dimension, Load State DimensionMember, Load Time, Load VisitStatus, Load VisitType DimensionMember
  10. Load ProcedureCodesqlload_dimension_members__load_procedurecode.sql
    ✨ Loads unique procedure code dimension members extracted from charge type records for billing and clinical tracking.
    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 Timesqlload_dimension_members__load_time.sql
    ✨ Builds time dimension members for days, months, and years to support temporal analysis of encounter data.
    writes DimensionMember · reads SourceEncounter
  13. Load EligibilityServiceTypesqlload_dimension_members__load_eligibilityservicetype.sqldisabled
    ✨ Loads the EligibilityServiceType dimension with standardized medical service categories used for insurance benefit verification.
    writes DimensionMember
  14. Load PayerType Dimensionsqlload_dimension_members__load_payertype_dimension.sqldisabled
    ✨ Updates the PayerType dimension to include specific members for self-pay classifications within the reporting system.
    writes DimensionMember
  15. Load VisitType DimensionMembersqlload_dimension_members__load_visittype_dimensionmember.sql
    ✨ Builds or updates visit type dimension members to categorize encounters within the reporting system.
    writes DimensionMember · reads SourceVisitCodes
  16. Load State DimensionMembersqlload_dimension_members__load_state_dimensionmember.sql
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility