aurora_standard.chm1500r
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| fac_no | char(3) | YES | ||||
| visit_no | int(11) | YES | MUL | |||
| id_1500 | char(3) | YES | ||||
| date_created | date | YES | ||||
| date_printed | date | YES | ||||
| date_emc | date | YES | ||||
| payor_source | char(1) | YES | ||||
| emc_flag | char(3) | YES | ||||
| input_by | int(11) | YES | ||||
| pos_1532 | char(2) | YES | ||||
| amt_paid | decimal(8,2) | YES | ||||
| type_claim | char(2) | YES | ||||
| box_19 | char(71) | YES | ||||
| fin_class | char(5) | YES | ||||
| diag_type_1 | char(1) | YES | ||||
| diag_code_1 | char(7) | YES | ||||
| diag_type_2 | char(1) | YES | ||||
| diag_code_2 | char(7) | YES | ||||
| diag_type_3 | char(1) | YES | ||||
| diag_code_3 | char(7) | YES | ||||
| diag_type_4 | char(1) | YES | ||||
| diag_code_4 | char(7) | YES | ||||
| diag_type_5 | char(1) | YES | ||||
| diag_code_5 | char(7) | YES | ||||
| diag_type_6 | char(1) | YES | ||||
| diag_code_6 | char(7) | YES | ||||
| diag_type_7 | char(1) | YES | ||||
| diag_code_7 | char(7) | YES | ||||
| diag_type_8 | char(1) | YES | ||||
| diag_code_8 | char(7) | YES | ||||
| diag_type_9 | char(1) | YES | ||||
| diag_code_9 | char(7) | YES | ||||
| diag_type_10 | char(1) | YES | ||||
| diag_code_10 | char(7) | YES | ||||
| diag_type_11 | char(1) | YES | ||||
| diag_code_11 | char(7) | YES | ||||
| diag_type_12 | char(1) | YES | ||||
| diag_code_12 | char(7) | YES | ||||
| pat_last_name | char(20) | YES | MUL | |||
| pat_first_name | char(20) | YES | ||||
| ins_co | smallint(6) | YES | ||||
| icd_ind | char(1) | YES | ||||
| n_10d | char(19) | YES | ||||
| n_11b_qual | char(2) | YES | ||||
| n_11b | char(28) | YES | ||||
| n_14 | date | YES | ||||
| n_14_qual | char(3) | YES | ||||
| n_15_qual | char(3) | YES | ||||
| n_15 | date | YES | ||||
| n_16_from | date | YES | ||||
| n_16_to | date | YES | ||||
| n_17_qual | char(2) | YES | ||||
| n_17_name | char(26) | YES | ||||
| n_17a_qual | char(2) | YES | ||||
| n_17a_id | char(17) | YES | ||||
| n_17b_npi | int(10) | YES | ||||
| n_18_from | date | YES | ||||
| n_18_to | date | YES | ||||
| n_22code | char(11) | YES | ||||
| n_22ref | char(18) | YES | ||||
| n_23 | char(29) | YES | ||||
| n_25 | char(20) | YES | ||||
| n_31a_phyno | smallint(6) | YES | ||||
| n_31a_nm | char(20) | YES | ||||
| n_31a_dt | date | YES | ||||
| n_31b_phyno | smallint(6) | YES | ||||
| n_31b_nm | char(20) | YES | ||||
| n_31b_dt | date | YES | ||||
| n_32_1 | char(26) | YES | ||||
| n_32_2 | char(26) | YES | ||||
| n_32_3 | char(26) | YES | ||||
| n_32a_npi | int(10) | YES | ||||
| n_32b_qual | char(2) | YES | ||||
| n_32b_id | char(17) | YES | ||||
| n_33_phyno | smallint(6) | YES | ||||
| n_33_ph | char(10) | YES | ||||
| n_33_1 | char(26) | YES | ||||
| n_33_2 | char(26) | YES | ||||
| n_33_3 | char(26) | YES | ||||
| n_33a_npi | int(10) | YES | ||||
| n_33b_qual | char(2) | YES | ||||
| n_33b_id | char(17) | YES | ||||
| billc_no | int(11) | YES | ||||
| bill_status | char(3) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |