_8.encounters_claims_files
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| ecf_id | int(11) | NO | PRI | auto_increment | ||
| ecf_cus_id | int(11) | NO | Customer Id | |||
| ecf_cli_id | int(11) | NO | MUL | Client Id | ||
| ecf_usr_id | int(11) | NO | MUL | User Id | ||
| ecf_claim_type | varchar(45) | NO | MUL | Claim file type | ||
| ecf_path | text | NO | Cloud files path | |||
| ecf_status | int(11) | NO | 0 | MUL | 0: Generated, 1: Sent, 2: Clearinghouse Received, 3: or Payer Received | |
| ecf_ebat_id | int(11) | NO | MUL | links to associated batch row | ||
| ecf_clm_cnt | int(11) | NO | 0 | # of claim segments | ||
| ecf_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ecf_id |
|