webcapp kimberly a saving-sherman sungard sct. 2 agenda u webcapp preview u self service for...

WebCAPP

Kimberly A Saving-Sherman

SunGard SCT

2

Agenda

WebCAPP Preview Self Service for Students

Self Service for Faculty & Advisor

WebCAPP Implementation

Web Generating a Compliance

Question and Answers

3

WebCAPP Phase I

Allows students and faculty/advisors to view, request and generate new degree evaluations based on the student’s curriculum.

Self Service for Students 5.3

Self Service for Faculty & Advisors 5.1

Student 5.3

4

New WebCAPP I Web Pages

Degree Evaluation

Display Options

General Requirements

Detail Requirements

View Previously Generated

Generate New Request

5

WebCAPP I Modified Web Pages

Faculty & Advisor Security Information

Student/Advisee ID Selection

6

WebCAPP Phase II

Allows students and faculty/advisors to view, request and generate What-If evaluations. A dynamic catalog, hold and purge functionality and course attribute class search are just some other highlights in this release.

Self Service for Students 5.4

Self Service for Faculty & Advisors 5.2

Student 5.4

7

New WebCAPP II Web Pages

What-If Analysis

8

WebCAPP II Modified Web Pages

Degree Evaluation Hold functionality

General Requirements Multiple Text Types

Detail Requirements Customizable Message

Multiple Text Types

9

WebCAPP II Modified Web Pages (cont)

View Previous Evaluations Purge

Generate New Request In-Progress Option (Self Service for Faculty only)

Student/Advisee ID Selection Searchable by Name (Self Service for Faculty only)

Look Up Classes to Add Search by Course Attributes

10

WebCAPP I Implementation

GTVSDAX – Crosswalk Validation

STVORIG – Originator Code Validation

SMADFLT – CAPP Compliance Default Parameter

SOATERM – Term Control

SMAPRLE – Program Definition Rules

STVPROC – Process Control Validation

(Self Service for Faculty only)

11

WebCAPP II Implementation

SMAWCRL – WebCAPP Rules

SOATERM – Term Control

STVHLDD – Hold Type Code Validation

Modified Form for Hold Functionality

SMARQCM – Compliance Request Management

12

GTVSDAX – Crosswalk Validation

WEBCAPP Internal Group Code

8 rows to be entered manually (Student 5.3)

Only WEBCURR hierarchy stays in GTVSDAX (Student 5.4)

DISPTEXT

SECONDCURR

STUEMAIL

FACEMAIL

WEBCURR

Hierarchy concept

1, 2, 3 and 4

13

GTVSDAX (5.3) / SMAWCRL (5.4)

DISPTEXT

Valid value from STVPRNT

Text associated with a program, area, group and/or rule with this print code will appear on the General and Detail Requirements page

Program text only displays on the General Requirements page

In Student 5.4 this control moves to SMAWCRL (WebCAPP Rules).

14

15

GTVSDAX (5.3) / SMAWCRL (5.4)

SECONDCURR The external code will be Y or N.

If SECONDCURR = Y (checked) The secondary curriculum will display if populated

on the Applicant or General Student record and all Recruiting and Degree records will display

16

GTVSDAX (5.3) / SMAWCRL (5.4)

SECONDCURR If SECONDCURR = N (unchecked)

The secondary curriculum will not display even if is exists on the Applicant or General Student record. The Recruiting and Degree records that displays will be the record with the highest catalog term and lowest sequence number.

17

18

GTVSDAX (5.3) / SMAWCRL (5.4)

STUEMAIL (Self Service for Faculty & Advisors)

Valid value from GTVEMAL

The email address associated with this code must be active, Preferred and Display on Web on GOAEMAL.

If the Student does not have an email address that meets the criteria, the Email link will not display on the General and Detail Requirements pages.

19

20

GTVSDAX (5.3) / SMAWCRL (5.4)

FACEMAIL (Self Service for Students)

Valid value from GTVEMAL

The email address associated with this code must be active, Preferred and Display on Web on GOAEMAL.

If the Advisor does not have an email address that meets the criteria, the Email your Advisor link will not display on the General and Detail Requirements pages.

21

22

GTVSDAX - Crosswalk Validation (Cont)

WEBCURR

This is a hierarchy of values determine which curriculum record(s) is pulled for display on the Degree Evaluation and the Generate New Request pages.

Each of the four records must have an external associated.

23

GTVSDAX - Crosswalk Validation (Cont)

WEBCURR (continued)

The valid values are:

DEG – Degree Record (SHADEGR)

GST – General Student Record (SGASTDN)

ADM – Applicant Record (SAAADMS)

REC – Prospect Information Record (SRARECR)

24

25

GTVSDAX - Crosswalk Validation (Cont)

