WM_SUBTY_EFF_VW

(SQL View)
 Index Back

WM Asset Subtype Effective Vw


SELECT A.SETID , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.DESCRSHORT , A.DESCR , B.ASSET_RESOURCE_SW , B.LINEAR_ASSET_SW , B.UNIT_OF_MEASURE , B.COST_RATE , B.BILL_RATE , B.CURRENCY_CD FROM PS_AM_SUBTYPE A , PS_AM_SUBTYPE_LN B WHERE B.SETID = A.SETID AND B.ASSET_TYPE = A.ASSET_TYPE AND B.ASSET_SUBTYPE = A.ASSET_SUBTYPE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_AM_SUBTYPE_LN I WHERE I.SETID = B.SETID AND I.ASSET_TYPE = B.ASSET_TYPE AND I.ASSET_SUBTYPE = B.ASSET_SUBTYPE AND I.EFFDT <= %CurrentDateIn)

  • Related Language Record: AM_SUBTYPE_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 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
    3 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 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

    Default Value: N

    7 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset

    Y/N Table Edit

    Default Value: N

    8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    9 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    10 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_CURR_VW.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL