CLAIMS

192200 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 255
CLAIMS_TRANSACTIONS.CLAIMID SYS_CONSTRAINT_676356a4-d67c-49f9-b7f2-4c8a8bdfda1aR
PATIENT VARCHAR 255
PATIENTS.ID SYS_CONSTRAINT_07b0c7b7-417e-43df-9627-edd075257adbR
PROVIDER VARCHAR 255
PROVIDERS.ID SYS_CONSTRAINT_4597a0cb-8d64-4f2a-bff1-df1105eabf9aR
PRIMARY_PAYER VARCHAR 255
PAYERS.ID SYS_CONSTRAINT_2b47049d-4ec8-4e20-b2bf-dc99d9ac9b97R
SECONDARY_PAYER VARCHAR 255
PAYERS.ID SYS_CONSTRAINT_0c806c9c-2025-4196-aff7-62567b87176cR
DEPARTMENT VARCHAR 255
PATIENT_DEPARTMENT VARCHAR 255
DIAGNOSIS1 VARCHAR 255 √
DIAGNOSIS2 VARCHAR 255 √
DIAGNOSIS3 VARCHAR 255 √
DIAGNOSIS4 VARCHAR 255 √
DIAGNOSIS5 VARCHAR 255 √
DIAGNOSIS6 VARCHAR 255 √
DIAGNOSIS7 VARCHAR 255 √
DIAGNOSIS8 VARCHAR 255 √
REFERRINGPROVIDERID VARCHAR 255 √
PROVIDERS.ID SYS_CONSTRAINT_1b514eef-6d51-4e59-8004-7778a946dbaaR
APPOINTMENTID VARCHAR 255 √
CURRENTILLNESSDATE DATE 0 √
SERVICEDATE DATE 0 √
SUPERVISINGPROVIDERID VARCHAR 255
PROVIDERS.ID SYS_CONSTRAINT_06aef3a8-f461-4b77-b8f7-6564a2521e22R
STATUS1 VARCHAR 255 √
STATUS2 VARCHAR 255 √
STATUSP VARCHAR 255 √
OUTSTANDING1 NUMBER 38 √
OUTSTANDING2 NUMBER 38 √
OUTSTANDINGP NUMBER 38 √
LASTBILLEDDATE1 DATE 0 √
LASTBILLEDDATE2 DATE 0 √
LASTBILLEDDATEP DATE 0 √
HEALTHCARECLAIMTYPEID1 VARCHAR 255 √
HEALTHCARECLAIMTYPEID2 VARCHAR 255 √

Relationships

Close relationships within degrees of separation