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
Field | Access Needed |
---|---|
ACAD.LEVELS.ID | READ |
ACLV.DESC | READ |
ACLV.CHGDATE | READ |
ACLV.ADDATE | READ |
BUILDINGS
Field | Access Needed |
---|---|
BUILDINGS.ID | READ |
BLDG.DESC | READ |
BLDG.LOCATION | READ |
BLDG.TYPE | READ |
BLDG.LONG.DESC | READ |
BLDG.INSTITUTION.CODE | READ |
BLDG.CHGDATE | READ |
BLDG.ADDATE | READ |
COURSE.SEC.FACULTY
Field | Access Needed |
---|---|
COURSE.SEC.FACULTY.ID | READ |
CSF.SECTION.TERM | READ |
CSF.COURSE.SECTION | READ |
CSF.FACULTY | READ |
CSF.INSTR.METHOD | READ |
CSF.TEACHING.ARRANGEMENT | READ |
CSF.FACULTY.PCT | READ |
CSF.CHGDATE | READ |
CSF.ADDDATE | READ |
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
Field | Access Needed |
---|---|
COURSE.SEC.MEETING.ID | READ |
CSM.COURSE.SECTION | READ |
CSM.START.DATE | READ, UPDATE |
CSM.END.DATE | READ, UPDATE |
CSM.BLDG | READ, UPDATE |
CSM.ROOM | READ, UPDATE |
CSM.INSTR.METHOD | READ |
CSM.START.TIME | READ, UPDATE |
CSM.END.TIME | READ, UPDATE |
COURSE.SEC.MEETING.ADDDATE | READ |
COURSE.SEC.MEETING.CHGDATE | READ, UPDATE |
CSM.MONDAY | READ, UPDATE |
CSM.TUESDAY | READ, UPDATE |
CSM.WEDNESDAY | READ, UPDATE |
CSM.THURSDAY | READ, UPDATE |
CSM.FRIDAY | READ, UPDATE |
CSM.SATURDAY | READ, UPDATE |
CSM.SUNDAY | READ, UPDATE |
CSM.FREQUENCY | READ |
CSM.SEC.TERM | READ |
CSM.SEC.LOCATION | READ |
CSM.EQUIPMENT | READ |
CSM.EQUIPMENT.QTY | READ |
COURSE.SEC.XLISTS
Field | Access Needed |
---|---|
COURSE.SEC.XLISTS.ID | READ |
CSXL.CAPACITY | READ |
CSXL.SECS | READ |
CSXL.PRIMARY.SECTION | READ |
SEC.TERM | READ |
COURSE.SEC.XLISTS.CHGDATE | READ |
COURSE.SEC.XLISTS.ADDDATE | READ |
COURSE.SECTIONS
Field | Access Needed |
---|---|
COURSE.SECTIONS.ID | READ |
SEC.SHORT.TITLE | READ |
SEC.SCHED.TYPE | READ |
SEC.LOCATION | READ |
SEC.MIN.ENROLL | READ |
SEC.CAPACITY | READ |
SEC.SUBJECT | READ |
SEC.CEUS | READ |
SEC.MIN.CRED | READ |
SEC.MAX.CRED | READ |
SEC.TERM | READ |
SEC.INSTR.METHODS | READ |
SEC.COURSE.NO | READ |
SEC.NO | READ |
COURSE.SECTIONS.CHGDATE | READ |
COURSE.SECTIONS.ADDDATE | READ |
SEC.COURSE | READ |
SEC.ACAD.LEVEL | READ |
SEC.XLIST | READ |
SEC.CRED.TYPE | READ |
SEC.START.DATE | READ |
SEC.END.DATE | READ |
SEC.SCHED.CAPACITY | READ |
SEC.NAME | READ |
SEC.NO.WEEKS | READ |
SEC.CIP | READ |
SEC.MEETING | READ |
SEC.ACTIVE.STUDENTS | READ |
SEC.DEPTS | READ |
SEC.DEPTS.PCTS | READ |
SEC.EQUIPMENT.QTY | READ |
SEC.EQUIPMENT.REQD | READ |
SEC.STATUS | READ |
SEC.STATUS.DATE | READ |
COURSES
Field | Access Needed |
---|---|
COURSES.ID | READ |
CRS.TITLE | READ |
CRS.CRED.TYPE | READ |
CRS.NAME | READ |
CRS.SESSIONS.CYCLE | READ |
CRS.YEARLY.CYCLE | READ |
CRS.SHORT.TITLE | READ |
CRS.SUBJECT | READ |
CRS.MIN.CRED | READ |
CRS.MAX.CRED | READ |
CRS.NO | READ |
CRS.CIP | READ |
CRS.START.DATE | READ |
CRS.END.DATE | READ |
CRS.ACAD.LEVEL | READ |
CRS.SCHED.TYPE | READ |
COURSES.CHGDATE | READ |
COURSES.ADDDATE | READ |
CRS.CEUS | READ |
CRS.CAPACITY | READ |
CRS.MIN.ENROLL | READ |
CRS.SCHED.CAPACITY | READ |
DEPTS
Field | Access Needed |
---|---|
DEPTS.ID | READ |
DEPTS.DESC | READ |
DEPTS.DIVISION | READ |
DEPTS.SCHOOL | READ |
DEPTS.ACAD.LEVEL | READ |
DEPTS.TYPE | READ |
DEPTS.INSTITUTIONS.ID | READ |
DEPTS.CHGDATE | READ |
DEPTS.ADDDATE | READ |
DIVISIONS
Field | Access Needed |
---|---|
DIVISIONS.ID | READ |
DIV.DESC | READ |
DIV.SCHOOL | READ |
DIV.ACAD.LEVEL | READ |
DIV.TYPE | READ |
DIV.INSTITUTIONS.ID | READ |
DIV.CHGDATE | READ |
DIV.ADDDATE | READ |
EQUIPMENT
Field | Access Needed |
---|---|
EQUIPMENT.ID | READ |
EQP.DESC | READ |
EQP.CATEGORY | READ |
EQP.CHGDATE | READ |
EQP.ADDDATE | READ |
INSTR.METHODS
Field | Access Needed |
---|---|
INSTR.METHODS.ID | READ |
INM.DESC | READ |
INM.ONLINE | READ |
INM.CATEGORY.CODE | READ |
INM.CHGDATE | READ |
INM.ADDDATE | READ |
LOCATION.REGIONS
Field | Access Needed |
---|---|
LOCATION.REGIONS.ID | READ |
LOCR.DESC | READ |
LOCR.START.DATE | READ |
LOCR.END.DATE | READ |
LOCR.DIVISIONS | READ |
LOCR.CHGDATE | READ |
LOCR.ADDDATE | READ |
LOCATIONS
Field | Access Needed |
---|---|
LOCATIONS.ID | READ |
LOC.DESC | READ |
LOC.CAMPUS.LOCATION | READ |
LOC.REGION | READ |
LOC.TYPE | READ |
LOC.CHGDATE | READ |
LOC.ADDDATE | READ |
PARTITIONS
Field | Access Needed |
---|---|
PARTITIONS.ID | READ |
PRTN.DESC | READ |
PRTN.CHGDATE | READ |
PRTN.ADDDATE | READ |
PERSON
Field | Access Needed |
---|---|
ID | READ |
LAST.NAME | READ |
FIRST.NAME | READ |
MIDDLE.NAME | READ |
PERSON.EMAIL.ADDRESSES | READ |
PERSON.EMAIL.TYPES | READ |
PERSON.PREFERRED.EMAIL | READ |
PERSON.CHGDATE | READ |
PERSON.ADDDATE | READ |
LYNX only collects information for Instructors assigned to a Section from the PERSON datafile. No Student information is needed.
ROOMS
Field | Access Needed |
---|---|
ROOMS.ID | READ |
ROOMS.BLD.ID | READ |
ROOMS.ROOM.ID | READ |
ROOM.NAME | READ |
ROOM.CAPACITY | READ |
ROOM.MIN.NO.PEOPLE | READ |
ROOM.TYPE | READ |
ROOM.RESPONSIBLE.DEPT | READ |
ROOM.PARTITION | READ |
ROOM.CIP | READ |
ROOM.AREA | READ |
ROOM.CHGDATE | READ |
ROOM.ADDDATE | READ |
SCHED.TYPES
Field | Access Needed |
---|---|
SCHED.TYPES.ID | READ |
SCTP.DESC | READ |
SCTP.CHGDATE | READ |
SCTP.ADDDATE | READ |
SUBJECTS
Field | Access Needed |
---|---|
SUBJECTS.ID | READ |
SUBJ.DESC | READ |
SUBJ.CHGDATE | READ |
SUBJ.ADDDATE | READ |
TERMS
Field | Access Needed |
---|---|
TERMS.ID | READ |
TERM.REPORTING.YEAR | READ |
TERM.DESC | READ |
TERM.START.DATE | READ |
TERM.END.DATE | READ |
TERM.SESSION | READ |
TERM.CHGDATE | READ |
TERM.ADDDATE | READ |
CORE.VALCODES
Field | Access Needed |
---|---|
VALCODE.ID | READ |
VAL.MINIMUM.INPUT.STRING | READ |
VAL.INTERNAL.CODE | READ |
VAL.EXTERNAL.REPRESENTATION | READ |
VAL.CHGDATE | READ |
VAL.ADDDATE | READ |
ST.VALCODES
Field | Access Needed |
---|---|
VALCODE.ID | READ |
VAL.MINIMUM.INPUT.STRING | READ |
VAL.INTERNAL.CODE | READ |
VAL.EXTERNAL.REPRESENTATION | READ |
VAL.CHGDATE | READ |
VAL.ADDDATE | READ |
Valcodes Collected
LYNX collects the following VALCODES:
- BUILDING.TYPES
- PERSON.EMAIL.TYPES
- ROOM.CHARACTERISTICS
- SECTION.STATUSES
- COURSE.LEVELS
- COURSE.STATUSES
- COURSE.TYPES
- TEACHING.ARRANGEMENTS