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

sub-job

CCP · Load-Dimension-Members

called by Daily-Accounts-Processing

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

22 tasks · CCP
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 Dimensionsqlload_dimension_members__load_insurance_dimension.sql
    ✨ Loads the insurance dimension with unique insurance keys and a placeholder for unmapped records to support payer-level analysis.
    writes DimensionMember · reads Insurance
  2. Load SourceInsurance Dimensionsqlload_dimension_members__load_sourceinsurance_dimension.sql
    ✨ Builds the source insurance dimension by linking insurance maps to source system details and financial classifications.
    writes DimensionMember · reads InsuranceMapSourceInsurance
  3. Load FinancialClass Dimensionsqlload_dimension_members__load_financialclass_dimension.sql
    ✨ Loads financial class dimensions by grouping payers into standardized categories based on source utility group definitions.
    writes DimensionMember · reads DimensionMemberSourceUtilGroup
    ↳ feeds from Load ClaimStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load Facility Dimensions, Load FacilityType Dimensions, Load Insurance Dimension, Load PatientAge Dimension, Load PatientSex Dimension, Load PlaceOfService Dimensions, Load Practice Dimensions, Load Provider Dimension, Load ProviderType Dimension, Load QuoteInsurance Dimension, Load SourceInsurance Dimension, Load State Dimension, Load Time Dimensions
  4. Load EligibilityInsurance Dimensionsqlload_dimension_members__load_eligibilityinsurance_dimension.sqldisabled
    ✨ Loads insurance members that support electronic eligibility and benefits verification via API integration.
    writes DimensionMember · reads DimensionMemberInsurance
  5. Load QuoteInsurance Dimensionsqlload_dimension_members__load_quoteinsurance_dimension.sql
    ✨ Builds a dimension of insurance providers associated with active contracts to facilitate accurate patient cost estimates.
    writes DimensionMember · reads ContractMapInsurance
  6. Load Time Dimensionssqlload_dimension_members__load_time_dimensions.sql
    ✨ Builds time dimensions including day, month, and year levels based on the range of service dates in the account data.
    writes DimensionMember · reads TransformAccount
  7. Load VisitStatus Dimensionsqlload_dimension_members__load_visitstatus_dimension.sqldisabled
    ✨ Loads unique appointment statuses into the visit status dimension to categorize and track the current state of patient visits.
    writes DimensionMember · reads TransformVisit
  8. Load DenialCategory Dimensionsqlload_dimension_members__load_denialcategory_dimension.sql
    ✨ Updates the denial category dimension with standardized codes and descriptions to classify and analyze insurance claim rejections.
    writes DimensionMember · reads AdjustmentCodeRollup
  9. Load Provider Dimensionsqlload_dimension_members__load_provider_dimension.sql
    ✨ Loads healthcare provider details and their associated types into the provider dimension for clinical and financial reporting.
    writes DimensionMember · reads Provider
  10. Load ProviderType Dimensionsqlload_dimension_members__load_providertype_dimension.sql
    ✨ Builds the provider type dimension by extracting unique provider categories to enable high-level grouping of medical staff.
    writes DimensionMember · reads DimensionMember
    ↳ feeds from Load ClaimStatus Dimension, Load DenialCategory Dimension, Load DiagnosisCode Dimension, Load Facility Dimensions, Load FacilityType Dimensions, Load FinancialClass Dimension, Load Insurance Dimension, Load PatientAge Dimension, Load PatientSex Dimension, Load PlaceOfService Dimensions, Load Practice Dimensions, Load Provider Dimension, Load QuoteInsurance Dimension, Load SourceInsurance Dimension, Load State Dimension, Load Time Dimensions
  11. Load Facility Dimensionssqlload_dimension_members__load_facility_dimensions.sql
    ✨ Updates the facility dimension with location names and group associations to organize data by specific service sites.
    writes DimensionMember · reads Facility
  12. Load FacilityType Dimensionssqlload_dimension_members__load_facilitytype_dimensions.sql
    ✨ Loads unique facility types into the dimension table to allow for the categorization of different healthcare service locations.
    writes DimensionMember · reads Facility
  13. Load Practice Dimensionssqlload_dimension_members__load_practice_dimensions.sql
    ✨ Populates the practice dimension with unique medical practice names to facilitate reporting across different business entities.
    writes DimensionMember · reads SourceLocation
  14. Load PlaceOfService Dimensionssqlload_dimension_members__load_placeofservice_dimensions.sql
    ✨ Updates the place of service dimension with standardized codes and descriptions for locations where healthcare services were provided.
    writes DimensionMember · reads POSCodesTransformCharge
  15. Load VisitType Dimensionssqlload_dimension_members__load_visittype_dimensions.sqldisabled
    ✨ Loads visit type dimensions from HL7 visit data to standardize appointment categories for reporting.
    writes DimensionMember · reads HL7Visit
  16. Load AccountStatus Dimensionsqlload_dimension_members__load_accountstatus_dimension.sqldisabled
    ✨ Updates account status dimensions using encounter status information to track the lifecycle of patient accounts.
    writes DimensionMember · reads SourceEncounter
  17. Load AllowedStatus Dimensionsqlload_dimension_members__load_allowedstatus_dimension.sqldisabled
    ✨ Builds allowed status dimensions to categorize how actual payments compare to expected insurance contract rates.
    writes DimensionMember
  18. Load ClaimStatus Dimensionsqlload_dimension_members__load_claimstatus_dimension.sql
    ✨ Loads claim status dimensions to define the various stages of the insurance billing and reimbursement process.
    writes DimensionMember
  19. Load DiagnosisCode Dimensionsqlload_dimension_members__load_diagnosiscode_dimension.sql
    ✨ Builds diagnosis code dimensions by extracting codes from account charges and mapping them to standardized medical categories.
    writes DimensionMember · reads AccountChargeDimensionMember
    ↳ feeds from Load ClaimStatus Dimension, Load DenialCategory Dimension, Load Facility Dimensions, Load FacilityType Dimensions, Load FinancialClass Dimension, Load Insurance Dimension, Load PatientAge Dimension, Load PatientSex Dimension, Load PlaceOfService Dimensions, Load Practice Dimensions, Load Provider Dimension, Load ProviderType Dimension, Load QuoteInsurance Dimension, Load SourceInsurance Dimension, Load State Dimension, Load Time Dimensions
  20. Load PatientAge Dimensionsqlload_dimension_members__load_patientage_dimension.sql
    ✨ Loads patient age dimensions by calculating current ages from birth dates to support demographic analysis.
    writes DimensionMember · reads Patient
  21. Load PatientSex Dimensionsqlload_dimension_members__load_patientsex_dimension.sql
    ✨ Loads patient sex dimensions from demographic records to enable gender-based reporting and filtering within the pipeline.
    writes DimensionMember · reads Patient
  22. Load State Dimensionsqlload_dimension_members__load_state_dimension.sql
    ✨ Updates state dimensions using facility location data to allow for geographic segmentation of healthcare services and revenue.
    writes DimensionMember · reads Facility