segment_site |
Base Entity | sg_completed_work_chr_data |
Attribute Name | site_code |
Definition |
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 |
Definition |
segment_id Logical Attribute Properties |
Logical Attribute Name | segment_id |
Datatype | INTEGER |
Nullable | NO |
task_db_site |
Base Entity | sg_completed_work_chr_data |
Attribute Name | site_code |
Definition |
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 |
Definition |
task_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | INTEGER |
Nullable | NO |
task_type_code |
Base Entity | sg_completed_work_chr_data |
Attribute Name | task_type_code |
Definition |
task_type_code Logical Attribute Properties |
Logical Attribute Name | task_type_code |
Datatype | INTEGER |
Nullable | NO |
gmt_completed |
Base Entity | sg_completed_work_chr_data |
Attribute Name | gmt_completed |
Definition |
gmt_completed Logical Attribute Properties |
Logical Attribute Name | gmt_completed |
Datatype | DATETIME |
Nullable | NO |
wc_db_site |
Base Entity | sg_completed_work_chr_data |
Attribute Name | site_code |
Definition |
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 |
Definition |
wc_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | INTEGER |
Nullable | NO |
wc_type_code |
Base Entity | sg_completed_work_chr_data |
Attribute Name | wc_type_code |
Definition |
wc_type_code Logical Attribute Properties |
Logical Attribute Name | wc_type_code |
Datatype | INTEGER |
Nullable | NO |
eu_db_site |
Base Entity | sg_completed_work_chr_data |
Attribute Name | site_code |
Definition |
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 |
Definition |
eu_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | INTEGER |
Nullable | NO |
eu_type_code |
Base Entity | sg_completed_work_chr_data |
Attribute Name | eu_type_code |
Definition |
eu_type_code Logical Attribute Properties |
Logical Attribute Name | eu_type_code |
Datatype | INTEGER |
Nullable | NO |
data_value |
Base Entity | sg_completed_work_chr_data |
Attribute Name | data_value |
Definition |
data_value Logical Attribute Properties |
Logical Attribute Name | data_value |
Datatype | VARCHAR(254) |
Nullable | NO |
gmt_last_updated |
Base Entity | sg_completed_work_chr_data |
Attribute Name | gmt_last_updated |
Definition |
gmt_last_updated Logical Attribute Properties |
Logical Attribute Name | gmt_last_updated |
Datatype | DATETIME |
Nullable | YES |
last_upd_db_site |
Base Entity | sg_completed_work_chr_data |
Attribute Name | site_code |
Definition |
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 |
Definition |
last_upd_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | INTEGER |
Nullable | YES |
rstat_type_code |
Base Entity | sg_completed_work_chr_data |
Attribute Name | rstat_type_cod |
Definition |
rstat_type_code Logical Attribute Properties |
Logical Attribute Name | rstat_type_cod |
Datatype | SMALLINT |
Nullable | YES |