Mapped Fields in Colleague UniData for LYNX


This page identifies the UniData Datafiles and Fields that are used for the LYNX integration between Colleague and 25Live. Bolded Field names indicate which key is the Primary Key for a specific Datafile.

Most Fields only require READ access, but some in COURSE.SEC.MEETING requires UPDATE access as well.

Meeting Pattern Update Behavior

Most of the time, customers will only update the Building (CSM.BLDG) and Room (CSM.ROOM) assignments in 25Live.

The following fields can be updated during a Location assignment export from 25Live within COURSE.SEC.MEETING.

  • CSM.START.TIME
  • CSM.END.TIME
  • CSM.START.DATE
  • CSM.END.DATE
  • CSM.SUNDAY
  • CSM.MONDAY
  • CSM.TUESDAY
  • CSM.WEDNESDAY
  • CSM.THURSDAY
  • CSM.FRIDAY
  • CSM.SATURDAY
  • CSM.DAYS
  • CSM.BLDG
  • CSM.ROOM
  • SEC.LOCATION

If any fields from the above list (matching CSM.*) are modified during an export from 25Live to Colleague, the following internal Colleague functions are called.
S.UPDT.FAC.SCHEDULES(X.SECTION, "D")
S.BUILD.SEC.SCHEDULES(X.SECTION, ERROR.OCCURRED, MSG, "1")
S.UPDT.FAC.SCHEDULES(X.SECTION, "A")

This will unassign Faculty IDs from the modified records in CALENDAR.SCHEDULES, update the section records, then add the Faculty IDs back to the new records in CALENDAR.SCHEDULES.

Mapped Datafiles

ACAD.LEVELS

FieldAccess Needed
ACAD.LEVELS.IDREAD
ACLV.DESCREAD
ACLV.CHGDATEREAD
ACLV.ADDATEREAD

BUILDINGS

FieldAccess Needed
BUILDINGS.IDREAD
BLDG.DESCREAD
BLDG.LOCATIONREAD
BLDG.TYPEREAD
BLDG.LONG.DESCREAD
BLDG.INSTITUTION.CODEREAD
BLDG.CHGDATEREAD
BLDG.ADDATEREAD

COURSE.SEC.FACULTY

FieldAccess Needed
COURSE.SEC.FACULTY.IDREAD
CSF.SECTION.TERMREAD
CSF.COURSE.SECTION

READ

CSF.FACULTYREAD
CSF.INSTR.METHODREAD
CSF.TEACHING.ARRANGEMENTREAD
CSF.FACULTY.PCTREAD
CSF.CHGDATEREAD
CSF.ADDDATEREAD
Tip: Use The LYNX Overlapping Section Binding in Place of CRMG (Common Room Groups)

When switching from an older TCS interface to LYNX, we recommend you use the Overlapping Section Binding option in place of CRMG (Common Room Groups).

COURSE.SEC.MEETING

FieldAccess Needed
COURSE.SEC.MEETING.IDREAD
CSM.COURSE.SECTIONREAD
CSM.START.DATEREAD, UPDATE
CSM.END.DATEREAD, UPDATE
CSM.BLDGREAD, UPDATE
CSM.ROOMREAD, UPDATE
CSM.INSTR.METHODREAD
CSM.START.TIMEREAD, UPDATE
CSM.END.TIMEREAD, UPDATE
COURSE.SEC.MEETING.ADDDATEREAD
COURSE.SEC.MEETING.CHGDATEREAD, UPDATE
CSM.MONDAYREAD, UPDATE
CSM.TUESDAYREAD, UPDATE
CSM.WEDNESDAYREAD, UPDATE
CSM.THURSDAYREAD, UPDATE
CSM.FRIDAYREAD, UPDATE
CSM.SATURDAYREAD, UPDATE
CSM.SUNDAYREAD, UPDATE
CSM.FREQUENCYREAD

CSM.SEC.TERM

READ
CSM.SEC.LOCATIONREAD
CSM.EQUIPMENTREAD
CSM.EQUIPMENT.QTYREAD

COURSE.SEC.XLISTS

FieldAccess Needed
COURSE.SEC.XLISTS.IDREAD
CSXL.CAPACITYREAD
CSXL.SECSREAD
CSXL.PRIMARY.SECTIONREAD
SEC.TERMREAD
COURSE.SEC.XLISTS.CHGDATEREAD
COURSE.SEC.XLISTS.ADDDATEREAD

COURSE.SECTIONS

FieldAccess Needed
COURSE.SECTIONS.IDREAD
SEC.SHORT.TITLEREAD
SEC.SCHED.TYPEREAD
SEC.LOCATIONREAD
SEC.MIN.ENROLLREAD
SEC.CAPACITYREAD
SEC.SUBJECTREAD
SEC.CEUSREAD
SEC.MIN.CREDREAD
SEC.MAX.CREDREAD
SEC.TERMREAD
SEC.INSTR.METHODSREAD
SEC.COURSE.NOREAD
SEC.NOREAD
COURSE.SECTIONS.CHGDATEREAD
COURSE.SECTIONS.ADDDATEREAD
SEC.COURSEREAD
SEC.ACAD.LEVELREAD
SEC.XLISTREAD
SEC.CRED.TYPEREAD
SEC.START.DATEREAD
SEC.END.DATEREAD
SEC.SCHED.CAPACITYREAD
SEC.NAMEREAD
SEC.NO.WEEKSREAD
SEC.CIPREAD
SEC.MEETINGREAD
SEC.ACTIVE.STUDENTSREAD
SEC.DEPTSREAD
SEC.DEPTS.PCTSREAD
SEC.EQUIPMENT.QTYREAD
SEC.EQUIPMENT.REQDREAD
SEC.STATUSREAD
SEC.STATUS.DATEREAD

COURSES

FieldAccess Needed
COURSES.IDREAD
CRS.TITLEREAD
CRS.CRED.TYPEREAD
CRS.NAMEREAD
CRS.SESSIONS.CYCLEREAD
CRS.YEARLY.CYCLEREAD
CRS.SHORT.TITLEREAD
CRS.SUBJECTREAD
CRS.MIN.CREDREAD
CRS.MAX.CREDREAD
CRS.NOREAD
CRS.CIPREAD
CRS.START.DATEREAD
CRS.END.DATEREAD
CRS.ACAD.LEVELREAD
CRS.SCHED.TYPEREAD
COURSES.CHGDATEREAD
COURSES.ADDDATEREAD
CRS.CEUSREAD
CRS.CAPACITYREAD
CRS.MIN.ENROLLREAD
CRS.SCHED.CAPACITYREAD

DEPTS

FieldAccess Needed
DEPTS.IDREAD
DEPTS.DESCREAD
DEPTS.DIVISIONREAD
DEPTS.SCHOOLREAD
DEPTS.ACAD.LEVELREAD
DEPTS.TYPEREAD
DEPTS.INSTITUTIONS.IDREAD
DEPTS.CHGDATEREAD
DEPTS.ADDDATEREAD

DIVISIONS

FieldAccess Needed
DIVISIONS.IDREAD
DIV.DESCREAD
DIV.SCHOOLREAD
DIV.ACAD.LEVELREAD
DIV.TYPEREAD
DIV.INSTITUTIONS.IDREAD
DIV.CHGDATEREAD
DIV.ADDDATEREAD

EQUIPMENT

FieldAccess Needed
EQUIPMENT.IDREAD
EQP.DESCREAD
EQP.CATEGORYREAD
EQP.CHGDATEREAD
EQP.ADDDATEREAD

INSTR.METHODS

FieldAccess Needed
INSTR.METHODS.IDREAD
INM.DESCREAD
INM.ONLINEREAD
INM.CATEGORY.CODEREAD
INM.CHGDATEREAD
INM.ADDDATEREAD

LOCATION.REGIONS

FieldAccess Needed
LOCATION.REGIONS.IDREAD
LOCR.DESCREAD
LOCR.START.DATEREAD
LOCR.END.DATEREAD
LOCR.DIVISIONSREAD
LOCR.CHGDATEREAD
LOCR.ADDDATEREAD

LOCATIONS

FieldAccess Needed
LOCATIONS.IDREAD
LOC.DESCREAD
LOC.CAMPUS.LOCATIONREAD
LOC.REGIONREAD
LOC.TYPEREAD
LOC.CHGDATEREAD
LOC.ADDDATEREAD

PARTITIONS

FieldAccess Needed
PARTITIONS.IDREAD
PRTN.DESCREAD
PRTN.CHGDATEREAD
PRTN.ADDDATEREAD

PERSON

FieldAccess Needed
IDREAD
LAST.NAMEREAD
FIRST.NAMEREAD
MIDDLE.NAMEREAD
PERSON.EMAIL.ADDRESSESREAD
PERSON.EMAIL.TYPESREAD
PERSON.PREFERRED.EMAILREAD
PERSON.CHGDATEREAD
PERSON.ADDDATE

READ


LYNX only collects information for Instructors assigned to a Section from the PERSON datafile. No Student information is needed.

ROOMS

FieldAccess Needed
ROOMS.IDREAD
ROOMS.BLD.IDREAD
ROOMS.ROOM.IDREAD
ROOM.NAMEREAD
ROOM.CAPACITYREAD
ROOM.MIN.NO.PEOPLEREAD
ROOM.TYPEREAD
ROOM.RESPONSIBLE.DEPTREAD
ROOM.PARTITIONREAD
ROOM.CIPREAD
ROOM.AREAREAD
ROOM.CHGDATEREAD
ROOM.ADDDATEREAD

SCHED.TYPES

FieldAccess Needed
SCHED.TYPES.IDREAD
SCTP.DESCREAD
SCTP.CHGDATEREAD
SCTP.ADDDATEREAD

SUBJECTS

FieldAccess Needed
SUBJECTS.IDREAD
SUBJ.DESCREAD
SUBJ.CHGDATEREAD
SUBJ.ADDDATEREAD

TERMS

FieldAccess Needed
TERMS.IDREAD
TERM.REPORTING.YEARREAD
TERM.DESCREAD
TERM.START.DATEREAD
TERM.END.DATEREAD
TERM.SESSIONREAD
TERM.CHGDATEREAD
TERM.ADDDATEREAD

CORE.VALCODES

FieldAccess Needed
VALCODE.IDREAD
VAL.MINIMUM.INPUT.STRINGREAD
VAL.INTERNAL.CODEREAD
VAL.EXTERNAL.REPRESENTATIONREAD
VAL.CHGDATEREAD
VAL.ADDDATEREAD

ST.VALCODES

FieldAccess Needed
VALCODE.IDREAD
VAL.MINIMUM.INPUT.STRINGREAD
VAL.INTERNAL.CODEREAD
VAL.EXTERNAL.REPRESENTATIONREAD
VAL.CHGDATEREAD
VAL.ADDDATEREAD

Valcodes Collected

LYNX collects the following VALCODES:

  • BUILDING.TYPES
  • PERSON.EMAIL.TYPES
  • ROOM.CHARACTERISTICS
  • SECTION.STATUSES
  • COURSE.LEVELS
  • COURSE.STATUSES
  • COURSE.TYPES
  • TEACHING.ARRANGEMENTS