Edit on GitHub
StarRez Lite link
StarRez is a student property management platform.
Featureslink
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 . |
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step StarRez setup guide to connect StarRez with your destination using Fivetran connectors.
Sync overviewlink
To capture new records, we incrementally sync the following tables and their child tables:
BOOKING
BOOKING_CUSTOM_FIELD
CATEGORY
CHARGE_GROUP
CHARGE_ITEM
CUSTOM_FIELD_DEFINITION
DELETED_TRANSACTION
ENTRY
ENTRY_ADDRESS
ENTRY_CUSTOM_FIELD
ENTRY_DETAIL
ENTRY_ENROLLMENT
GENERIC_TABLE_DATA
GENERIC_TABLE_DATA_FIELD
GENERIC_TABLE_DEFINITION
GENERIC_TABLE_DEFINITION_FIELD
GL_POSTING
GROUPS
LOG_ACTIVITY_DELETE
PROMO_CODE
PROMO_CODE_RECORD
PROMO_CODE_USAGE
ROOMBASE
ROOMSPACE
ROOM_CONFIGURATION
ROOM_LOCATION_FLOOR_SUITE
ROOM_LOCATION_SECTION
ROOM_LOCATION
ROOM_RATE
ROOM_RATE_ROOM_TYPE_LOCATION
ROOM_RATE_SESSION
ROOM_SPACE_MAINTENANCE_CATEGORY
ROOM_SPACE_MAINTENANCE_ITEM
ROOM_SPACE_MAINTENANCE
ROOM_TYPE
SECURITY_USER
TERM
TERM_SESSION
TRANSACTION
Schema informationlink
This schema applies to all StarRez connectors.
To zoom, open the ERD in a new window.