Phase 2 DataModel

PHASE 2 - DATA MODEL

SUBJECT AREA SECTIONS

1. PE - PRE PROCESSING
2 .PE - AUDIT
3. PD SURVEY
4. CTA - MANAGE CLASS WORDING & BAC
5. CTA - TEST AUDIT & WORK CONTROL RECORD
6. CTA - INSPECTION REPORT
7. USR SUMMARY PROCESS

LEGEND

New Table

Existing Table Altered

Existing Table Not Altered

New tables - Based on Existing Schema

(USR Summary Process)

1, 1 / 4, 3
 Phase 2 DataModel

PE - PRE PROCESSING DATA MODEL

SUBMISSION LEVEL

PolicySubmissionErrors ErrorType
Submission Log PolicySubmissionDetails PolicySubmissionTransactionDetail
PolicySubmissionTransaction PolicySubmissionErrorsGID ErrorTypeGID
SubmissionLogGID PolicySubmissionDetailsGID PolicySubmissionTransactionDetailGID
PolicySubmissionTransactionGID ErrorTypeGID (FK) ErrorCategoryLID
SubmissionLogGID (FK) PolicySubmissionDetailsGID (FK) PolicySubmissionTransactionDetailGID (FK)
FileName PolicySubmissionTransactionDetailGID (FK) ErrorCode
SubmissionLogGID (FK) PolicySubmissionDetailsGID (FK)
ReceivedDate SubmissionType PolicySubmissionDetailsFID (FK) ErrorDescription
ProcessedDate TransFileContent SubmissionLogGID (FK) SubmissionLogGID (FK) ErrorTypeFieldLevelLID
ETRDataProviderEmail
StatusLID ETRDatatypeCode LNKCarrierCode AuditRuleStoredProcedure
StatusLID RecordTypeCode
SubmissionID ETRTransVersionId InsurerFID SeverityLID
SubmissionTypeLID FieldName
IsActive ETRSubmissionTypeCode LNKPolicyNumber ErrorRecordTypeLID
MatchedEmployerFID FieldValue
RejectReasonLID ETRDataproviderCode LNKCertNumber ReportLevel
MatchedSetNumber CreateUserFID
ReportedSubmissionType ETRDataProviderContactName LNKPolicyEffectiveDate IsActive
MatchedPolicyFID CreateDate
RejectionComments ETRPhoneNumber LNKTransactionIssueDate RecordLevel
CreateUserFID LastUpdateUserFID
SystemSubmissionStatusLID ETRPhoneExtension LNKTransactionCode SupressAtHigherLevel
CreateDate LastUpdateDate
ETRFaxNumber TransactionStatusLID IsActive CanbeApproved
TransReferenceNo LastUpdatedUserFID FixErrorStoredProcedure
ETRProcessDate
CreateUserFID LastUpdateDate ReportComparisionOperator
ETRContactStreet
ETRContactCity CreateDate CreateDate
ETRContactState LastUpdateUserFID LastUpdateUserFID
ETRContactZip LastUpdateDate LastUpdateDate
ETRDataProviderTypeCode IsActive CreateUserFID
ETRTPEFEIN
ETRErrorReportingCode
SCRRecordTotals
SCRHeaderRecordsTotal
SCREarliestTransactionDate
SCRLatestTransactionDate
TransactionCount
CreateUserFID
CreateDate
LastUpdateUserFID
LastUpdateDate
IsActive

POLICY LEVEL
PolicySubmissionEndorsementRecord
PolicySubmissionEndorsementRecordGID
PolicySubmissionTransName PolicySubmissionTransAddress PolicySubmissionTransExposure
PolicySubmissionTransHeader PolicySubmissionTransactionDetailGID (FK)
PolicySubmissionTransNameGID PolicySubmissionTransAddressGID PolicySubmissionTransStatePremium PolicySubmissionTransExposureGID PolicySubmissionDetailsGID (FK)
PolicySubmissionTransHeaderGID
PolicySubmissionTransactionDetailGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionTransStatePremiumGID PolicySubmissionTransactionDetailGID (FK) SubmissionLogGID (FK)
PolicySubmissionTransactionDetailGID (FK)
PolicySubmissionDetailsGID (FK) PolicySubmissionDetailsGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionDetailsGID (FK)
PolicySubmissionDetailsGID (FK) EndorsementNumber
SubmissionLogGID (FK) SubmissionLogGID (FK) PolicySubmissionDetailsGID (FK) SubmissionLogGID (FK)
SubmissionLogGID (FK) BureauVersionIdentifier
NameCodeType TypeofAddress SubmissionLogGID (FK) ClassorStatCode
PolicyExpirationDate CarrierVersionIdentifier
NameLinkIdentifier ForeignAddressIndicator StateAddDeleteCode ClassWordingSuffix PolicyChangeEffectiveDate
TPEFein
EmployerClientCompanyCode AddressStructureCode ReportBureauNumber ExposureCoverageCode PolicyChangeExpirationDate
PolicyTypeCode
InsuredName StreetAddress ReportedCarrierCode ExposurePeriodEffectiveDate CreateUserFID
EmployeeLeasingPolicyTypeCode
NameFEIN CityName CalifCarrierCode EstimatedExposureAmount CreateDate
PolicyTermCode
ContinuationSequenceNumber StateCode ExModFactor NameLinkIdentifier LastUpdateUserFID
PriorPolicyNumber
NameLinkCounterIdentifier PostalZipCode ExmodStatusCode StateCodeLink LastUpdateDate
PriorCertNumber
PolicyChangeEffectiveDate AddressFreeForm EstimatedStateStdPremiumTotal ExposureRecordLink IsActive
LegalNatureofInsuredCode
PolicyChangeExpirationDate NameLinkIdentifier ExmodEffectiveDate NameLinkCounterIdentifier
FieldWrapUpCode
CreateUserFID StateCodeLink CreateUserFID PolicyChangeEffectiveDate
BusinessSegmentIdentifier PolicySubmissionTransCancelReinstate
CreateDate ExposureLocationLink CreateDate PolicyChangeExpirationDate
EmployerLiabDisPolLimitAmount
LastUpdateUserFID GeographicArea LastUpdateUserFID CreateUserFID PolicySubmissionTransCancelReinstateGID
EmployerLiabDisEmpAmount
LastUpdateDate CountryCode LastUpdateDate CreateDate PolicySubmissionTransactionDetailGID (FK)
ProducerName
IsActive NameLinkCounterIdentifier IsActive LastUpdateUserFID PolicySubmissionDetailsGID (FK)
GroupCoverageStatus
OriginalCarrierCode PolicyChangeEffectiveDate LastUpdateDate SubmissionLogGID (FK)
OriginalPolicyNumber PolicyChangeExpirationDate IsActive
CreateUserFID CancelReinstateIDCode
OriginalPolicyEffectiveDate InsuredName
TextotherLegalNatureofInsured CreateDate
LastUpdateUserFID InsuredAddress
CreateUserFID CancelReinstateTransactionSequencenumber
CreateDate LastUpdateDate
IsActive CorrespondingCancellationEffectiveDate
LastUpdateUserFID CancelReinstateEffectiveDate
LastUpdateDate CreateUserFID
IsActive CreateDate
LastUpdateUserFID
LastUpdateDate
IsActive

