Data Source Descriptions: Extrinsic Attributes

All Workflow Entities support Extrinsic Attributes. See Workflow Attributes . Each Entity has a Report View which includes all Intrinsic Data, these view are listed below.

In addition, the system automatically generates an Extrinsic Reporting view for each Entity that includes all client specific Extrinsic fields. These extrinsic views are listed below.

For most data types, the data in the views is the same data seen in the UI, typed as a Decimal, Text, Datetime consistent with the datatype, except as noted below which are all Integer foreign keys. Template attributes are not supported for reporting.

Data Type	Type of Data

Data Type	Type of Data
Payment	Transaction ID which is a foreign key to Data Source Description: Payment Transactions
Member	Member ID which is a foreign key to Data Source Description: Profile
Superviser	Member ID which is a foreign key to Data Source Description: Profile
Upload	Upload ID which is a foreign key to the Upload table (not available for reporting)
Member Role	Member Role ID which is a foreign key to Data Source Description: Member Role
Assessment Instance	Assessment Instance ID which is a foreign key to Data Source Description: Assessment Instance
Assessment Definition	Assessment ID which is a foreign key to the Assessment Table (not available for reporting)
Learning Plan Instance	Learning Plan Instance ID which is a foreign key to Data Source Description: Applications
Seat Assignment	Seat Assignment ID which is a foreign key to the Seat Assignment table (not available) for reporting.
Address	Address ID which is a foreign key to the Address Table (not availalbe for reporting)

To make displaying the name of a member referenced in a Member, Member Role, and Supervisor attribute as a column on a report easier, these views also include an extra field for each of them, suffixed with “ | Member Name” which is a text field containing the member name corresponding to the data in the attribute. This avoid needed to join to the Data Source Description: Profile if only the name of the member is needed. [New in 12.3].

The extrinsic views also include the Primary Key used to join the data to the Intrinsic data source along with relevant foreign keys that can also be used for joining to other data sources.