Penn Computing

University of Pennsylvania
Penn Computing << go backback

FIS_COMMITTEE Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_COMMITTEE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
COMMITTEE_DEPT_CD

Indexed - no
Format - varchar2(12)
May be null? yes

The department associated with the committee. The 4-character code that represents the organization.

Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies)

COMMITTEE_DESCRIPTION

Indexed - yes
Format - varchar2(250)
May be null - no

The long description of the committee.

COMMITTEE_ID

Indexed - yes (primary key)
Format - number(12)
May be null? no

The unique identifier of the committee. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system.

COMMITTEE_NAME

Indexed - no
Format - varchar2(150)
May be null? no

The name of the committee.
COMMITTEE_SCHOOL_CD

Indexed - no
Format - varchar2(12)
May be null? no

The school associated with the committee. The 2-character code that represents the school.

Example: 56 (Law School)

COMMITTEE_STATUS

Indexed - no
Format - varchar2(12)
May be null? no

The status of the committee.

 

ORDER_INDEX

Indexed - no
Format - varchar2(12)
May be null? no

The field is not in use.

FIS_COMMITTEE Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania