Difference between revisions of "Questionable Address List"

From EDgearWiki
Jump to navigationJump to search
 
(171 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
UNDER CONSTRUCTION!!!
+
__NOTOC__
 +
'''This program will provide the user a way to map and repair the questionable addresses that are listed in the student's demographics in [[Student Master]].  Students, who are on the list, have an address that is not marked with latitude and longitude and therefore are defined as questionable. 
  
−
'''This program will allow you to map and repair your questionable addresses that are listed in the student's demographics in Student Master.'''
+
In [[User Management]], a security of  '''Maintenance /Questionable Address List / RW''' is needed.
  
 +
==Menu Location==
  
−
On the left, click on '''System.'''
+
'''System > Reports > Questionable Address List'''
  
−
Under '''List''', select '''Questionable Address List.'''
+
==Setup Options==
  
−
If you need instructions for setup values to be used, follow the link for '''<span style="background:yellow">[[Standard Setup Options]]</span>'''.
+
[[File:questionablesetup.png]]
  
−
The next items are not found on the standard setup options document.
+
'''Year''' - This should be the prior year.
  
−
:'''Show Student Physical Address''' - include the student's physical address on the rows per student if it is questionable or blank
+
'''District''' - Default value is based on the user’s security settings. The user will be limited to their district only.
  
−
:'''Show Student Mailing Address''' - include the student's mailing address on the rows per student if it is questionable or blank
+
'''School''' - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.
  
−
:'''Show Guardian Physical Address''' - include the Guardian's physical address on the rows per student if it is questionable or blank
+
'''Make your selections below to print on your list.'''
  
−
:'''Show Guardian Mailing Address''' - include the Guardian's mailing address on the rows per student if it is questionable or blank
+
'''Show Manually Validated Addresses Only'''
  
−
:'''Show Father Address''' - include the father's address on the rows per student if it is questionable or blank
+
'''Show All Validated Addresses Only'''
  
−
:'''Show Mother Address''' - include the mother's address on the rows per student if it is questionable or blank
+
'''Show Student Physical Addresses'''
  
−
:'''Don't Show PO Boxes on Mailing Address''' - excludes PO Boxes if used as mailing addresses on the rows per student
+
'''Show Student Mailing Addresses'''
  
−
:'''Show Only Blank Addresses''' - includes only blank addresses on the rows per student
+
'''Show Guardian Physical Addresses'''
  
−
:'''Don't Show Blank Addresses''' - excludes blank addresses on the rows per student
+
'''Show Guardian Mailing Addresses'''
  
−
:'''Active Students Only''' - list only active students that do not have a drop code for this school year
+
'''Show Father Addresses'''
  
−
Click '''OK'''
+
'''Show Mother Addresses'''
  
 +
'''Don't Show PO Boxes on Mailing Addresses'''
  
−
'''Definitions of Column Headers'''
+
'''Show Only Blank Addresses'''
  
−
:To find definitions of commonly used columns follow this link: '''<span style="background:yellow">[[Common Column Headers]]</span>'''.
+
'''Don't Show Blank Addresses'''
  
−
One column that does not appear on the common list is:
+
'''Active Students Only'''
  
−
:'''Type''' - types of addresses include mailing and physical for different family members
+
'''Audit Different Addresses with Same Lat/Lon''' - This will display the addresses in the list that have the same latitude/longitude but different addresses. Sort using the latitude/longitude columns.
  
 +
'''Audit Same Addresses with Different Lat/Lon''' - This will display the addresses in the list that have different latitude/longitude but same addresses. Sort using the address column.
  
−
Click on the address that you want to correct on the map.  For the blanks, you can double click and add an address.
+
'''OK''' - Click to continue
  
−
After the address appears on the right top side of your screen, you can now use the marker to indicate where on the map the address should be located.
+
'''Cancel''' - Cancel choices
  
−
'''Alias''' -
+
To find definitions for standard setup values, follow this link: [[Standard Setup Options]].
  
−
:[[File:search.PNG]]
+
==Main==
  
−
'''Look Up''' - will allow you to look up any address and have it show on the map
+
[[File:qal.png]]
  
−
'''Print'''  
+
'''Search''' - Type in the data for which you are searching. It will pause for half a second, then process and search for the data from all of the columns bringing them to the top.
−
#Click the '''Print''' button at the bottom of the screen.
+
 
−
#A popup will appear with a set of document print options--PDF, XLS, CSV, HTML.  
+
===Column Headers===
−
#The default print option will be '''PDF'''.
+
 
−
#Click the print button on this popup and a print preview window will appear.  
+
'''Invalid Addresses on the left'''
−
#'''To get the print icon''' on this window, hover the mouse in the bottom right area of the preview. A grey rectangle will appear with several icons.  
+
 
−
#Click the print icon at the right end of this rectangle. Another print preview will appear.
+
'''School''' - School site number
−
#Click the print button at the top left to print the report. Close the print preview.
+
 
 +
'''Type''' - Type of address
 +
 
 +
'''Last Name''' - Student's last name
 +
 
 +
'''First Name''' - Student's first name
 +
 
 +
'''SIDNO''' - Student's identification number
 +
 
 +
'''Address''' - Address line 1
 +
 
 +
'''Address 2''' - Address line 2
 +
 
 +
'''Validated Addresses on the right'''
 +
 
 +
'''Address''' - Student's Address
 +
 
 +
'''City''' - Student's city
 +
 
 +
'''State''' - Student's state
 +
 
 +
'''Zip''' - Student's zip
 +
 
 +
==Top==
 +
 
 +
'''Action'''
 +
 
 +
'''[[Initialize Addresses]]'''
 +
 
 +
==Bottom==
 +
 
 +
[[File:questionablebottom.png]]
 +
 
 +
'''Setup''' - Click to go back to the Setup box.
 +
 
 +
[[Standard Print Options | '''Print''']] - This will allow the user to print the report.
 +
 +
'''Help''' - Click to view written instructions and/or videos.
 +
 
 +
'''[[Alias]]''' - Geocode Alias information - Click to enter an '''Alias'''.
 +
 
 +
'''[[Look Up]]''' - Address look up - This will allow the user to look up an address and have it show on the map prior to changing a student's address.
 +
 
 +
 
 +
===How-to===
 +
<p>The report will have three sections: '''1''') the student/parent/guardian names and address related information in street address order, '''2''') the suggested validated address, and '''3''') a map.</p>
 +
