SmartIntegrator Data Dictionary


Index

  • 4All Objects
  • AUMDashboard
  • AccessLog
  • AcctMaster
  • AcctMasterContact
  • Activity
  • ActivityContact
  • ActivityHistory
  • Address
  • AdvContract
  • AgencySetup
  • Agent
  • AgentContact
  • AgentHierarchy
  • AgentInterestParty
  • AgentLicense
  • AgentManager
  • AgentOfficeMap
  • AgentProdSummary
  • AgentReqs
  • AgentRequest
  • AgentRequirement
  • Annuity
  • Application
  • Appoinment
  • Appointments
  • AssetPreAlloc
  • AssetallocRiskLevel
  • Assignment
  • Auto
  • BankAcct
  • BinaryData
  • BrokerDealer
  • Business
  • BusinessVendor
  • CECredits
  • CECreditsDetail
  • Campaign
  • CarbonCopy
  • Choice
  • CommAdvCheck
  • CommBand
  • CommBatch
  • CommCarrierPay
  • CommExcess
  • CommHierarchy
  • CommImportData
  • CommInvLoad
  • CommInvPosting
  • CommLoadHeader
  • CommLoadPay
  • CommMember
  • CommPayable
  • CommPolTran
  • CommPostCheck
  • CommRate
  • CommRateDetail
  • CommReconcile
  • CommSchedule
  • Contact
  • ContactBenefit
  • ContactBus
  • ContactExtLink
  • ContactVendor
  • Contract
  • CorrTransSettings
  • CorrTransaction
  • CrtIllness
  • CrystalReports
  • CtmSetup
  • CustomData
  • DEXAgent
  • DSIFileWorkFlow
  • DSISystem
  • DXAgent
  • DXDownload
  • DXLoad
  • DXLoadInfo
  • DXLoadPHInfo
  • DXOAdvisorLogin
  • DashboardSetting
  • DataEventLog
  • DeleteLog
  • DeletedGroupCensus
  • Disability
  • DoctorContact
  • DownloadLog
  • Driver
  • DynReport
  • EOStatus
  • EXTInterfaceLogin
  • EZMail
  • EZMailAttachment
  • EZMailFolder
  • EmailQue
  • Endorcement
  • Essyncreport
  • Essyncsetup
  • EventInvitee
  • EventOccurrence
  • EventTemplate
  • Exserverinfo
  • FA
  • GAIDValidate
  • GPPlan
  • GroupCensus
  • GroupParticipant
  • GroupPlan
  • GroupPolicy
  • GsyncHistory
  • GsyncSetup
  • HOContact
  • HOInterestParty
  • HONewBusiness
  • HORep
  • HOSideBYSideReqs
  • HOStatusMain
  • HOStatusNotes
  • HOStatusReqs
  • Homemisc
  • Homeown
  • Hospital
  • HouseHold
  • HouseHoldMember
  • IRole
  • ISMember
  • ISSubscription
  • Illustration
  • Image
  • InsProduct
  • InterestParty
  • InvCommLoadHdr
  • InvPortfolio
  • InvestTicker
  • LAEType
  • LTC
  • LUAccountNum
  • LUHOClientID
  • LUTaxID
  • LastActive
  • LayoutDescription
  • LayoutSubscription
  • Lead
  • LeadPersonal
  • Letter
  • LetterContact
  • LetterSystem
  • Liability
  • Life
  • LoboptionSetup
  • MF
  • Medical
  • Message
  • MessageAttachment
  • MessageReceipt
  • MobileDeviceUser
  • ModuleACL
  • MySets
  • NAILBACode
  • NBDelivery
  • NBHistory
  • NewBusiness
  • NotesReceivable
  • Notification
  • OAnnuity
  • OPolicy
  • Office
  • OfficeHierarchy
  • OfficeSecurityPolicy
  • OldProductCode
  • OldSecurityCode
  • Opportunity
  • OpportunityStage
  • OpportunityStageHistory
  • OpportunityType
  • PCMExtension
  • PCMSetup
  • Page
  • PageContent
  • Participant
  • Person
  • PersonalProperty
  • Phone
  • PlcyExchange
  • PlcyTrack
  • PolPositionHistory
  • PolSubAccount
  • PolTransaction
  • Policy
  • PolicyClaim
  • Position
  • PositionHistory
  • PriceHistory
  • PrnContact
  • ProdBond
  • ProdCash
  • ProdMisc
  • ProdRiskClass
  • ProdStock
  • ProdSubAccount
  • ProdUit
  • ProdVA
  • Product
  • ProductExt
  • ProductFee
  • ProductLicType
  • ProductList
  • ProductOptions
  • ProductState
  • PropCasualty
  • ProposalTracking
  • Proxy
  • PushDataEventLog
  • PushEventSubscription
  • RTGoal
  • RTPosCurr
  • RTPosLic
  • RTPosStage
  • RTPosStageIntv
  • RTPosStageReq
  • RTPosition
  • RTStage
  • Rating
  • RealEstate
  • RecordNote
  • Recruit
  • RecruitBasic
  • RecruitIntv
  • RecruitLicPrep
  • RecruitPreCont
  • RecruitReq
  • RecruitStage
  • Recurrence
  • RelatedContact
  • Relation
  • RelationShip
  • RepContact
  • RepPerson
  • ReportSharing
  • ReqHistory
  • Requirement
  • ResourceSubscription
  • Rider
  • RiskAssignment
  • Role
  • RtInterview
  • RtLicPrep
  • RtPreCont
  • RtReq
  • SITranslog
  • SITranslogHistory
  • SSExport
  • Script
  • SecurityMaster
  • Service
  • ServiceAction
  • ServiceCatagory
  • ServiceInteraction
  • ServiceSubCatagory
  • ServiceTemplate
  • Set
  • SetMember
  • SiteInfo
  • SmartAnalyzer
  • SmartMailLink
  • SmartMailPostingCount
  • SmartMailSetup
  • SmartPad
  • SmartPadArchive
  • SmartPadHistory
  • Subscription
  • SyncLog
  • SyncTransLog
  • TableAssignment
  • TaskTemplate
  • TimeZone
  • Transaction
  • Udentitydata
  • Udentitydef
  • Umbrella
  • UnderReq
  • UnderWriter
  • Underguide
  • UnderguideAge
  • UnderguideFace
  • UnderguideNotes
  • UnderguideReq
  • User
  • UserHierarchy
  • UserMember
  • UserProfile
  • VA
  • Vehicle
  • VenSerProvider
  • Vendor
  • VendorCode
  • VendorExt
  • VendorReq
  • VendorRiskClass
  • WMAccountType
  • WMPositionType
  • WMSetup
  • WMTransactionType
  • WebAddress
  • WordTrack
  • WorkflowDefinition
  • WorkflowInUse
  • 4Top Level Objects
  • AccessLog
  • AcctMaster
  • Activity
  • ActivityContact
  • ActivityHistory
  • Address
  • AdvContract
  • Agent
  • AgentInterestParty
  • AgentLicense
  • AgentOfficeMap
  • AgentRequest
  • AgentRequirement
  • Application
  • Appoinment
  • Appointments
  • AssetPreAlloc
  • BinaryData
  • BrokerDealer
  • CECredits
  • CECreditsDetail
  • Campaign
  • CarbonCopy
  • Choice
  • CommAdvCheck
  • CommBand
  • CommBatch
  • CommCarrierPay
  • CommExcess
  • CommHierarchy
  • CommImportData
  • CommInvLoad
  • CommLoadPay
  • CommMember
  • CommPolTran
  • CommPostCheck
  • CommRate
  • CommRateDetail
  • CommReconcile
  • CommSchedule
  • Contact
  • ContactBus
  • ContactVendor
  • Contract
  • CrtIllness
  • CrystalReports
  • CtmSetup
  • DSIFileWorkFlow
  • DSISystem
  • DXAgent
  • DXLoad
  • DXLoadInfo
  • DXLoadPHInfo
  • DXOAdvisorLogin
  • DataEventLog
  • DeleteLog
  • DownloadLog
  • Driver
  • EOStatus
  • EXTInterfaceLogin
  • EZMail
  • EZMailAttachment
  • EZMailFolder
  • Endorcement
  • Essyncreport
  • Essyncsetup
  • Exserverinfo
  • GroupCensus
  • GroupPolicy
  • GsyncHistory
  • GsyncSetup
  • HouseHold
  • HouseHoldMember
  • IRole
  • ISMember
  • ISSubscription
  • Illustration
  • Image
  • InterestParty
  • InvCommLoadHdr
  • InvestTicker
  • LAEType
  • LUAccountNum
  • LastActive
  • LayoutDescription
  • LayoutSubscription
  • Lead
  • LeadPersonal
  • Letter
  • LetterContact
  • LetterSystem
  • Liability
  • LoboptionSetup
  • Message
  • MessageAttachment
  • MessageReceipt
  • ModuleACL
  • MySets
  • NewBusiness
  • Notification
  • Office
  • OfficeHierarchy
  • OfficeSecurityPolicy
  • Opportunity
  • OpportunityStage
  • OpportunityStageHistory
  • OpportunityType
  • PCMExtension
  • PCMSetup
  • Participant
  • Phone
  • PlcyExchange
  • PlcyTrack
  • PolPositionHistory
  • PolSubAccount
  • PolTransaction
  • Policy
  • Position
  • PositionHistory
  • ProdRiskClass
  • ProdSubAccount
  • Product
  • ProductFee
  • ProductLicType
  • ProductOptions
  • ProposalTracking
  • RTGoal
  • RTPosCurr
  • RTPosLic
  • RTPosStage
  • RTPosStageIntv
  • RTPosStageReq
  • RTPosition
  • RTStage
  • Rating
  • RecordNote
  • Recruit
  • RecruitBasic
  • RecruitIntv
  • RecruitLicPrep
  • RecruitPreCont
  • RecruitReq
  • RecruitStage
  • Recurrence
  • Relation
  • RelationShip
  • RepContact
  • ReportSharing
  • Requirement
  • ResourceSubscription
  • Rider
  • Role
  • RtInterview
  • RtLicPrep
  • RtPreCont
  • RtReq
  • SITranslog
  • SSExport
  • Script
  • SecurityMaster
  • Service
  • ServiceAction
  • ServiceCatagory
  • ServiceInteraction
  • ServiceSubCatagory
  • ServiceTemplate
  • Set
  • SetMember
  • SmartAnalyzer
  • SmartPad
  • SmartPadArchive
  • SmartPadHistory
  • Subscription
  • SyncLog
  • SyncTransLog
  • TableAssignment
  • TimeZone
  • Transaction
  • User
  • UserHierarchy
  • UserMember
  • UserProfile
  • Vehicle
  • VenSerProvider
  • Vendor
  • VendorCode
  • VendorExt
  • VendorRiskClass
  • WebAddress
  • WordTrack
  • WorkflowDefinition
  • WorkflowInUse
  • 4Lookups
  • AccBenPeriod = 2196
  • AccElemPeriod = 2197
  • AccountType = 47
  • AcctMasterAlphanum_1 = 2203
  • AcctMasterAlphanum_2 = 2204
  • AcctMasterStatus = 291
  • AcctRole = 50
  • ActCreatePartOptions = 1899
  • ActionStatus = 2201
  • ActivityOutcome = 64
  • ActivityPriority = 21
  • ActivityStatus = 22
  • ActivitySubtype = 20
  • ActivityType = 19
  • ActivityViewOptions = 490
  • AdapterBillingIndicator = 3150
  • AdapterCategory = 3148
  • AdapterFormat = 3149
  • AdapterStatus = 3151
  • AddressType = 16
  • AdvContAlphaNum3 = 2298
  • AdvisorChecks = 435
  • AdvisorPercOf = 315
  • AdvisorRecordType = 1619
  • AdvisorRequestType = 2098
  • AdvisorVuOptions = 1933
  • AdvisorVuType = 65
  • AgentReqStatus = 1663
  • AgentRequestStatus = 333
  • AgentRequestType = 332
  • AgentRole = 480
  • AgentStatus = 97
  • AgentTypelookup = 96
  • AlertType = 1935
  • AlphanumPlanOfInsType = 2242
  • AnalyzerStatus = 2124
  • AnnualIncome = 2258
  • AppAge = 40
  • AppAgelookup = 35
  • ApplicationStatus = 1577
  • ApprovalStatus = 2169
  • AssetClass = 54
  • AssetSector = 489
  • AssignmentType = 200
  • AuthenticationMode = 2021
  • AvailableInOffice = 2536
  • BankAcctType = 242
  • BenefitLength = 2066
  • BillingOptions = 3153
  • BondType = 55
  • BrokerDealer = 2022
  • BusinessClass = 12
  • BusinessType = 62
  • BuyoutFunding = 430
  • CPValidationStatus = 1908
  • CallOutcomeWF = 1571
  • CampaignClientNeed = 194
  • CampaignStatus = 152
  • CheckVersion = 2123
  • CommAdvPayStatus = 350
  • CommBandType = 313
  • CommBatchStatus = 485
  • CommImportDataStatus = 1621
  • CommInvPlatform = 2188
  • CommPaidBy = 378
  • CommPolTranStatus = 1931
  • CommPolTranType = 1932
  • CommPostCheckStatus = 1620
  • CommPostStatus = 318
  • CommissionType = 320
  • CommissionYear = 2128
  • ComplianceType = 2178
  • CompoundMethod = 147
  • ConKYCLookup1 = 2146
  • ConKYCLookup10 = 2229
  • ConKYCLookup11 = 2230
  • ConKYCLookup12 = 2231
  • ConKYCLookup13 = 2232
  • ConKYCLookup14 = 2233
  • ConKYCLookup15 = 2234
  • ConKYCLookup16 = 2235
  • ConKYCLookup17 = 2236
  • ConKYCLookup18 = 2237
  • ConKYCLookup19 = 2238
  • ConKYCLookup2 = 2147
  • ConKYCLookup20 = 2239
  • ConKYCLookup21 = 2243
  • ConKYCLookup22 = 2244
  • ConKYCLookup23 = 2245
  • ConKYCLookup24 = 2246
  • ConKYCLookup25 = 2247
  • ConKYCLookup26 = 2248
  • ConKYCLookup27 = 2249
  • ConKYCLookup28 = 2250
  • ConKYCLookup29 = 2251
  • ConKYCLookup3 = 2148
  • ConKYCLookup30 = 2252
  • ConKYCLookup4 = 2149
  • ConKYCLookup5 = 2150
  • ConKYCLookup6 = 2225
  • ConKYCLookup7 = 2226
  • ConKYCLookup8 = 2227
  • ConKYCLookup9 = 2228
  • Construction = 44
  • ContactAlphaKey = 1636
  • ContactCustom1 = 364
  • ContactCustom2 = 365
  • ContactCustom3 = 366
  • ContactCustom4 = 367
  • ContactCustom5 = 368
  • ContactCustomAlphanum1 = 1633
  • ContactCustomAlphanum2 = 1634
  • ContactSource = 178
  • ContactSubSource = 179
  • ContactType = 5
  • ContentType = 1905
  • ContractDateType = 384
  • ContractStatus = 317
  • ContractStatusType = 92
  • ContractType = 377
  • CorrTransactionStatus = 3155
  • County = 93
  • CovSelection = 250
  • Custom1 = 650
  • Custom10 = 659
  • Custom11 = 660
  • Custom12 = 661
  • Custom13 = 662
  • Custom14 = 663
  • Custom15 = 664
  • Custom16 = 665
  • Custom17 = 666
  • Custom18 = 667
  • Custom19 = 668
  • Custom2 = 651
  • Custom20 = 669
  • Custom3 = 652
  • Custom4 = 653
  • Custom5 = 654
  • Custom6 = 655
  • Custom7 = 656
  • Custom8 = 657
  • Custom9 = 658
  • DBOptionlookup = 41
  • DEPARTMENT = 1604
  • DSIFileWorkflowStatus = 1584
  • DSIType = 501
  • DXAdapterType = 1583
  • DXOAdvisorStatus = 1594
  • DXPRIORITY = 1311
  • DXSTATUS = 1256
  • DelReqSubType = 385
  • DisbltyRating = 2532
  • DividentOption = 42
  • DocumentType = 104
  • DownloadMethod = 383
  • Duration = 2023
  • DurationUnit = 18
  • DynReportCategory = 2210
  • DynReportFamily = 2212
  • EMailPostingOption = 1868
  • ESConnectionStatus = 2624
  • ESContactsImportAs = 2540
  • ESSyncAction = 2539
  • ESSyncDeletionOpt = 2623
  • ESSyncReportType = 2543
  • ESSyncSmartMail = 2657
  • ESSyncUserResponse = 2541
  • EZMailType = 2193
  • ElectronicOrderStatus = 1595
  • ElectronicReply = 2097
  • EnterpriseView = 294
  • EstimatedNetWorth = 2259
  • EventInviteeStatus = 327
  • EventType = 326
  • ExServerName = 2542
  • ExchangeTrackStatus = 73
  • ExlUserType = 474
  • ExpApplication = 3184
  • ExpFormat = 3183
  • FEPeriod = 2138
  • FileType = 431
  • FolderType = 186
  • FollowUpReq = 373
  • FormatType = 1312
  • FundObjective = 57
  • GAIDStatus = 1576
  • Gender = 7
  • Gender1 = 82
  • GroupCensusClass = 103
  • GroupCensusKeyEmployee = 107
  • GroupCensusStatus = 455
  • HIPPALetterOptions = 466
  • HODictionaryCode = 407
  • HOMatchedUnmatched = 427
  • HOProcessStatus = 426
  • HoldingType = 33
  • HouseMember = 9
  • HouseholdRating = 2222
  • HowHeld = 48
  • INTERACTIONCODE = 1607
  • ISMember_Status = 1862
  • ImageCategory = 456
  • ImportEncoding = 1900
  • Inactive = 106
  • IncomeRange = 126
  • Industry = 11
  • InforceRequest = 70
  • InsProductType = 39
  • InsuranceOrInvestmentComm = 2173
  • InsuranceType = 34
  • InterestMethod = 146
  • InterestpartyRelation = 2531
  • InvestmentObjective = 2163
  • InvestmentTimeHorizon = 2164
  • IssuingEntity = 2260
  • JobTitle = 2133
  • JoinFamily = 1615
  • KYCDataStatus = 2194
  • KeywordsActivity = 353
  • KeywordsPolicy = 356
  • LandingZone = 1581
  • LeadDataState = 226
  • LeadStage = 212
  • LeadStatus = 156
  • LeadType = 157
  • LeadsDistributionType = 195
  • LetterFormat = 136
  • LetterPurpose = 370
  • LetterSentMethod = 2224
  • LetterStatus = 471
  • LetterTypes = 135
  • LiabilitySecured = 249
  • LicenseAgentBroker = 425
  • LicenseIndCorp = 424
  • LicenseStatus = 94
  • LifeAPL = 2358
  • LinkType = 423
  • LostReason = 433
  • MailMergeAddressType = 301
  • MailServerType = 2261
  • Maintenance = 66
  • Marital = 8
  • MemberType = 2547
  • MktMgr = 1588
  • MobileDeviceUser_Status = 2295
  • MobileDeviceUser_Type = 2296
  • MsgArchiveStatus = 87
  • MsgFlag = 46
  • MsgPriority = 120
  • MsgType = 100
  • NASDSeries = 372
  • NamedJoin = 1614
  • Nationality = 150
  • NetWorthRange = 127
  • NewbusPriority = 414
  • NewbusinessDeliveryDecision = 76
  • NotificationPriority = 90
  • NotificationURLTarget = 304
  • OCSStage = 300
  • OPolicyCustomAlphanum1 = 1714
  • OPolicyCustomAlphanum2 = 1715
  • OPolicyCustomAlphanum3 = 1716
  • OPolicyCustomAlphanum4 = 1717
  • Occupation = 2132
  • OccupationRate = 429
  • OffCode = 1590
  • OppBusinessDriver = 448
  • OppRelationStrength = 449
  • Opportunity Name = 1776
  • OpportunityCompStrategy = 447
  • OpportunityStageStatus = 453
  • Owner = 49
  • OwnerCitizenship = 2151
  • POSReqSubType = 462
  • PaymentMethod = 387
  • PhoneType = 17
  • PolAddlCustom1 = 2068
  • PolAddlCustom2 = 2069
  • PolAddlCustom3 = 2070
  • PolAddlCustom4 = 2071
  • PolAddlCustom5 = 2072
  • PolAddlCustomAlphNum1 = 2073
  • PolAddlCustomAlphNum10 = 2082
  • PolAddlCustomAlphNum11 = 2083
  • PolAddlCustomAlphNum12 = 2084
  • PolAddlCustomAlphNum13 = 2085
  • PolAddlCustomAlphNum14 = 2086
  • PolAddlCustomAlphNum15 = 2087
  • PolAddlCustomAlphNum16 = 2088
  • PolAddlCustomAlphNum17 = 2089
  • PolAddlCustomAlphNum18 = 2090
  • PolAddlCustomAlphNum19 = 2091
  • PolAddlCustomAlphNum2 = 2074
  • PolAddlCustomAlphNum20 = 2092
  • PolAddlCustomAlphNum3 = 2075
  • PolAddlCustomAlphNum4 = 2076
  • PolAddlCustomAlphNum5 = 2077
  • PolAddlCustomAlphNum6 = 2078
  • PolAddlCustomAlphNum7 = 2079
  • PolAddlCustomAlphNum8 = 2080
  • PolAddlCustomAlphNum9 = 2081
  • PolicyAlphaKey1 = 2350
  • PolicyAlphaKey2 = 2351
  • PolicyPurpose = 2006
  • PolicyStage = 72
  • PolicyStatus = 37
  • PolicyTransaction = 188
  • PosMissing = 1920
  • PositionAlphanum_1 = 2205
  • PositionAlphanum_2 = 2206
  • PositionStatus = 298
  • PreferredCommlookup = 131
  • PremMode = 38
  • PremiumOption = 1990
  • PrimaryLanguage = 151
  • Priority = 99
  • ProcessedBy = 390
  • ProcessingType = 2511
  • ProductOptions = 132
  • ProductStatus = 391
  • ProductSubtype = 392
  • ProductionTrend = 1574
  • PropertyType = 51
  • ProposalAddlChildRider = 2220
  • ProposalAddlDccRider = 2219
  • ProposalAddlMEC = 2218
  • ProposalStatus = 496
  • ProuctAvailable = 241
  • PushEventDataLogStatus = 2653
  • PushEventID = 2654
  • PushEventJobStatus = 2652
  • PushEventServiceName = 2650
  • PushEventStatus = 2651
  • REQUESTSTATUS = 1612
  • RateReason = 436
  • Rating = 2360
  • ReadUnread = 98
  • RecordType = 4
  • RecruitCustomAlphaNum = 1635
  • RecruitEvaluation = 101
  • RecruitSource = 89
  • RecruitStatus = 86
  • RecruitType = 416
  • RegionCode = 1589
  • Relation = 14
  • RelationType = 13
  • ReminderType = 475
  • Renewal = 43
  • ReqPriority = 381
  • RequiredOfAgentRequestReq = 1670
  • Residual = 59
  • RiderProduct = 464
  • RiderStatus = 60
  • Riders = 477
  • RiskClass = 61
  • RiskObjective = 491
  • Role = 36
  • Roles = 134
  • RollupInvest = 395
  • Roof = 45
  • RptCategory = 324
  • SEVERITY = 1611
  • SIDataEventStatus = 1587
  • SIDataEventType = 1586
  • SI_LicesnseType = 1579
  • SLIBSendOption = 2177
  • SPRequestStatus = 473
  • SPStatus = 2118
  • ServiceLevel = 1573
  • SessionTimeout = 2109
  • ShowTimeAs = 1861
  • SmartPadLink = 15
  • SmartpadTypes = 140
  • SourceAdvisor = 341
  • SourceApp_Name = 1863
  • SourceOfData = 1930
  • SourceOfDataType = 308
  • SourceRecruit = 342
  • StateCode = 376
  • StockIndustry = 56
  • StockType = 492
  • SubSourceAdvisor = 344
  • SubSourceRecruit = 345
  • SubType = 325
  • SubTypeAdvisor = 338
  • SubTypeRecruit = 339
  • SubTypelookup = 1835
  • SubjectActivity = 2195
  • Suffix = 2131
  • SyncClientType = 321
  • SyncTransStatus = 1987
  • SyncTransType = 1986
  • SystemUserType = 2136
  • TargetMarket = 85
  • TaxType = 251
  • TemplateStatus = 1999
  • Territory = 486
  • TierStatus = 2546
  • Title = 2130
  • Tobacco = 10
  • TobaccoPrem = 1916
  • TransLogStatus = 2024
  • TransactionType = 52
  • UDEntityType = 2144
  • UnderReqStatus = 361
  • UnderwritingRequirementType = 77
  • UnderwritingSubClass = 1917
  • UserRole = 28
  • UserRoleCustomize = 2223
  • UserStatus = 27
  • VendorStatus = 415
  • WebAddressType = 149
  • WinReason = 483
  • WordBinderEmailOption = 1903
  • YesNo = 2
  • YesNoUnknown = 3
  • coverage = 302
  • datelookup = 78
  • firsttolast = 24
  • lookup = 1
  • monthnames = 26
  • participantrolelookup = 23
  • weekdaynames = 25
  • 4Methods
  • AssignContactstoAgent
  • CheckActivityConflict
  • CheckDuplicateContact
  • CheckPostImage
  • CreateCorrespondence
  • CreateSVAdvisorUser
  • CreateSecurities
  • CreateUserHierarchy
  • DSILookupCleanup
  • DelContact
  • DelContactSubObjs
  • DeleteActivityContact
  • DisableUser
  • DispatchLeads
  • DynamicReport
  • DynamicReportExcel
  • DynamicReportFilter
  • DynamicReportFilterDetail
  • DynamicReportSS
  • EnableUser
  • EnableUserStatsCollection
  • EnsureValidCarriers
  • GenAccountRefresh
  • GenPositionRefresh
  • GenProcessAccount
  • GenProcessAlerts
  • GenProcessContact
  • GenProcessHouseHold
  • GenProcessPosition
  • GenProcessPriceHistory
  • GenProcessSecurities
  • GenProcessTransaction
  • GetAdapterDetails
  • GetAdapterTransfDetails
  • GetAdvisorCommission
  • GetConfiguration
  • GetContactDOB
  • GetContactsForEmail
  • GetCustomLabelDetail
  • GetCustomLabels
  • GetDashboardData
  • GetDeletedContacts
  • GetESSyncSetup
  • GetEmailQueueData
  • GetGSyncDeletedContacts
  • GetGSyncOfficesAndUsers
  • GetHouseholdMember
  • GetInvtMaturityDate
  • GetLookupRelation
  • GetOfficeAdv4Dashboard
  • GetParticipantAvailability
  • GetPolicyInvtData
  • GetPolicyPremium
  • GetReferredContacts
  • GetSalesEnablerAdapterDetails
  • GetSiblingsUsingChild
  • GetSiteName
  • GetSmartMailData
  • GetSystemTime
  • GetTickerData
  • GetUnassignedAccounts
  • GetUnassignedPositions
  • GetUserLicense
  • GetValidKeyRelations
  • InsertActivityContact
  • InsertKeyRelations
  • InsertRequirement
  • PostMessageAlerts
  • ProcessAccount
  • ProcessAppointment
  • ProcessCarrier
  • ProcessChildOfficeSecPrices
  • ProcessCorrTransData
  • ProcessCustomChoice
  • ProcessFullNewbus
  • ProcessInterestParty
  • ProcessJohnHancockPDFReport
  • ProcessLAE
  • ProcessLicense
  • ProcessPolicy
  • ProcessPolicyAttachments
  • ProcessPosition
  • ProcessProduct
  • ProcessRiders
  • ProcessSITransLog
  • ProcessSecurities
  • ProcessSmartPadArchive
  • ProcessSubAccounts
  • ProcessTransaction
  • SAMLRemoteLogout
  • SIAdapterRefresh
  • SITokenGeneration
  • SaveBookmarkData
  • SaveSettings4Advisor
  • SendFormLetter
  • UpdateLayoutCache
  • UpdateUser
  • ValidateContactBenefit
  • ValidateData
  • ValidateTransaction
  • WMAlertSecValidator
  • WMAlertsProcessor
  • updateSite
  • 4Timezones

  • Objects

    AUMDashboard
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CONTACTBENEFIT_AUMDASHBOARD_ALIAS1cdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AssetContact1
    integer   truefalseAUM_ALIAS1_OtherNo 
    AssetContact2
    integer   truefalseAUM_ALIAS1_OtherNo 
    AssetContact3
    integer   truefalseAUM_ALIAS1_OtherNo 
    AssetContactPer1
    double   truefalseAUM_ALIAS1_OtherPrem 
    AssetContactPer2
    double   truefalseAUM_ALIAS1_OtherPrem 
    AssetContactPer3
    double   truefalseAUM_ALIAS1_OtherPrem 
    Assets1
    double   truefalseAUM_ALIAS1_CrtillPrem 
    Assets2
    double   truefalseAUM_ALIAS1_CrtillPrem 
    Assets3
    double   truefalseAUM_ALIAS1_CrtillPrem 
    AssetsPer1
    double   truefalseAUM_ALIAS1_CrtillVen 
    AssetsPer2
    double   truefalseAUM_ALIAS1_CrtillVen 
    AssetsPer3
    double   truefalseAUM_ALIAS1_CrtillVen 
    AssetsPerContact1
    double   truefalseAUM_ALIAS1_CTDCost 
    AssetsPerContact2
    double   truefalseAUM_ALIAS1_CTDCost 
    AssetsPerContact3
    double   truefalseAUM_ALIAS1_CTDCost 
    AssetsPerContactPer1
    double   truefalseAUM_ALIAS1_CTDValue 
    AssetsPerContactPer2
    double   truefalseAUM_ALIAS1_CTDValue 
    AssetsPerContactPer3
    double   truefalseAUM_ALIAS1_CTDValue 
    BondAsset1
    double   truefalseAUM_ALIAS1_BondValue 
    BondAsset2
    double   truefalseAUM_ALIAS1_BondValue 
    BondAsset3
    double   truefalseAUM_ALIAS1_BondValue 
    BondAssetPer1
    double   truefalseAUM_ALIAS1_BondCost 
    BondAssetPer2
    double   truefalseAUM_ALIAS1_BondCost 
    BondAssetPer3
    double   truefalseAUM_ALIAS1_BondCost 
    Last180Days1
    integer   truefalseAUM_ALIAS1_ULNo 
    Last180Days2
    integer   truefalseAUM_ALIAS1_ULNo 
    Last180Days3
    integer   truefalseAUM_ALIAS1_ULNo 
    Last180DaysPer1
    double   truefalseAUM_ALIAS1_OtherDebt 
    Last180DaysPer2
    double   truefalseAUM_ALIAS1_OtherDebt 
    Last180DaysPer3
    double   truefalseAUM_ALIAS1_OtherDebt 
    Last30Days1
    integer   truefalseAUM_ALIAS1_TermNo 
    Last30Days2
    integer   truefalseAUM_ALIAS1_TermNo 
    Last30Days3
    integer   truefalseAUM_ALIAS1_TermNo 
    Last30DaysPer1
    double   truefalseAUM_ALIAS1_PPValue 
    Last30DaysPer2
    double   truefalseAUM_ALIAS1_PPValue 
    Last30DaysPer3
    double   truefalseAUM_ALIAS1_PPValue 
    Last365Days1
    integer   truefalseAUM_ALIAS1_LifeNo 
    Last365Days2
    integer   truefalseAUM_ALIAS1_LifeNo 
    Last365Days3
    integer   truefalseAUM_ALIAS1_LifeNo 
    Last365DaysPer1
    double   truefalseAUM_ALIAS1_BankCost 
    Last365DaysPer2
    double   truefalseAUM_ALIAS1_BankCost 
    Last365DaysPer3
    double   truefalseAUM_ALIAS1_BankCost 
    Last90Days1
    integer   truefalseAUM_ALIAS1_PermNo 
    Last90Days2
    integer   truefalseAUM_ALIAS1_PermNo 
    Last90Days3
    integer   truefalseAUM_ALIAS1_PermNo 
    Last90DaysPer1
    double   truefalseAUM_ALIAS1_REDebt 
    Last90DaysPer2
    double   truefalseAUM_ALIAS1_REDebt 
    Last90DaysPer3
    double   truefalseAUM_ALIAS1_REDebt 
    MFAsset1
    double   truefalseAUM_ALIAS1_MfValue 
    MFAsset2
    double   truefalseAUM_ALIAS1_MfValue 
    MFAsset3
    double   truefalseAUM_ALIAS1_MfValue 
    MFAssetPer1
    double   truefalseAUM_ALIAS1_MfCost 
    MFAssetPer2
    double   truefalseAUM_ALIAS1_MfCost 
    MFAssetPer3
    double   truefalseAUM_ALIAS1_MfCost 
    NoContactWithDI1
    integer   truefalseAUM_ALIAS1_OfficeID 
    NoContactWithDI2
    integer   truefalseAUM_ALIAS1_OfficeID 
    NoContactWithDI3
    integer   truefalseAUM_ALIAS1_OfficeID 
    NoContactWithDIPer1
    double   truefalseAUM_ALIAS1_DIPrem 
    NoContactWithDIPer2
    double   truefalseAUM_ALIAS1_DIPrem 
    NoContactWithDIPer3
    double   truefalseAUM_ALIAS1_DIPrem 
    NoContactWithLI1
    integer   truefalseAUM_ALIAS1_ContactID 
    NoContactWithLI2
    integer   truefalseAUM_ALIAS1_ContactID 
    NoContactWithLI3
    integer   truefalseAUM_ALIAS1_ContactID 
    NoContactWithLIPer1
    double   truefalseAUM_ALIAS1_LifePerm 
    NoContactWithLIPer2
    double   truefalseAUM_ALIAS1_LifePerm 
    NoContactWithLIPer3
    double   truefalseAUM_ALIAS1_LifePerm 
    StockAsset1
    double   truefalseAUM_ALIAS1_StockValue 
    StockAsset2
    double   truefalseAUM_ALIAS1_StockValue 
    StockAsset3
    double   truefalseAUM_ALIAS1_StockValue 
    StockAssetPer1
    double   truefalseAUM_ALIAS1_StockCost 
    StockAssetPer2
    double   truefalseAUM_ALIAS1_StockCost 
    StockAssetPer3
    double   truefalseAUM_ALIAS1_StockCost 
    VAAsset1
    double   truefalseAUM_ALIAS1_VaValue 
    VAAsset2
    double   truefalseAUM_ALIAS1_VaValue 
    VAAsset3
    double   truefalseAUM_ALIAS1_VaValue 
    VAAssetPer1
    double   truefalseAUM_ALIAS1_VaCost 
    VAAssetPer2
    double   truefalseAUM_ALIAS1_VaCost 
    VAAssetPer3
    double   truefalseAUM_ALIAS1_VaCost 


    AccessLog
    Referred By:

    Main TableData ObjectTopSearchReadonly
    ACCESSLOG_TABLEAccessLogtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    InTime
    datetime   truefalseACCESSLOG_InTimeTime user logged in
    User
    object User truefalseACCESSLOG_UserIDForeign Key -- Link to APPUSER table
    UserID
    id User truefalseACCESSLOG_UserIDForeign Key -- Link to APPUSER table


    AcctMaster
    Referred By:
    RiskAssignment.AcctMasterID  RiskAssignment.AcctMaster  LUAccountNum.AcctMasterID  Liability.AcctMaster  Liability.AcctMasterID  Position.AcctMasterID  Position.AcctMaster  PolSubAccount.AcctMasterID  PolSubAccount.AcctMaster  RelatedContact.AcctMasters  RelatedContact.Trusts  AcctMasterContact.AcctMasterID  Contact.AcctMasters  Contact.Trusts 
    Main TableData ObjectTopSearchReadonly
    ACCTMASTER_TABLEacctmastertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AcctName
    string80  truefalseACCTMASTER_AcctNameAccount name
    AcctNumber
    string50  truefalseACCTMASTER_AcctNumberAccount number
    AcctType
    string80 AccountTypetruefalseACCTMASTER_AcctTypeAccount master type
    AcctTypeText
    integer   falsetrueACCTMASTER_AcctTypeText 
    AllInterstParties
    string1023  falsetrueACCTMASTER_AllInterstParties 
    AlphaNum1
    string40 AcctMasterAlphanum_1truefalseACCTMASTER_AlphaNum1 
    AlphaNum2
    string40 AcctMasterAlphanum_2truefalseACCTMASTER_AlphaNum2 
    AlphaNum3
    string40  truefalseACCTMASTER_AlphaNum3 
    AlphaNum4
    string40  truefalseACCTMASTER_AlphaNum4 
    DataProvider
    string255  truefalseACCTMASTER_DataProvider 
    HowHeld
    string50 HowHeldfalsefalseACCTMASTER_HowHeldHow Held choice field
    HowHeldText
    integer   falsetrueACCTMASTER_HowHeldText 
    Liability
    double   falsefalseACCTMASTER_LiabilityLiability amount
    NetValue
    double   falsefalseACCTMASTER_NetValueNet value
    Numeric1
    double   truefalseACCTMASTER_Numeric1 
    Numeric2
    double   truefalseACCTMASTER_Numeric2 
    OpenAcctDate
    date   falsefalseACCTMASTER_OpenAcctDateDate when account was opened
    Owner
    string50 OwnerfalsefalseACCTMASTER_OwnerInvestment owner
    OwnerText
    integer   falsetrueACCTMASTER_OwnerText 
    PersonalAsset
    lookup  YesNotruefalseACCTMASTER_PersonalAssetPersonal asset
    PostTransaction
    lookup  RollupInvesttruefalseACCTMASTER_PostTransactionCheck box to allow user to post transactions
    Purpose
    string64  falsefalseACCTMASTER_PurposePurpose, e.g., college education, retirement
    QualifyAccount
    lookup  YesNofalsefalseACCTMASTER_QualifyAccountCheck box if this is a qualified account related to tax calculations
    QualifyAccountText
    lookuptext   falsetrueACCTMASTER_QualifyAccountText 
    Registration
    string512  truefalseACCTMASTER_RegistrationPersonal information regarding account
    Remark
    string512  falsefalseACCTMASTER_RemarkRemarks column
    SourceOfDataType
    lookup  SourceOfDataTypetruefalseACCTMASTER_SourceOfDataTypeSource of data choice field
    Status
    lookup  AcctMasterStatustruefalseACCTMASTER_StatusAccount status
    TaxId
    string20  falsefalseACCTMASTER_TaxIdTax ID number
    TotalValue
    double   falsefalseACCTMASTER_TotalValueTotal account value
    UnmanagedAccount
    lookup  YesNofalsefalseACCTMASTER_UnmanagedAccountIs Account Managed? - default 'YES'
    AcctMasterContacts
     AcctMasterContact   
    Contact
    object Contact truefalseACCTMASTER_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact truefalseACCTMASTER_ContactIDForeign Key -- Link to CONTACT table
    CustomData
     CustomData   
    Liabilities
     Liability   
    LUAccountNum
     LUAccountNum   
    Positions
     Position   


    AcctMasterContact
    Referred By:
    AcctMaster.AcctMasterContacts 
    Main TableData ObjectTopSearchReadonly
    CONTACTACCTMASTER_TABLEinvestcontactfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    InterestPercent
    double   falsefalseCONTACTACCTMASTER_InterestPercentPercent interest of the account master
    ModifiedOn
    datetime   falsefalseCONTACTACCTMASTER_ModifiedOnDate modified
    Name
    string85  truefalseCONTACTACCTMASTER_NameName of the account master
    Relation
    string30  falsefalseCONTACTACCTMASTER_RelationContact account master relationship
    Remarks
    string128  falsefalseCONTACTACCTMASTER_RemarksRemarks : Removed ssHead as there is no UI for this
    Role
    lookup  AcctRoletruefalseCONTACTACCTMASTER_RoleRole of account master
    RoleAsOfDate
    date   falsefalseCONTACTACCTMASTER_RoleAsOfDateRole as of date: Removed ssHead as there is no UI for this
    RoleExpireDate
    date   falsefalseCONTACTACCTMASTER_RoleExpireDateRole expiration date: Removed ssHead as there is no UI for this
    RoleText
    lookuptext   falsetrueCONTACTACCTMASTER_RoleText 
    AcctMasterID
    id AcctMaster truefalseCONTACTACCTMASTER_AcctMasterIDForeign Key -- Link to ACCTMASTER table
    Address
    integer Address falsefalseCONTACTACCTMASTER_AddressIDForeign Key -- Link to ADDRESS table
    Contact
    object Contact falsefalseCONTACTACCTMASTER_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact truefalseCONTACTACCTMASTER_ContactIDForeign Key -- Link to CONTACT table


    Activity
    Referred By:
    SyncLog.ActivityID  ActivityHistory.ActivityID  RecruitReq.ActID  ActivityContact.Activity  ActivityContact.ActivityID  RecruitIntv.ActivityID  Activity.ParentObj  Activity.ParentID  RelatedContact.Activities  Participant.Activity  Participant.ActivityID  Contact.Activities 
    Main TableData ObjectTopSearchReadonly
    ACTIVITY_TABLEactivitytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActKeyword
    string40 KeywordsActivitytruefalseACTIVITY_ActKeywordKeywords
    ActivityStatus
    lookup  ActivityStatustruefalseACTIVITY_ActStatusStatus choice field: Active, Done, Discontinued
    ActivitySubType
    lookup  ActivitySubtypetruefalseACTIVITY_ActSubTypeSub type of activity
    ActivityType
    lookup  ActivityTypetruefalseACTIVITY_ActTypeType of activity
    AddlParticipants
    string1023  falsefalseACTIVITY_AdditionalParticipantsAdditional Participants
    Alarm
    short   falsefalseACTIVITY_ActAlarmActivity alarm
    AllContacts
    string1023  falsetrueACTIVITY_AllContacts 
    AllDayEvent
    byte  YesNotruefalseACTIVITY_AllDayEvent 
    ContactIDValue
    integer   falsefalseACTIVITY_ContactIDForeign Key -- Link to CONTACT table
    ContactName
    string80  falsefalseACTIVITY_ContactNameContact name
    CreatedBy
    integer   truefalseACTIVITY_CreatedByForeign Key -- Link to APPUSER table
    CreatedOn
    datetime   truefalseACTIVITY_CreatedOnDate when the activity is created
    Date
    datetime   truefalseACTIVITY_ActDateDate of the activity
    DueDate
    datetime   truefalseACTIVITY_ActDueDateDue date for the activity
    DueTime
    datetime   truefalseACTIVITY_ActDueTime 
    Duration
    short   falsefalseACTIVITY_ActDurationDuration of the activity
    DurationUnit
    lookup  DurationUnitfalsefalseACTIVITY_DurationUnitUnit of the duration
    EndDate
    datetime   truefalseACTIVITY_ActEndDate 
    EndTime
    datetime   truefalseACTIVITY_EndTime 
    FinishedTime
    datetime   falsefalseACTIVITY_FinishedTimeTime when activity is finished
    GUID
    string256  truefalseACTIVITY_ActivityGUIDColumn to be used for SmartOffice/Sync Activity Record matching
    Keyword
    string40 KeywordsActivityfalsefalseACTIVITY_ActKeywordKeywords
    LinkID
    link   truefalseACTIVITY_LinkIDPrimary key of record in referenced table
    LinkTable
    integer   truefalseACTIVITY_LinkTablePrimary table referenced
    ModifiedOn
    datetime   truefalseACTIVITY_ModifiedOnDate when the activity is modified
    OrigDate
    datetime   falsefalseACTIVITY_OriginalActDateOrganized date
    OrigDuedate
    datetime   falsefalseACTIVITY_OriginalActDueDateOrganized due date
    PerctCompleted
    integer   truefalseACTIVITY_PerctCompleted 
    Place
    string512  falsefalseACTIVITY_ActPlacePlace of the activity
    Priority
    lookup  ActivityPrioritytruefalseACTIVITY_ActPriorityActivity priority
    Private
    lookup  YesNotruefalseACTIVITY_PrivateIndicates if the activity is a private activity
    Reason
    text   falsefalseACTIVITY_ActReasonActivity reason
    RecurrenceID
    integer   truefalseACTIVITY_RecurrenceIDForeign Key -- Link to RECURRENCE table
    RemindAt
    lookup  ReminderTypetruefalseACTIVITY_RemindAtAmount of time before activity to display alert
    ShowTimeAs
    lookup  ShowTimeAsfalsefalseACTIVITY_ShowTimeAs 
    SourceApp
    lookup  SourceApp_NametruefalseACTIVITY_SOURCEAPPSource Application Name
    StartTime
    datetime   truefalseACTIVITY_CreatedOnDate when the activity is created
    Subject
    string256 SubjectActivitytruefalseACTIVITY_SubjectSubject of activity for Outlook/Notes sync
    Synchronized
    byte  YesNotruefalseACTIVITY_Synchronized 
    Time
    datetime   truefalseACTIVITY_ActTime 
    ToDo
    byte  YesNotruefalseACTIVITY_ToDoWhether the activity appears on the To Do list
    Track
    byte  YesNofalsefalseACTIVITY_TrackTracked activity choice field
    ParentID
    id Activity truefalseACTIVITY_ParentIDForeign Key -- Link to ACTIVITY table
    ParentObj
    integer Activity truefalseACTIVITY_ParentIDForeign Key -- Link to ACTIVITY table
    ActivityContacts
    objects ActivityContact falsefalseACTIVITY_ActivityIDPrimary Key
    ActivityHistorys
    objects ActivityHistory falsefalseACTIVITY_ActivityIDPrimary Key
    Contact
    object Contact falsefalseACTIVITY_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact falsefalseACTIVITY_ContactIDForeign Key -- Link to CONTACT table
    Opportunity
    object Opportunity falsefalseACTIVITY_OpportunityIDForeign Key -- Link to OPPORTUNITY table
    OpportunityID
    id Opportunity falsefalseACTIVITY_OpportunityIDForeign Key -- Link to OPPORTUNITY table
    Participants
    objects Participant falsefalseACTIVITY_ActivityIDPrimary Key
    RecurrenceObj
    object Recurrence truefalseACTIVITY_RecurrenceIDForeign Key -- Link to RECURRENCE table
    RecurrenceObjID
    id Recurrence truefalseACTIVITY_RecurrenceIDForeign Key -- Link to RECURRENCE table
    ScriptID
    id Script falsefalseACTIVITY_ScriptIDForeign Key -- Link to SCRIPT table
    SyncLogs
    objects SyncLog falsefalseACTIVITY_ActivityIDPrimary Key
    User
    object User falsefalseACTIVITY_CreatedByForeign Key -- Link to APPUSER table
    UserId
    id User falsefalseACTIVITY_CreatedByForeign Key -- Link to APPUSER table


    ActivityContact
    Referred By:
    Activity.ActivityContacts 
    Main TableData ObjectTopSearchReadonly
    ACTIVITY_CONTACT_TABLEactivitytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    PrimaryContact
    lookup  YesNotruefalseACTIVITY_CONTACT_PRIMARYCONTACT 
    Activity
    object Activity falsefalseACTIVITY_CONTACT_ACTIVITYID 
    ActivityID
    id Activity truefalseACTIVITY_CONTACT_ACTIVITYID 
    Contact
    object Contact falsefalseACTIVITY_CONTACT_CONTACTID 
    ContactID
    id Contact truefalseACTIVITY_CONTACT_CONTACTID 


    ActivityHistory
    Referred By:
    Activity.ActivityHistorys 
    Main TableData ObjectTopSearchReadonly
    ACTHISTORY_TABLEhistorytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Date
    datetime   truetrueACTHISTORY_ActDate 
    Duration
    integer   falsefalseACTHISTORY_DurationDuration time
    Outcome
    lookup  ActivityOutcomefalsefalseACTHISTORY_OutcomeOutcome of activity
    Time
    datetime   truefalseACTHISTORY_ActTime 
    ActivityID
    id Activity falsefalseACTHISTORY_ActivityIDForeign Key -- Link to ACTIVITY table
    Contact
    object Contact falsefalseACTHISTORY_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact truefalseACTHISTORY_ContactIDForeign Key -- Link to CONTACT table


    Address
    Referred By:
    ContactVendor.Addresses  AgentContact.Addresses  RepContact.Addresses  InterestParty.AddressId  InterestParty.Address  DoctorContact.Addresses  DoctorContact.PreferredAddress  Hospital.Addresses  Hospital.PreferredAddress  RelatedContact.Addresses  RelatedContact.BillingAddress  HouseHold.PrimaryAddress  AgentInterestParty.AddressId  AgentInterestParty.Address  AcctMasterContact.Address  Contact.ResidenceAddress  Contact.EmployerAddress  Contact.BillingAddress  Contact.PreferredAddress  Contact.Addresses 
    Main TableData ObjectTopSearchReadonly
    ADDRESS_TABLEaddresstruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AddressType
    lookup  AddressTypetruefalseADDRESS_AddressTypeType of address, e.g., business, residence
    AddressTypeText
    lookuptext   falsetrueADDRESS_AddressTypeText 
    CMPLTADDR_SINGLELINE
    string255  falsetrueADDRESS_CMPLTADDR_SINGLELINE 
    City
    string90  truefalseADDRESS_CityCity
    Country
    string45  truefalseADDRESS_CountryCountry
    CreatedOn
    datetime   truefalseADDRESS_CreatedOn 
    ElectronicDownload
    lookup  YesNotruefalseADDRESS_ElectronicDownload 
    Line1
    string255  truefalseADDRESS_Line1Street Line 1
    Line2
    string90  truefalseADDRESS_Line2Street Line 2
    Line3
    string90  truefalseADDRESS_Line3Street Line 3
    Line4
    string90  truefalseADDRESS_Line4Street Line 4
    ModifiedOn
    datetime   truefalseADDRESS_ModifiedOnDate address was last modified
    MovedIn
    date   truefalseADDRESS_MovedInDate moved in
    Postal
    string15  truefalseADDRESS_ZipPostal code (ZIP Code for U.S.)
    Preferred
    lookup  YesNotruefalseADDRESS_PreferredPreferred address
    Primary
    lookup  YesNotruefalseADDRESS_PrimaryPrimary address
    Remark
    string2048  truefalseADDRESS_RemarkUser's remarks about address
    State
    string30  truefalseADDRESS_StateState
    Valid
    lookup  YesNotruefalseADDRESS_ValidValid flag for Address Validation.
    ValidatedOn
    date   falsefalseADDRESS_ValidatedOnValidated On Date for Address validation.
    Contact
    object Contact truefalseADDRESS_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact truefalseADDRESS_ContactIDForeign Key -- Link to CONTACT table


    AdvContract
    Referred By:
    InterestParty.AdvContract  InterestParty.AdvContractID  Agent.AdvRecords  Contract.AdvContracts  AgentRequest.ContractID  AgentRequest.ProposedContractID  AdvContract.MgrContract  AgentInterestParty.AdvContract  AgentInterestParty.AdvContractID 
    Main TableData ObjectTopSearchReadonly
    ADVCONTRACT_TABLEAgentContracttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AdvContractId
    integer   falsefalseADVCONTRACT_ADVCONTRACTIDPrimary Key
    AlphaNum1
    string30  truefalseADVCONTRACT_ALPHANUM1Alphanumeric field 1
    AlphaNum2
    string30  falsefalseADVCONTRACT_ALPHANUM2Alphanumeric field 2
    AlphaNum3
    string30 AdvContAlphaNum3falsefalseADVCONTRACT_ALPHANUM3Alphanumeric field 3
    ContractNo
    string30  truefalseADVCONTRACT_CONTRACTNOContract number
    CreatedOn
    datetime   truefalseADVCONTRACT_CreatedOn 
    DefaultContract
    byte  YesNofalsefalseADVCONTRACT_DEFAULTCONTRACTIdicator of default Adv-Contract for advisor
    EffDate
    date   truefalseADVCONTRACT_EFFDATEEffective date
    ExpDate
    date   truefalseADVCONTRACT_EXPDATEExpiration Date
    GAID
    string15  truefalseADVCONTRACT_GAIDGeneral agent ID
    IsProposed
    lookup  YesNofalsefalseADVCONTRACT_IsProposed 
    MgrContractId
    integer   falsefalseADVCONTRACT_MGRCONTRACTIDForeign Key -- Link to ADVCONTRACT table
    ModifiedOn
    datetime   truefalseADVCONTRACT_ModifiedOn 
    SolicitorNo
    string30  truefalseADVCONTRACT_SOLICITORNOSolicitor Number
    Status
    lookup  LicenseStatusfalsefalseADVCONTRACT_STATUS 
    MgrContract
    id AdvContract falsefalseADVCONTRACT_MGRCONTRACTIDForeign Key -- Link to ADVCONTRACT table
    AgentID
    id Agent truefalseADVCONTRACT_AGENTIDForeign Key -- Link to AGENT table
    CommAssigned
    object Contact truefalseADVCONTRACT_COMMASSIGNEDTOForeign Key -- Link to AGENT table
    CommAssignedTo
    id Contact truefalseADVCONTRACT_COMMASSIGNEDTOForeign Key -- Link to AGENT table
    ManagerId
    id Contact falsefalseADVCONTRACT_MANAGERIDForeign Key -- Link to AGENT table
    ManagerObj
    object Contact falsefalseADVCONTRACT_MANAGERIDForeign Key -- Link to AGENT table
    CarrierID
    id ContactVendor truefalseADVCONTRACT_CARRIERIDForeign Key -- Link to VENDOR table
    CarrierObj
    object ContactVendor truefalseADVCONTRACT_CARRIERIDForeign Key -- Link to VENDOR table
    ContractID
    id Contract truefalseADVCONTRACT_CONTRACTIDForeign Key -- Link to CONTRACT table
    ContractObj
    object Contract truefalseADVCONTRACT_CONTRACTIDForeign Key -- Link to CONTRACT table
    CreatedBy
    id User falsefalseADVCONTRACT_CreatedByForeign Key -- Link to APPUSER table
    CreatedByObj
    object User falsefalseADVCONTRACT_CreatedByForeign Key -- Link to APPUSER table
    ModifiedBy
    id User falsefalseADVCONTRACT_ModifiedByForeign Key -- Link to APPUSER table
    ModifiedByObj
    object User falsefalseADVCONTRACT_ModifiedByForeign Key -- Link to APPUSER table


    AgencySetup
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENCYSETUP_TABLEagencysetupfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AdvisorVU
    lookup  YesNotruefalseAGENCYSETUP_AdvisorVUMake visible in AdvisorVu?
    AdvisorVUPolicy
    lookup  YesNotruefalseAGENCYSETUP_AdvisorVUPolicy 
    AdvisorVuOptions
    lookup  AdvisorVuOptionstruefalseAGENCYSETUP_AdvisorVuOptions 
    OfficeId
    integer   truefalseAGENCYSETUP_OfficeIdPrimary Foreign Key -- Link to OFFICE table


    Agent
    Referred By:
    Appointments.AgentObj  Appointments.AgentObjID  Appointments.Agent  DXOAdvisorLogin.AdvisorID  AgentContact.Agent  RepContact.Agent  AgentRequirement.AgentID  Agent.AgencyRecID  Agent.Agency  AgentHierarchy.AdvisorID  Appoinment.Agent  Appoinment.AgentID  AgentProdSummary.AgentObj  AgentProdSummary.AgentId  CtmSetup.DefManager  CtmSetup.DefManagerId  CECredits.AgentID  RelatedContact.Agent  AdvContract.AgentID  CommReconcile.Agent  CommReconcile.AgentID  BrokerDealer.AgentID  AgentManager.Agent  AgentManager.AgentId  Contact.Agent  Recruit.AgentContactID 
    Main TableData ObjectTopSearchReadonly
    AGENT_TABLEagenttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgencyID
    integer   falsefalseAGENT_AgencyId 
    AgencyName
    string230  falsetrueAGENT_AgencyName 
    AlphaNum1
    string40  truefalseAGENT_ALPHANUM1Customizable alphanumeric field #1
    AlphaNum2
    string40  truefalseAGENT_ALPHANUM2Customizable alphanumeric field #2
    AlphaNum3
    string40  truefalseAGENT_ALPHANUM3Customizable alphanumeric field #3
    BrokerDealer
    string128 BrokerDealerfalsefalseAGENT_BrokerDealer 
    BusinessRecord
    lookup  AdvisorRecordTypetruefalseAGENT_BusinessRecord 
    Code
    string30  truefalseAGENT_CodeAgent code
    DoingBusAs
    string64  truefalseAGENT_DoingBusAs 
    ECPUniqueID
    string64  falsefalseAGENT_ECPUniqueIDECP unique advisor ID
    HireDate
    date   falsefalseAGENT_HireDateHire date
    MDRTGoal
    integer   truefalseAGENT_MDRTGoaleOCS: Million Dollar Round Table goal amount
    MinCheckAmt
    double   falsefalseAGENT_MinCheckAmtMinimum amt. of comm. check to be distributed
    MktManager
    string64 MktMgrfalsefalseAGENT_MktManagerMarketing manager
    ModifiedOn
    datetime   truefalseAGENT_ModifiedOnDate of last modification
    OfficeCode
    string64 OffCodetruefalseAGENT_OfficeCodeOffice code
    Override
    double   falsefalseAGENT_OverrideSupervisor override percent
    RESERVEACCT
    lookup  YesNofalsefalseAGENT_RESERVEACCTAgency reserve account?
    RegionCode
    string64 RegionCodefalsefalseAGENT_RegionCodeRegion code
    Status
    lookup  AgentStatusfalsefalseAGENT_StatusAdvisor's current status
    Type
    lookup  AgentTypelookuptruefalseAGENT_TypeAdvisor type
    AdvRecords
     AdvContract   
    Agency
    object Agent falsefalseAGENT_AgencyId 
    AgencyRecID
    id Agent falsefalseAGENT_AgencyId 
    AgentContact
    object AgentContact falsefalseAGENT_ContactIDPrimary Foreign Key -- Link to CONTACT table
    AgentLicenses
     AgentLicense   
    Appoinments
     Appoinment   
    BrokerDealers
     BrokerDealer   
    Contact
    object Contact falsefalseAGENT_ContactIDPrimary Foreign Key -- Link to CONTACT table
    ContactID
    id Contact falsefalseAGENT_ContactIDPrimary Foreign Key -- Link to CONTACT table
    PrimaryContact
    object Contact falsefalseAGENT_PrimaryContactIdForeign Key -- Link to PRIMARYAGENT Alias table
    PrimaryContactID
    id Contact falsefalseAGENT_PrimaryContactIdForeign Key -- Link to PRIMARYAGENT Alias table
    Supervisor
    object Contact truefalseAGENT_SupervisorIDForeign Key -- Link to CONTACT table
    SupervisorID
    id Contact falsefalseAGENT_SupervisorIDForeign Key -- Link to CONTACT table
    CustomData
     CustomData   
    CaseManagerID
    id User truefalseAGENT_CaseManager 


    AgentContact
    Referred By:
    Agent.AgentContact 
    Main TableData ObjectTopSearchReadonly
    CONTACT_AGENT_ALIASagentfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ALPHANUM1
    string40 ContactCustomAlphanum1truefalseAGENT_CONTACT_ALPHANUM1 
    ALPHANUM2
    string40 ContactCustomAlphanum2truefalseAGENT_CONTACT_ALPHANUM2 
    Alphakey
    string40 ContactAlphaKeytruefalseAGENT_CONTACT_Alphakey 
    CompactName
    string280  truetrueAGENT_CONTACT_CompactName 
    ContactTitle
    string40 TitletruefalseAGENT_CONTACT_ContactTitle 
    ContactType
    lookup  SubTypelookuptruefalseAGENT_CONTACT_ContactType 
    ContactTypeCategory
    string128 ContactTypetruefalseAGENT_CONTACT_ContactTypeCategory 
    ContactTypeText
    lookuptext   truetrueAGENT_CONTACT_ContactTypeText 
    CreatedByText
    string60  truetrueAGENT_CONTACT_CreatedByText 
    CreatedOn
    datetime   truefalseAGENT_CONTACT_CreatedOn 
    EMailPrivacy
    lookup  YesNotruefalseAGENT_CONTACT_EMailPrivacy 
    Employer
    string128  truefalseAGENT_CONTACT_Employer 
    FirstLastName
    string360  truetrueAGENT_CONTACT_FirstLastName 
    FirstName
    string64  truefalseAGENT_CONTACT_FirstName 
    FullName
    string440  truetrueAGENT_CONTACT_FullName 
    Greeting
    string40  truefalseAGENT_CONTACT_Greeting 
    LastActBy
    integer   truefalseAGENT_CONTACT_LastActBy 
    LastActByPrimText
    string60  truetrueAGENT_CONTACT_LastActByPrimText 
    LastActByText
    string60  truetrueAGENT_CONTACT_LastActByText 
    LastActOn
    datetime   truefalseAGENT_CONTACT_LastActOn 
    LastCalOn
    datetime   truetrueAGENT_CONTACT_LastCalOn 
    LastFirstInitialName
    string216  truetrueAGENT_CONTACT_LastFirstInitialName 
    LastFirstName
    string280  truetrueAGENT_CONTACT_LastFirstName 
    LastLetterBy
    integer   truefalseAGENT_CONTACT_LastLetterBy 
    LastLetterByText
    string60  truetrueAGENT_CONTACT_LastLetterByText 
    LastLetterOn
    datetime   truefalseAGENT_CONTACT_LastLetterOn 
    LastName
    string200  truefalseAGENT_CONTACT_LastName 
    MaskedTaxID
    string20  truetrueAGENT_CONTACT_MaskedTaxID 
    MiddleName
    string40  truefalseAGENT_CONTACT_MiddleName 
    ModifiedByText
    string60  truetrueAGENT_CONTACT_ModifiedByText 
    ModifiedOn
    datetime   truefalseAGENT_CONTACT_ModifiedOn 
    NPNID
    string10  truefalseAGENT_CONTACT_NPNID 
    Name
    string320  truetrueAGENT_CONTACT_Name 
    NameWithSpouse
    string1023  truetrueAGENT_CONTACT_NameWithSpouse 
    NextActBy
    integer   truetrueAGENT_CONTACT_NextActBy 
    NextActByOffice
    integer   truetrueAGENT_CONTACT_NextActByOffice 
    NextActByPrimText
    string60  truetrueAGENT_CONTACT_NextActByPrimText 
    NextActByText
    string60  truetrueAGENT_CONTACT_NextActByText 
    NextActivityOn
    datetime   truetrueAGENT_CONTACT_NextActivityOn 
    NextCalOn
    datetime   truetrueAGENT_CONTACT_NextCalOn 
    OCSStage
    lookup  OCSStagetruefalseAGENT_CONTACT_OCSStage 
    PhonePrivacy
    lookup  YesNotruefalseAGENT_CONTACT_PhonePrivacy 
    PhotoID
    integer   truefalseAGENT_CONTACT_PhotoID 
    PostalMailPrivacy
    lookup  YesNotruefalseAGENT_CONTACT_PostalMailPrivacy 
    PreferedComm
    lookup  PreferredCommlookuptruefalseAGENT_CONTACT_PreferedComm 
    PreferredEMail
    string300  truetrueCONTACT_AGENT_PreferredEMail 
    PrimaryAdvisor
    integer   truefalseAGENT_CONTACT_PrimaryAdvisor 
    PrimaryAdvisorOfficeId
    integer   truefalseAGENT_CONTACT_PrimaryAdvisorOfficeId 
    Private
    lookup  YesNotruefalseAGENT_CONTACT_Private 
    QuickSearchFullName
    string400  truetrueAGENT_CONTACT_QuickSearchFullName 
    RecordType
    lookup  RecordTypetruefalseAGENT_CONTACT_RecordType 
    RecordTypeText
    lookuptext   truetrueAGENT_CONTACT_RecordTypeText 
    ReferentName
    string360  truefalseAGENT_CONTACT_ReferentName 
    ReferredByOfficeId
    integer   truefalseAGENT_CONTACT_ReferredByOfficeId 
    Remark
    string4000  truefalseAGENT_CONTACT_Remark 
    Source
    string64 SourceAdvisortruefalseAGENT_CONTACT_Source 
    SubSource
    string50 SubSourceAdvisortruefalseAGENT_CONTACT_SubSource 
    SubType
    string15 SubTypeAdvisortruefalseAGENT_CONTACT_SubType 
    Suffix
    string40 SuffixtruefalseAGENT_CONTACT_Suffix 
    TaxID
    string20  truefalseAGENT_CONTACT_TaxID 
    Addresses
     Address   
    Agent
     Agent   
    ReferredById
    id Contact truefalseAGENT_CONTACT_ReferredBy 
    ReferredByObj
    object Contact truefalseAGENT_CONTACT_ReferredBy 
    CustomData
     CustomData   
    Person
     Person   
    Phones
     Phone   
    CreatedById
    id User truefalseAGENT_CONTACT_CreatedBy 
    CreatedByObj
    object User truefalseAGENT_CONTACT_CreatedBy 
    ModifiedById
    id User truefalseAGENT_CONTACT_ModifiedBy 
    ModifiedByObj
    object User truefalseAGENT_CONTACT_ModifiedBy 
    WebAddresses
     WebAddress   


    AgentHierarchy
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENTHIERARCHY_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ContactId
    integer   truefalseAGENTHIERARCHY_CONTACTID 
    OfficeId
    integer   truefalseAGENTHIERARCHY_OFFICEID 
    SupervisorID
    integer   truefalseAGENTHIERARCHY_SUPERVISORID 
    AdvisorID
    id Agent truefalseAGENTHIERARCHY_CONTACTID 


    AgentInterestParty
    Referred By:

    Main TableData ObjectTopSearchReadonly
    POLAGENT_ALIASpolagenttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    InterestPercent
    double   falsefalsePOLAGENT_InterestPercent 
    MktManager
    string64 MktMgrfalsefalsePOLAGENT_MktManager 
    Name
    string300  truefalsePOLAGENT_NAME 
    OfficeCode
    string64 OffCodefalsefalsePOLAGENT_OfficeCode 
    PartyContactID
    integer   falsefalsePOLAGENT_AgentID 
    PartyRole
    lookup  RoletruefalsePOLAGENT_PartyRole 
    PartyRoleText
    lookuptext   falsetruePOLAGENT_PartyRoleText 
    RegionCode
    string64 RegionCodefalsefalsePOLAGENT_RegionCode 
    Relation
    string100 InterestpartyRelationfalsefalsePOLAGENT_Relation 
    Remarks
    string1024  falsefalsePOLAGENT_Remarks 
    RoleAsOfDate
    date   falsefalsePOLAGENT_RoleAsOfDate 
    RoleExpireDate
    date   falsefalsePOLAGENT_RoleExpireDate 
    Address
    object Address falsefalsePOLAGENT_AddressID 
    AddressId
    id Address falsefalsePOLAGENT_AddressID 
    AdvContract
    object AdvContract falsefalsePOLAGENT_ADVCONTRACTID 
    AdvContractID
    id AdvContract truefalsePOLAGENT_ADVCONTRACTID 
    Contact
    object Contact falsefalsePOLAGENT_AgentID 
    ContactID
    id Contact falsefalsePOLAGENT_AgentID 
    PolicyID
    id Policy truefalsePOLAGENT_HoldingID 


    AgentLicense
    Referred By:
    Agent.AgentLicenses  AgentRequest.LicenseID  AgentRequest.ProposedLicenseID 
    Main TableData ObjectTopSearchReadonly
    LICENSE_TABLELicensetruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentBroker
    lookup  LicenseAgentBrokerfalsefalseLICENSE_AgentBrokerIndicates license is agent or broker
    County
    lookup  CountyfalsefalseLICENSE_CountyCounty for license (for Florida only)
    EffDate
    date   truefalseLICENSE_EffDateLicense effective date
    ExpDate
    date   truefalseLICENSE_ExpDateLicense expiration date
    IndividualCorp
    lookup  LicenseIndCorpfalsefalseLICENSE_IndividualCorpIndicates license is for individual corp.
    IsProposed
    lookup  YesNotruefalseLICENSE_IsProposed 
    LOBList
    string255  falsetrueLICENSE_LOBList 
    LicenseNo
    string20  truefalseLICENSE_LicenseNoLicense number
    ModifiedOn
    datetime   truefalseLICENSE_ModifiedOn 
    Resident
    lookup  YesNofalsefalseLICENSE_ResidentResident State yes/no field
    State
    lookup  StateCodetruefalseLICENSE_StateStates licensed in
    Status
    lookup  LicenseStatustruefalseLICENSE_StatusLicense status
    TermDt
    date   falsefalseLICENSE_TermDtTerm date
    TermReason
    string2048  truefalseLICENSE_TermReasonRemarks
    AgentID
    id Contact truefalseLICENSE_AgentIDForeign Key -- Link to CONTACT table
    Contact
    object Contact falsefalseLICENSE_AgentIDForeign Key -- Link to CONTACT table


    AgentManager
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENTMANAGER_TABLEdefaultagentmanagerfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    LOB
    lookup  HoldingTypetruefalseAGENTMANAGER_LOB 
    ManagerType
    lookup  AdvisorRequestTypetruefalseAGENTMANAGER_ManagerTypeManager type
    ManagerTypeText
    lookuptext   truetrueAGENTMANAGER_ManagerTypeText 
    Agent
    object Agent truefalseAGENTMANAGER_AgentIDForeign Key -- Link to AGENT table
    AgentId
    id Agent truefalseAGENTMANAGER_AgentIDForeign Key -- Link to AGENT table
    Manager
    object User truefalseAGENTMANAGER_ManagerIDForeign Key -- Link to APPUSER table
    ManagerId
    id User truefalseAGENTMANAGER_ManagerIDForeign Key -- Link to APPUSER table


    AgentOfficeMap
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENTOFFICEMAP_TABLEagentofficemaptruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgencyNumber
    string64  truefalseAGENTOFFICEMAP_AgencyNumberAgency number
    LicenseNumber
    string20  truefalseAGENTOFFICEMAP_LicenseNumberLicense number
    Provider
    string24  truefalseAGENTOFFICEMAP_ProviderProvider
    OfficeIDForAgent
    id Office falsefalseAGENTOFFICEMAP_OfficeIDForAgentForeign Key -- Link to OFFICE table


    AgentProdSummary
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENTPRODSUMMARY_TABLEagentfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    COMMReceivable
    double   truefalseAGENTPRODSUMMARY_COMMRECEIVABLE 
    CombinedCases
    double   truefalseAGENTPRODSUMMARY_COMBINED_CASES 
    CombinedCases1
    double   truefalseAGENTPRODSUMMARY_COMBINEDCASES1 
    CombinedCasesPending
    double   truefalseAGENTPRODSUMMARY_PENDING_COMBINED_CASES 
    CombinedProd
    double   truefalseAGENTPRODSUMMARY_COMBINED_PROD 
    CombinedProd1
    double   truefalseAGENTPRODSUMMARY_COMBINEDPROD1 
    CombinedProdPending
    double   truefalseAGENTPRODSUMMARY_PENDING_COMBINED_PROD 
    CombinedRank
    integer   truefalseAGENTPRODSUMMARY_COMBINED_RANK 
    CombinedSubmitted
    date   truefalseAGENTPRODSUMMARY_LASTSUBMITTEDLOB1 Submitted Date
    CombinedTrend
    lookup  ProductionTrendtruefalseAGENTPRODSUMMARY_COMBINED_TREND 
    CurrMonthCases
    double   truefalseAGENTPRODSUMMARY_CurrMonthCases 
    CurrMonthProd
    double   truefalseAGENTPRODSUMMARY_CurrMonthProd 
    Days
    integer   truetrueAGENTPRODSUMMARY_DAYS 
    Days1
    integer   truetrueAGENTPRODSUMMARY_DAYS1 
    Days2
    integer   truetrueAGENTPRODSUMMARY_DAYS2 
    Days3
    integer   truetrueAGENTPRODSUMMARY_DAYS3 
    Days4
    integer   truetrueAGENTPRODSUMMARY_DAYS4 
    Days5
    integer   truetrueAGENTPRODSUMMARY_DAYS5 
    FixedAnnuity
    lookup  YesNotruefalseAGENTPRODSUMMARY_FixedAnnuity 
    FixedLife
    lookup  YesNotruefalseAGENTPRODSUMMARY_FixedLife 
    ImmidiateVarAnnuity
    lookup  YesNotruefalseAGENTPRODSUMMARY_ImmidiateVarAnnuity 
    LOB1Cases
    double   truefalseAGENTPRODSUMMARY_LOB1_CASES 
    LOB1Cases1
    double   truefalseAGENTPRODSUMMARY_LOB1CASES1 
    LOB1CasesPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB1_CASES 
    LOB1CommReceivable
    double   truefalseAGENTPRODSUMMARY_LOB1COMMRECEIVABLE 
    LOB1Prod1
    double   truefalseAGENTPRODSUMMARY_LOB1PROD1 
    LOB1ProdPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB1_PROD 
    LOB1ProjReceivable
    double   truefalseAGENTPRODSUMMARY_LOB1PROJRECEIVABLE 
    LOB1Rank
    integer   truefalseAGENTPRODSUMMARY_LOB1_RANK 
    LOB1SubmittedDate
    date   truefalseAGENTPRODSUMMARY_LASTSUBMITTED1LOB2 Submitted Date
    LOB1Trend
    lookup  ProductionTrendtruefalseAGENTPRODSUMMARY_LOB1_TREND 
    LOB2Cases
    double   truefalseAGENTPRODSUMMARY_LOB2_CASES 
    LOB2Cases1
    double   truefalseAGENTPRODSUMMARY_LOB2CASES1 
    LOB2CasesPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB2_CASES 
    LOB2CommReceivable
    double   truefalseAGENTPRODSUMMARY_LOB2COMMRECEIVABLE 
    LOB2Prod
    double   truefalseAGENTPRODSUMMARY_LOB2_PROD 
    LOB2Prod1
    double   truefalseAGENTPRODSUMMARY_LOB2PROD1 
    LOB2ProdPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB2_PROD 
    LOB2ProjReceivable
    double   truefalseAGENTPRODSUMMARY_LOB2PROJRECEIVABLE 
    LOB2Rank
    integer   truefalseAGENTPRODSUMMARY_LOB2_RANK 
    LOB2SubmittedDate
    date   truefalseAGENTPRODSUMMARY_LASTSUBMITTED2LOB3 Submitted Date
    LOB2Trend
    lookup  ProductionTrendtruefalseAGENTPRODSUMMARY_LOB2_TREND 
    LOB3Cases
    double   truefalseAGENTPRODSUMMARY_LOB3_CASES 
    LOB3Cases1
    double   truefalseAGENTPRODSUMMARY_LOB3CASES1 
    LOB3CasesPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB3_CASES 
    LOB3CommReceivable
    double   truefalseAGENTPRODSUMMARY_LOB3COMMRECEIVABLE 
    LOB3Prod
    double   truefalseAGENTPRODSUMMARY_LOB3_PROD 
    LOB3Prod1
    double   truefalseAGENTPRODSUMMARY_LOB3PROD1 
    LOB3ProdPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB3_PROD 
    LOB3ProjReceivable
    double   truefalseAGENTPRODSUMMARY_LOB3PROJRECEIVABLE 
    LOB3Rank
    integer   truefalseAGENTPRODSUMMARY_LOB3_RANK 
    LOB3SubmittedDate
    date   truefalseAGENTPRODSUMMARY_LASTSUBMITTED3LOB4 Submitted Date
    LOB3Trend
    lookup  ProductionTrendtruefalseAGENTPRODSUMMARY_LOB3_TREND 
    LOB4Cases
    double   truefalseAGENTPRODSUMMARY_LOB4_CASES 
    LOB4Cases1
    double   truefalseAGENTPRODSUMMARY_LOB4CASES1 
    LOB4CasesPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB4_CASES 
    LOB4CommReceivable
    double   truefalseAGENTPRODSUMMARY_LOB4COMMRECEIVABLE 
    LOB4NRank
    integer   truefalseAGENTPRODSUMMARY_LOB4_RANK 
    LOB4Prod
    double   truefalseAGENTPRODSUMMARY_LOB4_PROD 
    LOB4Prod1
    double   truefalseAGENTPRODSUMMARY_LOB4PROD1 
    LOB4ProdPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB4_PROD 
    LOB4ProjReceivable
    double   truefalseAGENTPRODSUMMARY_LOB4PROJRECEIVABLE 
    LOB4SubmittedDate
    date   truefalseAGENTPRODSUMMARY_LASTSUBMITTED4LOB5 Submitted Date
    LOB4Trend
    lookup  ProductionTrendtruefalseAGENTPRODSUMMARY_LOB4_TREND 
    LOB5Cases
    double   truefalseAGENTPRODSUMMARY_LOB5_CASES 
    LOB5Cases1
    double   truefalseAGENTPRODSUMMARY_LOB5CASES1 
    LOB5CasesPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB5_CASES 
    LOB5CommReceivable
    double   truefalseAGENTPRODSUMMARY_LOB5COMMRECEIVABLE 
    LOB5Prod
    double   truefalseAGENTPRODSUMMARY_LOB5_PROD 
    LOB5Prod1
    double   truefalseAGENTPRODSUMMARY_LOB5PROD1 
    LOB5ProdPending
    double   truefalseAGENTPRODSUMMARY_PENDING_LOB5_PROD 
    LOB5ProjReceivable
    double   truefalseAGENTPRODSUMMARY_LOB5PROJRECEIVABLE 
    LOB5Rank
    integer   truefalseAGENTPRODSUMMARY_LOB5_RANK 
    LOB5SubmittedDate
    date   truefalseAGENTPRODSUMMARY_LASTSUBMITTED5Combined Submitted Date
    LOB5Trend
    lookup  ProductionTrendtruefalseAGENTPRODSUMMARY_LOB5_TREND 
    LOBProd1
    double   truefalseAGENTPRODSUMMARY_LOB1_PROD 
    MTHCommReceived
    double   truefalseAGENTPRODSUMMARY_MONTH_COMMRECEIVED 
    PROJReceivable
    double   truefalseAGENTPRODSUMMARY_PROJRECEIVABLE 
    PrevMonthCases
    double   truefalseAGENTPRODSUMMARY_PrevMonthCases 
    PrevMonthCases1
    double   truefalseAGENTPRODSUMMARY_PrevMonthCases1 
    PrevMonthProd
    double   truefalseAGENTPRODSUMMARY_PrevMonthProd 
    PrevMonthProd1
    double   truefalseAGENTPRODSUMMARY_PrevMonthProd1 
    Q1Cases
    double   truefalseAGENTPRODSUMMARY_Q1Cases 
    Q1Cases1
    double   truefalseAGENTPRODSUMMARY_Q1Cases1 
    Q1CommReceived
    double   truefalseAGENTPRODSUMMARY_Q1COMMRECEIVED 
    Q1Prod
    double   truefalseAGENTPRODSUMMARY_Q1Prod 
    Q1Prod1
    double   truefalseAGENTPRODSUMMARY_Q1Prod1 
    Q2Cases
    double   truefalseAGENTPRODSUMMARY_Q2Cases 
    Q2Cases1
    double   truefalseAGENTPRODSUMMARY_Q2Cases1 
    Q2CommReceived
    double   truefalseAGENTPRODSUMMARY_Q2COMMRECEIVED 
    Q2Prod
    double   truefalseAGENTPRODSUMMARY_Q2Prod 
    Q2Prod1
    double   truefalseAGENTPRODSUMMARY_Q2Prod1 
    Q3Cases
    double   truefalseAGENTPRODSUMMARY_Q3Cases 
    Q3Cases1
    double   truefalseAGENTPRODSUMMARY_Q3Cases1 
    Q3CommReceived
    double   truefalseAGENTPRODSUMMARY_Q3COMMRECEIVED 
    Q3Prod
    double   truefalseAGENTPRODSUMMARY_Q3Prod 
    Q3Prod1
    double   truefalseAGENTPRODSUMMARY_Q3Prod1 
    Q4Cases
    double   truefalseAGENTPRODSUMMARY_Q4Cases 
    Q4Cases1
    double   truefalseAGENTPRODSUMMARY_Q4Cases1 
    Q4CommReceived
    double   truefalseAGENTPRODSUMMARY_Q4COMMRECEIVED 
    Q4Prod
    double   truefalseAGENTPRODSUMMARY_Q4Prod 
    Q4Prod1
    double   truefalseAGENTPRODSUMMARY_Q4Prod1 
    RetailBanking
    lookup  YesNotruefalseAGENTPRODSUMMARY_RetailBanking 
    SellsCol1
    lookup  YesNotruefalseAGENTPRODSUMMARY_COLI 
    SellsDI
    lookup  YesNotruefalseAGENTPRODSUMMARY_DI 
    SellsGroup
    lookup  YesNotruefalseAGENTPRODSUMMARY_Group 
    SellsLtc
    lookup  YesNotruefalseAGENTPRODSUMMARY_LTC 
    SellsMF
    lookup  YesNotruefalseAGENTPRODSUMMARY_MF 
    SellsOther
    lookup  YesNotruefalseAGENTPRODSUMMARY_Other 
    SellsWrap
    lookup  YesNotruefalseAGENTPRODSUMMARY_WRAP 
    ServiceLevel
    lookup  ServiceLeveltruefalseAGENTPRODSUMMARY_ServiceLevel 
    ValidateDate
    datetime   truefalseAGENTPRODSUMMARY_ValidateDate 
    VariableAnnuity
    lookup  YesNotruefalseAGENTPRODSUMMARY_VariableAnnuity 
    VariableLife
    lookup  YesNotruefalseAGENTPRODSUMMARY_VariableLife 
    Wirehouse
    lookup  YesNotruefalseAGENTPRODSUMMARY_Wirehouse 
    YTDCases
    double   truefalseAGENTPRODSUMMARY_YTDCases 
    YTDCases1
    double   truefalseAGENTPRODSUMMARY_YTDCases1 
    YTDCommReceived
    double   truefalseAGENTPRODSUMMARY_YTD_COMMRECEIVED 
    YTDProd
    double   truefalseAGENTPRODSUMMARY_YTDProd 
    YTDProd1
    double   truefalseAGENTPRODSUMMARY_YTDProd1 
    AgentId
    id Agent truefalseAGENTPRODSUMMARY_AgentID 
    AgentObj
    object Agent truefalseAGENTPRODSUMMARY_AgentID 


    AgentReqs
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENTREQS_TABLEagentreqsfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentReqType
    lookup  AgentRequestTypetruefalseAGENTREQS_AgentReqType 
    Completed
    date   falsefalseAGENTREQS_Completed 
    Description
    string255  falsefalseAGENTREQS_Description 
    DueDate
    date   falsefalseAGENTREQS_DueDate 
    Mandatory
    byte  YesNotruefalseAGENTREQS_Mandatory 
    ModifiedOn
    datetime   truefalseAGENTREQS_ModifiedOn 
    Remarks
    string512  falsefalseAGENTREQS_Remarks 
    RequiredOf
    lookup  RequiredOfAgentRequestReqtruefalseAGENTREQS_RequiredOf 
    Status
    lookup  AgentReqStatustruefalseAGENTREQS_Status 
    StatusDate
    date   falsefalseAGENTREQS_StatusDate 
    AgentRequestID
    id AgentRequest falsefalseAGENTREQS_RequestId 
    AssignedUser
    object User falsefalseAGENTREQS_AssignedTo 
    AssignedUserID
    id User falsefalseAGENTREQS_AssignedTo 


    AgentRequest
    Referred By:
    AgentReqs.AgentRequestID 
    Main TableData ObjectTopSearchReadonly
    AGENTREQUEST_TABLEagentrequesttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CompletedDate
    date   truefalseAGENTREQUEST_COMPLETEDAdvisor request completed date
    Description
    string2048  falsefalseAGENTREQUEST_DESCRIPTIONAdvisor request description
    FollowUpDate
    date   falsefalseAGENTREQUEST_FOLLOWUPDATEAdvisor request follow-up date
    LOB
    lookup  InsuranceTypetruefalseAGENTREQUEST_LobLine of business
    ModifiedOn
    date   truefalseAGENTREQUEST_LASTMODIFIEDDATEDate last modified
    ProposedContractVal
    integer   falsefalseAGENTREQUEST_ProposedContractID 
    State
    lookup  StateCodetruefalseAGENTREQUEST_StateState
    StateText
    lookuptext   falsetrueAGENTREQUEST_StateText 
    Status
    lookup  AgentRequestStatustruefalseAGENTREQUEST_STATUSAdvisor request status
    StatusDate
    date   falsefalseAGENTREQUEST_StatusDate 
    StatusText
    lookuptext   falsetrueAGENTREQUEST_StatusText 
    Type
    lookup  AdvisorRequestTypetruefalseAGENTREQUEST_TYPEAdvisor request type
    TypeText
    lookuptext   falsetrueAGENTREQUEST_TypeText 
    ContractID
    id AdvContract falsefalseAGENTREQUEST_ContractIDForeign Key -- Link to CONTRACT table
    ProposedContractID
    id AdvContract falsefalseAGENTREQUEST_ProposedContractID 
    LicenseID
    id AgentLicense falsefalseAGENTREQUEST_LicenseIDForeign Key -- Link to LICENSE table
    ProposedLicenseID
    id AgentLicense falsefalseAGENTREQUEST_ProposedLicenseID 
    AppointmentID
    id Appoinment falsefalseAGENTREQUEST_AppointmentsIDForeign Key -- Link to APPOITMENT table
    ProposedAppID
    id Appoinment falsefalseAGENTREQUEST_ProposedAppID 
    Agent
    object Contact falsefalseAGENTREQUEST_AGENTIDForeign Key -- Link to AGENT table
    AgentID
    id Contact truefalseAGENTREQUEST_AGENTIDForeign Key -- Link to AGENT table
    CarrierID
    id ContactVendor truefalseAGENTREQUEST_CarrierIdForeign Key -- Link to VENDOR table
    CarrierObj
    object ContactVendor truefalseAGENTREQUEST_CarrierIdForeign Key -- Link to VENDOR table
    EOStatusID
    id EOStatus falsefalseAGENTREQUEST_EOStatusIDForeign Key -- Link to EOSTATUS table
    ProposedEOStatusID
    id EOStatus falsefalseAGENTREQUEST_ProposedEOID 
    ORGAgencyManager
    id User truefalseAGENTREQUEST_ORGAgencyManagerForeign Key -- Link to APPUSER table


    AgentRequirement
    Referred By:

    Main TableData ObjectTopSearchReadonly
    AGENTREQUIREMENT_TABLEagentrequirementtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentID
    id Agent truefalseAGENTREQUIREMENT_AgentIdPrimary Foreign Key -- Link to AGENT table
    MasterListID
    id VendorReq truefalseAGENTREQUIREMENT_MasterListIdPrimary Foreign Key -- Link to VENDORREQ table


    Annuity
    Referred By:
    Policy.Annuity 
    Main TableData ObjectTopSearchReadonly
    ANNUITY_TABLEpolicyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AnnualInc
    double   falsefalseANNUITY_AnnualIncAnnual income
    AnnuityCost
    double   falsefalseANNUITY_AnnuityCostAnnuity cost
    AnnuityForm
    string60  falsefalseANNUITY_AnnuityFormAnnuity form
    AnnuityRate
    double   falsefalseANNUITY_AnnuityRateAnnuity rate
    CurrDate
    date   falsefalseANNUITY_CurrDateCurrent date
    CurrValue
    double   falsefalseANNUITY_CurrValueCurrent value
    DefVal86
    double   falsefalseANNUITY_DefVal861986 defined value
    DefVal88
    double   falsefalseANNUITY_DefVal881988 defined value
    EEContribution
    double   falsefalseANNUITY_EEContriEmployee contribution amount
    EEValue
    double   falsefalseANNUITY_EEValueValue of all employee contributions
    ERContribution
    double   falsefalseANNUITY_ERContriEmployer contribution amount
    ERValue
    double   falsefalseANNUITY_ERValueValue of all employer contributions
    Employer
    string60  falsefalseANNUITY_EmployerEmployer name
    Immediate
    lookup  YesNofalsefalseANNUITY_ImmediateImmediate annuity
    LoanAmount
    double   falsefalseANNUITY_LoanAmountAmount of loan
    LoanInt
    double   falsefalseANNUITY_LoanIntLoan interest
    MaturityDate
    date   falsefalseANNUITY_MATDateMaturity date
    MaturityValue
    double   falsefalseANNUITY_MATValueMaturity value
    PaymentsYr
    short   falsefalseANNUITY_PaymentsYrPeriodic payout amount
    PayoutAmt
    double   falsefalseANNUITY_PayoutAmtPayout amount
    PenphSend
    date   falsefalseANNUITY_PenphSendDate annuity leaves penalty phase
    PeriodicAmt
    double   falsefalseANNUITY_PeriodicAmtPeriodic deposit amount
    PurDate
    date   falsefalseANNUITY_PurDatePurchase date
    Qualified
    lookup  YesNofalsefalseANNUITY_QualifiedQualified yes/no field
    SubAcctValue
    double   falsefalseANNUITY_SubAcctValue 
    SurrValue
    double   falsefalseANNUITY_SurrValueAnnuity surrender value
    TaxPay
    double   falsefalseANNUITY_TaxPayTax pay
    Type
    lookup  TaxTypefalsefalseANNUITY_TypeAnnuity type choice field
    Withdrawals
    double   falsefalseANNUITY_WithdrawalsAmount of each withdrawal
    WtdrlsYear
    double   falsefalseANNUITY_WtdrlsYearNumber of withdrawals per year


    Application
    Referred By:

    Main TableData ObjectTopSearchReadonly
    SIADAPTER_TABLEsiadaptertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    BillingOption
    lookup  BillingOptionsfalsefalseSIADAPTER_BillingOption 
    BillingType
    lookup  AdapterBillingIndicatorfalsefalseSIADAPTER_BillIndicator 
    Category
    lookup  AdapterCategoryfalsefalseSIADAPTER_Category 
    CreatedBy
    integer   falsefalseSIADAPTER_CreatedByCreated by
    CreatedByOfficeID
    integer   falsefalseSIADAPTER_CreatedByOfficeIDCreated by officeid
    CreatedOn
    datetime   falsefalseSIADAPTER_CreatedOnCreated on
    Format
    lookup  AdapterFormatfalsefalseSIADAPTER_Format 
    FreePeriod
    integer   falsefalseSIADAPTER_FreePeriod 
    LOB
    string255  falsefalseSIADAPTER_LOB 
    LicenseID
    integer   truefalseSIADAPTER_LicenseIDLicenseID for the standard SmartIntegrator Plug-ins.
    LicenseType
    lookup  SI_LicesnseTypefalsefalseSIADAPTER_LicenseTypeLicense type.
    ModifiedBy
    integer   falsefalseSIADAPTER_ModifiedByModified by
    ModifiedByOfficeID
    integer   falsefalseSIADAPTER_ModifiedByOfficeIDModified by officeid
    string255  falsefalseSIADAPTER_MovieLink 
    Name
    string40  truefalseSIADAPTER_NameAdapter name
    OfficeID
    integer   truefalseSIADAPTER_OFFICEID 
    PackageID
    integer   falsefalseSIADAPTER_PackageIDPackage Id
    PushEventFlag
    lookup  YesNotruefalseSIADAPTER_PushEventFlag 
    PushEventType
    lookup  PushEventServiceNametruefalseSIADAPTER_PushEventType 
    RackPrice
    double   falsefalseSIADAPTER_RackPrice 
    ReleaseDate
    date   falsefalseSIADAPTER_ReleaseDate 
    SeStatus
    lookup  AdapterStatusfalsefalseSIADAPTER_SEStatus 
    Status
    lookup  ApplicationStatustruefalseSIADAPTER_StatusAdapter status
    Tier1
    lookup  YesNotruefalseSIADAPTER_Tier1 
    Tier2
    lookup  YesNotruefalseSIADAPTER_Tier2 
    Tier3
    lookup  YesNotruefalseSIADAPTER_Tier3 
    Tier4
    lookup  YesNotruefalseSIADAPTER_Tier4 
    TierStatus
    lookup  TierStatustruefalseSIADAPTER_TierStatus 
    URL
    string255  falsefalseSIADAPTER_WebaddressWeb address


    Appoinment
    Referred By:
    Agent.Appoinments  AgentRequest.AppointmentID  AgentRequest.ProposedAppID 
    Main TableData ObjectTopSearchReadonly
    APPOINTMENTS_TABLEAppointmenttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentIDVal
    integer   truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    AppointmentNo
    string64  truefalseAPPOINTMENTS_AppointmentNoAppointment number
    AppointmentsID
    integer   truefalseAPPOINTMENTS_AppointmentsIDPrimary Key
    ChkResident
    string10  truetrueAPPOINTMENTS_ChkResident 
    ContractNo
    string30  falsefalseAPPOINTMENTS_ContractNoContract number assigned by carrier (if any)
    County
    lookup  CountyfalsefalseAPPOINTMENTS_CountyCounty for State of Florida
    EndDate
    date   truefalseAPPOINTMENTS_EndDateDate which the appointment expires
    HasDocument
    lookup  YesNotruetrueAPPOINTMENTS_HasDocumentHas document
    IsProposed
    lookup  YesNotruefalseAPPOINTMENTS_IsProposed 
    LOBList
    string255  truetrueAPPOINTMENTS_LOBList 
    OfficeID
    integer   truefalseAPPOINTMENTS_OfficeIDPrimary Key
    Resident
    lookup  YesNofalsefalseAPPOINTMENTS_ResidentIndicates residence in state
    StartDate
    date   truefalseAPPOINTMENTS_StartDateDate which the appointment is valid from
    State
    lookup  StateCodetruetrueAPPOINTMENTS_StateState in which the appointment is for
    StateList
    string255  truetrueAPPOINTMENTS_StateList 
    StateStr
    string255  truefalseAPPOINTMENTS_StateStrList of all selected states
    Status
    lookup  LicenseStatustruefalseAPPOINTMENTS_StatusAppointment status, e.g., active, inactive
    TermReason
    string2048  truefalseAPPOINTMENTS_TermReasonAppointment remarks
    VendorIDVal
    integer   truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table
    VendorOfficeID
    integer   truefalseAPPOINTMENTS_VendorOfficeIDForeign Key -- Link to VENDOR table
    Agent
    object Agent falsefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    AgentID
    id Agent truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    CreatedBy
    object User falsefalseAPPOINTMENTS_CreatedByForeign Key -- Link to APPUSER table
    CreatedById
    id User truefalseAPPOINTMENTS_CreatedByForeign Key -- Link to APPUSER table
    ModifiedBy
    object User falsefalseAPPOINTMENTS_ModifiedByForeign Key -- Link to APPUSER table
    ModifiedById
    id User truefalseAPPOINTMENTS_ModifiedByForeign Key -- Link to APPUSER table
    Vendor
    object Vendor truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table
    VendorID
    id Vendor truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table


    Appointments
    Referred By:
    LAEType.LinkIDID 
    Main TableData ObjectTopSearchReadonly
    APPOINTMENTS_TABLEAppointmenttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentID
    integer   truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    AgentIDVal
    integer   truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    AppointmentNo
    string64  truefalseAPPOINTMENTS_AppointmentNoAppointment number
    AppointmentsID
    integer   truefalseAPPOINTMENTS_AppointmentsIDPrimary Key
    ChkResident
    string10  truetrueAPPOINTMENTS_ChkResident 
    ContractNo
    string30  truefalseAPPOINTMENTS_ContractNoContract number assigned by carrier (if any)
    County
    lookup  CountytruefalseAPPOINTMENTS_CountyCounty for State of Florida
    EndDate
    date   truefalseAPPOINTMENTS_EndDateDate which the appointment expires
    HasDocument
    lookup  YesNotruetrueAPPOINTMENTS_HasDocumentHas document
    LOBList
    string255  truetrueAPPOINTMENTS_LOBList 
    ModifiedOn
    datetime   truefalseAPPOINTMENTS_ModifiedOn 
    OfficeID
    integer   truefalseAPPOINTMENTS_OfficeIDPrimary Key
    Resident
    lookup  YesNotruefalseAPPOINTMENTS_ResidentIndicates residence in state
    StartDate
    date   truefalseAPPOINTMENTS_StartDateDate which the appointment is valid from
    State
    lookup  StateCodetruetrueAPPOINTMENTS_StateState in which the appointment is for
    StateList
    string255  truetrueAPPOINTMENTS_StateList 
    StateStr
    string255  truefalseAPPOINTMENTS_StateStrList of all selected states
    Status
    lookup  LicenseStatustruefalseAPPOINTMENTS_StatusAppointment status, e.g., active, inactive
    TermReason
    string2048  truefalseAPPOINTMENTS_TermReasonAppointment remarks
    VendorID
    integer   truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table
    VendorIDVal
    integer   truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table
    VendorOfficeID
    integer   truefalseAPPOINTMENTS_VendorOfficeIDForeign Key -- Link to VENDOR table
    Agent
    object Agent truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    AgentObj
    object Agent truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    AgentObjID
    id Agent truefalseAPPOINTMENTS_AgentIDForeign Key -- Link to AGENT table
    LAETypes
     LAEType   
    ProdLicTypeID
    id ProductLicType truefalseAPPOINTMENTS_ProdLicTypeID 
    ProductLicType
    object ProductLicType falsefalseAPPOINTMENTS_ProdLicTypeID 
    CreatedBy
    object User falsefalseAPPOINTMENTS_CreatedByForeign Key -- Link to APPUSER table
    CreatedById
    id User truefalseAPPOINTMENTS_CreatedByForeign Key -- Link to APPUSER table
    ModifiedBy
    object User falsefalseAPPOINTMENTS_ModifiedByForeign Key -- Link to APPUSER table
    ModifiedById
    id User truefalseAPPOINTMENTS_ModifiedByForeign Key -- Link to APPUSER table
    VendorObj
    object Vendor truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table
    VendorObjID
    id Vendor truefalseAPPOINTMENTS_VendorIDForeign Key -- Link to VENDOR table


    AssetPreAlloc
    Referred By:

    Main TableData ObjectTopSearchReadonly
    ASSETPREALLOC_TABLEassetprealloctruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AssetType
    lookup  AssetClassfalsefalseASSETPREALLOC_AssetTypePrimary Key
    Description
    string128  falsefalseASSETPREALLOC_DescriptionDescription
    DesiredAlloc
    integer   falsefalseASSETPREALLOC_DesiredAllocPercent allocated
    RiskTolerance
    integer   falsefalseASSETPREALLOC_RiskTolerancePercent of tolerance
    Sector
    lookup  AssetSectorfalsefalseASSETPREALLOC_SectorSector
    RiskLevel
    object AssetallocRiskLevel truefalseASSETPREALLOC_RiskLevel 
    RiskLevelID
    id AssetallocRiskLevel truefalseASSETPREALLOC_RiskLevel 


    AssetallocRiskLevel
    Referred By:
    RiskAssignment.RiskLevelId  RiskAssignment.RiskLevel  AssetPreAlloc.RiskLevel  AssetPreAlloc.RiskLevelID 
    Main TableData ObjectTopSearchReadonly
    ASSETALLOCRISKLEVEL_TABLEassetallocrisklvlfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CreatedByText
    string60  falsetrueASSETALLOCRISKLEVEL_CreatedByTextCreated By
    CreatedOn
    datetime   falsefalseASSETALLOCRISKLEVEL_CreatedOnCreated On
    Description
    string512  falsefalseASSETALLOCRISKLEVEL_Description 
    ModifiedByText
    string60  falsetrueASSETALLOCRISKLEVEL_ModifiedByTextModified By
    ModifiedOn
    datetime   falsefalseASSETALLOCRISKLEVEL_ModifiedOnModified On
    Name
    string255  falsefalseASSETALLOCRISKLEVEL_Name 
    CreatedBy
    object User truefalseASSETALLOCRISKLEVEL_CreatedByIdForeign key Link to APPUSER
    CreatedById
    id User truefalseASSETALLOCRISKLEVEL_CreatedByIdForeign key Link to APPUSER
    ModifiedBy
    object User truefalseASSETALLOCRISKLEVEL_ModifiedByIdForeign key Link to APPUSER
    ModifiedById
    id User truefalseASSETALLOCRISKLEVEL_ModifiedByIdForeign key Link to APPUSER


    Assignment
    Referred By:
    Contact.Assignments 
    Main TableData ObjectTopSearchReadonly
    ASSIGNMENT_TABLEassignmentfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppuserID
    integer   truefalseASSIGNMENT_AppuserIDPrimary Foreign Key -- Link to APPUSER table
    AppuserOfficeID
    integer   truefalseASSIGNMENT_AppuserOfficeIDPrimary Foreign Key -- Link to APPUSER table
    ModifiedOn
    datetime   truefalseASSIGNMENT_ModifiedOnDate of last modification
    Type
    lookup  AssignmentTypetruefalseASSIGNMENT_Type 
    Contact
    object Contact truefalseASSIGNMENT_ContactID 
    ContactID
    id Contact truefalseASSIGNMENT_ContactID 
    User
    object User truefalseASSIGNMENT_AppuserIDPrimary Foreign Key -- Link to APPUSER table
    UserID
    id User truefalseASSIGNMENT_AppuserIDPrimary Foreign Key -- Link to APPUSER table


    Auto
    Referred By:
    Policy.Auto 
    Main TableData ObjectTopSearchReadonly
    AUTO_TABLEpolicyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AddPIP
    integer   falsefalseAUTO_AddPIPPersonal injury protection
    BodilyInjury1
    integer   falsefalseAUTO_BodilyInjury1Bodily injury per person
    BodilyInjury2
    integer   falsefalseAUTO_BodilyInjury2Bodily injury per accident
    Medical1
    integer   falsefalseAUTO_Medical1Medical coverage per person
    Medical2
    integer   falsefalseAUTO_Medical2Medical field 2 (not used)
    MultiCarDisc
    lookup  YesNofalsefalseAUTO_MultiCarDiscMultiple car discount
    MultiPolDisc
    lookup  YesNofalsefalseAUTO_MultiPolDiscMultiple policy discount
    PropDamage1
    integer   falsefalseAUTO_PropDamage1Property damage field 1 (not used)
    PropDamage2
    integer   falsefalseAUTO_PropDamage2Property damage coverage per accident
    Rental
    string40  falsefalseAUTO_RentalRental coverage
    Towing
    string40  falsefalseAUTO_TowingTowing coverage
    UMBI
    integer   falsefalseAUTO_UMBIUninsured motorist bodily injury per person
    UMBI1
    integer   falsefalseAUTO_UMBI1Uninsured motorist bodily injury per accident
    UMPD
    integer   falsefalseAUTO_UMPDUninsured motorist property damage 1 (not used)
    UMPD2
    integer   falsefalseAUTO_UMPD2Uninsured motorist property damage 2 (not used)


    BankAcct
    Referred By:
    Position.BankAcct 
    Main TableData ObjectTopSearchReadonly
    BANKACCT_TABLEpositionfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AnnualIncome
    double   falsefalseBANKACCT_AnnualIncomeAnnual income
    BankAcctType
    lookup  BankAcctTypefalsefalseBANKACCT_BankAcctTypeBank account type choice field
    BankAcctTypeText
    lookuptext   falsetrueBANKACCT_BankAcctTypeText 
    CalculateBank
    lookup  YesNofalsefalseBANKACCT_CalculateBankOption: calculate maturity value & annual income
    Compunding
    lookup  CompoundMethodfalsefalseBANKACCT_CompundingBank account's compounding period
    InterestRate
    double   falsefalseBANKACCT_InterestRateBank account's interest rate
    MaturityDate
    date   falsetrueBANKACCT_MaturityDateBank accounts maturity date
    MaturityValue
    double   falsetrueBANKACCT_MaturityValueBank accounts maturity value
    Term
    integer   falsefalseBANKACCT_TermDeposit term


    BinaryData
    Referred By:

    Main TableData ObjectTopSearchReadonly
    BINARYDATA_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    BlobData
    dtImage   truefalseBINARYDATA_BlobData 
    ContentType
    string75  truefalseBINARYDATA_ContentTypeMIME type
    Description
    string128  truefalseBINARYDATA_DescriptionDescription of this BLOB
    FileName
    string256  truefalseBINARYDATA_FileNameFile Name
    IsCompressed
    byte  YesNotruefalseBINARYDATA_IsCompressed 
    LinkID
    integer   truefalseBINARYDATA_LinkIDReverse pointer from BLOB to the table that is pointing this record.
    LinkTable
    integer   truefalseBINARYDATA_LinkTableReverse pointer from BLOB to the table that is pointing this record.


    BrokerDealer
    Referred By:
    Agent.BrokerDealers 
    Main TableData ObjectTopSearchReadonly
    BROKERDEALER_TABLEbrokerdealertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CRDNo
    string128  falsefalseBROKERDEALER_CRDNoCRD number
    EffectiveDate
    date   falsefalseBROKERDEALER_EffectiveDateEffective date
    ExpirationDate
    date   falsefalseBROKERDEALER_ExpirationDateExpiration date
    NASDSeries
    lookup  NASDSeriesfalsefalseBROKERDEALER_NASDSeriesNASD series choice field
    Reason
    text   falsefalseBROKERDEALER_ReasonReason
    RepID
    string30  falsefalseBROKERDEALER_RepIDRep. ID
    SponsorCompany
    string128  falsefalseBROKERDEALER_SponsorCompanySponsor company
    AgentID
    id Agent truefalseBROKERDEALER_AgentIdForeign Key -- Link to AGENT table
    ContactId
    id Contact truefalseBROKERDEALER_ContactIdForeign Key -- Link to CONTACT table


    Business
    Referred By:
    RelatedContact.Business  DeletedGroupCensus.Business  DeletedGroupCensus.BusinessID  Contact.Business 
    Main TableData ObjectTopSearchReadonly
    BUSINESS_TABLEcontactfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AbbrName
    string20  truefalseBUSINESS_AbbrNameBusiness short name
    BusinessClass
    lookup  BusinessClasstruefalseBUSINESS_BusinessClassBusiness class
    BusinessType
    lookup  BusinessTypetruefalseBUSINESS_BusinessTypeType of business
    DoingBusinessAs
    string64  truefalseBUSINESS_DoingBusAsDoing business as
    Employees
    integer   falsefalseBUSINESS_EmployeesNumber of employees
    EstabDate
    date   truefalseBUSINESS_EstDateDate business established
    FiscalYear
    date   falsefalseBUSINESS_FiscalYearFiscal year
    Income
    integer   falsefalseBUSINESS_IncomeIncome
    Industry
    lookup  IndustrytruefalseBUSINESS_IndustryType of industry
    IndustryText
    lookuptext   falsetrueBUSINESS_IndustryText 
    ModifiedOn
    datetime   truefalseBUSINESS_ModifiedOnDate last modified
    NumOwners
    integer   falsetrueBUSINESS_NoOwnersNumber of owners
    PrimaryContactName
    string60  falsefalseBUSINESS_PrimContactPrimary contact person for the business
    Revenue
    double   falsefalseBUSINESS_RevenueEstimated annual revenue for the business
    SICNumber
    string30  falsefalseBUSINESS_SICNOSIC number
    Segment
    string30  falsefalseBUSINESS_SegmentSegment
    Tax
    double   falsefalseBUSINESS_TaxTax
    PrimaryContact
    object Contact falsefalseBUSINESS_PrimContactIDForeign Key -- Link to CONTACT table


    BusinessVendor
    Referred By:
    ContactVendor.Business 
    Main TableData ObjectTopSearchReadonly
    BUSINESS_VENDOR_ALIASvendorfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AbbrName
    string20  truefalseVENDOR_AbbrName 
    PrimaryContactName
    string60  truefalseVENDOR_PrimContact 
    PrimaryContactID
    id ContactVendor falsefalseVENDOR_PrimContactID 


    CECredits
    Referred By:
    CECreditsDetail.CECreditsID 
    Main TableData ObjectTopSearchReadonly
    CECREDITS_TABLEEducationtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CreatedOn
    date   falsefalseCECREDITS_CreatedOnDate created
    DateFrom
    date   falsefalseCECREDITS_DateFromStart date when credits are required
    DateTo
    date   falsefalseCECREDITS_DateToEnd date when credits are required
    ModifiedOn
    date   truefalseCECREDITS_ModifiedOnDate modified
    Required
    double   falsefalseCECREDITS_RequiredCredits required
    State
    lookup  StateCodefalsefalseCECREDITS_StateState in which credits are required
    Status
    lookup  ProductStatusfalsefalseCECREDITS_StatusStatus of credits
    AgentID
    id Agent truefalseCECREDITS_AgentIDForeign Key -- Link to AGENT table
    CreatedBy
    id User truefalseCECREDITS_CreatedByForeign Key -- Link to APPUSER table
    ModifiedBy
    id User truefalseCECREDITS_ModifiedByForeign Key -- Link to APPUSER table


    CECreditsDetail
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CECREDITSDETAIL_TABLEcecreditstruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CECredits
    double   falsefalseCECREDITSDETAIL_CECreditsNumber of CE credits earned for class
    CEDate
    date   falsefalseCECREDITSDETAIL_CEDateDate of CE credit class
    Description
    string255  falsefalseCECREDITSDETAIL_DescriptionCE class description
    Remarks
    string255  falsefalseCECREDITSDETAIL_RemarksCE class remarks
    CECreditsID
    object CECredits truefalseCECREDITSDETAIL_CECreditsIDForeign Key -- Link to CECREDITS table


    Campaign
    Referred By:
    Lead.CampaignID  Opportunity.Campaign 
    Main TableData ObjectTopSearchReadonly
    CAMPAIGN_TABLEcampaigntruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Budget
    double   falsefalseCAMPAIGN_BudgetBudget
    EndDate
    date   falsefalseCAMPAIGN_EndDateEnd date
    Name
    string80  truefalseCAMPAIGN_NameName of the campaign
    Remarks
    string1024  falsefalseCAMPAIGN_RemarksRemarks
    SponsoredBy
    string80  falsefalseCAMPAIGN_SponsoredBySponsored by
    StartDate
    date   falsefalseCAMPAIGN_StartDateStart date
    Status
    lookup  CampaignStatustruefalseCAMPAIGN_StatusStatus of the campaign: Active or Inactive


    CarbonCopy
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CARBONCOPY_TABLEcarboncopytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CaseStatusContact
    lookup  YesNotruefalseCARBONCOPY_CaseStatusContact 
    CcToCaseStatus
    lookup  YesNotruefalseCARBONCOPY_CcToCaseStatus 
    Purpose
    string2048  truetrueCARBONCOPY_Purpose 
    PurposeList
    string255  truefalseCARBONCOPY_PurposeListList of all purposes for which contact is cc'ed
    CCContact
    object Contact truefalseCARBONCOPY_CCContactID 
    CCContactID
    id Contact truefalseCARBONCOPY_CCContactID 
    Contact
    object Contact truefalseCARBONCOPY_ContactID 
    ContactID
    id Contact truefalseCARBONCOPY_ContactID 


    Choice
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CHOICE_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ChoiceID
    integer   truefalseCHOICE_ChoiceIDPrimary Key
    ChoiceIndex
    integer   truefalseCHOICE_ChoiceIndexPrimary Key
    Description
    string255  truefalseCHOICE_Description 
    Locale
    string8  truefalseCHOICE_LocalePrimary Key
    OfficeID
    integer   truefalseCHOICE_OfficeIDPrimary Foreign Key -- Link to OFFICE table


    CommAdvCheck
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMADVCHECK_TABLEcommadvchecktruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CheckAmount
    double   truefalseCOMMADVCHECK_CheckAmountCheck Amount


    CommBand
    Referred By:
    CommRate.CommBands 
    Main TableData ObjectTopSearchReadonly
    COMMBANDING_TABLEcommbandstruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CommRateID
    integer   truefalseCOMMBANDING_COMMRATEIDForeign Key -- Link to COMMRATE table
    EffDate
    date   truefalseCOMMBANDING_EFTDATEEffective date: takes the current date
    ExpDate
    date   truefalseCOMMBANDING_EXPDATEExpiration date
    ModifiedOn
    datetime   truefalseCOMMBANDING_MODIFIEDON 
    ProductOptionOffID
    integer   truefalseCOMMBANDING_PRODUCTOPTIONOFFID 
    State
    lookup  StateCodetruefalseCOMMBANDING_STATEState banding choice field
    CommRateDetails
     CommRateDetail   
    ProductOptionID
    id ProductOptions truefalseCOMMBANDING_PRODUCTOPTIONID 
    ProductOptions
    object ProductOptions truefalseCOMMBANDING_PRODUCTOPTIONID 


    CommBatch
    Referred By:
    CommCarrierPay.BatchId  CommCarrierPay.Batch  CommReconcile.BatchID  CommReconcile.Batch 
    Main TableData ObjectTopSearchReadonly
    COMMBATCH_TABLEcommbatchtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AdjEntries
    byte  YesNofalsefalseCOMMBATCH_AdjEntriesBatch inculdes adjustment comm. entries?
    BatchDate
    date   falsefalseCOMMBATCH_BatchDateBatch Date
    Description
    string255  falsefalseCOMMBATCH_DescriptionBatch description
    IncludeLicenseCheck
    byte   falsefalseCOMMBATCH_IncludeLicenseCheck 
    IncludeSuspense
    integer   falsefalseCOMMBATCH_IncludeSuspenseBatch includes suspense items from previously processed with suspense batch
    MinCheckAmt
    byte  YesNofalsefalseCOMMBATCH_MinCheckAmtBatch includes comm. under min. check amount?
    ModifiedOn
    datetime   truefalseCOMMBATCH_ModifiedOn 
    Name
    string125  falsefalseCOMMBATCH_NameBatch name
    SendToJobQueue
    lookup  YesNofalsefalseCOMMBATCH_SendToJobQueue 
    Status
    lookup  CommBatchStatusfalsefalseCOMMBATCH_StatusBatch Status choice field
    StmtHeader
    string128  falsefalseCOMMBATCH_StmtHeaderCommission Statement Header and email Subject used when emailing statement to Advisor


    CommCarrierPay
    Referred By:
    CommImportData.CommCarrierPayID  CommReconcile.CarrierPay  CommReconcile.CarrierPayID 
    Main TableData ObjectTopSearchReadonly
    COMMCARRIERPAY_TABLEcarrierpostingtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentID
    integer   falsefalseCOMMCARRIERPAY_AGENTIDFK to Agent Contact Table
    CheckAmount
    double   falsefalseCOMMCARRIERPAY_CHECKAMTCheck or statement amount
    CheckDate
    date   falsefalseCOMMCARRIERPAY_CHECKDATEDate of check/statement received from carrier
    CheckNumber
    string40  falsefalseCOMMCARRIERPAY_CHECKNUMBERCheck number
    DepositDate
    date   falsefalseCOMMCARRIERPAY_DEPOSITDATE 
    Description
    string80  falsefalseCOMMCARRIERPAY_DESCRIPTIONCarrier Posting Description
    DiffAmount
    double   falsetrueCOMMCARRIERPAY_DIFFAMOUNT 
    DiffFromValidated
    double   falsetrueCOMMCARRIERPAY_DIFFFROMVALIDATEDDifference of TotalTransAmt. and PostedAmt.
    ModifiedOn
    datetime   truefalseCOMMCARRIERPAY_ModifiedOn 
    PostedAmount
    double   falsefalseCOMMCARRIERPAY_POSTEDAMTTotal amount posted
    PostedBY
    integer   falsefalseCOMMCARRIERPAY_POSTEDBYForeign Key -- Link to APPUSER table
    PostedOn
    date   falsefalseCOMMCARRIERPAY_POSTEDONDate payment was posted, takes the current date
    PostingName
    string255  falsetrueCOMMCARRIERPAY_PostingName 
    Status
    lookup  CommPostStatusfalsefalseCOMMCARRIERPAY_STATUSStatus choice field
    TotalTransAmount
    double   falsefalseCOMMCARRIERPAY_TOTALTRANSAMTCommission amt. total for all the commreconcile transaction records.
    Batch
    object CommBatch truefalseCOMMCARRIERPAY_BatchIdForeign Key -- Link to COMMBATCH table
    BatchId
    id CommBatch truefalseCOMMCARRIERPAY_BatchIdForeign Key -- Link to COMMBATCH table
    Agent
    object Contact truefalseCOMMCARRIERPAY_AGENTIDFK to Agent Contact Table
    AgentId
    id Contact truefalseCOMMCARRIERPAY_AGENTIDFK to Agent Contact Table
    User
    object User truefalseCOMMCARRIERPAY_POSTEDBYForeign Key -- Link to APPUSER table
    UserId
    id User truefalseCOMMCARRIERPAY_POSTEDBYForeign Key -- Link to APPUSER table
    Vendor
    object Vendor truefalseCOMMCARRIERPAY_VENDORIDForeign Key -- Link to VENDOR table
    VendorID
    id Vendor truefalseCOMMCARRIERPAY_VENDORIDForeign Key -- Link to VENDOR table


    CommExcess
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMEXCESS_TABLEcommexcesstruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CommRateDetailID
    integer   truefalseCOMMEXCESS_COMMRATEDETAILIDForeign Key -- Link to COMMRATEDETAIL table
    Commission
    double   truefalseCOMMEXCESS_COMMISSIONCommission percent
    PercOf
    lookup  AdvisorPercOftruefalseCOMMEXCESS_PERCOFCommisison percent of choice field
    TimesTarget
    integer   truefalseCOMMEXCESS_TIMESTARGETCommission paid by choice field


    CommHierarchy
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMHIERARCHY_TABLEcommhierarchytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentID
    integer   truefalseCOMMHIERARCHY_AGENTIDForeign Key -- Link to INTERESTPARTY table
    AgentOfficeID
    integer   truefalseCOMMHIERARCHY_AGENTOFFICEIDForeign Key -- Link to AGENT table
    CarrierContractID
    integer   truefalseCOMMHIERARCHY_CARRIERCONTRACTIDForeign Key -- Link to ADVCONTRACT table
    CarrierContractOfficeID
    integer   truefalseCOMMHIERARCHY_CARRIERCNTRCTOFFIDForeign Key -- Link to ADVCONTRACT table
    CarrierRateID
    integer   truefalseCOMMHIERARCHY_CARRIERRATEIDForeign Key -- Link to COMMRATE table
    CarrierRateOfficeID
    integer   truefalseCOMMHIERARCHY_CARRIERRATEOFFIDForeign Key -- Link to COMMRATE table
    CommAssignedTo
    integer   truefalseCOMMHIERARCHY_COMMASSIGNEDTOAgent ID but not a foreign key
    GAContractID
    integer   truefalseCOMMHIERARCHY_GACONTRACTIDForeign Key -- Link to ADVCONTRACT table
    GAContractOfficeID
    integer   truefalseCOMMHIERARCHY_GACONTRACTOFFICEIDForeign Key -- Link to ADVCONTRACT table
    GARateID
    integer   truefalseCOMMHIERARCHY_GARATEIDForeign Key -- Link to COMMRATE table
    GARateOfficeID
    integer   truefalseCOMMHIERARCHY_GARATEOFFICEIDForeign Key -- Link to COMMRATE table
    HierarchyID
    integer   truefalseCOMMHIERARCHY_HIERARCHYIDPrimary Key
    HierarchyLevel
    integer   truefalseCOMMHIERARCHY_HIERARCHYLEVELHierarchy level
    InterestPartyID
    integer   truefalseCOMMHIERARCHY_INTERESTPARTYIDForeign Key -- Link to INTERESTPARTY table
    InterestPartyOfficeID
    integer   truefalseCOMMHIERARCHY_INTERESTPARTYOFFIDForeign Key -- Link to AGENT table
    OfficeID
    integer   truefalseCOMMHIERARCHY_OFFICEIDPrimary Key


    CommImportData
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMIMPORTDATA_TABLEcommimportdatatruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActualCommission
    double   falsefalseCOMMIMPORTDATA_ACTUALCOMMISSION 
    AgentCarrierID
    string255  falsefalseCOMMIMPORTDATA_AGENTCARRIERID 
    AgentID
    string255  falsefalseCOMMIMPORTDATA_AGENTID 
    AgentTaxID
    string255  falsefalseCOMMIMPORTDATA_AGENTTAXID 
    CPValidationStatus
    lookup  CPValidationStatusfalsefalseCOMMIMPORTDATA_CPVALIDATIONSTATUS 
    CarrierName
    string200  falsefalseCOMMIMPORTDATA_CARRIERNAME 
    CommTypeText
    string64  falsefalseCOMMIMPORTDATA_COMMTYPETEXT 
    CommissionPercent
    double   truefalseCOMMIMPORTDATA_COMMPERCENT 
    CommissionType
    lookup  CommissionTypetruefalseCOMMIMPORTDATA_COMMISSIONTYPE 
    DueDate
    date   falsefalseCOMMIMPORTDATA_DUEDATE 
    EffectiveDate
    date   falsefalseCOMMIMPORTDATA_EFFECTIVEDATE 
    ExpectedCommission
    double   falsefalseCOMMIMPORTDATA_EXPECTEDCOMMISSION 
    ExpectedDueDate
    date   falsefalseCOMMIMPORTDATA_EXPECTEDDUEDATE 
    InsuredName
    string255  falsefalseCOMMIMPORTDATA_INSUREDNAME 
    ModalPremium
    double   falsefalseCOMMIMPORTDATA_MODALPREMIUM 
    PolicyNumber
    string40  falsefalseCOMMIMPORTDATA_POLICYNUMBER 
    PremiumModeText
    string255  falsefalseCOMMIMPORTDATA_PREMMODETEXT 
    PremiumPaid
    double   falsefalseCOMMIMPORTDATA_PREMIUMPAID 
    PremiumPaid2
    double   falsefalseCOMMIMPORTDATA_PREMIUMPAID2 
    PremiumPaid3
    double   falsefalseCOMMIMPORTDATA_PREMIUMPAID3 
    PremiumType
    string255  falsefalseCOMMIMPORTDATA_PREMIUMTYPE 
    ProductCode
    string30  falsefalseCOMMIMPORTDATA_PRODUCTCODE 
    Remark
    string512  falsefalseCOMMIMPORTDATA_REMARK 
    SplitPercent
    double   falsefalseCOMMIMPORTDATA_SPLITPERCENT 
    Status
    lookup  CommImportDataStatustruefalseCOMMIMPORTDATA_STATUS 
    WritingAdvisor
    string255  falsefalseCOMMIMPORTDATA_WRITINGADVISOR 
    CommCarrierPayID
    id CommCarrierPay truefalseCOMMIMPORTDATA_CARRIERPAYID 
    CommPostCheckID
    id CommPostCheck truefalseCOMMIMPORTDATA_COMMPOSTCHECKID 
    HoldingID
    id Position falsefalseCOMMIMPORTDATA_HOLDINGID 
    VendorID
    id Vendor truefalseCOMMIMPORTDATA_VENDORID 


    CommInvLoad
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMINVLOAD_TABLEinvcommloadtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription


    CommInvPosting
    Referred By:
    CommReconcile.INVPostingID  CommReconcile.INVPosting 
    Main TableData ObjectTopSearchReadonly
    COMMINVPOSTING_TABLE falsefalsefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription


    CommLoadHeader
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMLOADHEADER_TABLE falsefalsefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription


    CommLoadPay
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMLOAD_TABLEcommloadpaytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription


    CommMember
    Referred By:
    CommRateDetail.CommMembers 
    Main TableData ObjectTopSearchReadonly
    COMMMEMBERBAND_TABLEcommmemberbandtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CommRateDetailID
    integer   truefalseCOMMMEMBERBAND_CommRateDetailIdForeign Key -- Link to COMMRATEDETAIL table
    DollarAmtPerMember
    double   truefalseCOMMMEMBERBAND_DollarAmtPerMemberDollar amount per member in group policy
    UptoMembers
    integer   truefalseCOMMMEMBERBAND_UptoMembersCount for up to members in group policy


    CommPayable
    Referred By:
    RelatedContact.CommPayables  Contact.CommPayables 
    Main TableData ObjectTopSearchReadonly
    COMMPAYABLE_TABLEagentpaymentfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentCode
    string30  truefalseCOMMPAYABLE_AGENTCODECode for agent to whom comm. is paid.
    AgentName
    string255  truefalseCOMMPAYABLE_AGENTNAMEName of agent to whom comm. is paid
    AgentOfficeID
    integer   truefalseCOMMPAYABLE_AGENTOFFICEIDForeign Key -- Link to AGENT table
    CarrierActualPaid
    double   truefalseCOMMPAYABLE_CARRIERACTUALPAID 
    CarrierDirect
    double   truefalseCOMMPAYABLE_CARRIERDIRECTComm. amount paid by the carrier directly
    Category
    lookup  InsuranceOrInvestmentCommtruefalseCOMMPAYABLE_CATEGORYInsurance Or Investment Commission record?
    ChkPostedByBatchId
    integer   truefalseCOMMPAYABLE_ChkPostedByBatchIdFK link to the batch which has posted the check to which this commpayable contributes.
    CommAdvCheckID
    integer   truefalseCOMMPAYABLE_CommAdvCheckIDForeign Key -- Link to COMMADVCHECK table
    CommType
    lookup  CommissionTypetruefalseCOMMPAYABLE_COMMTYPEChoice field commission type
    CommpayableID
    integer   truetrueCOMMPAYABLE_COMMPAYABLEIDPrimary Key
    ComponentPrem
    double   truefalseCOMMPAYABLE_COMPONENTPREMPremium corresponding to this record's component
    CreatedOn
    datetime   truefalseCOMMPAYABLE_CREATEDONDate transaction was created
    CurrentLevel
    integer   truefalseCOMMPAYABLE_CURRENTLEVELHierarchy level of the advisor
    CurrentRole
    lookup  AgentRoletruefalseCOMMPAYABLE_CURRENTROLEAgent Role (supervisor/adv/ga) choice field
    DiffAmt
    double   truefalseCOMMPAYABLE_DIFFAMTDifference in amount receivable and paid amount
    FYRCommission
    lookup  CommissionYeartruefalseCOMMPAYABLE_FYRCOMMISSIONFirst year commission?
    InsuredName
    string255  truefalseCOMMPAYABLE_INSUREDNAMEName of the insured party
    InterestPartyID
    integer   truefalseCOMMPAYABLE_INTERESTPARTYID 
    InterestPercent
    double   truefalseCOMMPAYABLE_INTERESTPERCENT100% if not a split case, else % share
    Locked
    lookup  YesNotruefalseCOMMPAYABLE_Locked 
    ModifiedOn
    datetime   truefalseCOMMPAYABLE_MODIFIEDONDate of last modification to commpayable transaction
    PaidAmt
    double   truefalseCOMMPAYABLE_PAIDAMTCommission amount paid
    PaidBY
    lookup  CommPaidBytruefalseCOMMPAYABLE_PAIDBYCommision Paid by (Carrier/GA) choice field
    PaidDate
    date   truefalseCOMMPAYABLE_PAIDDATEDate commission payable paid
    PaidOn
    date   truefalseCOMMPAYABLE_PAIDONDate on which commission payment is made
    PayableDueDate
    date   truefalseCOMMPAYABLE_PAYABLEDUEDate commission payable due
    PayableTo
    integer   truefalseCOMMPAYABLE_PAYABLETOForeign Key -- Link to AGENT table
    PaymentType
    string32  truefalseCOMMPAYABLE_PAYMENTTYPE 
    PolicyNo
    string30  truefalseCOMMPAYABLE_POLICYNOPolicy number for which comm. is paid
    PremPaid
    double   truefalseCOMMPAYABLE_PREMPAIDPremium amount
    ProductName
    string64  truefalseCOMMPAYABLE_PRODUCTNAME 
    Receivable
    double   truefalseCOMMPAYABLE_RECEIVABLECommission amount receivable
    ReceivablePerc
    double   truefalseCOMMPAYABLE_RECEIVABLEPERCCommission amount in precentage
    ReceivablePercOf
    lookup  AdvisorPercOftruefalseCOMMPAYABLE_RECEIVABLEPERCOFComponent of which the commission amount is % of
    Status
    lookup  CommAdvPayStatustruefalseCOMMPAYABLE_STATUSPay Status (paid/on hold/etc.) choice field
    TransDate
    date   truefalseCOMMPAYABLE_TRANSDATE 
    TransType
    string32  truefalseCOMMPAYABLE_TRANSTYPE 
    WasCommassigned
    lookup  YesNotruefalseCOMMPAYABLE_WASCOMMASSIGNEDIndicator to check whether commission is assigned to another advisor
    YtdPrem
    double   truefalseCOMMPAYABLE_YTDPREMYear to date premium
    CommReconcile
    object CommReconcile truefalseCOMMPAYABLE_COMMRECONCILEIDForeign Key -- Link to COMMRECONCILE table
    CommReconcileId
    id CommReconcile truefalseCOMMPAYABLE_COMMRECONCILEIDForeign Key -- Link to COMMRECONCILE table
    AgentOnContract
    object Contact truefalseCOMMPAYABLE_AGENTONCONTRACTForeign Key -- Link to AGENT table
    AgentOnContractID
    id Contact truefalseCOMMPAYABLE_AGENTONCONTRACTForeign Key -- Link to AGENT table
    CommpayableAra
    object Contact truefalseCOMMPAYABLE_ARAForeign Key -- Link to AGENT table
    CommpayableAraID
    id Contact truefalseCOMMPAYABLE_ARAForeign Key -- Link to AGENT table
    Policy
    object Policy truefalseCOMMPAYABLE_HOLDINGIDForeign Key -- Link to HOLDING table
    PolicyID
    id Policy truefalseCOMMPAYABLE_HOLDINGIDForeign Key -- Link to HOLDING table
    CreatedBy
    object User falsefalseCOMMPAYABLE_CREATEDBYForeign Key -- Link to APPUSER table
    CreatedById
    id User truefalseCOMMPAYABLE_CREATEDBYForeign Key -- Link to APPUSER table
    ModifiedBy
    object User falsefalseCOMMPAYABLE_MODIFIEDBYForeign Key -- Link to APPUSER table
    ModifiedById
    id User truefalseCOMMPAYABLE_MODIFIEDBYForeign Key -- Link to APPUSER table
    Carrier
    object Vendor truefalseCOMMPAYABLE_CARRIERIDForeign Key -- Link to VENDOR table
    CarrierId
    id Vendor truefalseCOMMPAYABLE_CARRIERIDForeign Key -- Link to VENDOR table


    CommPolTran
    Referred By:
    CommReconcile.CommPolTranID  CommReconcile.CommPolTran 
    Main TableData ObjectTopSearchReadonly
    COMMPOLTRAN_TABLEcommpoltrantruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AlphaKey1
    string128 PolicyAlphaKey1truefalseCOMMPOLTRAN_ALPHANUMKEY1User Defined
    AlphaKey2
    string128 PolicyAlphaKey2truefalseCOMMPOLTRAN_ALPHANUMKEY2User Defined
    AplhaNum
    string128  truefalseCOMMPOLTRAN_ALPHANUMUser Defined
    CarrierPaidDate
    date   truefalseCOMMPOLTRAN_CARRIERPAIDDATEDate Commission Paid To Carrier
    CommPaidDate
    date   truefalseCOMMPOLTRAN_COMMPAIDDATECommission Paid Date
    CommissionType
    lookup  CommissionTypetruefalseCOMMPOLTRAN_COMMISSIONTYPEType Of Commission - Base,Flat Extra,Excess and LumpSum
    CommissionYear
    integer   truefalseCOMMPOLTRAN_COMMISSIONYEAR1,2,3..etc
    Date1
    date   truefalseCOMMPOLTRAN_Date1Customizable Date field 1
    DueDate
    date   truefalseCOMMPOLTRAN_DUEDATEActual Premium Due Date
    EndDate
    date   truefalseCOMMPOLTRAN_ENDDATEEnd date for comm. projection date range
    NetCarrierOf
    lookup  AdvisorPercOftruefalseCOMMPOLTRAN_NETPERCOFNet % Of Premium
    NetCarrierPer
    double   truefalseCOMMPOLTRAN_NETCARRIERPER% Amount defined by the User
    NetPerOf
    lookup  AdvisorPercOftruefalseCOMMPOLTRAN_NETPERCOFNet % Of Premium
    Netcommission
    byte   truefalseCOMMPOLTRAN_NETCOMMISSIONNet Commission CheckBox
    Num1
    double   truefalseCOMMPOLTRAN_Num1Customizable Numeric field 1
    Num2
    double   truefalseCOMMPOLTRAN_Num2Customizable Numeric field 2
    PaymentType
    lookup  PaymentMethodtruefalseCOMMPOLTRAN_PAYMENTTYPE 
    Premium
    double   truefalseCOMMPOLTRAN_PREMIUMPremium Amount
    PremiumMode
    lookup  PremModetruefalseCOMMPOLTRAN_PREMIUMMODE 
    SettleDate
    date   truefalseCOMMPOLTRAN_SETTLEDATEFund Settlement Date / Carrier Posting Date
    Status
    lookup  CommPolTranStatustruefalseCOMMPOLTRAN_STATUSError/Validation Status
    StatusDate
    date   truefalseCOMMPOLTRAN_STATUSDATE 
    TransactionDate
    date   truefalseCOMMPOLTRAN_TRANSACTIONDATETransaction Date
    TransactionNo
    string64  truefalseCOMMPOLTRAN_TRANSACTIONNO 
    TransactionType
    lookup  CommPolTranTypetruefalseCOMMPOLTRAN_TRANSACTIONTYPECash with application or Additional Premium
    Policy
    id Policy truefalseCOMMPOLTRAN_HOLDINGIDForeign Key - Link To Holding Table
    Product
    object Product truefalseCOMMPOLTRAN_PRODUCTIDForeign Key - Link to PRODUCT TABLE
    ProductId
    id Product truefalseCOMMPOLTRAN_PRODUCTIDForeign Key - Link to PRODUCT TABLE


    CommPostCheck
    Referred By:
    CommImportData.CommPostCheckID 
    Main TableData ObjectTopSearchReadonly
    COMMPOSTCHECK_TABLEcommpostchecktruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CarrierName
    string200  truefalseCOMMPOSTCHECK_CARRIERNAME 
    CheckAmount
    double   falsefalseCOMMPOSTCHECK_CHECKAMOUNT 
    CheckDate
    date   falsefalseCOMMPOSTCHECK_CHECKDATE 
    CheckNumber
    string40  falsefalseCOMMPOSTCHECK_CHECKNUMBER 
    DepositDate
    date   falsefalseCOMMPOSTCHECK_DEPOSITDATE 
    PostedAmount
    double   falsefalseCOMMPOSTCHECK_POSTEDAMOUNT 
    PostedOn
    datetime   falsefalseCOMMPOSTCHECK_POSTEDON 
    Remark
    string256  falsefalseCOMMPOSTCHECK_REMARK 
    Status
    lookup  CommPostCheckStatustruefalseCOMMPOSTCHECK_STATUS 
    TotalTransAmt
    double   falsefalseCOMMPOSTCHECK_TOTALTRANSAMTCommission amt. total for all the commimportdata transaction records.
    PostedBy
    object User falsefalseCOMMPOSTCHECK_POSTEDBYID 
    PostedByID
    id User truefalseCOMMPOSTCHECK_POSTEDBYID 


    CommRate
    Referred By:
    Contract.CommRates 
    Main TableData ObjectTopSearchReadonly
    COMMRATE_TABLEcommratetruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CumulativeRate
    byte   falsefalseCOMMRATE_CUMULATIVERATEIs rate cumulative?
    Description
    string255  truefalseCOMMRATE_DESCRIPTIONRate Description
    ModifiedOn
    datetime   truefalseCOMMRATE_MODIFIEDON 
    UseComplex
    lookup  CommBandTypetruefalseCOMMRATE_USECOMPLEXPremium/Excess/Member Banding choice field
    CommBands
     CommBand   
    CarrierID
    id ContactVendor truefalseCOMMRATE_CARRIERIDForeign Key - Link to VENDOR table
    ContractID
    id Contract truefalseCOMMRATE_CONTRACTIDForeign Key - Link to CONTRACT table
    ProductID
    id Product truefalseCOMMRATE_PRODUCTIDForeign Key -- Link to PRODUCT table


    CommRateDetail
    Referred By:
    CommBand.CommRateDetails 
    Main TableData ObjectTopSearchReadonly
    COMMRATEDETAIL_TABLEcommratedetailtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CommBandID
    integer   truefalseCOMMRATEDETAIL_COMMBANDINGIDForeign Key -- Link to COMMBANDING table
    FromYear
    integer   truefalseCOMMRATEDETAIL_FROMYEARBeginning year for commission rates
    ModifiedOn
    datetime   truefalseCOMMRATEDETAIL_MODIFIEDON 
    ThruYear
    integer   truefalseCOMMRATEDETAIL_THRUYEAREnding year for commission rates
    CommMembers
     CommMember   
    CommSchedules
     CommSchedule   


    CommReconcile
    Referred By:
    CommPayable.CommReconcileId  CommPayable.CommReconcile 
    Main TableData ObjectTopSearchReadonly
    COMMRECONCILE_TABLEreceivabletruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AccountNumber
    string32  falsefalseCOMMRECONCILE_ACCOUNTNUMBER 
    AccumulatedPrem
    double   falsefalseCOMMRECONCILE_ACCUMULATEDPREMPremium accumulated until date
    ActualAmount
    double   falsefalseCOMMRECONCILE_ACTUALAMTActual commission amount received
    ActualPremPaid
    double   falsefalseCOMMRECONCILE_ACTUALPREMPAIDPremium paid from SRE or Carrier Posting.
    AgencyContractNo
    string256  falsefalseCOMMRECONCILE_AGENCYCONTRACTNOAdvisor Contract Number
    Category
    lookup  InsuranceOrInvestmentCommfalsefalseCOMMRECONCILE_CATEGORYInsurance Or Investment Commission record?
    CommType
    lookup  CommissionTypefalsefalseCOMMRECONCILE_COMMTYPECommission type choice field
    CommissionPREM
    double   falsefalseCOMMRECONCILE_COMMISSIONPREMIUM 
    CommissionYear
    integer   falsefalseCOMMRECONCILE_CommissionYearCommission year for which the commission was generated.
    CompPrem
    double   falsefalseCOMMRECONCILE_COMPONENTPREMAmount of commissionable base premium
    CreatedOn
    datetime   falsefalseCOMMRECONCILE_CREATEDONDate transaction was created
    DeferredAmount
    double   falsefalseCOMMRECONCILE_DEFERREDAMT 
    DiffAmount
    double   falsefalseCOMMRECONCILE_DIFFAMTDifference = Expected - Direct - Actual
    DirectAmount
    double   falsefalseCOMMRECONCILE_DIRECTAMTAmount paid directly to advisors by carrier
    DueDate
    date   falsefalseCOMMRECONCILE_DUEDATECommission receivable due date
    ExcessPrem
    double   falsefalseCOMMRECONCILE_EXCESSPREMAmount of excess premium
    ExpectedAmount
    double   falsefalseCOMMRECONCILE_EXPECTEDAMTExpected commission receivable amount
    ExpectedPer
    double   falsefalseCOMMRECONCILE_EXPECTEDPERCCommission amount in terms of %
    ExpectedPerOf
    lookup  AdvisorPercOffalsefalseCOMMRECONCILE_EXPECTEDPERCOFComp. whose % is commision amt. choice field
    FYRCommission
    lookup  CommissionYearfalsefalseCOMMRECONCILE_FYRCOMMISSIONFirst year commission?
    FromLiecnseCheck
    lookup  YesNofalsefalseCOMMRECONCILE_FROMLIECNSECHECKIndicator to identify whether this record had failed due to Lic/Cont/Appt check
    GrossInvestment
    double   falsefalseCOMMRECONCILE_GROSSINVESTMENT 
    GroupingNumber
    integer   falsefalseCOMMRECONCILE_GROUPINGNOGroups all the commissions on one due date
    InvestmentCurrency
    string32  falsefalseCOMMRECONCILE_INVESTMENTCURRENCY 
    InvestmentPlatform
    lookup  CommInvPlatformfalsefalseCOMMRECONCILE_INVESTMENTPLATFORM 
    InvestorName
    string64  falsefalseCOMMRECONCILE_INVESTORNAME 
    Locked
    lookup  YesNofalsefalseCOMMRECONCILE_Locked 
    ModifiedOn
    datetime   truefalseCOMMRECONCILE_MODIFIEDONDate of last modification to commrecocile transaction
    NetExptAmount
    double   falsefalseCOMMRECONCILE_NETEXPTAMTNet commission amount expected for GA
    NextDueDate
    date   falsefalseCOMMRECONCILE_NEXTDUEDATENext commission due date
    NumberOfMonth
    integer   falsefalseCOMMRECONCILE_NOOFMONTHNo. of months for which the premium was paid
    OriginalNetExptAmount
    double   falsefalseCOMMRECONCILE_ORIGINALNETEXPTAMT 
    PaidBY
    lookup  CommPaidByfalsefalseCOMMRECONCILE_PAIDBYPaid by Carrier/GA choice field
    PaymentType
    string32  falsefalseCOMMRECONCILE_PAYMENTTYPE 
    PolicyDate
    date   falsefalseCOMMRECONCILE_POLICYDATEPolicy date
    PremPaid
    double   falsefalseCOMMRECONCILE_PREMPAIDAmount of premium paid
    ProductName
    string64  falsefalseCOMMRECONCILE_PRODUCTNAME 
    Remarks
    string255  falsefalseCOMMRECONCILE_REMARKSRemarks
    RiderCommission
    byte  YesNofalsefalseCOMMRECONCILE_RIDERCOMMISSIONCommission receivable is for rider?
    RiderName
    string128  falsefalseCOMMRECONCILE_RIDERNAME 
    SettleDate
    date   falsefalseCOMMRECONCILE_SETTLEDATE 
    SplitPercnt
    double   falsefalseCOMMRECONCILE_SplitPercntSplit Percentage for the Advisor (Column is basically used for CTM Light calculations)
    Status
    lookup  CommPostStatusfalsefalseCOMMRECONCILE_STATUSStatus choice field
    TransDate
    date   falsefalseCOMMRECONCILE_TRANSDATE 
    TransType
    string32  falsefalseCOMMRECONCILE_TRANSTYPE 
    WriteofAmount
    double   falsefalseCOMMRECONCILE_WRITEOFFAMTDifference between paid and receivable
    YTDPremPaid
    double   falsefalseCOMMRECONCILE_YTDPREMPAIDYear to date premium paid
    Agent
    object Agent truefalseCOMMRECONCILE_ARAIDARA ID
    AgentID
    id Agent truefalseCOMMRECONCILE_ARAIDARA ID
    Batch
    object CommBatch truefalseCOMMRECONCILE_BatchIdForeign Key -- Link to COMMBATCH table
    BatchID
    id CommBatch truefalseCOMMRECONCILE_BatchIdForeign Key -- Link to COMMBATCH table
    CarrierPay
    object CommCarrierPay truefalseCOMMRECONCILE_CARRIERPAYIDForeign Key -- Link to COMMCARRIERPAY table
    CarrierPayID
    id CommCarrierPay truefalseCOMMRECONCILE_CARRIERPAYIDForeign Key -- Link to COMMCARRIERPAY table
    INVPosting
    object CommInvPosting truefalseCOMMRECONCILE_INVPOSTINGID 
    INVPostingID
    id CommInvPosting truefalseCOMMRECONCILE_INVPOSTINGID 
    CommPolTran
    object CommPolTran truefalseCOMMRECONCILE_COMMPOLTRANID 
    CommPolTranID
    id CommPolTran truefalseCOMMRECONCILE_COMMPOLTRANID 
    Position
    id Position truefalseCOMMRECONCILE_HOLDINGIDForeign Key -- Link to HOLDING table
    PositionID
    id Position truefalseCOMMRECONCILE_HOLDINGIDForeign Key -- Link to HOLDING table
    Product
    id Product truefalseCOMMRECONCILE_PRODUCTIDForeign Key -- Link to PRODUCT table
    ProductID
    id Product truefalseCOMMRECONCILE_PRODUCTIDForeign Key -- Link to PRODUCT table
    Rider
    id Rider truefalseCOMMRECONCILE_RIDERIDForeign Key -- Link to RIDER table
    RiderID
    id Rider truefalseCOMMRECONCILE_RIDERIDForeign Key -- Link to RIDER table
    CreatedBy
    object User falsefalseCOMMRECONCILE_CREATEDBYForeign Key -- Link to APPUSER table
    CreatedByID
    id User truefalseCOMMRECONCILE_CREATEDBYForeign Key -- Link to APPUSER table
    ModifiedBy
    object User truefalseCOMMRECONCILE_MODIFIEDBYForeign Key -- Link to APPUSER table
    VendorID
    id Vendor truefalseCOMMRECONCILE_VENDORIDForeign Key -- Link to VENDOR table


    CommSchedule
    Referred By:
    CommRateDetail.CommSchedules 
    Main TableData ObjectTopSearchReadonly
    COMMPREMBAND_TABLEcommprembandtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    BasePercentage
    double   truefalseCOMMPREMBAND_BASECOMMBase commission percentage
    CommRateDetailID
    integer   truefalseCOMMPREMBAND_COMMRATEDETAILIDForeign Key -- Link to COMMRATEDETAIL table
    DollarComm
    double   truefalseCOMMPREMBAND_DOLLARCOMMFlat dollar amount per premium mode
    ModifiedOn
    datetime   truefalseCOMMPREMBAND_MODIFIEDON 
    UpToPremium
    double   truefalseCOMMPREMBAND_UPTOPREMIUMUp to premium amount


    Contact
    Referred By:
    User.ContactID  User.Contact  VenSerProvider.ServiceProviderId  VenSerProvider.ServiceProvider  ActivityHistory.Contact  ActivityHistory.ContactID  Image.ContactID  AcctMaster.ContactID  AcctMaster.Contact  RiskAssignment.Contact  RiskAssignment.ContactID  CommCarrierPay.Agent  CommCarrierPay.AgentId  ContactBus.Business  ContactBus.Contact  ContactBus.BusinessID  ContactBus.ContactID  EventInvitee.ContactID  AgentContact.ReferredByObj  AgentContact.ReferredById  ActivityContact.Contact  ActivityContact.ContactID  SmartPad.ContactID  SmartPad.Contact  ProposalTracking.PrimaryAgent  ProposalTracking.PrimaryAgentID  ProposalTracking.PrimaryOwnerID  ProposalTracking.PrimaryInsuredID  ProposalTracking.PrimaryInsured  ProposalTracking.PrimaryOwner  Rider.Contact  InterestParty.ContactID  InterestParty.Contact  HORep.Contact  GroupParticipant.ContactID  ContactExtLink.ContactId  Agent.SupervisorID  Agent.ContactID  Agent.Contact  Agent.PrimaryContactID  Agent.Supervisor  Agent.PrimaryContact  UnderReq.ServiceProvider  UnderReq.ServiceProviderID  LUTaxID.Contact  LUTaxID.ContactID  Phone.Contact  Phone.ContactID  NewBusiness.ContactID  NewBusiness.Contact  Opportunity.ContactID  Opportunity.Contact  CarbonCopy.CCContact  CarbonCopy.Contact  CarbonCopy.ContactID  CarbonCopy.CCContactID  Liability.ContactID  Liability.Contact  Position.ContactID  Position.Contact  ContactBenefit.ContactID  PolSubAccount.ContactID  PolSubAccount.Contact  Service.Contact  HouseHoldMember.Contact  HouseHoldMember.ContactID  SmartMailLink.ContactId  SmartPadArchive.ContactID  Activity.ContactID  Activity.Contact  Policy.PrimaryAdvisor  Policy.ContactID  Policy.PrimaryAdvisorID  Policy.Contact  WebAddress.Contact  WebAddress.ContactID  CtmSetup.HouseId  UnderWriter.Contact  SetMember.Contact  SetMember.ContactID  Address.Contact  Address.ContactID  HOContact.ContactID  AgentRequest.Agent  AgentRequest.AgentID  Person.BusinessID  Person.ContactID  Person.Business  PolicyClaim.PolicyInsured  PolicyClaim.PolicyInsuredID  CorrTransaction.ContactID  CorrTransaction.Contact  GroupCensus.BusinessID  GroupCensus.ContactID  GroupCensus.Business  GroupCensus.Contact  Requirement.ContactID  Requirement.Contact  HouseHold.Contact  HouseHold.ContactID  Product.FullContactID  Business.PrimaryContact  AdvContract.ManagerId  AdvContract.CommAssigned  AdvContract.CommAssignedTo  AdvContract.ManagerObj  AgentInterestParty.Contact  AgentInterestParty.ContactID  DeletedGroupCensus.Contact  DeletedGroupCensus.ContactID  AcctMasterContact.Contact  AcctMasterContact.ContactID  Assignment.Contact  Assignment.ContactID  PrnContact.Contact  PrnContact.ContactID  BrokerDealer.ContactId  Relation.RelatedToID  Relation.RelatedTo  Relation.Contact  Relation.ContactID  LetterContact.ContactID  Contact.PrimaryAgent  Contact.PrimaryAgentID  Contact.ReferredById  Contact.ReferredByObj  AgentLicense.Contact  AgentLicense.AgentID  Vendor.Contact  Vendor.ContactID  CommPayable.AgentOnContractID  CommPayable.CommpayableAra  CommPayable.AgentOnContract  CommPayable.CommpayableAraID  LUHOClientID.Contact  LUHOClientID.ContactID 
    Main TableData ObjectTopSearchReadonly
    CONTACT_TABLEcontacttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActivityOutcomes
    string1023  falsetrueCONTACT_ActivityOutcomes 
    AlphaKey
    string40 ContactAlphaKeytruefalseCONTACT_AlphakeyAvailable alphanumeric field
    AlphaNum1
    string40 ContactCustomAlphanum1truefalseCONTACT_ALPHANUM1Customizable alphanumeric field #1
    AlphaNum2
    string40 ContactCustomAlphanum2truefalseCONTACT_ALPHANUM2Customizable alphanumeric field #2
    AppointmentsMade
    integer   falsetrueCONTACT_AppointmentsMade 
    CallsMade
    integer   falsetrueCONTACT_CallsMade 
    Category
    string128 ContactTypetruefalseCONTACT_ContactTypeCategoryContact type category
    ClientType
    lookup  SubTypelookuptruefalseCONTACT_ContactTypeType of contact
    ClientTypeText
    string128 ContactTypetruefalseCONTACT_ContactTypeCategoryContact type category
    ContactSubType
    string15 SubTypetruefalseCONTACT_SubTypeSub type
    ContactType
    lookup  RecordTypetruefalseCONTACT_RecordTypeRecord type
    ContactTypeText
    lookuptext   falsetrueCONTACT_RecordTypeText 
    CreatedOn
    datetime   truefalseCONTACT_CreatedOnDate contact was created
    EMailPrivacy
    lookup  YesNotruefalseCONTACT_EMailPrivacyEmail privacy yes/no field
    EmployerName
    string128  truefalseCONTACT_EmployerEmployer name
    FirstMiddleLastName
    string320  falsetrueCONTACT_FirstMiddleLastName 
    FirstName
    string64  truefalseCONTACT_FirstNameFirst name
    FullName
    string440  falsetrueCONTACT_FullName 
    Greeting
    string40  truefalseCONTACT_GreetingGreeting or nickname
    HOID
    string50  truefalseCONTACT_HOClientIDHome office unique client ID
    LastComplActOn
    datetime   falsetrueCONTACT_LastComplActOn 
    LastName
    string200  truefalseCONTACT_LastNameLast name
    LatestActivityNotes
    string1023  falsetrueCONTACT_LatestActivityNotes 
    MailPrivacy
    lookup  YesNotruefalseCONTACT_PostalMailPrivacyPostal mail privact yes/no field
    MiddleName
    string40  truefalseCONTACT_MiddleNameMiddle name or initial
    ModifiedOn
    datetime   truefalseCONTACT_ModifiedOnDate of last modification to contact record
    NPN
    string10  truefalseCONTACT_NPN 
    Name
    string320  falsetrueCONTACT_Name 
    NextActivityOn
    datetime   falsetrueCONTACT_NextActivityOn 
    PhonePrivacy
    lookup  YesNofalsefalseCONTACT_PhonePrivacyPhone privacy yes/no field
    PreferedComm
    lookup  PreferredCommlookupfalsefalseCONTACT_PreferedCommPreferred communication method
    Private
    lookup  YesNotruefalseCONTACT_PrivateIdentifies the record as a private record
    ReferentName
    string360  truefalseCONTACT_ReferentNameNominator
    Remark
    string4000  falsefalseCONTACT_RemarkRemarks
    ReviewDate
    date   falsefalseCONTACT_ReviewDateReview date
    SmsPrivacy
    lookup  YesNotruefalseCONTACT_SmsPrivacy 
    Source
    string64 ContactSourcetruefalseCONTACT_SourceSource of contact
    SourceApp
    lookup  SourceApp_NametruefalseCONTACT_SOURCEAPPSource Application Name.
    SourceOfData
    lookup  SourceOfDatatruefalseCONTACT_SourceOfDataAcitivity Date of the Oldest Activity linked to this contact having Sub-Type of "Initial"
    SubSource
    string50 ContactSubSourcetruefalseCONTACT_SubSourceSub source
    Suffix
    string40 SuffixtruefalseCONTACT_SuffixSuffix
    TaxID
    string20  truefalseCONTACT_TaxIDTax ID # or SSN
    Territory
    string255 TerritoryfalsefalseCONTACT_TerritoryTerritory
    Title
    string40 TitlefalsefalseCONTACT_ContactTitleTitle
    Type
    string128 ContactTypetruefalseCONTACT_ContactTypeCategoryContact type category
    AcctMasters
     AcctMaster   
    Trusts
     AcctMaster   
    Activities
     Activity   
    Addresses
     Address   
    BillingAddress
     Address   
    EmployerAddress
    object Address falsefalseCONTACT_DefBusAddrIDForeign Key -- Link to ADDRESS table
    PreferredAddress
    object Address falsefalseCONTACT_PreferredAddrIDPreferred address yes/no field
    ResidenceAddress
    object Address falsefalseCONTACT_DefResAddrIDForeign Key -- Link to ADDRESS table
    Agent
     Agent   
    Assignments
     Assignment   
    Business
     Business   
    CommPayables
     CommPayable   
    PrimaryAgent
    object Contact falsefalseCONTACT_PrimaryAgentForeign Key -- Link to CONTACT table
    PrimaryAgentID
    id Contact falsefalseCONTACT_PrimaryAgentForeign Key -- Link to CONTACT table
    ReferredById
    id Contact truefalseCONTACT_ReferredByForeign Key -- Link to CONTACT table
    ReferredByObj
    object Contact truefalseCONTACT_ReferredByForeign Key -- Link to CONTACT table
    ContactBenefit
     ContactBenefit   
    ContactBuses
     ContactBus   
    ContactBusiness
     ContactBus   
     ContactExtLink   
    CustomData
     CustomData   
    BusEmployeeCensus
     GroupCensus   
    EmployeeCensus
     GroupCensus   
    HouseHold
    object HouseHold falsefalsePERSONAL_PrimaryHouseHoldIDForeign Key -- Link to HOUSEHOLD table
    HouseHolds
     HouseHold   
    HouseHoldMembers
     HouseHoldMember   
    Image
    object Image falsefalseCONTACT_PhotoID 
    PhotoID
    id Image falsefalseCONTACT_PhotoID 
    Liabilities
     Liability   
    LUHOClientID
     LUHOClientID   
    LUTaxID
     LUTaxID   
    NewBusinesses
     NewBusiness   
    Office
    object Office truefalseCONTACT_OfficeIDPrimary Foreign Key -- Link to OFFICE table
    Person
     Person   
    BusinessFax
     Phone   
    BusinessPhone
    object Phone falsefalseCONTACT_DefBusPhoneIDForeign Key -- Link to PHONE table
    Faxes
     Phone   
    HomeFax
     Phone   
    MobilePhone
     Phone   
    Phones
     Phone   
    PreferredPhone
    object Phone falsefalseCONTACT_PreferredPhoneIDForeign Key -- Link to PHONE table
    ResidencePhone
    object Phone falsefalseCONTACT_DefResPhoneIDForeign Key -- Link to PHONE table
    AgentPolicies
     Policy   
    Policies
     Policy   
    BankAccts
     Position   
    Relations
     Relation   
    SpouseRelation
     Relation   
    PCMSmartPads
     SmartPad   
    SmartPads
     SmartPad   
    CreatedBy
    object User falsefalseCONTACT_CreatedByForeign Key -- Link to APPUSER table
    ModifiedBy
    object User truefalseCONTACT_ModifiedByForeign Key -- Link to APPUSER table
    ModifiedByID
    id User truefalseCONTACT_ModifiedByForeign Key -- Link to APPUSER table
    Vendor
     Vendor   
    PreferredEmailAddress
     WebAddress   
    PreferredWebAddress
     WebAddress   
    WebAddresses
     WebAddress   
    Websites
     WebAddress   


    ContactBenefit
    Referred By:
    RelatedContact.ContactBenefit  Contact.ContactBenefit 
    Main TableData ObjectTopSearchReadonly
    CONTACTBENEFIT_TABLEcontactfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AnnBen
    double   falsefalseCONTACTBENEFIT_AnnBenTotal field: annual benefit
    AnnNo
    integer   falsefalseCONTACTBENEFIT_AnnNoTotal number of annual policies
    AnnPrem
    double   falsefalseCONTACTBENEFIT_AnnPremTotal field: annual premiums
    AutoNo
    integer   falsefalseCONTACTBENEFIT_AutoNoTotal number of Auto policies
    AutoPrem
    double   falsefalseCONTACTBENEFIT_AutoPremTotal field: Auto policy premiums
    BankCost
    double   falsefalseCONTACTBENEFIT_BankCostTotal field: total orig. capital of bank accts.
    BankValue
    double   falsefalseCONTACTBENEFIT_BankValueTotal field: total values of all bank accounts
    BondCost
    double   falsefalseCONTACTBENEFIT_BondCostTotal field: cost of bonds
    BondValue
    double   falsefalseCONTACTBENEFIT_BondValueTotal field: value of bonds
    CTDCost
    double   falsefalseCONTACTBENEFIT_CTDCostTotal field: cost of CTDs
    CTDValue
    double   falsefalseCONTACTBENEFIT_CTDValueTotal field: value of CTDs
    CrtIllBen
    double   falsefalseCONTACTBENEFIT_CrtIllBenTotal field: Critical Illness policy benefit
    CrtIllPrem
    double   falsefalseCONTACTBENEFIT_CrtIllPremTotal field: Critical Illness policy premiums
    DPPCost
    double   falsefalseCONTACTBENEFIT_DPPCostTotal field: cost of DPPs
    DPPValue
    double   falsefalseCONTACTBENEFIT_DPPValueTotal field: value of DPPs
    DiBen
    double   falsefalseCONTACTBENEFIT_DiBenTotal field: DI policy benefit
    DiNo
    integer   falsefalseCONTACTBENEFIT_DiNoTotal number of DI policies
    DiPrem
    double   falsefalseCONTACTBENEFIT_DiPremTotal field: DI policy premiums
    FaCost
    double   falsefalseCONTACTBENEFIT_FaCostTotal field: fixed annuity cost
    FaValue
    double   falsefalseCONTACTBENEFIT_FaValueTotal field: fixed annuity current value
    HomeNo
    integer   falsefalseCONTACTBENEFIT_HomeNoTotal number of Home policies
    HomePrem
    double   falsefalseCONTACTBENEFIT_HomePremTotal field: Home policy premiums
    InvCost
    double   falsefalseCONTACTBENEFIT_InvCostTotal field: total investment cost
    InvValue
    double   falsefalseCONTACTBENEFIT_InvValueTotal field: total investment current value
    LifeBen
    double   falsefalseCONTACTBENEFIT_LifeBenTotal field: Life policy benefit
    LifeCSV
    double   falsefalseCONTACTBENEFIT_LifeCSVTotal field: Life CSV (Cash Surrender Value)
    LifeNo
    integer   falsefalseCONTACTBENEFIT_LifeNoTotal number of Life policies
    LifePrem
    double   falsefalseCONTACTBENEFIT_LifePremTotal field: Life policy premiums
    LtcNo
    integer   falsefalseCONTACTBENEFIT_LtcNoTotal number of LTC policies
    LtcPrem
    double   falsefalseCONTACTBENEFIT_LtcPremTotal field: LTC policy premiums
    MISCCost
    double   falsefalseCONTACTBENEFIT_MISCCostTotal field: total miscellaneous cost
    MISCValue
    double   falsefalseCONTACTBENEFIT_MISCValueTotal field: total miscellaneous value
    MedBen
    double   falsefalseCONTACTBENEFIT_MedBenTotal field: Medical policy benefit
    MedNo
    integer   falsefalseCONTACTBENEFIT_MedNoTotal number of Medical policies
    MedPrem
    double   falsefalseCONTACTBENEFIT_MedPremTotal field: Medical policy premiums
    MfCost
    double   falsefalseCONTACTBENEFIT_MfCostTotal field: mutual fund cost
    MfValue
    double   falsefalseCONTACTBENEFIT_MfValueTotal field: mutual fund value
    ModifiedOn
    datetime   falsefalseCONTACTBENEFIT_ModifiedOnTimestamp synchronization
    NRCost
    double   falsefalseCONTACTBENEFIT_NRCostTotal field: total NR cost
    NRValue
    double   falsefalseCONTACTBENEFIT_NRValueTotal field: total NR value
    NetEquity
    double   falsefalseCONTACTBENEFIT_NetEquityNet equity
    OTHERDebt
    double   falsefalseCONTACTBENEFIT_OTHERDebtOther Debt
    OfficeID
    integer   falsefalseCONTACTBENEFIT_OfficeIDPrimary Key
    OtherNo
    integer   falsefalseCONTACTBENEFIT_OtherNoTotal number of other policies
    OtherPrem
    double   falsefalseCONTACTBENEFIT_OtherPremTotal field: other policy premiums
    PPCost
    double   falsefalseCONTACTBENEFIT_PPCostTotal field: total cost of all PPs
    PPValue
    double   falsefalseCONTACTBENEFIT_PPValueTotal field: total values of all PPs
    PermBen
    double   falsefalseCONTACTBENEFIT_PermBenTotal field: Permanent Life policy benefit
    PermNo
    integer   falsefalseCONTACTBENEFIT_PermNoTotal number of Permanent Life policies
    PermPrem
    double   falsefalseCONTACTBENEFIT_PermPremTotal field: Permanent Life policy premiums
    PolPrem
    double   falsefalseCONTACTBENEFIT_PolPremTotal field: policy premiums
    RECost
    double   falsefalseCONTACTBENEFIT_RECostTotal field: real estate cost
    REDebt
    double   falsefalseCONTACTBENEFIT_REDebtTotal field: real estate debt
    REValue
    double   falsefalseCONTACTBENEFIT_REValueTotal field: total real estate value
    StockCost
    double   falsefalseCONTACTBENEFIT_StockCostTotal field: stocks cost
    StockValue
    double   falsefalseCONTACTBENEFIT_StockValueTotal field: stocks current value
    TermBen
    double   falsefalseCONTACTBENEFIT_TermBenTotal field: Term Life benefit amount
    TermNo
    integer   falsefalseCONTACTBENEFIT_TermNoTotal number of Term Life policies
    TermPrem
    double   falsefalseCONTACTBENEFIT_TermPremTotal field: Term Life policy premiums
    ULBen
    double   falsefalseCONTACTBENEFIT_ULBenTotal field: UL policies benefit
    ULNo
    integer   falsefalseCONTACTBENEFIT_ULNoTotal number of UL policies
    ULPrem
    double   falsefalseCONTACTBENEFIT_ULPremTotal field: UL policy premiums
    UTCost
    double   falsefalseCONTACTBENEFIT_UTCostTotal cost of all Umbrella policies
    UTValue
    double   falsefalseCONTACTBENEFIT_UTValueTotal value of all Umbrella policies
    UmbrellaNo
    integer   falsefalseCONTACTBENEFIT_UmbrellaNoTotal number of Umbrella policies
    UmbrellaPrem
    double   falsefalseCONTACTBENEFIT_UmbrellaPremTotal field: Umbrella policy premiums
    UnmanagedAsset
    double   falsefalseCONTACTBENEFIT_UnmanagedAssetUnmanaged assets
    UnmanagedLiability
    double   falsefalseCONTACTBENEFIT_UnmanagedLiabilityUnmanaged Liability
    VaCost
    double   falsefalseCONTACTBENEFIT_VaCostTotal field: variable annuity cost
    VaValue
    double   falsefalseCONTACTBENEFIT_VaValueTotal field: variable annuity current value
    ValidateDate
    datetime   falsefalseCONTACTBENEFIT_ValidateDateValidation date
    ContactID
    id Contact falsefalseCONTACTBENEFIT_ContactIDPrimary Foreign Key -- Link to CONTACT table


    ContactBus
    Referred By:
    RelatedContact.ContactBusiness  RelatedContact.ContactBuses  Contact.ContactBusiness  Contact.ContactBuses 
    Main TableData ObjectTopSearchReadonly
    CONTACTBUS_TABLEcontactbustruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Role
    lookup  RolestruefalseCONTACTBUS_RoleRole of contact
    RoleText
    lookuptext   falsetrueCONTACTBUS_RoleText 
    Business
    object Contact falsefalseCONTACTBUS_BusinessIDForeign Key -- Link to BUSINESS table
    BusinessID
    id Contact falsefalseCONTACTBUS_BusinessIDForeign Key -- Link to BUSINESS table
    Contact
    object Contact falsefalseCONTACTBUS_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact falsefalseCONTACTBUS_ContactIDForeign Key -- Link to CONTACT table


    ContactExtLink
    Referred By:
    Contact.ContactExtLinks 
    Main TableData ObjectTopSearchReadonly
    CONTACTEXTLINK_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CreatedByOfficeId
    integer   truefalseCONTACTEXTLINK_CreatedByOfficeId 
    CreatedByText
    string60  truetrueCONTACTEXTLINK_CreatedByText 
    CreatedOn
    datetime   truefalseCONTACTEXTLINK_CreatedOn 
    ExtLinkContactId
    string255  falsefalseCONTACTEXTLINK_ExtLinkContactID 
    ExtLinkSource
    string255  truefalseCONTACTEXTLINK_ExtLinkSource 
    ModifiedByOfficeId
    integer   falsefalseCONTACTEXTLINK_ModifiedByOfficeId 
    ModifiedByText
    string60  truetrueCONTACTEXTLINK_ModifiedByText 
    ModifiedOn
    datetime   truefalseCONTACTEXTLINK_ModifiedOn 
    OfficeId
    integer   falsefalseCONTACTEXTLINK_OfficeID 
    ContactId
    id Contact truefalseCONTACTEXTLINK_ContactID 
    CreatedById
    id User truefalseCONTACTEXTLINK_CreatedById 
    ModifiedById
    id User falsefalseCONTACTEXTLINK_ModifiedById 


    ContactVendor
    Referred By:
    SecurityMaster.VendorContact  SecurityMaster.VendorContactID  ProdSubAccount.VendorContact  ProdSubAccount.VendorContactID  BusinessVendor.PrimaryContactID  Illustration.CarrierID  Illustration.Carrier  ProposalTracking.Carrier  ProposalTracking.CarrierID  Contract.CarrierID  Contract.Vendor  Policy.CarrierID  Policy.Carrier  AgentRequest.CarrierID  AgentRequest.CarrierObj  Product.VendorContact  Product.VendorContactID  AdvContract.CarrierID  AdvContract.CarrierObj  CommRate.CarrierID  Vendor.ContactVendor 
    Main TableData ObjectTopSearchReadonly
    CONTACT_VENDOR_ALIAS2vendortruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    EMailPrivacy
    lookup  YesNofalsefalseVENDOR_EMailPrivacy 
    Name
    string200  truefalseVENDOR_Name 
    PhonePrivacy
    lookup  YesNofalsefalseVENDOR_PhonePrivacy 
    PostalMailPrivacy
    lookup  YesNofalsefalseVENDOR_PostalMailPrivacy 
    Addresses
     Address   
    Business
     BusinessVendor   
    Phones
     Phone   
    Products
     Product   
    Vendor
     Vendor   
    WebAddresses
     WebAddress   


    Contract
    Referred By:
    AdvContract.ContractObj  AdvContract.ContractID  CommRate.ContractID 
    Main TableData ObjectTopSearchReadonly
    CONTRACT_TABLEContracttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CarrierOfficeID
    integer   truefalseCONTRACT_CARRIEROFFICEIDForeign Key -- Link to VENDOR table
    ContractDisplayName
    string30  truetrueCONTRACT_ContractDisplayNameNon-DB column for Contract display name
    ContractName
    string120  truefalseCONTRACT_CONTRACTNAMEContract name
    ContractType
    lookup  ContractTypetruefalseCONTRACT_CONTRACTTYPEContract type choice field
    DateType
    lookup  ContractDateTypetruefalseCONTRACT_DATETYPEType of date that the commissions are paid from
    Description
    string80  truefalseCONTRACT_DESCRIPTIONContract description
    ModifiedOn
    datetime   truefalseCONTRACT_MODIFIEDON 
    PaidBy
    lookup  CommPaidBytruefalseCONTRACT_PAIDBYContract paid by choice field
    Status
    lookup  ContractStatusTypetruefalseCONTRACT_STATUSContract status choice field
    AdvContracts
     AdvContract   
    CommRates
     CommRate   
    CarrierID
    id ContactVendor truefalseCONTRACT_CARRIERIDForeign Key -- Link to VENDOR table
    Vendor
    object ContactVendor falsefalseCONTRACT_CARRIERIDForeign Key -- Link to VENDOR table


    CorrTransSettings
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CORRTRANS_SETTINGS_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppuserOfficeID
    integer   truefalseCORRTRANS_SETTINGS_APPUSEROFFICEID 
    BinaryDataKey
    string100  truefalseCORRTRANS_SETTINGS_BINARYDATAKEY 
    CreatedOn
    datetime   truefalseCORRTRANS_SETTINGS_CREATEDON 
    DocReadOnly
    lookup  YesNotruefalseCORRTRANS_SETTINGS_DOCREADONLY 
    EmailAsHTML
    lookup  YesNotruefalseCORRTRANS_SETTINGS_EMAILASHTML 
    EmailAsPDF
    lookup  YesNotruefalseCORRTRANS_SETTINGS_EMAILASPDF 
    EmailAttachment1
    string260  truefalseCORRTRANS_SETTINGS_EMAILATTACHMENT1 
    EmailAttachment2
    string260  truefalseCORRTRANS_SETTINGS_EMAILATTACHMENT2 
    EmailAttachment3
    string260  truefalseCORRTRANS_SETTINGS_EMAILATTACHMENT3 
    EmailAttachment4
    string260  truefalseCORRTRANS_SETTINGS_EMAILATTACHMENT4 
    EmailBCCList
    string256  truefalseCORRTRANS_SETTINGS_EMAILBCCLIST 
    EmailCCList
    string256  truefalseCORRTRANS_SETTINGS_EMAILCCLIST 
    EmailFrom
    string256  truefalseCORRTRANS_SETTINGS_EMAILFROM 
    EmailOption
    lookup  WordBinderEmailOptiontruefalseCORRTRANS_SETTINGS_EMAILOPTION 
    EmailSecure
    integer  YesNotruefalseCORRTRANS_SETTINGS_EMAILSECURE 
    EmailSignature
    lookup  YesNotruefalseCORRTRANS_SETTINGS_EMAILSIGNATURE 
    EmailSubject
    string256  truefalseCORRTRANS_SETTINGS_EMAILSUBJECT 
    ImageDataKey
    string100  truefalseCORRTRANS_SETTINGS_IMAGEDATAKEY 
    LastAccessedOn
    datetime   truefalseCORRTRANS_SETTINGS_LASTACCESSEDON 
    Method
    lookup  LetterSentMethodtruefalseCORRTRANS_SETTINGS_METHOD 
    Module
    lookup  PushEventServiceNametruefalseCORRTRANS_SETTINGS_MODULE 
    SMTPPassword
    string128  truefalseCORRTRANS_SETTINGS_SMTPPASSWORD 
    SMTPPort
    integer   truefalseCORRTRANS_SETTINGS_SMTPPORT 
    SMTPServer
    string256  truefalseCORRTRANS_SETTINGS_SMTPSERVER 
    SMTPTLS
    lookup  YesNotruefalseCORRTRANS_SETTINGS_SMTPTLS 
    SMTPUseSSL
    lookup  YesNotruefalseCORRTRANS_SETTINGS_SMTPUSESSL 
    SMTPUserName
    string256  truefalseCORRTRANS_SETTINGS_SMTPUSERNAME 
    SelectedPrinter
    string256  truefalseCORRTRANS_SETTINGS_SELECTEDPRINTER 
    SettingsID
    integer   truefalseCORRTRANS_SETTINGS_ID 
    Status
    lookup  CorrTransactionStatustruefalseCORRTRANS_SETTINGS_STATUS 
    TransactionID
    string64  truefalseCORRTRANS_SETTINGS_TRANSACTIONID 
    AppUser
    object User truefalseCORRTRANS_SETTINGS_APPUSERID 
    AppUserID
    id User truefalseCORRTRANS_SETTINGS_APPUSERID 


    CorrTransaction
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CORRTRANSACTION_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppuserOfficeID
    integer   truefalseCORRTRANSACTION_APPUSEROFFICEID 
    CNTLetterDoc
    dtImage   truefalseCORRTRANSACTION_CNTLETTERDOC 
    CNTLetterFFP
    lookup  YesNotruefalseCORRTRANSACTION_CNTLETTERFFP 
    CNTLetterFooterID
    integer   truefalseCORRTRANSACTION_CNTLETTERFOOTERID 
    CNTLetterFooterOfficeID
    integer   truefalseCORRTRANSACTION_CNTLETTERFOOTEROFFICEID 
    CNTLetterFormat
    integer   truefalseCORRTRANSACTION_CNTLETTERFORMAT 
    CNTLetterHPF
    lookup  YesNotruefalseCORRTRANSACTION_CNTLETTERHFP 
    CNTLetterHeaderID
    integer   truefalseCORRTRANSACTION_CNTLETTERHEADERID 
    CNTLetterHeaderOfficeID
    integer   truefalseCORRTRANSACTION_CNTLETTERHEADEROFFICEID 
    CNTLetterOptOut
    string256  truefalseCORRTRANSACTION_CNTLETTEROPTOUT 
    CNTLetterType
    integer   truefalseCORRTRANSACTION_CNTLETTERTYPE 
    CntLetterDocUpdated
    dtImage   truefalseCORRTRANSACTION_CNTLETTERDOCUPDATED 
    CntLetterEmailUpdated
    dtImage   truefalseCORRTRANSACTION_CNTLETTEREMAILUPDATED 
    ContactCodes
    text   truefalseCORRTRANSACTION_CONTACTCODES 
    ContactDestination
    string255  truefalseCORRTRANSACTION_CONTACTDESTINATION 
    ContactEditor
    integer   truefalseCORRTRANSACTION_CONTACTEDITOR 
    ContactFullName
    string256  truefalseCORRTRANSACTION_CONTACTFULLNAME 
    ContactMethod
    integer   truefalseCORRTRANSACTION_CONTACTMETHOD 
    ContactOfficeID
    integer   truefalseCORRTRANSACTION_CONTACTOFFICEID 
    ContactRefID
    integer   truefalseCORRTRANSACTION_CONTACTREFID 
    ContactRefOfficeID
    integer   truefalseCORRTRANSACTION_CONTACTREFOFFICEID 
    ContactRefTableID
    integer   truefalseCORRTRANSACTION_CONTACTREFTABLEID 
    ContactVals
    text   truefalseCORRTRANSACTION_CONTACTVALS 
    CorrTransactionID
    integer   truefalseCORRTRANSACTION_CORRTRANSACTIONID 
    LetterCompressed
    integer   truefalseCORRTRANSACTION_LETTERCOMPRESSED 
    LetterDoc
    dtImage   truefalseCORRTRANSACTION_LETTERDOC 
    LetterFormat
    lookup  LetterFormattruefalseCORRTRANSACTION_LETTERFORMAT 
    LetterKeyWord
    string255  truefalseCORRTRANSACTION_LETTERKEYWORD 
    LetterNoCode
    lookup  YesNotruefalseCORRTRANSACTION_LETTERNOCODE 
    LetterOfficeID
    integer   truefalseCORRTRANSACTION_LETTEROFFICEID 
    LetterPrintUsingWord
    lookup  YesNotruefalseCORRTRANSACTION_LETTERPRINTUSINGWORD 
    LetterTitle
    string255  truefalseCORRTRANSACTION_LETTERTITLE 
    LetterType
    lookup  LetterTypestruefalseCORRTRANSACTION_LETTERTYPE 
    LetterUserCodes
    string1024  truefalseCORRTRANSACTION_LETTERUSERCODES 
    LetterUserValues
    string2048  truefalseCORRTRANSACTION_LETTERUSERVALUES 
    Status
    lookup  CorrTransactionStatustruefalseCORRTRANSACTION_STATUS 
    TransactionID
    string64  truefalseCORRTRANSACTION_TRANSACTIONID 
    Contact
    object Contact truefalseCORRTRANSACTION_CONTACTID 
    ContactID
    id Contact truefalseCORRTRANSACTION_CONTACTID 
    Letter
    object Letter truefalseCORRTRANSACTION_LETTERID 
    LetterID
    id Letter truefalseCORRTRANSACTION_LETTERID 
    AppUser
    object User truefalseCORRTRANSACTION_APPUSERID 
    AppUserID
    id User truefalseCORRTRANSACTION_APPUSERID 


    CrtIllness
    Referred By:
    Policy.CrtIllness 
    Main TableData ObjectTopSearchReadonly
    CRTILLNESS_TABLEpolicytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CancerRel
    byte   truefalseCRTILLNESS_CancerRelCancer-related exclusions
    Exclusions
    string30  truefalseCRTILLNESS_ExclusionsExclusions
    HeartRel
    byte   truefalseCRTILLNESS_HeartRelHeart-related exclusion
    NetFaceAmt
    double   truefalseCRTILLNESS_NetFaceAmtNet face amount
    PayOutOpt
    string30  truefalseCRTILLNESS_PayOutOptPayout option
    PayoutAmt
    double   truefalseCRTILLNESS_PayoutAmtPayout amount
    Rating
    string30  truefalseCRTILLNESS_RatingRating
    RatingAmt
    double   truefalseCRTILLNESS_RatingAmtRating amount


    CrystalReports
    Referred By:
    ReportSharing.CrystalReport  ReportSharing.ReportID 
    Main TableData ObjectTopSearchReadonly
    CRYSTALREPORTS_TABLEcrystalrpttruetruetrue

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AvailableForPackage
    lookup  YesNotruefalseCRYSTALREPORTS_AvailableForPackageIs this report available for Report Packaging
    CategoryID
    lookup  RptCategoryfalsefalseCRYSTALREPORTS_CategoryIDCategory ID
    CreatedOn
    datetime   falsefalseCRYSTALREPORTS_CreatedOn 
    ModifiedOn
    datetime   falsefalseCRYSTALREPORTS_ModifiedOn 
    OfficeID
    integer   truefalseCRYSTALREPORTS_OfficeIDPrimary Key
    RPTFileName
    string80  falsefalseCRYSTALREPORTS_RPTFileNameReport file name
    ReportName
    string80  falsefalseCRYSTALREPORTS_ReportNameReport name


    CtmSetup
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CTMSETUP_TABLEctmsetuptruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DefManager
    object Agent truefalseCTMSETUP_DefManagerIdForeign Key -- Link to AGENT table
    DefManagerId
    id Agent truefalseCTMSETUP_DefManagerIdForeign Key -- Link to AGENT table
    HouseId
    id Contact truefalseCTMSETUP_HouseId 


    CustomData
    Referred By:
    SecurityMaster.CustomData  ProdSubAccount.CustomData  Lead.CustomData  AcctMaster.CustomData  AgentContact.CustomData  RepContact.CustomData  Agent.CustomData  NewBusiness.CustomData  Opportunity.CustomData  Service.CustomData  Policy.CustomData  HouseHold.CustomData  Product.CustomData  Contact.CustomData 
    Main TableData ObjectTopSearchReadonly
    CUSTOMDATA_TABLEcustomdatafalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AlphaNum1
    string255 Custom1falsefalseCUSTOMDATA_AlphaNum1Customizable alphanumeric field 1
    AlphaNum10
    string255 Custom10falsefalseCUSTOMDATA_AlphaNum10Customizable alphanumeric field 10
    AlphaNum11
    string255 Custom11falsefalseCUSTOMDATA_AlphaNum11Customizable alphanumeric field 11
    AlphaNum12
    string255 Custom12falsefalseCUSTOMDATA_AlphaNum12Customizable alphanumeric field 12
    AlphaNum13
    string255 Custom13falsefalseCUSTOMDATA_AlphaNum13Customizable alphanumeric field 13
    AlphaNum14
    string255 Custom14falsefalseCUSTOMDATA_AlphaNum14Customizable alphanumeric field 14
    AlphaNum15
    string255 Custom15falsefalseCUSTOMDATA_AlphaNum15Customizable alphanumeric field 15
    AlphaNum16
    string255 Custom16falsefalseCUSTOMDATA_AlphaNum16Customizable alphanumeric field 16
    AlphaNum17
    string255 Custom17falsefalseCUSTOMDATA_AlphaNum17Customizable alphanumeric field 17
    AlphaNum18
    string255 Custom18falsefalseCUSTOMDATA_AlphaNum18Customizable alphanumeric field 18
    AlphaNum19
    string255 Custom19falsefalseCUSTOMDATA_AlphaNum19Customizable alphanumeric field 19
    AlphaNum2
    string255 Custom2falsefalseCUSTOMDATA_AlphaNum2Customizable alphanumeric field 2
    AlphaNum20
    string255 Custom20falsefalseCUSTOMDATA_AlphaNum20Customizable alphanumeric field 20
    AlphaNum3
    string255 Custom3falsefalseCUSTOMDATA_AlphaNum3Customizable alphanumeric field 3
    AlphaNum4
    string255 Custom4truefalseCUSTOMDATA_AlphaNum4Customizable alphanumeric field 4
    AlphaNum5
    string255 Custom5truefalseCUSTOMDATA_AlphaNum5Customizable alphanumeric field 5
    AlphaNum6
    string255 Custom6truefalseCUSTOMDATA_AlphaNum6Customizable alphanumeric field 6
    AlphaNum7
    string255 Custom7truefalseCUSTOMDATA_AlphaNum7Customizable alphanumeric field 7
    AlphaNum8
    string255 Custom8truefalseCUSTOMDATA_AlphaNum8Customizable alphanumeric field 8
    AlphaNum9
    string255 Custom9falsefalseCUSTOMDATA_AlphaNum9Customizable alphanumeric field
    Date1
    date   falsefalseCUSTOMDATA_Date1Customizable date field 1
    Date10
    date   falsefalseCUSTOMDATA_Date10Customizable date field 10
    Date11
    date   falsefalseCUSTOMDATA_Date11Customizable date field 11
    Date2
    date   falsefalseCUSTOMDATA_Date2Customizable date field 2
    Date3
    date   falsefalseCUSTOMDATA_Date3Customizable date field 3
    Date4
    date   falsefalseCUSTOMDATA_Date4Customizable date field 4
    Date5
    date   falsefalseCUSTOMDATA_Date5Customizable date field 5
    Date6
    date   falsefalseCUSTOMDATA_Date6Customizable date field 6
    Date7
    date   falsefalseCUSTOMDATA_Date7Customizable date field 7
    Date8
    date   falsefalseCUSTOMDATA_Date8Customizable date field 8
    Date9
    date   falsefalseCUSTOMDATA_Date9Customizable date field 9
    Int1
    integer   falsefalseCUSTOMDATA_Int1Customizable integer field 1
    Int10
    integer   falsefalseCUSTOMDATA_Int10 
    Int2
    integer   falsefalseCUSTOMDATA_Int2Customizable integer field 2
    Int3
    integer   falsefalseCUSTOMDATA_Int3Customizable integer field 3
    Int4
    integer   falsefalseCUSTOMDATA_Int4Customizable integer field 4
    Int5
    integer   falsefalseCUSTOMDATA_Int5Customizable integer field 5
    Int6
    integer   falsefalseCUSTOMDATA_Int6 
    Int7
    integer   falsefalseCUSTOMDATA_Int7 
    Int8
    integer   falsefalseCUSTOMDATA_Int8 
    Int9
    integer   falsefalseCUSTOMDATA_Int9 
    LinkTable
    integer   truefalseCUSTOMDATA_LinkTableuser Group that custom tab will be used with
    Lookup1
    lookup  ContactCustom1falsefalseCUSTOMDATA_Lookup1Customizable lookup/choice field 1
    Lookup2
    lookup  ContactCustom2falsefalseCUSTOMDATA_Lookup2Customizable lookup/choice field 2
    Lookup3
    lookup  ContactCustom3falsefalseCUSTOMDATA_Lookup3Customizable lookup/choice field 3
    Lookup4
    lookup  ContactCustom4falsefalseCUSTOMDATA_Lookup4Customizable lookup/choice field 4
    Lookup5
    lookup  ContactCustom5falsefalseCUSTOMDATA_Lookup5Customizable lookup/choice field 5
    ModifiedOn
    datetime   truefalseCUSTOMDATA_ModifiedOnDate of last modification
    Num1
    double   falsefalseCUSTOMDATA_Num1Customizable numeric field 1
    Num10
    double   falsefalseCUSTOMDATA_Num10 
    Num2
    double   falsefalseCUSTOMDATA_Num2Customizable numeric field 2
    Num3
    double   falsefalseCUSTOMDATA_Num3Customizable numeric field 3
    Num4
    double   falsefalseCUSTOMDATA_Num4Customizable numeric field 4
    Num5
    double   falsefalseCUSTOMDATA_Num5Customizable numeric field 5
    Num6
    double   falsefalseCUSTOMDATA_Num6Customizable numeric field 6
    Num7
    double   falsefalseCUSTOMDATA_Num7 
    Num8
    double   falsefalseCUSTOMDATA_Num8 
    Num9
    double   falsefalseCUSTOMDATA_Num9 
    ObjectID
    link   falsefalseCUSTOMDATA_ObjectIdPrimary Key
    ObjectIDVal
    integer   truefalseCUSTOMDATA_ObjectIdPrimary Key
    SubModuleID
    integer   truefalseCUSTOMDATA_SubModuleIdPrimary Key
    YesNo1
    lookup  YesNofalsefalseCUSTOMDATA_YesNo1Customizable yes/no field 1
    YesNo10
    lookup  YesNofalsefalseCUSTOMDATA_YesNo10 
    YesNo1Text
    lookuptext   falsetrueCUSTOMDATA_YesNo1Text 
    YesNo2
    lookup  YesNofalsefalseCUSTOMDATA_YesNo2Customizable yes/no field 2
    YesNo2Text
    lookuptext   falsetrueCUSTOMDATA_YesNo2Text 
    YesNo3
    lookup  YesNofalsefalseCUSTOMDATA_YesNo3Customizable yes/no field 3
    YesNo3Text
    lookuptext   falsetrueCUSTOMDATA_YesNo3Text 
    YesNo4
    lookup  YesNofalsefalseCUSTOMDATA_YesNo4Customizable yes/no field 4
    YesNo4Text
    lookuptext   falsetrueCUSTOMDATA_YesNo4Text 
    YesNo5
    lookup  YesNofalsefalseCUSTOMDATA_YesNo5Customizable yes/no field 5
    YesNo5Text
    lookuptext   falsetrueCUSTOMDATA_YesNo5Text 
    YesNo6
    lookup  YesNofalsefalseCUSTOMDATA_YesNo6Customizable yes/no field 6
    YesNo6Text
    lookuptext   falsetrueCUSTOMDATA_YesNo6Text 
    YesNo7
    lookup  YesNofalsefalseCUSTOMDATA_YesNo7Customizable yes/no field 7
    YesNo7Text
    lookuptext   falsetrueCUSTOMDATA_YesNo7Text 
    YesNo8
    lookup  YesNofalsefalseCUSTOMDATA_YesNo8Customizable yes/no field 8
    YesNo8Text
    lookuptext   falsetrueCUSTOMDATA_YesNo8TextCustom Lookup
    YesNo9
    lookup  YesNofalsefalseCUSTOMDATA_YesNo9 


    DEXAgent
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DEXAGENT_TABLEdexagentsetupfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppUserID
    integer   truefalseDEXAGENT_AppUserIDApplication user ID
    DexFolder
    string50  truefalseDEXAGENT_DexFolderNot used; value defined in config.xml
    DexServer
    string50  truefalseDEXAGENT_DexServerNot used; value defined in config.xml
    ExpGroupID
    string60  truefalseDEXAGENT_ExpGroupIDDataXchange PCM export Provider Name.
    ExpLandingZone
    string60  truefalseDEXAGENT_ExpLandingZoneDataXchange PCM Export Landing Zone.
    ExpMailboxID
    string60  truefalseDEXAGENT_ExpMailboxIDDataXchange PCM Export Target Mailbox.
    ExpUserName
    string50  truefalseDEXAGENT_ExpUserNameDataXchange PCM Export User Name.
    FileType
    lookup  FileTypetruefalseDEXAGENT_FileTypeNAILBA & XMLife file types
    Frequency
    integer   truefalseDEXAGENT_FrequencyFrequency
    Unit
    lookup  DurationUnittruefalseDEXAGENT_UnitDuration unit: days/hours/minutes
    UserName
    string16  truefalseDEXAGENT_UserNameUser name


    DSIFileWorkFlow
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DSIFILEWORKFLOW_TABLEdsifileworkflowtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AdapterType
    lookup  DXAdapterTypetruefalseDSIFILEWORKFLOW_ADAPTERTYPEType of adapter
    DSFileWorkFLowId
    integer   truefalseDSIFILEWORKFLOW_DSFILEWORKFLOWID 
    EndTime
    datetime   truefalseDSIFILEWORKFLOW_ENDTIMEThe time at whcih adapter completed load the data to the interface tables
    FilePath
    string512  falsefalseDSIFILEWORKFLOW_FILEPATHComplete path of the file
    LastModified
    datetime   truefalseDSIFILEWORKFLOW_LASTMODIFIED 
    OfficeID
    integer   falsefalseDSIFILEWORKFLOW_OFFICEIDFK - part of Appuser FK. The office this file belongs to
    StartTime
    datetime   falsefalseDSIFILEWORKFLOW_STARTTIMEThe time at which the Adapter started loading the data from the source file to the interface tables
    Status
    lookup  DSIFileWorkflowStatustruefalseDSIFILEWORKFLOW_STATUSVarious statuses from file successfully loaded till the data is moved to interface tables
    LoadNo
    id DSISystem truefalseDSIFILEWORKFLOW_LOADNOFK to DSISystem table
    UserID
    id User falsefalseDSIFILEWORKFLOW_APPUSERIDThe user this file belongs to


    DSISystem
    Referred By:
    DSIFileWorkFlow.LoadNo 
    Main TableData ObjectTopSearchReadonly
    DSISYSTEM_TABLEdsisystemtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DXEndTime
    datetime   falsefalseDSISYSTEM_DX_ENDTIMEDate and time of end of application
    DXStartTime
    datetime   falsefalseDSISYSTEM_DX_STARTTIMEDate and time of start of application
    ETLEndTime
    datetime   falsefalseDSISYSTEM_ETL_ENDTIMEEnd time of external load
    ETLStartTime
    datetime   truefalseDSISYSTEM_ETL_STARTTIMEStart time of external load -- required to begin
    InstanceInfo
    string255  falsefalseDSISYSTEM_INSTANCEINFO 
    LoadNo
    integer   truefalseDSISYSTEM_LOADNOPrimary Key
    Priority
    lookup  DXPRIORITYtruefalseDSISYSTEM_PriorityPrioity to be used if there are multiple loads
    Remark
    string255  truefalseDSISYSTEM_RemarksAdapter Manager should put DXO in this column to distiguish.
    Status
    lookup  DXSTATUStruefalseDSISYSTEM_StatusStatus of the process
    Type
    lookup  DSITypetruefalseDSISYSTEM_DSITYPEType = TDM or PDM


    DXAgent
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DEXAGENT_TABLEdexagentsetuptruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ExpGroupingID
    string60  falsefalseDEXAGENT_ExpGroupIDDataXchange PCM export Provider Name.
    ExpLandingZone
    string60  falsefalseDEXAGENT_ExpLandingZoneDataXchange PCM Export Landing Zone.
    ExpMailboxID
    string60  falsefalseDEXAGENT_ExpMailboxIDDataXchange PCM Export Target Mailbox.
    ExpPassword
    binary   falsefalseDEXAGENT_ExpPasswordDataXchange PCM Export User Password.
    ExpUserName
    string50  falsefalseDEXAGENT_ExpUserNameDataXchange PCM Export User Name.
    OfficeID
    integer   truefalseDEXAGENT_OfficeIDPrimary Key


    DXDownload
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DXDOWNLOAD_TABLEdxdownloadfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DXPLog
    text   truefalseDXDOWNLOAD_DXPLog 
    ErrorCount
    integer   truetrueDXDOWNLOAD_ErrorCount 
    FileType
    lookup  FileTypetruefalseDXDOWNLOAD_FileType 
    Mailbox
    string15  truefalseDXDOWNLOAD_Mailbox 
    RecordCount
    integer   truefalseDXDOWNLOAD_RecordCount 
    RecordStatus
    lookup  SPRequestStatustruefalseDXDOWNLOAD_RecordStatus 
    TimeOfDownload
    datetime   truefalseDXDOWNLOAD_TimeOfDownload 


    DXLoad
    Referred By:
    DXLoadPHInfo.DXLoad  DXLoadPHInfo.DXLoadID  DXLoadInfo.DXLoad  DXLoadInfo.DXLoadID 
    Main TableData ObjectTopSearchReadonly
    DXLOAD_TABLEDXLoadtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DataProvider
    string1024  truefalseDXLOAD_DataProvider 
    OfficeId
    integer   truefalseDXLOAD_OfficeId 
    ServiceRunAt
    datetime   falsefalseDXLOAD_ServiceRunAt 
    ServiceRunBy
    id User truefalseDXLOAD_ServiceRunBy 


    DXLoadInfo
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DXLOADINFO_TABLEDXLoadInfotruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    HoldingOfficeID
    integer   truefalseDXLOADINFO_HoldingOfficeId 
    IsFixed
    byte   falsefalseDXLOADINFO_IsFixed 
    IsNew
    byte   falsefalseDXLOADINFO_IsNew 
    DXLoad
    object DXLoad falsefalseDXLOADINFO_DXLoadId 
    DXLoadID
    id DXLoad falsefalseDXLOADINFO_DXLoadId 
    Holding
    object Policy falsefalseDXLOADINFO_HoldingId 
    HoldingID
    id Policy falsefalseDXLOADINFO_HoldingId 
    Position
    object Position falsefalseDXLOADINFO_HoldingId 
    PositionID
    id Position truefalseDXLOADINFO_HoldingId 


    DXLoadPHInfo
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DXLOADPHINFO_TABLEDXLoadPHInfotruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DXLoad
    object DXLoad falsefalseDXLOADPHINFO_DXLoadId 
    DXLoadID
    id DXLoad falsefalseDXLOADPHINFO_DXLoadId 
    PositionHistory
    object PositionHistory falsefalseDXLOADPHINFO_PHId 
    PositionHistoryID
    id PositionHistory truefalseDXLOADPHINFO_PHId 


    DXOAdvisorLogin
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DXOADVISORLOGIN_TABLEdxoadvisorlogintruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DXOUserName
    string50  truefalseDXOADVISORLOGIN_UserNameDXO User Name.
    OfficeName
    string50  truefalseDXOADVISORLOGIN_OfficeName 
    SendOption
    lookup  SLIBSendOptiontruefalseDXOADVISORLOGIN_SendOption 
    SiteName
    string50  truefalseDXOADVISORLOGIN_SiteName 
    Status
    lookup  DXOAdvisorStatustruefalseDXOADVISORLOGIN_StatusDXO Advisor Status - Active/Inactive.
    AdvisorID
    id Agent falsefalseDXOADVISORLOGIN_AdvisorIDDXO AdvisorID


    DashboardSetting
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DASHBOARDSETUP_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    isSuperUser
    string1024  truefalseDASHBOARDSETUP_SetupData 
    showAll
    integer   truefalseDASHBOARDSETUP_OfficeId 


    DataEventLog
    Referred By:

    Main TableData ObjectTopSearchReadonly
    SIDATAEVENTLOG_TABLEsidataeventlogtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Action
    lookup  SIDataEventTypefalsefalseSIDATAEVENTLOG_ACTIONEvent Action - Insert/Update/Delete.
    AdvisorID
    string50  truefalseSIDATAEVENTLOG_AdvisorIDAdvisorID for the record
    ObjectID
    string50  falsefalseSIDATAEVENTLOG_OBJECTIDSI Object ID.
    ObjectType
    string60  truefalseSIDATAEVENTLOG_OBJECTTYPEEvent Object Type.
    OfficeIDValue
    integer   truefalseSIDATAEVENTLOG_OFFICEIDEvent OfficeID
    Status
    lookup  SIDataEventStatustruefalseSIDATAEVENTLOG_STATUSEvent Log Status - Processed/Not Processed.
    Time
    datetime   truefalseSIDATAEVENTLOG_CREATEDTIMEEvent Log Time.
    UniqueID
    string64  truefalseSIDATAEVENTLOG_UniqueID 
    XMLData
    integer   falsefalseSIDATAEVENTLOG_XMLDATAIDBinary Data Id.
    User
    object User falsefalseSIDATAEVENTLOG_USERIDEvent UserID
    UserID
    id User falsefalseSIDATAEVENTLOG_USERIDEvent UserID


    DeleteLog
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DELETELOG_TABLEdeletelogtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppuserOfficeID
    integer   truefalseDELETELOG_AppuserOfficeIDAppuser OfficeID
    CreatedOn
    datetime   truefalseDELETELOG_CreatedOnAppuser ID
    Description
    string512  truefalseDELETELOG_Description 
    LinkID
    integer   truefalseDELETELOG_LinkID 
    LinkTable
    integer   truefalseDELETELOG_LinkTable 
    ParentLinkID
    integer   truefalseDELETELOG_ParentLinkId 
    ParentLinkOffID
    integer   truefalseDELETELOG_ParentLinkOId 
    ParentLinkTable
    integer   truefalseDELETELOG_ParentLinkTable 
    OfficeId
    id Office truefalseDELETELOG_OfficeId 
    UserID
    id User truefalseDELETELOG_APPUSERIDUnique increment PK column for deletelog.


    DeletedGroupCensus
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DELETEDGROUPCENSUS_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    BusinessOfficeID
    integer   truefalseDELETEDGROUPCENSUS_BusinessOfficeID 
    ContactOfficeID
    integer   truefalseDELETEDGROUPCENSUS_ContactOfficeID 
    DeletedByText
    string60  truetrueDELETEDGROUPCENSUS_DeletedByText 
    DeletedOn
    datetime   falsefalseDELETEDGROUPCENSUS_DeletedOn 
    EISSynced
    lookup  YesNotruefalseDELETEDGROUPCENSUS_EISSynced 
    Business
    object Business truefalseDELETEDGROUPCENSUS_BusinessID 
    BusinessID
    id Business truefalseDELETEDGROUPCENSUS_BusinessID 
    Contact
    object Contact truefalseDELETEDGROUPCENSUS_ContactID 
    ContactID
    id Contact truefalseDELETEDGROUPCENSUS_ContactID 
    DeletedBy
    object User truefalseDELETEDGROUPCENSUS_DeletedByID 
    DeletedByID
    id User truefalseDELETEDGROUPCENSUS_DeletedByID 


    Disability
    Referred By:
    Policy.Disability 
    Main TableData ObjectTopSearchReadonly
    DISBLTY_TABLEpolicyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Assigned
    lookup  YesNoUnknownfalsefalseDISBLTY_AssignedAssigned indicator
    AssignedText
    lookuptext   falsetrueDISBLTY_AssignedText 
    BenAmtSick
    double   falsefalseDISBLTY_BenAmtSickBenefit amount for sickness
    BenPeriodSick
    string90 AccBenPeriodfalsefalseDISBLTY_BenPrdSickBenefit period for sickness
    BenefitAmt
    double   falsefalseDISBLTY_BenefitAmtBenefit amount for accident
    BenefitPeriod
    string90 AccBenPeriodfalsefalseDISBLTY_BenefitPrdBenefit period for accident
    BuyoutFunding
    lookup  BuyoutFundingfalsefalseDISABILITY_BuyoutFundingBuyout funding
    DiClass
    string180  falsefalseDISBLTY_DiClassDisability class (not used)
    EESplit
    integer   falsefalseDISBLTY_EESplitEmployee paid premium amount
    ERSplit
    integer   falsefalseDISBLTY_ERSplitEmployer paid premium amount
    Elimination
    string90 AccElemPeriodfalsefalseDISBLTY_EliminationElimination period for accident
    EliminationSick
    string90 AccElemPeriodfalsefalseDISBLTY_ElimSickElimination period for sickness
    FlexBill
    lookup  YesNoUnknownfalsefalseDISBLTY_FlexBillFlex billing indicator
    FlexBillText
    lookuptext   falsetrueDISBLTY_FlexBillText 
    LumpSumBenifit
    double   falsefalseDISABILITY_LumpSumBenifitLump sum benefit
    ModifiedOn
    datetime   truefalseDISABILITY_ModifiedOnDate of last modification
    OccupationRate
    lookup  OccupationRatefalsefalseDISABILITY_OccupationRateOccupation rate
    Rating
    string180 DisbltyRatingfalsefalseDISBLTY_RatingRating
    Residual
    lookup  ResidualfalsefalseDISBLTY_ResidualPolicy residual: benefit, rider or none
    ResidualText
    lookuptext   falsetrueDISBLTY_ResidualText 
    StepDate
    date   falsefalseDISBLTY_StepDateStep rated date
    StepRated
    short   falsefalseDISBLTY_StepRatedStep rated
    TotalBuyoutCoverage
    double   falsefalseDISABILITY_TotalBuyoutCoverageTotal buyout coverage
    Wivers
    string180  falsefalseDISBLTY_WiversWaivers


    DoctorContact
    Referred By:
    UnderReq.DoctorContactID  UnderReq.DoctorContact 
    Main TableData ObjectTopSearchReadonly
    CONTACT_DOCTOR_ALIASdoctorfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    FirstName
    string64  truefalseDOCTOR_FirstName 
    Greeting
    string40  falsefalseDOCTOR_Greeting 
    LastName
    string200  truefalseDOCTOR_LastName 
    MiddleName
    string40  falsefalseDOCTOR_MiddleName 
    Remark
    string4000  falsefalseDOCTOR_Remark 
    Suffix
    string40 SuffixfalsefalseDOCTOR_Suffix 
    Addresses
     Address   
    PreferredAddress
    object Address falsefalseDOCTOR_PreferredAddrID 
    Phones
     Phone   
    PreferredPhone
    object Phone falsefalseDOCTOR_PreferredPhoneID 
    PreferredWebAddress
     WebAddress   
    WebAddresses
     WebAddress   


    DownloadLog
    Referred By:

    Main TableData ObjectTopSearchReadonly
    DOWNLOADLOG_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CreatedBy
    integer   falsefalseDOWNLOADLOG_CreatedBy 
    CreatedByOfficeID
    integer   falsefalseDOWNLOADLOG_CreatedByOfficeID 
    Keywords
    string256 KeywordsActivityfalsefalseDOWNLOADLOG_Keywords 
    LinkID
    integer   falsefalseDOWNLOADLOG_LinkID 
    LinkTable
    integer   falsefalseDOWNLOADLOG_LinkTable 
    LinkedWith
    string64  falsefalseDOWNLOADLOG_LinkedWith 
    LogDate
    datetime   falsefalseDOWNLOADLOG_LogDate 
    LogText
    text   falsefalseDOWNLOADLOG_LogText 
    LogType
    string64  falsefalseDOWNLOADLOG_LogType 
    ModifiedByOfficeID
    integer   falsefalseDOWNLOADLOG_ModifiedByOfficeID 
    ModifiedOn
    datetime   falsefalseDOWNLOADLOG_ModifiedOn 
    ModififedBy
    integer   falsefalseDOWNLOADLOG_ModififedBy 


    Driver
    Referred By:
    Policy.Drivers 
    Main TableData ObjectTopSearchReadonly
    DRIVERS_TABLEdrivertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Accident
    integer   falsefalseDRIVER_AccidentAccident
    Age
    integer   falsetrueDRIVERS_Age 
    DOB
    date   truefalseDRIVERS_DOBDriver's date of birth
    DriverName
    string60  truefalseDRIVERS_DriverNameDriver's name
    GoodDriver
    integer   falsefalseDRIVER_GoodDriverGood driver discount
    GoodStudent
    integer   falsefalseDRIVER_GoodStudentGood student discount
    License
    string60  falsefalseDRIVERS_LicenseDriver's state driver's license number
    MajorCitation
    double   falsefalseDRIVER_MajorCitationNumber of major citations
    Marital
    lookup  MaritalfalsefalseDRIVERS_MaritalDriver's marital status
    MaritalText
    lookuptext   falsetrueDRIVERS_MaritalText 
    MinorCitation
    double   falsefalseDRIVER_MinorCitationNumber of minor citations
    Rating
    string60  falsefalseDRIVERS_RatingDriver's rating
    Remarks
    string240  falsefalseDRIVER_RemarksRemarks
    Sex
    lookup  GenderfalsefalseDRIVERS_SexDriver's gender
    SexText
    lookuptext   falsetrueDRIVERS_SexText 
    State
    lookup  StateCodefalsefalseDRIVER_StateState of driver's license
    SurChargeAccident
    string20  falsefalseDRIVER_SurChargeAccidentSurcharge accident
    SurChargeTickets
    string30  falsefalseDRIVER_SurChargeTicketsSurcharge tickets
    PolicyID
    id Policy truefalseDRIVERS_HoldingIDForeign Key -- Link to HOLDING table


    DynReport
    Referred By:
    UserProfile.DynReportObj  UserProfile.DynReportID 
    Main TableData ObjectTopSearchReadonly
    DYNREPORT_TABLEreportfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActReason
    string255  falsefalseDYNREPORT_ActReasonActivity reason
    Category
    string32  truefalseDYNREPORT_CategoryCategory of the dynamic report
    CategoryName
    string512 DynReportCategorytruefalseDYNREPORT_CategoryNameActual name of the category, column added to make it available for filter.
    CreatedByText
    string60  truetrueDYNREPORT_CreatedByText 
    CreatedOn
    datetime   truefalseDYNREPORT_CreatedOnDate when the dynamic report is created
    Description
    string2048  falsefalseDYNREPORT_DescriptionDynamic report description
    Family
    lookup  JoinFamilytruetrueDYNREPORT_Family 
    FilterData
    text   truefalseDYNREPORT_FilterDataFilter used for this report
    JoinID
    integer  NamedJointruefalseDYNREPORT_JoinIDCategory this report belongs to, e.g., contact
    Keyword
    string40 KeywordsActivitytruefalseDYNREPORT_KeywordKeyword for the dynamic report
    ModifiedOn
    datetime   truefalseDYNREPORT_ModifiedOnDate on which the dynamic report last modified
    Name
    string127  truefalseDYNREPORT_Name 
    RTOption
    lookup  YesNotruefalseDYNREPORT_RTOptionIndicates runtime parameters option
    RealFamilyName
    string256 DynReportFamilytruefalseDYNREPORT_RealFamilyNameActual Family name, olumn added to make it available for filter.
    Image
    object Image truefalseDYNREPORT_ImageIDForeign Key -- Link to IMAGE table (MS Excel)
    ImageID
    id Image truefalseDYNREPORT_ImageIDForeign Key -- Link to IMAGE table (MS Excel)
    Letter
    object Letter falsefalseDYNREPORT_LetterIDForeign Key -- Link to LETTER table
    CreatedBy
    object User truefalseDYNREPORT_CreatedBy 
    CreatedByID
    id User truefalseDYNREPORT_CreatedBy 


    EOStatus
    Referred By:
    AgentRequest.EOStatusID  AgentRequest.ProposedEOStatusID 
    Main TableData ObjectTopSearchReadonly
    EOSTATUS_TABLEEOtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AgentID
    integer   truefalseEOSTATUS_AgentIDForeign Key -- Link to CONTACT table
    Carrier
    string256  truefalseEOSTATUS_CarrierCarrier name of E&O policy
    EOStatusID
    integer   truefalseEOSTATUS_EOStatusIDPrimary Key
    EffDate
    date   truefalseEOSTATUS_EffDateE&O insurance effective date
    ExpDate
    date   truefalseEOSTATUS_ExpDateE&O policy expiration date
    HasDocument
    lookup  YesNotruetrueEOSTATUS_HasDocumentIndicates presence of document
    LOBList
    string255  truetrueEOSTATUS_LOBList 
    ModifiedOn
    datetime   truefalseEOSTATUS_ModifiedOn 
    OfficeID
    integer   truefalseEOSTATUS_OfficeIDPrimary Key
    PolicyNo
    string30  truefalseEOSTATUS_PolicyNoE&O policy number
    Status
    lookup  LicenseStatustruefalseEOSTATUS_StatusStatus of E&O insurance
    TermReason
    string2048  truefalseEOSTATUS_TermReasonAdditional remarks regarding E&O policy
    Type
    lookup  ComplianceTypetruefalseEOSTATUS_Type 


    EXTInterfaceLogin
    Referred By:

    Main TableData ObjectTopSearchReadonly
    EXTINTERFACELOGIN_TABLEextinterfacelogintruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Data
    string100  falsefalseEXTINTERFACELOGIN_InterfaceDataExternal Interface Specific Data.
    InterfaceType
    lookup  MktMgrtruefalseEXTINTERFACELOGIN_InterfaceTypeExternal Inteface Name
    LoginName
    string40  truefalseEXTINTERFACELOGIN_InterfaceLoginNameExternal Interface Login Name.
    LoginType
    lookup  RegionCodetruefalseEXTINTERFACELOGIN_LoginTypeExternal Interface Login Type - Admin/User Level.
    Password
    string256  falsefalseEXTINTERFACELOGIN_InterfacePasswordExternal Interface password.
    Status
    lookup  OffCodefalsefalseEXTINTERFACELOGIN_InterfaceStatusExternal Interface Status
    User
    object User falsefalseEXTINTERFACELOGIN_UserIDSO User ID
    UserID
    id User falsefalseEXTINTERFACELOGIN_UserIDSO User ID


    EZMail
    Referred By:
    EZMailAttachment.EZMail  EZMailAttachment.EZMailID 
    Main TableData ObjectTopSearchReadonly
    EZMAIL_TABLEmessagetruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AccountID
    integer   falsefalseEZMAIL_ACCOUNTIDForeign Key -- Link to EZMAILACCT table
    AppUserID
    integer   truefalseEZMAIL_AppUserIDForeign Key -- Link to APPUSER table
    Bcc
    text   falsefalseEZMAIL_BccBlind carbon copy
    Body
    dtImage   falsefalseEZMAIL_BodyText in message box
    Cc
    text   falsefalseEZMAIL_CcCarbon copy
    ContentType
    integer   falsefalseEZMAIL_ContentTypeContent type
    DateReceived
    datetime   falsefalseEZMAIL_DateRecvDate message received
    DateSent
    datetime   truefalseEZMAIL_DateSentDate when message was sent
    EZMailSize
    integer   falsefalseEZMAIL_EzmailSize 
    FolderID
    integer   falsefalseEZMAIL_FolderIDForeign Key -- Link to EZMAILFOLDER table
    From
    string64  truefalseEZMAIL_FromMessage sender
    LinkedTableID
    integer   falsefalseEZMAIL_LinkedTableIDPrimary table referenced
    LinkedTableOfficeId
    integer   falsefalseEZMAIL_LinkedTableOfficeIdOffice ID of table referenced
    LinkedTablePKey
    integer   falsefalseEZMAIL_LinkedTablePKeyPrimary Key of table referenced
    Mail
    dtImage   falsefalseEZMAIL_Mail 
    MailType
    lookup  EZMailTypefalsefalseEZMAIL_MailType 
    MessageID
    string256  truefalseEZMAIL_MessageID 
    NumAttach
    integer   falsefalseEZMAIL_NumAttachNumber of attachments
    OfficeID
    integer   truefalseEZMAIL_OfficeIDPrimary Key
    Priority
    lookup  PriorityfalsefalseEZMAIL_PriorityMessage priority
    SPPost
    byte  YesNofalsefalseEZMAIL_SPPostSmartpad posting
    Status
    lookup  ReadUnreadfalsefalseEZMAIL_MsgStatusStatus: read/unread
    Subject
    string512  falsefalseEZMAIL_SubjectMessage subject
    To
    text   falsefalseEZMAIL_ToMessage recipients
    UniqueID
    string250  truefalseEZMAIL_UniqueIDUniversal unique message number
    EZMailAttachments
     EZMailAttachment   


    EZMailAttachment
    Referred By:
    EZMail.EZMailAttachments 
    Main TableData ObjectTopSearchReadonly
    EZMAILATTACH_TABLEattachmenttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Attachment
    dtImage   falsefalseEZMAILATTACH_AttachmentAttachment size in Kb
    ContentType
    string256  falsefalseEZMAILATTACH_ContentTypeAttachment image
    EZMailAttachSize
    integer   truefalseEZMAILATTACH_EzmailAttachSize 
    Name
    string64  falsefalseEZMAILATTACH_NameAttachment name
    EZMail
    object EZMail falsefalseEZMAILATTACH_EZMAILIDForeign Key -- Link to EZMAIL table
    EZMailID
    id EZMail truefalseEZMAILATTACH_EZMAILIDForeign Key -- Link to EZMAIL table


    EZMailFolder
    Referred By:

    Main TableData ObjectTopSearchReadonly
    EZMAILFOLDER_TABLEfoldertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    FolderID
    integer   truefalseEZMAILFOLDER_FolderIDPrimary Key
    Name
    string64  truefalseEZMAILFOLDER_NameFolder name
    OfficeID
    integer   truefalseEZMAILFOLDER_OfficeIDPrimary Key
    Type
    lookup  FolderTypefalsefalseEZMAILFOLDER_TypeFolder type
    UserID
    integer   truefalseEZMAILFOLDER_APPUSERIDForeign Key -- Link to APPUSER table


    EmailQue
    Referred By:

    Main TableData ObjectTopSearchReadonly
    EMAILQUEUE_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Attachment1
    dtImage   truefalseEMAILQUEUE_ATTACHMENT1 
    Attachment2
    dtImage   truefalseEMAILQUEUE_ATTACHMENT2 
    Attachment3
    dtImage   truefalseEMAILQUEUE_ATTACHMENT3 
    Attachment4
    dtImage   truefalseEMAILQUEUE_ATTACHMENT4 
    AttachmentName1
    string256  truefalseEMAILQUEUE_ATTACHMENTNAME1 
    AttachmentName2
    string256  truefalseEMAILQUEUE_ATTACHMENTNAME2 
    AttachmentName3
    string256  truefalseEMAILQUEUE_ATTACHMENTNAME3 
    AttachmentName4
    string256  truefalseEMAILQUEUE_ATTACHMENTNAME4 
    Body
    text   truefalseEMAILQUEUE_Body 
    Cc
    string256  truefalseEMAILQUEUE_Cc 
    EmailID
    integer   truefalseEMAILQUEUE_EMAILID 
    From
    string256  truefalseEMAILQUEUE_From 
    LastError
    text   truefalseEMAILQUEUE_LastError 
    LastSendTime
    datetime   truefalseEMAILQUEUE_LastSendTime 
    MimeType
    string24  truefalseEMAILQUEUE_MimeType 
    OfficeID
    integer   truefalseEMAILQUEUE_OfficeID 
    Secure
    lookup  YesNotruefalseEMAILQUEUE_Secure 
    Send
    lookup  YesNotruefalseEMAILQUEUE_Send 
    Subject
    string256  truefalseEMAILQUEUE_Subject 
    To
    string4000  truefalseEMAILQUEUE_To 
    UserID
    integer   truefalseEMAILQUEUE_UserID 


    Endorcement
    Referred By:
    Policy.Endorcements 
    Main TableData ObjectTopSearchReadonly
    ENDORCEMENTS_TABLEpolicytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Code
    string30  falsefalseENDORCEMENTS_CodeEndorsement code
    Description
    string30  falsefalseENDORCEMENTS_DescEndorsement description
    OfficeID
    integer   falsefalseENDORCEMENTS_OFFICEIDPrimary Key
    Premium
    double   falsefalseENDORCEMENTS_PremiumEndorsement premium
    HoldingID
    id Policy falsefalseENDORCEMENTS_HoldingIDForeign Key -- Link to HOLDING table


    Essyncreport
    Referred By:

    Main TableData ObjectTopSearchReadonly
    ESSYNCREPORT_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CreatedOn
    datetime   truefalseESSYNCREPORT_CreatedOn 
    IsReportOpened
    lookup  YesNotruefalseESSYNCREPORT_IsReportOpened 
    ReportType
    lookup  ESSyncReportTypetruefalseESSYNCREPORT_ReportType 
    ESSyncSetupId
    id Essyncsetup truefalseESSYNCREPORT_ESSyncSetupId 
    ImageId
    id Image truefalseESSYNCREPORT_ImageId 


    Essyncsetup
    Referred By:
    Essyncreport.ESSyncSetupId 
    Main TableData ObjectTopSearchReadonly
    ESSYNCSETUP_TABLEessyncsetuptruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppUserName
    string50  truefalseESSYNCSETUP_AppUserName 
    CalendarName
    string240  falsefalseESSYNCSETUP_ESCalendarName 
    CalendarSyncAction
    lookup  ESSyncActiontruefalseESSYNCSETUP_CalendarSyncAction 
    CalendarSyncDocs
    lookup  YesNofalsefalseESSYNCSETUP_CalendarSyncDocs 
    ContactDelAction
    lookup  ESSyncDeletionOptfalsefalseESSYNCSETUP_ContactDelAction 
    ContactSetId
    integer   falsefalseESSYNCSETUP_ContactSetId 
    ContactSetOfficeId
    integer   falsefalseESSYNCSETUP_ContactSetOfficeId 
    ContactSyncAction
    lookup  ESSyncActiontruefalseESSYNCSETUP_ContactSyncAction 
    ContactSyncBirthDates
    lookup  YesNotruefalseESSYNCSETUP_ContactSyncBirthDates 
    ContactSyncPhotos
    lookup  YesNofalsefalseESSYNCSETUP_ContactSyncPhotos 
    ContactsImportAs
    lookup  ESContactsImportAsfalsefalseESSYNCSETUP_ContactsImportAs 
    CreatedBy
    integer   falsefalseESSYNCSETUP_CreatedBy 
    CreatedByOfficeId
    integer   falsefalseESSYNCSETUP_CreatedByOfficeId 
    CreatedOn
    datetime   falsefalseESSYNCSETUP_CreatedOn 
    DoNotPostInternalEmail
    byte  YesNotruefalseESSYNCSETUP_DoNotPostInternalEmail 
    ESConnectionStatus
    lookup  ESConnectionStatustruefalseESSYNCSETUP_ESConnectionStatus 
    ESContactFolder
    string256  falsefalseESSYNCSETUP_ESContactFolder 
    ESDomainName
    string256  falsefalseESSYNCSETUP_ESDomainName 
    ESMailBoxName
    string75  falsefalseESSYNCSETUP_ESMailBoxName 
    ESMailBoxPassword
    string128  falsefalseESSYNCSETUP_ESMailBoxPassword 
    ESServerName
    lookup  ExServerNamefalsefalseESSYNCSETUP_ESServerName 
    ESServerURL
    string256  falsefalseESSYNCSETUP_ESServerURL 
    ESSubSystemType
    string10  falsefalseESSYNCSETUP_ESSubSystemType 
    EmailSyncAction
    byte  ESSyncSmartMailtruefalseESSYNCSETUP_EmailSyncAction 
    EnCalConEmailAssoc
    lookup  YesNofalsefalseESSYNCSETUP_EnCalConEmailAssoc 
    EnableSync
    lookup  YesNofalsefalseESSYNCSETUP_EnableSync 
    IncludeAttachment
    byte  YesNotruefalseESSYNCSETUP_IncludeAttachment 
    IncomingCc
    byte  YesNotruefalseESSYNCSETUP_IncomingCc 
    IncomingFrom
    byte  YesNotruefalseESSYNCSETUP_IncomingFrom 
    IncomingTo
    byte  YesNotruefalseESSYNCSETUP_IncomingTo 
    IsAllDayEvents
    lookup  YesNotruefalseESSYNCSETUP_IsAllDayEvents 
    IsCalendarRecurring
    lookup  YesNofalsefalseESSYNCSETUP_IsCalendarRecurring 
    IsFullRefresh
    lookup  YesNotruefalseESSYNCSETUP_IsFullRefresh 
    IsPreview
    lookup  YesNotruefalseESSYNCSETUP_IsPreview 
    IsSetBasedSync
    lookup  YesNofalsefalseESSYNCSETUP_IsSetBasedSync 
    IsTaskRecurring
    lookup  YesNofalsefalseESSYNCSETUP_IsTaskRecurring 
    LastSyncedTime
    datetime   truefalseESSYNCSETUP_LastSyncedTime 
    LinkEmail
    byte  YesNotruefalseESSYNCSETUP_LinkEmail 
    ModifiedBy
    integer   falsefalseESSYNCSETUP_ModifiedBy 
    ModifiedByOfficeId
    integer   falsefalseESSYNCSETUP_ModifiedByOfficeId 
    ModifiedOn
    datetime   truefalseESSYNCSETUP_ModifiedOn 
    OutgoingBcc
    byte  YesNotruefalseESSYNCSETUP_OutgoingBcc 
    OutgoingCC
    byte  YesNotruefalseESSYNCSETUP_OutgoingCC 
    OutgoingFrom
    byte  YesNotruefalseESSYNCSETUP_OutgoingFrom 
    OutgoingTo
    byte  YesNotruefalseESSYNCSETUP_OutgoingTo 
    PostEmailToContact
    byte  YesNotruefalseESSYNCSETUP_PostEmailToContact 
    RequestReport
    lookup  YesNofalsefalseESSYNCSETUP_RequestReport 
    SyncUserResponse
    lookup  ESSyncUserResponsetruefalseESSYNCSETUP_SyncUserResponse 
    TaskSyncAction
    lookup  ESSyncActionfalsefalseESSYNCSETUP_TaskSyncAction 
    TaskSyncDocs
    lookup  YesNofalsefalseESSYNCSETUP_TaskSyncDocs 
    Set
    object Set truefalseESSYNCSETUP_ContactSetId 
    SetId
    id Set truefalseESSYNCSETUP_ContactSetId 
    AppUser
    object User truefalseESSYNCSETUP_AppUserId 
    AppUserId
    id User truefalseESSYNCSETUP_AppUserId 


    EventInvitee
    Referred By:

    Main TableData ObjectTopSearchReadonly
    EVNTINVITEE_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Status
    lookup  EventInviteeStatusfalsefalseEVNTINVITEE_StatusStatus
    ContactID
    id Contact truefalseEVNTINVITEE_ContactIDForeign Key -- Link to CONTACT table
    EvntOccurrenceID
    id EventOccurrence truefalseEVNTINVITEE_EvntOccurrenceIDForeign Key -- Link to EVNTOCCURANCE table
    InvitedBy
    id User falsefalseEVNTINVITEE_InvitedByForeign Key -- Link to APPUSER table


    EventOccurrence
    Referred By:
    EventInvitee.EvntOccurrenceID 
    Main TableData ObjectTopSearchReadonly
    EVNTOCCURRENCE_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CoordinatorID
    integer   truefalseEVNTOCCURRENCE_CoordinatorIDFkey to APPUSER_EVNTINITIATOR_ALIAS
    EndDateTime
    datetime   falsefalseEVNTOCCURRENCE_EndDateScheduled finish time
    EndTime
    time   falsetrueEVNTOCCURRENCE_EndTime 
    EventName
    string128  falsefalseEVNTOCCURRENCE_EventNameEvent/site name
    EvntOccurrenceID
    integer   truefalseEVNTOCCURRENCE_EvntOccurrenceIDPrimary Key
    InitiatorID
    integer   truefalseEVNTOCCURRENCE_InitiatorIDForeign Key -- Link to APPUSER_EVNTCOORDINATOR_ALIAS table
    StartDateTime
    datetime   truefalseEVNTOCCURRENCE_StartDateScheduled date and time
    StartTime
    time   falsetrueEVNTOCCURRENCE_StartTime 
    EvntTemplateID
    id EventTemplate truefalseEVNTOCCURRENCE_EvntTemplateIDForeign Key -- Link to EVNTTEMPLATE table
    Coordinator
    id User truefalseEVNTOCCURRENCE_CoordinatorIDFkey to APPUSER_EVNTINITIATOR_ALIAS
    Initiator
    id User truefalseEVNTOCCURRENCE_InitiatorIDForeign Key -- Link to APPUSER_EVNTCOORDINATOR_ALIAS table


    EventTemplate
    Referred By:
    EventOccurrence.EvntTemplateID 
    Main TableData ObjectTopSearchReadonly
    EVNTTEMPLATE_TABLEeventtemplatefalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    EvntTemplateID
    integer   truefalseEVNTTEMPLATE_EvntTemplateIDPrimary Key
    EvntType
    lookup  EventTypefalsefalseEVNTTEMPLATE_EvntTypeEvent type
    Status
    lookup  TemplateStatusfalsefalseEVNTTEMPLATE_StatusTemplate status
    TemplateName
    string128  truefalseEVNTTEMPLATE_TemplateNameTemplate name
    OfficeID
    id Office falsefalseEVNTTEMPLATE_OfficeIDPrimary Foreign Key -- Link to OFFICE table
    CreatedBy
    id User falsefalseEVNTTEMPLATE_CreatedByForeign Key -- Link to APPUSER table


    Exserverinfo
    Referred By:

    Main TableData ObjectTopSearchReadonly
    EXSERVERINFO_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppuserOfficeID
    integer   truefalseEXSERVERINFO_AppUserOfficeId 
    CreatedOn
    date   falsefalseEXSERVERINFO_CreatedOn 
    EnableSetting
    lookup  YesNofalsefalseEXSERVERINFO_EnableSetting 
    ExAccountName
    string256  falsefalseEXSERVERINFO_ExAccountName 
    ExAccountPassword
    string128  falsefalseEXSERVERINFO_ExAccountPassword 
    ExDomainName
    string256  falsefalseEXSERVERINFO_ExDomainName 
    ExEmailId
    string256  falsefalseEXSERVERINFO_ExEmailId 
    ExServerName
    lookup  ExServerNamefalsefalseEXSERVERINFO_ExServerName 
    ModifiedOn
    date   truefalseEXSERVERINFO_ModifiedOn 
    OfficeId
    integer   truefalseEXSERVERINFO_OfficeId 
    AppUser
    object User truefalseEXSERVERINFO_AppUserId 
    AppUserId
    id User truefalseEXSERVERINFO_AppUserId 


    FA
    Referred By:
    Position.FA 
    Main TableData ObjectTopSearchReadonly
    FA_TABLEpositionfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AnnualIncome
    double   falsefalseFA_AnnualIncomeAnnual income
    Deferred
    lookup  YesNofalsefalseFA_DeferredDeferred yes/no field
    DeferredText
    lookuptext   falsetrueFA_DeferredText 
    MaturityDate
    date   falsetrueFA_MaturityDateMaturity date
    MaturityValue
    double   falsetrueFA_MaturityValueMaturity value
    SinglePrem
    lookup  YesNofalsefalseFA_SinglePremSingle Premium yes/no field
    SinglePremText
    lookuptext   falsetrueFA_SinglePremText 
    WithDrawals
    double   falsefalseFA_WithDrawalsAmount of withdrawals


    GAIDValidate
    Referred By:

    Main TableData ObjectTopSearchReadonly
    GAIDVALIDATE_TABLEgaidvalidatefalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AdvisorId
    integer   truefalseGAIDVALIDATE_AdvisorId 
    AdvisorOfficeId
    integer   truefalseGAIDVALIDATE_AdvisorOfficeId 
    CarrierId
    integer   truefalseGAIDVALIDATE_CarrierId 
    Comments
    text   truefalseGAIDVALIDATE_Comments 
    GAID
    string20  truefalseGAIDVALIDATE_GAID 
    Status
    lookup  GAIDStatustruefalseGAIDVALIDATE_Status 


    GPPlan
    Referred By:

    Main TableData ObjectTopSearchReadonly
    GPPLAN_TABLEgpplanfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    GPPlanId
    integer   truefalseGPPLAN_GPPLANIDPrimary Key


    GroupCensus
    Referred By:
    GroupCensus.RelatedtoID  GroupCensus.GroupCensusMember  Contact.EmployeeCensus  Contact.BusEmployeeCensus 
    Main TableData ObjectTopSearchReadonly
    GROUPCENSUS_TABLEgroupcensustruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Alphanum1
    string30  falsefalseGROUPCENSUS_Alphanum1Optional alpha numeric column 2
    Alphanum2
    string30  falsefalseGROUPCENSUS_Alphanum2Key employee yes/no field
    Alphanum3
    string30  falsefalseGROUPCENSUS_Alphanum3Optional alpha numeric column 4
    Alphanum4
    string30  falsefalseGROUPCENSUS_Alphanum4Optional alpha numeric column 5
    Alphanum5
    string30  falsefalseGROUPCENSUS_Alphanum5Optional alpha numeric column 6
    Alphanum6
    string30  falsefalseGROUPCENSUS_Alphanum6Optional alpha numeric column 7
    Alphanum7
    string30  falsefalseGROUPCENSUS_Alphanum7Optional alpha numeric column 2
    Alphanum8
    string30  falsefalseGROUPCENSUS_Alphanum8 
    BaseSalary
    double   falsefalseGROUPCENSUS_BaseSalaryW-2 salary of employee census member
    BonusSalary
    double   falsefalseGROUPCENSUS_BonusSalaryPrior salary of employee census member
    BusinessOfficeID
    integer   truefalseGROUPCENSUS_BusinessOfficeID 
    Class
    lookup  GroupCensusClassfalsefalseGROUPCENSUS_ClassTotal salary
    Cobra1
    date   falsefalseGROUPCENSUS_Cobra1Cobra end date
    Cobra2
    date   falsefalseGROUPCENSUS_Cobra2Pre-existing condition
    ContactOfficeID
    integer   truefalseGROUPCENSUS_ContactOfficeID 
    Coverage
    lookup  coveragefalsefalseGROUPCENSUS_Coverage 
    CoverageText
    lookuptext   falsetrueGROUPCENSUS_CoverageTextEmployee Status choice field
    Dental
    lookup  coveragefalsefalseGROUPCENSUS_DENTAL 
    GroupCensusID
    integer   truefalseGROUPCENSUS_GroupCensusIDPrimary Foreign Key -- Link to CONTACT table
    HireDate
    date   falsefalseGROUPCENSUS_HireDateRetirement date of employee census member
    KeyEmployee
    lookup  GroupCensusKeyEmployeefalsefalseGROUPCENSUS_KeyEmployeeTermination date of employee census member
    Life
    lookup  coveragefalsefalseGROUPCENSUS_LIFE 
    Medical
    lookup  YesNofalsefalseGROUPCENSUS_MEDICARE 
    MemberType
    lookup  MemberTypefalsefalseGROUPCENSUS_MEMBERTYPE 
    ModifiedOn
    datetime   truefalseGROUPCENSUS_ModifiedOnOptional alpha numeric column 3
    OfficeID
    integer   falsefalseGROUPCENSUS_OfficeIDPrimary Key
    PreCond
    string60  falsefalseGROUPCENSUS_PreCondOptional alpha numeric column 1
    PriorSalary
    double   falsefalseGROUPCENSUS_PriorSalaryRetirement age of employee census member
    Quote
    lookup  YesNofalsefalseGROUPCENSUS_QUOTE 
    RetirementAge
    integer   falsefalseGROUPCENSUS_RetirementAgeCoverage choice field
    RetirementDate
    date   falsefalseGROUPCENSUS_RetirementDateClass choice field
    Status
    lookup  GroupCensusStatustruefalseGROUPCENSUS_StatusDate of last modification
    TerminatedDate
    date   falsefalseGROUPCENSUS_TerminatedDateBase salary of employee census member
    TotalSalary
    double   falsefalseGROUPCENSUS_TotalSalaryCobra begin date
    Vision
    lookup  coveragefalsefalseGROUPCENSUS_VISION 
    W2Salary
    double   falsefalseGROUPCENSUS_W2SalaryBonus salary of employee census member
    Business
    object Contact truefalseGROUPCENSUS_BusinessIDHire date of employee census member
    BusinessID
    id Contact truefalseGROUPCENSUS_BusinessIDHire date of employee census member
    Contact
    object Contact truefalseGROUPCENSUS_ContactIDPrimary Foreign Key -- Link to CONTACT table
    ContactID
    id Contact truefalseGROUPCENSUS_ContactIDPrimary Foreign Key -- Link to CONTACT table
    GroupCensusMember
     GroupCensus   
    RelatedtoID
    id GroupCensus truefalseGROUPCENSUS_RELATEDTOID 


    GroupParticipant
    Referred By:

    Main TableData ObjectTopSearchReadonly
    GROUPPARTICIPANT_TABLEgrpplanmembersfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ContactID
    id Contact truefalseGROUPPARTICIPANT_CONTACTIDPrimary Foreign Key - Link to GRPPLANPOLICY tbl.
    GroupPlan
    object GroupPlan truefalseGROUPPARTICIPANT_GPPlanPolicyIDHolding ID
    GroupPlanID
    id GroupPlan truefalseGROUPPARTICIPANT_GPPlanPolicyIDHolding ID
    IndvHoldingID
    id Policy truefalseGROUPPARTICIPANT_HoldingID 


    GroupPlan
    Referred By:
    GroupParticipant.GroupPlan  GroupParticipant.GroupPlanID 
    Main TableData ObjectTopSearchReadonly
    GRPPLANPOLICY_TABLEgroupplanpolicyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    HoldingID
    id Policy truefalseGRPPLANPOLICY_HoldingIDForeign Key -- Link to HOLDING table


    GroupPolicy
    Referred By:

    Main TableData ObjectTopSearchReadonly
    GROUPPOLICY_TABLEgrouppolicytruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription


    GsyncHistory
    Referred By:
    GsyncSetup.GsyncHistories 
    Main TableData ObjectTopSearchReadonly
    GSYNCHISTORY_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DataMoved
    lookup  YesNotruefalseGSYNCHISTORY_DataMoved 
    PreviewSync
    lookup  YesNotruefalseGSYNCHISTORY_PreviewSync 
    ReportType
    lookup  truefalseGSYNCHISTORY_ReportType 
    Report_Date
    datetime   truefalseGSYNCHISTORY_Report_Date 
    SyncReport
    text   truefalseGSYNCHISTORY_SyncReport 
    SyncSetupOfficeID
    integer   truefalseGSYNCHISTORY_SyncSetupOfficeID 
    SyncSetupID
    id GsyncSetup truefalseGSYNCHISTORY_SyncSetupID 


    GsyncSetup
    Referred By:
    GsyncHistory.SyncSetupID 
    Main TableData ObjectTopSearchReadonly
    GSYNCSETUP_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActivitySyncEnabled
    lookup  YesNotruefalseGSYNCSETUP_ActivitySyncEnabled 
    ContactSyncEnabled
    lookup  YesNotruefalseGSYNCSETUP_ContactSyncEnabled 
    CreatedBy
    integer   truefalseGSYNCSETUP_CreatedBy 
    CreatedByOfficeID
    integer   truefalseGSYNCSETUP_CreatedByOfficeID 
    CreatedOn
    date   truefalseGSYNCSETUP_CreatedOn 
    GoogleGroup
    string50  truefalseGSYNCSETUP_Google_Group 
    IsPreview
    lookup  YesNotruefalseGSYNCSETUP_IsPreview 
    ModifiedBy
    integer   truefalseGSYNCSETUP_ModifiedBy 
    ModifiedByOfficeID
    integer   truefalseGSYNCSETUP_ModifiedByOfficeID 
    ModifiedOn
    date   truefalseGSYNCSETUP_ModifiedOn 
    RequestReport
    lookup  YesNotruefalseGSYNCSETUP_RequestReport 
    SetID
    integer   truefalseGSYNCSETUP_SETID 
    SetOfficeID
    integer   truefalseGSYNCSETUP_Set_OfficeID 
    SyncApproved
    lookup  YesNotruefalseGSYNCSETUP_SyncApproved 
    SyncContactOption
    lookup  truefalseGSYNCSETUP_SyncContactOption 
    SyncEnabled
    lookup  YesNotruefalseGSYNCSETUP_SyncEnabled 
    SyncFailed
    lookup  YesNotruefalseGSYNCSETUP_SyncFailed 
    SyncFullRefresh
    lookup  YesNotruefalseGSYNCSETUP_SyncFullRefresh 
    SyncPhoto
    lookup  YesNotruefalseGSYNCSETUP_SyncPhoto 
    SyncRecActivity
    lookup  YesNotruefalseGSYNCSETUP_SyncRecActivity 
    SyncTask
    lookup  YesNotruefalseGSYNCSETUP_SyncTask 
    UserID
    integer   truefalseGSYNCSETUP_UserID 
    UserOfficeID
    integer   truefalseGSYNCSETUP_UserOfficeID 
    GsyncHistories
    objects GsyncHistory falsefalseGSYNCSETUP_GSyncID 


    HOContact
    Referred By:
    HOStatusMain.InsuredContactID  HOInterestParty.HOContactID  HOInterestParty.HOContact 
    Main TableData ObjectTopSearchReadonly
    HOCONTACT_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActualContactID
    integer   truefalseHOCONTACT_ActualContactID 
    ActualContactOffID
    integer   truefalseHOCONTACT_ActualContactOffID 
    Age
    integer   truefalseHOCONTACT_Age 
    DateOfBirth
    date   truefalseHOCONTACT_DateOfBirth 
    FirstName
    string30  truefalseHOCONTACT_FirstName 
    Gender
    lookup  GendertruefalseHOCONTACT_Gender 
    HOPendingCaseID
    integer   truefalseHOCONTACT_HOPendingCaseID 
    LastName
    string30  truefalseHOCONTACT_LastName 
    MiddleName
    string30  truefalseHOCONTACT_MiddleName 
    Name
    string128  truefalseHOCONTACT_Name 
    OfficeID
    integer   truefalseHOCONTACT_OfficeID 
    Prefix
    string10  truefalseHOCONTACT_Prefix 
    Suffix
    string10  truefalseHOCONTACT_Suffix 
    TaxId
    string20  truefalseHOCONTACT_TaxId 
    UndWritingRiskClass
    lookup  RiskClasstruefalseHOCONTACT_UndWritingRiskClass 
    ContactID
    id Contact truefalseHOCONTACT_ActualContactID 
    HOStatusMainId
    id HOStatusMain truefalseHOCONTACT_HOPendingCaseID 
    HOStatusMainObj
    object HOStatusMain falsefalseHOCONTACT_HOPendingCaseID 


    HOInterestParty
    Referred By:

    Main TableData ObjectTopSearchReadonly
    HOINTERESTPARTY_TABLEhointerestpartyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ApprovalBasis
    string300  truefalseHOINTERESTPARTY_ApprovalBasis 
    Asof
    date   truefalseHOINTERESTPARTY_AsofAs of date
    FirstName
    string30  truefalseHOINTERESTPARTY_FirstName 
    LastName
    string30  truefalseHOINTERESTPARTY_LastName 
    MiddleName
    string30  truefalseHOINTERESTPARTY_MiddleName 
    Name
    string128  truefalseHOINTERESTPARTY_NameName
    PendingCaseID
    integer   truefalseHOINTERESTPARTY_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table
    Percentage
    double   truefalseHOINTERESTPARTY_PercentagePercentage
    Prefix
    string10  truefalseHOINTERESTPARTY_Prefix 
    Relation
    string128  truefalseHOINTERESTPARTY_RelationRelationship
    Role
    lookup  RoletruefalseHOINTERESTPARTY_RoleRole
    Suffix
    string10  truefalseHOINTERESTPARTY_Suffix 
    HOContact
    object HOContact truefalseHOINTERESTPARTY_ContactID 
    HOContactID
    id HOContact truefalseHOINTERESTPARTY_ContactID 
    HOStatusMainId
    id HOStatusMain truefalseHOINTERESTPARTY_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table
    HOStatusMainObj
    object HOStatusMain falsefalseHOINTERESTPARTY_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table


    HONewBusiness
    Referred By:
    NewBusiness.HONewBusinesses 
    Main TableData ObjectTopSearchReadonly
    HOSTATUSMAIN_TABLEnewbusfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ApprovalDate
    date   falsefalseHOSTATUSMAIN_ApprovalDateApproval date
    CarrierCode
    string30  falsefalseHOSTATUSMAIN_CarrierCodeCarrier code
    CarrierInputDate
    date   falsefalseHOSTATUSMAIN_CarrierInputDateCarrier input date
    CaseID
    string30  falsefalseHOSTATUSMAIN_CaseIDCase ID (SmartOffice policy# equivalent)
    DateStamp
    datetime   falsefalseHOSTATUSMAIN_DateStampDate and time the NAILBA record was inserted
    PlacementExp
    date   falsefalseHOSTATUSMAIN_PlacementExpDelivery expiration date
    UserStamp
    string30  falsefalseHOSTATUSMAIN_UserStampInserts user: DEXAGENT
    HoldingID
    id NewBusiness falsefalseHOSTATUSMAIN_HoldingIDForeign Key -- Link to NEWBUS table


    HORep
    Referred By:
    NewBusiness.HORep 
    Main TableData ObjectTopSearchReadonly
    HOREP_TABLEnewbusfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Contact
    object Contact falsefalseHOREP_HOREPIDPrimary Foreign Key -- Link to CONTACT table
    Vendor
    object Vendor falsefalseHOREP_CarrierIDForeign Key -- Link to VENDOR table
    VendorID
    id Vendor falsefalseHOREP_CarrierIDForeign Key -- Link to VENDOR table


    HOSideBYSideReqs
    Referred By:

    Main TableData ObjectTopSearchReadonly
    HOSIDEBYSIDEREQS_TABLEhostatusfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Associated
    string256  truefalseHOSIDEBYSIDEREQS_AssociatedAssociated
    CarrierCode
    string30  truefalseHOSIDEBYSIDEREQS_CarrierCodeCarrier code
    CaseId
    string15  truefalseHOSIDEBYSIDEREQS_CaseIdCase ID
    Date1
    date   truefalseHOSIDEBYSIDEREQS_Date1 
    DateOrdered
    date   truefalseHOSIDEBYSIDEREQS_DateOrderedDate ordered
    DateReceived
    date   truefalseHOSIDEBYSIDEREQS_DateReceivedDate received
    DateStamp
    datetime   truefalseHOSIDEBYSIDEREQS_DateStampDate Stamp
    ProcessedYN
    lookup  YesNoUnknowntruefalseHOSIDEBYSIDEREQS_ProcessedYNIndicates if processed
    RecordType
    string2  truefalseHOSIDEBYSIDEREQS_RecordTypeRecord type
    ReqComment
    string500  truefalseHOSIDEBYSIDEREQS_ReqCommentRequirement comment
    RequiredOf
    string8  truefalseHOSIDEBYSIDEREQS_RequiredOfRequired of
    RequirementCode
    string30  truefalseHOSIDEBYSIDEREQS_RequirementCodeRequirement code
    Status
    lookup  UnderReqStatustruefalseHOSIDEBYSIDEREQS_Status 
    UserStamp
    string30  truefalseHOSIDEBYSIDEREQS_UserStampUser Stamp


    HOStatusMain
    Referred By:
    HOContact.HOStatusMainObj  HOContact.HOStatusMainId  HOStatusReqs.HOStatusMainObj  HOStatusReqs.HOStatusMainId  HOInterestParty.HOStatusMainObj  HOInterestParty.HOStatusMainId 
    Main TableData ObjectTopSearchReadonly
    HOSTATUSMAIN_TABLEhostatusfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AddlAdvisorID
    string64  truefalseHOSTATUSMAIN_AddlAdvisorID 
    AgencyCaseID
    string15  truefalseHOSTATUSMAIN_AgencyCaseIDCase ID (for NAILBA auxiliary case reference)
    AgentSSNo
    string20  truefalseHOSTATUSMAIN_AgentSSNoAgent SSNo
    Alphanum1
    string128  truefalseHOSTATUSMAIN_Alphanum1 
    Alphanum2
    string128  truefalseHOSTATUSMAIN_Alphanum2 
    ApprovalBasis
    string70  truefalseHOSTATUSMAIN_ApprovalBasisApproval basis
    ApprovalDate
    date   truefalseHOSTATUSMAIN_ApprovalDateApproval date
    BinaryDataId
    integer   truefalseHOSTATUSMAIN_BinaryDataId 
    CarrierAgentID
    string64  truefalseHOSTATUSMAIN_CarrierAgentIDCarrier's agent ID from the file
    CarrierCode
    string30  truefalseHOSTATUSMAIN_CarrierCodeCarrier code
    CarrierInputDate
    date   truefalseHOSTATUSMAIN_CarrierInputDateCarrier input date
    CarrierName
    string250  truetrueHOSTATUSMAIN_CarrierName 
    CaseID
    string30  truefalseHOSTATUSMAIN_CaseIDCase ID (SmartOffice policy# equivalent)
    CaseName
    string30  truefalseHOSTATUSMAIN_CaseNameName of the primary contact for the case
    CaseNbr
    integer   truefalseHOSTATUSMAIN_CaseNbrCase number (for Commerce Agency users)
    CaseProcessed
    lookup  HOProcessStatustruefalseHOSTATUSMAIN_CaseProcessedCase processed yes/no field
    CaseStatus
    lookup  YesNotruetrueHOSTATUSMAIN_CaseStatus 
    CaseType
    lookup  InsProductTypetruefalseHOSTATUSMAIN_CaseType 
    CashWithApp
    double   truefalseHOSTATUSMAIN_CashWithAppAmount of cash received with application
    ClassOfBusiness
    string64  truefalseHOSTATUSMAIN_ClassOfBusinessInsurance type or sub-type
    ClientSSNo
    string20  truefalseHOSTATUSMAIN_ClientSSNoClient social security number
    ClosedStatus
    lookup  YesNotruefalseHOSTATUSMAIN_ClosedStatusCase Closed yes/no
    DateOfBirth
    date   truefalseHOSTATUSMAIN_DateOfBirthDate of birth
    DateStamp
    datetime   truefalseHOSTATUSMAIN_DateStampDate and time the NAILBA record was inserted
    EffDate
    date   truefalseHOSTATUSMAIN_EffDate 
    EventDetails
    text   truefalseHOSTATUSMAIN_EventDetailsHO pending case downloads events
    EventDetailsNotes
    text   truetrueHOSTATUSMAIN_EventDetailsNotes 
    EventDetailsReqs
    text   truetrueHOSTATUSMAIN_EventDetailsReqs 
    FaceAmount
    double   truefalseHOSTATUSMAIN_FaceAmountFace amount
    FirstName
    string64  truefalseHOSTATUSMAIN_FirstName 
    FormatType
    lookup  FormatTypetruefalseHOSTATUSMAIN_FormatType 
    GaID
    string20  truefalseHOSTATUSMAIN_GaIDGeneral agent ID
    Gender
    lookup  GendertruefalseHOSTATUSMAIN_Gender 
    HOCaseType
    string20  truefalseHOSTATUSMAIN_HOCaseType 
    HOReceiptDate
    date   truefalseHOSTATUSMAIN_HOReceiptDate 
    HiddenRecord
    lookup  YesNotruefalseHOSTATUSMAIN_HiddenRecord 
    HoUnderWriter
    string128  truefalseHOSTATUSMAIN_HoUnderWriterHome office underwriter
    HoldingTypeCode
    lookup  HoldingTypetruetrueHOSTATUSMAIN_HoldingTypeCode 
    IgnoreCase
    lookup  YesNoUnknowntruefalseHOSTATUSMAIN_IgnoreCaseIgnore case yes/no field
    IssueAge
    integer   truefalseHOSTATUSMAIN_IssueAge 
    IssueDate
    date   truefalseHOSTATUSMAIN_IssueDate 
    IssueState
    string2  truefalseHOSTATUSMAIN_IssueStateIssue state
    LastActivity
    date   truefalseHOSTATUSMAIN_LastActivityLast Activity Date on the NAILBA record
    LastName
    string200  truefalseHOSTATUSMAIN_LastName 
    MatchedYN
    lookup  HOMatchedUnmatchedtruefalseHOSTATUSMAIN_MatchedYNMatched yes/no field
    Middle
    string40  truefalseHOSTATUSMAIN_Middle 
    ModalPremium
    double   truefalseHOSTATUSMAIN_ModalPremiumModal premium amount
    NewBusinessContact
    string128  truefalseHOSTATUSMAIN_NewBusinessContactHO Rep
    OtherInsured
    string1  truefalseHOSTATUSMAIN_OtherInsuredOther insured yes/no flag
    PaymentMethod
    lookup  PaymentMethodtruefalseHOSTATUSMAIN_PaymentMethod 
    PermFlatExtraAmt
    double   truefalseHOSTATUSMAIN_PermFlatExtraAmt 
    PermTableRating
    string10  truefalseHOSTATUSMAIN_PermTableRating 
    PlacementExp
    date   truefalseHOSTATUSMAIN_PlacementExpDelivery expiration date
    PlanCode
    string40  truefalseHOSTATUSMAIN_PlanCodePlan code
    PlanName
    string255  truefalseHOSTATUSMAIN_PlanName 
    PolicyID
    integer   truefalseHOSTATUSMAIN_PolicyIDPolicy ID (for Commerce Agency users)
    Prefix
    string40  truefalseHOSTATUSMAIN_Prefix 
    PremiumBalanceDue
    double   truefalseHOSTATUSMAIN_PremiumBalanceDuePremium balance due amount
    PremiumMode
    string32  truefalseHOSTATUSMAIN_PremiumModePremium mode
    QuoteID
    integer   truefalseHOSTATUSMAIN_QuoteIDQuote ID (for Commerce Agency users)
    RolloverAmt
    double   truefalseHOSTATUSMAIN_RolloverAmtRollover amount
    ServiceID
    string14  truefalseHOSTATUSMAIN_ServiceIDService ID (for Commerce Agency users)
    SignedDate
    date   truefalseHOSTATUSMAIN_SignedDate 
    SmokerStatus
    lookup  TobaccotruefalseHOSTATUSMAIN_SmokerStatus 
    Status
    string64  truefalseHOSTATUSMAIN_StatusStatus
    SubAdvisorID
    string64  truefalseHOSTATUSMAIN_SubAdvisorID 
    Suffix
    string40  truefalseHOSTATUSMAIN_Suffix 
    TargetPremAmount
    double   truefalseHOSTATUSMAIN_TargetPremAmount 
    TempFlatExtraAmt
    double   truefalseHOSTATUSMAIN_TempFlatExtraAmt 
    TobaccoPremBasis
    lookup  TobaccoPremtruefalseHOSTATUSMAIN_TobaccoPremBasis 
    TransferToPaid
    date   truefalseHOSTATUSMAIN_TransferToPaidTransfer to paid date
    UnderwritingSubClass
    lookup  UnderwritingSubClasstruefalseHOSTATUSMAIN_UnderwritingSubClass 
    UserStamp
    string30  truefalseHOSTATUSMAIN_UserStampInserts user: DEXAGENT
    WritingAgentName
    string70  truefalseHOSTATUSMAIN_WritingAgentNameWriting advisor name
    XMLDATA
    text   truefalseHOSTATUSMAIN_XMLDATAXML data
    InsuredContactID
    id HOContact truefalseHOSTATUSMAIN_InsuredContactID 


    HOStatusNotes
    Referred By:

    Main TableData ObjectTopSearchReadonly
    HOSTATUSNOTES_TABLEhostatusnotesfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    CarrierCode
    string30  truefalseHOSTATUSNOTES_CarrierCodeCarrier code
    CaseID
    string15  truefalseHOSTATUSNOTES_CaseIDCase ID (SmartOffice policy # equivalent)
    DateStamp
    datetime   truefalseHOSTATUSNOTES_DateStampDate and time the NAILBA record was inserted
    EventDetailInt
    integer   truefalseHOSTATUSNOTES_EventDetailIntSpeeds HO pending case download events query
    EventDetails
    text   truefalseHOSTATUSNOTES_EventDetailsHO pending case download events
    NoteAuthor
    string12  truefalseHOSTATUSNOTES_NoteAuthorNote author
    NoteDate
    date   truefalseHOSTATUSNOTES_NoteDateNote date
    PendingCaseID
    integer   truefalseHOSTATUSNOTES_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table
    ProcessedYN
    lookup  YesNoUnknowntruefalseHOSTATUSNOTES_ProcessedYNProcessed yes/no field
    RecordType
    string2  truefalseHOSTATUSNOTES_RecordTypeRecord type
    SegmentNbr
    integer   truefalseHOSTATUSNOTES_SegmentNbrSegment number
    SegmentText
    text   truefalseHOSTATUSNOTES_SegmentTextSegment text
    SegmentType
    string256  truefalseHOSTATUSNOTES_SegmentTypeSegment type
    TextSegmentNbr
    integer   truefalseHOSTATUSNOTES_TextSegmentNbrText segment number
    UserStamp
    string30  truefalseHOSTATUSNOTES_UserStampInserts user: DEXAGENT


    HOStatusReqs
    Referred By:

    Main TableData ObjectTopSearchReadonly
    HOSTATUSREQS_TABLEhostatusreqsfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Associated
    string1  truefalseHOSTATUSREQS_AssociatedAssociated
    CarrierCode
    string30  truefalseHOSTATUSREQS_CarrierCodeCarrier code
    CaseID
    string15  truefalseHOSTATUSREQS_CaseIDCase ID (ECP Policy# equivalent)
    Date1
    date   truefalseHOSTATUSREQS_Date1 
    Date2
    date   truefalseHOSTATUSREQS_Date2 
    DateOrdered
    date   truefalseHOSTATUSREQS_DateOrderedDate ordered
    DateReceived
    date   truefalseHOSTATUSREQS_DateReceivedDate received
    DateStamp
    datetime   truefalseHOSTATUSREQS_DateStampDate and time NAILBA record inserted
    EventDetailInt
    integer   truefalseHOSTATUSREQS_EventDetailIntSpeeds HO pending case download events query
    EventDetails
    text   truefalseHOSTATUSREQS_EventDetailsHO pending case download events
    HORequirementRefID
    string256  falsefalseHOSTATUSREQS_HORequirementRefID 
    HOSBS
    string4  truetrueHOSTATUSREQS_HOSBS 
    PendingCaseID
    integer   truefalseHOSTATUSREQS_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table
    ProcessedYN
    lookup  YesNoUnknowntruefalseHOSTATUSREQS_ProcessedYNProcessed yes/no field
    RecordType
    string2  truefalseHOSTATUSREQS_RecordTypeRecord type
    ReqComment
    string1024  truefalseHOSTATUSREQS_ReqCommentRequirement comment
    ReqContactID
    integer   falsefalseHOSTATUSREQS_ReqContactID 
    ReqUniqueID
    string200  truefalseHOSTATUSREQS_ReqUniqueID 
    Requiredof
    string20  truefalseHOSTATUSREQS_RequiredofPerson required of: Doctor, Insured, Agent
    RequirementCode
    string30  truefalseHOSTATUSREQS_RequirementCodeRequirement code
    RequirementNoteDate
    date   truefalseHOSTATUSREQS_RequirementNoteDateRequirement note date
    SegmentNbr
    integer   truefalseHOSTATUSREQS_SegmentNbrSegment number
    SegmentType
    string2  truefalseHOSTATUSREQS_SegmentTypeSegment type
    SourceTag
    string30  truefalseHOSTATUSREQS_SourceTag 
    Status
    lookup  UnderReqStatustruefalseHOSTATUSREQS_StatusHO Requirement Status in <ReqStatus> XML tag
    TextSegmentNbr
    integer   truefalseHOSTATUSREQS_TextSegmentNbrText segment number
    UserStamp
    string30  truefalseHOSTATUSREQS_UserStampInserts user: DEXAGENT
    HOStatusMainId
    id HOStatusMain truefalseHOSTATUSREQS_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table
    HOStatusMainObj
    object HOStatusMain falsefalseHOSTATUSREQS_PendingCaseIDForeign Key -- Link to HOSTATUSMAIN table


    Homemisc
    Referred By:
    Policy.Homemiscs 
    Main TableData ObjectTopSearchReadonly
    HOMEMISC_TABLE falsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Alpha1
    string80  falsefalseHOMEMISC_Alpha1Optional alphanumeric field
    AnnPrem
    double   falsefalseHOMEMISC_AnnPremAnnual premium
    Code
    string30  falsefalseHOMEMISC_CodeCode
    CovType
    string80  falsefalseHOMEMISC_CovTypeCoverage type
    Date1
    date   falsefalseHOMEMISC_Date1Optional date field
    Descr
    string255  falsefalseHOMEMISC_DescrProperty description
    InsuAmt
    integer   falsefalseHOMEMISC_InsuAmtInsured amount
    Num1
    integer   falsefalseHOMEMISC_Num1Optional numeric field
    OfficeID
    integer   falsefalseHOMEMISC_OfficeIDPrimary Key
    Remark
    string30  falsefalseHOMEMISC_RemarkRemark
    YesNo1
    lookup  YesNofalsefalseHOMEMISC_YesNo1Optional yes/no indicator
    YesNo1Text
    lookuptext   falsetrueHOMEMISC_YesNo1TextYes/No
    PolicyID
    id Policy falsefalseHOMEMISC_HoldingIDForeign Key -- Link to HOLDING table


    Homeown
    Referred By:
    Policy.Homeown 
    Main TableData ObjectTopSearchReadonly
    HOMEOWN_TABLEpolicyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Alarm
    lookup  YesNofalsefalseHOMEOWN_AlarmIndicates alarm installed in dwelling
    AlarmText
    lookuptext   falsetrueHOMEOWN_AlarmText 
    Construction
    lookup  ConstructionfalsefalseHOMEOWN_ConstructionDescription of dwelling construction
    ConstructionText
    lookuptext   falsetrueHOMEOWN_ConstructionText 
    Deductible
    integer   falsefalseHOMEOWN_DeductibleMedical deductible
    Dwelling
    integer   falsefalseHOMEOWN_DwellingAmount of coverage for insured residence
    EqDed
    string30  falsefalseHOMEOWN_EqDedEarthquake deductible
    Floater
    string40  falsefalseHOMEOWN_FloaterType of endorsement that covers minor articles
    FloodDed
    string30  falsefalseHOMEOWN_FloodDedFlood deductible
    GuarReplace
    lookup  YesNofalsefalseHOMEOWN_GuarReplaceIndicates will pay amt. regardless of cost
    GuarReplaceText
    lookuptext   falsetrueHOMEOWN_GuarReplaceText 
    Liability
    integer   falsefalseHOMEOWN_LiabilityAmount of liability coverage provided by policy
    Location
    string60  falsefalseHOMEOWN_LocationLocation of the home
    LossOfUse
    integer   falsefalseHOMEOWN_LossOfUseAmount of coverage for loss of use (hotel room)
    MedicalPay
    integer   falsefalseHOMEOWN_MedicalPayAmount of medical coverage provided by policy
    ModifiedOn
    datetime   truefalseHOMEOWN_ModifiedOnDate of last modification
    Mortgee1
    string80  falsefalseHOMEOWN_Mortgee1Coverage for the first mortgage holder
    Mortgee2
    string80  falsefalseHOMEOWN_Mortgee2Coverage of the second mortgage holder
    OtherStructure
    integer   falsefalseHOMEOWN_OtherStructureAmount of coverage for an additional structure
    PersProperty
    integer   falsefalseHOMEOWN_PersPropertyAmount of coverage for personal property
    PropDamage
    double   falsefalseHOMEOWN_PropDamageMaximum allowable coverage for property damage
    ProtClass
    short   falsefalseHOMEOWN_ProtClassClass assigned to city of residence
    Replacement
    lookup  YesNofalsefalseHOMEOWN_ReplacementIndicates will pay amt. needed to cover loss
    ReplacementText
    lookuptext   falsetrueHOMEOWN_ReplacementText 
    Roof
    lookup  RooffalsefalseHOMEOWN_RoofRoof Type choice field
    RoofText
    lookuptext   falsetrueHOMEOWN_RoofText 
    Squarefeet
    short   falsefalseHOMEOWN_SquarefeetSquare feet of structure
    Territory
    string30  falsefalseHOMEOWN_TerritoryDescription of the territory where dwelling is
    YearBuilt
    short   falsefalseHOMEOWN_YearBuiltYear the structure was built


    Hospital
    Referred By:
    UnderReq.Hospital  UnderReq.HospitalID 
    Main TableData ObjectTopSearchReadonly
    CONTACT_HOSPITAL_ALIAShospitalfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    FirstName
    string64  truefalseHOSPITAL_FirstName 
    Greeting
    lookup  RecordTypefalsefalseHOSPITAL_RecordType 
    LastName
    string200  truefalseHOSPITAL_LastName 
    MiddleName
    string40  falsefalseHOSPITAL_MiddleName 
    Addresses
     Address   
    PreferredAddress
    object Address falsefalseHOSPITAL_PreferredAddrID 
    Phones
     Phone   
    PreferredPhone
    object Phone falsefalseHOSPITAL_PreferredPhoneID 
    PreferredWebAddress
     WebAddress   
    WebAddresses
     WebAddress   


    HouseHold
    Referred By:
    RiskAssignment.HouseholdID  RiskAssignment.Household  SmartPad.HouseHold  SmartPad.HouseHoldID  HouseHoldMember.HouseholdID  HouseHoldMember.HouseHold  SmartPadArchive.HouseHold  SmartPadArchive.HouseHoldID  RelatedContact.HouseHolds  Contact.HouseHold  Contact.HouseHolds 
    Main TableData ObjectTopSearchReadonly
    HOUSEHOLD_TABLEhouseholdtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Anniversary
    date   truefalseHOUSEHOLD_Anniversary 
    HouseholdID
    integer   falsefalseHOUSEHOLD_HouseholdIDPrimary Key
    Income
    double   falsefalseHOUSEHOLD_IncomeHousehold total income
    IncomeRange
    lookup  IncomeRangefalsefalseHOUSEHOLD_IncomeRangeHousehold income range
    ModifiedOn
    datetime   truefalseHOUSEHOLD_ModifiedOnDate household last modified
    MonthMortgageRent
    double   falsefalseHOUSEHOLD_MonthMortgageRentHousehold total monthly mortgage or rent
    Name
    string64  truefalseHOUSEHOLD_NameHousehold name, usually by last name
    NetWorth
    double   falsefalseHOUSEHOLD_NetWorthHousehold total net worth
    NetWorthRange
    lookup  NetWorthRangefalsefalseHOUSEHOLD_NetWorthRangeHousehold net worth range
    OwnOrRent
    lookup  YesNofalsefalseHOUSEHOLD_OwnOrRentWhether the home is rented or owned
    Propensity
    string32  truefalseHOUSEHOLD_PropensityPropensity
    Rating
    string64 HouseholdRatingtruefalseHOUSEHOLD_RatingRating
    Salutation
    string120  truefalseHOUSEHOLD_SalutationSalutation for the household
    SourceOfDataType
    lookup  SourceOfDatatruefalseHOUSEHOLD_SourceOfDataType 
    PrimaryAddress
    object Address falsefalseHOUSEHOLD_PrimaryAddressIDForeign Key -- Link to ADDRESS table
    Contact
    object Contact falsefalseHOUSEHOLD_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact truefalseHOUSEHOLD_ContactIDForeign Key -- Link to CONTACT table
    CustomData
     CustomData   
    HouseHoldMembers
    objects HouseHoldMember falsefalseHOUSEHOLD_HouseholdIDPrimary Key


    HouseHoldMember
    Referred By:
    HouseHold.HouseHoldMembers  Contact.HouseHoldMembers 
    Main TableData ObjectTopSearchReadonly
    HOUSEHOLDMEMBERS_TABLEhouseholdmembertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Member
    lookup  HouseMembertruefalseHOUSEHOLDMEMBERS_HouseMemberHousehold members
    MemberText
    lookuptext   falsetrueHOUSEHOLDMEMBERS_HouseMemberText 
    ModifiedOn
    datetime   truefalseHOUSEHOLDMEMBERS_ModifiedOnHousehold member last modified on date
    Primary
    byte  YesNofalsetrueHOUSEHOLDMEMBERS_Primary 
    Contact
    object Contact falsefalseHOUSEHOLDMEMBERS_ContactIDPrimary Foreign Key -- Link to CONTACT table
    ContactID
    id Contact falsefalseHOUSEHOLDMEMBERS_ContactIDPrimary Foreign Key -- Link to CONTACT table
    HouseHold
    object HouseHold falsefalseHOUSEHOLDMEMBERS_HouseholdID 
    HouseholdID
    id HouseHold falsefalseHOUSEHOLDMEMBERS_HouseholdID 


    IRole
    Referred By:

    Main TableData ObjectTopSearchReadonly
    USERROLE_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    RoleID
    integer   truefalseUSERROLE_ROLEIDPrimary Key
    User
    object User falsefalseUSERROLE_UserIDPrimary Foreign Key -- Link to APPUSER table
    UserID
    id User truefalseUSERROLE_UserIDPrimary Foreign Key -- Link to APPUSER table


    ISMember
    Referred By:

    Main TableData ObjectTopSearchReadonly
    ISMEMBER_TABLEismembertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ContactID
    integer   falsefalseISMEMBER_CONTACTIDContactID
    ContactOfficeID
    integer   truefalseISMEMBER_CONTACTOFFICEIDofficeid of the contact to be used in case of contact sharing
    ModifiedOn
    datetime   truefalseISMEMBER_MODIFIEDON 
    Status
    lookup  ISMember_StatustruefalseISMEMBER_STATUSStatus
    UserID
    id User truefalseISMEMBER_APPUSERIDAppUser ID.


    ISSubscription
    Referred By:

    Main TableData ObjectTopSearchReadonly
    ISSUBSCRIPTION_TABLEissubscriptiontruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ActModified
    byte   truefalseISSUBSCRIPTION_ACTMODIFIEDActivity Modified Flag.
    ActNextDays
    integer   truefalseISSUBSCRIPTION_ACTNEXTDAYSFuture days to sync Activity
    ActPrevDays
    integer   truefalseISSUBSCRIPTION_ACTPREVDAYSPrevious days to sync Activity
    LastSyncTime
    datetime   truefalseISSUBSCRIPTION_LASTSYNCTIMEIntellisync Last Sync Time.
    OfficeID
    integer   truefalseISSUBSCRIPTION_OFFICEID 
    TODOLastSyncTime
    datetime   truefalseISSUBSCRIPTION_TODOLASTSYNCTIMELast Sync Time for TODO.
    TODOModified
    byte   truefalseISSUBSCRIPTION_TODOMODIFIEDTODO Modified Status.
    Set
    object Set falsefalseISSUBSCRIPTION_SETIDset ID.
    SetID
    id Set truefalseISSUBSCRIPTION_SETIDset ID.
    User
    object User falsefalseISSUBSCRIPTION_APPUSERIDAppUser ID
    UserID
    id User truefalseISSUBSCRIPTION_APPUSERIDAppUser ID


    Illustration
    Referred By:
    ProposalTracking.Illustrations 
    Main TableData ObjectTopSearchReadonly
    ILLUSTRATION_TABLEillustrationtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    BasicFace
    double   falsefalseILLUSTRATION_BasicFaceBasic face amount of illustration
    Closed
    date   falsefalseILLUSTRATION_ClosedDate illustration was closed
    HoldingSubtype
    lookup  InsProductTypefalsefalseILLUSTRATION_HoldingSubtype 
    HoldingType
    lookup  HoldingTypefalsefalseILLUSTRATION_HoldingType 
    Notes
    string255  falsefalseILLUSTRATION_NotesIllustration notes
    PremMode
    lookup  PremModefalsefalseILLUSTRATION_PremModePremium mode on illustration
    Premium
    double   falsefalseILLUSTRATION_PremiumPremium on illustration
    SentToPCM
    date   falsefalseILLUSTRATION_SentToPCMDate illustration was sent to PCM module
    TaxType
    lookup  TaxTypefalsefalseILLUSTRATION_TaxType 
    Carrier
    object ContactVendor falsefalseILLUSTRATION_CarrierIdForeign Key -- Link to CONTACT table
    CarrierID
    id ContactVendor falsefalseILLUSTRATION_CarrierIdForeign Key -- Link to CONTACT table
    Image
    object Image falsefalseILLUSTRATION_ImageIdForeign Key -- Link to IMAGE table
    RiskClass
    object ProdRiskClass falsefalseILLUSTRATION_ProductRiskIdForeign Key -- Link to PRODRISKCLASS table
    RiskClassID
    id ProdRiskClass falsefalseILLUSTRATION_ProductRiskIdForeign Key -- Link to PRODRISKCLASS table
    Product
    object Product falsefalseILLUSTRATION_ProductIdForeign Key -- Link to PRODUCT table
    ProductID
    id Product falsefalseILLUSTRATION_ProductIdForeign Key -- Link to PRODUCT table
    ProposalID
    id ProposalTracking truefalseILLUSTRATION_ProposalIdForeign Key -- Link to PROPOSALTRACKING table


    Image
    Referred By:
    Illustration.Image  DynReport.ImageID  DynReport.Image  ProposalTracking.ImageID  ProposalTracking.Image  Office.BrandImage  Office.BrandImgID  Essyncreport.ImageId  Contact.Image  Contact.PhotoID 
    Main TableData ObjectTopSearchReadonly
    IMAGE_TABLEimagetruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Category
    lookup  ImageCategoryfalsefalseIMAGE_CategoryImage category
    ContactOfficeID
    integer   truefalseIMAGE_ContactOfficeID 
    CreatedOn
    datetime   truefalseIMAGE_CreatedOnDate image was created
    Description
    string75  falsefalseIMAGE_DescriptionDescription
    Details
    string768  truefalseIMAGE_Details 
    Exclusive
    lookup  ExlUserTypefalsefalseIMAGE_ExclusiveExclusivity: all users, advisors only, ClientVu
    ImageData
    dtImage   falsefalseIMAGE_ImageDataImage data
    ImageSize
    integer   falsefalseIMAGE_ImageSize 
    IsCompressed
    byte  YesNofalsefalseIMAGE_IsCompressed 
    Keyword
    string75 KeywordsActivityfalsefalseIMAGE_KeywordKeyword
    link   truefalseIMAGE_LinkIDPrimary key of the table referenced
    LinkOfficeId
    integer   truefalseIMAGE_LinkOfficeId 
    LinkTable
    integer   truefalseIMAGE_LinkTablePrimary table referenced
    LinkType
    lookup  LinkTypetruefalseIMAGE_LinkTypeLink type, i.e., linked or embedded
    MimeType
    string256  falsefalseIMAGE_MIMETypeMIME type
    OfficeID
    integer   falsefalseIMAGE_OfficeIDPrimary Key
    Private
    lookup  YesNofalsefalseIMAGE_PrivateDocument MIME type
    URL
    string256  falsefalseIMAGE_DocumentUrlThe URL of the document
    ContactID
    id Contact falsefalseIMAGE_ContactIDForeign Key -- Link to CONTACT table
    CreatedBy
    id User truefalseIMAGE_CreatedByForeign Key -- Link to APPUSER table


    InsProduct
    Referred By:
    Product.InsProduct 
    Main TableData ObjectTopSearchReadonly
    INSPRODUCT_TABLEproductfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AppAge
    lookup  AppAgefalsefalseINSPRODUCT_AppAgeIndicates how age is calculated (last/nearest)
    Effective
    date   falsefalseINSPRODUCT_EffectiveProduct effective date
    Expiration
    date   falsefalseINSPRODUCT_ExpirationProduct expiration date
    FeeCommissionable
    lookup  YesNofalsefalseINSPRODUCT_FeeCommCommissionable policy fee? (not used)
    InsProductSubType
    lookup  ProductSubtypefalsefalseINSPRODUCT_SubtypeInsurance sub-type
    InsProductSubTypeText
    string256  falsetrueINSPRODUCT_SubTypeText 
    InsProductType
    lookup  InsProductTypetruefalseINSPRODUCT_TypeType for Life type products
    MultiLife
    byte  YesNofalsefalseINSPRODUCT_MultiLifeIndicates a MultiLife product
    Rider
    lookup  RiderProducttruefalseINSPRODUCT_RiderIs this a rider product? yes/no field
    ProductExt
    object ProductExt falsefalseINSPRODUCT_ProductIDPrimary Foreign Key -- Link to PRODUCT table


    InterestParty
    Referred By:
    Policy.PrimaryInsuredParty  Policy.PrimaryInterestParty  Policy.InterestParties  Policy.PrimaryAdvisorParty 
    Main TableData ObjectTopSearchReadonly
    INTERESTPARTY_TABLEpolclienttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Age
    short   truefalseINTERESTPARTY_AgeIssue age
    CaseModifiedOn
    datetime   truefalseINTERESTPARTY_CASEMODIFIEDON 
    CurrentRiskClass
    string128  falsefalseINTERESTPARTY_CurrentRiskClass 
    InterestPercent
    double   falsefalseINTERESTPARTY_InterestPercentInterested parties' percentage in the policy
    MktManager
    string64 MktMgrfalsefalseINTERESTPARTY_MktManagerMarketing manager
    ModifiedOn
    datetime   truefalseINTERESTPARTY_ModifiedOnDate last modified
    Name
    string300  truefalseINTERESTPARTY_NameContact name
    OfficeCode
    string64 OffCodefalsefalseINTERESTPARTY_OfficeCodeOffice code
    PartyContactID
    integer   falsefalseINTERESTPARTY_ContactIDForeign Key -- Link to CONTACT table
    PartyRole
    lookup  RoletruefalseINTERESTPARTY_PartyRoleRole of the client
    PartyRoleText
    lookuptext   falsetrueINTERESTPARTY_PartyRoleText 
    ProductClassID
    integer   falsefalseINTERESTPARTY_ProdClassIdForeign Key -- Link to PRODRISKCLASS table
    RegionCode
    string64 RegionCodefalsefalseINTERESTPARTY_RegionCodeRegion code
    Relation
    string100 InterestpartyRelationfalsefalseINTERESTPARTY_RelationRelationship to the primary contact
    Remarks
    string1024  falsefalseINTERESTPARTY_RemarksInterested party remarks
    RoleAsOfDate
    date   falsefalseINTERESTPARTY_RoleAsOfDateDate interested party is active on the policy
    RoleExpireDate
    date   falsefalseINTERESTPARTY_RoleExpireDateDate interested party is inactive on the policy
    SaveAge
    short   truefalseINTERESTPARTY_SaveAge 
    TotalPercent
    double   falsetrueINTERESTPARTY_TotalPercent 
    Address
    object Address falsefalseINTERESTPARTY_AddressIDForeign Key -- Link to ADDRESS table
    AddressId
    id Address falsefalseINTERESTPARTY_AddressIDForeign Key -- Link to ADDRESS table
    AdvContract
    object AdvContract falsefalseINTERESTPARTY_ADVCONTRACTIDForeign Key -- Link to ADVCONTRACT table
    AdvContractID
    id AdvContract truefalseINTERESTPARTY_ADVCONTRACTIDForeign Key -- Link to ADVCONTRACT table
    Contact
    object Contact falsefalseINTERESTPARTY_ContactIDForeign Key -- Link to CONTACT table
    ContactID
    id Contact falsefalseINTERESTPARTY_ContactIDForeign Key -- Link to CONTACT table
    Policy
    object Policy falsefalseINTERESTPARTY_HoldingIDForeign Key -- Link to HOLDING table
    PolicyID
    id Policy truefalseINTERESTPARTY_HoldingIDForeign Key -- Link to HOLDING table
    DeliveryProdRiskClass
    object ProdRiskClass falsefalseINTERESTPARTY_HOProdClassIdForeign Key -- Link to PRODRISKCLASS table
    DeliveryProdRiskClassID
    id ProdRiskClass falsefalseINTERESTPARTY_HOProdClassIdForeign Key -- Link to PRODRISKCLASS table
    HOProdClassID
    id ProdRiskClass falsefalseINTERESTPARTY_HOProdClassIdForeign Key -- Link to PRODRISKCLASS table
    ProdRiskClass
    object ProdRiskClass falsefalseINTERESTPARTY_ProdClassIdForeign Key -- Link to PRODRISKCLASS table
    ProdRiskClassID
    id ProdRiskClass falsefalseINTERESTPARTY_ProdClassIdForeign Key -- Link to PRODRISKCLASS table
    HORatingID
    id Rating falsefalseINTERESTPARTY_HORatingIDForeign Key -- Link to RATING table
    IssuedRating
    object Rating falsefalseINTERESTPARTY_HORatingIDForeign Key -- Link to RATING table
    ProposedRating
    object Rating falsefalseINTERESTPARTY_RatingIdForeign Key -- Link to RATING table
    RatingId
    id Rating falsefalseINTERESTPARTY_RatingIdForeign Key -- Link to RATING table


    InvCommLoadHdr
    Referred By:

    Main TableData ObjectTopSearchReadonly
    COMMINVLOADHDR_TABLEinvcommloadhdrtruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription


    InvPortfolio
    Referred By:
    RiskAssignment.InvPortfolioId  RiskAssignment.InvPortfolio 
    Main TableData ObjectTopSearchReadonly
    INVPORTFOLIO_TABLEcdsDeffalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AlphaNum1
    string40  falsefalseINVPORTFOLIO_AlphaNum1 
    AlphaNum2
    string40  falsefalseINVPORTFOLIO_AlphaNum2 
    AlphaNum3
    string40  falsefalseINVPORTFOLIO_AlphaNum3 
    AlphaNum4
    string40  falsefalseINVPORTFOLIO_AlphaNum4 
    CurrentValue
    double   falsefalseINVPORTFOLIO_CurrentValue 
    Date1
    date   falsefalseINVPORTFOLIO_Date1 
    Date2
    date   falsefalseINVPORTFOLIO_Date2 
    Goal
    double   falsefalseINVPORTFOLIO_Goal 
    LoanBalance
    double   falsefalseINVPORTFOLIO_LoanBalance 
    Name
    string512  falsefalseINVPORTFOLIO_Name 
    NetValue
    double   falsefalseINVPORTFOLIO_NetValue 
    Numeric1
    double   falsefalseINVPORTFOLIO_Numeric1 
    Numeric2
    double   falsefalseINVPORTFOLIO_Numeric2 
    Purpose
    string128  falsefalseINVPORTFOLIO_Purpose 
    Remarks
    string512  falsefalseINVPORTFOLIO_Remarks 
    CreatedBy
    object User truefalseINVPORTFOLIO_CreatedBy 
    CreatedById
    id User truefalseINVPORTFOLIO_CreatedBy 
    ModifiedBy
    object User truefalseINVPORTFOLIO_ModifiedBy 
    ModifiedById
    id User truefalseINVPORTFOLIO_ModifiedBy 


    InvestTicker
    Referred By:

    Main TableData ObjectTopSearchReadonly
    INVESTTICKERDATA_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    TickerData
    string4000  truefalseINVESTTICKERDATA_TickerData 


    LAEType
    Referred By:
    Appointments.LAETypes 
    Main TableData ObjectTopSearchReadonly
    LAETYPE_TABLELAETypetruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    LOB
    lookup  InsuranceTypetruefalseLAETYPE_LOBLOB (Line of Business) Type choice field
    link   falsefalseLAETYPE_LinKIdForeign Key -- Link to LICENSE table
    LinkID
    integer   truefalseLAETYPE_LinKIdForeign Key -- Link to LICENSE table
    LinkTable
    integer   truefalseLAETYPE_LinkTablePrimary table referenced
    OfficeID
    integer   truefalseLAETYPE_OfficeIDPrimary Foreign Key -- Link to OFFICE table
    LinkIDID
    id Appointments falsefalseLAETYPE_LinKIdForeign Key -- Link to LICENSE table


    LTC
    Referred By:
    Policy.LTC 
    Main TableData ObjectTopSearchReadonly
    LTC_TABLEpolicyfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AddLTC
    string45  falsefalseLTC_AddLTCAdditional LTC coverage
    AutoInc
    string45  falsefalseLTC_AutoIncAutomatic increase in benefits
    BenefitLength
    string25 BenefitLengthfalsefalseLTC_BenefitLengthBenefit Length
    CovSelection
    lookup  CovSelectionfalsefalseLTC_CovSelectionCoverage Selection
    Daily1
    double   falsefalseLTC_Daily1Nursing home maximum daily benefit
    Daily2
    double   falsefalseLTC_Daily2Home care maximum daily benefit
    Elimination1
    string45  falsefalseLTC_Elimination1Nursing home elimination period
    Elimination2
    string45  falsefalseLTC_Elimination2Home care elimination period
    HosPrd
    string45  falsefalseLTC_HosPrdRequired hospital period
    LifeTime1
    double   falsefalseLTC_LifeTime1Nursing home maximum lifetime benefit
    LifeTime2
    double   falsefalseLTC_LifeTime2Home care maximum lifetime
    ModifiedOn
    datetime   truefalseLTC_ModifiedOnDate of last modification
    MonthlyBenifit1
    double   falsefalseLTC_MonthlyBenifit1Nursing home maximum monthly benefit
    MonthlyBenifit2
    double   falsefalseLTC_MonthlyBenifit2Home care maximum monthly benefit
    OtherLTC
    string45  falsefalseLTC_OtherLTCOther coverage
    TaxType
    lookup  TaxTypefalsefalseLTC_TaxTypeTax type choice field
    UnlDaily1
    lookup  YesNofalsefalseLTC_UnlDaily1Unlimited nursing home daily benefit
    UnlDaily2
    lookup  YesNofalsefalseLTC_UnlDaily2Unlimited home care daily benefit
    UnlLifeTime1
    lookup  YesNofalsefalseLTC_UnlLifeTime1Unlimited nursing home lifetime benefit
    UnlLifeTime2
    lookup  YesNofalsefalseLTC_UnlLifeTime2Unlimited home care lifetime benefit
    UnlMonthly1
    lookup  YesNofalsefalseLTC_UnlMonthly1Unlimited nursing home monthly benefit
    UnlMonthly2
    lookup  YesNofalsefalseLTC_UnlMonthly2Unlimited home care monthly benefit


    LUAccountNum
    Referred By:
    AcctMaster.LUAccountNum 
    Main TableData ObjectTopSearchReadonly
    LUACCOUNTNUM_TABLEacctmastertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    SrcAdminSystem
    string30  truefalseLUACCOUNTNUM_SRCADMINSYSTEMAccount number
    AcctMasterID
    id AcctMaster falsefalseLUACCOUNTNUM_ACCTMASTERIDPrimary Foreign Key -- Link to ACCTMASTER table


    LUHOClientID
    Referred By:
    RelatedContact.LUHOClientID  Contact.LUHOClientID 
    Main TableData ObjectTopSearchReadonly
    LUHOCLIENTID_TABLEcontactfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    HOClientID
    string50  truefalseLUHOCLIENTID_HOCLIENTIDHO client ID of contact
    Contact
    object Contact falsefalseLUTAXID_CONTACTIDPrimary Foreign Key -- Link to PRODUCT table
    ContactID
    id Contact falsefalseLUHOCLIENTID_CONTACTIDPrimary Foreign Key -- Link to CONTACT table


    LUTaxID
    Referred By:
    RelatedContact.LUTaxID  Contact.LUTaxID 
    Main TableData ObjectTopSearchReadonly
    LUTAXID_TABLEcontactfalsetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    TaxID
    string20  truefalseLUTAXID_TAXIDTax ID
    Contact
    object Contact falsefalseLUTAXID_CONTACTIDPrimary Foreign Key -- Link to PRODUCT table
    ContactID
    id Contact falsefalseLUTAXID_CONTACTIDPrimary Foreign Key -- Link to PRODUCT table


    LastActive
    Referred By:

    Main TableData ObjectTopSearchReadonly
    LASTACTIVE_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    LastActiveDT
    datetime   truefalseLASTACTIVE_LastActiveDTDate and time information
    LinkID
    link   falsefalseLASTACTIVE_LinkRecordIDForeign Key -- Link to CONTACT table
    LinkOfficeID
    integer   truefalseLASTACTIVE_LinkOfficeIDForeign Key -- Link to CONTACT table
    LinkRecordID
    integer   falsefalseLASTACTIVE_LinkRecordIDForeign Key -- Link to CONTACT table
    LinkTableId
    integer   truefalseLASTACTIVE_LinkTableId 
    ModuleId
    integer   truefalseLASTACTIVE_ModuleId 
    OfficeID
    integer   truetrueLASTACTIVE_OfficeIDPrimary Key
    AppUserID
    id User truefalseLASTACTIVE_AppsuserIDForeign Key -- Link to APPUSER table


    LayoutDescription
    Referred By:
    LayoutSubscription.LayoutDescID  LayoutSubscription.LayoutDesc 
    Main TableData ObjectTopSearchReadonly
    LAYOUTDESC_TABLElayoutdesctruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    LayoutDesc
    text   truefalseLAYOUTDESC_LayoutDesc 
    ModuleId
    integer   truefalseLAYOUTDESC_ModuleId 
    RecordType
    integer   truefalseLAYOUTDESC_RecordType 
    SearchCondition
    integer   truefalseLAYOUTDESC_SearchCondition 
    TemplateName
    string128  truefalseLAYOUTDESC_TemplateName 
    User
    object User truefalseLAYOUTDESC_CreatedById 
    UserID
    id User truefalseLAYOUTDESC_CreatedById 


    LayoutSubscription
    Referred By:

    Main TableData ObjectTopSearchReadonly
    LAYOUTSUBSCRIPTION_TABLEcdsDeftruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    RecordType
    integer   truefalseLAYOUTSUBSCRIPTION_RecordType 
    SearchCondition
    integer   truefalseLAYOUTSUBSCRIPTION_SearchCondition 
    SubModuleId
    integer   truefalseLAYOUTSUBSCRIPTION_SubModuleId 
    LayoutDesc
    object LayoutDescription truefalseLAYOUTSUBSCRIPTION_LayoutDescId 
    LayoutDescID
    id LayoutDescription truefalseLAYOUTSUBSCRIPTION_LayoutDescId 
    SubscribedBy
    object User truefalseLAYOUTSUBSCRIPTION_SubscribedById 
    SubscribedById
    id User truefalseLAYOUTSUBSCRIPTION_SubscribedById 


    Lead
    Referred By:
    LeadPersonal.LeadID 
    Main TableData ObjectTopSearchReadonly
    LEADS_TABLEleadstruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    ClientNeed1
    lookup  CampaignClientNeedfalsefalseLEADS_ClientNeed1Client need 1
    ClientNeed1Text
    lookuptext   falsetrueLEADS_ClientNeed1TextResidence address ZIP Code
    ClientNeed2
    lookup  CampaignClientNeedfalsefalseLEADS_ClientNeed2Client need 2
    ClientNeed2Text
    lookuptext   falsetrueLEADS_ClientNeed2TextBusiness address line 1
    ClientNeed3
    lookup  CampaignClientNeedfalsefalseLEADS_ClientNeed3Client need 3
    ClientNeed3Text
    lookuptext   falsetrueLEADS_ClientNeed3TextBusiness address line 2
    ClientNeed4
    lookup  CampaignClientNeedfalsefalseLEADS_ClientNeed4Client need 4
    ClientNeed4Text
    lookuptext   falsetrueLEADS_ClientNeed4TextBusiness address line 3
    ContactExists
    byte  YesNofalsefalseLEADS_ContactExistsContact Exists yes/no field
    ContactTitle
    string40  falsefalseLEADS_ContactTitleLead's title, e.g., Dr., Mr.
    CreatedOn
    datetime   falsefalseLEADS_CreatedOnDate lead created
    DataState
    lookup  LeadDataStatefalsefalseLEADS_DataStateData state
    DistributionType
    lookup  LeadsDistributionTypefalsefalseLEADS_DistributionTypeDistribution type choice field
    Employer
    string128  falsefalseLEADS_EmployerLead's current employer
    ExternalLeadsID
    string64  truefalseLEADS_ExternalLeadsIDLead's ID from other databases
    FirstName
    string64  falsefalseLEADS_FirstNameLead's first name
    FollowUp
    integer   falsefalseLEADS_FollowUpLead follow-up in days if no action by advisor User
    Greeting
    string40  falsefalseLEADS_GreetingLead's greeting name
    HOClientID
    string50  truefalseLEADS_HOClientIDHome office client ID
    LastName
    string200  falsefalseLEADS_LastNameLead's last name
    LeadType
    lookup  LeadTypetruefalseLEADS_LeadTypeType of Lead choice field
    MiddleName
    string40  falsefalseLEADS_MiddleNameLead's middle name
    Name
    string120  falsetrueLEADS_NameLead's salary
    Needs
    string256  falsetrueLEADS_Needs 
    Potential
    integer   falsefalseLEADS_PotentialLead's potential
    PriorityLead
    lookup  YesNofalsefalseLEADS_PriorityLeadPriority Lead yes/no field
    Qualified
    integer  LeadStagefalsefalseLEADS_QualifiedQualified lead
    Remarks
    string400  falsefalseLEADS_RemarksRemarks
    Score
    integer   truefalseLEADS_ScoreStrength of lead
    Source
    string64  falsefalseLEADS_SourceLead's source
    Stage
    lookup  LeadStagetruefalseLEADS_StageStage choice field
    Status
    lookup  LeadStatustruefalseLEADS_StatusLead status choice field
    StatusDate
    datetime   falsefalseLEADS_StatusDateLead status date
    StatusText
    lookuptext   falsetrueLEADS_StatusText 
    SubSource
    string50  falsefalseLEADS_SubSourceSub-source
    Suffix
    string40  falsefalseLEADS_SuffixLead's suffix, e.g., Jr., Ph.D.
    TaxID
    string20  falsefalseLEADS_TaxIDLead's tax ID or SSN
    CampaignID
    id Campaign truefalseLEADS_CampaignIDForeign Key -- Link to CAMPAIGN table
    CustomData
     CustomData   
    LeadPersonal
     LeadPersonal   
    OfficeID
    id Office truefalseLEADS_OfficeIDPrimary Foreign Key -- Link to OFFICE table
    CreatedByID
    id User truefalseLEADS_CreatedByForeign Key -- Link to APPUSER table
    UserID
    id User truefalseLEADS_AppuserIDForeign Key -- Link to APPUSER table


    LeadPersonal
    Referred By:
    Lead.LeadPersonal 
    Main TableData ObjectTopSearchReadonly
    LEADSPERSONAL_TABLEleadstruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Age
    integer   falsefalseLEADSPERSONAL_AgeLead's age
    BusAreaCode
    string6  falsefalseLEADSPERSONAL_BusAreaCodeBusiness phone area code
    BusCity
    string90  falsefalseLEADSPERSONAL_BusCityBusiness address city
    BusCountry
    string45  falsefalseLEADSPERSONAL_BusCountryBusiness address country
    BusDialNumber
    string14  falsefalseLEADSPERSONAL_BusDialNumberBusiness phone number
    BusLine1
    string90  falsefalseLEADSPERSONAL_BusLine1Business address line 1
    BusLine2
    string90  falsefalseLEADSPERSONAL_BusLine2Business address line 2
    BusLine3
    string90  falsefalseLEADSPERSONAL_BusLine3Business address line 3
    BusLine4
    string90  falsefalseLEADSPERSONAL_BusLine4Business address line 4
    BusLine5
    string90  falsefalseLEADSPERSONAL_BusLine5Business address line 5
    BusState
    string30  falsefalseLEADSPERSONAL_BusStateBusiness address state
    BusZip
    string15  falsefalseLEADSPERSONAL_BusZipBusiness address ZIP Code
    DOB
    date   falsefalseLEADSPERSONAL_DOBLead's date of birth
    EmailAddress
    string120  falsefalseLEADSPERSONAL_EmailAddressLead's e-mail address
    Gender
    lookup  GenderfalsefalseLEADSPERSONAL_GenderLead's gender
    GenderText
    lookuptext   falsetrueLEADSPERSONAL_GenderText 
    JobTitle
    string128  falsefalseLEADSPERSONAL_JobTitleLead's job title
    Marital
    lookup  MaritalfalsefalseLEADSPERSONAL_MaritalLead's marital status
    MaritalText
    lookuptext   falsetrueLEADSPERSONAL_MaritalText 
    Occupation
    string64  falsefalseLEADSPERSONAL_OccupationLead's occupation
    ResAreaCode
    string6  falsefalseLEADSPERSONAL_ResAreaCodeResidence phone area code
    ResCity
    string90  falsefalseLEADSPERSONAL_ResCityResidence address city
    ResCountry
    string45  falsefalseLEADSPERSONAL_ResCountryResidence address country
    ResDialNumber
    string14  falsefalseLEADSPERSONAL_ResDialNumberResidence phone number
    ResLine1
    string90  falsefalseLEADSPERSONAL_ResLine1Residence address line 1
    ResLine2
    string90  falsefalseLEADSPERSONAL_ResLine2Residence address line 2
    ResLine3
    string90  falsefalseLEADSPERSONAL_ResLine3Residence address line 3
    ResLine4
    string90  falsefalseLEADSPERSONAL_ResLine4Residence address line 4
    ResLine5
    string90  falsefalseLEADSPERSONAL_ResLine5Residence address line 5
    ResState
    string30  falsefalseLEADSPERSONAL_ResStateResidence address state
    ResZip
    string15  falsefalseLEADSPERSONAL_ResZipResidence address ZIP Code
    SAge
    integer   falsefalseLEADSPERSONAL_SAgeSpouse's age
    SContactTitle
    string40  falsefalseLEADSPERSONAL_SContactTitleSpouse's title
    SDOB
    date   falsefalseLEADSPERSONAL_SDOBSpouse's birth date
    SEmailAddress
    string120  falsefalseLEADSPERSONAL_SEmailAddressSpouse's e-mail address
    SEmployer
    string128  falsefalseLEADSPERSONAL_SEmployerSpouse's employer
    SFirstName
    string64  falsefalseLEADSPERSONAL_SFirstNameSpouse's first name
    SGreeting
    string40  falsefalseLEADSPERSONAL_SGreetingSpouse's greeting name
    SJobTitle
    string128  falsefalseLEADSPERSONAL_SJobTitleSpouse's job title
    SLastName
    string128  falsefalseLEADSPERSONAL_SLastNameSpouse's last name
    SMiddleName
    string40  falsefalseLEADSPERSONAL_SMiddleNameSpouse's middle name
    SOccupation
    string64  falsefalseLEADSPERSONAL_SOccupationSpouse's occupation
    SSuffix
    string40  falsefalseLEADSPERSONAL_SSuffixSpouse's suffix
    Salary
    integer   falsefalseLEADSPERSONAL_SalaryLead's salary
    Tax
    double   falsefalseLEADSPERSONAL_TaxIncome tax
    Tobacco
    lookup  TobaccofalsefalseLEADSPERSONAL_TobaccoTobacco smoker or nonsmoker status
    LeadID
    id Lead falsefalseLEADSPERSONAL_LeadsId 


    Letter
    Referred By:
    LetterSystem.LetterID  DynReport.Letter  CorrTransaction.LetterID  CorrTransaction.Letter  LetterContact.LinkFormletterID  LetterContact.LinkHeaderID  LetterContact.LinkFooterID  LetterContact.LinkEnvelopeID 
    Main TableData ObjectTopSearchReadonly
    LETTER_TABLElettertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    Category
    lookup  ImageCategoryfalsefalseLETTER_CategoryLetter Log tab under which letter is displayed
    Compressed
    integer   falsefalseLETTER_CompressedStates whether the letter is compressed
    CreatedByText
    string60  falsetrueLETTER_CreatedByTextCreated by text
    CreatedOn
    datetime   truefalseLETTER_CreatedOnLetter created date
    Data
    dtImage   falsefalseLETTER_DataData
    EmailSubject
    string255 falsefalseLETTER_EmailSubject 
    Format
    lookup  LetterFormatfalsefalseLETTER_FormatFormat
    FormatText
    lookuptext   falsetrueLETTER_FormatText 
    Icon
    byte   falsetrueLETTER_Icon 
    Keyword
    string255 KeywordsActivitytruefalseLETTER_KeywordKeyword
    LetterID
    integer   truetrueLETTER_LetterIDPrimary Key
    LetterSize
    integer   falsefalseLETTER_LetterSize 
    ModifiedBy
    integer   falsefalseLETTER_ModifiedByForeign Key -- Link to APPUSER table
    ModifiedByText
    string60  falsetrueLETTER_ModifiedByTextModified by text
    ModifiedOn
    datetime   falsefalseLETTER_ModifiedOnDate letter modified
    NoDelete
    lookup  YesNofalsefalseLETTER_NoDelete 
    OriginalID
    integer   truefalseLETTER_OriginalIDOriginal ID
    Private
    lookup  YesNotruefalseLETTER_PrivatePrivate letter
    ReadOnly
    integer   falsefalseLETTER_ReadOnlyRead only letter
    Title
    string255  truefalseLETTER_TitleLetter title
    Type
    lookup  LetterTypestruefalseLETTER_TypeType
    TypeText
    lookuptext   falsetrueLETTER_TypeText 
    UsePrintEditor
    byte   falsefalseLETTER_PrintUsingWord 
    LetterSystem
     LetterSystem   
    CreatedBy
    object User truefalseLETTER_CreatedByForeign Key -- Link to APPUSER table
    CreatedByID
    id User truefalseLETTER_CreatedByForeign Key -- Link to APPUSER table


    LetterContact
    Referred By:

    Main TableData ObjectTopSearchReadonly
    CONTACTLETTER_TABLElettercontacttruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    AddressOption
    lookup  MailMergeAddressTypefalsefalseCONTACTLETTER_AddressOptionAddress type for the letter choice field
    AsText
    integer   falsefalseCONTACTLETTER_AsTextSend Word document as text? yes/no field
    Category
    lookup  ImageCategoryfalsefalseCONTACTLETTER_Category 
    Compressed
    integer   falsefalseCONTACTLETTER_Compressed 
    CreatedOn
    datetime   truefalseCONTACTLETTER_CreatedOn 
    Data
    dtImage   truefalseCONTACTLETTER_Data 
    Destination
    string750  falsefalseCONTACTLETTER_DestinationFax number or e-mail address
    Encoding
    lookup  ImportEncodingtruefalseCONTACTLETTER_ENCODING 
    FinalEnabledOn
    datetime   falsefalseCONTACTLETTER_FinalEnabledOn 
    FooterFirstPage
    integer   falsefalseCONTACTLETTER_FFPInsert footer on the first page? yes/no field
    HeaderFirstPage
    integer   falsefalseCONTACTLETTER_HFPInsert header on the first page? yes/no field
    Keyword
    string255 KeywordsActivityfalsefalseCONTACTLETTER_Keyword 
    LetterID
    integer   falsefalseCONTACTLETTER_LetterIDPrimary Foreign Key -- Link to LETTER table
    LinkID
    integer   falsefalseCONTACTLETTER_LinkIDLink ID
    LinkOfficeID
    integer   falsefalseCONTACTLETTER_LinkOfficeIDLink office ID
    LinkTable
    integer   falsefalseCONTACTLETTER_LinkTableLink table
    MarkFinal
    lookup  YesNofalsefalseCONTACTLETTER_MarkFinal 
    Method
    lookup  LetterSentMethodfalsefalseCONTACTLETTER_MethodMethod to send the letter choice field
    Private
    lookup  YesNotruefalseCONTACTLETTER_PrivateForeign Key -- Link to CONTACT table
    Title
    string255  truefalseCONTACTLETTER_Title 
    ContactID
    id Contact truefalseCONTACTLETTER_ContactIDForeign Key -- Link to CONTACT table
    LinkEnvelopeID
    id Letter falsefalseCONTACTLETTER_LinkEnvelopeIDForeign Key -- Link to LETTER table
    LinkFooterID
    id Letter falsefalseCONTACTLETTER_LinkFooterIDForeign Key -- Link to LETTER table
    LinkFormletterID
    id Letter falsefalseCONTACTLETTER_LinkFormletterIDForeign Key -- Link to LETTER table
    LinkHeaderID
    id Letter falsefalseCONTACTLETTER_LinkHeaderIDForeign Key -- Link to LETTER table


    LetterSystem
    Referred By:
    Letter.LetterSystem 
    Main TableData ObjectTopSearchReadonly
    SYSTEMLETTER_TABLElettertruetruefalse

    Properties:
    NameTypeLengthObjectLookupSearchReadonlyColumnDescription
    DefaultFooterID
    integer   falsefalseSYSTEMLETTER_DefaultFooterIDForeign Key -- Link to LETTER table
    DefaultHeaderID
    integer   falsefalseSYSTEMLETTER_DefaultHeaderIDForeign Key -- Link to LETTER table
    ExpiresOn
    date   falsefalseLETTERSYSTEM_ExpiresOnLetter expiration date
    FooterFirstPageOnly
    byte  YesNofalsefalseSYSTEMLETTER_FooterFirstPageOnlyFooter on first page only
    HIPAA_Protected
    lookup  HIPPALetterOptionsfalsefalseSYSTEMLETTER_HIPAA_ProtectedIndicates letter must conform to HIPAA
    HeaderFirstPageOnly
    byte  YesNofalsefalseSYSTEMLETTER_HeaderFirstPageOnlyHeader on first page only