asset_org_site
Base Entity as_completed_work
Attribute Name site_code
ColumnName asset_org_site
Definition
Note

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


asset_id
Base Entity as_completed_work
Attribute Name asset_id
ColumnName asset_id
Definition
Note

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


task_db_site
Base Entity as_completed_work
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 as_completed_work
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 as_completed_work
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 as_completed_work
Attribute Name gmt_completed
ColumnName gmt_completed
Definition
Note

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


cp_loc_hr_delta
Base Entity as_completed_work
Attribute Name cp_loc_hr_delta
ColumnName cp_loc_hr_delta
Definition
Note

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


cp_loc_min_delta
Base Entity as_completed_work
Attribute Name cp_loc_min_delta
ColumnName cp_loc_min_delta
Definition
Note

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


gmt_started
Base Entity as_completed_work
Attribute Name gmt_started
ColumnName gmt_started
Definition
Note

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


st_loc_hr_delta
Base Entity as_completed_work
Attribute Name st_loc_hr_delta
ColumnName st_loc_hr_delta
Definition
Note

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


st_loc_min_delta
Base Entity as_completed_work
Attribute Name st_loc_min_delta
ColumnName st_loc_min_delta
Definition
Note

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


by_agent_site
Base Entity as_completed_work
Attribute Name site_code
ColumnName by_agent_site
Definition
Note

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


by_agent_id
Base Entity as_completed_work
Attribute Name agent_id
ColumnName by_agent_id
Definition
Note

by_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype NUMERIC(10, 0)
Nullable YES


from_sy_agent_site
Base Entity as_completed_work
Attribute Name site_code
ColumnName from_sy_agent_site
Definition
Note

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


from_sy_agent_id
Base Entity as_completed_work
Attribute Name agent_id
ColumnName from_sy_agent_id
Definition
Note

from_sy_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype NUMERIC(10, 0)
Nullable YES


priority_lev_db_site
Base Entity as_completed_work
Attribute Name site_code
ColumnName priority_lev_db_site
Definition
Note

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


priority_lev_db_id
Base Entity as_completed_work
Attribute Name db_id
ColumnName priority_lev_db_id
Definition
Note

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


priority_lev_type_code
Base Entity as_completed_work
Attribute Name priority_lev_type_code
ColumnName priority_lev_type_code
Definition
Note

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


work_order_db_site
Base Entity as_completed_work
Attribute Name site_code
ColumnName work_order_db_site
Definition
Note

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


work_order_db_id
Base Entity as_completed_work
Attribute Name db_id
ColumnName work_order_db_id
Definition
Note

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


work_order_id
Base Entity as_completed_work
Attribute Name work_order_id
ColumnName work_order_id
Definition
Note

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


work_req_db_site
Base Entity as_completed_work
Attribute Name site_code
ColumnName work_req_db_site
Definition
Note

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


work_req_db_id
Base Entity as_completed_work
Attribute Name db_id
ColumnName work_req_db_id
Definition
Note

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


work_req_id
Base Entity as_completed_work
Attribute Name work_req_id
ColumnName work_req_id
Definition
Note

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


work_step_db_site
Base Entity as_completed_work
Attribute Name work_step_db_site
ColumnName work_step_db_site
Definition
Note

work_step_db_site Logical Attribute Properties
Logical Attribute Name work_step_db_site
Datatype CHAR(16)
Nullable YES


work_step_db_id
Base Entity as_completed_work
Attribute Name work_step_db_id
ColumnName work_step_db_id
Definition
Note

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


work_step_id
Base Entity as_completed_work
Attribute Name work_step_id
ColumnName work_step_id
Definition
Note

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


user_tag_ident
Base Entity as_completed_work
Attribute Name user_tag_ident
ColumnName user_tag_ident
Definition
Note

user_tag_ident Logical Attribute Properties
Logical Attribute Name user_tag_ident
Datatype NVARCHAR(254)
Nullable YES


name
Base Entity as_completed_work
Attribute Name name
ColumnName name
Definition
Note

name Logical Attribute Properties
Logical Attribute Name name
Datatype NVARCHAR(254)
Nullable YES


long_description
Base Entity as_completed_work
Attribute Name long_description
ColumnName long_description
Definition
Note

long_description Logical Attribute Properties
Logical Attribute Name long_description
Datatype VARCHAR(4000)
Nullable YES


gmt_last_updated
Base Entity as_completed_work
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 as_completed_work
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 as_completed_work
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 as_completed_work
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


work_ord_step_seq
Base Entity as_completed_work
Attribute Name work_ord_step_seq
ColumnName work_ord_step_seq
Definition
Note

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