D - Records

PolicySubmissionGroupEndorsement PolicySubmissionMultipurposeTextEndorsement
PolicySubmissionEndorsement PolicySubmissionExclusionEndorsement PolicySubmissionGroupEndorsementGID PolicySubmissionMultipurposeTextEndorsementGID
PolicySubmissionEndorsementGID PolicySubmissionExclusionEndorsementGID PolicySubmissionEndorsementGID (FK) PolicySubmissionEndorsementGID (FK)
PolicySubmissionTransactionDetailGID (FK) PolicySubmissionEndorsementGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionTransactionDetailGID (FK)
PolicySubmissionDetailsGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionDetailsGID (FK) PolicySubmissionDetailsGID (FK)
SubmissionLogGID (FK) PolicySubmissionDetailsGID (FK) SubmissionLogGID (FK) SubmissionLogGID (FK)
RecordTypeCode SubmissionLogGID (FK)
GroupName EndorsementLine
EndorsementNumber NameExcluded GroupInsuranceEffectiveDate
BureauVersionIdentifier GroupInsuranceExpirationDate
CarrierVersionIdentifier
InsuredName
EndorsementEffectiveDate
EndorsementExpirationDate
EndorsementSequenceNumber
EndorsementSerialNumber
IsActive
CreateUserFID
CreateDate PolicySubmissionCAF10Endorsement PolicySubmissionCAFAltCovgInfoEndorsement
LastUpdateUserFID PolicySubmissionEmployeeLeasingEndorsement PolicySubmissionCAF11Endorsement
PolicySubmissionCAF10EndorsementGID PolicySubmissionCAFAltCovgInfoEndorsementGID
LastUpdateDate PolicySubmissionEmployeeLeasingEndorsementGID PolicySubmissionEndorsementGID (FK) PolicySubmissionCAF11EndorsementGID PolicySubmissionEndorsementGID (FK)
PolicySubmissionEndorsementGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionEndorsementGID (FK) PolicySubmissionTransactionDetailGID (FK)
PolicySubmissionTransactionDetailGID (FK) PolicySubmissionDetailsGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionDetailsGID (FK)
PolicySubmissionDetailsGID (FK) SubmissionLogGID (FK) PolicySubmissionDetailsGID (FK) SubmissionLogGID (FK)
SubmissionLogGID (FK) SubmissionLogGID (FK)
TitletenWording AlternateCoverageInsuredName
Name EmployeeName ExcludedOperationDescription AlternateCoverageInsurerCode
StreetAddress OperationName AlternateCoverageInsurerName
CityName OperationTitle AlternateCoveragePolicyNumber
StateCode LocationAddress AlternateCoverageCertNumber
PostalZipCode ClassificationCode AlternateCoveragePolicyInceptionDate
ClassificationSuffix AlternateCoveragePolicyExpirationDate
ClassificationWording

Specific Endorsement (Tran code 03 Related Records 10,11,87,88,89) General Endorsements (Section 6)
PolicySubmissionDataElementChangeEndorsement PolicySubmissionNameChangeEndorsement
PolicySubmissionClassRateChangeEndorsement PolicySubmissionDataElementChangeEndorsementGID PolicySubmissionNameChangeEndorsementGID PolicySubmissionPeriodEndorsement
PolicySubmissionModChangeEndorsement
PolicySubmissionEndorsementGID (FK) PolicySubmissionEndorsementGID (FK) PolicySubmissionPeriodEndorsementGID
PolicySubmissionModChangeEndorsementGID PolicySubmissionClassRateChangeEndorsementGID
PolicySubmissionTransactionDetailGID (FK) PolicySubmissionTransactionDetailGID (FK) PolicySubmissionEndorsementGID (FK)
PolicySubmissionEndorsementGID (FK) PolicySubmissionEndorsementGID (FK)
PolicySubmissionDetailsGID (FK) PolicySubmissionDetailsGID (FK) PolicySubmissionTransactionDetailGID (FK)
PolicySubmissionTransactionDetailGID (FK) PolicySubmissionTransactionDetailGID (FK)
SubmissionLogGID (FK) SubmissionLogGID (FK) PolicySubmissionDetailsGID (FK)
PolicySubmissionDetailsGID (FK) PolicySubmissionDetailsGID (FK)
SubmissionLogGID (FK) RevisedNameRecordTypeCode SubmissionLogGID (FK)
SubmissionLogGID (FK) RevisedCarrierCode
RevisedPolicyNumber RevisedNameLinkIdentifier EffectiveDateFirstPolicyPeriod
ModificationEffectiveDate ExposurePeriodEffectiveDate
RevisedPolicyEffectiveDate RevisedInsuredName ExpirationDateFirstPolicyPeriod
ExmodFactor ClassificationCodeRevisionCode
RevisedPolicyExpirationDate RevisedFEIN EffectiveDateSecondPolicyPeriod
ExmodStatusCode ClassificationCode
RevisedLegalNatureofInsuredCode RevisedContinuationSequenceNumber ExpirationDateSecondPolicyPeriod
ACTCoverageCode
RevisedTextOtherLegalNatureofInsuredCode RevisedLegalNatureofEntityCode EffectiveDateThirdPolicyPeriod
EstimatedExposureAmount
RevisedEndorsementNumber RevisedTextOtherLegalNatureEntityCode ExpirationDateThirdPolicyPeriod
ClassWordingSuffix
RevisedBureauVersionID RevisedStateCode
PolicySubmissionAddressChangeEndorsement NameLinkIdentifier
RevisedCarrierIdentifier RevisedStateUnemploymentNumber
PolicySubmissionAddressChangeEndorsementGID StateCodeLink
RevisedProducerName NameRevisionCode
PolicySubmissionEndorsementGID (FK) ExposureRecordLink
RevisedBureauNumber RevisedEmployerClientCode
PolicySubmissionTransactionDetailGID (FK) RevisedCode PolicyChangeEffectiveDate
PolicySubmissionDetailsGID (FK) RevisedNameLinkCounterIdentifier
SubmissionLogGID (FK)

