Penn Computing

University of Pennsylvania
Penn Computing << go backback

FIS_GRAD_GROUP_DEPTS Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_GRAD_GROUP_DEPTS Table - Data Element Index

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



Data element Definition
DEPT_CD

Indexed - no
Format - char(12)
May be null - no

The 4-digit number that represents the organization with which the graduate group is associated.

FOUNDATIONAL

Indexed - no
Format - varchar2(1)
May be null - yes
A Yes/No flag indicating whether the graduate group is foundational.

GRAD_GROUP_ID

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

The unique identifier of the graduate group. 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.

ID

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

A unqiue identifier for the row in the GRAD_GROUP_DEPTS table. 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.
SCHOOL_CD

Indexed - no
Format - char(6)
May be null? no

The two character code that represents the specific school or center with which the graduate group is associated.

 


FIS_GRAD_GROUP_DEPTS 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