Record
Mapping of the FESD attributes to the WorkZone Content Server FESD Web Services database fields and notes on WorkZone Content Server FESD Web Services implementation are presented in the table below.
| FESD Parameter | WorkZone Content Server FESD Web Services Table | WorkZone Content Server FESD Web Services Field | WorkZone Content Server FESD Web Services Implementation Notes |
|---|---|---|---|
| userIdentifier | N/A | N/A | Is recorded to Use_log.identification field. |
| caseFileIdentifier | Record | file_key | Parameter type is GUID. Corresponding file_key from File table is found by fesd_id_key equal to this value. |
| recordIdentifier | Record | fesd_id_key | Parameter type is GUID instead of int(10) specified by FESD standard. |
| uniqueIdentifier | Record | fesd_id_key | Parameter type is GUID instead of int(10) specified by FESD standard. |
| year | Record | N/A | Calculated as year part of the Record.created field. |
| sequenceNumber | Record | record_key | |
| caseFileReference | Record | file_key | Parameter type is GUID instead of char(10) specified by FESD standard. Used for output: Corresponding fesd_id_key from File table is found by file_key. |
| caseFileSequenceNumber | Record | record_no | |
| registrationDate | Record | created | Ignored at input. Is filled in with the date of Record creation. |
| documentTypeReference | Record | record_grp | Parameter type is char(32) instead of char(2) specified by FESD standard. |
| documentDate | Record | letter_date | |
| noDocumentDateIndicator | N/A | N/A | Ignored at input. Is not stored in WorkZone Content Server FESD Web Services database. Calculated for GetRecord method: ‘1’ if Record.letter_date is empty, ‘0’ otherwise |
| recordStatusCode | Record | record_type | Parameter type is char(32) instead of char(2) specified by FESD standard. |
| recordContentsDescriptionText | Record_title | text | |
| recordContentsDescriptionNonDisclosureIndicator | Record | not_public_desc | Parameter type is unsignedByte instead of char(1) specified by FESD standard. Method accepts only ‘0’ and ‘1’. ‘1’ in method input and output = ’J’ in WorkZone Content Server FESD Web Services database, ‘0’ in method input and output = ’N’ in WorkZone Content Server FESD Web Services database. |
| recordContentsAlternativeDescriptionText | Localized_record_text | text | |
| recordDepricationDate | Record | deprecation | |
| executionDate | Record | execution | |
| recordDeadline | Record | reply_time_limit_date | |
| nonDisclosureDescriptionText | Record | legislation_ref | |
| nonDisclosureEvaluationDate | Record | evaluation | |
| recordPaper | Record | medium | Parameter type is unsignedByte instead of char(1) specified by FESD standard. Method accepts only ‘0’ and ‘1’. ‘1’ in method input and output = ’P’ in WorkZone Content Server FESD Web Services database, ‘0’ in method input and output = ’E’ in WorkZone Content Server FESD Web Services database. |
| loanDate | Record_location | received | |
| borrowerReference | Record_location | recipient | Parameter type is GUID instead of int(10) specified by FESD standard. Algorithms of storing and fetching this parameter to / from WorkZone Content Server FESD Web Services database are similar to algorithms for caseFileResponsibleOfficerReference parameter of CaseFile. |
| createdByReference | Record | create_user | Parameter type is GUID instead of int(10) specified by FESD standard. Ignored in input. The field Record.create_user in database is filled in with name code of user who called CreateRecord method. For output, it is retrieved as fesd_id_key from a row found in Users table by user_name = value of the field. |
| lastUpdatedDate | Record | ||
| lastUpdatedByReference | Record | ||
| responsibleOfficerReference / responsibleCaseOfficerReference | Record | ||
| sender | Record_name | ||
| recipient | Record_name | ||
| comment | See Record Comment. | ||
| reminder | See Record Reminder. | ||
| documentAccosiation | See Record Document Association. | ||