submissionDiagram.md

Submission Data Model

Diagrams are drawn using Mermaid to better visualize the in the app. You can edit and save new diagrams using the Mermaid Live Editor.

Database Models (birds-eye view)

For more detail, see prisma schema.

erDiagram

StateSubmission ||--|{ StateSubmissionRevision: "contains many"
StateSubmission ||--|| State: "assigned to"

Loading

Domain Models (detailed representation of data and relationships)

For more detail, see graphql schema and the submission form data proto schema

Other notes:

• Programs are currently hardcoded in a file
• "Health plan package" and "state submission" mean the same thing.

erDiagram
HealthPlanPackage {
    date initiallySubmittedAt
    enum status
    string stateCode
    array revisions
}
HealthPlanPackage ||--|| HealthPlanPackageRevision: revisions

HealthPlanPackageRevision {
    date createdAt
    UpdateInfo unlockInfo
    UpdateInfo submitInfo
    FormData submissionFormProto
}

HealthPlanPackageRevision ||--|| HealthPlanPackageFormData: submissionFormProto

HealthPlanPackageRevision ||--|| UpdateInfo : "submitInfo"
HealthPlanPackageRevision ||--|| UpdateInfo : "unlockInfo"
UpdateInfo {
  date updatedAt
  string updatedBy
  string updatedReason
}


HealthPlanPackageFormData {
    string id
    string status
    number stateNumber
    enum stateCode
    string submissionDescription
    enum submissionType
    array programIDs
    date submittedAt
    date createdAt
    date updatedAt
    array stateContacts
    array documents
    ContractInfo  contractInfo
    RateInfo rateInfo
}

HealthPlanPackageFormData || -- || ContractInfo : contractInfo
ContractInfo {
    enum contractType
    enum contractExecutionStatus
    date contractDateStart
    date contractDateEnd
    array managedCareEntities
    array federalAuthorities
    array contractDocuments
    ContractAmendmentInfo contractAmendmentInfo
}

ContractInfo ||--|| ContractAmendmentInfo : contractAmendmentInfo
ContractAmendmentInfo {
    array itemsBeingAmended
    string otherItemBeingAmended
    boolean relatedToCovid19
    boolean relatedToVaccination
    CapitationRatesAmendedInfo capitationRatesAmendedInfo
}

ContractAmendmentInfo ||--|| CapitationRatesAmendedInfo : capitationRatesAmendedInfo
CapitationRatesAmendedInfo {
    string reason
    string otherReason
}


Document {
    string name
    string S3URL
    array documentCategories
}


Contact {
    string name
    string titleRole
    string email
}

HealthPlanPackageFormData ||--|{ RateInfo : rateInfo
   RateInfo {
    enum rateType
    date rateDateStart
    date rateDateEnd
    date rateDateCertified
    array actuaryContacts
    enum actuaryCommunicationPreference
    array rateDocuments
    RateAmendmentInfo rateAmendmentInfo
    }

HealthPlanPackageFormData ||--|{ Contact : "stateContacts"
RateInfo ||--|{ Contact : "actuaryContacts"

RateInfo ||--|{ RateAmendmentInfo : rateAmendmentInfo
   RateAmendmentInfo {
    date effectiveDateStart
    date effectiveDateEnd
    }


ContractInfo ||--|{ Document : "contractDocuments"
HealthPlanPackageFormData ||--|{ Document : "documents"
RateInfo ||--|{ Document : "rateDocuments"

Loading