Purpose

To enquire on the Service choice details recorded by students via Connect

SubSystem

Enrolments

The primary purpose of this form is to enquire on the Service choice details recorded by students via Connect. It is also used by administrators to directly maintain Students’ Service details (update, delete and insert).

It is accessed from the menu or from the ‘Services’ button displayed in ENRF3000 (Person).

Users have the choice of updating existing records (other than Service Code, Start Date) or inserting new records. When a new Service record is inserted, the Start Date will default to the current date, but may be modified before saving. If a current open-ended Service record with the same Service Code already exists, it is automatically end dated (current date less one day).

When a Service is inserted, a response must be recorded, in one of the following ways:

• When the selected Service has a YES-NO Response Type, a YES or NO response must be recorded in the Use Service field. The Open Question Response field and the Multiple Choice Response block are disabled
• When the selected Service has an OPEN Response Type, a response must be recorded in the Open Question Response field. The Use Service field and Multiple Choice Response block are disabled
• When the selected Service has a MULTCHOICE Response Type, at least one Answer in the Multiple Choice Response block must be selected. The Use Service and Open Question Response fields are disabled.

This function will also include:

• An ‘As at Date’ field – to enable users to restrict the display of Service records to those current, as at the specified date (e.g. the current date). This field will default to NULL (i.e. show all records).  
• A ‘Sort By’ field – to enable users to sort either by Start Date (DESC) / Service Code (ASC) or Service Code (ASC) / Start Date (DESC). The default sort order will be Start Date (DESC) / Service Code (ASC)
• A Question Text button - to display the question text (if defined) for a Service.

For further details on Service choice details recorded by students via Connect, see Record Person Service Selections (SSF_PE_SERVICE) or Maintain Services (ENRF01Y0).

The Person block contains:

• Person ID
• Sex
• Date Of Birth

The Person Service block contains:

• Sort By (Pop)
• As At Date
• Service Code (LOV)
• Description
• Response Type
Use Service (Pop)
• Start Date
• End Date
• Open Question Response

Button

• Question Text (Overlay)
  • Question Text
  • Back button

The Multiple Choice Response block contains:

• Answer Code
• Description
• Select check box
• Answer Text

Rules/Notes:

Validations include:

• Use Service must be specified when the Response Type is YES-NO
• Open Question Response must be specified when the Response Type is OPEN
• At least one Multiple Choice Answer  must be selected when the Response Type is MULTCHOICE
• Cannot select more than one Multiple Choice Answer when the  Response Type is MULTCHOICE and Multiple Choice Selection Type is SINGLE
• When an End Date is inserted, It must be greater than or equal to the Start Date
• The Start Date must be less than or equal to the End Date
• A future start date cannot be inserted
• Service Code dates cannot overlap with an existing Service Code for the person.

When the Question Text button is selected, the Question Test overlay appears over the top of the Open Question Response. The Button only enables when the Question Text is not NULL.

The Multiple Choice Response block is only enabled when the selected Service has a MULTCHOICE Response Type, otherwise, this block is disabled.

Label

Field Source

Field Type

Format

Comments

Person ID

PDV.PERSON_ID

Text

NUMBER 9999999990

Enabled, Not updateable, Queryable

No Label

PDV.CONTEXT_BLOCK_NAME

Text

Varchar2(85)

Enabled, Not updateable, Queryable

Sex

PDV.SEX

Text

Varchar2(1)

Enabled, Not updateable, Queryable

Date of Birth

PDV.BIRTH_DT

Text

Date DD/MM/YYYY

Enabled, Not updateable, Queryable

Service Code

PES.SERVICE_CD

Text (with LOV)

Varchar2(10)

Enabled, Not Updateable, Allow Insert, Queryable

Description

SERV.DESCRIPTION

Text

Varchar2(60)

Disabled

Response Type

SERV.RESPONSE_TYPE

Text

Varchar2(10)

Disabled

Use Service

PES.USE_SERVICE_IND

Pop List

Varchar2(1)

This field only enables when Response Type = ‘YES-NO’. It also automatically set to SERV.DEFAULT_YES_NO_RESPONSE

Start Date

PES.START_DT

Text

Date DD/MM/YYYY

Enabled, Not Updateable, Allow Insert, Queryable. Default to current date when inserting new record

End Date

PES.END_DT

Text

Date DD/MM/YYYY

Enabled, Updateable, Allow Insert, Queryable

Open Question Response

PES.OPEN_QUESTION_RESPONSE

Text

Varchar2(2000)

This field only enables when Response Type = ‘OPEN’ Vertical Scroll Bar

Question Text

SERV.QUESTION_TEXT

Text

Varchar2(2000)

Display field, Non-queryable, Vertical Scroll Bar. Display in the position of Open Question Response when button Question Text is pressed

Answer Code

PSMCRV.ANSWER_CD

Text

Varchar2(10)

Display only

Description

SMCQA.DESCRITION

Text

Varchar2(60)

Display only

Select

Check box

Varchar2(1)

Enabled,
Updateable. This value it obtained from SMCQA. DEFAULT_RESPONSE_IND.  If SMCQA. DEFAULT_RESPONSE_IND = ‘Y’ then PSMCV.SELECT_ANSWER_IND = ‘Y’ else, PSMCV.SELECT_ANSWER_IND = ‘N’

Answer Text

SMCQA.ANSWER_TEXT

Text

Varchar2(1)

Display only

Sort By

Nil

Pop list

Varchar2(30)

Start Date (DESC)/ Service Code (ASC). Enabled,
Updateable

As At Date

Nil

Text

Date DD/MM/YYYY

NULL means show all records. Enabled,
Updateable