ASSET_ALL_VW_OL

(SQL View)
 Index Back

Asset General Information


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.PARENT_ID , 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.PROFILE_ID , A.ASSET_CLASS , A.CAP_NUM , 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.COMPOSITE_SW , A.COMPOSITE_ID , A.FERC_CD , B.CUSTODIAN , B.EMPLID , %subrec(CF12_AN_SBR, B) , B.PROJECT_ID , B.DEPTID , B.OFFSITE_SW , B.AUTH_STATUS , B.AUTHORIZATION_NAME , B.AUTHORIZATION_DT , C.LOCATION , C.AUTH_STATUS , C.AUTHORIZATION_NAME , C.AUTHORIZATION_DT , C.DOCUMENT_ID , A.REPLACEMENT_COST , A.DESCR_LONG FROM PS_ASSET A , PS_ASSET_CUSTODIAN B , PS_ASSET_LOCATION C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND A.ASSET_ID = C.ASSET_ID AND B.EFFDT = ( SELECT MAX(Z.EFFDT) FROM PS_ASSET_CUSTODIAN Z WHERE Z.BUSINESS_UNIT = A.BUSINESS_UNIT AND Z.ASSET_ID = A.ASSET_ID AND Z.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_ASSET_LOCATION X WHERE X.BUSINESS_UNIT = A.BUSINESS_UNIT AND X.ASSET_ID = A.ASSET_ID AND X.EFFDT <= %CurrentDateIn)

  • 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

    Prompt Table: SP_BU_AM_NONVW

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

    Default Value: NEXT

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

    Prompt Table: PARENT_ASSET

    4 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset
    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_ALL_VW.DESCR

    8 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

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ASSET

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

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

    15 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
    16 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
    17 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

    18 ACQUISITION_DT Date(10) DATE Acquisition Date
    19 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code
    20 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_TBL

    21 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class
    22 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

    Prompt Table: CAP

    23 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
    24 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    25 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
    26 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    27 PRODUCTION_DT Date(10) DATE Production Date
    28 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant
    29 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact
    30 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
    31 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name
    32 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name
    33 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

    Y/N Table Edit

    34 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID
    35 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code
    36 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
    37 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    38 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
    39 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
    40 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
    41 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
    42 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
    43 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
    44 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
    45 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
    46 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
    47 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
    48 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
    49 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
    50 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    51 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    52 OFFSITE_SW Character(1) VARCHAR2(1) NOT NULL This Asset is Offsite

    Y/N Table Edit

    53 CUST_AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Custodian Authorization Status
    54 CUST_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Custodian Authorization Name
    55 CUST_AUTH_DT Date(10) DATE Custodian Authorization Date
    56 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    57 LOC_AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Location Authorization Status
    58 LOC_AUTH_NAME Character(30) VARCHAR2(30) NOT NULL Location Authorization Name
    59 LOC_AUTH_DT Date(10) DATE Location Authorization Date
    60 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
    61 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
    62 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description