StarRez Lite
StarRez is a student property management platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | BOOKING_TYPE, CUSTOM_FIELD_USAGE_TYPE_ENUM, ENTRY_STATUS_ENUM, ENROLLMENT_TYPE_ENUM, FIELD_DATA_TYPE_ENUM, GENDER_ENUM, GENDER_TYPE_ENUM, GL_POSTING_TYPE_ENUM, GROUP_STATUS_ENUM, NATIONALITY, RECORD_TYPE_ENUM, ROOM_RATE_DURATION_ENUM, ROOM_SPACE_TYPE_ENUM, and TRANSACTION_TYPE_ENUM. |
| History mode | ||
| Custom data | check | BOOKING, CHARGE_GROUP, CHARGE_ITEM, ENTRY, ENTRY_APPLICATION, ENTRY_DETAIL, ENTRY_ENROLLMENT, GROUPS, ROOM_LOCATION, ROOM_SPACE_CLOSED, ROOM_SPACE_DETAIL, ROOM_SPACE_MAINTENANCE, ROOM_TYPE, ROOMBASE, TERM_SESSION, TRANSACTION. |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | BOOKING_TYPE, CUSTOM_FIELD_USAGE_TYPE_ENUM, ENROLLMENT_TYPE_ENUM , ENTRY_STATUS_ENUM, FIELD_DATA_TYPE_ENUM, GENDER_ENUM, GL_POSTING_TYPE_ENUM, GROUP_STATUS_ENUM, GROUP_STATUS_ENUM, NATIONALITY, ROOM_RATE_DURATION_ENUM, ROOM_SPACE_TYPE_ENUM, ROOMSPACE_CLOSED_REASON, and TRANSACTION_TYPE_ENUM tables. |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step StarRez setup guide to connect StarRez with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
APPLICATION_STATUSBOOKINGBOOKING_CUSTOM_FIELDCATEGORYCHARGE_GROUPCHARGE_ITEMCUSTOM_FIELD_DEFINITIONDELETED_TRANSACTIONENTRYENTRY_ADDRESSENTRY_APPLICATIONENTRY_APPLICATION_CUSTOM_FIELDENTRY_CUSTOM_FIELDENTRY_DETAILENTRY_ENROLLMENTGENERIC_TABLE_DATAGENERIC_TABLE_DATA_FIELDGENERIC_TABLE_DEFINITIONGENERIC_TABLE_DEFINITION_FIELDGL_POSTINGGROUPSLOG_ACTIVITY_DELETEPROMO_CODEPROMO_CODE_RECORDPROMO_CODE_USAGEROOMBASEROOMSPACEROOM_CONFIGURATIONROOM_CONFIGURATION_TERM_TYPEROOM_LOCATION_FLOOR_SUITEROOM_LOCATION_SECTIONROOM_LOCATIONROOM_RATEROOM_RATE_ROOM_TYPE_LOCATIONROOM_RATE_SESSIONROOM_SPACE_CLOSEDROOM_SPACE_DETAILROOM_SPACE_MAINTENANCE_CATEGORYROOM_SPACE_MAINTENANCE_ITEMROOM_SPACE_MAINTENANCEROOM_TYPESECURITY_USERTERMTERM_SESSIONTERM_TYPETRANSACTION
To capture updates and deletes, we also re-import the remaining tables and their child tables during every sync.
Schema information
This schema applies to all StarRez connectors.
Explore StarRez schema ERD