Table: dim_agency

Type: Dimension Columns: 7

Description

Agency information. The data grain is individual child care subsidy agency.

Columns

Column Name Description
agency_id

Unique identifier for the agency

business_id

Unique identifier for the business

agency

The name of the agency

agency_state

The state where the agency is located

agency_county

The county where the agency is located

agency_phone_number

The phone number of the agency

is_agency_archived

Indicates whether the agency is currently archived; enumerated: 'Yes' or 'No'