Online
v0.9.0
Tables
data_attributes 9849 records
| entity_id | physical_name | origin | data_type | dialect_type | dialect | business_type | business_type_params | data_type_info | order | scale | is_primary_key | is_foreign_key | is_unique | is_nullable | is_autoincrement | is_surrogate_key | is_business_key | is_audit_column | is_scd_column | audit_role | scd_role | pii_level | pcidss_attribute | hipaa_identifier | id | name | description | created_by_id | updated_by_id | created_at | updated_at | version | deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dd4a6cbf-fa9d-4075-bf99-774301583a84 | null | null | FLOAT | null | null | null | null | null | 1 | null | null | null | null | null | null | 6641e7cd-7702-47d6-aa8b-df54bb421927 | SRC_KEY | Src Key attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| dd4a6cbf-fa9d-4075-bf99-774301583a84 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | ada05939-96ab-4974-ab93-35c42676cb1f | LOCATION_ENRICHED_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | TIME | null | null | null | null | null | 6 | null | null | null | null | null | null | 8aef6957-bc21-4620-843f-0e199505b458 | TGT_IS_ENABLED | Tgt Is Enabled attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | STRING | TIMESTAMP | null | null | null | null | 5 | null | null | null | null | null | null | d2b4e68e-c9f8-4a5e-8926-3722f1ce69eb | is_manager_id | Is Manager Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | STRING | BIGINT | null | null | null | null | 4 | null | null | null | null | null | null | 8066a9d2-02a3-4f0a-b290-5303468734ce | SECONDARY_CHANNEL | Secondary Channel attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | JSON | null | null | null | null | null | 3 | null | null | null | null | null | null | 0f5c2e13-9831-4cea-bfed-00efef21aa9a | old_is_deleted | Old Is Deleted attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | INTEGER | null | null | null | null | null | 2 | null | null | null | null | null | null | 314f2a5b-ce7e-4994-8ecd-845ce2b48464 | avg_is_deleted | Avg Is Deleted attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | STRING | VARCHAR | null | null | null | null | 1 | null | null | null | null | null | null | cadf9741-8df1-454d-9a75-00901481e64e | LABEL | Label attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 93d802ab-af8d-45d5-a139-69cc204828a6 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 0e20c46a-2170-4d4b-ad5f-4e8dc96fb7a0 | TICKET_HISTORY_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | STRING | DOUBLE | null | null | null | null | 7 | null | null | null | null | null | null | a1b6ba25-d5aa-4904-b85c-aa67911c06b1 | NEW_LOCALE | New Locale attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | STRING | UUID | null | null | null | null | 6 | null | null | null | null | null | null | 86845be4-633e-4e76-847e-74b18cb93126 | FIRST_QUANTITY | First Quantity attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | DATE | null | null | null | null | null | 5 | null | null | null | null | null | null | 19842754-c6e7-48f7-a418-3d699624f002 | ORIG_MULTIPLIER | Orig Multiplier attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | JSON | null | null | null | null | null | 4 | null | null | null | null | null | null | 99577ef4-cb75-48f5-be13-69d1588180cc | min_zip_code | Min Zip Code attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | INTEGER | null | null | null | null | null | 3 | null | null | null | null | null | null | 18b32c64-d9a5-46a3-8ae3-b27d8a268184 | HAS_COMPLETED | Has Completed attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | STRING | VARCHAR | null | null | null | null | 2 | null | null | null | null | null | null | 8b6a1db1-29bc-476c-9af6-81cf631c1056 | FIRST_ZIP_CODE | First Zip Code attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | STRING | UUID | null | null | null | null | 1 | null | null | null | null | null | null | 50208e38-d369-4309-b512-b76679bb2011 | CACHED_REVISION | Cached Revision attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 7194201f-3f20-471e-9072-99b9626301c3 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 9066b7ff-c698-48f9-befa-4c698ca55a87 | CLIENT_AGGREGATE_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| eacfebcf-498d-4460-bd60-e53cb965c2b1 | null | null | BOOLEAN | null | null | null | null | null | 5 | null | null | null | null | null | null | f3fd68fb-aab8-4cfd-82b5-954877d579a2 | ORIG_REVIEWER_ID | Orig Reviewer Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| eacfebcf-498d-4460-bd60-e53cb965c2b1 | null | null | TIME | null | null | null | null | null | 4 | null | null | null | null | null | null | 24fac3ca-3d08-4b19-8661-89d4f7bf136b | temp_parent_id | Temp Parent Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| eacfebcf-498d-4460-bd60-e53cb965c2b1 | null | null | STRING | DOUBLE | null | null | null | null | 3 | null | null | null | null | null | null | 011d1f94-2e93-45a1-af4d-455d48f5ce59 | default_updated | Default Updated attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| eacfebcf-498d-4460-bd60-e53cb965c2b1 | null | null | TIME | null | null | null | null | null | 2 | null | null | null | null | null | null | 572ed848-8fa7-4423-ad95-cd9d1bb4d929 | secondary_parent_id | Secondary Parent Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| eacfebcf-498d-4460-bd60-e53cb965c2b1 | null | null | DATE | null | null | null | null | null | 1 | null | null | null | null | null | null | 64051f18-3110-44ff-b582-ef2204f698b5 | must_last_name | Must Last Name attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| eacfebcf-498d-4460-bd60-e53cb965c2b1 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | f9a1a3b3-e93b-4bde-b726-d82aa46ac877 | MESSAGE_TYPE_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| fdcd7747-63dd-4f77-b4ba-26defbe325b8 | null | null | STRING | DOUBLE | null | null | null | null | 5 | null | null | null | null | null | null | 28712bfa-bcbd-448d-a039-c46f0bd049ed | is_zip_code | Is Zip Code attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| fdcd7747-63dd-4f77-b4ba-26defbe325b8 | null | null | STRING | DOUBLE | null | null | null | null | 4 | null | null | null | null | null | null | f7e8cec2-4fad-41ff-9c64-7cb43b71aa97 | IS_STATE | Is State attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| fdcd7747-63dd-4f77-b4ba-26defbe325b8 | null | null | STRING | VARCHAR | null | null | null | null | 3 | null | null | null | null | null | null | 40ebd531-2a3a-49c2-b225-20a9f8ac3d4d | is_factor | Is Factor attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| fdcd7747-63dd-4f77-b4ba-26defbe325b8 | null | null | STRING | BIGINT | null | null | null | null | 2 | null | null | null | null | null | null | 09b8cb8b-d207-4c80-b0d1-261bc0bbd066 | CACHED_LAST_NAME | Cached Last Name attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| fdcd7747-63dd-4f77-b4ba-26defbe325b8 | null | null | BOOLEAN | null | null | null | null | null | 1 | null | null | null | null | null | null | 11c25691-af41-4f9a-aaec-7ca560acf215 | is_is_active | Is Is Active attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| fdcd7747-63dd-4f77-b4ba-26defbe325b8 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | aad0204f-d9e2-491a-b2af-b2a1c46c26cb | TRANSACTION_METRIC_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | STRING | TIMESTAMP | null | null | null | null | 9 | null | null | null | null | null | null | 6b961381-3068-40de-8a51-3fa37cc86883 | PRIMARY_IS_DELETED | Primary Is Deleted attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | STRING | BIGINT | null | null | null | null | 8 | null | null | null | null | null | null | 2d163fc2-4406-4e54-a84a-71cf85a3fbfe | IS_POSTAL_CODE | Is Postal Code attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | FLOAT | null | null | null | null | null | 7 | null | null | null | null | null | null | 2b046825-158a-4417-bd2b-6129d6178dee | PRIMARY_SESSION_ID | Primary Session Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | INTEGER | null | null | null | null | null | 6 | null | null | null | null | null | null | fb8a8ec1-2c3d-4996-9912-b62c77ef44de | custom_percentage | Custom Percentage attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | FLOAT | null | null | null | null | null | 5 | null | null | null | null | null | null | d03e0734-ae26-4d3c-83e2-0f73aac80868 | temp_average | Temp Average attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | STRING | TEXT | null | null | null | null | 4 | null | null | null | null | null | null | a8788d4e-55dc-4894-8aa6-aa2a4e8b0d1f | FIRST_IS_PRIMARY | First Is Primary attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | STRING | TEXT | null | null | null | null | 3 | null | null | null | null | null | null | 03b2b975-bfbb-4d45-af31-07b500eb6877 | MAX_IS_DELETED | Max Is Deleted attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | STRING | BIGINT | null | null | null | null | 2 | null | null | null | null | null | null | dae08485-1fb2-4135-b683-fab79144e0ea | HAS_LAST_NAME | Has Last Name attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | BOOLEAN | null | null | null | null | null | 1 | null | null | null | null | null | null | 7ead6156-4da6-437a-8838-584e1aa81456 | AVG_PHONE | Avg Phone attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 65c6fb35-ce74-451c-893a-b510eadd4ce4 | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 8fa884a5-3571-4048-9fb5-c8ab9efedd3c | ORGANIZATION_LOOKUP_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | FLOAT | null | null | null | null | null | 8 | null | null | null | null | null | null | d9bec40a-4c9d-4b14-a3e3-b1c840917ac1 | CUSTOM_CHILD_ID | Custom Child Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | JSON | null | null | null | null | null | 7 | null | null | null | null | null | null | b686806c-61c6-4192-9555-d70d51a692f4 | OLD_TIMESTAMP | Old Timestamp attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | JSON | null | null | null | null | null | 6 | null | null | null | null | null | null | 300fbdf0-b118-45a2-aa7a-4410aecf09f9 | PRIMARY_IS_OPTIONAL | Primary Is Optional attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | STRING | DOUBLE | null | null | null | null | 5 | null | null | null | null | null | null | 2f83fb0f-1a01-4c2b-b648-602df8efb9d8 | orig_currency | Orig Currency attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | STRING | UUID | null | null | null | null | 4 | null | null | null | null | null | null | 7ce35d85-006d-47b2-9f6f-6f79aaa9589f | should_child_id | Should Child Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | BOOLEAN | null | null | null | null | null | 3 | null | null | null | null | null | null | ba9a7605-4fce-4311-9cc9-48fe44e50ebe | MAY_CHILD_ID | May Child Id attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | STRING | TIMESTAMP | null | null | null | null | 2 | null | null | null | null | null | null | 20dd718b-73c7-4a9c-8090-c9febb17c0e1 | SUM_IS_REQUIRED | Sum Is Required attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | DATE | null | null | null | null | null | 1 | null | null | null | null | null | null | 028eab0e-f997-4c18-bd4f-11720c3532ac | cached_phase | Cached Phase attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| c98e0d3e-e380-45e0-bf84-5b374984f28d | null | null | INTEGER | null | null | null | null | null | 0 | null | null | null | null | null | null | 62807c35-5d2c-4137-8e17-b961e9e632bd | MILESTONE_PROCESSED_SK | Primary key | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 55a90175-b440-4950-9961-d28186216acf | null | null | CHAR | null | null | null | null | null | 7 | null | null | null | null | null | null | eef0f8d1-e756-4bac-ae37-3355ef23355a | SRC_PHONE | Src Phone attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 | ||||||||||
| 55a90175-b440-4950-9961-d28186216acf | null | null | STRING | VARCHAR | null | null | null | null | 6 | null | null | null | null | null | null | a60d0738-b1d4-4bd8-9145-70a9b4a61338 | temp_full_name | Temp Full Name attribute | 00000000-demo-user-0000-000000000001 | 00000000-demo-user-0000-000000000001 | 2026-01-03 15:16:40 | 2026-01-03 15:16:40 | 1 |