COAUPDATEFILE
Stores the files for the AddressFinder process.
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| REQUESTFILE | varbinary | yes | The file generated by the process that is uploaded to Blackbaud. | |
| CASSRPTFILE | varbinary | yes | The CASSRPT pdf file generated by the process that is downloaded from Blackbaud. | |
| NCOARPTFILE | varbinary | yes | The NCOARPT pdf file generated by the process that is downloaded from Blackbaud. |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ID | uniqueidentifier | COAUPDATE.ID | Primary Key. |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_COAUPDATEFILE | ID | yes | yes | yes |