PROFILE_TBL

(SQL Table)
 Index Back

Asset Profile

AM Asset Profile Information

  • Related Language Record: PROFILE_LANG

  • Parent Record Of PROFILETBL_NKVW PROFILE_BK_TBL PROFILE_TBL_VW PROFILE_TBL_VW1 PROFILE_TBL_VW2 PROFILE_TBL_VW3 PROFLETBL_LN_VW SP_BK_PRF_CLSVW SP_BK_PRF_NONVW SP_BK_PRF_OPRVW

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

    Default Value: P

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

    Prompt Table: ASSET_CLASS_TBL

    9 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
    10 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE_VW

    11 RD_PLANT_ASSET Character(1) VARCHAR2(1) NOT NULL R and D Plant Asset

    Y/N Table Edit

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

    Y/N Table Edit

    14 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name

    Prompt Table: AM_INDEX_TBL

    15 INDEX_DETAIL_NAME Character(35) VARCHAR2(35) NOT NULL SubIndex Name

    Prompt Table: AM_INDEX_DETAIL

    16 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

    17 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

    Prompt Table: CAP_THR_DFN1_VW

    18 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    19 PROFILE_ACTIVE_SW Character(1) VARCHAR2(1) NOT NULL Profile Active Switch
    N=Inactive
    Y=Active

    Default Value: Y