01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
RATE_CLASS→RATE_CLASSES.RATE_CLASSTYPE_OF_SERVICE→V_TYPE_OF_SERVICE.TYPE_OF_SERVICEPROC_UNIT_CODE→PROCEDURE_UNITS.PROC_UNIT_CODEPROC_CODE,CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHOD
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | PROC_CODE PK | string | varchar(20) | no | |
| 2 | CODING_METHOD PK | string | varchar(5) | no | |
| 3 | RATE_CLASS PK | string | varchar(15) | no | |
| 4 | EFFECTIVE_DATE PK | datetime | datetime | no | |
| 5 | PROC_CODE_TRANSLATION | string | varchar(20) | yes | |
| 6 | TYPE_OF_SERVICE | string | varchar(2) | yes | |
| 7 | CHARGE | decimal | decimal(19,4) | yes | |
| 8 | APPROVED | decimal | decimal(19,4) | yes | |
| 9 | EXPECTED_AMT | decimal | decimal(19,4) | yes | |
| 10 | UNIT_MINUTES | integer | int | yes | |
| 11 | PROC_UNIT_CODE | string | varchar(20) | yes | |
| 12 | MAX_UNITS | decimal | numeric(10,2) | yes |