data_replication_schema_2026-10-16.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Schema	Type	Replication Type	Table Name	Column Name	Data Type	Max Length	Numeric Precision	Numeric Scale	Is Nullable	Is Primary Key	Is Foreign Key	Is Identity	Default Value	Description
7	dbo	TABLE	Not Documented	AdditionalErrorProperties	additionalPropertyID	int		10	0	No	Yes	No	Yes
8	dbo	TABLE	Not Documented	AdditionalErrorProperties	errorID	int		10	0	Yes	No	Yes	No
9	dbo	TABLE	Not Documented	AdditionalErrorProperties	name	nvarchar	255			No	No	No	No
10	dbo	TABLE	Not Documented	AdditionalErrorProperties	value	nvarchar	-1			No	No	No	No
67	dbo	TABLE	Not Documented	AppointmentGuests	appointmentID	int		10	0	No	Yes	No	No
68	dbo	TABLE	Not Documented	AppointmentGuests	dateLastSync	datetime				Yes	No	No	No
69	dbo	TABLE	Not Documented	AppointmentGuests	userID	int		10	0	No	Yes	No	No
121	dbo	TABLE	Not Documented	BillMasterDiscountRates	billMasterID	int		10	0	No	Yes	No	No
122	dbo	TABLE	Not Documented	BillMasterDiscountRates	dateLastSync	datetime				Yes	No	No	No
123	dbo	TABLE	Not Documented	BillMasterDiscountRates	discountRateID	int		10	0	No	Yes	No	No
140	dbo	TABLE	Not Documented	BillMasterSurchargeRates	billMasterID	int		10	0	No	Yes	No	No
141	dbo	TABLE	Not Documented	BillMasterSurchargeRates	dateLastSync	datetime				Yes	No	No	No
142	dbo	TABLE	Not Documented	BillMasterSurchargeRates	surchargeRateID	int		10	0	No	Yes	No	No
389	dbo	TABLE	Not Documented	BillingProfileBccRecipients	billingProfileID	int		10	0	No	Yes	No	No
390	dbo	TABLE	Not Documented	BillingProfileBccRecipients	dateLastSync	datetime				Yes	No	No	No
391	dbo	TABLE	Not Documented	BillingProfileBccRecipients	recipientUserID	int		10	0	No	Yes	No	No
392	dbo	TABLE	Not Documented	BillingProfileCcRecipients	billingProfileID	int		10	0	No	Yes	No	No
393	dbo	TABLE	Not Documented	BillingProfileCcRecipients	dateLastSync	datetime				Yes	No	No	No
394	dbo	TABLE	Not Documented	BillingProfileCcRecipients	recipientUserID	int		10	0	No	Yes	No	No
402	dbo	TABLE	Not Documented	BillingProfileToRecipients	billingProfileID	int		10	0	No	Yes	No	No
403	dbo	TABLE	Not Documented	BillingProfileToRecipients	dateLastSync	datetime				Yes	No	No	No
404	dbo	TABLE	Not Documented	BillingProfileToRecipients	recipientUserID	int		10	0	No	Yes	No	No
471	dbo	TABLE	Not Documented	BillingProfileVersionBCCRecipients	billingProfileVersionID	int		10	0	No	Yes	No	No
472	dbo	TABLE	Not Documented	BillingProfileVersionBCCRecipients	dateLastSync	datetime				Yes	No	No	No
473	dbo	TABLE	Not Documented	BillingProfileVersionBCCRecipients	recipientUserID	int		10	0	No	Yes	No	No
474	dbo	TABLE	Not Documented	BillingProfileVersionCCRecipients	billingProfileVersionID	int		10	0	No	Yes	No	No
475	dbo	TABLE	Not Documented	BillingProfileVersionCCRecipients	dateLastSync	datetime				Yes	No	No	No
476	dbo	TABLE	Not Documented	BillingProfileVersionCCRecipients	recipientUserID	int		10	0	No	Yes	No	No
477	dbo	TABLE	Not Documented	BillingProfileVersionToRecipients	billingProfileVersionID	int		10	0	No	Yes	No	No
478	dbo	TABLE	Not Documented	BillingProfileVersionToRecipients	dateLastSync	datetime				Yes	No	No	No
479	dbo	TABLE	Not Documented	BillingProfileVersionToRecipients	recipientUserID	int		10	0	No	Yes	No	No
548	dbo	TABLE	Not Documented	BullhornIdSnapshot	bullhornIdSnapshotID	int		10	0	No	Yes	No	Yes
549	dbo	TABLE	Not Documented	BullhornIdSnapshot	dateLastModified	datetime				Yes	No	No	No
550	dbo	TABLE	Not Documented	BullhornIdSnapshot	entity	nvarchar	100			Yes	No	No	No
551	dbo	TABLE	Not Documented	BullhornIdSnapshot	entityID	int		10	0	No	No	No	No
870	dbo	TABLE	Not Documented	CandidateAvailabilityMaskAssociation	candidateAvailabilityID	int		10	0	No	Yes	No	No
871	dbo	TABLE	Not Documented	CandidateAvailabilityMaskAssociation	candidateAvailabilityMaskID	int		10	0	No	Yes	No	No
872	dbo	TABLE	Not Documented	CandidateAvailabilityMaskAssociation	dateLastSync	datetime				Yes	No	No	No
873	dbo	TABLE	Not Documented	CandidateAvailabilityMaskAssociation	isDeleted	bit				No	No	No	No	((0))
1000	dbo	TABLE	Not Documented	CandidateDistributionLists	candidateID	int		10	0	No	Yes	No	No
1001	dbo	TABLE	Not Documented	CandidateDistributionLists	dateLastSync	datetime				Yes	No	No	No
1002	dbo	TABLE	Not Documented	CandidateDistributionLists	distributionListID	int		10	0	No	Yes	No	No
1274	dbo	TABLE	Not Documented	CategoryPuclicArticles	articleID	int		10	0	No	Yes	No	No
1275	dbo	TABLE	Not Documented	CategoryPuclicArticles	categoryID	int		10	0	No	Yes	No	No
1276	dbo	TABLE	Not Documented	CategoryPuclicArticles	dateLastSync	datetime				Yes	No	No	No
1519	dbo	TABLE	Not Documented	ClientContactClientLocations	clientContactID	int		10	0	No	Yes	No	No
1520	dbo	TABLE	Not Documented	ClientContactClientLocations	dateLastSync	datetime				Yes	No	No	No
1521	dbo	TABLE	Not Documented	ClientContactClientLocations	locationID	int		10	0	No	Yes	No	No
1526	dbo	TABLE	Not Documented	ClientContactDistributionLists	clientContactID	int		10	0	No	Yes	No	No
1527	dbo	TABLE	Not Documented	ClientContactDistributionLists	dateLastSync	datetime				Yes	No	No	No
1528	dbo	TABLE	Not Documented	ClientContactDistributionLists	distributionListID	int		10	0	No	Yes	No	No
1689	dbo	TABLE	Not Documented	ClientCorporationBillRulesetTimeLaborEvalRules	clientCorporationBillRulesetID	int		10	0	No	Yes	No	No
1690	dbo	TABLE	Not Documented	ClientCorporationBillRulesetTimeLaborEvalRules	dateLastSync	datetime				Yes	No	No	No
1691	dbo	TABLE	Not Documented	ClientCorporationBillRulesetTimeLaborEvalRules	timeLaborEvalRuleID	int		10	0	No	Yes	No	No
1701	dbo	TABLE	Not Documented	ClientCorporationBillRulesetVersionTimeLaborEvalRules	clientCorporationBillRulesetVersionID	int		10	0	No	Yes	No	No
1702	dbo	TABLE	Not Documented	ClientCorporationBillRulesetVersionTimeLaborEvalRules	dateLastSync	datetime				Yes	No	No	No
1703	dbo	TABLE	Not Documented	ClientCorporationBillRulesetVersionTimeLaborEvalRules	timeLaborEvalRuleID	int		10	0	No	Yes	No	No
1837	dbo	TABLE	Not Documented	ClientCorporationPayRulesetTimeLaborEvalRules	clientCorporationPayRulesetID	int		10	0	No	Yes	No	No
1838	dbo	TABLE	Not Documented	ClientCorporationPayRulesetTimeLaborEvalRules	dateLastSync	datetime				Yes	No	No	No
1839	dbo	TABLE	Not Documented	ClientCorporationPayRulesetTimeLaborEvalRules	timeLaborEvalRuleID	int		10	0	No	Yes	No	No
1849	dbo	TABLE	Not Documented	ClientCorporationPayRulesetVersionTimeLaborEvalRules	clientCorporationPayRulesetVersionID	int		10	0	No	Yes	No	No
1850	dbo	TABLE	Not Documented	ClientCorporationPayRulesetVersionTimeLaborEvalRules	dateLastSync	datetime				Yes	No	No	No
1851	dbo	TABLE	Not Documented	ClientCorporationPayRulesetVersionTimeLaborEvalRules	timeLaborEvalRuleID	int		10	0	No	Yes	No	No
1964	dbo	TABLE	Not Documented	ClientCorporationRateCards	clientCorporationID	int		10	0	No	Yes	No	No
1965	dbo	TABLE	Not Documented	ClientCorporationRateCards	dateLastSync	datetime				Yes	No	No	No
1966	dbo	TABLE	Not Documented	ClientCorporationRateCards	rateCardID	int		10	0	No	Yes	No	No
2084	dbo	TABLE	Not Documented	CorporateUserDistributionLists	corporateUserID	int		10	0	No	Yes	No	No
2085	dbo	TABLE	Not Documented	CorporateUserDistributionLists	dateLastSync	datetime				Yes	No	No	No
2086	dbo	TABLE	Not Documented	CorporateUserDistributionLists	distributionListID	int		10	0	No	Yes	No	No
2087	dbo	TABLE	Not Documented	CorporateUserFavoriteSavedSearches	corporateUserID	int		10	0	No	Yes	No	No
2088	dbo	TABLE	Not Documented	CorporateUserFavoriteSavedSearches	dateLastSync	datetime				Yes	No	No	No
2089	dbo	TABLE	Not Documented	CorporateUserFavoriteSavedSearches	searchID	int		10	0	No	Yes	No	No
2187	dbo	TABLE	Not Documented	DMEntityRecordCountData	ATSCount	int		10	0	Yes	No	No	No
2188	dbo	TABLE	Not Documented	DMEntityRecordCountData	DMCount	int		10	0	Yes	No	No	No
2189	dbo	TABLE	Not Documented	DMEntityRecordCountData	ID	int		10	0	No	No	No	Yes
2190	dbo	TABLE	Not Documented	DMEntityRecordCountData	dateAdded	datetime				Yes	No	No	No
2191	dbo	TABLE	Not Documented	DMEntityRecordCountData	endDate	datetime				Yes	No	No	No
2192	dbo	TABLE	Not Documented	DMEntityRecordCountData	entityName	nvarchar	255			Yes	No	No	No
2193	dbo	TABLE	Not Documented	DMEntityRecordCountData	startDate	datetime				Yes	No	No	No
2194	dbo	TABLE	Not Documented	DataMirrorError	dateAdded	datetime				Yes	No	No	No
2195	dbo	TABLE	Not Documented	DataMirrorError	dateSent	datetime				Yes	No	No	No
2196	dbo	TABLE	Not Documented	DataMirrorError	errorID	int		10	0	No	Yes	No	Yes
2197	dbo	TABLE	Not Documented	DataMirrorError	errorMessage	nvarchar	-1			Yes	No	No	No
2198	dbo	TABLE	Not Documented	DataMirrorError	errorType	nvarchar	255			Yes	No	No	No
2199	dbo	TABLE	Not Documented	DataMirrorError	failedEntityName	nvarchar	255			Yes	No	No	No
2200	dbo	TABLE	Not Documented	DataMirrorError	failedRecordID	int		10	0	Yes	No	No	No
2201	dbo	TABLE	Not Documented	DataMirrorErrorTypeLookup	errorTypeLookupID	int		10	0	No	Yes	No	No
2202	dbo	TABLE	Not Documented	DataMirrorErrorTypeLookup	label	nvarchar	255			No	No	No	No
2203	dbo	TABLE	Not Documented	DataMirrorScheduledJob	dateAdded	datetime				No	No	No	No	(getdate())
2204	dbo	TABLE	Not Documented	DataMirrorScheduledJob	dateCompleted	datetime				Yes	No	No	No
2205	dbo	TABLE	Not Documented	DataMirrorScheduledJob	name	nvarchar	255			No	No	No	No
2206	dbo	TABLE	Not Documented	DataMirrorScheduledJob	scheduledJobId	int		10	0	No	No	No	Yes
3394	dbo	TABLE	Not Documented	HousingComplexAmenities	dateLastSync	datetime				Yes	No	No	No
3395	dbo	TABLE	Not Documented	HousingComplexAmenities	housingAmenityID	int		10	0	No	Yes	No	No
3396	dbo	TABLE	Not Documented	HousingComplexAmenities	housingComplexID	int		10	0	No	Yes	No	No
3487	dbo	TABLE	Not Documented	HousingComplexUnitAmenities	dateLastSync	datetime				Yes	No	No	No
3488	dbo	TABLE	Not Documented	HousingComplexUnitAmenities	housingAmenityID	int		10	0	No	Yes	No	No
3489	dbo	TABLE	Not Documented	HousingComplexUnitAmenities	housingComplexUnitID	int		10	0	No	Yes	No	No
3544	dbo	TABLE	Not Documented	IdSnapshot	dateLastModified	datetime				Yes	No	No	No

