Search and View Rollbooks

Search and View Rollbooks (SCRBVIE)

There are three types of searches that a user can perform. The first being a return of all ‘Today’s Rollbooks’; the second being a return of 'All My Rollbooks’ and the third being a general search allowing for searching on Rollbooks that match specific criteria. Each column of the Rollbook Results list can be sorted, by clicking on the column title.

Today’s Rollbooks are those Rollbooks that the user has access to and which have an Attendance Activity Date equal to today’s date.

My Rollbooks are those Rollbooks that the user has created, owns or is an authorised user of. If a user has a System Security Advanced Function of RB-AD-UPD, then all Rollbooks will be displayed. This list returns all Rollbooks from the most current Rollbook to the least current. The Rollbook Commencement is used as the sort order, with the latest commencement date being at the top of the list to the earliest being last. If no commencement date exists for a rollbook, i.e. no activities have yet been defined, these rollbooks will be at the top of the list and in Rollbook ID order.

Search Rollbooks is a general search function allows the user to search for Rollbooks with specific parameters.

Search Rollbooks

The Search Rollbooks screen including the Rollbook Student Criteria is shown below :

scrbvie1

The Rollbook Search Parameters available are:

Rollbook ID (no other fields are required if the ID is entered)
Status
Type (Single or Multi Unit)
Owner (Surname, Title, Given Names)
Creator (Surname, Title, Given Names)
Academic Period
Location
Unit Code (restricted by location if location is selected prior to Unit Code)

The Rollbook Student Search Parameters are:

Person ID (no other fields are required if the ID is entered)
Surname
Given Names
Preferred Given Names
Date of Birth
Email Address
Gender Radio Buttons

Student Search parameters only appear if the Rollbook Type is SNGLSTDNT.
If you select a Rollbook of Type of SNGLSTDNT and then press the Search button before the page has re-loaded, then a message will appear and you will be prevented from continuing until the page has reloaded.
% can be used as a wild card in any field, except for Date of Birth.
If a Unit selected in the search parameters is present in a multi-unit Rollbook, then that Rollbook will be returned in the search results:

Label	Field Source	Field Type	Format	Comments
Rollbook ID:	ROLLBOOK.ROLLBOOK_ID	Input Field	Number(6) 999999	% will return all Rollbooks. However, % does not have to be defined.
Status:	S_ROLLBOOK_STATUS.DESCRIPTION	Poplist	Varchar2(60)	.
Owner:	PDV.CONTEXT_BLOCK_NAME	Poplist	Varchar2(85)	The Owner is where the RBAU.USER_TYPE = ‘OWNER’ and RBAU.ACCESS_REMOVED_DT IS NULL (select first person id multiple, order by Person ID desc) If the above doesn’t exist, then the Owner will be the Creator of the Rollbook (ROLLBOOK.RB_CREATOR_PERSON_ID)
Creator:	PDV.CONTEXT_BLOCK_NAME	Poplist	Varchar2(85)	Join ROLLBOOK.RB_CREATOR_PERSON_ID to PE.PERSON_ID to get the PDV.CONTEXT_BLOCK_NAME
Academic Period:	CI.ALTERNATE_CODE	Poplist	Varchar2(10)	Current Year. The cal_instance must be ACTIVE. Return the cal_type and ci_sequence_number to the template as well
Location:	LOC.DESCRIPTION	Poplist	Varchar2(60)	Return the Location Code to the template as well
Unit:	UV.UNIT_CD - UV.SHORT_TITLE	Poplist	Varchar2(63)	Return the Unit Version Number to the template as well

Label	Field Source	Field Type	Format	Comments
Person ID:	PERSON.PERSON_ID	Input Field	NUMBER(10) 9999999999	If the person returned is a potential student then ‘DUPLICATE’ is displayed if the person has been matched to a person (ROLLBOOK_STUDENT.PERSON_ID is not null where ROLLBOOK_STUDENT. RBPS_SEQUENCE_NUMBER is not null) or ‘POTENTIAL’ if it does not meet the above scenario
Surname:	PERSON.SURNAME or ROLLBOOK_POTENTIAL_SDTNT.SURNAME	Input Field	VARCHAR2(30)	.
Given Names:	PERSON.GIVEN_NAMES or ROLLBOOK_POTENTIAL_SDTNT.GIVEN_NAMES	Input Field	VARCHAR2(40)	.
Preferred Given Names:	PERSON.PREFERRED_GIVEN_NAME	Input Field	VARCHAR2(30)	.
Date of Birth:	PERSON.BIRTH_DT or ROLLBOOK_POTENTIAL_SDTNT.BIRTH_DT	Input Field	DATE dd/mm/yyyy	.
Email Address:	PERSON.EMAIL_ADDR or ROLLBOOK_POTENTIAL_SDTNT. CONTACT_DETAILS	Input Field	VARCHAR2(200)
Gender:	PERSON.SEX or ROLLBOOK_POTENTIAL_SDTNT.SEX	Radio button	VARCHAR2(1)	If PERSON.SEX = ‘U’ display NULL