<p>All addresses on this report must be reviewed and a selection made in order to associate the address with a '''latitude''' and '''longitude''' which are required to remove an address from this report.</p>
 +
<p>'''To review''' an address, double click the address field on the left and there will be a possible match displayed on the map and in the area above the map.</p>
 +
:*Possible causes: Misspelled street names, abbreviations (E for East), periods in abbreviations, and possibly other differences.
 +
If there is an '''exact match''' or only minor differences on the address between the report and the suggestion(s), click the validated address on the top right. All records with a matching address will be updated and will be removed from the report.
 +
:*If the map has the name '''spelled correctly''', click the address in the Validated Address section at the top right.
 +
:*If the map has the name '''misspelled''', you can use the '''Alias''' button on the bottom of the screen to enter the correctly spelled street name. After entering the alias the newly validated street name will be used as the name on the map and the name in the validated addresses section. '''Make your selection''' by clicking the top right validated address section.
 +
If there is '''NO exact match''', close the popup that appears on the map (this may take a couple of clicks on the ‘x’—trying clicking to the right of the ‘x’)
 +
:*Use the marker pin (one of the three small icons in the top center of the map) to pinpoint the location on the map—'''first''' move the map around to find the address, '''second''' click the small pin icon at the top center of the map, '''finally''', left click on the map at the desired location.
 +
:*Click the '''confirm button''' at the bottom left of the map.
 +
:*The latitude and longitude will be assigned to this address and the questionable addresses list will be updated removing any corrected addresses from the list.
 +
:*NOTE that if you place a marker in the wrong spot on the map, re-select the address on the left and the map will refresh; make sure that the ‘hand icon’ is the active top center icon before attempting to relocate the position on the map; re-select the pin icon and then left click to identify the position.
 +
 
 +
 
 +
'''To Edit a Pin Marker'''
 +
 
 +
#Choose the option to "Show All Validated addresses Only".
 +
#When the list appears, type the address in the Search bar. 
 +
#Click on the address.
 +
#Click the Marker icon.  
 +
#Click on the location on the map where the address is supposed to be located.
 +
#Then click Confirm.  That will move the address to the proper location.
 +
 
 +
 
 +
----
 +
