Epic Schema — Transactions, Entities & Codes

Epic Insurance System — Entity Relationship Diagram
TransCompany PK UniqTransCompany UniqTransHead UniqEntity CommissionAmount TransCode PK Code DescriptionOf TransactionClass TransHead PK UniqTransHead ItemNumber Code BillModeCode UniqEntity UniqPolicy InvoiceNumber TransDetail PK UniqTransHead PK TransDetailNumber DescriptionOf ItemAmount ApplymentAmount ItemBalanceCalc ClassCode ProcessCode TransBrokerProducer PK UniqTransBrokerProducer UniqTransHead UniqBroker CommissionPct Broker PK UniqEntity BrokerCode NameOf UniqContactNamePrimary Entity PK UniqEntity EntityCode EntityType NameOf UniqContactNamePrimary Company PK UniqEntity LookupCode NameOf UniqContactNamePrimary ContactName PK UniqContactName UniqEntity NameOf PhoneNumber Employee PK UniqEntity EmployeeCode NameOf CdSICCode PK UniqSICCode SICCode DescriptionOf UniqCdSICCategory CdSICCategory PK UniqCdSICCategory CategoryCode DescriptionOf Legend Primary Key (PK) Foreign Key relationship
← Back to Home
100%