Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| payerid | int | 4 | √ | null |
|
|
||||
| payercode | varchar | 5 | √ | null |
|
|
||||
| payercode2 | varchar | 10 | √ | null |
|
|
||||
| payername | varchar | 50 | √ | null |
|
|
||||
| payertype | varchar | 20 | √ | null |
|
|
||||
| payeraccountid | int | 4 | √ | null |
|
|
||||
| createddate | datetime | 16,3 | √ | null |
|
|
||||
| revisiondate | datetime | 16,3 | √ | null |
|
|
||||
| deleted | varchar | 1 | √ | null |
|
|
||||
| roomchargebilldesc | varchar | 50 | √ | null |
|
|
||||
| useratedesc | char | 1 | √ | null |
|
|
||||
| showcarelevel | char | 1 | √ | null |
|
|
||||
| facilityid | int | 4 | √ | null |
|
|
||||
| mpprflag | char | 1 | √ | null |
|
|
||||
| ppsflag | char | 1 | √ | null |
|
|
||||
| collectionstemplateid | int | 4 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
