Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Marisol Ortega, Data and Innovation Administrator (CDR Administrator)
View as Administrator Data engineer Utilities steward Police steward
Data catalog / curated / dim_department

curated.dim_department

dim department. 11 rows.
LayerCurated
Source systemCDR
Data ownerData and Innovation Administrator
Data stewardKevin Tran
ClassificationInternal
RefreshNightly
RetentionCurrent version
AccessRoles R1 to R5, row policy P-01

Lineage

Curatedcurated.dim_department

Columns

ColumnTypeClassification
dept_codetext
nametext
data_owner_titletext
data_stewardtext

Quality rules

Rules run on the cleansed source tables upstream.

Sample rows

dept_codenamedata_owner_titledata_steward
UTLUtilitiesUtilities DirectorBrandon Hayes
PWPublic WorksPublic Works DirectorElena Ruiz
DSDevelopment ServicesDevelopment Services DirectorMichael Okafor
PDPolicePolice ChiefJasmine Patel
FDFireFire ChiefRyan Castillo

Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.