SUDS Data Dictionary
APEX_PUBLIC_USER
Elements
Element: Room Number Suffix - 01134
Page Name
Description:
One alpha-numeric character following the four alpha-numeric 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
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Physical Facilities Space (SPA)
ROOMS (ROOM)
ROOM_NBR_SUFFIX
104
1371
24
Physical Facilities Space
Student Instruction (SIF)
COURSE_MEETINGS (MEET)
ROOM_NBR_SUFFIX
104
1185
21
Student Instruction
Student Instruction (SIF)
ROOMS (ROOM)
ROOM_NBR_SUFFIX
104
1371
24
Student Instruction
1 - 3
Allowed Values
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
SIF
COURSE_MEETINGS
6224
ROOM_NBR_SUFFIX is nulled if UNSCHED_MTG_IND = 'T'
1
Generated or Modified during SUDS Edit Process
1 - 1
Prior Database Information:
Physical Description:
VARCHAR2(1)
Short Name:
ROOMSUF
Column Name:
ROOM_NBR_SUFFIX
---
Sign Out
Search
Search