RevisedAddressRecordTypeCode
RevisedAddressStructureCode
RevisedAddressStreet
RevisedAddressCity
RevisedAddressState
RevisedAddressZip
RevisedNameLinkIdentifier
RevisedStateCodeLink
RevisedExposureLinkforLocationCode
RevisedGeographicArea
RevisedCountryCode
AddressRevisionCode
PolicyChangeEffectiveDate

2, 1 / 4, 3
 Phase 2 DataModel

PD SURVEY
PD SURVEY

PDSurveyData
PDSurveyDataErrors
PDSurveyDataGID
PDSurveyExcludedInsurers PDSurveyDataErrorGID
PDSurveyDataSamplingDetailsFID (FK)
PDServerExcludedInsurersGID
SurveyID PDSurveyErrorTypeFID (FK)
InsurerFID SurveyYear PDSurveyDataFID (FK)
LastUpdateUserFID SurveyStatusLID isApproved
LastUpdatedDate SurveyLevel
LossFID
ClaimNumber
AccidentDate
InsurerFID
NAICGroupFID
PolicyFID
InjuryType
ClaimStatusLID PDSurveyErrorType
ReportedDate PDSurveyErrorTypeGID
isResolved
ResolvedDate ErrorCode
ResolutionMethodLID ErrorDescription
PDSurveyDataSamplingDetails ValidationRuleStoredprocedure
PDRBeforeAppo
PDSurveyDataSamplingDetailsGID PDRAfterAppo ErrorMessage
Indemnity isApprovable
PolicyEffectiveFromDate isActive
Medical
PolicyEffectiveToDate CreateUserFID
IsRepByAttorney
AccidentYear CreateDate
WorkersLegalCost
DataSamplingStatusLID LastUpdateUserFID
InsurerLegalCost
CreateUserFID LastUpdatedDate
ArbitrationFees
CreateDate
OtherAllocated
LastUpdatedDate
EducationVoucherIncurred
LastUpdateUserFID
OtherVRIncurred
isPhysicianPreDes
TD
BirthDate
HireDate PDSurveyMLReports
WCABCode PDSurveyMLReportGID
WeeksPD1
WeeksPD2 PDSurveyDataFID (FK)
WeeksPD3 ReportNumber
EmploymentStatusLID Speciality
ZipCode Requestor
ACTComments FeeCode
LastUpdateUserFID Cost
LastUpdatedDate ServiceDate
SuppressionState

PDSurveyDisputeMechanismMapping
PDSurveyDisputeMechanismMappingGID

PDSurveyDataFID (FK)
DisputeMechanismLID
PDSurveyDataSamplingDetailsFID (FK)

2, 2 / 4, 3
 Phase 2 DataModel

TEST AUDIT AND WORK CONTROL RECORD

CTA - New General - New

CTATestAuditMasterRecordDetail CTAInsurerGroupConfiguration
CTATestAuditMasterRecordClaimDetail InsurerGroup
CTATestAuditMasterRecordDetailGID CTAInsurerGroupConfigurationGID
CTATestAuditMasterRecordClaimDetailGID InsurerGroupGID
WorKControlRecordFID (FK) InsurerGroupFID (FK)
CTATestAuditMasterRecordDetailFID (FK) InsurerGroupCode
InsurerAuditPayroll FrequencyForTestAuditSelection
ClaimNumber InsurerGroupName
AbsolutePayrollDifference MaximumOutOfStatePercentage
AccidentDate GroupTypeLID
InsurerPurePremium MaximumFinalPremium
ReportedDate CreateDate
AbsolutePurePremiumDifference TestAuditTypeLID
ClassClaimAssignedToByInsurer CreateUserFID
PremiumDifferencePercentage TestAuditSelectionTypeLID
ClassPayrollAssignedToByInsurer LastUpdateDate
PayrollCauseDifferenceLID CreateDate
ClassAssignedByTestAudit LastUpdateUserFID
IsXModDifference CreateUserFID
CauseOfClaimDifferenceLID IsActive
CreateUserFID LastUpdateDate
CreateDate
CreateDate LastUpdateUserFID
CreateUserFID
LastUpdateUserFID LastUpdateDate
LastUpdateDate LastUpdateUserFID
IsCIC11753 CTATestAuditSelectionData
InsurerAudit_VoluntaryDate CTATestAuditSelectionDataGID
InvoiceDate
PayrollCloseDate InsurerGroupQuotaFID (FK)
ClaimsCloseDate RunDate
IsVoluntary RunQuota
IsOutOfState TargetQuota
IsPhysical TestAuditPoliciesSelected
ProtestedLID ShortFall
ProtestLetterDate OutOfStatePolicies
ProtestReceiptDate ManualSelectionPolicyCount
TestAuditRevisedFlag TestAuditSelectionTypeLID
ExcludeFromSummaryForClaimsAudit CreateDate
ExcludeFromSummaryForPayrollAudit CreateUserFID
ProtestedRevisedToNoDiffCauseLID LastUpdateDate
ProtestResultsNotificationDate LastUpdateUserFID
EliminationCauseLID
Comments
ChargeableDiffFlag
ChargeableFlag

CTA - Existing Correspondence - Existing WorkQueue - Existing

