Penn Computing

University of Pennsylvania
Penn Computing << go backback

ACTIVITY_TO_990 Table
   Tables and Data Elements   Global Activities Registry Home   Data Warehouse Home

ACTIVITY_TO_990 Table - Data Element Index

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



Data element Definition

ID

Indexed - yes
Format - Integer
May be null - no

Unique identifier for the translation from Activity ID to 990 category and sub-category.

 

ACTIVITY_ID

Indexed - no
Format - Integer
May be null - yes

ID column from the ACTIVITY_TYPE or ACTIVITY_SUB_TYPE Table.

CATEGORY

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

990 Category for the primary or secondary purpose of a trip.

SUB_CATEGORY

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

990 Sub-Category for the primary or secondary purpose of a trip.


ACTIVITY_TO_990 Table
   Tables and Data Elements   Global Activities Registry 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