Schema

Type

Replication Type

Table Name

Column Name

Data Type

Max Length

Numeric Precision

Numeric Scale

Is Nullable

Is Primary Key

Is Foreign Key

Is Identity

Default Value

Description

dbo

TABLE

Not Documented

AdditionalErrorProperties

additionalPropertyID

int

Yes

dbo

TABLE

Not Documented

AdditionalErrorProperties

errorID

int

Yes

dbo

TABLE

Not Documented

AdditionalErrorProperties

name

nvarchar

255

dbo

TABLE

Not Documented

AdditionalErrorProperties

value

nvarchar

-1

dbo

TABLE

Not Documented

AppointmentGuests

appointmentID

int

Yes

dbo

TABLE

Not Documented

AppointmentGuests

dateLastSync

datetime

Yes

dbo

TABLE

Not Documented

AppointmentGuests

userID

int

Yes

121

dbo

TABLE

Not Documented

BillMasterDiscountRates

billMasterID

int

Yes

122

dbo

TABLE

Not Documented

BillMasterDiscountRates

dateLastSync

datetime

Yes

123

dbo

TABLE

Not Documented

BillMasterDiscountRates

discountRateID

int

Yes

140

dbo

TABLE

Not Documented

BillMasterSurchargeRates

billMasterID

int