CorrespondenceTemplate
CorrespondenceTemplateGID
WorkqueueLog WorkQueueComparisionFields WorkQueueAction
WorkControlRecord TemplateFileName
TemplateName WorkqueueLogGID WorkQueueComparisionFieldsGID WorkQueueActionGID
WorKControlRecordGID IsBulkCorrespondence
LogUserFID ComparisionValue ActionLevel
PolicyFID SignatorFID
ActionTypeLID Operator AuditActionTypeLID
EmployerFID Subject
PreviousValue IsActive IsActive
InspectionTypeLID Keywords
NewValue WorkQueueGID (FK) DateCompletion
InspectionPriorityLID DepartmentGID (FK) WorkQueueGID (FK)
CorrespondenceTemplateEntity LogDateTime
Location DepartmentGID (FK)
LogMessage
WCRStatusLID CorrespondenceTemplateEntityGID IsActive
SelectionDate
CorrespondenceTemplateFID (FK) WorkQueueGID (FK)
RecordExpirationDate
EntityTypeLID DepartmentGID (FK)
DateAssigned
DateCompleted
FieldRepUserFID Correspondence
CreateUserFID CorrespondenceGID
CreateDate
LastUpdateUserFID CorrespondenceTemplateFID (FK)
LastUpdateDate CreateUserFID
IsActive CreateDate
Route LastUpdateUserFID
FacsimileNumber LastUpdateDate
IsChargeApplicable CommunicationSentDate
FacsimileComments Keyword
LetterReceiptDate DocumentGUID
NotificationDate IsActive
AssignedByUserFID Subject
MaterialReceivedDate SignatorFID
ApprovedDate CorrespondenceStatusLID
EmployerGID (FK) DeliveryMethodLID
DocumentName
SentByUserFID

LSRToCTACorrespondenceTransaction CorrespondenceTransaction
LSRToCTACorrespondenceTransactionGID TransactionGID
PolicyFID (FK)
EntityTypeLID
TestAuditPolicyFID TransactionReferenceFID
WorKControlRecordFID (FK) TransactionStatusLID
EmployerGID (FK) CreateDate
LastUpdateDate

DocumentEntity
DocumentEntityGID

DocumentFID (FK)
DocumentTypeLID
EntityFID
EntityTypeLID
EmployerFID
IsActive
ReportLevel

DDTS- Existing
DDTSDocuments DDTSMetaData DDTSFTPAddress DDTSStatus DDTSSystemBatch DDTSPrinterDetails DDTSEmailNotification
DDTSDocGID DDTSMetaDataGID DDTSFTPAddressGID DDTSStatusGID DDTSBatchGID DDTSPrinterGID DDTSEmailNotificationGID
DDTSMetaDataFID (FK) InsurerFID FTPAddress DDTSDocFID (FK) DocTypeLID PrinterName ProcessTypeLID
DDTSFTPFID (FK) PolicyFID FTPUserName DeliveryStatusLID StartRunDate CreateDate StatusLID
CreateuserFid EmployerFID FTPPassWord ResendAttempts EndRunDate CreateUserFID CreateDate
UpdatedUserFID RatingInsurerIssuingofficeMappingFID FTPZipPassword DeliveryNotes StatusLID LastUpdateUserFID LastUpdateDate
DocTypeLID ReleaseDate DeliveryDate ProcessedFileCount LastUpdateDate
DocDeliveryTypeLID StatOffice CreateDate ErrorFileCount IsActive
DDTSDocumentID LetterDate UpdatedDate ProcessTypeLID
DDTSDocRepositoryLID IsWithDrawn DDTSBatchFID DDTSEmailNotificationDetails
DocSharepointGUID NAICGroupFID DDTSEmailNotificationDetailsGID
DocFilePath EntityFID
DB2PDFDocGID DDTSEmailNotificationFID (FK)
DocumentName
Resend
SortOrderParamValue
CreateDate
UpdatedDate
IsActive
NumberOfCopies

General - Existing
InsurerTPELocationMap Insurer Department

InsurerTPELocationMapGID InsurerGID DepartmentGID

InsurerFID NAICGroupFID CreateUserFID

TPEFID CreateUserFID LastUpdateUserFID
FTPAddressFID LastUpdateUserFID DepartmentName
StateAbbreviationFID InsurerName DepartmentTypeLID
CreateUserFID IsIndependent CreateDate
LastUpdateUserFID EffectiveFromDate LastUpdateDate
MailCode EffectiveToDate IsActive
Lot MemberTypeLID DepartmentConst
SelectionTag MemberStatusLID
InBoundFTP MNFRMInsurerName
OutBoundFTP InsurerCode
InsurerGroupAssociation
EffectiveFromDate CDICode
EffectiveToDate NCCICode InsurerGroupAssociationGID
CreateDate ClosedInsolventStatusLID
InsurerGroupFID (FK)
LastUpdateDate NAICCode
InsurerFID (FK)
OfficeTypeLID CreateDate
CreateUserFID
Telephone LastUpdateDate
CreateDate
Fax IsActive
LastUpdateUserFID
Email IsEligibleforFTP
LastUpdateDate
Address1 MemberSinceDate
EffectiveFromDate
Address2 ControlListNotificationTimeInMonth
EffectiveToDate
City SubGroup
State CheckCertificateNumber
ZIP
Country
IsActive
LocationID LinkedDocument InsurerGroupQuota
Note LinkedDocumentGID InsurerGroupQuotaGID
LocationName
Telephone2 ReceivedDate InsurerGroupFID (FK)
LinkedDocumentTypeLID AnnualQuota
DocumentGUID Year
Configuration Keyword CreateDate
CreateUserFID CreateUserFID
IsActive LastUpdateUserFID
KeyName
DocumentName LastUpdateDate
KeyValue
Comments IsActive
IsActive
CreateDate

Note: As part of these Phase 2 Implementation we are breaking the existing "InsurerGroupAssociation" table into two viz "InsurerGroup" and
"InsurerGroupAssociation" . This change is recommended in order to have the schema normalized. As part of this Data Base Change the required changes
to the existing MII and bridge need to be carried out.

2, 3 / 4, 3
 Phase 2 DataModel

PE - AUDIT PROCESSING DATA MODEL

ACTIVE

Policy
PolicyGID

