CLAIMS_TRANSACTIONS

1155144 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 255
CLAIMID VARCHAR 255
CLAIMS.ID SYS_CONSTRAINT_676356a4-d67c-49f9-b7f2-4c8a8bdfda1aR
CHARGEID VARCHAR 255
PATIENTID VARCHAR 255
PATIENTS.ID SYS_CONSTRAINT_6f8538f1-dd06-4a3e-b554-a5d33494e001R
TYPE VARCHAR 255
AMOUNT NUMBER 10,2 √
METHOD VARCHAR 255 √
FROM_DATE DATE 0 √
TO_DATE DATE 0 √
PLACE_OF_SERVICE VARCHAR 255 √
PROCEDURE_CODE VARCHAR 255 √
MODIFIER1 VARCHAR 255 √
MODIFIER2 VARCHAR 255 √
DIAGNOSIS_REF1 VARCHAR 255 √
DIAGNOSIS_REF2 VARCHAR 255 √
DIAGNOSIS_REF3 VARCHAR 255 √
DIAGNOSIS_REF4 VARCHAR 255 √
UNITS NUMBER 38 √
DEPARTMENTID VARCHAR 255
NOTES VARCHAR 255 √
UNITAMOUNT NUMBER 10,2 √
TRANSFEROUTID VARCHAR 255 √
TRANSFERTYPE VARCHAR 255 √
PAYMENTS NUMBER 10,2 √
ADJUSTMENTS NUMBER 10,2 √
TRANSFERS NUMBER 10,2 √
OUTSTANDING NUMBER 10,2 √
APPOINTMENT_ID VARCHAR 255 √
LINE_NOTE VARCHAR 255 √
PATIENT_INSURANCE_ID VARCHAR 255 √
FEE_SCHEDULE_ID VARCHAR 255 √
PROVIDER_ID VARCHAR 255 √
PROVIDERS.ID SYS_CONSTRAINT_b579a988-667d-404c-9aa6-f9f9efc91bbcR
SUPERVISING_PROVIDER_ID VARCHAR 255 √
PROVIDERS.ID SYS_CONSTRAINT_9b50a613-0087-48a5-a774-1a2914ffc590R

Relationships

Close relationships within degrees of separation