Yes

141

dbo

TABLE

Not Documented

BillMasterSurchargeRates

dateLastSync

datetime

Yes

142

dbo

TABLE

Not Documented

BillMasterSurchargeRates

surchargeRateID

int

Yes

389

dbo

TABLE

Not Documented

BillingProfileBccRecipients

billingProfileID

int

Yes

390

dbo

TABLE

Not Documented

BillingProfileBccRecipients

dateLastSync

datetime

Yes

391

dbo

TABLE

Not Documented

BillingProfileBccRecipients

recipientUserID

int

Yes

392

dbo

TABLE

Not Documented

BillingProfileCcRecipients

billingProfileID

int

Yes

393

dbo

TABLE

Not Documented

BillingProfileCcRecipients

dateLastSync

datetime

Yes

394

dbo

TABLE

Not Documented

BillingProfileCcRecipients

recipientUserID

int

Yes

402

dbo

TABLE

Not Documented

BillingProfileToRecipients

billingProfileID

int

Yes

403

dbo

TABLE

Not Documented

BillingProfileToRecipients

dateLastSync

datetime

Yes

404

dbo

TABLE

Not Documented

BillingProfileToRecipients

recipientUserID

int

Yes

471

dbo

TABLE

Not Documented

BillingProfileVersionBCCRecipients

