RE_ACTIVE_PPTY

(SQL View)
 Index Back

Asset Properties

Properties in the Asset Repository

SELECT P.BUSINESS_UNIT , P.ASSET_ID , %subrec(AM_PROPERTY_SBR, P) , P.IS_LEASED , A.FINANCIAL_ASSET_SW , (%Coalesce (( SELECT FINANCIAL_ASSET_SW FROM PS_RE_AST_PROF_VW WHERE A.BUSINESS_UNIT = BUSINESS_UNIT AND A.ASSET_ID = ASSET_ID), ' ')) AS FINANCIAL_ASSET_SW , (%Coalesce (( SELECT ACQUISITION_CD FROM PS_RE_AST_PROF_VW WHERE A.BUSINESS_UNIT = BUSINESS_UNIT AND A.ASSET_ID = ASSET_ID), ' ')) AS ACQUISITION_CD , (%Coalesce (( SELECT CATEGORY FROM PS_RE_AST_PROF_VW WHERE A.BUSINESS_UNIT = BUSINESS_UNIT AND A.ASSET_ID = ASSET_ID), ' ')) AS CATEGORY , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.PROFILE_ID FROM PS_ASSET_PROPERTY P , PS_ASSET A WHERE P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.ASSET_ID = A.ASSET_ID AND A.ASSET_STATUS = 'I' AND A.ASSET_TYPE = '050'

  • Related Language Record: ASSET_PROP_LG

    • # 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

    Prompt Table: ASSET

    3 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
    4 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description
    5 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name
    6 PROPERTY_CLASS Character(2) VARCHAR2(2) NOT NULL Property Class
    10=Site
    20=Building
    30=Floor
    40=Area
    50=Space
    7 PROPERTY_SUBCLASS Character(20) VARCHAR2(20) NOT NULL Property Subclass
    010=Warehouse

    Prompt Table: AM_PROP_SUBC

    8 PARENT_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Parent Property ID

    Prompt Table: %EDITTABLE

    9 SITE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Site ID

    Prompt Table: ASSET_SITE

    10 BLDG_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Building ID

    Prompt Table: ASSET_BLDG

    11 FLOOR_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Floor ID

    Prompt Table: ASSET_FLOOR

    12 AREA_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Area ID

    Prompt Table: ASSET_AREA

    13 SPACE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Space ID

    Prompt Table: ASSET_SPACE

    14 PARCEL_NUMBER Character(30) VARCHAR2(30) NOT NULL Parcel Number
    15 LOT Character(20) VARCHAR2(20) NOT NULL Lot Number
    16 BLOCK Character(20) VARCHAR2(20) NOT NULL Block Number
    17 TOTAL_AREA Number(18,3) DECIMAL(17,3) NOT NULL Total Area
    18 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)

    Prompt Table: UNITS_TBL
    Set Control Field: UNIT_OF_MEASURE

    19 CURRENT_OCCUPANCY Number(7,0) INTEGER NOT NULL Current Occupancy
    20 MAX_OCCUPANCY Number(8,0) INTEGER NOT NULL Maximum Occupancy

    Default Value: 0

    21 OCCUPANCY_STATUS Character(2) VARCHAR2(2) NOT NULL Occupancy Status
    10=Occupied
    20=Vacant

    Default Value: 10

    22 OWNERSHIP_STATUS Character(2) VARCHAR2(2) NOT NULL Ownership Status
    10=Owned
    20=Leased

    Default Value: 10

    23 LEGAL_DESCR Long Character CLOB Legal Description
    24 IS_LEASED Number(1,0) SMALLINT NOT NULL Indicator that the property is on a lease in RE Lease Admin application.
    25 CAPITALIZATION_SW Character(1) VARCHAR2(1) NOT NULL Capitalized
    0=To Capitalize Later
    1=To be Capitalized
    2=Already Capitalized
    3=Never Capitalize
    4=Already Non Capitalized
    5=Consolidated
    26 CAPITALIZATION_FLG Character(1) VARCHAR2(1) NOT NULL Work Management user preferences option to override capitalization limit
    27 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
    28 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
    29 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
    30 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
    31 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID