Penn Computing

University of Pennsylvania
Penn Computing << go backback
LEASES Table   Tables and Data Elements   Assets Home    Data Warehouse Home

LEASES Table - Data Element Index

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



Data element Definition
EXTRACT_DATE

Indexed - yes
Format - date
May be null? no
The date the record was extracted from BEN Assets, the Oracle Fixed Assets system, and loaded into the Data Warehouse.
LAST_UPDATED_BY_USER

Indexed - no
Format - varchar2(100)
May be null? yes
The BEN Financials login identification (ID) for the person or batch job that last updated the lease record.
LAST_UPDATE_DATE

Indexed - no
Format - date
May be null? yes
The date on which the lease record was last updated in BEN Assets.
LEASE_DESC

Indexed - no
Format - varchar2(30)
May be null? yes
The description of the lease.
LEASE_ID

Indexed - yes
Format - number(15)
May be null? no
The unique system identifier for a lease.
LEASE_NUMBER

Indexed - yes
Format - varchar2(15)
May be null? yes
The unique identifier for the lease.
LEASE_TERM

Indexed - no
Format - number
May be null? yes
The term of the lease.
LEASE_TYPE

Indexed - no
Format - varchar2(1)
May be null? yes
The type of lease.
LESSOR_ID

Indexed - no
Format - number(15)
May be null? yes
The unique identifier for the lessor.

LEASES Table   Tables and Data Elements   Assets 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