Page Name

Description:

The official number or other identifier that serves to uniquely identify the building or covered walkway within a site.

Coding Instructions:

Institutionally assigned number or identifier, and must be the exact same identifier for this building on both the non-SUDS Facilities BUILDING 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

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Physical Facilities Space (SPA)	BUILDINGS (BLDG)	BLDG_NBR	100	1275	23	Physical Facilities Space
Physical Facilities Space (SPA)	ROOMS (ROOM)	BLDG_NBR	100	1365	24	Physical Facilities Space
Student Instruction (SIF)	BUILDINGS (BLDG)	BLDG_NBR	100	1275	23	Student Instruction
Student Instruction (SIF)	COURSE_MEETINGS (MEET)	BLDG_NBR	100	1179	21	Student Instruction
Student Instruction (SIF)	ROOMS (ROOM)	BLDG_NBR	100	1365	24	Student Instruction

1 - 5

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
SIF	COURSE_MEETINGS	6221	BLDG_NBR is nulled if UNSCHED_MTG_IND = 'T'	1	Generated or Modified during SUDS Edit Process

1 - 1

Physical Description:

VARCHAR2(20)

Short Name:

BLDGNO

Column Name:

BUILDING_NUMBER

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Building Number - 01130

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: