1. Project
2. Servers

AUI DW ODS

Servers

• Collapse All
• Expand All

Servers

1

• AUI_DW_ODS.AUI-DEV-DW-01.DATABASE.WINDOWS.NET

Author: Keith Moltzan

Copyright © All Rights Reserved

Created: 29/01/2021

1. Project
2. Servers
3. AUI_DW_ODS.AUI-DEV-DW-01.DATABASE.WINDOWS.NET

AUI DW ODS

AUI_DW_ODS.AUI-DEV-DW-01.DATABASE.WINDOWS.NET

• Collapse All
• Expand All

Databases

1

• AUI_DW_ODS

Properties

Name	Value
Product	Microsoft SQL Azure
Version Level	RTM
Edition	SQL Azure
Version	12.0.2000.8
Collation	SQL_Latin1_General_CP1_CI_AS

Settings

Name	Value
Default data file path	N/A
Default log file path	N/A
Default backup file path
Recovery Interval (minutes)	0
Default index fill factor (%)	0
Default backup media retention (days)	0
Compress backup	False
Nested triggers enabled	True
Allow triggers to fire others	True
Default language	us_english
Default fulltext language	us_english
Default fulltext language LCID	1033
Network packet size	4096
Two digit year cutoff	2049
Max text replication size (bytes)	65536
Locks	0
Blocked process threshold	20
Cursor threshold	-1
Cost threshold for parallelism	5
Scans and runs startup procedures	False
Transform noise words	False
Filestream access level	Disabled
Optimize for 'ad hoc' workloads	False
Remote login timeout (sec)	10

Author: Keith Moltzan

Copyright © All Rights Reserved

Created: 29/01/2021

1. Project
2. Servers
3. AUI_DW_ODS.AUI-DEV-DW-01.DATABASE.WINDOWS.NET
4. User databases
5. AUI_DW_ODS

AUI DW ODS

AUI_DW_ODS

• Collapse All
• Expand All

Description

Object Types

1

• Tables

Properties

Name	Value
SQL Server version	Microsoft SQL Azure RTM 12.0.2000.8
Edition
Compatibility level
Last backup time	N/A
Last backup time of transaction log	N/A
Default index fill factor (%)	0
Creation date	1/21/2021 7:34:53 PM
Number of Users	4
Database Encryption Enabled	False
Database Encryption Algorithm	N/A
Database status	ONLINE
Max size	0 B
Default language	N/A
Default fulltext language	us_english

Options

Name	Value
Database collation	SQL_Latin1_General_CP1_CS_AS
Restrict access	MULTI_USER
Cleanly shutdown	False
Supplemental logging enabled	False
Is Read-Only	False
Auto close	False
Auto shrink	False
Database is read-only for restore log	False
Is Snapshot	False
Snapshot isolation state	False
Read committed snapshot on	True
Recovery model	FULL
Page verify option	Checksum
Auto create statistics	True
Auto update statistics	True
Auto update statistics asynchronously	False
ANSI NULL default	True
ANSI NULL enabled	True
ANSI padding enabled	True
ANSI warnings enabled	True
Arithmetic abort enabled	True
Concatenating NULL yields NULL	True
Numeric roundabort enabled	False
Quoted Identifier ON	True
Recursive triggers enabled	False
Close cursors on commit	False
Local cursor by default	False
Fulltext enabled	True
Trustworthy	False
Database chaining	False
Forced parameterization	False
Master key encrypted by server	False
Published	False
Merge published	False
Is distribution database	False
Sync with backup	False
Service broker GUID	91b8494f-ff1e-450b-898c-926800c9180b
Service broker enabled	True
Log reuse wait	Nothing
Date correlation	False
Change data capture enabled	False
Honor broker priority	False
Database owner
Delayed durability	Disabled
Containment type	False

Author: Keith Moltzan

Copyright © All Rights Reserved

Created: 29/01/2021

1. Project
2. Servers
3. AUI_DW_ODS.AUI-DEV-DW-01.DATABASE.WINDOWS.NET
4. User databases
5. AUI_DW_ODS
6. Tables
7. SALESFORCE.Campaign

AUI DW ODS

SALESFORCE.Campaign

• Collapse All
• Expand All

Description

Columns

103

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Rule	Default	Computed	Persisted	Description
	Id	nvarchar	18	0	0	True				False	False
	IsDeleted	bit	1	1	0	True				False	False
	Name	nvarchar	80	0	0	True				False	False
	ParentId	nvarchar	18	0	0	False				False	False
	Type	nvarchar	255	0	0	False				False	False
	RecordTypeId	nvarchar	18	0	0	False				False	False
	STATUS	nvarchar	255	0	0	False				False	False
	StartDate	date	3	10	0	False				False	False
	EndDate	date	3	10	0	False				False	False
	ExpectedRevenue	decimal	9	18	0	False				False	False
	BudgetedCost	decimal	9	18	0	False				False	False
	ActualCost	decimal	9	18	0	False				False	False
	ExpectedResponse	float	8	53	0	False				False	False
	NumberSent	float	8	53	0	False				False	False
	IsActive	bit	1	1	0	True				False	False
	Description	nvarchar		0	0	False				False	False
	NumberOfLeads	int	4	10	0	True				False	False
	NumberOfConvertedLeads	int	4	10	0	True				False	False
	NumberOfContacts	int	4	10	0	True				False	False
	NumberOfResponses	int	4	10	0	True				False	False
	NumberOfOpportunities	int	4	10	0	True				False	False
	NumberOfWonOpportunities	int	4	10	0	True				False	False
	AmountAllOpportunities	decimal	9	18	0	True				False	False
	AmountWonOpportunities	decimal	9	18	0	True				False	False
	OwnerId	nvarchar	18	0	0	True				False	False
	CreatedDate	datetime	8	23	3	True				False	False
	CreatedById	nvarchar	18	0	0	True				False	False
	LastModifiedDate	datetime	8	23	3	True				False	False
	LastModifiedById	nvarchar	18	0	0	True				False	False
	SystemModstamp	datetime	8	23	3	True				False	False
	LastActivityDate	date	3	10	0	False				False	False
	LastViewedDate	datetime	8	23	3	False				False	False
	LastReferencedDate	datetime	8	23	3	False				False	False
	CampaignMemberRecordTypeId	nvarchar	18	0	0	False				False	False
	ERx_Events__Campaign_Template__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Campaign_Time_Zone__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Campus_Private_Campaign_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Closed_Event_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Configure__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Contact_Email__c	nvarchar	80	0	0	False				False	False
	ERx_Events__Directions__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Duplicate_Email_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Email_Setting__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Email_Template_Registration__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Email_Template_Waitlist__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Enforce_Personalized_Security__c	bit	1	1	0	True				False	False
	ERx_Events__Event_Description__c	nvarchar		0	0	False				False	False
	ERx_Events__Event_Full_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Event_Page_URL__c	nvarchar	1300	0	0	False				False	False
	ERx_Events__Event_Registration_Template__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Event_Time__c	nvarchar	50	0	0	False				False	False
	ERx_Events__Event_Title_Style__c	nvarchar	100	0	0	False				False	False
	ERx_Events__Event_URL__c	nvarchar	255	0	0	False				False	False
	ERx_Events__FormBuilder_Pages__c	nvarchar	100	0	0	False				False	False
	ERx_Events__Guest_Information_Bar_Color__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Guest_Information__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Image_URL__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Instruction_Text_Color__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Is_Recurrence__c	bit	1	1	0	True				False	False
	ERx_Events__Location__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Maximum_Registrations__c	float	8	53	0	False				False	False
	ERx_Events__Maximum_Waitlist_Registrations__c	float	8	53	0	False				False	False
	ERx_Events__Maximum_number_of_guests__c	float	8	53	0	False				False	False
	ERx_Events__Mutually_Exclusive_Group__c	bit	1	1	0	True				False	False
	ERx_Events__Mutually_Exclusive_Warning_Attended__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Mutually_Exclusive_Warning_Registered__c	nvarchar	255	0	0	False				False	False
	ERx_Events__New_Contact_Lead_Source__c	nvarchar	30	0	0	False				False	False
	ERx_Events__Ongoing_Event__c	bit	1	1	0	True				False	False
	ERx_Events__OnlineGuestEnabled__c	bit	1	1	0	True				False	False
	ERx_Events__Override_Contact_Message__c	nvarchar		0	0	False				False	False
	ERx_Events__Payment_URL__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Private__c	bit	1	1	0	True				False	False
	ERx_Events__RSVP_Date__c	date	3	10	0	False				False	False
	ERx_Events__Recurrence_Information__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Redirect_URL__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Register_Waitlist_until__c	datetime	8	23	3	False				False	False
	ERx_Events__Registration_Success_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Seconds_to_show_Success_Message__c	float	8	53	0	False				False	False
	ERx_Events__Sender_Email__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Should_Send_Email__c	bit	1	1	0	True				False	False
	ERx_Events__StartDateTime__c	datetime	8	23	3	False				False	False
	ERx_Events__Thank_You_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Total_Registered__c	float	8	53	0	False				False	False
	ERx_Events__Total_WaitListed__c	float	8	53	0	False				False	False
	ERx_Events__Unlisted__c	bit	1	1	0	True				False	False
	ERx_Events__Waitlist_until_message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Waitlisted_Message__c	nvarchar	255	0	0	False				False	False
	ERx_Events__Total_Event_Registrations__c	float	8	53	0	False				False	False
	ERx_Events__Total_Waitlisted_Registrations__c	float	8	53	0	False				False	False
	ERx_Events__Unnamed_Guest_Event_Registrations__c	float	8	53	0	False				False	False
	ERx_Events__Unnamed_Guest_Waitlisted_Registrations__c	float	8	53	0	False				False	False
	ERx_Events__Is_Show_Available_Space_Text__c	bit	1	1	0	True				False	False
	ERx_Events__Is_Waitlist_Registration_Closed__c	bit	1	1	0	True				False	False
	ERx_Events__Registration_Available__c	float	8	53	0	False				False	False
	ERx_Events__Short_Description__c	nvarchar	1	0	0	False				False	False
	ERx_Events__Waitlist_Available__c	float	8	53	0	False				False	False
	Old_Owner_Name__c	nvarchar	255	0	0	False				False	False
	Old_Created_By_ID__c	nvarchar	255	0	0	False				False	False
	Old_Created_By_Name__c	nvarchar	255	0	0	False				False	False
	Old_Owner_ID__c	nvarchar	255	0	0	False				False	False
	DW_ID	uniqueidentifier	16	0	0	True			(newsequentialid())	False	False
	DW_INSERT_DT	datetime	8	23	3	True			(getdate())	False	False
	DW_LAST_UPDATE_DT	datetime	8	23	3	False				False	False

Indexes

1

Key	Name	Columns	Unique	Type	Description
	PK_CAMPAIGN_ID	Id	True

Depends On

• SALESFORCE

Used By

• SALESFORCE.UPSERT_CAMPAIGN

Author: Keith Moltzan

Copyright © All Rights Reserved

Created: 29/01/2021