Entity dataset for the legacy data schema
Learn about the entity dataset for the column-based schema.
This table holds data for all entities. Use these datasets to view your entity metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| Uri | The universal resource identifier. It is in the format <ObjectTypeSpecifier>/Id. Example: For entities the | Data type: STRING Mode: NULLABLE |
| Type | The entity type in Reltio. | Data type: STRING Mode: NULLABLE |
| Id | The entity identifier in Reltio. | Data type: STRING Mode: NULLABLE |
| createdTime | The timestamp when the entity is created in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| createdBy | The user who created the entity. | Data type: STRING Mode: NULLABLE |
| updatedTime | The timestamp when the entity is last updated in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| updatedBy | The user who last updated the entity. | Data type: STRING Mode: NULLABLE |
| deletedTime | The time when the entity is deleted. | Data type: TIMESTAMP Mode: NULLABLE |
| deleted | An indicator that tells you whether the entity is deleted or not. | Data type: BOOLEAN Mode: NULLABLE |
| startDate | The date when the entity is created in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| endDate | The date when the entity is marked for a soft delete, if it is already deleted, in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| eventTime | The time when an event is logged in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| insertedTime | The time when an entity is inserted in the GBQ table. | Data type: TIMESTAMP Mode: NULLABLE |
| versionTime | The object version in Reltio. | Data type: INTEGER Mode: NULLABLE |
| conflictedAttributes | The location of all attributes that are currently not in the attributes schema. After the tables are deleted and data is resynchronized, these values are added to the attribute column in the attributes schema. | Data type: STRING Mode: NULLABLE |
| tags | The location of all tags that can be applied to the entity. | Data type: STRING Mode: REPEATED |
| crosswalks | A representation of the crosswalks of an object in Reltio. | Data type: RECORD Mode: REPEATED |
| attributes_<entityType> | The attributes of an entity type. For example, location, company, Health Care Organisations (HCO), Health Care Professionals (HCP), and contact. | Data type: RECORD Mode: NULLABLE |
| analyticsAttributes_<entityType> | The analytical attributes of an entity type. For example, Health Care Organisations (HCO), Health Care Professionals (HCP). | Data type: RECORD Mode: NULLABLE |
| Field | Description | GBQ type/GBQ mode |
|---|---|---|
| <Attribute name 1> | The first attribute's name. | GBQ type: RECORD GBQ mode: REPEATED |
| <Attribute name 2> | The second attribute's name. | GBQ type: RECORD GBQ mode: REPEATED |
| <Attribute name 3> | The third attribute's name. | GBQ type: RECORD GBQ mode: REPEATED |
| Field | Description | GBQ type/GBQ mode |
|---|---|---|
| Id | The attribute identifier. | GBQ type: STRING GBQ mode: NULLABLE |
| value | The attribute value. | GBQ type: STRING/INTEGER/TIMESTAMP GBQ mode: REPEATED |
| isOV | An indicator that tells you whether the attribute has operational values or not. | GBQ type: BOOLEAN GBQ mode: NULLABLE |
| Field | Description | GBQ type/GBQ mode |
|---|---|---|
| Id | The attribute identifier. | GBQ type: STRING GBQ mode: NULLABLE |
| value | The attribute value. | GBQ type: RECORD GBQ mode: REPEATED |
| isOV | An indicator that tells you whether the attribute has operational values or not. | GBQ type: BOOLEAN GBQ mode: NULLABLE |
| Field | Description | GBQ type/GBQ mode |
|---|---|---|
| value | The crosswalk value. | GBQ type: STRING GBQ mode: NULLABLE |
| attributes | The list of attribute Uris that belong to the crosswalk. | GBQ type: STRING GBQ mode: REPEATED |
| Uri | The crosswalk's Universal resource identifier. | GBQ type: STRING GBQ mode: NULLABLE |
| createDate | The timestamp when the crosswalk is created in Reltio. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| updateDate | The timestamp when the crosswalk is last updated in Reltio. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| deleteDate | The timestamp when the crosswalk is deleted. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| reltioLoadDate | The timestamp when the crosswalk is loaded in Reltio. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| source | The crosswalk source. | GBQ type: STRING GBQ mode: NULLABLE |
| sourceTable | The crosswalk source table. | GBQ type: STRING GBQ mode: NULLABLE |
| refEntityOrRelationId | The identifier of the entity or relation that is used as a source for the reference attribute. | GBQ type: STRING GBQ mode: NULLABLE |
| Field | Description | GBQ type/GBQ mode |
|---|---|---|
| <Analytical attribute name 1> | The first attribute's name. | GBQ type: <any data type> GBQ mode: REPEATED |
| <Analytical attribute name 2> | The second attribute's name. | GBQ type: <any data type> GBQ mode: REPEATED |
| <Analytical attribute name 3> | The third attribute's name. | GBQ type: <any data type> GBQ mode: REPEATED |