Penn Computing

University of Pennsylvania
Penn Computing << go backback

FIS_GRAD_GROUP_FACULTY Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_GRAD_GROUP_FACULTY Table - Data Element Index

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



Data element Definition
END_DATE

Indexed - no
Format - date
May be null? yes

The end date of the faculty member's membership in the graduate group.
FASDA_ID

Indexed - no
Format - number
May be null? no

A unique system identifier assigned to each unique faculty member in the FIS_FACULTY table. This number is not used in other data collections, and should not be used for reporting.
GRAD_GROUP_CHAIR

Indexed - no
Format - varchar2(1)
May be null - no

A flag used to indicate whether the faculty member is the chairperson of the graduate group.

GRAD_GROUP_FACUL_ID

Indexed - yes (primary key)
Format - number(12)
May be null? no
A unique identifier of each faculty graduate group record.

GRAD_GROUP_ID

Indexed - no
Format - number
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.

START_DATE

Indexed - no
Format - date
May be null? no

The start date of the faculty member's membership in the graduate group.

 


FIS_GRAD_GROUP_FACULTY 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