01Relates to the patient
reference data (no patient link)
Single-patient export: not included (not referenced by patient records).
02References
SERVICE_NAME→SERVICES.SERVICE_NAMEPROC_CODE,CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHODRULE_SERVICE_NAME→SERVICES.SERVICE_NAMEVALUE_APG_CODE→APG_CODES.APG_CODEVALUE_DIAG_CODE_CLASS→DIAG_CLASSES.DIAG_CLASSVALUE_LOCATION_CLASS→LOCATION_CLASSES.LOCATION_CLASSOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONREV_CODE→REV_CODES.REV_CODEVALUE_DEPT_CODE→DEPARTMENTS.DEPT_CODEVALUE_DIAG_CODE→DIAGNOSIS_CODES.DIAG_CODEVALUE_PAYOR_CLASS→PAYOR_CLASSES.PAYOR_CLASSVALUE_PROVIDER_CLASS→PROVIDER_CLASSES.PROVIDER_CLASSVALUE_RATE_CLASS→RATE_CLASSES.RATE_CLASSVALUE_OFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONVALUE_COMPANY_CODE→PAYORS.COMPANY_CODEVALUE_PROC_CODE,VALUE_CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHODVALUE_PROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | SERVICE_NAME PK | string | varchar(40) | no | |
| 2 | RULE_SEQUENCE PK | integer | int | no | |
| 3 | RULE_DESCRIPTION | string | varchar(40) | no | |
| 4 | RULE_TYPE | integer | int | no | |
| 5 | VALUE_OPERATOR | integer | int | no | |
| 6 | RULE_ACTION | integer | int | no | |
| 7 | STOP_RULES | boolean | bit | no | |
| 8 | VALUE_INT | integer | int | yes | |
| 9 | VALUE_INT_2 | integer | int | yes | |
| 10 | VALUE_DATETIME | datetime | datetime | yes | |
| 11 | VALUE_DATETIME_2 | datetime | datetime | yes | |
| 12 | VALUE_CHAR | string | varchar(40) | yes | |
| 13 | VALUE_CHAR_2 | string | varchar(40) | yes | |
| 14 | RULE_SERVICE_NAME | string | varchar(40) | yes | |
| 15 | PROC_CODE | string | varchar(20) | yes | |
| 16 | CODING_METHOD | string | varchar(5) | yes | |
| 17 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 18 | VALUE_PROC_CODE | string | varchar(20) | yes | |
| 19 | VALUE_CODING_METHOD | string | varchar(5) | yes | |
| 20 | VALUE_COMPANY_CODE | string | varchar(20) | yes | |
| 21 | VALUE_RATE_CLASS | string | varchar(15) | yes | |
| 22 | VALUE_DIAG_CODE | string | varchar(8) | yes | |
| 23 | VALUE_PAYOR_CLASS | string | varchar(15) | yes | |
| 24 | VALUE_PROVIDER_CLASS | string | varchar(15) | yes | |
| 25 | VALUE_OFFICE_LOCATION | string | varchar(20) | yes | |
| 26 | VALUE_PROGRAM_CODE | string | varchar(15) | yes | |
| 27 | VALUE_DEPT_CODE | string | varchar(15) | yes | |
| 28 | VALUE_LOCATION_CLASS | string | varchar(15) | yes | |
| 29 | VALUE_APG_CODE | string | varchar(4) | yes | |
| 30 | VALUE_PROV_DEGREE | string | varchar(15) | yes | |
| 31 | VALUE_DIAG_CODE_CLASS | string | varchar(15) | yes | |
| 32 | REV_CODE | string | varchar(5) | yes | |
| 33 | REF_PROV_CODE | string | varchar(20) | yes | |
| 34 | APG_CODE | string | varchar(4) | yes | |
| 35 | VALUE_SED | string | char(1) | yes | |
| 36 | VALUE_LANGUAGE_INCENTIVE | string | char(1) | yes | |
| 37 | VALUE_INTERPRETER_INCENTIVE | boolean | bit | yes |