[[System|'''System''' Main Page]]
 +
----
 +
[[WebPams|'''JCampus''' Main Page]]

Latest revision as of 09:00, 8 May 2024

This program will provide the user a way to map and repair the questionable addresses that are listed in the student's demographics in Student Master. Students, who are on the list, have an address that is not marked with latitude and longitude and therefore are defined as questionable.

In User Management, a security of Maintenance /Questionable Address List / RW is needed.

Menu Location

System > Reports > Questionable Address List

Setup Options

Questionablesetup.png

Year - This should be the prior year.

District - Default value is based on the user’s security settings. The user will be limited to their district only.

School - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.

Make your selections below to print on your list.

Show Manually Validated Addresses Only

Show All Validated Addresses Only

Show Student Physical Addresses

Show Student Mailing Addresses

Show Guardian Physical Addresses

Show Guardian Mailing Addresses

Show Father Addresses

Show Mother Addresses

Don't Show PO Boxes on Mailing Addresses

Show Only Blank Addresses

Don't Show Blank Addresses

Active Students Only

Audit Different Addresses with Same Lat/Lon - This will display the addresses in the list that have the same latitude/longitude but different addresses. Sort using the latitude/longitude columns.

Audit Same Addresses with Different Lat/Lon - This will display the addresses in the list that have different latitude/longitude but same addresses. Sort using the address column.

OK - Click to continue

Cancel - Cancel choices

To find definitions for standard setup values, follow this link: Standard Setup Options.

Main

Qal.png

Search - Type in the data for which you are searching. It will pause for half a second, then process and search for the data from all of the columns bringing them to the top.

Column Headers

Invalid Addresses on the left

School - School site number

Type - Type of address

Last Name - Student's last name

First Name - Student's first name

SIDNO - Student's identification number

Address - Address line 1

Address 2 - Address line 2

Validated Addresses on the right

Address - Student's Address

City - Student's city

State - Student's state

Zip - Student's zip

Top

Action

Initialize Addresses

Bottom

Questionablebottom.png

Setup - Click to go back to the Setup box.

Print - This will allow the user to print the report.

Help - Click to view written instructions and/or videos.

Alias - Geocode Alias information - Click to enter an Alias.

Look Up - Address look up - This will allow the user to look up an address and have it show on the map prior to changing a student's address.


How-to

The report will have three sections: 1) the student/parent/guardian names and address related information in street address order, 2) the suggested validated address, and 3) a map.

All addresses on this report must be reviewed and a selection made in order to associate the address with a latitude and longitude which are required to remove an address from this report.

To review an address, double click the address field on the left and there will be a possible match displayed on the map and in the area above the map.

  • Possible causes: Misspelled street names, abbreviations (E for East), periods in abbreviations, and possibly other differences.

If there is an exact match or only minor differences on the address between the report and the suggestion(s), click the validated address on the top right. All records with a matching address will be updated and will be removed from the report.

  • If the map has the name spelled correctly, click the address in the Validated Address section at the top right.
  • If the map has the name misspelled, you can use the Alias button on the bottom of the screen to enter the correctly spelled street name. After entering the alias the newly validated street name will be used as the name on the map and the name in the validated addresses section. Make your selection by clicking the top right validated address section.

If there is NO exact match, close the popup that appears on the map (this may take a couple of clicks on the ‘x’—trying clicking to the right of the ‘x’)

  • Use the marker pin (one of the three small icons in the top center of the map) to pinpoint the location on the map—first move the map around to find the address, second click the small pin icon at the top center of the map, finally, left click on the map at the desired location.
  • Click the confirm button at the bottom left of the map.
  • The latitude and longitude will be assigned to this address and the questionable addresses list will be updated removing any corrected addresses from the list.
  • NOTE that if you place a marker in the wrong spot on the map, re-select the address on the left and the map will refresh; make sure that the ‘hand icon’ is the active top center icon before attempting to relocate the position on the map; re-select the pin icon and then left click to identify the position.


To Edit a Pin Marker

  1. Choose the option to "Show All Validated addresses Only".
  2. When the list appears, type the address in the Search bar.
  3. Click on the address.
  4. Click the Marker icon.
  5. Click on the location on the map where the address is supposed to be located.
  6. Then click Confirm. That will move the address to the proper location.


System Main Page

JCampus Main Page

Retrieved from EDgear Wiki