SELECT uName.ID,uName.IsLastName, uName.LastNameCount, uName.IsFirstName,  uName.FirstNameCount,  uName.IsSocialSecurityNo, uName.SocialSecurityNoCount, uName.IsDateOfBirth, uName.DateOfBirthCount, uName.IsEmpID, uName.EmpIDCount, uName.IsSocialSecurityNoLastCharacters, uName.SocialSecurityNoLastCharactersCount, uName.SSN_MaskingID, uName.SSN_Masking_ScreensID, uName.IsLetterMustForPIN, uName.IsDigitMustForPIN, uName.IsSpCharMustForPIN, uName.IsUpperCharMustForPIN, uName.IsLowerCharMustForPIN, uName.MinCharactersForPIN, uName.MaxCharactersForPIN, uName.ExactLengthOfPIN, uName.IsEmailID, pWord.IsLastName as IsLastNameForPassword, pWord.LastNameCount as LastNameCountForPassword, pWord.IsFirstName as IsFirstNameForPassword,  pWord.FirstNameCount as FirstNameCountForPassword,  pWord.IsSocialSecurityNo as IsSocialSecurityNoForPassword, pWord.SocialSecurityNoCount as SocialSecurityNoCountForPassword, pWord.IsDateOfBirth as IsDateOfBirthForPassword, pWord.DateOfBirthCount as DateOfBirthCountForPassword, pWord.IsEmpID as IsEmpIDForPassword, pWord.EmpIDCount as EmpIDCountForPassword, pWord.IsLetterMust, pWord.IsDigitMust, pWord.IsSpCharMust, pWord.IsUpperCharMust, pWord.IsLowerCharMust,  pWord.MinCharacters,  pWord.MaxCharacters,  pWord.ExactLength,  pWord.IsRequiredCurrentPwd,  pWord.ExpiryDays,  pWord.DefaultPassword , sPolicy.AttemptsToFailAccount,  sPolicy.AttemptsToFailSession,  sPolicy.RequiredMinutesInFailedLogin, sPolicy.DisallowedMinOnDisabledLogin,  sPolicy.UseMFA,  sPolicy.MFATokenLength,  sPolicy.MFAFailAttempts  							
from UserNameCredentials uName,  PasswordCredentials pWord,							
SecurityPolicy sPolicy							
							
OnlineEnrollment							
Update PasswordCredentials SET IsLetterMust = 1, IsDigitMust = 1, IsSpCharMust = 1, IsUpperCharMust = 1, IsLowerCharMust = 1,  MinCharacters = 10							
							
MasterCompanyDB							
Update PasswordCredentials SET IsLetterMust = 1, IsDigitMust = 1, IsSpCharMust = 1, IsUpperCharMust = 1, IsLowerCharMust = 1,  MinCharacters = 10							
							
Update	UserNameCredentials 						
SET		IsLastName=1, LastNameCount=4, 					
		IsFirstName=1,  FirstNameCount=1,  					
		IsSocialSecurityNo=1, SocialSecurityNoCount=3, 					
		IsDateOfBirth=1, DateOfBirthCount=2					

Update	PasswordCredentials 		
SET		IsLastName=1, LastNameCount=1, 	
		IsFirstName=1,  FirstNameCount=2,  	
		IsSocialSecurityNo=1, SocialSecurityNoCount=3, 	
		IsDateOfBirth=1, DateOfBirthCount=2,	
		IsEmpID=1, EmpIDCount = 2	
