Skip Headers
Oracle® Student Learning Implementation Guide
Release 3.1.3

Part Number E21072-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

A List of Values (LOVs)

This appendix describes each of the LOVs that are used by OSL.

A.1 LOVs Matrix

The following table provides a list of LOVs.

Cust – LOV can be customized

Remv – Value can be removed or end-dated

Table A-1 LOVs Matrix

LOV Purpose Value Value Description Cust Remv

OSL_ACCESSIBILITY_LEVEL

The level of accessibility.

   

Yes

 
   

ACCESSIBILE

Supports accessibility features

 

No

   

INACCESSIBLE

Accessibility features are removed to optimize performance

 

No

   

SCREEN_READER

Accessibility features are added to improve behaviour in a screen reader, but not for users

 

No

OSL_ADDRESS_USAGE_TYPE

Presented to the administrator as options for the purpose of an address.

   

No

 
   

HEADQUARTERS_FOR

   

No

   

HOME

   

No

   

OTHER

   

No

   

TEMP_ADDRESS

   

No

   

VACATION_HOME

   

No

   

PRIMARY

   

No

   

PRIMARY_HOME

   

No

   

MAILING

   

No

OSL_APPROVAL_STATUS

Not used

       

OSL_ASSESSED_OUTCOME_TYPE

Denotes the type of an assessed outcome.

   

No

 
   

C

Confirmation

 

No

   

D

Demonstration

 

No

OSL_ASSESSMENT_TYPE

Denotes the type of an assessment.

   

No

 
   

G

Graded assessment

 

No

   

N

Numeric (marks) assessment

 

No

OSL_COLLECTION_CATEGORY

Denotes the type of a collection.

   

No

 
   

CLASS

Class collection

 

No

   

GROUP

Group collection

 

No

   

LEARNINGITEM

Learning item collection

 

No

   

LEARNINGPLAN

Learning plan collection

 

No

OSL_COLLECTION_GROUP_RELATION

Denotes the type of relationship between two collections.

   

No

 
   

CLASS-GROUP

Class-core group relationship

 

No

   

LEARNINGPLAN-CLASS

Learning plan-class group relationship

 

No

   

LEARNINGITEM-CLASS

Learning item-class group relationship

 

No

   

EXTERNAL_CLASS-LEARNINGPLAN

External class-learning plan group relationship

 

No

OSL_COLLECTION_RELATIONSHIP

Denotes the type of relationship that a party has with a collection.

   

No

 
   

STUDENT_OF_CLASS

Student of class

 

No

   

TEACHER_OF_CLASS

Teacher of class

 

No

   

STUDENT_OF_CORE_GROUP

Student of core group

 

No

   

TEACHER_OF_CORE_GROUP

Teacher of core group

 

No

   

STUDENT_OF_LEARNING_PLAN

Student of learning plan

 

No

   

STUDENT_OF_LEARNING_ITEM

Student of learning item

 

No

   

EXTERNAL_STUDENT_OF_CLASS

External student of class

 

No

OSL_CONTACT_POINT_PURPOSE

Denotes the purpose of a party's contact point.

   

No

 
   

ASSISTANT

Assistant

 

No

   

BUSINESS

Business

 

No

   

HOME_BUSINESS

Home business

 

No

   

PERSONAL

Personal

 

No

   

EMERGENCY

Emergency

 

No

   

HOMEPAGE

Homepage

 

No

OSL_CONTACT_POINT_TYPE

Denotes the type of a party contact point.

   

No

 
   

EMAIL

Email

 

No

   

FAX

Fax

 

No

   

PHONE

Phone

 

No

   

PAGER

Pager

 

No

   

SMS

SMS

 

No

   

WEB

Web

 

No

OSL_CONTENT_RESOURCE_TYPE

Denotes the type of a content resource

   

No

 
   

FILE

File resource

 

No

   

IMAGE

Image resource

 

No

   

AUDIO

Audio resource

 

No

OSL_CUSTOMISATION_LEVEL

Denotes the level of customisation that is allowed for LOVs.

   

No

 
   

APPL

Cannot be customised

 

No

   

INSTN

Department can customise

 

No

OSL_DEFAULT_ROLE

Denotes the role to be taken by default if the user has multiple roles.

   

No

 
   

PARENT

Parent role

 

No

   

TEACHER

Teacher role

 

No

OSL_DISCUSSION_TYPE

Presented to the user as options for the type of discussion post.

   

Yes

 
   

ANNOUNCEMENT

Announcement

 

Yes

   

ANSWER

Answer

 

Yes

   

NORMAL

Normal

 

Yes

   

QUESTION

Question

 

Yes

OSL_GENDER

Presented to the administrator as options for the gender of a person.

   

No

 
   

FEMALE

Female

 

No

   

MALE

Male

 

No

   

UNKNOWN

Unknown

 

No

OSL_INSTITUTION_TYPE

Denotes the type of an institution

   

Yes

 
   

DEPARTMENT

Department

 

No

   

NON-SCHOOL

Non-school (For example, Region or district)

 

No

   

PRIMARY

Primary school

 

Yes

   

SECONDARY

Secondary school

 

Yes

   

SPECIAL

Special school

 

Yes

OSL_LANGUAGE

Not used

       

OSL_LEARNING_ITEM_TYPE

Denotes the type of a learning item.

   

No

 
   

CLASS

Class learning item

 

No

   

DISCUSSION

Discussion learning item

 

No

   

DOCUMENT

Document learning item

 

No

   

FOLDER

Folder learning item

 

No

   

JOURNAL

Journal learning item

 

No

   

PERSONAL

Personal planning area

 

No

   

REFERENCE

Reference learning item

 

No

   

SUBMISSION

