| Data element |
Definition |
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. |
COST_OF_REMOVAL
Indexed - no
Format - number
May be null? yes |
The cost expended to remove the asset from its location. This field is not currently used at Penn. |
COST_RETIRED
Indexed - no
Format - number
May be null? yes |
The cost of the asset at time of retirement. |
DATE_RETIRED
Indexed - yes
Format - date
May be null? no |
The date on which the asset was retired. This date is used in depreciation calculations. |
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_RETIRED
Indexed - yes
Format - char(2)
May be null? no |
The fiscal month in which the asset was retired.
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_RETIRED
Indexed - yes
Format - char(4)
May be null? no |
The fiscal year in which the asset was retired. 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) |
GAIN_LOSS_AMOUNT
Indexed - no
Format - number
May be null? yes |
The amount of gain or loss resulting from the retirement. |
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 retirement record. |
LAST_UPDATE_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the retirement record was last updated in BEN Assets. |
NBV_RETIRED
Indexed - no
Format - number
May be null? yes |
The net book value (NBV) at the time of retirement.
|
PROCEEDS_OF_SALE
Indexed - no
Format - number
May be null? yes |
The amount of proceeds resulting from the sale of the asset. This field is not currently used at Penn.
|
RETIREMENT_EFFECTIVE_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the retirement record was created. |
RETIREMENT_ID
Indexed - yes
Format - number
May be null? no |
The unique system identifier for the retirement record. |
RETIREMENT_REASON
Indexed - yes
Format - char(15)
May be null? yes |
The reason the asset was retired (e.g. lost, sold, etc.). |
RETIREMENT_TYPE
Indexed - yes
Format - varchar2(20)
May be null? no |
Indicates whether the asset was partially or fully retired. |
SOLD_TO
Indexed - no
Format - varchar2(30)
May be null? yes |
The individual or organization to which the asset was sold. |
TRADE_IN_ASSET_ID
Indexed - yes
Format - number
May be null? yes |
For retired assets that were traded in, the asset ID of the new asset. |
UNITS
Indexed - no
Format - number
May be null? yes |
The number of units retired. |
