Output

The Read Exceptions stage returns records from the exception repository that have been approved and that match the selection criteria specified in the Read Exception options. In addition to the records' fields, Read Exceptions returns these fields which describe the last modifications made to the record in the Business Steward Portal.

Table 1. Read Exceptions Output

Field Name

Description

Exception.Comment

Any comments entered by the person who resolved the exception. For example, comments might describe the modifications that the business steward made to the record.

Exception.LastModifiedBy

The last user to modify the record in the Business Steward Portal

Exception.LastModifiedMilliseconds

The time that the record was last modified in the Business Steward Portal. The time is expressed in milliseconds since January 1, 1970 0:00 GMT. This is the standard way of calculating time in the Java programming language. You can use this value to perform date comparisons, or to create a transform to convert this value to whatever date format you want.

Exception.LastModifiedString

The time that the record was last modified in the Business Steward Portal. This field provides a more understandable representation of the date than the Exception.LastModifiedMilliseconds field. The time is expressed in this format:

Thu Feb 17 13:34:32 CST 2011