Member Registration

Please enter your email and Union Card Number. After successfully logging in, you will proceed to registration.

Your email address will be your username.



Need Help?

Email with any issues or concerns.

Send Us a Message
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/public/Registration';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Registration';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/public/Registration' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@DocumentUrlPath ("/public/Registration")
@NodeAliasPath ("/public/Registration")
@DocumentCulture ("en-US")
3.5 kB
 
Table (1 [65], 785 B)
 
SimpleHandler`2.StartEvent 0.000
 
2
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25757;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25757)
117 B
 
Table (1 [33], 12.3 kB)
 
SimpleHandler`2.StartEvent 0.766
 
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/public', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
375 B
 
Table (2 [157], 4 kB)
 
SimpleHandler`2.StartEvent 0.016
 
4
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 70
PageContext.CurrentPage_InitComplete 0.000
 
5
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSCaptchaControl';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSCaptchaControl")
195 B
 
cmswebparts_membership_registration_registrationform_iatse_ascx.__BuildControl__control11 0.000
 
6
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.FormUserControl';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.FormUserControl")
170 B
 
Table (1 [2], 5.1 kB)
 
cmswebparts_membership_registration_registrationform_iatse_ascx.__BuildControl__control11 0.000
 
7
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.FormUserControl';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.FormUserControl")
137 B
 
Table (1 [55], 19.4 kB)
 
cmswebparts_membership_registration_registrationform_iatse_ascx.__BuildControl__control11 0.000
 
8
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 846)
cmswebparts_membership_registration_registrationform_iatse_ascx.__BuildControl__control11 0.000
 
9
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 846)
cmswebparts_membership_registration_registrationform_iatse_ascx.__BuildControl__control11 0.016
 
10
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'SimpleCaptcha';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
@UserControlCodeName ("SimpleCaptcha")
165 B
 
Table (1 [34], 2.5 kB)
 
cmswebparts_membership_registration_registrationform_iatse_ascx.__BuildControl__control11 0.219
 
11
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.JobSkills';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.JobSkills")
141 B
 
Table (1 [55], 5.6 kB)
 
PageContext.CurrentPage_InitComplete 0.171
 
12
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.JobPositions';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.JobPositions")
147 B
 
Table (1 [55], 5.6 kB)
 
0.194
 
13
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.JobVenues';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.JobVenues")
141 B
 
Table (1 [55], 5.7 kB)
 
0.312
 
14
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.JobVenueTypes';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.JobVenueTypes")
149 B
 
Table (1 [55], 5.6 kB)
 
0.484
 
15
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.jobskills';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.jobskills")
174 B
 
Table (1 [2], 1.7 kB)
 
PageContext.CurrentPage_InitComplete 0.203
 
16

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('customtable_JobSkills');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
17
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 5360)
PageContext.CurrentPage_InitComplete 0.016
 
18
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5360)
PageContext.CurrentPage_InitComplete 0.000
 
19
(customtable.jobskills.generalselect)
SELECT *
FROM customtable_JobSkills
Table (93 [8], 9.5 kB)
 
PageContext.CurrentPage_InitComplete 0.375
 
20
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.licenseandcerts';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.licenseandcerts")
186 B
 
Table (1 [2], 2 kB)
 
PageContext.CurrentPage_InitComplete 0.360
 
21

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('customtable_LicenseAndCerts');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
22
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 5361)
PageContext.CurrentPage_InitComplete 0.000
 
23
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5361)
PageContext.CurrentPage_InitComplete 0.000
 
24
(customtable.licenseandcerts.generalselect)
SELECT *
FROM customtable_LicenseAndCerts
Table (82 [9], 9.4 kB)
 
PageContext.CurrentPage_InitComplete 0.219
 
25
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.jobpositions';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.jobpositions")
180 B
 
Table (1 [2], 1.7 kB)
 
PageContext.CurrentPage_InitComplete 0.156
 
26

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('customtable_JobPositions');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
27
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 5362)
PageContext.CurrentPage_InitComplete 0.000
 
28
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5362)
PageContext.CurrentPage_InitComplete 0.000
 
29
(customtable.jobpositions.generalselect)
SELECT *
FROM customtable_JobPositions
Table (24 [8], 2 kB)
 
PageContext.CurrentPage_InitComplete 0.047
 
30
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.jobvenues';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.jobvenues")
174 B
 
Table (1 [2], 1.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
31

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('customtable_JobVenues');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
32
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 5363)
PageContext.CurrentPage_InitComplete 0.000
 
33
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5363)
PageContext.CurrentPage_InitComplete 0.000
 
34
(customtable.jobvenues.generalselect)
SELECT *
FROM customtable_JobVenues
Table (162 [8], 15.9 kB)
 
PageContext.CurrentPage_InitComplete 0.312
 
35
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'customtable.jobvenuetypes';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("customtable.jobvenuetypes")
182 B
 
Table (1 [2], 1.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
36

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('customtable_JobVenueTypes');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
37
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 5365)
PageContext.CurrentPage_InitComplete 0.000
 
38
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5365)
PageContext.CurrentPage_InitComplete 0.000
 
39
(customtable.jobvenuetypes.generalselect)
SELECT *
FROM customtable_JobVenueTypes
Table (6 [8], 458 B)
 
PageContext.CurrentPage_InitComplete 0.047
 
40
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'Webparts_Membership_RegistrationForm.Captcha';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("Webparts_Membership_RegistrationForm.Captcha")
@CultureCode ("en-US")
350 B
 
PageContext.CurrentPage_InitComplete 0.000
 
  40 queries, 9.3 kB write, 113 kB read   3.943