FACILITY_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_CS.SETID_FACILITY Prompt Table: SETID_TBL
2	FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Facility ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	BLDG_CD	Character(10)	VARCHAR2(10) NOT NULL	Building Prompt Table: BLDG_TBL
6	ROOM	Character(10)	VARCHAR2(10) NOT NULL	Room
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: FACILITY_TBL.DESCR
9	FACILITY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Facility Type AUD=Auditorium CBL=Cable TV CMLB=Computer Lab EXT=Exterior Space ITV=Interactive TV Classroom LAB=Laboratory LCTR=Lecture Room RSCH=Research Site SMNR=Seminar Room SPRT=Sporting Facility Default Value: LCTR
10	FACILITY_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Facility Group Y/N Table Edit Default Value: N
11	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
12	ROOM_CAPACITY	Number(4,0)	SMALLINT NOT NULL	Room Capacity
13	GENERL_ASSIGN	Character(1)	VARCHAR2(1) NOT NULL	General Assignment Y/N Table Edit Default Value: Y
14	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization Prompt Table: ACAD_ORG_TB2_VW
15	FACILITY_PARTITION	Character(2)	VARCHAR2(2) NOT NULL	Facility Partition 01=First Quadrant 02=Second Quadrant 03=Third Quadrant 04=Fourth Quadrant
16	MIN_UTLZN_PCT	Number(3,0)	SMALLINT NOT NULL	Minimum Utilization Percent
17	FACILITY_CONFLICT	Character(1)	VARCHAR2(1) NOT NULL	Status of Facility Y/N Table Edit Default Value: Y
18	EXT_SA_FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	External SA Facility ID