InsurerFID
CarrierCodeTransIssueDate
PolicyNumber
PolicyExposureAssociation
PolicyNumberTransIssueDate PolicyEmployerNames PolicyExmodAssociation
PolicyAddress PolicyExposureAssociationGID PolicyAddrExposureMapping
CertificateNumber
CertNumberTransIssueDate PolicyEmployerNamesGID PolicyAddressGID PolicyExmodAssociationGID PolicyFID (FK)
PolicyGeneral PolicyAddrExposureMappingGID
PolicyEffectiveDate PolicyFID (FK) PolicyFID (FK) PolicyFID (FK)
ClassCode PolicyAddressGID (FK)
PolicyEffectiveTransIssueDate PolicyGeneralGID PolicyExposureAssociationGID (FK)
NameCodeTypeLID TypeofAddressLID ReportBureauNumber JobClassificationFID
PolicyExpirationDate PolicyFID (FK) PolicyFID (FK)
NameLinkIdentifier ForeignAddressIndicator ExModFactor ExposureCoverageCodeLID
PolicyExpirationTransIssueDate PriorPolicyNumber NameCategoryLID ExmodStatusCodeLID
AddressStructureCodeLID ExposurePeriodEffectiveDate CreateUserFID
CancellationEffectiveDate PriorCertNumber InsuredName ExmodEffectiveDate
StreetAddress EstimatedExposureAmount CreateDate
PolicyTypeLID FieldWrapUpCodeLID NameFEIN IssueDate
CityName ClassificationWording LastUpdateUserFID
PolicyTypeReasonLID FieldWrapUpIssueDate ContinuationSequenceNumber CreateUserFID
StateCode JobClassificationSuffixFID LastUpdateDate
TransactionCode BusinessSegmentIdentifier NameLinkCounterIdentifier CreateDate
PostalZipCode NameLinkIdentifier IsActive
TransactionIssueDate BusinessSegmentName PolicyChangeEffectiveDate LastUpdateUserFID
AddressFreeForm StateCodeLink
TPEFID BusinessSegmentIDIssueDate PolicyChangeExpirationDate LastUpdateDate
NameLinkIdentifier ExposureRecordLink
TPETransIssuedDate ProducerName IssueDate IsActive
StateCodeLink NameLinkCounterIdentifier
EmpLeasingPolicyTypeCodeLID ProducerNameIssueDate IsPrimary ExposureLocationLink PolicyChangeEffectiveDate
EmpLeasingPolicyTypeCodeIssueDate LegalNatureOfInsuredLID CreateUserFID GeographicArea PolicyChangeExpirationDate
PolicyTermCodeLID LegalNatureOfInsuredLIDIssueDate CreateDate CountryCode IssueDate
PolicyTermCodeTransIssueDate TextotherLegalNatureofInsured LastUpdateUserFID NameLinkCounterIdentifier CreateUserFID
PolicyChangeEffectiveDate TextotherLegalNatureofInsuredIssueDate LastUpdateDate PolicyChangeEffectiveDate CreateDate
PolicyChangeExpirationDate CreateUserFID IsActive PolicyChangeExpirationDate LastUpdateUserFID
CreatedByTransactionTypeLID CreateDate IssueDate LastUpdateDate
IsRenewable LastUpdateUserFID CreateUserFID IsActive
ReInstatementEffectiveDate LastUpdateDate CreateDate
CoverageTypeLID IsActive Renamed PolicyJobCodeAssociation table of Phase
LastUpdateUserFID
EstimatedStateStdPremiumTotal 1 as PolicyExposureAssociation
LastUpdateDate
IsAuditable PolicyNameAddrMapping
IsActive
ARDFID
PolicyNameAddrMappingGID
NextARDFID
PolicyEmployerNamesGID (FK)
IsLargeEAP PolicyAuditLog PolicyAddressGID (FK)
CityAbbreviationFID
PolicyTransactionsGID PolicyFID (FK)
SplittedCount
PolicyFID (FK)
InsurerTPELocationMapFID CreateUserFID
OriginalPolicyNumber PolicySubmissionTransactionFID CreateDate
PolicyPrefix CreatedbyTransactionTypeLID LastUpdateUserFID
PolicyBody TransactionIssueDate LastUpdateDate
PolicySuffix TransactionRecordLID IsActive
MFPolicyNumber CreateDate
CreateUserFID CreateUserFID
CreateDate EmployerPolicyMapping
LastUpdateUserFID EmployerPolicyMappingGID
LastUpdateDate
IsActive PolicyFID (FK)
SetNumber
BNRelationTypeLID
IsOriginal
OwnershipChangeDate
LinkedEmployerPolicyMappingFid
CreateUserFID
CreateDate
LastUpdateUserFID
LastUpdateDate
IsActive
EmployerFID (FK)

Historical Data Other Tables

PolicyAddressHistory PolicyExmodHistory PolicyClassificationHistory
PolicyHistory PolicyGeneralHistory PolicyNameHistory PolicyFormsHistory
PolicyAddressGID PolicyExmodAssociationGID PolicyClassificationHistoryGID
PolicyHistoryGID PolicyGeneralHistoryGID PolicyNameHistoryGID PolicyFormsHistoryGID PolicyParentChildMapping
PolicyEmployerNamesGID PolicyFID (FK) PolicyFID (FK)
PolicyFID (FK) PolicyFID (FK) PolicyFID (FK) PolicyFID (FK)
PolicyFID (FK) PolicyParentChildMappingGID
PolicyTransactionDetailFID PolicyTransactionDetailFID
PolicyTransactionDetailFID PolicyTransactionDetailFID PolicyTransactionDetailFID PolicyTransactionDetailFID
PolicyTransactionDetailFID ChangeTypeLID ChangeTypeLID ParentPolicyFID
ChangeTypeLID ChangeTypeLID ChangeTypeLID ChangeTypeLID
ChangeTypeLID ProcessedDate ProcessedDate ChildPolicyFID
ProcessedDate ProcessedDate ProcessedDate ProcessedDate
ProcessedDate ReportBureauNumber ClassCode RelationTypeLID
InsurerFID PriorPolicyNumber NameCodeTypeLID TransactionIssueDate
TypeofAddressLID ExModFactor JobClassificationFID CreateUserFID
CarrierCodeTransIssueDate PriorCertNumber NameLinkIdentifier EndorsementNumber
ForeignAddressIndicator ExmodStatusCodeLID ExposureCoverageCodeLID CreateDate
PolicyNumber FieldWrapUpCodeLID NameCategoryLID BureauVersionIdentifier
AddressStructureCodeLID ExmodEffectiveDate ExposurePeriodEffectiveDate LastUpdateUserFID
PolicyNumberTransIssueDate FieldWrapUpIssueDate InsuredName CarrierVersionIdentifier
StreetAddress IssueDate EstimatedExposureAmount LastUpdateDate
CertNumber BusinessSegmentIdentifier NameFEIN ChangeEffectiveDate
CityName CreateUserFID ClassificationWording IsActive
CertNumberTransIssueDate BusinessSegmentName ContinuationSequenceNumber ChangeExpirationDate
StateCode CreateDate JobClassificationSuffixFID
PolicyEffectiveDate BusinessSegmentIDIssueDate NameLinkCounterIdentifier FormFID
PostalZipCode NameLinkIdentifier
PolicyEffectiveTransIssueDate ProducerName PolicyChangeEffectiveDate HasExtraDetails
AddressFreeForm StateCodeLink
PolicyExpirationDate ProducerNameIssueDate PolicyChangeExpirationDate CreateDate
NameLinkIdentifier ExposureRecordLink
PolicyExpirationTransIssueDate LegalNatureOfInsuredLID IssueDate CreateUserFID
StateCodeLink NameLinkCounterIdentifier PolicyErrorType
CancellationEffectiveDate LegalNatureOfInsuredLIDIssueDate IsPrimary
ExposureLocationLink PolicyChangeEffectiveDate
PolicyTypeLID TextotherLegalNatureofInsured CreateUserFID ErrorTypeGID
GeographicArea PolicyChangeExpirationDate
PolicyTypeReasonLID TextotherLegalNatureofInsuredIssueDate CreateDate
CountryCode IssueDate ErrorCode
TransactionCode CreateUserFID CreateUserFID
TransactionIssueDate CreateDate NameLinkCounterIdentifier ErrorCategoryLID
PolicyChangeEffectiveDate CreateDate ErrorDescription
TPEFID
TPETransIssuedDate PolicyChangeExpirationDate SeverityLID
EmpLeasingPolicyTypeCodeLID IssueDate IsActive
EmpLeasingPolicyTypeCodeIssueDate CreateUserFID
PolicyTermCodeLID CreateDate
PolicyTermCodeTransIssueDate
PolicyChangeEffectiveDate
PolicyChangeExpirationDate EmployerStatus
CreatedByTransactionTypeLID
EmployerStatusGID
IsRenewable
ReInstatementEffectiveDate EmployerFID
CoverageTypeLID EmployerStatusLID
EstimatedStateStdPremiumTotal CreateUserFID
IsAuditable CreateDate
ARDFID LastUpdateUserFID
NextARDFID LastUpdateDate
IsLargeEAP
CityAbbreviationFID
CreateUserFID
CreateDate

Matching Logic

PolicyMatchingLog
LatestBNSetPolicy MatchedBNSet MatchedBNSetDetails PolicyMatchingLogGID
LatestBNSetPolicyGID MachedBNSetGID MatchedBNSetDetailsGID
PolicyTransactionDetailFID
EmployerFID PolicyTransactionDetailFID MachedBNSetGID (FK)
Message
SetNumber EmployerFID MatchTypeLID TimeStamp
PolicyFID SetNumber PointsEarned DataBaseName
TotalPoints DBServerName
PolicyFID Severity
ExceedsThreshold
PolicyMatchingThresholdConfiguration
PolicyMatchingThresholdConfigurationGID

MatchTypeLID
ThresholdValue

D - Records

Endorsements
PolicyMultipurposeTextEndorsement PolicyCAF10Endorsement
PolicyEndorsement PolicyCAF11Endorsement PolicyCAFAlternateCoverageInfoEndorsement PolicyGroupEndorsement
PolicyMultipurposeTextEndorsementGID PolicyCAF10EndorsementGID
PolicyEndorsementGID PolicyCAF11EndorsementGID PolicyCAFAlternateCoverageInfoEndorsementGID PolicyGroupEndorsementGID
PolicyEndorsementGID (FK) PolicyEndorsementGID (FK)
PolicyFID (FK) PolicyEndorsementGID (FK) PolicyEndorsementGID (FK) PolicyFID (FK)
PolicyFID (FK) PolicyFID (FK)
RecordTypeLId PolicyFID (FK) PolicyCAF10EndorsementGID (FK) PolicyEndorsementGID (FK)
EndorsementLine TitletenWording PolicyCAF11EndorsementGID (FK)
EndorsementNumber ExcludedOperationDescription GroupName
CreateUserFID EmployeeName PolicyFID (FK)
BureauVersionID CreateUserFID GroupInsuranceEffectiveDate
CreateDate OperationName
CarrierVersionID CreateDate AlternateCoverageInsuredName GroupInsuranceExpirationDate
LastUpdateUserFID OperationTitle
StateCodeLID LastUpdateUserFID AlternateCoverageInsurerCode CreateUserFID
LastUpdateDate LocationAddress
FormFID LastUpdateDate AlternateCoverageInsurerName CreateDate
IsActive ClassificationSuffix
InsuredName IsActive AlternateCoveragePolicyNumber LastUpdateUserFID
ClassificationWording
PolicyChangeEffectiveDate AlternateCoverageCertNumber LastUpdateDate
ClassificationCode
PolicyChangeExpirationDate AlternateCoveragePolicyInceptionDate IsActive
PolicyExclusionEndorsement CreateUserFID
EndorsementSequenceNumber AlternateCoveragePolicyExpirationDate
CreateDate
EndorsementSerialNumber PolicyExclusionEndorsementGID
LastUpdateUserFID CreateUserFID
HasVariableText PolicyEndorsementGID (FK)
LastUpdateDate CreateDate
HasExtraDetails PolicyFID (FK)
IsActive LastUpdateUserFID
CreateDate LastUpdateDate
NameExcluded
CreateUserFID IsActive
CreateDate
LastUpdateUserFID
LastUpdateUserFID
LastUpdateDate
LastUpdateDate
IsActive
IsActive
CreateUserFID

PolicyEmployeeLeasingAddress
PolicyEmployeeLeasingAddressGID
PolicyEndorsementGID (FK) PolicyEmployeeLeasingNames
PolicyEmployeeLeasingNamesGID (FK) PolicyEmployeeLeasingNamesGID
PolicyFID (FK) PolicyEndorsementGID (FK)
PolicyFID (FK)
Address
City Name
State SequenceNumber
Zip CreateUserFID
AddressFreeForm CreateDate
CreateUserFID LastUpdateUserFID
CreateDate LastUpdateDate
LastUpdateUserFID IsActive
LastUpdateDate
IsActive

3, 1 / 4, 3
Phase 2 DataModel

Employer

Employer
EmployerGID

CreateUserFID
LastUpdateUserFID
PolicyAddressFID
DraftIndicatorRequestorFID
Name
IsRateable
IsBlocked
BureauNumber
CreateDate
LastUpdateDate
IsActive
DoNotInspect
FEINCode
OriginalInspectionSelectionDate
LastInspectionDate
GenerateRatingAsDraft
DraftReasonLID
DraftDate
SortBureauNumber

3, 2 / 4, 3
Phase 2 DataModel

3, 3 / 4, 3
 Phase 2 DataModel

CTA - INSPECTION REPORT BAC

EmployerBACHistory EmployerBAC

