| Data element |
Definition |
ASSET_CATEGORY_ID_COMPARE
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the asset category as stored in BEN Assets at the time the inventory file was returned. Refer to ASSET_CATEGORIES for asset code description. |
|
ASSET_CATEGORY_ID_INBOUND
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the asset category, as returned in the inventory file. Refer to ASSET_CATEGORIES for asset code description. |
ASSET_CATEGORY_ID_OUTBOUND
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the asset category, as stored in BEN Assets at the time the asset record was sent out for inventory. Refer to ASSET_CATEGORIES for asset code description. |
ASSET_DESC_COMPARE
Indexed - no
Format - varchar2(80)
May be null? yes |
The description of the asset as stored in BEN Assets at the time the inventory file was returned. |
ASSET_DESC_INBOUND
Indexed - no
Format - varchar2(80)
May be null? yes |
The description of the asset, as returned in the inventory file. |
ASSET_DESC_OUTBOUND
Indexed - no
Format - varchar2(80)
May be null? yes |
The description of the asset as stored in BEN Assets at the time the asset record was sent out for inventory. |
ASSET_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? no |
The unique identifier for an asset. |
ASSET_RESPONSIBLE_ORG_COMPARE
Indexed - yes
Format - char(4)
May be null? yes |
The organization responsible for managing the asset, as stored in BEN Assets at the time the inventory file was returned. 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_RESPONSIBLE_ORG_INBOUND
Indexed - yes
Format - char(4)
May be null? yes |
The organization responsible for managing the asset, as returned in the inventory file. 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_RESPONSIBLE_ORG_OUTBOUND
Indexed - yes
Format - char(4)
May be null? yes |
The organization responsible for managing the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. Note that the Asset_Responsible_Org is distinct and possibly different from the Responsible_Org associated with the fund used to purchase the asset. |
CUSTODIAN_NAME_COMPARE
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the asset’s custodian, as stored in the BEN Financials system at the time the inventory file was returned. |
CUSTODIAN_NAME_INBOUND
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the asset’s custodian, based on the Custodian Penn ID returned in the inventory file. |
CUSTODIAN_NAME_OUTBOUND
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the asset’s custodian, as stored in the BEN Financials system at the time the asset record was sent out for inventory. |
CUSTODIAN_PENN_ID_COMPARE
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the asset’s custodian, as stored in BEN Assets at the time the inventory file was returned. |
CUSTODIAN_PENN_ID_INBOUND
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the asset’s custodian, as returned in the inventory file. |
CUSTODIAN_PENN_ID_OUTBOUND
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the asset’s custodian, as stored in BEN Assets at the time the asset record was sent out for inventory. |
CUSTODIAN_PHONE_COMPARE
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the asset’s custodian, as stored in BEN Assets at the time the inventory file was returned. |
CUSTODIAN_PHONE_INBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the asset’s custodian, as returned in the inventory file. |
CUSTODIAN_PHONE_OUTBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the asset’s custodian, as stored in BEN Assets at the time the asset record was sent out for inventory. |
EXCEPTION
Indexed - no
Format - varchar2(50)
May be null? yes |
Indicates whether and why the record was an exception returned from the inventory process.
Valid values:
New Asset: Asset was returned by
Vendor but not initially sent
Valid Asset: Asset was sent and
returned by Vendor
Invalid Asset: Asset was returned by
vendor but asset number is invalid
Not Returned: Asset was sent to
vendor but never returned |
EXCLUDE_FLAG
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates whether the record was excluded from the bulk update of inventoried items to BEN Assets. |
EXTRACT_NAME
Indexed - yes
Format - varchar2(15)
May be null? no |
The type of assets sent out in the extract file (e.g., new additions, inventory). |
INVENTORY_DATE
Indexed - yes
Format - date
May be null? no |
The date as of which the asset was inventoried, for the Inventory Name. |
INVENTORY_NAME
Indexed - yes
Format - varchar2(7)
May be null? no |
The name of the inventory cycle, in the format QTRX-YY. The quarter represents the quarter of the fiscal year; e.g., the QTR3-08 occurs in April 2008, representing the inventory for the third quarter of fiscal year 2008. |
LAST_EXTRACT_DATE
Indexed - no
Format - date
May be null? no |
The date the record was extracted from the Oracle Fixed Assets system and loaded into the Data Warehouse. |
LOCATED_DURING_INVENTORY
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates the status of the asset as a result of inventory. |
LOCATION_ID_COMPARE
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the location of the asset, as stored in BEN Assets at the time the inventory file was returned. |
|
LOCATION_ID_INBOUND
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the location of the asset, as returned in the inventory file. |
LOCATION_ID_OUTBOUND
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the location of the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. |
MANUFACTURER_NAME_COMPARE
Indexed - no
Format - varchar2(30)
May be null? yes |
The name of the manufacturer of the asset, as stored in BEN Assets at the time the inventory file was returned. This is not necessarily the same as the name of the asset supplier. |
MANUFACTURER_NAME_INBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
The name of the manufacturer of the asset, as returned in the inventory file. This is not necessarily the same as the name of the asset supplier. |
MANUFACTURER_NAME_OUTBOUND
Indexed - no
Format - varchar2(40)
May be null? yes |
The name of the manufacturer of the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. |
MODEL_NUMBER_COMPARE
Indexed - no
Format - varchar2(40)
May be null? yes |
The model number of the asset, as designated by the manufacturer, and as stored in BEN Assets at the time the inventory file was returned. |
MODEL_NUMBER_INBOUND
Indexed - no
Format - varchar2(40)
May be null? yes |
The model number of the asset, as designated by the manufacturer, and as returned in the inventory file. |
MODEL_NUMBER_OUTBOUND
Indexed - no
Format - varchar2(40)
May be null? yes |
The model number of the asset, as designated by the manufacturer, and as stored in BEN Assets at the time the asset record was sent out for inventory. |
SERIAL_NUMBER_COMPARE
Indexed - no
Format - varchar2(35)
May be null? yes |
The serial number of the asset, as designated by the manufacturer, and as stored in BEN Assets at the time the inventory file was returned. |
SERIAL_NUMBER_INBOUND
Indexed - no
Format - varchar2(35)
May be null? yes |
The serial number of the asset, as designated by the manufacturer, and as returned in the inventory file. |
SERIAL_NUMBER_OUTBOUND
Indexed - no
Format - varchar2(35)
May be null? yes |
The serial number of the asset, as designated by the manufacturer, and as stored in BEN Assets at the time the asset record was sent out for inventory. |
TAGGING_CONTACT_NAME_COMPARE
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the tagging contact for the asset, as stored in the BEN Financials system at the time the inventory file was returned. |
TAGGING_CONTACT_NAME_INBOUND
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the tagging contact for the asset, based on the Custodian Penn ID returned in the inventory file. |
TAGGING_CONTACT_NAME_OUTBOUND
Indexed - yes
Format - varchar2(240)
May be null? yes |
The full name of the tagging contact for the asset, as stored in the BEN Financials system at the time the asset record was sent out for inventory. |
TAGGING_CONTACT_PENN_ID_COMPARE
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the tagging contact for the asset, as stored in BEN Assets at the time the inventory file was returned. |
TAGGING_CONTACT_PENN_ID_INBOUND
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the tagging contact for the asset, as returned in the inventory file. |
TAGGING_CONTACT_PENN_ID_OUTBOUND
Indexed - yes
Format - char(8)
May be null? yes |
The Penn ID of the tagging contact for the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. |
TAGGING_CONTACT_PHONE_COMPARE
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the tagging contact for the asset, as stored in BEN Assets at the time the inventory file was returned. |
TAGGING_CONTACT_PHONE_INBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the tagging contact for the asset, as returned in the inventory file. |
TAGGING_CONTACT_PHONE_OUTBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
The phone number of the tagging contact for the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. |
TAGGING_DATE_COMPARE
Indexed - no
Format - date
May be null? yes |
The date when the tag was physically applied to the asset, as stored in BEN Assets at the time the inventory file was returned. |
TAGGING_DATE_INBOUND
Indexed - no
Format - date
May be null? yes |
The date when the tag was physically applied to the asset, as returned in the inventory file. |
TAGGING_DATE_OUTBOUND
Indexed - no
Format - date
May be null? yes |
The date when the tag was physically applied to the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. |
TAGGING_STATUS_COMPARE
Indexed - no
Format - varchar2(30)
May be null? yes |
Indicates whether the asset is able to be tagged, as stored in the BEN Financials system at the time the inventory file was returned. |
TAGGING_STATUS_INBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
Indicates whether the asset is able to be tagged, as returned in the inventory file. |
TAGGING_STATUS_OUTBOUND
Indexed - no
Format - varchar2(30)
May be null? yes |
Indicates whether the asset is able to be tagged, as stored in BEN Assets at the time the asset record was sent out for inventory. |
TAG_NUMBER_COMPARE
Indexed - no
Format - varchar2(15)
May be null? yes |
The number on the tag physically applied to the asset, as stored in BEN Assets at the time the inventory file was returned. |
TAG_NUMBER_INBOUND
Indexed - no
Format - varchar2(15)
May be null? yes |
The number on the tag physically applied to the asset, as returned in the inventory file. |
TAG_NUMBER_OUTBOUND
Indexed - no
Format - varchar2(15)
May be null? yes |
The number on the tag physically applied to the asset, as stored in BEN Assets at the time the asset record was sent out for inventory. |
