Argos Power Tips

Datablock Designer Power Tips

Registration and Enrolled Indicators- What is the definition of these indicators and how they are used in Banner. (Contributed by Kim Bell) * Students with a registered indicator (registered_ind) set to ‘Y’ means they are currently registered for classes.

• Students with a registered indicator (registered_ind) set to ‘N’ means they were once registered but are not currently registered
• Students with a registered indicator (registered_ind) set to null means they were never registered for that term.

Address_by_Rule_MV - When using the hierarchy rules for addresses. There is a new view available called beardata.address_by_rule_mv. This view will allow users to filter address by a the hierachy discribe by the rule associated. For student address the most common rule is STDNADDR. This rule searches for student address in the following order

1. MA - Current Mailing Address
2. PR- Primary/Permenant Mailing Address
3. RH- Residence Hall Address

The rules work like this, if the student has an active MA address type this is the address that will be used in the query, if they do not have an active current address type the rule searches for the second address type of PR. If the student does not have an active MA address type but does have an active PR address type this is the address the that will be used for this student in the query, if the student does not have an active address type for MA or PR, then the query looks for the RH address type. If a student does not have any of these address types they will not show on the query. To prevent this from happening please see below:  Outer Joining in the where clause.

Academic Study View- When using information found in the Academic_Study table use the beardata.Academic_Study table. This table has been modified to afford faster searching for reports. All of the data in this table is the same as Academic_Study, nothing has been changed that will affect the integrity of the data stored in this table. Other filters to accomplish faster search times.

•  Set Primary_Program_Ind = 'Y'
•   Set an Academic_Period

Joining Tables in Argos - When joining tables in argos, it is best to join by the Person_UID rather then the ID where available. The Person_UID is an indexed field and will make your queries run alittle quicker.

Outer Joining in the where clause - Situtation - If you have a list of students and what to show only a certain type of Address, and some student may not have that type of Address, but you still want to list them on the report. You can outer join in the where clause. Do do this in the GUI, make a calculated field and add in the the field that you want to filter in this instance Address_type and add a (+) to the end. This will left outer join this field to your query. It will look like the picture below.

 
This will allow all student to be shown on the list but will give you the addresses of student with the Address Type specified.

Adding Count to preview Multi Column List Box.To add a record count to the preview multi-column in your data block. First create the multi-column then change the property. Show Item Count. This will give you a total count of records at the bottom of the preview window.

Report Writer Power Tips