CaseFile Comment
Comments are related to their CaseFiles via file_key fields in File and File_comment tables.
Mapping of the FESD attributes to the WorkZone FESD Web Services database fields and notes on WorkZone FESD Web Services implementation are presented in the table below.
| FESD Parameter | WorkZone FESD Web Services Table | WorkZone FESD Web Services Field |
WorkZone FESD Web Services Implementation Notes |
|---|---|---|---|
| informationTypeCode | File_comment | comment_type | Parameter type is char(32) instead of char(2) specified by FESD standard. |
| cancellationDate | File_comment | delete_date | |
| createdOnBehalfOfReference | File_comment | on_behalf_of | Parameter type is GUID instead of int(10) specified by FESD standard. Algorithms of storing and fetching this parameter to / from WorkZone FESD Web Services database are similar to algorithms for caseFileResponsibleOfficerReference parameter of CaseFile. |
| commentText | File_comment | text | |
| commentDocumentReference | File_comment | vattach_record_key | Parameter type is GUID instead of int(10) specified by FESD standard. |