Welcome to Release 14.00 > Navigation and Functional Changes > Field Changes > Columns Renamed |
This section provides a cross reference for old database tables available within the Framework, and database tables that have been renamed between the version 10.31.15 and 14.00.00 release.
The following columns were renamed from database tables during the upgrade:
Old Column Name | New Column Name |
tblAccountActivity.EndDate | AccountServicing.AccountActivity.EndDate |
tblAccountActivity.StartDate | AccountServicing.AccountActivity.StartDate |
tblCaseActivity.EndDate | AccountServicing.CaseActivity.EndDate |
tblCaseActivity.StartDate | AccountServicing.CaseActivity.StartDate |
tblCoborrower.CB1Relationship | Collections.AccountRelationship.RelationshipToPrimary |
tblCoborrower.CB2Relationship | Collections.AccountRelationship.RelationshipToPrimary |
tblCoborrower.CB3Relationship | Collections.AccountRelationship.RelationshipToPrimary |
tblCoborrower.CB4Relationship | Collections.AccountRelationship.RelationshipToPrimary |
tblSolutionCBSAccount.BorrowerRelationship | Collections.AccountRelationship.RelationshipToPrimary |
tblBankruptcyInfo.AllClaimsCompletedDate | Collections.CaseBankruptcy.AllClaimsCompletedDate |
tblBankruptcyInfo.AssetCase | Collections.CaseBankruptcy.AssetCase |
tblForeclosureAttorney.BorrowerAttorneyAddress1 | Collections.CaseBankruptcy.AttorneyAddress1 |
tblBankruptcyInfo.CaseNumber | Collections.CaseBankruptcy.BankruptcyCourtCaseNumber |
tblLookup.LookupDesc | Collections.CaseBankruptcy.ChapterDescription |
tblBankruptcyInfo.ChapterID | Collections.CaseBankruptcy.ChapterId |
tblLookup.LookupCode | Collections.CaseBankruptcy.ChapterId |
tblBankruptcyInfo.ConvertedFlag | Collections.CaseBankruptcy.ConvertedFlag |
tblCaseCourt.CourtAddress1 | Collections.CaseBankruptcy.CourtAddressLine1 |
tblCaseCourt.CourtAddress2 | Collections.CaseBankruptcy.CourtAddressLine2 |
tblCaseCourt.CourtCity | Collections.CaseBankruptcy.CourtCity |
tblCaseCourt.ClerkEmail | Collections.CaseBankruptcy.CourtClerkEmailAddress |
tblCaseCourt.ClerkFax | Collections.CaseBankruptcy.CourtClerkFax |
tblCaseCourt.ClerkName | Collections.CaseBankruptcy.CourtClerkName |
tblCaseCourt.ClerkPhone | Collections.CaseBankruptcy.CourtClerkWorkTelephoneNumber |
tblCaseCourt.CourtFax | Collections.CaseBankruptcy.CourtFax |
tblCaseCourt.District | Collections.CaseBankruptcy.CourtJudicialDistrictId |
tblCaseCourt.CourtLocation | Collections.CaseBankruptcy.CourtLocation |
tblCaseCourt.Court | Collections.CaseBankruptcy.CourtName |
tblCaseCourt.CourtState | Collections.CaseBankruptcy.CourtState |
tblCaseCourt.CourtPhone | Collections.CaseBankruptcy.CourtWorkTelephoneNumber |
tblCaseCourt.CourtPostal | Collections.CaseBankruptcy.CourtZip |
tblBankruptcyInfo.ConvertedDate | Collections.CaseBankruptcy.DateConverted |
tblBankruptcyInfo.DateFiled | Collections.CaseBankruptcy.DateFiled |
tblBankruptcyInfo.DateReceived | Collections.CaseBankruptcy.DateReceived |
tblBankruptcyInfo.DischargeDate | Collections.CaseBankruptcy.DischargeDate |
tblBankruptcyInfo.DismissalDate | Collections.CaseBankruptcy.DismissalDate |
tblBankruptcyInfo.DismissalCodeID | Collections.CaseBankruptcy.DismissalTypeId |
tblLookup.LookupCode | Collections.CaseBankruptcy.DismissalTypeId |
tblLookup.LookupDesc | Collections.CaseBankruptcy.DismissalTypeId |
tblBankruptcyInfo.DispositionCode | Collections.CaseBankruptcy.DispositionId |
tblBankruptcyInfo.ECOA | Collections.CaseBankruptcy.ECOACodeId |
tblBankruptcyInfo.FilerAssets | Collections.CaseBankruptcy.FilerAssets |
tblBankruptcyInfo.FilerLiabilities | Collections.CaseBankruptcy.FilerLiabilities |
tblBankruptcyInfo.FilingCity | Collections.CaseBankruptcy.FilingCity |
tblBankruptcyInfo.FilingCounty | Collections.CaseBankruptcy.FilingCounty |
tblBankruptcyInfo.FilingState | Collections.CaseBankruptcy.FilingState |
tblBankruptcyInfo.FilingStatus | Collections.CaseBankruptcy.FilingStatus |
tblCaseCourt.JudgeAddress1 | Collections.CaseBankruptcy.JudgeAddressLine1 |
tblCaseCourt.JudgeAddress2 | Collections.CaseBankruptcy.JudgeAddressLine2 |
tblCaseCourt.JudgeCity | Collections.CaseBankruptcy.JudgeCity |
tblCaseCourt.JudgeEmail | Collections.CaseBankruptcy.JudgeEmailAddress |
tblCaseCourt.JudgeFax | Collections.CaseBankruptcy.JudgeFax |
tblCaseCourt.JudgeInitials | Collections.CaseBankruptcy.JudgeInitials |
tblCaseCourt.JudgeName | Collections.CaseBankruptcy.JudgeName |
tblCaseCourt.JudgeState | Collections.CaseBankruptcy.JudgeState |
tblCaseCourt.JudgePhone | Collections.CaseBankruptcy.JudgeWorkTelephoneNumber |
tblCaseCourt.JudgePostal | Collections.CaseBankruptcy.JudgeZip |
tblBankruptcyInfo.NotifiedBy | Collections.CaseBankruptcy.NotificationSource |
tblBankruptcyInfo.NumberOfCreditors | Collections.CaseBankruptcy.NumberOfCreditors |
tblBankruptcyInfo.ObjectionFiledDate | Collections.CaseBankruptcy.ObjectionFiledDate |
tblBankruptcyInfo.PlanInterestRate | Collections.CaseBankruptcy.PlanInterestRate |
tblBankruptcyInfo.PlanTotalAmount | Collections.CaseBankruptcy.PlanTotalAmount |
tblBankruptcyInfo.PriorBankruptcyCaseNumber | Collections.CaseBankruptcy.PriorBankruptcyCaseNumber |
tblBankruptcyInfo.PriorBankruptcyDistrict | Collections.CaseBankruptcy.PriorBankruptcyDistrict |
tblBankruptcyInfo.PriorBankruptcyFilingDate | Collections.CaseBankruptcy.PriorBankruptcyFilingDate |
tblBankruptcyInfo.ClaimsDeadline | Collections.CaseBankruptcy.ProofOfClaimsFilingDeadline |
tblBankruptcyTrustee.Address1 | Collections.CaseBankruptcy.TrusteeAddressLine1 |
tblBankruptcyTrustee.Address2 | Collections.CaseBankruptcy.TrusteeAddressLine2 |
tblBankruptcyTrustee.City | Collections.CaseBankruptcy.TrusteeCity |
tblBankruptcyTrustee.Email | Collections.CaseBankruptcy.TrusteeEmailAddress |
tblBankruptcyTrustee.Fax | Collections.CaseBankruptcy.TrusteeFaxNumber |
tblBankruptcyTrustee.Name | Collections.CaseBankruptcy.TrusteeName |
tblBankruptcyTrustee.State | Collections.CaseBankruptcy.TrusteeState |
tblBankruptcyTrustee.Phone | Collections.CaseBankruptcy.TrusteeWorkTelephoneNumber |
tblBankruptcyTrustee.Postal | Collections.CaseBankruptcy.TrusteeZip |
tblBankruptcyInfo.VoluntaryDismissal | Collections.CaseBankruptcy.VoluntaryDismissal |
tblCaseSecondaryAddress.CS2ADD1Address1 | Collections.CaseBankruptcyParty.AttorneyAddressLine1 |
tblCaseSecondaryAddress.CS3ADD1Address1 | Collections.CaseBankruptcyParty.AttorneyAddressLine1 |
tblCaseSecondaryAddress.CS4ADD1Address1 | Collections.CaseBankruptcyParty.AttorneyAddressLine1 |
tblCaseSecondaryAddress.CS2ADD1Address2 | Collections.CaseBankruptcyParty.AttorneyAddressLine2 |
tblCaseSecondaryAddress.CS3ADD1Address2 | Collections.CaseBankruptcyParty.AttorneyAddressLine2 |
tblCaseSecondaryAddress.CS4ADD1Address2 | Collections.CaseBankruptcyParty.AttorneyAddressLine2 |
tblCaseSecondaryAddress.CS2ADD1Address3 | Collections.CaseBankruptcyParty.AttorneyAddressLine3 |
tblCaseSecondaryAddress.CS3ADD1Address3 | Collections.CaseBankruptcyParty.AttorneyAddressLine3 |
tblCaseSecondaryAddress.CS4ADD1Address3 | Collections.CaseBankruptcyParty.AttorneyAddressLine3 |
tblCaseSecondaryAddress.CS2ADD1City | Collections.CaseBankruptcyParty.AttorneyCity |
tblCaseSecondaryAddress.CS3ADD1City | Collections.CaseBankruptcyParty.AttorneyCity |
tblCaseSecondaryAddress.CS4ADD1City | Collections.CaseBankruptcyParty.AttorneyCity |
tblCaseSecondary.CS2Email | Collections.CaseBankruptcyParty.AttorneyEmailAddress |
tblCaseSecondary.CS4Email | Collections.CaseBankruptcyParty.AttorneyEmailAddress |
tblCaseSecondaryPhone.CS2PH4Phone | Collections.CaseBankruptcyParty.AttorneyFaxNumber |
tblCaseSecondaryPhone.CS3PH4Phone | Collections.CaseBankruptcyParty.AttorneyFaxNumber |
tblCaseSecondaryPhone.CS4PH4Phone | Collections.CaseBankruptcyParty.AttorneyFaxNumber |
tblCaseSecondaryPhone.CS2PH1Phone | Collections.CaseBankruptcyParty.AttorneyHomeTelephoneNumber |
tblCaseSecondaryPhone.CS3PH1Phone | Collections.CaseBankruptcyParty.AttorneyHomeTelephoneNumber |
tblCaseSecondaryPhone.CS4PH1Phone | Collections.CaseBankruptcyParty.AttorneyHomeTelephoneNumber |
tblCaseSecondaryPhone.CS2PH3Phone | Collections.CaseBankruptcyParty.AttorneyMobileTelephoneNumber |
tblCaseSecondaryPhone.CS3PH3Phone | Collections.CaseBankruptcyParty.AttorneyMobileTelephoneNumber |
tblCaseSecondaryPhone.CS4PH3Phone | Collections.CaseBankruptcyParty.AttorneyMobileTelephoneNumber |
tblCaseSecondary.CS2FirstName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS2LastName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS2MiddleName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3FirstName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3FullName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3LastName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3MiddleName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3Prefix | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3Suffix | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS3Title | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS4FirstName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS4LastName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondary.CS4MiddleName | Collections.CaseBankruptcyParty.AttorneyRepresentingParty |
tblCaseSecondaryAddress.CS2ADD1State | Collections.CaseBankruptcyParty.AttorneyState |
tblCaseSecondaryAddress.CS3ADD1State | Collections.CaseBankruptcyParty.AttorneyState |
tblCaseSecondaryAddress.CS4ADD1State | Collections.CaseBankruptcyParty.AttorneyState |
tblCaseSecondaryPhone.CS2PH2Phone | Collections.CaseBankruptcyParty.AttorneyWorkTelephoneNumber |
tblCaseSecondaryPhone.CS3PH2Phone | Collections.CaseBankruptcyParty.AttorneyWorkTelephoneNumber |
tblCaseSecondaryPhone.CS4PH2Phone | Collections.CaseBankruptcyParty.AttorneyWorkTelephoneNumber |
tblCaseSecondaryAddress.CS2ADD1Postal | Collections.CaseBankruptcyParty.AttorneyZip |
tblCaseSecondaryAddress.CS3ADD1Postal | Collections.CaseBankruptcyParty.AttorneyZip |
tblCaseSecondaryAddress.CS4ADD1Postal | Collections.CaseBankruptcyParty.AttorneyZip |
tblCaseSecondary.CS2Employer | Collections.CaseBankruptcyParty.FirmRepresentingParty |
tblCaseSecondary.CS3Employer | Collections.CaseBankruptcyParty.FirmRepresentingParty |
tblCaseSecondary.CS4Employer | Collections.CaseBankruptcyParty.FirmRepresentingParty |
tblCaseSecondary.CS1Gender | Collections.CaseBankruptcyParty.Notes |
tblCaseSecondaryAddress.CS1ADD1Address1 | Collections.CaseBankruptcyParty.PartyAddressLine1 |
tblCaseSecondaryAddress.CS1ADD1Address2 | Collections.CaseBankruptcyParty.PartyAddressLine2 |
tblCaseSecondaryAddress.CS1ADD1Address3 | Collections.CaseBankruptcyParty.PartyAddressLine3 |
tblCaseSecondaryAddress.CS1ADD1City | Collections.CaseBankruptcyParty.PartyCity |
tblBankruptcyCreditor.Email | Collections.CaseBankruptcyParty.PartyEmailAddress |
tblCaseSecondary.CS1Email | Collections.CaseBankruptcyParty.PartyEmailAddress |
tblBankruptcyCreditor.Fax | Collections.CaseBankruptcyParty.PartyFaxNumber |
tblCaseSecondaryPhone.CS1PH4Phone | Collections.CaseBankruptcyParty.PartyFaxNumber |
tblCaseSecondary.CS1FirstName | Collections.CaseBankruptcyParty.PartyFirstName |
tblBankruptcyCreditor.Name | Collections.CaseBankruptcyParty.PartyFullName |
tblCaseSecondary.CS1FullName | Collections.CaseBankruptcyParty.PartyFullName |
tblCaseSecondaryPhone.CS1PH1Phone | Collections.CaseBankruptcyParty.PartyHomeTelephoneNumber |
tblCaseSecondary.CS1LastName | Collections.CaseBankruptcyParty.PartyLastName |
tblCaseSecondary.CS1MiddleName | Collections.CaseBankruptcyParty.PartyMiddleName |
tblCaseSecondaryPhone.CS1PH3Phone | Collections.CaseBankruptcyParty.PartyMobileTelephoneNumber |
tblCaseSecondaryAddress.CS1ADD1State | Collections.CaseBankruptcyParty.PartyState |
tblCaseSecondary.CS1Suffix | Collections.CaseBankruptcyParty.PartySuffix |
tblCaseSecondary.CS2Suffix | Collections.CaseBankruptcyParty.PartySuffix |
tblCaseSecondary.CS4Suffix | Collections.CaseBankruptcyParty.PartySuffix |
tblCaseSecondary.CS1SSN | Collections.CaseBankruptcyParty.PartyTIN |
tblCaseSecondary.CS1Prefix | Collections.CaseBankruptcyParty.PartyTitle |
tblCaseSecondary.CS2Title | Collections.CaseBankruptcyParty.PartyTitle |
tblCaseSecondary.CS4Title | Collections.CaseBankruptcyParty.PartyTitle |
tblBankruptcyCreditor.Phone | Collections.CaseBankruptcyParty.PartyWorkTelephoneNumber |
tblCaseSecondaryPhone.CS1PH2Phone | Collections.CaseBankruptcyParty.PartyWorkTelephoneNumber |
tblCaseSecondaryAddress.CS1ADD1Postal | Collections.CaseBankruptcyParty.PartyZip |
tblCaseSecondaryAddress.CS1ADD1Address1 | Collections.CaseParty.AddressLine1 |
tblCaseSecondaryAddress.CS2ADD1Address1 | Collections.CaseParty.AddressLine1 |
tblCaseSecondaryAddress.CS3ADD1Address1 | Collections.CaseParty.AddressLine1 |
tblCaseSecondaryAddress.CS1ADD1Address2 | Collections.CaseParty.AddressLine2 |
tblCaseSecondaryAddress.CS2ADD1Address2 | Collections.CaseParty.AddressLine2 |
tblCaseSecondaryAddress.CS3ADD1Address2 | Collections.CaseParty.AddressLine2 |
tblCaseSecondaryAddress.CS1ADD1Address3 | Collections.CaseParty.AddressLine3 |
tblCaseSecondaryAddress.CS2ADD1Address3 | Collections.CaseParty.AddressLine3 |
tblCaseSecondaryAddress.CS3ADD1Address3 | Collections.CaseParty.AddressLine3 |
tblCaseSecondary.CS1Employer | Collections.CaseParty.BusinessName |
tblCaseSecondary.CS2Employer | Collections.CaseParty.BusinessName |
tblCaseSecondaryAddress.CS1ADD1City | Collections.CaseParty.City |
tblCaseSecondaryAddress.CS2ADD1City | Collections.CaseParty.City |
tblCaseSecondaryAddress.CS3ADD1City | Collections.CaseParty.City |
tblCaseSecondary.CS1Email | Collections.CaseParty.EmailAddress |
tblCaseSecondary.CS2Email | Collections.CaseParty.EmailAddress |
tblCaseSecondary.CS1FirstName | Collections.CaseParty.FirstName |
tblCaseSecondary.CS2FirstName | Collections.CaseParty.FirstName |
tblCaseSecondary.CS1FullName | Collections.CaseParty.FullName |
tblCaseSecondary.CS2FullName | Collections.CaseParty.FullName |
tblCaseSecondary.CS3FullName | Collections.CaseParty.FullName |
tblCaseSecondaryPhone.CS1PH1Phone | Collections.CaseParty.HomePhone |
tblCaseSecondaryPhone.CS2PH1Phone | Collections.CaseParty.HomePhone |
tblCaseSecondaryPhone.CS3PH1Phone | Collections.CaseParty.HomePhone |
tblCaseSecondary.CS1LastName | Collections.CaseParty.LastName |
tblCaseSecondary.CS2LastName | Collections.CaseParty.LastName |
tblCaseSecondary.CS1MiddleName | Collections.CaseParty.MiddleInitial |
tblCaseSecondary.CS2MiddleName | Collections.CaseParty.MiddleInitial |
tblCaseSecondaryPhone.CS1PH3Phone | Collections.CaseParty.MobilePhone |
tblCaseSecondaryPhone.CS2PH3Phone | Collections.CaseParty.MobilePhone |
tblCaseSecondaryPhone.CS3PH3Phone | Collections.CaseParty.MobilePhone |
tblCaseSecondaryAddress.CS1ADD1Postal | Collections.CaseParty.PostalCode |
tblCaseSecondaryAddress.CS2ADD1Postal | Collections.CaseParty.PostalCode |
tblCaseSecondaryAddress.CS3ADD1Postal | Collections.CaseParty.PostalCode |
tblCaseSecondaryAddress.CS1ADD1State | Collections.CaseParty.State |
tblCaseSecondaryAddress.CS2ADD1State | Collections.CaseParty.State |
tblCaseSecondaryAddress.CS3ADD1State | Collections.CaseParty.State |
tblCaseSecondary.CS1Suffix | Collections.CaseParty.Suffix |
tblCaseSecondary.CS2Suffix | Collections.CaseParty.Suffix |
tblCaseSecondary.CS1SSN | Collections.CaseParty.TIN |
tblCaseSecondary.CS2SSN | Collections.CaseParty.TIN |
tblCaseSecondary.CS1Prefix | Collections.CaseParty.Title |
tblCaseSecondary.CS1Title | Collections.CaseParty.Title |
tblCaseSecondary.CS2Prefix | Collections.CaseParty.Title |
tblCaseSecondary.CS2Title | Collections.CaseParty.Title |
tblCaseSecondaryPhone.CS1PH2Phone | Collections.CaseParty.WorkPhone |
tblCaseSecondaryPhone.CS2PH2Phone | Collections.CaseParty.WorkPhone |
tblCaseSecondaryPhone.CS3PH2Phone | Collections.CaseParty.WorkPhone |
tblRepoInfo.AmountChargedOff | Collections.CaseRepossession.AmountChargedOff |
tblRepoInfo.AmountRecovered | Collections.CaseRepossession.AmountRecovered |
tblRepoInfo.AuthorizedDate | Collections.CaseRepossession.AuthorizedDate |
tblRepoInfo.AuthorizePerson | Collections.CaseRepossession.AuthorizePerson |
tblRepoVehicle.BlackBookValue | Collections.CaseRepossession.BlackBookValue |
tblRepoVehicle.BlueBookValue | Collections.CaseRepossession.BlueValue |
tblRepoInfo.RepoDate | Collections.CaseRepossession.DateRepossessed |
tblRepoAssignment.DQAmount | Collections.CaseRepossession.DQAmount |
tblRepoVehicle.EdmundsValue | Collections.CaseRepossession.EdmundsValue |
tblRepoVehicle.PhotosReceived | Collections.CaseRepossession.IsPhotosReceived |
tblRepoAssignment.LoanBalance | Collections.CaseRepossession.LoanBalance |
tblRepoInfo.LossAmount | Collections.CaseRepossession.LossAmount |
tblRepoVehicle.Mileage | Collections.CaseRepossession.MileageWhenRepossessed |
tblRepoVehicle.NADAValue | Collections.CaseRepossession.NADAValue |
tblRepoVehicle.NOSL | Collections.CaseRepossession.NOSL |
tblRepoInfo.OriginalLoanDate | Collections.CaseRepossession.OriginalLoanDate |
tblRepoAssignment.PastDuePaymentDate | Collections.CaseRepossession.PastDuePaymentDate |
tblRepoVehicle.PhotosReceivedDate | Collections.CaseRepossession.PhotosReceivedDate |
tblRepoInfo.RepoStatusReason | Collections.CaseRepossession.RepossessionReasonCodeId |
tblRepoAssignment.ScheduledPayment | Collections.CaseRepossession.ScheduledPayment |
tblCaseSecondaryAddress.CS3ADD1Address1 | Collections.CaseRepossessionAssignment.AgentAddress1 |
tblCaseSecondaryAddress.CS3ADD1Address2 | Collections.CaseRepossessionAssignment.AgentAddress2 |
tblCaseSecondaryAddress.CS3ADD1Address3 | Collections.CaseRepossessionAssignment.AgentAddress3 |
tblCaseSecondary.CS3Employer | Collections.CaseRepossessionAssignment.AgentBusinessName |
tblCaseSecondaryAddress.CS3ADD1City | Collections.CaseRepossessionAssignment.AgentCity |
tblCaseSecondary.CS3FirstName | Collections.CaseRepossessionAssignment.AgentContactFirstName |
tblCaseSecondary.CS3FullName | Collections.CaseRepossessionAssignment.AgentContactFullName |
tblCaseSecondary.CS3LastName | Collections.CaseRepossessionAssignment.AgentContactLastName |
tblCaseSecondary.CS3MiddleName | Collections.CaseRepossessionAssignment.AgentContactMiddleName |
tblCaseSecondary.CS3Prefix | Collections.CaseRepossessionAssignment.AgentContactPrefix |
tblCaseSecondary.CS3Suffix | Collections.CaseRepossessionAssignment.AgentContactSuffix |
tblCaseSecondary.CS3Title | Collections.CaseRepossessionAssignment.AgentContactTitle |
tblCaseSecondary.CS3Email | Collections.CaseRepossessionAssignment.AgentEmailAddress |
tblCaseSecondaryPhone.CS3PH5Phone | Collections.CaseRepossessionAssignment.AgentFaxPhone |
tblCaseSecondaryPhone.CS3PH1Phone | Collections.CaseRepossessionAssignment.AgentHomePhone |
tblCaseSecondaryPhone.CS3PH3Phone | Collections.CaseRepossessionAssignment.AgentMobilePhone |
tblCaseSecondaryPhone.CS3PH4Phone | Collections.CaseRepossessionAssignment.AgentOtherPhone |
tblCaseSecondaryAddress.CS3ADD1Postal | Collections.CaseRepossessionAssignment.AgentPostalCode |
tblCaseSecondaryAddress.CS3ADD1State | Collections.CaseRepossessionAssignment.AgentState |
tblCaseSecondaryPhone.CS3PH2Phone | Collections.CaseRepossessionAssignment.AgentWorkPhone |
tblRepoVehicle.Condition | Collections.CaseRepossessionCondition.ConditionId |
tblRepoVehicle.ConditionReportReceivedDate | Collections.CaseRepossessionCondition.ConditionReportDate |
tblRepoVehicle.ConditionReportReceived | Collections.CaseRepossessionCondition.IsConditionReportReceived |
tblRepoVehicle.Description | Collections.CaseRepossessionCondition.Notes |
tblRepoVehicle.LocationOfUnit | Collections.CaseRepossessionLocation.VehicleLocation |
tblAccountCollateral.CollateralAddress | Collections.Collateral.AddressLine1 |
tblAccountCollateral.CollateralAddress2 | Collections.Collateral.AddressLine2 |
tblAccountCollateral.CollateralAddress3 | Collections.Collateral.AddressLine3 |
tblAccountCollateral.AppraisalAmount | Collections.Collateral.AppraisValue |
tblAccountMortgage.AppraisValue | Collections.Collateral.AppraisValue |
tblAccountMortgage.AssocCode | Collections.Collateral.AssociationCode |
tblAccountMortgage.CensusTract | Collections.Collateral.CensusTract |
tblAccountCollateral.CollateralCity | Collections.Collateral.City |
tblAccountMortgage.PropertyCity | Collections.Collateral.City |
tblAccountSecured.PropertyCity | Collections.Collateral.City |
tblAccountCollateral.CollateralCode | Collections.Collateral.CollateralCode |
tblAccountCollateral.CollateralCode2 | Collections.Collateral.CollateralCode |
tblAccountCollateral.CollateralCode3 | Collections.Collateral.CollateralCode |
tblAccountCollateral.CollateralCode4 | Collections.Collateral.CollateralCode |
tblAccountCollateral.Description1 | Collections.Collateral.CollateralDescription |
tblAccountCollateral.ShortDescription2 | Collections.Collateral.CollateralDescription |
tblAccountCollateral.ShortDescription3 | Collections.Collateral.CollateralDescription |
tblAccountCollateral.ShortDescription4 | Collections.Collateral.CollateralDescription |
tblAccountCollateral.Description2 | Collections.Collateral.CollateralDescription2 |
tblAccountCollateral.Description3 | Collections.Collateral.CollateralDescription3 |
tblAccountCollateral.CollateralType | Collections.Collateral.CollateralTypeDescription |
tblAccountAuto.Value | Collections.Collateral.CollateralValue |
tblAccountCollateral.CollateralValue | Collections.Collateral.CollateralValue |
tblAccountCollateral.CollateralValueDate | Collections.Collateral.CollateralValueDate |
tblAccountAuto.Color | Collections.Collateral.Color |
tblRepoVehicle.Color | Collections.Collateral.Color |
tblAccountMortgage.County | Collections.Collateral.County |
tblAccountSecured.County | Collections.Collateral.County |
tblAccountCollateral.CreditLife | Collections.Collateral.CreditLife |
tblAccountAuto.DealerCode | Collections.Collateral.DealerCode |
tblAccountAuto.Dealer | Collections.Collateral.DealerName |
tblAccountAuto.DealerPrivate | Collections.Collateral.DealerPrivate |
tblAccountMortgage.DistrictCode | Collections.Collateral.District |
tblAccountMortgage.FirstSecMortgFlag | Collections.Collateral.FirstSecMortgFlag |
tblAccountMortgage.FloodCommunityNumber | Collections.Collateral.FloodCommunityNumber |
tblAccountMortgage.FloodPanelNumber | Collections.Collateral.FloodPanelNumber |
tblAccountMortgage.FloodZone | Collections.Collateral.FloodZoneDescription |
tblAccountCollateral.GAPInsurance | Collections.Collateral.GAPInsurance |
tblAccountMortgage.HazInsurCode | Collections.Collateral.HazardInsuranceCode |
tblAccountAuto.Insurance | Collections.Collateral.Insurance |
tblAccountAuto.InsuranceAgentName | Collections.Collateral.InsuranceAgentName |
tblAccountAuto.InsuranceAgentPhoneNumber | Collections.Collateral.InsuranceAgentPhoneNumber |
tblAccountMortgage.InsuranceCancelDate | Collections.Collateral.InsuranceCancelDate |
tblAccountAuto.InsuranceCompany | Collections.Collateral.InsuranceCompany |
tblAccountMortgage.InsuranceCompany | Collections.Collateral.InsuranceCompany |
tblAccountMortgage.InsuranceExpirationDate | Collections.Collateral.InsuranceExpirationDate |
tblAccountMortgage.InsuranceInceptionDate | Collections.Collateral.InsuranceInceptionDate |
tblAccountAuto.InsurancePolicyNumber | Collections.Collateral.InsurancePolicyNumber |
tblAccountMortgage.FloodRequiredFlag | Collections.Collateral.IsFloodRequired |
tblAccountCollateral.LastRepriceDate | Collections.Collateral.LastRepriceDate |
tblAccountAuto.LicensePlate | Collections.Collateral.LicensePlateNumber |
tblRepoVehicle.LicensePlate | Collections.Collateral.LicensePlateNumber |
tblAccountCollateral.LocationCode | Collections.Collateral.LocationCode |
tblAccountAuto.Make | Collections.Collateral.Make |
tblAccountAuto.Make2 | Collections.Collateral.Make |
tblAccountAuto.Make3 | Collections.Collateral.Make |
tblAccountAuto.Make4 | Collections.Collateral.Make |
tblRepoVehicle.Make | Collections.Collateral.Make |
tblAccountMortgage.MapEffectiveDate | Collections.Collateral.MapEffectiveDate |
tblAccountCollateral.MarginPercentage | Collections.Collateral.MarginPercentage |
tblAccountAuto.Mileage | Collections.Collateral.Mileage |
tblAccountAuto.Model | Collections.Collateral.Model |
tblAccountAuto.Model2 | Collections.Collateral.Model |
tblAccountAuto.Model3 | Collections.Collateral.Model |
tblAccountAuto.Model4 | Collections.Collateral.Model |
tblRepoVehicle.Model | Collections.Collateral.Model |
tblAccountAuto.NewUsed | Collections.Collateral.NewUsed |
tblAccountCollateral.NumberOfUnits | Collections.Collateral.NumberOfUnits |
tblAccountMortgage.Occupancy | Collections.Collateral.Occupancy |
tblAccountCollateral.AppraisalDate | Collections.Collateral.OriginalAppraisalDate |
tblAccountMortgage.AppraisalDate | Collections.Collateral.OriginalAppraisalDate |
tblAccountCollateral.OriginalValue | Collections.Collateral.OriginalValue |
tblAccountMortgage.PlanName | Collections.Collateral.PlanName |
tblAccountCollateral.PledgeAmount | Collections.Collateral.PledgeAmount |
tblAccountCollateral.PoolCollateralNumber | Collections.Collateral.PoolCollateralNumber |
tblAccountCollateral.PoolValue | Collections.Collateral.PoolValue |
tblAccountCollateral.CollateralPostal | Collections.Collateral.PostalCode |
tblAccountMortgage.PropertyPostal | Collections.Collateral.PostalCode |
tblAccountSecured.PropertyPostal | Collections.Collateral.PostalCode |
tblAccountMortgage.PrimInsurCode | Collections.Collateral.PrimaryInsuranceCode |
tblAccountMortgage.PropertyAddress | Collections.Collateral.PropertyAddress |
tblAccountSecured.PropertyAddress | Collections.Collateral.PropertyAddress |
tblAccountMortgage.PurchasePrice | Collections.Collateral.PurchasePrice |
tblAccountAuto.PurposeCode | Collections.Collateral.PurposeCode |
tblAccountCollateral.PurposeCode | Collections.Collateral.PurposeCode |
tblAccountCollateral.RealtorBuilderCode | Collections.Collateral.RealtorBuilderCode |
tblAccountAuto.Registration | Collections.Collateral.RegistrationNumber |
tblAccountAuto.RetailValue | Collections.Collateral.RetailValue |
tblAccountCollateral.ShortDescription | Collections.Collateral.ShortDescription1 |
tblAccountAuto.State | Collections.Collateral.State |
tblAccountCollateral.CollateralState | Collections.Collateral.State |
tblAccountMortgage.PropertyState | Collections.Collateral.State |
tblAccountSecured.PropertyState | Collections.Collateral.State |
tblAccountMortgage.TaxCode | Collections.Collateral.TaxCode |
tblAccountCollateral.UnitPrice | Collections.Collateral.UnitPrice |
tblAccountMortgage.Usage | Collections.Collateral.Usage |
tblAccountMortgage.VacantPropertyFlag | Collections.Collateral.VacantPropertyFlag |
tblAccountCollateral.VaultReceiptNumber | Collections.Collateral.VaultReceiptNumber |
tblAccountAuto.VIN | Collections.Collateral.VIN |
tblAccountAuto.VIN2 | Collections.Collateral.VIN |
tblAccountAuto.VIN3 | Collections.Collateral.VIN |
tblAccountAuto.VIN4 | Collections.Collateral.VIN |
tblRepoVehicle.VIN | Collections.Collateral.VIN |
tblAccountAuto.Year | Collections.Collateral.Year |
tblAccountAuto.Year2 | Collections.Collateral.Year |
tblAccountAuto.Year3 | Collections.Collateral.Year |
tblAccountAuto.Year4 | Collections.Collateral.Year |
tblRepoVehicle.Year | Collections.Collateral.Year |
tblComment.Comments | Collections.Comment.CommentText |
tblComment.DateCreated | Collections.Comment.CreatedDate |
tblComment.DateModified | Collections.Comment.ModifiedDate |
tblAccountWorkflowComments.PhoneFlag | Collections.WorkflowContactAttempts.ContactType |
tblAccountWorkflowComments.PhoneNumber | Collections.WorkflowContactAttempts.PhoneNumber |
tblWorkflow.ValidContactFlag | Collections.WorkflowContactAttempts.ValidContact |
tblAccountWorkflowObjectInfo.DaysDQ | Collections.WorkflowMap.DaysDQ |
tblAccountWorkflowObjectInfo.DQAmount | Collections.WorkflowMap.DQAmount |
tblAccountWorkflowObjectInfo.NextContactDate | Collections.WorkflowMap.NextContactDate |
tblSolutionSYMITARWarningFlag.CodeFlag1 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag10 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag11 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag12 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag13 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag14 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag15 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag16 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag17 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag18 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag19 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag2 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag20 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag21 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag22 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag23 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag24 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag25 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag26 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag27 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag28 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag29 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag3 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag30 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag31 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag32 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag33 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag34 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag35 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag36 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag37 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag38 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag39 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag4 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag40 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag41 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag42 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag43 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag44 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag45 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag46 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag47 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag48 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag49 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag5 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag50 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag51 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag52 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag53 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag54 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag55 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag56 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag57 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag58 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag59 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag6 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag60 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag61 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag62 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag63 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag64 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag65 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag66 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag67 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag68 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag69 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag7 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag70 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag71 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag72 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag73 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag74 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag75 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag76 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag77 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag78 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag79 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag8 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag80 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag81 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag82 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag83 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag84 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag85 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag86 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag87 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag88 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag89 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag9 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag90 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag91 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag92 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag93 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag94 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag95 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag96 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag97 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag98 | Connector.SymitarWarningCodeFlag |
tblSolutionSYMITARWarningFlag.CodeFlag99 | Connector.SymitarWarningCodeFlag |
tblBorrowerAddress.ADD1Address1 | Core.Address.Address1 |
tblBorrowerAddress.ADD2Address1 | Core.Address.Address1 |
tblBorrowerAddress.ADD3Address1 | Core.Address.Address1 |
tblCasePrimaryAddress.ADD1Address1 | Core.Address.Address1 |
tblCasePrimaryAddress.ADD2Address1 | Core.Address.Address1 |
tblCasePrimaryAddress.ADD3Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB1ADD1Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB1ADD2Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB1ADD3Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB2ADD1Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB2ADD2Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB2ADD3Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB3ADD1Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB3ADD2Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB3ADD3Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB4ADD1Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB4ADD2Address1 | Core.Address.Address1 |
tblCoborrowerAddress.CB4ADD3Address1 | Core.Address.Address1 |
tblBorrowerAddress.ADD1Address2 | Core.Address.Address2 |
tblBorrowerAddress.ADD2Address2 | Core.Address.Address2 |
tblBorrowerAddress.ADD3Address2 | Core.Address.Address2 |
tblCasePrimaryAddress.ADD1Address2 | Core.Address.Address2 |
tblCasePrimaryAddress.ADD2Address2 | Core.Address.Address2 |
tblCasePrimaryAddress.ADD3Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB1ADD1Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB1ADD2Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB1ADD3Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB2ADD1Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB2ADD2Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB2ADD3Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB3ADD1Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB3ADD2Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB3ADD3Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB4ADD1Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB4ADD2Address2 | Core.Address.Address2 |
tblCoborrowerAddress.CB4ADD3Address2 | Core.Address.Address2 |
tblBorrowerAddress.ADD1Address3 | Core.Address.Address3 |
tblBorrowerAddress.ADD2Address3 | Core.Address.Address3 |
tblBorrowerAddress.ADD3Address3 | Core.Address.Address3 |
tblCasePrimaryAddress.ADD1Address3 | Core.Address.Address3 |
tblCasePrimaryAddress.ADD2Address3 | Core.Address.Address3 |
tblCasePrimaryAddress.ADD3Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB1ADD1Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB1ADD2Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB1ADD3Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB2ADD1Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB2ADD2Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB2ADD3Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB3ADD1Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB3ADD2Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB3ADD3Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB4ADD1Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB4ADD2Address3 | Core.Address.Address3 |
tblCoborrowerAddress.CB4ADD3Address3 | Core.Address.Address3 |
tblBorrowerAddress.BadAddressFlag | Core.Address.BadAddressFlag |
tblBorrowerAddress.ADD1City | Core.Address.City |
tblBorrowerAddress.ADD2City | Core.Address.City |
tblBorrowerAddress.ADD3City | Core.Address.City |
tblCasePrimaryAddress.ADD1City | Core.Address.City |
tblCasePrimaryAddress.ADD2City | Core.Address.City |
tblCasePrimaryAddress.ADD3City | Core.Address.City |
tblCoborrowerAddress.CB1ADD1City | Core.Address.City |
tblCoborrowerAddress.CB1ADD2City | Core.Address.City |
tblCoborrowerAddress.CB1ADD3City | Core.Address.City |
tblCoborrowerAddress.CB2ADD1City | Core.Address.City |
tblCoborrowerAddress.CB2ADD2City | Core.Address.City |
tblCoborrowerAddress.CB2ADD3City | Core.Address.City |
tblCoborrowerAddress.CB3ADD1City | Core.Address.City |
tblCoborrowerAddress.CB3ADD2City | Core.Address.City |
tblCoborrowerAddress.CB3ADD3City | Core.Address.City |
tblCoborrowerAddress.CB4ADD1City | Core.Address.City |
tblCoborrowerAddress.CB4ADD2City | Core.Address.City |
tblCoborrowerAddress.CB4ADD3City | Core.Address.City |
tblBorrowerAddress.ADD1Country | Core.Address.Country |
tblBorrowerAddress.ADD2Country | Core.Address.Country |
tblBorrowerAddress.ADD3Country | Core.Address.Country |
tblCasePrimaryAddress.ADD1Country | Core.Address.Country |
tblCasePrimaryAddress.ADD2Country | Core.Address.Country |
tblCasePrimaryAddress.ADD3Country | Core.Address.Country |
tblCoborrowerAddress.CB1ADD1Country | Core.Address.Country |
tblCoborrowerAddress.CB1ADD2Country | Core.Address.Country |
tblCoborrowerAddress.CB1ADD3Country | Core.Address.Country |
tblCoborrowerAddress.CB2ADD1Country | Core.Address.Country |
tblCoborrowerAddress.CB2ADD2Country | Core.Address.Country |
tblCoborrowerAddress.CB2ADD3Country | Core.Address.Country |
tblCoborrowerAddress.CB3ADD1Country | Core.Address.Country |
tblCoborrowerAddress.CB3ADD2Country | Core.Address.Country |
tblCoborrowerAddress.CB3ADD3Country | Core.Address.Country |
tblCoborrowerAddress.CB4ADD1Country | Core.Address.Country |
tblCoborrowerAddress.CB4ADD2Country | Core.Address.Country |
tblCoborrowerAddress.CB4ADD3Country | Core.Address.Country |
tblBorrowerAddress.ADD1Postal | Core.Address.PostalCode |
tblBorrowerAddress.ADD2Postal | Core.Address.PostalCode |
tblBorrowerAddress.ADD3Postal | Core.Address.PostalCode |
tblCasePrimaryAddress.ADD1Postal | Core.Address.PostalCode |
tblCasePrimaryAddress.ADD2Postal | Core.Address.PostalCode |
tblCasePrimaryAddress.ADD3Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB1ADD1Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB1ADD2Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB1ADD3Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB2ADD1Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB2ADD2Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB2ADD3Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB3ADD1Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB3ADD2Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB3ADD3Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB4ADD1Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB4ADD2Postal | Core.Address.PostalCode |
tblCoborrowerAddress.CB4ADD3Postal | Core.Address.PostalCode |
tblBorrowerAddress.ADD1State | Core.Address.State |
tblBorrowerAddress.ADD2State | Core.Address.State |
tblBorrowerAddress.ADD3State | Core.Address.State |
tblCasePrimaryAddress.ADD1State | Core.Address.State |
tblCasePrimaryAddress.ADD2State | Core.Address.State |
tblCasePrimaryAddress.ADD3State | Core.Address.State |
tblCoborrowerAddress.CB1ADD1State | Core.Address.State |
tblCoborrowerAddress.CB1ADD2State | Core.Address.State |
tblCoborrowerAddress.CB1ADD3State | Core.Address.State |
tblCoborrowerAddress.CB2ADD1State | Core.Address.State |
tblCoborrowerAddress.CB2ADD2State | Core.Address.State |
tblCoborrowerAddress.CB2ADD3State | Core.Address.State |
tblCoborrowerAddress.CB3ADD1State | Core.Address.State |
tblCoborrowerAddress.CB3ADD2State | Core.Address.State |
tblCoborrowerAddress.CB3ADD3State | Core.Address.State |
tblCoborrowerAddress.CB4ADD1State | Core.Address.State |
tblCoborrowerAddress.CB4ADD2State | Core.Address.State |
tblCoborrowerAddress.CB4ADD3State | Core.Address.State |
tblBorrower.Email | Core.EmailAddress.EmailAddress |
tblBorrowerEmail.EM1Email | Core.EmailAddress.EmailAddress |
tblBorrowerEmail.EM2Email | Core.EmailAddress.EmailAddress |
tblBorrowerEmail.EM3Email | Core.EmailAddress.EmailAddress |
tblBorrowerEmail.EM4Email | Core.EmailAddress.EmailAddress |
tblBorrowerEmail.EM5Email | Core.EmailAddress.EmailAddress |
tblCaseEmail.EM1Email | Core.EmailAddress.EmailAddress |
tblCaseEmail.EM2Email | Core.EmailAddress.EmailAddress |
tblCaseEmail.EM3Email | Core.EmailAddress.EmailAddress |
tblCaseEmail.EM4Email | Core.EmailAddress.EmailAddress |
tblCaseEmail.EM5Email | Core.EmailAddress.EmailAddress |
tblCasePrimary.Email | Core.EmailAddress.EmailAddress |
tblCoborrower.CB1Email | Core.EmailAddress.EmailAddress |
tblCoborrower.CB2Email | Core.EmailAddress.EmailAddress |
tblCoborrower.CB3Email | Core.EmailAddress.EmailAddress |
tblCoborrower.CB4Email | Core.EmailAddress.EmailAddress |
tblCoborrower.CB1AccountNumber | Core.Person.AccountNumber |
tblCoborrower.CB2AccountNumber | Core.Person.AccountNumber |
tblCoborrower.CB3AccountNumber | Core.Person.AccountNumber |
tblCoborrower.CB4AccountNumber | Core.Person.AccountNumber |
tblBorrower.Age | Core.Person.Age |
tblCasePrimary.Age | Core.Person.Age |
tblBorrower.BirthDate | Core.Person.BirthDate |
tblCasePrimary.BirthDate | Core.Person.BirthDate |
tblCoborrower.CB1BirthDate | Core.Person.BirthDate |
tblCoborrower.CB2BirthDate | Core.Person.BirthDate |
tblCoborrower.CB3BirthDate | Core.Person.BirthDate |
tblCoborrower.CB4BirthDate | Core.Person.BirthDate |
tblBorrower.Branch | Core.Person.Branch |
tblCoborrower.CB1DeathDate | Core.Person.DeceasedDate |
tblCoborrower.CB2DeathDate | Core.Person.DeceasedDate |
tblCoborrower.CB3DeathDate | Core.Person.DeceasedDate |
tblCoborrower.CB4DeathDate | Core.Person.DeceasedDate |
tblBorrower.Department | Core.Person.Department |
tblBorrower.DriverLicenseNumber | Core.Person.DriversLicenseNumber |
tblBorrower.DriverLicenseState | Core.Person.DriversLicenseState |
tblBorrower.Employer | Core.Person.Employer |
tblCasePrimary.Employer | Core.Person.Employer |
tblCoborrower.CB1Employer | Core.Person.Employer |
tblCoborrower.CB2Employer | Core.Person.Employer |
tblCoborrower.CB3Employer | Core.Person.Employer |
tblCoborrower.CB4Employer | Core.Person.Employer |
tblBorrower.FirstName | Core.Person.FirstName |
tblCasePrimary.FirstName | Core.Person.FirstName |
tblCoborrower.CB1FirstName | Core.Person.FirstName |
tblCoborrower.CB2FirstName | Core.Person.FirstName |
tblCoborrower.CB3FirstName | Core.Person.FirstName |
tblCoborrower.CB4FirstName | Core.Person.FirstName |
tblBorrower.FullName | Core.Person.FullName |
tblCasePrimary.FullName | Core.Person.FullName |
tblCoborrower.CB1FullName | Core.Person.FullName |
tblCoborrower.CB2FullName | Core.Person.FullName |
tblCoborrower.CB3FullName | Core.Person.FullName |
tblCoborrower.CB4FullName | Core.Person.FullName |
tblBorrower.Gender | Core.Person.Gender |
tblCasePrimary.Gender | Core.Person.Gender |
tblCoborrower.CB1Gender | Core.Person.Gender |
tblCoborrower.CB2Gender | Core.Person.Gender |
tblCoborrower.CB3Gender | Core.Person.Gender |
tblCoborrower.CB4Gender | Core.Person.Gender |
tblBorrower.Language | Core.Person.Language |
tblBorrower.LastName | Core.Person.LastName |
tblCasePrimary.LastName | Core.Person.LastName |
tblCoborrower.CB1LastName | Core.Person.LastName |
tblCoborrower.CB2LastName | Core.Person.LastName |
tblCoborrower.CB3LastName | Core.Person.LastName |
tblCoborrower.CB4LastName | Core.Person.LastName |
tblBorrower.LockoutDate | Core.Person.LockoutDate |
tblBorrower.MemberCode | Core.Person.MemberCode |
tblBorrower.MiddleName | Core.Person.MiddleName |
tblCasePrimary.MiddleName | Core.Person.MiddleName |
tblCoborrower.CB1MiddleName | Core.Person.MiddleName |
tblCoborrower.CB2MiddleName | Core.Person.MiddleName |
tblCoborrower.CB3MiddleName | Core.Person.MiddleName |
tblCoborrower.CB4MiddleName | Core.Person.MiddleName |
tblBorrower.MotherMaidenName | Core.Person.MotherMaidenName |
tblCoborrower.CB1MotherMaidenName | Core.Person.MotherMaidenName |
tblCoborrower.CB2MotherMaidenName | Core.Person.MotherMaidenName |
tblCoborrower.CB3MotherMaidenName | Core.Person.MotherMaidenName |
tblCoborrower.CB4MotherMaidenName | Core.Person.MotherMaidenName |
tblCoborrower.CB1ID | Core.Person.PersonNumber |
tblCoborrower.CB2ID | Core.Person.PersonNumber |
tblCoborrower.CB3ID | Core.Person.PersonNumber |
tblCoborrower.CB4ID | Core.Person.PersonNumber |
tblBorrower.Prefix | Core.Person.Prefix |
tblCasePrimary.Prefix | Core.Person.Prefix |
tblCoborrower.CB1Prefix | Core.Person.Prefix |
tblCoborrower.CB2Prefix | Core.Person.Prefix |
tblCoborrower.CB3Prefix | Core.Person.Prefix |
tblCoborrower.CB4Prefix | Core.Person.Prefix |
tblBorrower.SecurityPassword | Core.Person.SecurityPassword |
tblCoborrower.CB1SecurityPassword | Core.Person.SecurityPassword |
tblCoborrower.CB2SecurityPassword | Core.Person.SecurityPassword |
tblCoborrower.CB3SecurityPassword | Core.Person.SecurityPassword |
tblCoborrower.CB4SecurityPassword | Core.Person.SecurityPassword |
tblBorrower.SecurityQuestionAnswer | Core.Person.SecurityQuestionAnswer |
tblCoborrower.CB1SecurityQuestionAnswer | Core.Person.SecurityQuestionAnswer |
tblCoborrower.CB2SecurityQuestionAnswer | Core.Person.SecurityQuestionAnswer |
tblCoborrower.CB3SecurityQuestionAnswer | Core.Person.SecurityQuestionAnswer |
tblCoborrower.CB4SecurityQuestionAnswer | Core.Person.SecurityQuestionAnswer |
tblBorrower.SecurityQuestionCode | Core.Person.SecurityQuestionCode |
tblCoborrower.CB1SecurityQuestionCode | Core.Person.SecurityQuestionCode |
tblCoborrower.CB2SecurityQuestionCode | Core.Person.SecurityQuestionCode |
tblCoborrower.CB3SecurityQuestionCode | Core.Person.SecurityQuestionCode |
tblCoborrower.CB4SecurityQuestionCode | Core.Person.SecurityQuestionCode |
tblBorrower.Suffix | Core.Person.Suffix |
tblCasePrimary.Suffix | Core.Person.Suffix |
tblCoborrower.CB1Suffix | Core.Person.Suffix |
tblCoborrower.CB2Suffix | Core.Person.Suffix |
tblCoborrower.CB3Suffix | Core.Person.Suffix |
tblCoborrower.CB4Suffix | Core.Person.Suffix |
tblBorrower.TaxIDCode | Core.Person.TaxIDCode |
tblCoborrower.CB1TaxIDCode | Core.Person.TaxIDCode |
tblCoborrower.CB2TaxIDCode | Core.Person.TaxIDCode |
tblCoborrower.CB3TaxIDCode | Core.Person.TaxIDCode |
tblCoborrower.CB4TaxIDCode | Core.Person.TaxIDCode |
tblBorrower.SSN | Core.Person.TIN |
tblCasePrimary.SSN | Core.Person.TIN |
tblCoborrower.CB1SSN | Core.Person.TIN |
tblCoborrower.CB2SSN | Core.Person.TIN |
tblCoborrower.CB3SSN | Core.Person.TIN |
tblCoborrower.CB4SSN | Core.Person.TIN |
tblBorrower.SSN | Core.Person.TINRaw |
tblBorrower.Title | Core.Person.Title |
tblCasePrimary.Title | Core.Person.Title |
tblCoborrower.CB1Title | Core.Person.Title |
tblCoborrower.CB2Title | Core.Person.Title |
tblCoborrower.CB3Title | Core.Person.Title |
tblCoborrower.CB4Title | Core.Person.Title |
tblBorrowerPhone.WorkExtension | Core.Phone.Extension |
tblCoborrowerPhone.CB1WorkExtension | Core.Phone.Extension |
tblCoborrowerPhone.CB2WorkExtension | Core.Phone.Extension |
tblCoborrowerPhone.CB3WorkExtension | Core.Phone.Extension |
tblCoborrowerPhone.CB4WorkExtension | Core.Phone.Extension |
tblBorrowerPhone.PH1Phone | Core.Phone.PhoneNumber |
tblBorrowerPhone.PH2Phone | Core.Phone.PhoneNumber |
tblBorrowerPhone.PH3Phone | Core.Phone.PhoneNumber |
tblBorrowerPhone.PH4Phone | Core.Phone.PhoneNumber |
tblBorrowerPhone.PH5Phone | Core.Phone.PhoneNumber |
tblCasePrimaryPhone.PH1Phone | Core.Phone.PhoneNumber |
tblCasePrimaryPhone.PH2Phone | Core.Phone.PhoneNumber |
tblCasePrimaryPhone.PH3Phone | Core.Phone.PhoneNumber |
tblCasePrimaryPhone.PH4Phone | Core.Phone.PhoneNumber |
tblCasePrimaryPhone.PH5Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB1PH1Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB1PH2Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB1PH3Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB1PH4Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB1PH5Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB2PH1Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB2PH2Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB2PH3Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB2PH4Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB2PH5Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB3PH1Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB3PH2Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB3PH3Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB3PH4Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB3PH5Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB4PH1Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB4PH2Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB4PH3Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB4PH4Phone | Core.Phone.PhoneNumber |
tblCoborrowerPhone.CB4PH5Phone | Core.Phone.PhoneNumber |
Core.RealEstateValuation.DateReceived | Core.RealEstateValuationHistory.DateReceived |
Core.RealEstateValuation.DateRequested | Core.RealEstateValuationHistory.DateRequested |
Core.RealEstateValuation.FeeCharged | Core.RealEstateValuationHistory.FeeCharged |
Core.RealEstateValuation.ObjectIdentifier | Core.RealEstateValuationHistory.ObjectIdentifier |
Core.RealEstateValuation.PropertyEstimatedValue | Core.RealEstateValuationHistory.PropertyEstimatedValue |
Core.RealEstateValuation.PropertyEstimatedValueRange | Core.RealEstateValuationHistory.PropertyEstimatedValueRange |
Core.RealEstateValuation.PropertyHighValue | Core.RealEstateValuationHistory.PropertyHighValue |
Core.RealEstateValuation.PropertyInspector | Core.RealEstateValuationHistory.PropertyInspectorCompany |
Core.RealEstateValuation.PropertyLowValue | Core.RealEstateValuationHistory.PropertyLowValue |
Core.RealEstateValuation.Score | Core.RealEstateValuationHistory.Score |
Core.RealEstateValuation.ValuationDate | Core.RealEstateValuationHistory.ValuationDate |
Core.RealEstateValuation.ValuationProductId | Core.RealEstateValuationHistory.ValuationProductId |
Core.RealEstateValuation.ValuationTypeId | Core.RealEstateValuationHistory.ValuationTypeId |
Lending.Collateral.ValuationComment | Lending.CollateralValuation.ValuationComment |
Lending.Liability.MaxDelinuencyStatusId | Lending.Liability.MaxDelinquencyStatusId |
Lending.Loan.IsRateVariable | Lending.Loan.IsVariableRate |
tblAccountCertificate.DividendPriorYear | tblAccountCertificate.DividendAccruedPostedYTD |
tblAccountCreditCardSubRecord.NumberMonthsPastDue | tblAccountCreditCardSubRecord.NumMonthsPastDue |
tblAccountDeposit.IRAFedWithPriorYear | tblAccountDeposit.IRAFedWithPriorYTD |
tblAccountDeposit.IRAFedWithPriorYear | tblAccountDeposit.IRAFedWithYTD |
tblSolutionCBSAccount.LoanOfficer | tblAccountInfo.LoanOfficer |
tblSolutionCBSAccount.Password | tblAccountInfo.Password |
tblRepoAssignment.DateAssignedToAgent | tblAccountRepo.DateAssignedToAgent |
tblRepoAssignment.Comment | tblAccountRepo.RepoComment |
tblRepoAssignment.RepoReason | tblAccountRepo.RepoReason |
tblAccountWorkflow.ModifiedByID | tblAccountWorkflow.CreatedByID |
tblCaseType.CaseTypeID | tblCase.CaseTypeID |
tblLookup.LookupCode | tblFraudInfo.ReferralSourceTypeID |
tblLookup.LookupCode | tblFraudInfo.VictimTypeID |
tblLookup.LookupCode | tblFraudRestitution.PaymentFrequencyID |
tblSolutionOSI.CreditReportComment | tblLookup.LookupCode |
tblSolutionOSI.CreditReportConsComment | tblLookup.LookupCode |
tblSolutionOSI.CreditReportStatus | tblLookup.LookupCode |
tblSolutionOSI.CreditRptComplianceCond | tblLookup.LookupCode |
tblAccountWorkflowComments.PhoneType | tblLookup.LookupDesc |
tblCaseLawsuit.LawsuitStatusID | tblLookup.LookupDesc |
tblExpenseTypeLookup.TypeDescription | tblLookup.LookupDesc |
tblExpenseVendor.TypeDescription | tblLookup.LookupDesc |
tblSolutionUSERS.IRACertPentaltiesPriorYTD | tblSolutionUSERS.IRACertPenaltiesPriorYTD |