PROFILE_PCAM_VW

(SQL View)
 Index Back

PS/PC PS/AM Asset Profile View


SELECT A.SETID ,A.PROFILE_ID ,A.DESCR ,A.DEFAULT_DESCR ,A.FINANCIAL_ASSET_SW ,A.TAGGABLE_SW ,A.ACQUISITION_CD ,A.ASSET_CLASS ,A.RD_PLANT_ASSET ,A.RD_START_DT ,A.RD_USE_NBV ,A.INDEX_NAME ,A.INDEX_DETAIL_NAME ,A.ASSET_RESOURCE_SW ,A.ASSET_SUBTYPE ,A.ASSET_TYPE ,A.CAP_THRSHLD_ID ,A.ARO_SW ,A.PROFILE_ACTIVE_SW FROM PS_PROFILE_TBL A WHERE A.PROFILE_ACTIVE_SW <> 'N'

  • Related Language Record: PROFILE_LANG

    • # 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 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: SP_AMPRF_NONVW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DEFAULT_DESCR Character(30) VARCHAR2(30) NOT NULL Default Asset Description
    5 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
    N=Non Cap
    Y=Capitalize

    Y/N Table Edit

    Default Value: Y

    6 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset

    Default Value: Y

    7 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
    8 ASSET_CLASS Character(10) VARCHAR2(10) NOT NULL Asset Class
    9 RD_PLANT_ASSET Character(1) VARCHAR2(1) NOT NULL R and D Plant Asset

    Y/N Table Edit

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

    Y/N Table Edit

    12 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name
    13 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name
    14 ASSET_RESOURCE_SW Character(1) VARCHAR2(1) NOT NULL Field to indicate that an Asset is used as a tool or resource
    15 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
    16 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
    17 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID
    18 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
    N=No
    Y=Yes
    19 PROFILE_ACTIVE_SW Character(1) VARCHAR2(1) NOT NULL Profile Active Switch
    N=Inactive
    Y=Active

    Default Value: Y