Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > \d "DMEClaims"
- Table "public.DMEClaims"
- Column | Type | Modifiers
- -------------------------------+-----------------------+-----------
- claimId | character varying(15) | not null
- allowedChargeAmount | numeric(12,2) | not null
- beneficiaryId | character varying(15) | not null
- beneficiaryPartBDeductAmount | numeric(12,2) | not null
- beneficiaryPaymentAmount | numeric(12,2) | not null
- carrierNumber | character varying(5) | not null
- claimDispositionCode | character varying(2) | not null
- claimEntryCode | character(1) | not null
- claimGroupId | numeric(12,0) | not null
- claimTypeCode | character varying(2) | not null
- clinicalTrialNumber | character varying(8) |
- dateFrom | date | not null
- dateThrough | date | not null
- diagnosis10Code | character varying(7) |
- diagnosis10CodeVersion | character(1) |
- diagnosis11Code | character varying(7) |
- diagnosis11CodeVersion | character(1) |
- diagnosis12Code | character varying(7) |
- diagnosis12CodeVersion | character(1) |
- diagnosis1Code | character varying(7) |
- diagnosis1CodeVersion | character(1) |
- diagnosis2Code | character varying(7) |
- diagnosis2CodeVersion | character(1) |
- diagnosis3Code | character varying(7) |
- diagnosis3CodeVersion | character(1) |
- diagnosis4Code | character varying(7) |
- diagnosis4CodeVersion | character(1) |
- diagnosis5Code | character varying(7) |
- diagnosis5CodeVersion | character(1) |
- diagnosis6Code | character varying(7) |
- diagnosis6CodeVersion | character(1) |
- diagnosis7Code | character varying(7) |
- diagnosis7CodeVersion | character(1) |
- diagnosis8Code | character varying(7) |
- diagnosis8CodeVersion | character(1) |
- diagnosis9Code | character varying(7) |
- diagnosis9CodeVersion | character(1) |
- diagnosisPrincipalCode | character varying(7) |
- diagnosisPrincipalCodeVersion | character(1) |
- hcpcsYearCode | character(1) |
- nearLineRecordIdCode | character(1) | not null
- paymentAmount | numeric(12,2) | not null
- paymentDenialCode | character varying(2) | not null
- primaryPayerPaidAmount | numeric(12,2) | not null
- providerAssignmentIndicator | character(1) | not null
- providerPaymentAmount | numeric(12,2) | not null
- referringPhysicianNpi | character varying(12) |
- referringPhysicianUpin | character varying(12) |
- submittedChargeAmount | numeric(12,2) | not null
- weeklyProcessDate | date | not null
- finalAction | character(1) | not null
- Indexes:
- "DMEClaims_pkey" PRIMARY KEY, btree ("claimId")
- "DMEClaims_beneficiaryId_idx" btree ("beneficiaryId")
- Foreign-key constraints:
- "DMEClaims_beneficiaryId_to_Beneficiaries" FOREIGN KEY ("beneficiaryId") REFERENCES "Beneficiaries"("beneficiaryId")
- Referenced by:
- TABLE ""DMEClaimLines"" CONSTRAINT "DMEClaimLines_parentClaim_to_DMEClaims" FOREIGN KEY ("parentClaim") REFERENCES "DMEClaims"("claimId")
- Tablespace: "dmeclaims_ts"
- > \d "DMEClaimLines"
- Table "public.DMEClaimLines"
- Column | Type | Modifiers
- ---------------------------------+-----------------------+-----------
- lineNumber | numeric | not null
- parentClaim | character varying(15) | not null
- allowedChargeAmount | numeric(12,2) | not null
- beneficiaryPartBDeductAmount | numeric(12,2) | not null
- beneficiaryPaymentAmount | numeric(12,2) | not null
- betosCode | character varying(3) |
- cmsServiceTypeCode | character(1) | not null
- coinsuranceAmount | numeric(12,2) | not null
- diagnosisCode | character varying(7) |
- diagnosisCodeVersion | character(1) |
- firstExpenseDate | date |
- hcpcsCode | character varying(5) |
- hcpcsFourthModifierCode | character varying(5) |
- hcpcsInitialModifierCode | character varying(5) |
- hcpcsSecondModifierCode | character varying(5) |
- hcpcsThirdModifierCode | character varying(5) |
- hctHgbTestResult | numeric(3,1) | not null
- hctHgbTestTypeCode | character varying(2) |
- lastExpenseDate | date |
- mtusCode | character(1) |
- mtusCount | numeric | not null
- nationalDrugCode | character varying(11) |
- paymentAmount | numeric(12,2) | not null
- paymentCode | character(1) |
- placeOfServiceCode | character varying(2) | not null
- pricingStateCode | character varying(2) |
- primaryPayerAllowedChargeAmount | numeric(12,2) | not null
- primaryPayerCode | character(1) |
- primaryPayerPaidAmount | numeric(12,2) | not null
- processingIndicatorCode | character varying(2) |
- providerBillingNumber | character varying(10) |
- providerNPI | character varying(12) |
- providerParticipatingIndCode | character(1) |
- providerPaymentAmount | numeric(12,2) | not null
- providerSpecialityCode | character varying(3) |
- providerStateCode | character varying(2) | not null
- providerTaxNumber | character varying(10) | not null
- purchasePriceAmount | numeric(12,2) | not null
- screenSavingsAmount | numeric(12,2) |
- serviceCount | numeric | not null
- serviceDeductibleCode | character(1) |
- submittedChargeAmount | numeric(12,2) | not null
- supplierTypeCode | character(1) |
- Indexes:
- "DMEClaimLines_pkey" PRIMARY KEY, btree ("parentClaim", "lineNumber")
- Foreign-key constraints:
- "DMEClaimLines_parentClaim_to_DMEClaims" FOREIGN KEY ("parentClaim") REFERENCES "DMEClaims"("claimId")
- Tablespace: "dmeclaimlines_ts"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement