aurora_standard.chmarstph
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rec_type | char(2) | YES | ||||
| rec_seq_no | char(2) | YES | ||||
| visit_no | char(20) | YES | MUL | |||
| filler | char(2) | YES | ||||
| att_npi | char(10) | YES | ||||
| filler1 | char(6) | YES | ||||
| sur_npi | char(10) | YES | ||||
| filler2 | char(6) | YES | ||||
| oth_phy | char(10) | YES | ||||
| filler3 | char(6) | YES | ||||
| oth_phy2 | char(10) | YES | ||||
| filler4 | char(6) | YES | ||||
| att_lname | char(16) | YES | ||||
| att_fname | char(8) | YES | ||||
| att_mi | char(1) | YES | ||||
| sur_lname | char(16) | YES | ||||
| sur_fname | char(8) | YES | ||||
| sur_mi | char(1) | YES | ||||
| oth_lname | char(16) | YES | ||||
| oth_fname | char(8) | YES | ||||
| oth_mi | char(1) | YES | ||||
| oth2_lname | char(16) | YES | ||||
| oth2_fname | char(8) | YES | ||||
| oth2_mi | char(1) | YES | ||||
| filler5 | char(171) | YES |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
| ||||||||||||||||||||||||||
| filler |
|