Epic Schema — Policy Core & Line Details

Epic Insurance System — Entity Relationship Diagram
CdPolicyLineType PK UniqCdPolicyLineType CdPolicyLineTypeCode TypeOfBusinessCode TermDefaultCode UniqDepartment CdLineStatus PK UniqCdLineStatus CdLineStatusCode DescriptionOf Policy PK UniqPolicy PolicyNumber UniqEntity UniqDepartment UniqProfitCenter CdPolicyLineType EffectiveDate Agency DescriptionOf Line PK UniqLine UniqPolicy UniqEntity UniqCdPolicyLineType UniqCdLineStatus UniqProfitCenter BillModeCode CancellationLineJT PK UniqCancellation UniqLine UniqPolicy CancellationDate Reason Invoice PK UniqInvoice UniqPolicy UniqTransHead InvoiceNumber PrintedDate ItemAmount ServiceSummary PK UniqServiceSummary UniqPolicy ServiceDate DescriptionOf Department PK UniqDepartment DepartmentCode NameOf UniqProfitCenter ProfitCenter PK UniqProfitCenter ProfitCenterCode NameOf LineImage PK UniqLineImage UniqLine ImageType DescriptionOf Participation PK UniqParticipation UniqLine ParticipationPct UniqEntity PRPremise PK UniqPremise UniqLine Address City State LineBrokerProducer PK UniqLineBrokerProducer UniqLine UniqBroker CommissionPct LineEmployeeServicingJT PK UniqLineEmployeeServicingJT UniqLine UniqEmployee APBuilding PK UniqBuilding UniqLine BuildingNumber ConstructionType YearBuilt Legend Primary Key (PK) Foreign Key relationship
← Back to Home
100%