Top of GRD Index Table of Contents Feedback

GRDJ7000 - GVS Data Processing Job

Purpose To enable institutions to securely send student data in the Digitary Learner Profile (DLP) format to the My eQuals Graduation Verification Service (GVS).
SubSystem Graduation
Normally Run By Administration Specialist
Anticipated Frequency Run periodically during each Ceremony Round Processing Period
Structure  Tab Parameters

  

This job enables institutions to securely send the student data in the Digitary Learner Profile (DLP) format to Digitary for use by the Graduate Verification Service (GVS).

The job creates new records in GVS, updates existing records in GVS and removes existing records from GVS.

The job can be run in Schedule ASAP or Scheduled mode by the institution.

Note: The GVS Web Service details must be configured in GENF5000 for the job to run properly

 

The GVS Data Processing Job block contains:

Parameters Tab

  • Date From
  • Date To
  • Include Creates checkbox
  • Include Updates checkbox
  • Include Deletes checkbox

Rules/Notes:

The users can run this job to :
•  Create new records in GVS
•  Update existing records in GVS
•  Delete existing records from GVS.

Records are written into the S_LOG_ENTRY table after the job is run.

Select the check box(es) for the different sets of data that you wish to include in the job. At least one check box must be selected for this job to run.

When the Include Creates checkbox is selected, the job will only process records with the following Graduand details are satisfied:

  • Graduand Status in GRDF4200 is mapped to a System Graduand Status of GRADUATED
  • GVS Create Date in GRDF4200 is null
  • Conferral Date in GRDF4200 is not null
  • Send Data to GVS checkbox in GRDF4200 is selected.

All the records that have been successfully created in Digitary, will be flagged as transferred in Callista SMS by setting the GVS Create Date in GRDF4200 to the current date.

When the Include Updates checkbox is selected, a STUDENT_TODO record with S_STUDENT_TODO_TYPE of GVS-UPDATE is created when: the GVS Create Date in GRDF4200 is not null, the Send Data to GVS checkbox in GRDF4200 is selected, and one of the following fields has been updated for the student:

  • Address Line 1 (where address type is GVS-EMAIL)
  • Email Address
  • Birth Date
  • Given names
  • Surname
  • Graduation name
  • Honours level
  • Award title.

It will select each student record from the STUDENT_TODO table with a S_STUDENT_TODO_TYPE of ‘GVS-UPDATE for processing.

  • If the Date From parameter is specified, then only records with an Award Date on or after the date will be processed.
    If the Date To’parameter is specified, then only records with an Award Date on or before the date will be processed.
    If both parameters are specified, then only records with an Award Date that falls within the date range will be processed.
    If dates are not specified the job uses the current period.
  • All the records that have been successfully updated in Digitary, will be flagged as transferred in SMS by setting the GVS Create Date in GRDF4200 to the current date for the students.
  • Each STUDENT_TODO record that has been successfully processed, will be logically deleted from the STUDENT_TODO table.
  • Any records that are not successfully transferred to the GVS will return a validation message and the details logged in an S_LOG_ENTRY record and the GVS Create Date in GRDF4200 will not be updated, so that the data will be picked up again in a subsequent run of the job.

When the Include Deletes checkbox is selected, a STUDENT_TODO record with S_STUDENT_TODO_TYPE of GVS-OPTOUT is created  when a GVS Create Date exists in GRDF4200 and the Send Data to GVS checkbox in GRDF4200 is updated.

The Date From and Date To parameters are not relevant when the Delete option is selected.

  1. When the job is run, it will send each student record from the STUDENT_TODO table with a S_STUDENT_TODO_TYPE of GVS-OPTOUT to Digitary, one at a time.
  2. When a record is successfully deleted in Digitary, the GVS Create Date and GVS Update Date fields in GRDF4200 will be set to NULL.

All the records that are successfully deleted in Digitary, will be logically deleted from the STUDENT_TODO table.

1. DLP Learner Dataset

a. LearnersID

This is a mandatory element and it holds the learner’s unique identifiers.

Attribute Name Description Values Callista table name Callista column name

type		 The enumerated ID type UNIVERSITY, USI, NSN SYSTEM ISSUER TYPE SYSTEM ISSUER TYPE
value The unique identifier   PERSON PERSON_ID

Note: UNIVERSITY is the default value for type. This will provide a consistent response for the Learnersid until such time that all students have a USI.

b. Names

This element holds the learner’s name(s) and has the following associated attributes.

Attribute Name

Description

Values

Callista Table Name

Callista Column Name

