Windchill Risk and Reliability Desktop Help > Overview > Functions > Reporting > Reports for Association Table Types > FRACAS Reports with Associations
FRACAS Reports with Associations
The following table describes the expected behavior and permitted filters based on tables in a single FRACAS report.
Tables on Report
Expected Behavior
Permitted Filters
Problems
Works like a Problems report in earlier Windchill Risk and Reliability versions.
Problems
Problems, Incident
Works like a FRACAS Incidents report in earlier Windchill Risk and Reliability versions.
FRACAS Incidents
System Tree to Problem Associations
Shows all records from the associations table.
Problems, System Tree
Problems, System Tree to Problem Associations
A checkbox indicates whether to show all problems or just the ones associated with system tree items.
Problems, System Tree
Problems, System Tree to Problem Associations, System Tree
System Tree Items is the main table type for the report. All system tree records are shown. System tree records that are associated with problems show the associated problem data.
System Tree
System Tree to Problem Associations, System Tree
Problems, System Tree
* 
Differences exist between Case A and Case B. For Case A, the System Tree to Problem Associations table appears on the report and so relates to problems through this table. Case B relates to problems from the FRACAS Incidents table.
Case A: Problems, System Tree to Problem Associations, System Tree, Incidents
FRACAS Incidents is the main table type for the report. All incidents are shown, along with the system tree data to which they are tied. System tree records that are associated with problems show the associated problem data.
Problems, System Tree, FRACAS Incidents
* 
Any filters applied to problems are applied to the FRACAS Incidents table through its 1:N relationship with problems.
Problems, System Tree to Problem Associations, Incidents
System Tree to Problem Associations, System Tree, Incidents
System Tree to Problem Associations, Incidents
For Case A, tables that relate through the System Tree to Problem Associations table create combinations that are not permitted:
• If the report contains fields from the following tables, the combination is not permitted: Problems subtable, System Tree Items subtable, FRACAS Incidents, FRACAS Incidents subtable, FRACAS Maintenance Logs.
• If the report contains fields from the following tables, the combination is not permitted: System Tree Items subtable, Problems subtable, FRACAS Incidents, FRACAS Incidents subtable, FRACAS Maintenance Logs.
• If the report contains fields from the following tables, the combination is not permitted: FRACAS Incidents subtable, System Tree Items subtable, Problems subtable.
Case B: Problems, System Tree, Incidents
FRACAS Incidents is the main table type for the report. This report works like an Incidents report in earlier Windchill Risk and Reliability versions. It does not include any relationship between system tree items and problems.
Problems, System Tree, FRACAS Incidents
Problem Subtable table, Problems, System Tree and/or System Tree to Problem Associations
A Problems subtable is the main table type for the report. All Problems subtable records are shown. System tree items associated with problems through the System Tree to Problems Association table show the associated system tree data.
Any filter applicable to the main Problems subtable
Problem Subtable table, System Tree and/or System Tree to Problem Associations
Multiple Problems subtables, Problems, System Tree, and/or System Tree to Problem Associations
Problem table is the main table for the report. All problems and Problems subtable records are shown. System tree items that are associated with problems show the associated system tree data for each problem or Problems subtable record.
* 
Subtables print as N:N tables do in earlier Windchill Risk and Reliability versions, except that for each subtable record, associated system tree data is shown if there is an association.
Any filter applicable to Problems table
Multiple Problem Subtable tables, System Tree and/or System Tree to Problem Associations
System Tree Items subtable, System Tree, Problems, and/or System Tree to Problem Associations
System Tree Items subtable is the main table for the report. All System Tree Items subtable records are shown. Problems that are associated with System Tree Items subtable records through the System Tree to Problems Association table show the associated problem data.
Any filter applicable to the main System Tree Items subtable
System Tree Items subtable, Problems, and/or System Tree to Problem Associations
Multiple System Tree Items subtables, System Tree, Problems, and/or System Tree to Problem Associations
System Tree Items table is the main table for the report. All System Tree items and System Tree Items subtable records are shown. Problems that are associated with system tree items show the associated problem data for each system tree item or System Tree Items subtable record.
* 
Subtables print as N:N tables do in earlier Windchill Risk and Reliability versions, except for each subtable record, associated problem data is shown if there is an association.
Any filter applicable to the System Tree Items table
Multiple System Tree Items subtables, Problems, and/or System Tree to Problem Associations
Incidents subtable, System Tree to Problem Associations, plus optionally: Incidents, System Tree, or Problems
FRACAS Incidents subtable is the main table for the report. All Incident subtable records are shown. Problems that are associated with incidents or Incidents subtable records through the System Tree to Problems Association table show the associated problem data.
Any filter applicable to the main FRACAS Incidents subtable
Multiple Incidents subtables, System Tree to Problem Associations, plus optionally: Incidents, System Tree, or Problems
FRACAS Incidents subtable is the main table for the report. All incidents and Incidents subtable records are shown. Problems that are associated with incidents or Incidents subtable records through the System Tree to Problem Association table show the associated problem data for each incident or Incidents subtable record.
* 
Subtables print as N:N tables do in earlier Windchill Risk and Reliability versions, except for each subtable record, associated problem data is shown if there is an association.
Any filter applicable to the FRACAS Incidents table
* 
In addition to all the cases in the previous table, reports can contain fields from number of other tables, including: FRACAS Maintenance Logs, System Tree Items subtable, Problems subtables (including the special Problem Team Members subtable), and FRACAS Incident subtables.