WEBCURR (continued) Each value will associated with a sequence

number: 1, 2, 3 or 4.

If DEG is sequence 1 but the student does not have a Degree record the system will look for a record with the next sequence number. If no record is found the ‘No Curriculum Record Found’ message will be displayed.

26

STVORIG - Originator Code Validation Form

The WEB entry is used to designate the origin of the compliance request. This value will be populated in the Originator field on SMARQCM.

SMARQCM will also track the Oracle® Application Server/Internet Application Server ‘web user’.

27

28

STVDFLT – Compliance Default Options

For SMADFLT, CAPP Compliance Default Parameter Form, the code of WEB must be added to the validation table, STVDFLT.

29

30

SMADFLT - CAPP Compliance Default Parameter

WebCAPP uses the Default Code WEB. Institutions may choose the defaults that will be used when running compliance via Self Service for Students and/or Self Service for Faculty & Advisors.

31

32

SOATERM – Term Control Form

Web Processing Controls – WebCAPP Controls

Web Graduation Term

Check this box to allow compliance to be run for this term

This was renamed to Web Evaluation Term in the 5.4 release.

33

34

SOATERM – Term Control Form (cont)

Web Processing Controls – WebCAPP Controls

Web Catalog Term (5.4)

Check this box to allow the catalog associated with this term to display.

35

36

SOATERM – Term Control Form (cont)

Web Processing Controls – Schedule Search Controls

Search by Course Attribute (5.4)

Check this box to allow the class schedule to be queried by course attributes.

37

38

39

SMAPRLE – Program Definition Rules Form

A Web Indicator was added to allow the institution to determine what programs should be available for compliance processing via the Web.

40

41

STVPROC - Process Control Form

COMPLIANCE has been added to allow for security in Self Service for Faculty & Advisors.

This value must be added manually.

COMPLIANCE security is identical in processing to TRANSCRIPT.

GTVSDAX and SOAFAPC setup remains the same.

42

43

44

SMAWCRL (5.4) – WebCAPP Rules

What-If Analysis Display

Allows the institution to decide how much a student/faculty can enter for What If analysis

Evaluation Display

Secondary Curriculum, Faculty and Student Email controls moved from GTVSDAX

Print or Compliance Type text rules

Expanded Requirements

Future release

45

46

SMAWCRL (5.4) – WebCAPP Rules

Faculty Controls Allow for faculty/advisors to ‘override’ the In-

Progress rule on SMADFLT.

Purge Controls Allow the student and/or faculty/advisor to be

able to purge their requests/results they submit via the web.

47

48

Other Forms (5.4)

STVHLDD - Compliance Hold

SMARQCM – Hold Functionality

49

50

51

Processes

SFRPINI – Compliance Listener Start Up (the pipe process)

52

Setting Up the PIPES

DBMS_PIPES are an Oracle Feature (package). Banner uses this feature for Job Submission. If your institution is running Job Submission, you are using DBMS_PIPES. Chances are that these are installed. They must be started for CAPP, though.

DBMS_PIPES for Compliance Listener Start Up. Set-up of pipes.

1. To start the pipes, the DBA must run SFRPINI.

2. SFRPIPE is the process to start the pipes; it cannot be run alone; it is invoked by SFRPINI.

53

Setting Up the PIPES (Cont)

SFRPINI will start SFRPIPE for each record in the SFBPIPE table.

The SFBPIPE table was delivered with ten pipes.

You probably will need to change the number of pipes running depending on volume and system capabilities.

54

Setting Up the PIPES (Cont)

If SFRPINI fails on initial run, try removing the 5 pipes from the SFBPIPE table with the queue length = 4. Then restart the process.

There is additional step by step instructions in the training materials in Appendix D.

55

Dynamic Course Catalog

You can now replace HWSRCTLG with a link to hwskctlg.P_DisplaySubjects

STVSUBJ – Web Indicator

SOATERM – Web Processing Controls

Web Catalog Term

56

57

58

Web Generating a Compliance

59

60

61

Will be hyperlinked, if a compliance exists.

62

“Current Enrollment” returns the person to

this web menu.

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

Catalog Term

78

79

80

81

82

Summary

WebCAPP allows students and faculty/advisors to review academic progress via the web.

WebCAPP is easy to setup!

Question and Answers

Thank you for your participation

SunGard, the SunGard logo, SCT, the SCT logo, and Banner, Campus Pipeline, Luminis, PowerCAMPUS, SCT Matrix, SCT Plus, and SCT PocketRecruiter are trademarks or registered trademarks of SunGard Data Systems Inc. or its subsidiaries in the U.S.

and other countries. All other trade names are trademarks or registered trademarks of their respective holders.

© 2003-2004 SunGard