Search Results Screen

When a search is made for your Rollbooks, the results are displayed in a tabular form as shown below.

If the Rollbook is Multi Unit, then all of the units it contains are displayed, sorted in descending order.

The Search Results screen is shown below :

scrbvie2

If only one Rollbook is returned, then the Maintain Rollbook screen is displayed directly.
If no rollbooks satisfy the search parameters then 'No rollbooks found' is displayed in the results table.

The Search Results screen is shown below :

scrbvie3

If no students satisfy the search parameters then 'No students found' is displayed in the results table.
If you click on the Person ID field link then that single student rollbook is opened - see .

scrbvie3b

If you click on the Rollbook ID field link then that rollbook is opened - see Maintain Rollbook.

Validations include:

At least one of the fields must be entered before searching
Rollbook Unit must exist if Academic Period and/or location are selected after unit has been selected.
Rollbook location must exist if Academic Period is selected after location has been selected.
Only Units location, owner, creator and Academic Period will be available in the list where they exist in the Rollbook table.

scrbvie4

scrbvie5

Label	Field Source	Field Type	Format	Comments
Student	DECODE(PERSON.PERSON_ID, NULL, ROLLBOOK_POTENTIAL_SDTNT.SURNAME\|\|', '\|\| ROLLBOOK_POTENTIAL_SDTNT.GIVEN_NAMES, PERSON.PERSON_ID \|\| ' - '\|\| PERSON.SURNAME \|\|', '\|\|PERSON.TITLE\|\|' '\|\|PERSON.GIVEN_NAMES)	Display Field	VARCHAR2(96)	Only display if user has come from Rollbook Student Search Results screen
Rollbook ID	ROLLBOOK.ROLLBOOK_ID	Link	Number(6) 999990	The link will navigate user to Maintain Rollbook page Default Order by Rollbook ID DESC
Commencement Date	MIN(ROLLBOOK_ACTIVITY.ACTIVITY_DT)	Display Field	Date	Only retrieve the first Activity Date for the Rollbook, if one exists.
Description	RB.DESCRIPTION	Display Field	Varchar2 (60)	.
Rollbook Type	ROLLBOOK.S_ROLLBOOK_TYPE	Display Field	Varchar2 (10)	.
Unit Offering	ROLLBOOK_UNIT_INSTANCE.UNIT_CD\|\|’.’\|\| ROLLBOOK_UNIT_INSTANCE.VERSION_NUMBER\|\|’/’\|\| NVL(CAL_INSTANCE.ALTERNATE_CODE, CAL_INSTANCE.CAL_TYPE)	Display Field	VARCHAR2(35)	This should replace the Unit and Teaching Period columns. Display the Unit Offering (Unit Code/Teaching Period), but also return the values to the template. Use the following function to return the values: Unit Code/Teaching Period SSFK_ROLLBOOK_UTITILITY.SSFP_GET_UNIT_CODES_CI Unit Codes SSFK_ROLLBOOK_UTITILITY.SSFP_GET_UNIT_CODES Teaching Period SSFK_ROLLBOOK_UTITILITY.SSFP_GET_TEACH_PERIODS There may be multiple units for a rollbook ID. When there is display them as: UNIT1 UNIT2 That is, in the same table cell, each one with a break.
Teaching Period	NVL(ADM.ALTERNATE_CODE, CI.CAL_TYPE)	Display Field	Varchar2 (2000)	There may be multiple teaching periods for a rollbook ID. When there is display them as: TEACHINGPERIOD1 TEACHINGPERIOD2 That is, in the same table cell, each one with a break (this may be due to multiple unit codes and/or multiple teaching periods for the unit offering pattern)
Status	ROLLBOOK.S_ROLLBOOK_STATUS	Display Field	Varchar2 (10)	.
Delivery Location	LOC.DESCRIPTION	Display Field	Varchar2 (60)	.
Rollbook Owner	PDV.CONTEXT_BLOCK_NAME	Display Field	Varchar2 (85)	The Owner is where the RBAU.USER_TYPE = ‘OWNER’ and RBAU.ACCESS_REMOVED_DT IS NULL (select first person id multiple, order by Person ID desc) If the above doesn’t exist, then the Owner will be the Creator of the Rollbook (ROLLBOOK.RB_CREATOR_PERSON_ID)

Last Modified on: 23 January, 2008 3:19 PM

History Information

Release Information	Project	Changes to Document
10.0.0.2.0.0	1415 - CVET - Electronic Rollbook	Some general reordering of page. Added references to Single Student rollbooks
10.0.0.2.0.0	1412 - CVET - Electronic Rollbook	Some general reordering of page. Added references to Multiple unit rollbooks
10.0.0.0.0.0	1364 - PDS - CVET - Electronic Rollbook and Grade Management	New form