EmployerBACHistoryGID BureauAssignedClassGID
DDTSInspectionReportRequest DDTSInspectionReportDetails DDTSInspectionReportAnnualManualClassInfo
DDTSInspectionReportRequestGID DDTSInspectionReportRecipients DDTSInspectionReportDetailsGID DDTSInspectionReportAnnualManualClassInfoID BureauNumber LastUpdateUserFID
DDTSInspectionReportRecipientsGID JobClassCode CreateUserFID
InspectionReportTypeLID DDTSInspectionReportRequestFID (FK) DDTSInspectionReportRequestFID (FK) EmployerFID (FK)
DateAdded
CreateUserFID DDTSInspectionReportRequestFID (FK) DocSharepointGUID EffectiveDate DateDeleted
DateDeleted
UpdateUserFID CreateUserFID CreateUserFID CreateUserFID OfficeAssigned
OfficeAssigned
StatusLID UpdateUserFID UpdateUserFID UpdateUserFID IfAny
IfAny
CreateDate DocSharepointGUID StatusLID CreateDate USLH
USLH
UpdateDate InsReptCoverLetterTypeLID CreateDate UpdateDate IsActive
CreateUserFID
EmployerGID (FK) StatusLID UpdateDate CreateDate Lotus
WorKControlRecordGID (FK) CreateDate LastUpdateUserFID CreateDate
UpdateDate LastUpdateDate LastUpdateDate
EmployerGID (FK) JobClassCodeSuffix EffectiveFromDate
InsurerGID (FK) Route Route
Source UpdateTypeLID-N
Comments
ClassWording
ClassCodeGroup

MQIncomingMessageLog
MQIncomingMessageProcessErrors
MQIncomingMessageLogGID
MQIncomingMessageProcessErrorsID MQMessageErrorTypes
BureauNumber MQMessageErrorTypeGID
JobClassCode MQIncomingMessageLogFID (FK)
Suffix MQMessageErrorTypeFID (FK) ErrorCode
Territory ErrorDescription ErrorDescription
UpdateType CreateUserFID IsActive
UpdateIndicator CreateDate CreateUserFID
EffectiveDate UpdateUserFID CreateDate
OfficeAssignedFlag UpdateDate UpdateUserFID
IfAnyFlag UpdateDate
USLHFlag
DateReceived
DateProcessed
StatusFlagLID
BACUpdateStatusLID
WCRUpdateStatusLID
CreateUserFID
UpdateUserFID
CreateDate
UpdateDate

4, 1 / 4, 3
 Phase 2 DataModel

MANAGE CLASS WORDING & BAC

Manage Class Wording

JobClassification JobClassificationSuffix
JobClassificationGID JobClassificationSuffixGID JobClassificationRatingConfiguration
JobClassCode JobClassificationFID (FK) JobClassificationRatingConfigurationGID
JobDescription Suffix
EffectiveFromDate JobClassificationFID (FK)
Description DRatio
EffectiveToDate EffectiveFromDate
CreateDate ExpectedLossRate
EffectiveToDate CreateUserFID
CreateUserFID CreateDate
LastUpdateUserFID CreateDate
CreateUserFID LastUpdateUserFID
LastUpdateDate LastUpdateUserFID
ClassCodeTypeLID LastUpdateDate
LastUpdateDate IsActive
ClassCodeClassificationTypeLID IsActive
OfficeAssigned HourlyWageThreshold
IsActive EffectiveFromDate
ClassCodeSymbol EffectiveToDate
ManufacturerCodeLID
IndustryGroupLID
ExcludedForTestSelection
DualWageLID
CompanionDualWage
JobClassificationGroupMapping
ThresholdTypeLID
ThresholdValue JobClassificationGroupMappingGID
ThresholdEffectiveFromDate
JobClassificationGroupFID
NAICS
JobClassificationFID (FK)
RetroHazardGroup
ILDG
MLDG
PerCapitaClass JobClassificationOperation
PerRaceClass JobClassificationOperationGID
All Audit Columns respect to User is linked to LSRUser Table ExcludedForOriginalSelection JobClassificationNotes
CTAReviewRequired JobClassificationFID (FK)
ExcludedForRenewalSelection JobOperationLID JobClassificationNotesGID
EffectiveFromDate
JobClassificationFID (FK)
EffectiveToDate
Description
CreateDate
CreateUserFID
CreateUserFID
CreateDate
LastUpdateUserFID
LastUpdateUserFID
LastUpdateDate
LastUpdateDate
IsActive

4, 2 / 4, 3
 Phase 2 DataModel

USR SUMMARY PROCESS

JobScheduleConfiguration
JobScheduleConfigurationGID

