segment_site
Base Entity sg_completed_work_chr_data
Attribute Name site_code
ColumnName segment_site
Definition
Note

segment_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


segment_id
Base Entity sg_completed_work_chr_data
Attribute Name segment_id
ColumnName segment_id
Definition
Note

segment_id Logical Attribute Properties
Logical Attribute Name segment_id
Datatype NUMERIC(10, 0)
Nullable NO


task_db_site
Base Entity sg_completed_work_chr_data
Attribute Name site_code
ColumnName task_db_site
Definition
Note

task_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


task_db_id
Base Entity sg_completed_work_chr_data
Attribute Name db_id
ColumnName task_db_id
Definition
Note

task_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype NUMERIC(10, 0)
Nullable NO


task_type_code
Base Entity sg_completed_work_chr_data
Attribute Name task_type_code
ColumnName task_type_code
Definition
Note

task_type_code Logical Attribute Properties
Logical Attribute Name task_type_code
Datatype NUMERIC(10, 0)
Nullable NO


gmt_completed
Base Entity sg_completed_work_chr_data
Attribute Name gmt_completed
ColumnName gmt_completed
Definition
Note

gmt_completed Logical Attribute Properties
Logical Attribute Name gmt_completed
Datatype TIMESTAMP/DATE
Nullable NO


wc_db_site
Base Entity sg_completed_work_chr_data
Attribute Name site_code
ColumnName wc_db_site
Definition
Note

wc_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


wc_db_id
Base Entity sg_completed_work_chr_data
Attribute Name db_id
ColumnName wc_db_id
Definition
Note

wc_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype NUMERIC(10, 0)
Nullable NO


wc_type_code
Base Entity sg_completed_work_chr_data
Attribute Name wc_type_code
ColumnName wc_type_code
Definition
Note

wc_type_code Logical Attribute Properties
Logical Attribute Name wc_type_code
Datatype NUMERIC(10, 0)
Nullable NO


eu_db_site
Base Entity sg_completed_work_chr_data
Attribute Name site_code
ColumnName eu_db_site
Definition
Note

eu_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


eu_db_id
Base Entity sg_completed_work_chr_data
Attribute Name db_id
ColumnName eu_db_id
Definition
Note

eu_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype NUMERIC(10, 0)
Nullable NO


eu_type_code
Base Entity sg_completed_work_chr_data
Attribute Name eu_type_code
ColumnName eu_type_code
Definition
Note

eu_type_code Logical Attribute Properties
Logical Attribute Name eu_type_code
Datatype NUMERIC(10, 0)
Nullable NO


data_value
Base Entity sg_completed_work_chr_data
Attribute Name data_value
ColumnName data_value
Definition
Note

data_value Logical Attribute Properties
Logical Attribute Name data_value
Datatype NVARCHAR(254)
Nullable NO


gmt_last_updated
Base Entity sg_completed_work_chr_data
Attribute Name gmt_last_updated
ColumnName gmt_last_updated
Definition
Note

gmt_last_updated Logical Attribute Properties
Logical Attribute Name gmt_last_updated
Datatype TIMESTAMP/DATE
Nullable YES


last_upd_db_site
Base Entity sg_completed_work_chr_data
Attribute Name site_code
ColumnName last_upd_db_site
Definition
Note

last_upd_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


last_upd_db_id
Base Entity sg_completed_work_chr_data
Attribute Name db_id
ColumnName last_upd_db_id
Definition
Note

last_upd_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype NUMERIC(10, 0)
Nullable YES


rstat_type_code
Base Entity sg_completed_work_chr_data
Attribute Name rstat_type_cod
ColumnName rstat_type_code
Definition
Note

rstat_type_code Logical Attribute Properties
Logical Attribute Name rstat_type_cod
Datatype NUMERIC(5, 0)
Nullable YES