| Data element |
Definition |
ACCUMULATED_DEPRECIATION
Indexed - no
Format - number
May be null? yes |
The depreciation amount for the asset as of end of last month-end.
|
|
ACQUISITION_COST
Indexed - no
Format - number
May be null? no |
The total acquisition cost of the asset, reflecting original cost (whether for for items acquired through the accounts payable process or those added manually), plus any subsequent changes made within the BEN Assets system. |
ASSET_CATEGORY_ID
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for an asset category. Refer to ASSET_CATEGORIES for asset code description. |
ASSET_CREATION_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the asset record was created in BEN Assets. |
ASSET_CREATION_FISCAL_MONTH
Indexed - yes
Format - char(2)
May be null? yes |
The fiscal month in which the asset was created.
Examples: 01 (July); 11 (May). See also FISCAL_YEAR
Values:
01 July
02 August
03 September
04 October
05 November
06 December
07 January
08 February
09 March
10 April
11 May
12 June
|
ASSET_CREATION_FY
Indexed - yes
Format - char(4)
May be null? yes |
The fiscal year in which the asset was created. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.
Example: 2007 (fiscal year that began July 1, 2006, and ended June 30, 2007) |
ASSET_DESC
Indexed - no
Format - varchar2(80)
May be null? yes |
The description of the asset. |
ASSET_ID
Indexed - yes
Format - number(15)
May be null? no |
The unique system identifier for an asset. |
ASSET_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? no |
The unique identifier for an asset. |
ASSET_RESPONSIBLE_CTR
Indexed - yes
Format - char(2)
May be null? yes |
The center to which the organization responsible for managing the asset belongs. |
ASSET_RESPONSIBLE_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The organization responsible for managing the asset. Note that the Asset_Responsible_Org is distinct and possibly different from the Responsible_Org associated with the fund used to purchase the asset. |
ASSET_TYPE
Indexed - yes
Format - varchar2(11)
May be null? yes |
The type of asset (e.g. Capitalized, etc). |
CAPITAL_PROGAM_CODE
Indexed - no
Format - varchar2(30)
May be null? yes |
The capital program code associated with the asset. |
COMPONENT_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the asset is a component of another asset. |
CURRENT_UNITS
Indexed - no
Format - number
May be null? yes |
The number of units currently associated with the asset. |
CUSTODIAN_ACTIVE_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the custodian is considered active in BEN Financials and may be associated with assets. |
CUSTODIAN_CONSULTANT_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the custodian is flagged as a consultant in BEN Financials. |
CUSTODIAN_NAME
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the asset's custodian, as stored in the BEN Financials system. |
CUSTODIAN_PENN_ID
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the asset's custodian. |
CUSTODIAN_PHONE
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the asset's custodian, as entered into Internet Procurement at the time of asset purchase, or updated in the BEN Assets system. |
DATE_PLACED_IN_SERVICE
Indexed - yes
Format - date
May be null? yes |
The date on which the asset was placed in service. |
DEPRECIATE_FLAG
Indexed - no
Format - varchar2(3)
May be null? yes |
Indicates whether the asset is set to depreciate.
The value of this flag will overwrite the default for the asset category.
Values:
YES
NO |
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. |
FISCAL_MONTH_PLACED_IN_SERVICE
Indexed - yes
Format - char(2)
May be null? yes |
The fiscal month in which the asset was placed in service.
Examples: 01 (July); 11 (May). See also FISCAL_YEAR
Values:
01 July
02 August
03 September
04 October
05 November
06 December
07 January
08 February
09 March
10 April
11 May
12 June
|
FY_PLACED_IN_SERVICE
Indexed - yes
Format - char(4)
May be null? yes |
The fiscal year in which the asset was placed in service. Penn's fiscal year begins July 1 of one calendar year and ends June 30 of the next calendar year.
Example: 2007 (fiscal year that began July 1, 2006, and ended June 30, 2007)
|
GOVT_RETAINS_TITLE
Indexed - no
Format - char(1)
May be null? yes |
For assets purchased with sponsored program funds, indicates whether the government retains the title to the asset (Y), or whether the University holds the title (N). |
IN_PHYSICAL_INVENTORY
Indexed - no
Format - varchar2(3)
May be null? yes |
Indicates whether the asset is included in physical inventory processes. |
IN_USE_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the asset is currently in use. |
LAST_INVENTORY_DATE
Indexed - no
Format - date
May be null? yes |
The date as of which the asset was last inventoried. |
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 asset record. |
LAST_UPDATE_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the asset was last updated in BEN Assets. |
LEASE_ID
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the lease associated with the asset. |
LEGACY_ASSET_NUMBER
Indexed - yes
Format - varchar2(30)
May be null? yes |
For assets created prior to the implementation of BEN Assets, the legacy Property Management System number for the asset. |
LIFE_IN_MONTHS
Indexed - no
Format - number(4)
May be null? yes |
The useful life of the asset, measured in months. |
LOCATED DURING_INVENTORY
Indexed - no
Format - varchar2(150)
May be null? yes |
Indicates the status of the asset as a result of inventory ('Y' indicates the asset was located at inventory, 'N' indicates it was not.). |
MANUFACTURER_NAME
Indexed - no
Format - varchar2(30)
May be null? yes |
The name of the manufacturer of the asset. This is not necessarily the same as the name of the asset supplier. |
MODEL_NUMBER
Indexed - no
Format - varchar2(40)
May be null? yes |
The model number of the asset, as designated by the manufacturer. |
NET_BOOK_VALUE
Indexed - no
Format - number
May be null? yes |
The net book value of the asset. Net book value is calculated as asset cost less depreciation reserve. |
NEW_OR_USED
Indexed - no
Format - varchar2(4)
May be null? yes |
Indicates whether the asset was new or previously used when acquired. |
OWNED_OR_LEASED
Indexed - no
Format - varchar2(15)
May be null? yes |
Indicates whether the asset is owned or leased by the University. |
PARENT_ASSET_ID
Indexed - yes
Format - number(15)
May be null? yes |
For assets that are subcomponents of other assets, the unique ID of the parent asset. |
PRIMARY_ASSET_NUMBER
Indexed - no
Format - varchar2(30)
May be null? yes |
For items related to existing assets (not subcomponents), the unique identifier of the associated asset. |
REMAINING_LIFE
Indexed - no
Format - number(4)
May be null? yes |
The remaining useful life of the asset, calculated as the Life_In_Months minus the difference between the depreciation start date and the period close date. |
RESEARCH_AMOUNT
Indexed - no
Format - number
May be null? yes |
For assets funded by sponsored programs, the total amount of the asset cost funded by grants. Contributions for all research funds are summed and stored in this amount. |
RESEARCH_DEPRN
Indexed - no
Format - number
May be null? yes |
That portion of the YTD Depreciation Expense on an asset that is related to the portion of the acquisition cost of the asset funded by Research dollars. |
RETIRED_FLAG
Indexed - yes
Format - char(1)
May be null? no |
Indicates whether the asset has been retired, based on retirement type in the RETIREMENTS table. |
SERIAL_NUMBER
Indexed - no
Format - varchar2(35)
May be null? yes |
The serial number of the asset, as designated by the manufacturer. |
TAGGABLE_STATUS
Indexed - yes
Format - varchar2(30)
May be null? yes |
Indicates whether the asset is able to be tagged. Newly created assets default to a status of READY FOR TAGGING. |
TAGGING_CONTACT_ACTIVE_FLAG
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the tagging contact is considered active in BEN Financials and may be associated with assets. |
TAGGING_CONTACT_NAME
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the asset's tagging contact, as stored in the BEN Financials system. |
TAGGING_CONTACT_PENN_ID
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the asset's tagging contact. |
TAGGING_CONTACT_PHONE
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the asset's tagging contact, as entered into Internet Procurement at the time of asset purchase, or updated in the BEN Assets system. |
TAGGING_DATE
Indexed - no
Format - date
May be null? yes |
The date when the tag was physically applied to the asset, or the asset was determined to be untaggable. |
TAG_NUMBER
Indexed - no
Format - varchar2(15)
May be null? yes |
The number on the tag physically applied to the asset. |
UNIV_DEPRN
Indexed - no
Format - number
May be null? yes |
That portion of the YTD Depreciation Expense on an asset that is related to the portion of the acquisition cost of the asset funded by University dollars, that is all funding other than that provided by Research dollars. |
YTD_DEPRECIATION
Indexed - no
Format - number
May be null? yes |
Current Fiscal YTD depreciation as of the end of last month-end. |