JobName LateLargeUSRCriteria
JobDescription USRSummaryExclusions USRSummary USRSummaryLoss USRSummaryLossHistory
LateLargeUSRCriteriaGID USRSummaryAuditTransaction
JobType USRSummaryGID
USRSummaryExclusionGID USRSummaryLossGID USRSummaryLossHistoryGID USRSummaryAuditTransactionGID
ParentJobFID USRSummaryHistory FinalPremium
USRSummaryGID (FK) USRSummaryGID (FK) USRSummaryHistoryGID (FK) USRSummaryHistoryGID (FK)
ScheduledDateTime USRID PolicyInceptionStartDate
IsActive EmployerFID ClaimNumber USRSummaryHistoryGID USRSummaryGID (FK)
Description ClaimNumber PolicyInceptionEndDate
InsurerFID InjuryTypeLID EmployerFID InjuryTypeLID CreateUserFID TransactionStatusLID
PolicyFID IndemnityLossAmount InsurerFID JobClassificationFID CreateDate CreateDate
ReportLevel MedicalLossAmount PolicyFID IndemnityLossAmount
JobScheduleConfigurationDetail LastUpdateDate
CorrectionNumber AccidentDate CorrectionNumber MedicalLossAmount CreateUserFID
JobScheduleConfigurationDetailGID CreateUserFID FraudulentIndicatorLID ReportedExposureTotal AccidentDate LastUpdateUserFID
JobScheduleConfigurationGID (FK) CreateDate StateJurisdication ReportedPremiumTotal FraudulentIndicatorLID LateLargeUSRsSnapShot
LastUpdateUserFID AdjustExpenseAmount AuthorizedExposureTotal StateJurisdication
JobStatusLID LateLargeUSRsSnapShotGID
LastUpdateDate SSNNumber AuthorizedPremiumTotal AdjustExpenseAmount
CanRun LateLargeUSRCriteriaGID (FK)
ReportedExposureTotal PaidIndemnity ExposureRecordCount SSNNumber
LastUpdateUserFID WorkQueue
ReportedPremiumTotal PaidMedical ReportedIndemnityTotal PaidIndemnity PolicyFID
LastUpdateDate ErrorTypeRoleMapping WorkQueueGID
AuthorizedExposureTotal LossTypeLID ReportedMedicalTotal PaidMedical EmployerFID
LastRunDate SummaryRollupDetails ErrorTypeRoleMappingGID DepartmentGID (FK)
AuthorizedPremiumTotal RecoveryTypeLID AuthorizedIndemnityTotal LossTypeLID InsurerFID
SummaryRollupDetailGID ExposureRecordCount CoverageTypeLID RecoveryTypeLID PriorYearTotalPayrollAmount
AuthorizedMedicalTotal SummaryErrorTypeFID WorkDescription
JobScheduleConfigurationDetailGID (FK) ReportedIndemnityTotal SettlementTypeLID CoverageTypeLID PriorYearFinalPremiumAmount
SummaryLossRecordCount RoleFID WorkStatusLID
JobScheduleConfigurationGID (FK) LossRecordCount VoucherIndicator SettlementTypeLID CreateUserFID
EstimatedExposureIndicator IsActive CreateDate
SummaryActionGID (FK) EstimatedExposureIndicator VoucherTotal VoucherIndicator CreateDate
RiskId CreateUserFID
RiskId WeeklyWages PolicyTypeIdCodeCoverage VoucherTotal LastUpdateUserFID
PolicyYear WorkTypeLID
PolicyTypeIDCodeCoverage PercentageDisability PolicyTypeIdCodePlanIndicator WeeklyWages LastUpdateDate
SummaryReportLevel ErrorTypeFID
PolicyTypeIDCodePlanIndicator GrossIncurred PolicyTypeNonStdIndicator PercentageDisability IsActive
CreateDate DueDate
PolicyTypeIDNonStdIndicator LossID InsuredName GrossIncurred
CreateUserFID PrimaryEntityFID
InsuredName ClaimStatusLID InsuredAddress LossID WorkSubTypeLID
InsuredAddress CatastropheNumber OriginalCorrectionNumber ClaimStatusLID
SummaryActions PrimaryEntityTypeLID
StatusLID CoverageExceptionLID CreateUserFID CatastropheNumber SecondaryEntityTypeLID
SummaryActionGID OriginalReportLevel ReportLevel CoverageExceptionLID
CreateDate SecondaryEntityFID
JobScheduleConfigurationDetailGID (FK) OriginalCorrectionNumber CreateDate ReportLevel
LastUpdateUserFID OwnerFID
CreateUserFID LastUpdateDate CreateDate ErrorRecordTypeLID
JobScheduleConfigurationGID (FK)
LastUpdateUserFID CreateUserFID WorkStateLID
SummaryActionDescription
LastUpdateDate LastUpdateUserFID ErrorRecordFID
SummaryActionTypeLID
ClaimCount LastUpdateDate LastUpdateDate
SummaryActionStatusLID
CorrectionNumber ClaimCount LastUpdateUserFID
CreateUserFID
IsActive CorrectionNumber EmployerFID
CreateDate
ACTTypeLID IsActive AuditRulesConfiguration ComparisionValue
LastUpdateUserFID
OccupationDescription ACTTypeLID LastActionLevel
LastUpdateDate AuditRulesConfigurationGID
ClaimType OccupationDescription DiaryDueDate
IsActive
InjuryPartCode ClaimType AuditThreshold ApprovalReason
InjuryNatureCode InjuryPartCode SummaryAuditThreshold NextActionLevel
InjuryCauseCode InjuryCauseCode IsActive ActionLevelOneLID
BatchDate ExecutiveOfficersMinPayroll ActionLevelTwoLID
IsEdited ExecutiveOfficersMaxPayroll ActionLevelThreeLID
JobClassificationCode EffectiveFromDate IsActive
OriginalReportLevel EffectiveToDate AssignedByUserFID
OriginalCorrectionNumber CreateUserFID CSTicketNumber
CreateDate HasNotes
LastUpdateUserFID HasLinkedDocument
LastUpdateDate DepartmentFID
IsBookMarked
USRSummaryTotal ReportLevel
USRSummaryAuditError
USRSummaryExposure USRSummaryTotalGID USRSummaryExposureHistory StateWideSummary InsurerFID
USRSummaryTotalsByClass USRSummaryGID (FK) USRSummaryAuditErrorGID TPEFID
USRSummaryExposureGID USRSummaryHistoryGID (FK) USRSummaryExposureHistoryGID StatewideSummaryGID
USRSummaryTotalByClassGID USRSummaryHistoryGID (FK) IsLastAction
USRSummaryGID (FK) USRSummaryHistoryGID (FK)
USRSummaryGID (FK) USRID EffectivePolicyYear AdditionalInfo
ReportedTotalExposureNonPerCapita SeverityTypeLID
EffectiveDate ErrorCode EffectiveDate StatewidePayrollTotal
ExposureAmountTotal TotalExposureNonPerCapita
ExposureAmount ErrorRecordFID ExposureAmount StatewideLossTotal
LossAmountTotal ReportedTotalIncurredIndemnity
AuthorizedPremium ComparisonValue ReportedPremium CreateUserFID
IndemnityCount TotalIncurredIndemnity
ReportedPremium IsActive ExposureID CreateDate
PurePremium ReportedTotalIncurredMedical
ExposureID ErrorTypeFID CreateDate LastUpdateUserFID
TotalIncurredMedical
IsActive ReportLevel CreateUserFID LastUpdateDate
SubjectPurePremium
CreateDate CorrectionNumber CorrectionNumber IsActive
ModifiedPurePremium
CreateUserFID IsApproved ExposureACTCoverageCodeLID JobClassificationFID
ReportedFinalPremium
LastUpdateUserFID IsUSLH IsActive PurePremium
FinalPremium
LastUpdateDate Code9897PurePremium SeverityTypeLID
IsEdited Code0990PurePremium
BatchDate LossRecordCount
ExposureACTCoverageCodeLID ExposureRecordCount
CorrectionNumber OriginalReportLevel
JobClassificationCode OriginalCorrectionNumber
OriginalReportLevel CorrectionNumber
OriginalCorrectionNumber

All Audit Columns respect to User is linked to LSRUser Table

4, 3 / 4, 3