aurora_standard.chmgltcd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | MUL | |||
| date_created | date | YES | ||||
| a_seq_no | smallint(6) | YES | ||||
| a_level_of_care | varchar(2) | YES | ||||
| a_pat_status | varchar(2) | YES | ||||
| a_dos_from | date | YES | ||||
| a_dos_to | date | YES | ||||
| a_bill_days | decimal(2,0) | YES | ||||
| b_seq_no | smallint(6) | YES | ||||
| b_level_of_care | varchar(2) | YES | ||||
| b_pat_status | varchar(2) | YES | ||||
| b_dos_from | date | YES | ||||
| b_dos_to | date | YES | ||||
| b_bill_days | decimal(2,0) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
| ||||||||||||||||||||||||||
| date_created |
|