ASSET_STAGE

(SQL Table)
 Index Back

Asset General Information

If you add fields to ASSET, they must also be added to ASSET_JV_VW and AMIF_ASST_TMP.

  • Related Language Record: ASSET_STG_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Default Value: NEXT

    3 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    5 AM_TRANS_SOURCE Character(3) VARCHAR2(3) NOT NULL Differentiate data source for transaction staging tables.
    AWF=AM Workflow
    6 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    8 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

    Prompt Table: PARENT_ASSET

    9 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset

    Prompt Table: AM_COMPONENT

    10 ASSET_ASSIGNED_TO Character(12) VARCHAR2(12) NOT NULL Asset Assigned To
    11 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset
    12 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ASSET.DESCR

    15 ASSET_STATUS Character(1) VARCHAR2(1) NOT NULL Asset Status
    A=Received (Not in Service)
    B=Budgeted
    C=Commitment
    D=Disposed
    I=In Service
    M=Suspended
    R=Requisitioned
    T=Transferred
    W=Work In Progress

    Default Value: I

    16 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
    N=Non Cap
    Y=Capitalize

    Y/N Table Edit

    Default Value: N

    17 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset

    Y/N Table Edit

    Default Value: N

    18 REPLACE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Replaced Asset ID

    Prompt Table: ASSET

    19 CONVERSION_ID Character(15) VARCHAR2(15) NOT NULL Old Asset ID
    20 NEW_ASSET_SW Character(1) VARCHAR2(1) NOT NULL New Asset
    N=Used Asset
    Y=New Asset

    Default Value: Y

    21 AVAIL_SW Character(1) VARCHAR2(1) NOT NULL Asset is Available

    Y/N Table Edit

    Default Value: N

    22 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
    23 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
    24 ACQUISITION_CD Character(1) VARCHAR2(1) NOT NULL Acquisition Code
    C=Constructed
    D=Donated
    I=Trade In
    K=Like Exchange
    L=Leased
    P=Purchased
    T=Transferred

    Default Value: P

    25 ACQUISITION_DT Date(10) DATE Acquisition Date
    26 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code

    Prompt Table: FINANCE_CD_TBL

    27 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
    28 REPLACE_COST_DT Date(10) DATE Last Update
    29 LEASE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Lease Asset ID

    Prompt Table: LEASE_SRCH2

    30 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_TBL

    31 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class

    Prompt Table: ASSET_CLASS_TBL

    32 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

    Prompt Table: CAP_OPEN_VW

    33 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

    Prompt Table: CAP_DET_OPEN_VW

    34 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    35 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
    36 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL

    37 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
    38 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    39 PRODUCTION_DT Date(10) DATE Production Date
    40 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant
    41 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact
    42 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
    43 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name

    Prompt Table: AM_INDEX_TBL

    44 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name

    Prompt Table: AM_INDEX_DETAIL

    45 LAST_INDEX_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Last Index Value
    46 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

    Y/N Table Edit

    Default Value: N

    47 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID

    Prompt Table: ASSET_COMPO1_VW

    48 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

    Prompt Table: FERC_CD_TBL

    49 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
    G=Group Asset
    M=Group Member
    N=None

    Default Value: N

    50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CURR_CD_AM_VW.CURRENCY_CD

    51 RD_PLANT_ASSET Character(1) VARCHAR2(1) NOT NULL R and D Plant Asset

    Y/N Table Edit

    52 RD_START_DT Date(10) DATE R and D Start Date
    53 RD_USE_NBV Character(1) VARCHAR2(1) NOT NULL Use NBV for R and D

    Y/N Table Edit

    54 IP_ADDRESS Character(39) VARCHAR2(39) NOT NULL Internet Protocol Address
    55 IP_ALIAS Character(35) VARCHAR2(35) NOT NULL Internet Address Alias/UNC
    56 COLLATERAL_ASSET Character(2) VARCHAR2(2) NOT NULL Collateral Asset
    01=Mortgage
    02=Fixed Mortgage
    03=Factory Foundation Mortgage
    04=Others
    57 CLUSTERED_ASSET Character(1) VARCHAR2(1) NOT NULL Clustered Asset

    Y/N Table Edit

    58 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
    59 LAST_REVIEW_DT Date(10) DATE Used for Australian VAT - last date of mandatory review
    60 AM_AST_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1
    61 AM_AST_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2
    62 AM_AST_UD_DATE1 Date(10) DATE User Defined Date Field1
    63 AM_AST_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1
    64 AM_AST_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2
    65 LAST_CALC_RPL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Last calculated replacement cost
    66 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset

    Y/N Table Edit

    Default Value: N

    67 SS_STATUS Character(1) VARCHAR2(1) NOT NULL Strategic Sourcing Status
    A=Sent to Auction
    N=Not allowed to be Auctioned
    S=Sold in Auction
    Y=Allowed to be Auctioned
    68 VIN Character(18) VARCHAR2(18) NOT NULL VIN
    69 ASSET_RESOURCE_SW Character(1) VARCHAR2(1) NOT NULL Field to indicate that an Asset is used as a tool or resource

    Y/N Table Edit

    70 ALLOW_OVERBOOK_SW Character(1) VARCHAR2(1) NOT NULL Allow Overbooking

    Y/N Table Edit

    Default Value: N

    71 CHARGE_BACK_SW Character(1) VARCHAR2(1) NOT NULL Charge Back Switch
    D=Default
    N=No
    Y=Yes

    Default Value: D

    72 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

    Y/N Table Edit

    Default Value: N

    73 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template

    Prompt Table: EPL_LOOKUP_VW

    74 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag

    Y/N Table Edit

    Default Value: N

    75 REPAIR_STATUS Character(1) VARCHAR2(1) NOT NULL Repair Status
    0=None
    1=Needs Repair
    2=In Repair

    Default Value: 0

    76 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

    Prompt Table: SP_BU_WM_NONVW

    77 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

    Prompt Table: AM_WM_SHOP

    78 UNOWNED_FLG Character(1) VARCHAR2(1) NOT NULL Non-Owned Asset

    Y/N Table Edit

    79 WO_LOCATION_FLG Character(1) VARCHAR2(1) NOT NULL Work Order Location
    1=Shop Location
    2=Asset Location
    3=Other Location
    80 OFFLINE_FLG Character(1) VARCHAR2(1) NOT NULL Asset Offline

    Y/N Table Edit

    Default Value: N

    81 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality

    Prompt Table: AM_CRIT_LVL

    82 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

    Prompt Table: AM_CREW_VW

    83 AVAIL_FOR_USE Character(1) VARCHAR2(1) NOT NULL Available For Use

    Y/N Table Edit

    84 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
    85 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
    86 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field
    87 IN_SERVICE_DT Date(10) DATE In Service Date
    88 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: REGION_CD_RP

    89 SKU Character(50) VARCHAR2(50) NOT NULL Stock Keeping Unit

    Prompt Table: AM_SKU_ITEM

    90 CRM_IPROD_ID Character(20) VARCHAR2(20) NOT NULL For CRM integration of IT Assets
    91 CRM_IPROD_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
    92 CRM_IPROD_STATUS Character(3) VARCHAR2(3) NOT NULL For CRM integration of IT Assets
    INS=Install
    UNI=Uninstall
    93 CRM_DEPT_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
    94 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
    95 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset

    Y/N Table Edit

    96 NBR_OF_CPU Number(3,0) SMALLINT NOT NULL Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.
    97 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

    Prompt Table: CAP_THR_DFN1_VW

    98 IN_PHY_USE Character(1) VARCHAR2(1) NOT NULL Describes if entity is in physical use.

    Y/N Table Edit

    Default Value: N

    99 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

    Default Value: 0

    100 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    101 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
    N=No
    Y=Yes

    Y/N Table Edit

    102 ARO_ID Character(12) VARCHAR2(12) NOT NULL ARO Identification
    103 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

    Default Value: %DATETIME