Table 5088 "Profile Questionnaire Line"

Base Application · Microsoft.CRM.Profiling · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5110 “Profile Questionnaire Setup” (1 Learn page).

Properties

Property	Value
Caption	Profile Questionnaire Line
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Profile Questionnaire Code	Code[20]	—	TableRelation Table 5087 “Profile Questionnaire Header” (Profile Questionnaire Header)
2	Line No. Δ BC28	Integer	Specifies the number of the profile questionnaire line. This field is used internally by the program.
3	Type Δ BC28	Enum “Profile Questionnaire Line Type”	Specifies whether the entry is a question or an answer.	enum Enum 5090 “Profile Questionnaire Line Type”
4	Description Δ BC28	Text[250]	Specifies the profile question or answer.	NotBlank
5	Multiple Answers Δ BC28	Boolean	Specifies that the question has more than one possible answer.
6	Auto Contact Classification Δ BC28	Boolean	Specifies that the question is automatically answered when you run the Update Contact Classification batch job.
7	Customer Class. Field Δ BC28	Enum “Profile Quest. Cust. Class. Field”	Specifies the customer information that the automatic classification is based on. There are seven options: Blank, Sales (LCY), Profit (LCY), Sales Frequency (Invoices/Year), Avg. Invoice Amount (LCY), Discount (%), and Avg. Overdue (Day).	enum Enum 5085 “Profile Quest. Cust. Class. Field”
8	Vendor Class. Field Δ BC28	Enum “Profile Quest. Vend. Class. Field”	Specifies the vendor information that the automatic classification is based on. There are six options:	enum Enum 5086 “Profile Quest. Vend. Class. Field”
9	Contact Class. Field Δ BC28	Enum “Profile Quest. Cont. Class. Field”	Specifies the contact information on which the automatic classification is based. There are seven options:	enum Enum 5084 “Profile Quest. Cont. Class. Field”
10	Starting Date Formula Δ BC28	DateFormula	Specifies the date to start the automatic classification of your contacts.
11	Ending Date Formula Δ BC28	DateFormula	Specifies the date to stop the automatic classification of your contacts.
12	Classification Method Δ BC28	Option	Specifies the method you can use to classify contacts. There are four options: Blank, Defined Value, Percentage of Value and Percentage of Contacts.	OptionCaption: ,Defined Value,Percentage of Value,Percentage of Contacts
13	Sorting Method Δ BC28	Option	Specifies the sorting method for the automatic classification on which the question is based. This field is only valid when you select Percentage of Value or Percentage of Contacts in the Classification Method field. It indicates the direction of the percentage. There are two options:	OptionCaption: ,Descending,Ascending
14	From Value Δ BC27 Δ BC28	Decimal	Specifies the value from which the automatic classification of your contacts starts.
15	To Value Δ BC27 Δ BC28	Decimal	Specifies the value that the automatic classification of your contacts stops at.
16	No. of Contacts Δ BC28	Integer	Specifies the number of contacts that have given this answer.	FlowField: count(“Contact Profile Answer” where(“Profile Questionnaire Code” = field(“Profile Questionnaire Code”), “Line No.” = field(“Line No.”))); not editable
17	Priority Δ BC28	Enum “Profile Answer Priority”	Specifies the priority you give to the answer and where it should be displayed on the lines of the Contact Card. There are five options:	enum Enum 5089 “Profile Answer Priority”
18	No. of Decimals Δ BC28	Integer	Specifies the number of decimal places to use when entering values in the From Value and To Value fields.
19	Min. % Questions Answered Δ BC27 Δ BC28	Decimal	Specifies the number of questions in percentage that must be answered for this rating to be calculated.
9501	Wizard Step	Option	—	OptionCaption: ,1,2,3,4,5,6; not editable
9502	Interval Option	Option	—	OptionCaption: Minimum,Maximum,Interval
9503	Answer Option	Option	—	OptionCaption: HighLow,ABC,Custom
9504	Answer Description	Text[250]	—
9505	Wizard From Value Δ BC27	Decimal	—
9506	Wizard To Value Δ BC27	Decimal	—
9707	Wizard From Line No.	Integer	—

Keys

Key1: Profile Questionnaire Code, Line No. (clustered)
Key2: Type, Description

Procedures

MoveUp()
MoveDown()
Question(): Text[250]
FindQuestionLine(): Integer
CreateRatingFromProfQuestnLine(var ProfileQuestnLine: Record "Profile Questionnaire Line")
CheckStatus()
PerformNextWizardStatus()
PerformPrevWizardStatus()
FinishWizard()
SetIntervalOption()
ValidateIntervalOption()
ValidateAnswerOption()
NoOfProfileAnswers(): Decimal
ShowAnswers()
GetProfileLineAnswerDesc(): Text[250]
GetAnswers(var ProfileQuestionnaireLine: Record "Profile Questionnaire Line")

Plus 3 local procedures.

Triggers

OnDelete

Relations

lookup page Page 5149 “Profile Questn. Line List”
Profile Questionnaire Code: TableRelation Table 5087 “Profile Questionnaire Header”
No. of Contacts: CalcFormula Table 5089 “Contact Profile Answer”

Referenced by

6 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Table 5111 “Rating”: Profile Question Description, Profile Questionnaire Line No., Rating Profile Quest. Line No.
Table 5089 “Contact Profile Answer”: Answer, Line No.
Table 5096 “Segment Wizard Filter”: Profile Questn. Line Filter

Pages and codeunits on this table

Page 5110 “Profile Questionnaire Setup” (source table)
Page 5112 “Profile Question Details” (source table)
Page 5114 “Contact Profile Answers” (source table)
Page 5149 “Profile Questn. Line List” (source table)
Page 5169 “Profile Questn. Line Subform” (source table)
Page 5172 “Answer Points” (source table)
Page 5189 “Create Rating” (source table)
Page 5190 “Rating Answers” (source table)
Page 5191 “Create Rating Subform” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 5059 “ProfileManagement” (1 call: FinishWizard → ShowAnswerPoints)
Page 5189 “Create Rating” (1 call: StartWizard → (object))
Page 5190 “Rating Answers” (1 call: ShowAnswers → (object))

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Profile Questionnaire Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.