Penn Computing

University of Pennsylvania
Penn Computing << go backback

FIS_FACULTY Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_FACULTY Table - Data Element Index

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



Data element Definition
ACADEMIC_BASE

Indexed - no
Format - number
May be null - yes

This field is not in use.

BIRTHDATE

Indexed - no
Format - date
May be null? yes

The individual's date of birth, as initially entered into the Faculty Information System (FIS).

COUNTRY_OF_CITIZENSHIP

Indexed - no
Format - char(2)
May be null? yes

The 2-character IRS tax rate grouping indicating the employee's country of citizenship, as initially entered into the Faculty Information System (FIS).

CREATE_DT

Indexed - no
Format - date
May be null? no

The creation date of the record.

CREATE_ID

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

The Penn ID of the person who created the record.
DEATH_DT

Indexed - no
Format - date
May be null? no

The individual's date of death, as entered into the Faculty Information System (FIS).

DEPARTMENT_CD

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

The 4-digit number that represents the organization responsible for the employee's primary academic job appointment. Information source is FIS as input on the faculty screen. For cases where the individual has a primary academic appointment, the DEPARTMENT_CODE will reflect the proposed department for the related FIS action.
ETHNICITY_CD

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

A numeric code indicating the individual's ethnicity, as entered into FIS. Use this to join to the FIS_ETHNICITY_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the ethnicity description. This field should not be used for reporting.
FASDA_ID

Indexed - yes (primary key)
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.
GENDER_CD

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

A numeric code indicating the individual's sex, as entered into FIS. Use this to join to the FIS_GENDER_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the gender description (e.g., Male, Female).
HOSPITAL_AFF_CD

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

 
JOB_CLASS_TITLE

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

The 6-digit Payroll Job Class code for the faculty member. Refer to associated Job_Title column in DWADMIN.JOB_CLASS to find the title which currently corresponds to the Job_Class. For cases where the individual has a primary academic appointment, the JOB_CLASS_TITLE will reflect the proposed job class for the related FIS action.
JOINT_PIK_DEPARTMENT_CD

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

The Joint/PIK appointment department code in the non-administering school.
JOINT_PIK_SCHOOL_CD

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

The Joint/PIK appointment school name of the non-administering school.
LAST_UPD

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

The date/time when the record was last updated.
MARITAL_STS_CD

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

A numeric code indicating the individual's marital status, as entered into FIS. Use this to join to the FIS_MARITAL_STATUS_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the marital status description (e.g., Single, Married, Divorced, Widow or widower, Unknown).
NAME_FIRST

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

The first name of the individual, as initially entered into FIS.
NAME_LAST

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

The last name of the individual, as initially entered into FIS.
NAME_MIDDLE

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

The middle name of the individual, as initially entered into FIS.
NAME_PREFIX

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

The name prefix (e.g., Mr., Mrs., Ms., Dr., Dean) of the individual, as initially entered into FIS.
NAME_SUFFIX

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

The name suffix (e.g., Jr., Sr., III) of the individual, as initially entered into FIS.
NON_GUARANTEED_SUPPLEMENTAL_CD

Indexed - no
Format - number
May be null? yes

This field is not in use.
ON_GOING_ADDL_COMPENSATION

Indexed - no
Format - number
May be null? yes

This field is not in use.
PAA_ID

Indexed - no
Format - number(22)
May be null? yes

The Action_ID of the action identifying the individual's Primary Academic Appointment (PAA). The logic used to determine an employee's FIS primary academic appointment is documented in the cautions for this table, at http://www.upenn.edu/computing/da/dw/faculty/fis_faculty.t.html.
PAA_MAN_FL

Indexed - no
Format - number(22)
May be null? yes

A Yes/No field to indicate if this the Primary Academic Appointment has been manually designated.
PENN_ID

Indexed - no
Format - number(15)
May be null? yes

The 8-digit identification number assigned to the individual by the Penn Community system.
SCHOOL_CD

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

The two character code that represents the specific school or center to which the Department_Code belongs. Information source is FIS as input on the faculty screen. For cases where the individual has a primary academic appointment, the SCHOOL_CODE will reflect the proposed school for the related FIS action.

Example: 40 (School of Medicine)

TENURE_PROBATION_DATE

Indexed - no
Format - date
May be null? yes

The start date of the tenure probationary period
TENURE_STATUS

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

A numeric code indicating the tenure status, as determined by PSC. Use this to join to the FIS_TENURE_STATUS_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the status description (e.g., Granted, Restricted, Under final consideration, Denied).
TENURE_STATUS_DATE

Indexed - no
Format - date
May be null? yes

For faculty members, the date when the Tenure_Status is expected or was attained. For Clinician-Educators, this information is used for tenure tracking.
TIME_LIMITED_ADDL_COMPENSATION

Indexed - no
Format - number
May be null? yes

This field is not in use.
TIME_LIMITED_ADDL_COMP_END

Indexed - no
Format - date
May be null? yes

This field is not in use.
TIME_LIMITED_ADDL_COMP_START

Indexed - no
Format - date
May be null? yes

This field is not in use.
UPD_DT

Indexed - no
Format - date
May be null? no

The date the record was last updated.
UPD_ID

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

The Penn ID of the person who last updated the record.
VISA

Indexed - no
Format - char(2)
May be null? yes

The 2-character code that indicates the type of visa held by an employee who is not a U.S. citizen.

Values:

F1     Student

F2     Spouse or child of student

H1     Temporary worker of distinguished merit 

       and ability

H2     Temporary worker performing services 

       unavailable in this country

IM     Immigrant

J1     Exchange visitor

J2     Spouse or child of exchange visitor

O1     Individual of extraordinary ability in the 

       sciences, education, business, athletics or

       the arts

O2     Accompanying workers

Q1     International cultural exchange

SP     Substantial presence

TN     Treaty of NAFTA

      

 

VISA_EXPIRATION_DATE

Indexed - no
Format - date
May be null? yes

For employees who are not U.S. citizens, the date of the first of the month when the visa expires, as originally entered into the Faculty Information System (FIS).

FIS_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