FO_Client_Provs
This table is used to cross reference clients to providers. It allows you to map one or more clients to a provider code. The system will execute this rule at the time the User picks an ordering physician in the order screen.
Each record in this table represents a single Provider code Client Code pair.
| Field | Type | Notes |
|---|---|---|
|
ClientCode |
varchar(50) |
Enter a unique client code. |
|
ProviderCode |
varchar(50) |
Provider code for this client. Enter a valid provider code. |
|
ClientProviders_ID |
int |
ID field, a counter. Unique |
|
EditDate |
datetime |
Date record was last edited. Informational |
|
CreateDate |
datetime |
Date record was created. Informational |