Penn Computing

University of Pennsylvania
Penn Computing << go backback
SUB_CONTRACTOR Table   Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

SUB_CONTRACTOR Table - Data Element Index

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

 

Data element Definition
SUB_CONTRACTOR_CODE

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

The 2-character code used to identify a subcontractor for a sponsored project. Example: DP (DUPONT)

Values:

AA to ZZ

Refer to the SUB_CONTRACTOR Table for values.
SUB_CONTRACTOR_NAME

Indexed - no
Format - char (20)
May be null? yes
The 20-character name of the subcontractor associated with the SUB_CONTRACTOR_CODE. Example: DUPONT (DP)
Values:

Refer to the SUB_CONTRACTOR Table for values.


SUB_CONTRACTOR Table   Tables and Data Elements   Sponsored Projects 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