• Elements

  • Element: Room Number Digits - 01133

Page Name

Four alpha-numeric characters designating a room.

Institutionally assigned number or identifier, and must be the exact same identifier for this room on both the non-SUDS Facilities ROOMS table and the SIF.

COURSE_MEETINGS table. This field must be identically coded on both files.

Load programs on the COURSE_MEETINGS table will NULL value when UNSCHED_MTG_FLG = 'T'



ELEMENT

192001

21-JUL-2022


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Physical Facilities Space (SPA)ROOMS (ROOM)ROOM_NBR_DIGITS103136924Physical Facilities Space
Student Instruction (SIF)COURSE_MEETINGS (MEET)ROOM_NBR_DIGITS103118321Student Instruction
Student Instruction (SIF)ROOMS (ROOM)ROOM_NBR_DIGITS103136924Student Instruction
  • 1 - 3

Allowed Values

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
SIFCOURSE_MEETINGS5336Class with an Unscheduled Meeting Time Flag (#01197) value of X (Scheduled) and there is no matching Room record found within the Report Time Frame (#02001) by Reporting Institution (#01045), Site Number (#10062), Building Number (#01130), Room Number Prefix (#01132), Room Number Digits (#01133), and Room Number Suffix (#01134).9Critical Error: may cause submission to be rejected
SIFCOURSE_MEETINGS5367Class with an Unscheduled Meeting Time Flag (#01197) value of X (Scheduled) cannot be assigned to out-of-use rooms. 9Critical Error: may cause submission to be rejected
SIFCOURSE_MEETINGS6223ROOM_NBR_DIGITS is nulled if UNSCHED_MTG_IND = 'T' 1Generated or Modified during SUDS Edit Process
  • 1 - 3

Prior Database Information:

VARCHAR2(10)
ROOMNO
ROOM_NBR_DIGITS
Release 2.0