nameType

The enumerated name type

STUDENT, GRADUATE, ALTERNATE

SYSTEM NAME TYPE

SYSTEM NAME TYPE

givenNames

The learner’s given names

 

PERSON

GIVEN_NAMES

familyNames

The learner’s family name

 

PERSON

SURNAME

fullName

The learner’s full name representation

 

GRADUAND

GRADUATION_NAME

Note: GRADUATE is the default value for nameType.

c. Email

Email id of the student

Attribute Name Description Values Callista table name Callista column name

email

The student's email address

   PERSON_ADDR_GVS_EMAIL_V GVS_EMSAIL_ADDR

d. Dob

Student's date of birth

Attribute Name Description Values Callista Table Name Callista Column Name
dob Student’s date of birth Format: YYYY-MM-DD PERSON BIRTH_DT

2. DLP Award Dataset

a. Name

The graduation name values as they appear on the award.

Attribute Name Description Values Callista Table Name Callista Column Name

name

Award Name

 

AWARD

AWARD_TITLE

b. Award Type

The type of award conferred. Valid award type values are shown below (this list is not exhaustive and is expected to grow and change as specific cases present).

Attribute Name Description Values Callista Table Name Callista Column Name

awardType

The type of Award

• CERTIFICATE_I
• CERTIFICATE_II
• CERTIFICATE_III
• CERTIFICATE_IV
• CERTIFICATE_V
• CERTIFICATE_VI
• DIPLOMA
• ADVANCED_DIPLOMA
• ASSOCIATE_DEGREE
• UNDERGRAD_CERTIFICATE
• BACHELOR_DEGREE
• BACHELOR_HONOURS_DEGREE
• GRADUATE_CERTIFICATE
• GRADUATE_DIPLOMA
• POSTGRADUATE_CERTIFICATE
• POSTGRADUATE_DIPLOMA
• MASTERS_DEGREE
• DOCTORAL_DEGREE
• CERTIFICATE
• DEGREE

GOVT_COURSE_TYPE

DESCRIPTION

c. Issuer

This element holds the details of the issuer of the award and has the following associated attributes.

Attribute Name Description Values Callista Table Name Callista Column Name

type

The type of issuer

 • CUSTODIAN
• JOINT
• ANTECEDANT

AWARD_ISSUER

ISSUER_TYPE

identifier

The issuer’s unique identifier

 

AWARD_ISSUER

ISSUER_CD

name

The issuer’s full name

 

AWARD_ISSUER

ISSUER_NAME

url

The issuer’s public URL

 

AWARD_ISSUER

ISSUER_URL

countryCode

The issuer’s country code

Defaulted to ‘AU’

AWARD_ISSUER

ISSUER_COUNTRY

d. awardid

The unique identifier for the award for a learner. It is expected to be a unique value to identify the specific award. The type and format of this value is determined by the institution. The Verification Service determines uniqueness based on this value and the issuing institution. This unique awardId value is also used to update and revoke previously supplied records.

Attribute Name Description Values Callista Table Name Callista Column Name

awardId

The unique identifier for the Award.

 

PERSON.
AWARD

PERSON_ID ||AWARD_CD

e. awardTitle

The title of the award.

Attribute Name Description Values Callista Table Name Callista Column Name

awardTitle

The Title of the Award achieved.

 

AWARD

AWARD_TITLE

f. honours

Honours information

Attribute Name Description Values Callista Table Name Callista Column Name

honours

Honours information.

 

GRADUAND

HONOURS_LEVEL

g. studyAreas

Attribute Name Description Values Callista Table Name Callista Column Name

Type

The type of area of study.

 • SPECIALISATION
• MAJOR
• MINOR

FIELD_OF_STUDY

GOVT_FIELD_OF_STUDY

Title

The title of the area of study

 

GOVT_FIELD_OF_STUDY

DESCRIPTION

h. awardDate

The date the award was conferred, and it should be in YYYY-MM-DD Format.

Attribute Name Description Values Callista Table Name Callista Column Name

awardDate

Date the student was conferred.

Format: YYYY-MM-DD

GRADUAND

CONFERRAL_DT

i. issueDate

The date the award was issued

Attribute Name Description Values Callista Table Name Callista Column Name

issueDate

Date the award was issued.

Format: YYYY-MM-DD

N/A          

N/A

 

Last Modified on 08-Feb-2022 11:43 AM

History Information

Release Version Project Change to Document
23.1.0.3, 24.0.0.3 & 24.1.0.2 2549 - My eQuals EVS New Online Help page