ASSET_SS_TRF_VW

(SQL View)
 Index Back

Asset General Information

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

SELECT A.BUSINESS_UNIT , A.ASSET_ID , B.DTTM_STAMP , B.DATE_SUBMITTED , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.PARENT_ID , A.COMPONENT_OF_ID , A.ASSET_ASSIGNED_TO , A.TAGGABLE_SW , A.TAG_NUMBER , A.DESCR , A.DESCRSHORT , A.ASSET_STATUS , A.FINANCIAL_ASSET_SW , A.REPLACE_SW , A.REPLACE_ASSET_ID , A.CONVERSION_ID , A.NEW_ASSET_SW , A.AVAIL_SW , A.AVAIL_CONTACT , A.AVAIL_PHONE , A.ACQUISITION_CD , A.ACQUISITION_DT , A.FINANCING_CD , A.REPLACEMENT_COST , A.REPLACE_COST_DT , A.LEASE_ASSET_ID , A.PROFILE_ID , A.ASSET_CLASS , A.CAP_NUM , A.CAP_SEQUENCE , A.MFG_ID , A.MANUFACTURER , A.MODEL , A.PROD_VERSION , A.SERIAL_ID , A.PRODUCTION_DT , A.PLANT , A.MANUFACTUR_CONTACT , A.BUSINESS_UNIT_JV , A.INDEX_NAME , A.INDEX_DETAIL_NAME , A.LAST_INDEX_VALUE , A.COMPOSITE_SW , A.COMPOSITE_ID , A.FERC_CD , A.GROUP_ASSET_FLAG , A.CURRENCY_CD , A.RD_PLANT_ASSET , A.RD_START_DT , A.RD_USE_NBV , A.IP_ADDRESS , A.IP_ALIAS , A.COLLATERAL_ASSET , A.CLUSTERED_ASSET , A.LIFE , A.LAST_REVIEW_DT , A.AM_AST_UD_CHAR1 , A.AM_AST_UD_CHAR2 , A.AM_AST_UD_DATE1 , A.AM_AST_UD_NUM1 , A.AM_AST_UD_NUM2 , A.LAST_CALC_RPL_COST , A.HAZARDOUS_SW , A.SS_STATUS , A.VIN , A.ASSET_RESOURCE_SW , A.ALLOW_OVERBOOK_SW , A.CHARGE_BACK_SW , A.SCHEDULABLE_SW , A.EPL_TMPL_ID , A.REPAIRABLE_FLG , A.REPAIR_STATUS , A.BUSINESS_UNIT_WO , A.SHOP_ID , A.UNOWNED_FLG , A.WO_LOCATION_FLG , A.OFFLINE_FLG , A.ASSET_CRITICALITY , A.CREW_ID , A.AVAIL_FOR_USE , A.IT_UD_CHAR1 , A.IT_UD_CHAR2 , A.IT_UD_DATE1 , A.IN_SERVICE_DT , A.REGION_CD , A.SKU , A.CRM_IPROD_ID , A.CRM_IPROD_SETID , A.CRM_IPROD_STATUS , A.CRM_DEPT_SETID , A.DESCR_LONG , A.LINEAR_ASSET_SW , A.NBR_OF_CPU , A.CAP_THRSHLD_ID , A.IN_PHY_USE , A.SYNCID , A.SYNCDTTM , A.ARO_SW , A.ARO_ID , A.SES_LAST_DTTM FROM %Table(ASSET) A , %Table(AM_SS_TRF_HDR) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID

  • Related Language Record: ASSET_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 DATE_SUBMITTED Date(10) DATE Date Submitted
    5 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
    6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: PARENT_ASSET

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

    Prompt Table: AM_COMPONENT

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

    Default Value: ASSET.DESCR

    14 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ASSET

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

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

    21 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
    22 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
    23 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

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

    Prompt Table: FINANCE_CD_TBL

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

    Prompt Table: LEASE_SRCH2

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

    Prompt Table: PROFILE_VW

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

    Prompt Table: ASSET_CLASS_TBL

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

    Prompt Table: CAP_OPEN_VW

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

    Prompt Table: CAP_DET_OPEN_VW

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

    Prompt Table: MANUFACTURER

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

    Prompt Table: MFG_MODEL

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

    Prompt Table: AM_INDEX_TBL

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

    Prompt Table: AM_INDEX_DETAIL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ASSET_COMPO1_VW

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

    Prompt Table: FERC_CD_TBL

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

    Default Value: N

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

    Default Value: CURR_CD_AM_VW.CURRENCY_CD

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

    66 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
    67 VIN Character(18) VARCHAR2(18) NOT NULL VIN
    68 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

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: D

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: EPL_LOOKUP_VW

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: 0

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

    Prompt Table: SP_BU_WM_NONVW

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

    Prompt Table: AM_WM_SHOP

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: AM_CRIT_LVL

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

    Prompt Table: AM_CREW_VW

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

    Y/N Table Edit

    83 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
    84 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
    85 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field
    86 IN_SERVICE_DT Date(10) DATE In Service Date
    87 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

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

    Prompt Table: AM_SKU_ITEM

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

    Y/N Table Edit

    95 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.
    96 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

    Prompt Table: CAP_THR_DFN1_VW

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

    Y/N Table Edit

    Default Value: N

    98 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

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

    Y/N Table Edit

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

    Default Value: %DATETIME