Appointments By State Inquiry

Available in spreadsheet format only.

Use the Appointments By State Inquiry page to generate a printable transcript of key appointment information recorded in Producer Manager for one selected firm or individual producer.

View screen capture of report criteria

View screen capture of report results

To open the Appointments By State Inquiry page, from the Inquiries menu select Appointment, and then select Appointments By State Inquiry.

The Appointments By State Inquiry page contains the following sections:

Search Producer

You can set report criteria for the Appointments By State Inquiry simply by searching for a selected producer whose record is stored and contains appointment information in Producer Manager.

Use the Search Producer page to search for the individual or firm producer whose appointment information you want to report.

The Search Producer page consists of the following sections:

Producer Type

Search Fields

Use the Search Fields to enter search criteria for one or multiple producer records, either individual or firm. At least one search criterion is required.

Fields and controls include the following:

Last:Individual producers only. Enter a search string on individual producer last name. You may use as few as two characters in your search string. Wildcard characters are not allowed. May not contain numeric characters or double quotation marks (").
Firm Name:Firm producers only. Enter a search string on firm name. You may use as few as two characters in your search string. May contain numeric characters. Wildcard characters are not allowed. May not contain double quotation marks (").
First:Individual producers only. Must be used in combination withLastname criterion. You may use as few as one character in your search string. Wildcard characters are not allowed. May not contain numeric characters or double quotation marks (").
Middle:Individual producers only. Must be used in combination withLastname criterion. You may use as few as one character in your search string. Wildcard characters are not allowed. May not contain numeric characters or double quotation marks (").
SSN:Individual producers only. Enter a producer's entire Social Security Number. Partial searches not allowed. Maximum 9 characters without separating hyphens or 11 characters with two separating hyphens.
EIN: Firm producers only. Enter a producer's entire Federal Employer Identification Number. Partial searches not allowed. Maximum 9 characters without a separating hyphen or 10 characters with a separating hyphen.
NPN: Enter a producer's entire National Producer Number. Partial searches not allowed. Maximum 10 characters.
Active Business Unit: Select from the dropdown menu an the short name of an active business unit to which a producer is assigned. May not be the only search criterion.

License Number: Enter the entire number of a producer's state license, either active or inactive. Partial searches not allowed. Maximum 15 characters.
License State: Select from the dropdown menu a state in which a producer holds an active or inactive license.
External System ID: Enter a producer's entire external system ID code, including leading zeroes, either active or inactive. Partial searches not allowed. Maximum 22 characters.
Primary External ID Only: Click to checkmark the checkbox to constrain a search using anExternal System IDcriterion to only those external system IDs marked as a "primary" ID on a producer's record. The search will ignore a match on anExternal System IDthat is not marked as "primary." (For more information, see Maintain External System Identifiers.)
Records Per Page: If multiple records met your search criteria, the default number of records displayed per page of results is 10. From the dropdown menu, select a value in increments of 10 up to 50 and then execute or re-execute the search to display a number of records up to the selected value in the Search Results sub-section.
Search: Click to execute the search based on the entered search criteria.

If only one producer record met your search criteria, the Appointments By State Inquiry page will refresh with the selected producer's appointment information ready to be generated into the report.

If multiple records met your search criteria, they will display in the Search Results section.

Cancel: Click to abort the operation and open the Producer Manager Home page.

Search Results

If multiple producer records met your search criteria, they will display in the Search Results section of the Search Producer page.

Fields and controls include the following:

Name: For each listed producer record, displays a producer name as a blue hyperlink.

Click a selected producer's Name hyperlink to refresh the Appointments By State Inquiry page with the selected producer's appointment information ready to be generated into the report.

Click the column heading to toggle alphabet or reverse alphabetic sorting of the Search Results on the Name field.

SSN:Individual producer searches only. For each listed producer record, displays a producer's Social Security Number. Click the column heading to toggle highest-to-lowest or lowest-to-highest sorting of the Search Resultson theSSNfield.
EIN: Firm producer searches only. For each listed producer record, displays a producer's federal Employer Identification Number. Click the column heading to toggle highest-to-lowest or lowest-to-highest sorting of the Search Resultson theEINfield.
License State/#: For each listed producer record, displays the state codes of the states in which a producer holds at least one active or inactive license and the corresponding license numbers. Click the node () to expand the record row to display all of the producer's license state and number information. Click the node () to collapse the information.
NPN: For each listed producer record, displays a producer's National Producer Number. Click the column heading to toggle highest-to-lowest or lowest-to-highest sorting of the Search Resultson theNPNfield.
Active BU: For each listed producer record, displays the name of the business unit(s) with which a producer is actively associated. Click the node () to expand the record row to display all of the producer's business unit information. Click the node () to collapse the information.
City: For each listed producer record, displays the producer's mailing address city. Click the column heading to toggle alphabetic or reverse alphabetic sorting of the Search Resultson theCityfield.
State: For each listed producer record, displays the producer's mailing address state. Click the column heading to toggle alphabetic or reverse alphabetic sorting of the Search Resultson theStatefield.
Displaying[v] - [w](of[x]matching records): Displays the range in numbers of producer records currently displaying in the Search Results sub-section out of the total number of producer records returned by a search.
Page[y]of[z]: Displays the number of the page currently displaying out of the total number of pages of producer records returned by a search.
Go To Page: Available only when more than 10 records are returned by a search, resulting in multiple pages of Search Results. Select from the dropdown menu the number of the page of producer records to which you wish to navigate.
Go: Click to navigate to the page number of Search Results selected in the Go To Page dropdown menu.

Report Results

Displays appointment information for the selected producer as recorded in your company's instance of Producer Manager.

The Title tab of the report displays a summary of the selected report criteria, including data summaries (such as total record and producer counts), report properties, and all of the selection and filter criteria used to generate the report.

The Title tab also includes the following data fields per producer included in the report:

Producer Name: Displays the producer's name information: last name, first name, and middle name for individuals or firm name for firms. (For more information, see Details.)
NPN: Displays the producer's National Producer Number.
PM Producer ID: Displays the producer's Producer Manager record ID. (For more information, see Details.)
Preferred External System ID: Displays the external system identifier marked as "Primary" on the producer's record. (For more information, see External System IDs.)
Active Business Units: Displays the short name(s) of the business units to which the producer is actively assigned (sorted alphabetically). (For more information, see Business Units.)
Status: Displays the status of the selected producer's record in Producer Manager. A producer's record status is Active if the producer holds at least one active appointment or firm association (if an individual) or individual association (if a firm); the producer's record status is Inactive if all appointments and associations are no longer active.
Effective Date: If the Status is Active, displays the date on which the producer's Status became effective. If the Status is Inactive, displays the date on which the producer's last active appointment or association became effective.
Termination Date: If the Status is Inactive, displays the date on which the producer's Status became effective.

On the Data tab, report results are sorted first by state and then by appointing company. They include the following data fields:

State: For each state in which the selected producer is appointed, displays the name of the regulatory jurisdiction.
NAIC ID: For each appointing company listed, displays the National Association of Insurance Commissioners identifier of the appointing company with which the selected producer is appointed.
Company Name: For each appointing company listed, displays the name of the appointing company with which the selected producer is appointed.
Status: Displays the overall status of the selected producer with the appointing company identified in the Company Name field. A producer's status is Inactive if all appointments with the appointing company are inactive; the producer's status is Active if the producer holds at least one active appointment with the appointing company.
Effective Date: Displays the date on which the value of the Status field last was updated. (For more information, see Details.)
Appointment Type: For each appointment listed, displays the state-specific description of the appointment type held by a selected producer.
Status: For each appointing company listed, displays the status of the selected producer's appointment of the type identified in the Appointment Type field with the appointing company identified in the Company Name field.
Active Date: For each appointment listed, displays the appointment's effective date. Displays for either active or inactive appointments.
Termination Date: Inactive appointments only. Displays the date on which the appointment became inactive.
Termination Reason: Inactive appointments only.Displays the state-specific reason for the appointment termination.
Shared Producer Name: Shared appointment states only. Displays the name of the producer with which the appointment is shared (i.e., the appointment state acknowledges that a producer is authorized under another producer's appointment, such as an affiliated individual producer's indirect appointment with a firm producer).
State Verified: For each producer listed that met the report criteria, displays Y if the State Verified checkbox in the producer's appointment information contains a checkmark; displays N if the State Verified checkbox in the producer's appointment information does not contain a checkmark.
System Record Only: More detail view only. For each appointment listed, displays a checkmarked checkbox if the appointment was manually recorded on the selected producer's record or has been added to the record through an automated data reconciliation; a checkbox without a checkmark indicates that the appointment was not manually recorded and was submitted through the Sircon Platform (Producer Manager or Producer Express) to a state.
Appointment Action: For each transaction request listed, displays the submitted transaction type, either Appointment or Termination.
Submit Date: For each transaction request listed, displays the date on which the transaction was submitted.
Submit Status: For each transaction request listed, displays the status of the transaction request (e.g., Approved (processed and approved by the state), Denied (processed and rejected by the state), Submitted to SIRCON (pending state processing).)
Response Date: Displays only for transaction requests that have undergone state processing. For each transaction request listed, displays the date on which the state to which the request was submitted responded to the request.
Actual Effective Date: Displays only for transaction requests that have undergone state processing. For each transaction request listed, displays the date on which a requested appointment or termination became or would become effective, based on Vertafore-configured state backdating or system future-dating rules.
Rejection Reason: Displays only for transaction requests that have undergone state processing and where the value of theSubmit Statusfield is Denied. For each transaction request listed, displays the state-specific reason.

Page Controls

Warning

Results of the Appointments By State Inquiry may contain unmasked, full Social Security Number information for individual producers. It is not possible to configure the system to mask or hide these values in the report results. However, using a security role setting, a user with administrator permissions may deny other users the permission to run this inquiry or view inquiry results requested by other users. For more information, see Maintain Security Role.

Notes

Note: The Appointments By State Inquiry reports appointment information only as recorded in your company's instance of Producer Manager. It does not verify appointment information directly with state records. However, if your company is using Producer Manager's automated data reconciliation utilities (such as Scheduled Syncs) to keep producer appointment data refreshed continually, the Appointments By State Inquiry report results should be synchronized with state records.