CaseFile

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 File fesd_id_key Parameter type is GUID instead of int(10) specified by FESD standard.
uniqueIdentifier File fesd_id_key Parameter type is GUID instead of int(10) specified by FESD standard.
caseFileNumber File file_no  
caseFileNumberIdentifier File file_no  
fileClass File file_class

Obsolete.

This parameter was added by KMD because file.file_class field was mandatory in Captia and did not contain default values. The field was intended to classify CaseFiles in Captia.
year File year Currently not supported by OpenWSI.
sequenceNumber File file_key  
paperIndicator File medium Parameter type is unsignedByte instead of char(1) specified by FESD standard. Method accepts only ‘0’ and ‘1’.
creationDate File created  
titleText File_title text  
titleNonDisclosureIndicator File not_public_title 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.
titleNonDisclosureText File public_title  
caseFileStatusCode File state Parameter type is char(32) instead of char(2) specified by FESD standard.
caseFileTypeCode File file_type Parameter type is char(32) instead of char(10) specified by FESD standard.
caseFileResponsibleOfficerReference File officer

Parameter type is GUID instead of int(10) specified by FESD standard.

The parameter is stored in WorkZone FESD Web Services database by the following algorithm:

  1. Retrieve name_key from a row found in Name table by fesd_id_key = incoming GUID.
  2. Retrieve name_code from a row found in Employee table by name_key = found name_key
  3. Retrieved value is used for storing into the field. The reversed algorithm is used for retrieving a value from the field.
nonDisclosureDescriptionText File legislation_ref  
latestRecordDate N/A N/A Currently not supported by OpenWSI. Ignored at input.
retentionTime File retention  
disposalCode File disposal_code Parameter type is char(32) instead of char(2) specified by FESD standard.
disposalDate File disposal  
precendensText File precendent  
precendensReference N/A N/A Not implemented by OpenWSI. Ignored at input.
loanDate File_location date_received  
borrowerReference File_location name_code 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.
numberHistoricIdentifier File previous_no  
createdByReference File create_user Parameter type is GUID instead of int(10) specified by FESD standard. For output, it is retrieved as fesd_id_key from a row found in Users table by user_name = value of the field.
latestUpdateByReference File update_user Parameter type is GUID instead of date specified by FESD standard. For output, it is retrieved as fesd_id_key from a row found in Users table by user_name = value of the field.
lastUpdateDate File updated Parameter type is date instead of int(10) specified by FESD standard.
comment See CaseFile Comment.  
reminder See CaseFile Reminder.  
caseFilePartyReference See CaseFile Party.  
caseFileObjectReference, caseFileObjectName See CaseFile Object.  
caseFileParty File_name fesd_id_key Parameter type is GUID instead of int(10) specified by FESD standard. Each Party is stored as a separate row in the File_name table.
caseFileObject File_name fesd_id_key Parameter type is GUID instead of int(10) specified by FESD standard. Each Object is stored as a separate row in the File_name table.