Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Kevin Tran, Data Engineer (Data Engineer)
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.