Penn Computing

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

ASSET_CATEGORIES Table - Data Element Index

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



Data element Definition
ASSET_CLEARING_OBJECT_CODE

Indexed - no
Format - varchar2(25)
May be null? yes
The object code used in the asset clearing account for the category.
ASSET_COST_OBJECT_CODE

Indexed - no
Format - varchar2(25)
May be null? yes
The object code used in the asset cost account for the category.

 

CATEGORY_DESC

Indexed - no
Format - varchar2(40)
May be null? yes
The description of the category.
CATEGORY_ID

Indexed - yes
Format - number
May be null? no
The unique system identifier for an asset category.
CATEGORY_MAJOR

Indexed - yes
Format - varchar2(30)
May be null? yes
The major segment of the category code.
CATEGORY_MINOR

Indexed - yes
Format - varchar2(30)
May be null? yes
The minor segment of the category code.
CATEGORY_NUMBER

Indexed - no
Format - varchar2(150)
May be null? yes
The number of the category, as assigned by the Property Management Group.
CATEGORY_TYPE

Indexed - no
Format - varchar2(30)
May be null? yes
The type of category.
CIP_CLEARING_OBJECT_CODE

Indexed - no
Format - varchar2(25)
May be null? yes
The object code used in the CIP clearing account for the category.
CIP_COST_OBJECT_CODE

Indexed - no
Format - varchar2(25)
May be null? yes
The object code used in the CIP cost account for the category.

 

DEFAULT_LIFE_IN_MONTHS

Indexed - no
Format - number(4)
May be null? yes
The default life if months for the asset category.
DEPRECIATE_FLAG

Indexed - no
Format - varchar2(3)
May be null? yes
Indicates whether the asset category default is set to depreciate.
Values:
YES
NO

ASSET_CATEGORIES 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