Table: dbo.Report_Profile_Element
This table will contain an entry for each report contained within a client specific override of a global report profile. Each entry will have a key to link to a report definition, and a report option xml file. Together, the report definition xml and the report option xml describe how to print a report.
Columns
NameTypeConstraintsDescription
report_profile_element_KEYint (4)NOT NULLPrimary key
report_profile_KEYint (4)NOT NULLThe key of the parent report profile to which this report profile element is linked.
report_definition_KEYint (4)NOT NULLThe report profile definition KEY. Links us to a report/report definition record.
report_option_xmlnvarchar (-1)NOT NULLcontains the xml string of the descriptions for this report profile report.
Primary key
NameColumnsDescription
PK_Report_Profile_Elementreport_profile_element_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Profile_Element__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)
FK_Report_Profile_Element__Report_Profile__report_profile_KEYreport_profile_KEYReport_Profile (report_profile_KEY)

Schema diagram