billingProfileVersionID

int

Yes

472

dbo

TABLE

Not Documented

BillingProfileVersionBCCRecipients

dateLastSync

datetime

Yes

473

dbo

TABLE

Not Documented

BillingProfileVersionBCCRecipients

recipientUserID

int

Yes

474

dbo

TABLE

Not Documented

BillingProfileVersionCCRecipients

billingProfileVersionID

int

Yes

475

dbo

TABLE

Not Documented

BillingProfileVersionCCRecipients

dateLastSync

datetime

Yes

476

dbo

TABLE

Not Documented

BillingProfileVersionCCRecipients

recipientUserID

int

Yes

477

dbo

TABLE

Not Documented

BillingProfileVersionToRecipients

billingProfileVersionID

int

Yes

478

dbo

TABLE

Not Documented

BillingProfileVersionToRecipients

dateLastSync

datetime

Yes

479

dbo

TABLE

Not Documented

BillingProfileVersionToRecipients

recipientUserID

int

Yes

548

dbo

TABLE

Not Documented

BullhornIdSnapshot

bullhornIdSnapshotID

int

Yes

549

dbo

TABLE

Not Documented

BullhornIdSnapshot

dateLastModified

datetime

Yes

550

dbo

TABLE

Not Documented

BullhornIdSnapshot

