Record

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
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 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 FESD Web Services database, ‘0’ in method input and output = ’N’ in WorkZone 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 FESD Web Services database, ‘0’ in method input and output = ’E’ in WorkZone 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 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.