Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
facilityid | int | 4 | √ | null |
|
|
||||
facility | varchar | 75 | √ | null |
|
|
||||
facilitycode | varchar | 5 | √ | null |
|
|
||||
patientid | int | 4 | √ | null |
|
|
||||
lastname | varchar | 50 | √ | null |
|
|
||||
firstname | varchar | 50 | √ | null |
|
|
||||
patientnumber | varchar | 35 | √ | null |
|
|
||||
payerid | int | 4 | √ | null |
|
|
||||
payer | varchar | 50 | √ | null |
|
|
||||
effectivedate | datetime | 16,3 | √ | null |
|
|
||||
ineffectivedate | datetime | 16,3 | √ | null |
|
|
||||
insuranceid | int | 4 | √ | null |
|
|
||||
insurance | varchar | 80 | √ | null |
|
|
||||
plantype | varchar | 254 | √ | null |
|
|
||||
insurance_plan | varchar | 100 | √ | null |
|
|
||||
insuredsname | varchar | 102 | √ | null |
|
|
||||
patientrelationship | varchar | 3 | √ | null |
|
|
||||
policynumber | varchar | 30 | √ | null |
|
|
||||
groupname | varchar | 50 | √ | null |
|
|
||||
groupnumber | varchar | 30 | √ | null |
|
|
||||
varchar | 30 | √ | null |
|
|
|||||
medicareadvantageplan | varchar | 1 | √ | null |
|
|
||||
insuranceaddressid | int | 4 | √ | null |
|
|
||||
clientpayerinfoid | int | 4 | √ | null |
|
|
||||
deleted | varchar | 1 | √ | null |
|
|