entity

nvarchar

100

Yes

551

dbo

TABLE

Not Documented

BullhornIdSnapshot

entityID

int

870

dbo

TABLE

Not Documented

CandidateAvailabilityMaskAssociation

candidateAvailabilityID

int

Yes

871

dbo

TABLE

Not Documented

CandidateAvailabilityMaskAssociation

candidateAvailabilityMaskID

int

Yes

872

dbo

TABLE

Not Documented

CandidateAvailabilityMaskAssociation

dateLastSync

datetime

Yes

873

dbo

TABLE

Not Documented

CandidateAvailabilityMaskAssociation

isDeleted

bit

((0))

1000

dbo

TABLE

Not Documented

CandidateDistributionLists

candidateID

int

Yes

1001

dbo

TABLE

Not Documented

CandidateDistributionLists

dateLastSync

datetime

Yes

1002

dbo

TABLE

Not Documented

CandidateDistributionLists

distributionListID

int

Yes

1274

dbo

TABLE

Not Documented

CategoryPuclicArticles

articleID

int

Yes

1275

dbo

TABLE

Not Documented

CategoryPuclicArticles

categoryID

int

Yes

1276

dbo

TABLE

Not Documented

CategoryPuclicArticles

dateLastSync

datetime

Yes

1519

dbo

TABLE

Not Documented

ClientContactClientLocations

clientContactID

int

Yes

1520

dbo

TABLE

Not Documented

ClientContactClientLocations

dateLastSync

datetime

Yes

1521

dbo

TABLE

Not Documented

ClientContactClientLocations

locationID

int

Yes

1526

dbo

TABLE

Not Documented

ClientContactDistributionLists

clientContactID

int

Yes

1527

dbo

TABLE

Not Documented

ClientContactDistributionLists

dateLastSync

datetime

Yes

1528

dbo

TABLE

Not Documented

ClientContactDistributionLists

distributionListID

int

Yes

1689

dbo

TABLE

Not Documented

ClientCorporationBillRulesetTimeLaborEvalRules

clientCorporationBillRulesetID

int

Yes

1690

dbo

TABLE

Not Documented

ClientCorporationBillRulesetTimeLaborEvalRules

dateLastSync

datetime

Yes

1691

dbo

TABLE

Not Documented

ClientCorporationBillRulesetTimeLaborEvalRules

timeLaborEvalRuleID

int

Yes

1701

dbo

TABLE

Not Documented

ClientCorporationBillRulesetVersionTimeLaborEvalRules

clientCorporationBillRulesetVersionID

int

Yes

1702

dbo

TABLE

Not Documented

ClientCorporationBillRulesetVersionTimeLaborEvalRules

dateLastSync

datetime

Yes

1703

dbo

TABLE

Not Documented

ClientCorporationBillRulesetVersionTimeLaborEvalRules

timeLaborEvalRuleID

int

Yes

1837

dbo

TABLE

Not Documented

ClientCorporationPayRulesetTimeLaborEvalRules

clientCorporationPayRulesetID

int

Yes

1838

dbo

TABLE

Not Documented

ClientCorporationPayRulesetTimeLaborEvalRules

dateLastSync

datetime

Yes

1839

dbo

TABLE

Not Documented

ClientCorporationPayRulesetTimeLaborEvalRules

timeLaborEvalRuleID

int

Yes

1849

dbo

TABLE

Not Documented

ClientCorporationPayRulesetVersionTimeLaborEvalRules

clientCorporationPayRulesetVersionID

int

Yes

1850

dbo

