ErrorID : 0
ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->RaisedQualifyingEvent.Save->RaisedQualifyingEvent.ReviewChangesQualifyingEvent->RaisedQualifyingEvent.UpdateReviewChangesOtherThanQualifyingEventMode
ErrorMessage: Incorrect syntax near '20122013'.
tempID:1
tempID:1
tempID:1
tempID:1
tempID:1
retrieved values:Test
FirstName = NullIf('Test',''),
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL,
tempID:1
retrieved values:FirstChange
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''),
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,
tempID:1
retrieved values:Oct 10 1990 12:00AM
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''),
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL,
tempID:1
retrieved values:149146143
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''),
tempID:1
retrieved values:Jan 1 2017 12:00AM
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''),
tempID:1
retrieved values:3
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL,
tempID:1
retrieved values:Jan 1 2017 12:00AM
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''),
tempID:1
retrieved values:Content.aspx?Pageid=2
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''),
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL,
tempID:1
retrieved values:Aug 1 2017 12:00AM
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''),
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0,
tempID:1
retrieved values:1
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1,
tempID:1
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0,
tempID:1
retrieved values:15
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL,
tempID:1
retrieved values:Yes
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''),
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL,
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0,
tempID:1
retrieved values:No
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''),
tempID:1
retrieved values:No
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''), COBRABillSuppresion343 = NullIf('No',''),
tempID:1
retrieved values:0
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''), COBRABillSuppresion343 = NullIf('No',''), IsInterviewer = 0,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''), COBRABillSuppresion343 = NullIf('No',''), IsInterviewer = 0, EIN = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''), COBRABillSuppresion343 = NullIf('No',''), IsInterviewer = 0, EIN = NULL, MostRecentHireDate = NULL,
tempID:1
retrieved values:NULL
FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''), COBRABillSuppresion343 = NullIf('No',''), IsInterviewer = 0, EIN = NULL, MostRecentHireDate = NULL, OtherUniqueIdentifier = NULL,
UPDATE Employee SET FirstName = NullIf('Test',''), MiddleInitial = NULL, LastName = NullIf('FirstChange',''), TitleID = NULL, GenderID = 1,DateOfBirth = NullIf('Oct 10 1990',''), EmpID = NULL, SocialSecurityNo = NullIf('149146143',''), EmploymentDate = NullIf('Jan 1 2017',''), Class1ID = 3, Class2ID = 1, Class3ID = NULL, Class4ID = NULL, StreetAddress1 = NULL, StreetAddress2 = NULL, City = NULL, CountryID = 1,StateID = NULL, PostalCode = NULL, HomePhone = NULL, WorkPhone = NULL, Extension = NULL, EmailAddress = NULL, AlternateEmail = NULL, ReceiveEmail = 0, MaritalStatusID = NULL, MaritalStatusDate = NULL, EmployeeTypeID = NULL, OfficerStatus = 0, StockHoldings = NULL, IsUnionMember = 0, IsEmployeeSupervisor = 0, SupervisorID = NULL, CurrentJobTitle = NULL, JobDescription = NULL, WorkedHoursPerWeek = NULL, EmployeeStatusID = 1,StatusChangeReasonID = NULL, StatusChangeOtherReason = NULL, COBRANotificationMailDate = NULL, SystemAccessExpirationDate = NULL, LoginStatusID = 0,IsLoginDisabled = 0, ShowDisclaimer = 1, CompanyBankID = NULL, RehireDate = NULL, StatusChangeDate = NullIf('Jan 1 2017',''), LastVisitedUrl = NullIf('Content.aspx?Pageid=2',''), LastVisitedUrlQE = NULL, LanguageIndicator = 1,County = NULL, EffectiveDate = NullIf('Aug 1 2017',''), QESStatus = 0,IsCompanyUser = 0, UserID = 1, UseEmployerAddress = 0, EnrollMentModeID = 15,QualifyingEventID = NULL, Campus333 = NULL, DoesthisemployeeneedtoreviewtheFDUEmployeeAffirmations334 = NullIf('Yes',''), TIAACrefEmployerMatch135 = NULL, 20122013AnnualAward141 = NULL, CellPhoneNo = NULL, ReceiveSMS = 0, GrandfatheredforLifeBenefits342 = NullIf('No',''), COBRABillSuppresion343 = NullIf('No',''), IsInterviewer = 0, EIN = NULL, MostRecentHireDate = NULL, OtherUniqueIdentifier = NULL, DateTimeStamp = 'Jul 21 2017 2:06PM' WHERE ID = 2781