Table: dim_transaction_origin

Type: Dimension Columns: 8

Description

Record origin information. The data grain is creator for individual transactions the entity creating the record. This can be either the system or an individual (staff, guardian, etc).

Columns

Column Name Type Description
transaction_origin_key int32

Surrogate key corresponding to the origin (Kangarootime system generated entities will be unique per business)

business_id string

Unique identifier for the business

origin string

The entity responsible for creating the record. For individuals, this would be their full names. The value of "system" indicates the record was generated by Kangarootime

origin_type string

The type of the source entity; enumerated: 'System' (Kangarootime system) or 'Person' (human generated source)

origin_first_name string

The first name of the entity creating the record; NULL indicates the Kangarootime system

origin_last_name string

The last name of the entity creating the record; NULL indicates the Kangarootime system

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.