ASSET_SES_VW

(SQL View)
 Index Back

Asset PTSF Search View

Asset PTSF Search View

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.TAG_NUMBER , A.DESCR , A.DESCRSHORT , A.ASSET_CLASS , A.PARENT_ID , A.PROFILE_ID , A.MFG_ID , A.MANUFACTURER , A.SERIAL_ID , A.DESCR_LONG , A.ASSET_STATUS , A.SES_LAST_DTTM , D.SETID , E.SETID , A.BUSINESS_UNIT , %Coalesce(A.ACQUISITION_DT, %DateIn('1900-01-01')) , A.CAP_NUM , A.COMPONENT_OF_ID , A.MODEL , A.PROD_VERSION , %Substring(%Cast(A.ACQUISITION_DT, Date, Character), 6, 2) , %Substring(%Cast(A.ACQUISITION_DT, Date, Character), 6, 2) , %TextIn(' ') , %TextIn(' ') FROM %Table(ASSET) A , %Table(SET_CNTRL_REC) D , %Table(SET_CNTRL_REC) E WHERE A.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.REC_GROUP_ID = 'FS_18' AND D.RECNAME = 'MANUFACTURER' AND A.BUSINESS_UNIT = E.SETCNTRLVALUE AND E.REC_GROUP_ID = 'AM_15' AND E.RECNAME = 'AM_SUBTYPE'

  • Related Language Record: ASSET_SES_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    3 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
    4 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    5 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ASSET.DESCR

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

    Prompt Table: ASSET_CLASS_TBL

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

    Prompt Table: PARENT_ASSET

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

    Prompt Table: PROFILE_TBL

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

    Prompt Table: MANUFACTURER

    12 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
    13 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    14 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
    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 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp
    17 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    18 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
    19 DESCR120 Character(120) VARCHAR2(120) NOT NULL Description
    20 ACQUISITION_DT Date(10) DATE Acquisition Date
    21 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #
    22 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
    23 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    24 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
    25 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    26 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    27 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    28 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1