SUDS Data Dictionary
APEX_PUBLIC_USER
---
Sign Out
Home
Elements
Edits
Elements
Element: Room Number Prefix - 01132
Page Name
Description:
Two alpha-numeric characters preceding the four characters of the room number designation.
Coding Instructions:
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'
Algorithm:
Usage Type:
ELEMENT
Begin Term:
192001
End Term:
Last Modified:
21-JUL-2022
Associated Submissions, Tables, and Columns
Go
Actions
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Physical Facilities Space (SPA)
ROOMS (ROOM)
ROOM_NBR_PREFIX
102
1367
24
Physical Facilities Space
Student Instruction (SIF)
COURSE_MEETINGS (MEET)
ROOM_NBR_PREFIX
102
1181
21
Student Instruction
Student Instruction (SIF)
ROOMS (ROOM)
ROOM_NBR_PREFIX
102
1367
24
Student Instruction
1 - 3
Search
Allowed Values
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
SIF
COURSE_MEETINGS
6222
ROOM_NBR_PREFIX is nulled if UNSCHED_MTG_IND = 'T'
1
Generated or Modified during SUDS Edit Process
1 - 1
Search
Prior Database Information:
Physical Description:
VARCHAR2(2)
Short Name:
ROOMPRE
Column Name:
ROOM_NBR_PREFIX