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 | Description |
|---|---|
transaction_origin_key |
Surrogate key corresponding to the origin (Kangarootime system generated entities will be unique per business) |
business_id |
Unique identifier for the business |
origin |
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 |
The type of the source entity; enumerated: 'System' (Kangarootime system) or 'Person' (human generated source) |
origin_first_name |
The first name of the entity creating the record; NULL indicates the Kangarootime system |
origin_last_name |
The last name of the entity creating the record; NULL indicates the Kangarootime system |