API tools faq
paste
Advertisement
Guest User

PostgreSQL Question: Schema for Slow Tables

a guest
Mar 26th, 2018
183
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.08 KB | None | 0 0
raw download clone embed print report
  1. > \d "OutpatientClaims"
  2. Table "public.OutpatientClaims"
  3. Column | Type | Modifiers
  4. ------------------------------------+-----------------------+-----------
  5. claimId | character varying(15) | not null
  6. attendingPhysicianNpi | character varying(10) |
  7. attendingPhysicianUpin | character varying(9) |
  8. beneficiaryId | character varying(15) | not null
  9. beneficiaryPaymentAmount | numeric(12,2) | not null
  10. bloodDeductibleLiabilityAmount | numeric(12,2) | not null
  11. claimFacilityTypeCode | character(1) | not null
  12. claimFrequencyCode | character(1) | not null
  13. claimGroupId | numeric(12,0) | not null
  14. claimNonPaymentReasonCode | character varying(2) |
  15. claimPrimaryPayerCode | character(1) |
  16. claimQueryCode | character(1) | not null
  17. claimServiceClassificationTypeCode | character(1) | not null
  18. claimTypeCode | character varying(2) | not null
  19. coinsuranceAmount | numeric(12,2) | not null
  20. dateFrom | date | not null
  21. dateThrough | date | not null
  22. deductibleAmount | numeric(12,2) | not null
  23. diagnosis10Code | character varying(7) |
  24. diagnosis10CodeVersion | character(1) |
  25. diagnosis11Code | character varying(7) |
  26. diagnosis11CodeVersion | character(1) |
  27. diagnosis12Code | character varying(7) |
  28. diagnosis12CodeVersion | character(1) |
  29. diagnosis13Code | character varying(7) |
  30. diagnosis13CodeVersion | character(1) |
  31. diagnosis14Code | character varying(7) |
  32. diagnosis14CodeVersion | character(1) |
  33. diagnosis15Code | character varying(7) |
  34. diagnosis15CodeVersion | character(1) |
  35. diagnosis16Code | character varying(7) |
  36. diagnosis16CodeVersion | character(1) |
  37. diagnosis17Code | character varying(7) |
  38. diagnosis17CodeVersion | character(1) |
  39. diagnosis18Code | character varying(7) |
  40. diagnosis18CodeVersion | character(1) |
  41. diagnosis19Code | character varying(7) |
  42. diagnosis19CodeVersion | character(1) |
  43. diagnosis1Code | character varying(7) |
  44. diagnosis1CodeVersion | character(1) |
  45. diagnosis20Code | character varying(7) |
  46. diagnosis20CodeVersion | character(1) |
  47. diagnosis21Code | character varying(7) |
  48. diagnosis21CodeVersion | character(1) |
  49. diagnosis22Code | character varying(7) |
  50. diagnosis22CodeVersion | character(1) |
  51. diagnosis23Code | character varying(7) |
  52. diagnosis23CodeVersion | character(1) |
  53. diagnosis24Code | character varying(7) |
  54. diagnosis24CodeVersion | character(1) |
  55. diagnosis25Code | character varying(7) |
  56. diagnosis25CodeVersion | character(1) |
  57. diagnosis2Code | character varying(7) |
  58. diagnosis2CodeVersion | character(1) |
  59. diagnosis3Code | character varying(7) |
  60. diagnosis3CodeVersion | character(1) |
  61. diagnosis4Code | character varying(7) |
  62. diagnosis4CodeVersion | character(1) |
  63. diagnosis5Code | character varying(7) |
  64. diagnosis5CodeVersion | character(1) |
  65. diagnosis6Code | character varying(7) |
  66. diagnosis6CodeVersion | character(1) |
  67. diagnosis7Code | character varying(7) |
  68. diagnosis7CodeVersion | character(1) |
  69. diagnosis8Code | character varying(7) |
  70. diagnosis8CodeVersion | character(1) |
  71. diagnosis9Code | character varying(7) |
  72. diagnosis9CodeVersion | character(1) |
  73. diagnosisAdmission1Code | character varying(7) |
  74. diagnosisAdmission1CodeVersion | character(1) |
  75. diagnosisAdmission2Code | character varying(7) |
  76. diagnosisAdmission2CodeVersion | character(1) |
  77. diagnosisAdmission3Code | character varying(7) |
  78. diagnosisAdmission3CodeVersion | character(1) |
  79. diagnosisExternal10Code | character varying(7) |
  80. diagnosisExternal10CodeVersion | character(1) |
  81. diagnosisExternal11Code | character varying(7) |
  82. diagnosisExternal11CodeVersion | character(1) |
  83. diagnosisExternal12Code | character varying(7) |
  84. diagnosisExternal12CodeVersion | character(1) |
  85. diagnosisExternal1Code | character varying(7) |
  86. diagnosisExternal1CodeVersion | character(1) |
  87. diagnosisExternal2Code | character varying(7) |
  88. diagnosisExternal2CodeVersion | character(1) |
  89. diagnosisExternal3Code | character varying(7) |
  90. diagnosisExternal3CodeVersion | character(1) |
  91. diagnosisExternal4Code | character varying(7) |
  92. diagnosisExternal4CodeVersion | character(1) |
  93. diagnosisExternal5Code | character varying(7) |
  94. diagnosisExternal5CodeVersion | character(1) |
  95. diagnosisExternal6Code | character varying(7) |
  96. diagnosisExternal6CodeVersion | character(1) |
  97. diagnosisExternal7Code | character varying(7) |
  98. diagnosisExternal7CodeVersion | character(1) |
  99. diagnosisExternal8Code | character varying(7) |
  100. diagnosisExternal8CodeVersion | character(1) |
  101. diagnosisExternal9Code | character varying(7) |
  102. diagnosisExternal9CodeVersion | character(1) |
  103. diagnosisExternalFirstCode | character varying(7) |
  104. diagnosisExternalFirstCodeVersion | character(1) |
  105. diagnosisPrincipalCode | character varying(7) |
  106. diagnosisPrincipalCodeVersion | character(1) |
  107. fiscalIntermediaryClaimProcessDate | date |
  108. fiscalIntermediaryNumber | character varying(5) |
  109. mcoPaidSw | character(1) |
  110. nearLineRecordIdCode | character(1) | not null
  111. operatingPhysicianNpi | character varying(10) |
  112. operatingPhysicianUpin | character varying(9) |
  113. organizationNpi | character varying(10) |
  114. otherPhysicianNpi | character varying(10) |
  115. otherPhysicianUpin | character varying(9) |
  116. patientDischargeStatusCode | character varying(2) |
  117. paymentAmount | numeric(12,2) | not null
  118. primaryPayerPaidAmount | numeric(12,2) | not null
  119. procedure10Code | character varying(7) |
  120. procedure10CodeVersion | character(1) |
  121. procedure10Date | date |
  122. procedure11Code | character varying(7) |
  123. procedure11CodeVersion | character(1) |
  124. procedure11Date | date |
  125. procedure12Code | character varying(7) |
  126. procedure12CodeVersion | character(1) |
  127. procedure12Date | date |
  128. procedure13Code | character varying(7) |
  129. procedure13CodeVersion | character(1) |
  130. procedure13Date | date |
  131. procedure14Code | character varying(7) |
  132. procedure14CodeVersion | character(1) |
  133. procedure14Date | date |
  134. procedure15Code | character varying(7) |
  135. procedure15CodeVersion | character(1) |
  136. procedure15Date | date |
  137. procedure16Code | character varying(7) |
  138. procedure16CodeVersion | character(1) |
  139. procedure16Date | date |
  140. procedure17Code | character varying(7) |
  141. procedure17CodeVersion | character(1) |
  142. procedure17Date | date |
  143. procedure18Code | character varying(7) |
  144. procedure18CodeVersion | character(1) |
  145. procedure18Date | date |
  146. procedure19Code | character varying(7) |
  147. procedure19CodeVersion | character(1) |
  148. procedure19Date | date |
  149. procedure1Code | character varying(7) |
  150. procedure1CodeVersion | character(1) |
  151. procedure1Date | date |
  152. procedure20Code | character varying(7) |
  153. procedure20CodeVersion | character(1) |
  154. procedure20Date | date |
  155. procedure21Code | character varying(7) |
  156. procedure21CodeVersion | character(1) |
  157. procedure21Date | date |
  158. procedure22Code | character varying(7) |
  159. procedure22CodeVersion | character(1) |
  160. procedure22Date | date |
  161. procedure23Code | character varying(7) |
  162. procedure23CodeVersion | character(1) |
  163. procedure23Date | date |
  164. procedure24Code | character varying(7) |
  165. procedure24CodeVersion | character(1) |
  166. procedure24Date | date | procedure25Code | character varying(7) |
  167. procedure25CodeVersion | character(1) |
  168. procedure25Date | date |
  169. procedure2Code | character varying(7) |
  170. procedure2CodeVersion | character(1) |
  171. procedure2Date | date |
  172. procedure3Code | character varying(7) |
  173. procedure3CodeVersion | character(1) |
  174. procedure3Date | date |
  175. procedure4Code | character varying(7) |
  176. procedure4CodeVersion | character(1) |
  177. procedure4Date | date |
  178. procedure5Code | character varying(7) |
  179. procedure5CodeVersion | character(1) |
  180. procedure5Date | date |
  181. procedure6Code | character varying(7) |
  182. procedure6CodeVersion | character(1) |
  183. procedure6Date | date |
  184. procedure7Code | character varying(7) |
  185. procedure7CodeVersion | character(1) |
  186. procedure7Date | date |
  187. procedure8Code | character varying(7) |
  188. procedure8CodeVersion | character(1) |
  189. procedure8Date | date |
  190. procedure9Code | character varying(7) |
  191. procedure9CodeVersion | character(1) |
  192. procedure9Date | date |
  193. professionalComponentCharge | numeric(12,2) | not null
  194. providerNumber | character varying(9) | not null
  195. providerPaymentAmount | numeric(12,2) | not null
  196. providerStateCode | character varying(2) | not null
  197. totalChargeAmount | numeric(12,2) | not null
  198. weeklyProcessDate | date | not null
  199. finalAction | character(1) | not null
  200. Indexes:
  201. "OutpatientClaims_pkey" PRIMARY KEY, btree ("claimId")
  202. "OutpatientClaims_beneficiaryId_idx" btree ("beneficiaryId")
  203. Foreign-key constraints:
  204. "OutpatientClaims_beneficiaryId_to_Beneficiaries" FOREIGN KEY ("beneficiaryId") REFERENCES "Beneficiaries"("beneficiaryId")
  205. Referenced by:
  206. TABLE ""OutpatientClaimLines"" CONSTRAINT "OutpatientClaimLines_parentClaim_to_OutpatientClaims" FOREIGN KEY ("parentClaim") REFERENCES "OutpatientClaims"("claimId")
  207. Tablespace: "outpatientclaims_ts"
  208.  
  209.  
  210. > \d "OutpatientClaimLines"
  211. Table "public.OutpatientClaimLines"
  212. Column | Type | Modifiers
  213. -------------------------------------+-----------------------+-----------
  214. lineNumber | numeric | not null
  215. parentClaim | character varying(15) | not null
  216. apcOrHippsCode | character varying(5) |
  217. benficiaryPaymentAmount | numeric(12,2) | not null
  218. bloodDeductibleAmount | numeric(12,2) | not null
  219. cashDeductibleAmount | numeric(12,2) | not null
  220. discountCode | character(1) |
  221. firstMspPaidAmount | numeric(12,2) | not null
  222. hcpcsCode | character varying(5) |
  223. hcpcsInitialModifierCode | character varying(5) |
  224. hcpcsSecondModifierCode | character varying(5) |
  225. nationalDrugCode | character varying(24) |
  226. nationalDrugCodeQualifierCode | character varying(2) |
  227. nationalDrugCodeQuantity | numeric |
  228. nonCoveredChargeAmount | numeric(12,2) | not null
  229. obligationToAcceptAsFullPaymentCode | character(1) |
  230. packagingCode | character(1) |
  231. patientResponsibilityAmount | numeric(12,2) | not null
  232. paymentAmount | numeric(12,2) | not null
  233. paymentMethodCode | character varying(2) |
  234. providerPaymentAmount | numeric(12,2) | not null
  235. rateAmount | numeric(12,2) | not null
  236. reducedCoinsuranceAmount | numeric(12,2) | not null
  237. revCntr1stAnsiCd | character varying(5) |
  238. revCntr2ndAnsiCd | character varying(5) |
  239. revCntr3rdAnsiCd | character varying(5) |
  240. revCntr4thAnsiCd | character varying(5) |
  241. revenueCenterCode | character varying(4) | not null
  242. revenueCenterDate | date |
  243. revenueCenterRenderingPhysicianNPI | character varying(12) |
  244. revenueCenterRenderingPhysicianUPIN | character varying(12) |
  245. secondMspPaidAmount | numeric(12,2) | not null
  246. statusCode | character varying(2) |
  247. totalChargeAmount | numeric(12,2) | not null
  248. unitCount | numeric | not null
  249. wageAdjustedCoinsuranceAmount | numeric(12,2) | not null
  250. Indexes:
  251. "OutpatientClaimLines_pkey" PRIMARY KEY, btree ("parentClaim", "lineNumber")
  252. Foreign-key constraints:
  253. "OutpatientClaimLines_parentClaim_to_OutpatientClaims" FOREIGN KEY ("parentClaim") REFERENCES "OutpatientClaims"("claimId")
  254. Tablespace: "outpatientclaimlines_ts"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!