TABLE

Not Documented

ClientCorporationPayRulesetVersionTimeLaborEvalRules

dateLastSync

datetime

Yes

1851

dbo

TABLE

Not Documented

ClientCorporationPayRulesetVersionTimeLaborEvalRules

timeLaborEvalRuleID

int

Yes

1964

dbo

TABLE

Not Documented

ClientCorporationRateCards

clientCorporationID

int

Yes

1965

dbo

TABLE

Not Documented

ClientCorporationRateCards

dateLastSync

datetime

Yes

1966

dbo

TABLE

Not Documented

ClientCorporationRateCards

rateCardID

int

Yes

2084

dbo

TABLE

Not Documented

CorporateUserDistributionLists

corporateUserID

int

Yes

2085

dbo

TABLE

Not Documented

CorporateUserDistributionLists

dateLastSync

datetime

Yes

2086

dbo

TABLE

Not Documented

CorporateUserDistributionLists

distributionListID

int

Yes

2087

dbo

TABLE

Not Documented

CorporateUserFavoriteSavedSearches

corporateUserID

int

Yes

2088

dbo

TABLE

Not Documented

CorporateUserFavoriteSavedSearches

dateLastSync

datetime

Yes

2089

dbo

TABLE

Not Documented

CorporateUserFavoriteSavedSearches

searchID

int

Yes

2187

dbo

TABLE

Not Documented

DMEntityRecordCountData

ATSCount

int

Yes

2188

dbo

TABLE

Not Documented

DMEntityRecordCountData

DMCount

int

Yes

2189

dbo

TABLE

Not Documented

DMEntityRecordCountData

int

Yes

2190

dbo

TABLE

Not Documented

DMEntityRecordCountData

dateAdded

datetime

Yes

2191

dbo

TABLE

Not Documented

DMEntityRecordCountData

endDate

datetime

Yes

2192

dbo

TABLE

Not Documented

DMEntityRecordCountData

entityName

nvarchar

255

Yes

2193

dbo

TABLE

Not Documented

DMEntityRecordCountData

startDate

datetime

Yes

2194

dbo

TABLE

Not Documented

DataMirrorError

dateAdded

datetime

Yes

2195

dbo

TABLE

Not Documented

DataMirrorError

dateSent

datetime

Yes

2196

dbo

TABLE

Not Documented

DataMirrorError

errorID

int

Yes

2197

dbo

TABLE

Not Documented

DataMirrorError

errorMessage

nvarchar

-1

Yes

2198

dbo

TABLE

Not Documented

DataMirrorError

errorType

nvarchar

255

Yes

2199

dbo

TABLE

Not Documented

DataMirrorError

failedEntityName

nvarchar

255

Yes

2200

dbo

TABLE

Not Documented

DataMirrorError

failedRecordID

int

Yes

2201

dbo

TABLE

Not Documented

DataMirrorErrorTypeLookup

errorTypeLookupID

int

Yes

2202

dbo

TABLE

Not Documented

DataMirrorErrorTypeLookup

label

nvarchar

255

2203

dbo

TABLE

Not Documented

DataMirrorScheduledJob

dateAdded

datetime

(getdate())

2204

dbo

TABLE

Not Documented

DataMirrorScheduledJob

dateCompleted

datetime

Yes

2205

dbo

TABLE

Not Documented

DataMirrorScheduledJob

name

nvarchar

255

2206

dbo

TABLE

Not Documented

DataMirrorScheduledJob

scheduledJobId

int

Yes

3394

dbo

TABLE

Not Documented

HousingComplexAmenities

dateLastSync

datetime

Yes

3395

dbo

TABLE

Not Documented

HousingComplexAmenities

housingAmenityID

int

Yes

3396

dbo

TABLE

Not Documented

HousingComplexAmenities

housingComplexID

int

Yes

3487

dbo

TABLE

Not Documented

HousingComplexUnitAmenities

dateLastSync

datetime

Yes

3488

dbo

TABLE

Not Documented

HousingComplexUnitAmenities

housingAmenityID

int

Yes

3489

dbo

TABLE

Not Documented

HousingComplexUnitAmenities

housingComplexUnitID

int

Yes

3544

dbo

TABLE

Not Documented

IdSnapshot

dateLastModified

datetime

Yes