asset_org_site
Base Entity as_completed_work
Attribute Name site_code
Definition

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
Definition

asset_id Logical Attribute Properties
Logical Attribute Name asset_id
Datatype INTEGER
Nullable NO


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

gmt_completed Logical Attribute Properties
Logical Attribute Name gmt_completed
Datatype DATETIME
Nullable NO


cp_loc_hr_delta
Base Entity as_completed_work
Attribute Name cp_loc_hr_delta
Definition

cp_loc_hr_delta Logical Attribute Properties
Logical Attribute Name cp_loc_hr_delta
Datatype SMALLINT
Nullable YES


cp_loc_min_delta
Base Entity as_completed_work
Attribute Name cp_loc_min_delta
Definition

cp_loc_min_delta Logical Attribute Properties
Logical Attribute Name cp_loc_min_delta
Datatype SMALLINT
Nullable YES


gmt_started
Base Entity as_completed_work
Attribute Name gmt_started
Definition

gmt_started Logical Attribute Properties
Logical Attribute Name gmt_started
Datatype DATETIME
Nullable YES


st_loc_hr_delta
Base Entity as_completed_work
Attribute Name st_loc_hr_delta
Definition

st_loc_hr_delta Logical Attribute Properties
Logical Attribute Name st_loc_hr_delta
Datatype SMALLINT
Nullable YES


st_loc_min_delta
Base Entity as_completed_work
Attribute Name st_loc_min_delta
Definition

st_loc_min_delta Logical Attribute Properties
Logical Attribute Name st_loc_min_delta
Datatype SMALLINT
Nullable YES


by_agent_site
Base Entity as_completed_work
Attribute Name site_code
Definition

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
Definition

by_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype INTEGER
Nullable YES


from_sy_agent_site
Base Entity as_completed_work
Attribute Name site_code
Definition

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
Definition

from_sy_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype INTEGER
Nullable YES


priority_lev_db_site
Base Entity as_completed_work
Attribute Name site_code
Definition

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
Definition

priority_lev_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


priority_lev_type_code
Base Entity as_completed_work
Attribute Name priority_lev_type_code
Definition

priority_lev_type_code Logical Attribute Properties
Logical Attribute Name priority_lev_type_code
Datatype INTEGER
Nullable YES


work_order_db_site
Base Entity as_completed_work
Attribute Name site_code
Definition

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
Definition

work_order_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


work_order_id
Base Entity as_completed_work
Attribute Name work_order_id
Definition

work_order_id Logical Attribute Properties
Logical Attribute Name work_order_id
Datatype INTEGER
Nullable YES


work_ord_step_seq
Base Entity as_completed_work
Attribute Name work_ord_step_seq
Definition

work_ord_step_seq Logical Attribute Properties
Logical Attribute Name work_ord_step_seq
Datatype INTEGER
Nullable YES


user_tag_ident
Base Entity as_completed_work
Attribute Name user_tag_ident
Definition

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


name
Base Entity as_completed_work
Attribute Name name
Definition

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


long_description
Base Entity as_completed_work
Attribute Name long_description
Definition

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
Definition

gmt_last_updated Logical Attribute Properties
Logical Attribute Name gmt_last_updated
Datatype DATETIME
Nullable YES


last_upd_db_site
Base Entity as_completed_work
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 as_completed_work
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 as_completed_work
Attribute Name rstat_type_cod
Definition

rstat_type_code Logical Attribute Properties
Logical Attribute Name rstat_type_cod
Datatype SMALLINT
Nullable YES