Penn Computing

University of Pennsylvania
Penn Computing << go backback
TERM Table . Tables and Data Elements . Housing Home . Data Warehouse Home

TERM Table - Data Element Index

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

Data element Definition
Active

Indexed - no
Format - Varchar2(40)
May be Null? N

Activedateclose

Indexed - no
Format - Date
May be Null? Y

Activedateopen

Indexed - no
Format - Date
May be Null? Y

Datemodified

Indexed - no
Format - Date
May be Null? N

Description

Indexed - no
Format - Varchar2(160)
May be Null? Y

Recordtypeenum

Indexed - no
Format - Number
May be Null? N

Termcode

Indexed - no
Format - Varchar2(160)
May be Null? Y

Termid

Indexed - yes
Format - Number
May be Null? N

Unique Identifier

Termtypeid

Indexed - no
Format - Number
May be Null? N

TERM Table . Tables and Data Elements . Housing 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