Submission learning item

 

No

   

TASK

Task learning item

 

No

OSL_LIST_NAME_FORMAT

Format of the list of names.

   

No

 
   

DISPLAY_NAME

The defined Display Name is displayed.

 

No

   

LAST_FIRST_NAME

Names are displayed as ''Lastname Firstname''.

 

No

   

LAST_PREFERRED_NAME

Names are displayed as ''Lastname Preferredname''. If the Preferredname is null, the name is displayed as ''Lastname Firstname''.

 

No

   

LAST_COMMA_FIRST_NAME

Names are displayed as ''Lastname, Firstname''.

 

No

   

LAST_COMMA_PREFERRED_NAME

Names are displayed as ''Lastname, Preferredname''. If the Preferredname is null, the name is displayed as ''Lastname, Firstname''.

 

No

   

FIRST_LAST_NAME

Names are displayed as ''Firstname Lastname''.

 

No

   

PREFERRED_LAST_NAME

Names are displayed as ''Preferredname Lastname''. If the Preferredname is null, the name is displayed as ''Firstname Lastname''.

 

No

   

FIRST_MIDDLE_LAST_NAME

Names are displayed as ''Firstname MiddleName Lastname''.

 

No

   

LAST_COMMA_FIRST_MIDDLE_NAME

Names are displayed as ''Lastname, Firstname Middlename''.

 

No

OSL_LOCK_TYPE

Not used

       

OSL_NAME_SORT_OPTIONS

Options for sorting names.

   

No

 
   

DISPLAY_NAME

Names are sorted in order of Sort Name, Display Name.

 

No

   

LAST_FIRST_NAME

Names are sorted in order of Last Name, First Name, Middle Name.

 

No

   

LAST_PREFERRED_NAME

Names are sorted in order of Last Name, Preferred Name, First Name, Middle Name.

 

No

   

FIRST_LAST_NAME

Names are sorted in order of First Name, Last Name, Middle Name.

 

No

   

PREFERRED_LAST_NAME

Names are sorted in order of Preferred Name, First Name, Last Name, Middle Name.

 

No

OSL_OBSERVATION_AUDIENCE

Presented to the teacher as options for the viewing audience when creating an observation

   

No

 
   

kInternal

INTERNAL

Internal audience - teachers only

 

No

   

kExternal

EXTERNAL

External audience - teachers, student, parents

 

No

OSL_OBSERVATION_CATEGORY

Presented as options for the category of an observation when it is being created

   

Yes

 
   

ADVICE

Learning advice

 

Yes

   

IMPROVEMENT

Areas for improvement

 

Yes

   

REFLECTIONS

Reflections of learning

 

Yes

   

SUPPORT

Learning support

 

Yes

   

WELLDONE

Things student does well

 

Yes

OSL_OBSERVATION_TYPE

Denotes the type of an observation

   

No

 
   

LI

Learning Item Observations

 

No

   

GLOBAL

Global Observations

 

No

OSL_OUTCOME_STATEMENT_TYPE

Denotes the type of an outcome statement

   

No

 
   

ANNOTATIVE

Annotative outcome statement

 

No

   

DEMONSTRABLE

Demonstrable outcome statement

 

No

   

INDICATIVE

Indicative outcome statement

 

No

OSL_PARTY_TYPE

Denotes the type of a party

   

No

 
   

PERSON

Person

 

No

   

ORGANISATION

Organisation

 

No

OSL_PERSON_TITLE

Presented to the administrator as options for the title of a person

   

No

 
   

DR

Dr

 

No

   

MR

Mr

 

No

   

MRS

Mrs

 

No

   

MS

Ms

 

No

OSL_PHONE_TYPE

Denotes the type of a party's phone contact

   

No

 
   

OFFICE

Office phone

 

No

   

HOME

Home phone

 

No

   

MOBILE

Mobile phone

 

No

OSL_PROFICIENCY_LEVEL_TYPE

Denotes the type of a proficiency level

   

Yes

 
   

CORE

Core level

 

Yes

   

FOUNDATION

Foundation level

 

Yes

OSL_PROFICIENCY_SET_TYPE

Denotes the type of a proficiency set

   

No

 
   

GRADED

Graded proficiency set

 

No

   

OUTCOME

Outcomes proficiency set

 

No

OSL_RELATIONSHIP_TYPE

Denotes the type of relationship (or role) that one party has with another

   

No

 
   

STUDENT_OF

Student of a school or class

 

No

   

TEACHER_OF

Teacher of a school or class

 

No

   

SCHOOL_ADMIN_OF

Administrator of a school

 

No

   

SCHOOL_CURRICULUM_ADMIN_OF

Curriculum administrator of a school

 

No

   

DEPARTMENT_ADMIN_OF

Administrator of a department

 

No

   

DEPARTMENT_CURRICULUM_ADMIN_OF

Curriculum administrator of a department

 

No

   

GUEST_OF

Guest of a school or class

 

No

   

PARENT_OF

Parent of a student or class

 

No

   

GUARDIAN_OF

Guardian of a student

 

No

   

PARENT_INSTITUTION_OF

Parent institution of another institution

 

No

   

SYSTEM_ADMIN_OF

System administrator of OSL

 

No

   

SIBLING_OF

Sibling of a student

 

No

OSL_SPOKEN_COMPREHENSION_LEVEL

Not used

       

OSL_WORKSPACE_TYPE

The LT workspaces that are available to students

   

No

 
   

BASIC

Basic student workspace

 

No

   

STANDARD

Standard workspace

 

No

OSL_YES_NO

Denotes how 'Yes' & 'No' is represented in the DB

   

No

 
   

N

No

 

No

   

Y

Yes

 

No