SUDS Data Dictionary
APEX_PUBLIC_USER
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
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
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
6222
ROOM_NBR_PREFIX is nulled if UNSCHED_MTG_IND = 'T'
1
Generated or Modified during SUDS Edit Process
1 - 1
Prior Database Information:
Physical Description:
VARCHAR2(2)
Short Name:
ROOMPRE
Column Name:
ROOM_NBR_PREFIX
---
Sign Out
Search
Search