ZTRAX Schema Information : ZTrans Unique Record identifier columns (used to join information across tables for a particular record) (FIPS, TransID) Primary Key Information: [TableName : Primary Key Columns] utBKManagedSpecific : TransID, FIPS utBorrowerMailAddress : TransId, BorrowerMailSequenceNumber, FIPS utBorrowerName : TransId, BorrowerNameSequenceNumber, FIPS utBorrowerNameDescriptionCode : TransId, BorrowerDescSequenceNumber, BorrowerNameSequenceNumber, FIPS utBuyerMailAddress : TransId, BuyerMailSequenceNumber, FIPS utBuyerName : TransId, BuyerNameSequenceNumber, FIPS utBuyerNameDescriptionCode : TransId, BuyerDescSequenceNumber, BuyerNameSequenceNumber, FIPS utDelete : FIPS, TransID utForeclosureNameAddress : TransId, FCNameAddressSequenceNumber, FIPS utForeclosureNODNOSDoc : TransId, OrigNODNOSRecSequenceNumber, FIPS utForeclosureOriginalLoan : TransId, FCOrigLoanSequenceNumber, FIPS utHawaiiBorrowerNotes : TransID, BorrowerNotesSequenceNumber, FIPS utHawaiiGranteeNotes : TransID, GranteeNotesSequenceNumber, FIPS utLegacy : TransID, FIPS utMain : TransId, FIPS utModification : TransId, ModLoanSequenceNumber, FIPS utPropertyInfo : TransId, PropertySequenceNumber, FIPS utRegionSpecific : TransID, FIPS utSellerMailAddress : TransId, SellerMailSequenceNumber, FIPS utSellerName : TransId, SellerNameSequenceNumber, FIPS utSellerNameDescriptionCode : TransId, SellerDescSequenceNumber, SellerNameSequenceNumber, FIPS ZAsmt Unique Record identifier columns (used to join information across tables for a particular record) (FIPS, RowID) Primary Key Information: [TableName : Primary Key Columns] utAdditionalPropertyAddress : RowID, PropertyAddressSequenceNumber, FIPS utBKManagedSpecific : RowID, FIPS utBuilding : RowID, BuildingOrImprovementNumber, FIPS utBuildingAreas : RowID, BuildingOrImprovementNumber, BuildingAreaSequenceNumber, FIPS utCareOfName : RowID, NameSequenceNumber, NameTypeStndCode, MailCareOfName, FIPS utDelete : FIPS, RowID utExteriorWall : RowID, BuildingOrImprovementNumber, ExteriorWallStndCode, FIPS utExtraFeature : RowID, BuildingOrImprovementNumber, ExtraFeatureSequenceNumber, FIPS utGarage : RowID, BuildingOrImprovementNumber, GarageSequenceNumber, FIPS utInteriorFlooring : RowID, BuildingOrImprovementNumber, InteriorFlooringTypeStndCode, FIPS utInteriorWall : RowID, BuildingOrImprovementNumber, InteriorWallStndCode, FIPS utLotSiteAppeal : RowID, LotSiteAppealStndCode, FIPS utMailAddress : RowID, NameTypeStndCode, FIPS utMain : RowID, FIPS utName : RowID, NameSequenceNumber, NameTypeStndCode, FIPS utOby : RowID, BuildingOrImprovementNumber, OBYSequenceNumber, FIPS utPool : RowID, BuildingOrImprovementNumber, PoolStndCode, PoolSize, FIPS utSaleData : RowID, SaleSeqNum, FIPS utTaxDistrict : RowID, TaxDistrictStndCode, TaxDistrictName, FIPS utTaxExemption : RowID, TaxExemptionStndCode, FIPS utTypeConstruction : RowID, BuildingOrImprovementNumber, TypeConstructionStndCode, FIPS utValue : RowID, FIPS utVestingCodes : RowID, NameSequenceNumber, NameTypeStndCode, OwnerVestingStndCode, FIPS