IDM - Asset

asset_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

type_id

string

True

type_id

 dim_asset_type.id

status_id

string

 True

status_id

 dim_asset_status.id

budget_id

string

 True

budget_id

site_id

string

 True

site_id

 dim_site.id

group_id

string

 True

group_id

parent_id

string

parent_id

 dim_asset.id

manufacturer_id

string

manufacturer_id

model_id

string

model_id

customer_id

string

customer_id

vendor_id

string

vendor_id

 dim_person.id

axle_schema_id

string

axle_schema_id

location_id

string

location_id

 dim_location.id

code

string

 True

code

serial_number

string

serial_number

tag_identifier

string

tag_identifier

description

string

description

source

string

source

modified_date

timestamp

modified_date

purchased_date

timestamp

purchased_date

purchase_cost

double

purchase_cost

useful_life

double

useful_life

salvage_value

double

salvage_value

sold_date

timestamp

sold_date

trip_date

timestamp

trip_date

logs_from_parent

boolean

logs_from_parent

model_year

int

model_year

in_service_date

timestamp

in_service_date

edw_start_time

timestamp

True

ETL internal usage

edw_row_is_last

boolean

ETL internal usage

history_start_time

timestamp

 True

history_end_time

timestamp

row_is_current

boolean

True

The row data is current or not.

asset_type_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

name

string

True

name

parent_id

string

parent_id

 dim_asset_type.id

axle_schema_id

string

axle_schema_id

budget_id

string

budget_id

is_description_optional

boolean

is_description_optional

class

string

class

Enum: one of

• facilities

• fixed_equipment

• mobile_equipment

• fleet

edw_start_time

timestamp

True

ETL internal usage

edw_row_is_last

boolean

ETL internal usage

history_start_time

timestamp

 True

history_end_time

timestamp

row_is_current

boolean

True

The row data is current or not.

asset_status_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

name

string

True

name

is_active_status

boolean

is_active_status

is_system

boolean

is_system

edw_start_time

timestamp

True

ETL internal usage

edw_row_is_last

boolean

ETL internal usage

history_start_time

timestamp

 True

history_end_time

timestamp

row_is_current

boolean

True

The row data is current or not.

asset_type_location_pk

long

True

surrogate key as primary key

asset_id

string

True

dim_asset.id

tenant_id

string

True

dim_tenant.id

asset_type_id

string

 True

dim_asset_type.id

asset_type_name

string

True

dim_asset_type.name

modified_date

date

dim_asset.modified_date

location_id

string

dim_asset.location_id

site_id

string

True

dim_asset.site_id

address_id

string

dim_address.id

region_id

string

dim_region.id

building_id

string

dim_building.id

floor_id

string

dim_floor.id

space_id

string

dim_space.id

site_name

string

dim_site.name

region_name

string

dim_region.name

building_name

string

dim_building.name

floor_name

string

dim_floor.name

space_name

string

dim_space.name

country

string

dim_address.country

state

string

dim_address.state

city

string

dim_address.city

history_start_date

date

True

to_date(dim_asset.history_start_time)

edw_start_time

timestamp

True

dim_asset.edw_start_time – ETL INTERNAL USAGE