Document
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 the Use_log.identification field. |
| documentIdentifier | 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. |
| documentCategoryCode | Record | record_grp | Parameter type is char(32) instead of char(2) specified by FESD standard. |
| titleText | Record_title | text | |
| paperIndicator | 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. |
| paperPlacementDescriptionText | Record | physical_reference | |
| documentStatusCode | Record | record_type | Parameter type is char(32) instead of char(2) specified by FESD standard. |
| creatorReference | Record | 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. |
| nonDisclosureDescriptionText | Record | legislation_ref | Parameter type is varchar(256) instead of char(16) specified by FESD standard. |
| comment | See Record Comment. | ||