ASSET_JV_VW

(SQL View)
 Index Back

Asset Joint Venture View

If you add fields to ASSET, they must also be on this view.

SELECT BUSINESS_UNIT , ASSET_ID , ASSET_TYPE , ASSET_SUBTYPE , PARENT_ID , COMPONENT_OF_ID , TAGGABLE_SW , TAG_NUMBER , DESCR , DESCRSHORT , ASSET_STATUS , FINANCIAL_ASSET_SW , REPLACE_SW , REPLACE_ASSET_ID , CONVERSION_ID , NEW_ASSET_SW , AVAIL_SW , AVAIL_CONTACT , AVAIL_PHONE , ACQUISITION_CD , ACQUISITION_DT , FINANCING_CD , REPLACEMENT_COST , REPLACE_COST_DT , LEASE_ASSET_ID , PROFILE_ID , ASSET_CLASS , CAP_NUM , CAP_SEQUENCE , MANUFACTURER , MODEL , PROD_VERSION , SERIAL_ID , PRODUCTION_DT , PLANT , MANUFACTUR_CONTACT , BUSINESS_UNIT_JV , INDEX_NAME , INDEX_DETAIL_NAME , LAST_INDEX_VALUE , COMPOSITE_SW , COMPOSITE_ID , FERC_CD , GROUP_ASSET_FLAG , CURRENCY_CD , RD_PLANT_ASSET , RD_START_DT , RD_USE_NBV , IP_ADDRESS , IP_ALIAS , COLLATERAL_ASSET , CLUSTERED_ASSET , life , LAST_REVIEW_DT , AM_AST_UD_CHAR1 , AM_AST_UD_CHAR2 , AM_AST_UD_DATE1 , AM_AST_UD_NUM1 , AM_AST_UD_NUM2 , LAST_CALC_RPL_COST , HAZARDOUS_SW , SS_STATUS , %subrec(AM_MAINT_SBR, PS_ASSET) , ASSET_ASSIGNED_TO , AVAIL_FOR_USE , VIN , IT_UD_CHAR1 , IT_UD_CHAR2 , IT_UD_DATE1 , MFG_ID , IN_SERVICE_DT , REGION_CD , SKU , CRM_IPROD_ID , CRM_IPROD_SETID , CRM_IPROD_STATUS , CRM_DEPT_SETID , DESCR_LONG , LINEAR_ASSET_SW , NBR_OF_CPU , CAP_THRSHLD_ID , IN_PHY_USE , ARO_SW , ARO_ID , SES_LAST_DTTM FROM PS_ASSET

  • 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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

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

    Default Value: NEXT

    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
    5 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

    Prompt Table: PARENT_ASSET

    6 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset

    Prompt Table: AM_COMPONENT

    7 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset
    8 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ASSET_JV_VW.DESCR

    11 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ASSET

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

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

    18 AVAIL_CONTACT Character(30) VARCHAR2(30) NOT NULL Availability Contact
    19 AVAIL_PHONE Character(12) VARCHAR2(12) NOT NULL Availability Phone
    20 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

    21 ACQUISITION_DT Date(10) DATE Acquisition Date
    22 FINANCING_CD Character(5) VARCHAR2(5) NOT NULL Financing Code

    Prompt Table: FINANCE_CD_TBL

    23 REPLACEMENT_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Replacement Cost
    24 REPLACE_COST_DT Date(10) DATE Last Update
    25 LEASE_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Lease Asset ID

    Prompt Table: LEASE_SRCH

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

    Prompt Table: PROFILE_TBL

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

    Prompt Table: ASSET_CLASS_TBL

    28 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

    Prompt Table: CAP

    29 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

    Prompt Table: CAP_DET_VW

    30 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
    31 MODEL Character(30) VARCHAR2(30) NOT NULL Model
    32 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
    33 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    34 PRODUCTION_DT Date(10) DATE Production Date
    35 PLANT Character(30) VARCHAR2(30) NOT NULL Manufacturing Plant
    36 MANUFACTUR_CONTACT Character(30) VARCHAR2(30) NOT NULL Manufacturing Contact
    37 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
    38 INDEX_NAME Character(20) VARCHAR2(20) NOT NULL Index Name

    Prompt Table: AM_INDEX_TBL

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

    Prompt Table: AM_INDEX_DETAIL

    40 LAST_INDEX_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Last Index Value
    41 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

    Y/N Table Edit

    Default Value: N

    42 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID

    Prompt Table: ASSET_COMPOS_VW

    43 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

    Prompt Table: FERC_CD_TBL

    44 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
    G=Group Asset
    M=Group Member
    N=None
    45 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    46 RD_PLANT_ASSET Character(1) VARCHAR2(1) NOT NULL R and D Plant Asset

    Y/N Table Edit

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

    Y/N Table Edit

    49 IP_ADDRESS Character(39) VARCHAR2(39) NOT NULL Internet Protocol Address
    50 IP_ALIAS Character(35) VARCHAR2(35) NOT NULL Internet Address Alias/UNC
    51 COLLATERAL_ASSET Character(2) VARCHAR2(2) NOT NULL Collateral Asset
    01=Mortgage
    02=Fixed Mortgage
    03=Factory Foundation Mortgage
    04=Others
    52 CLUSTERED_ASSET Character(1) VARCHAR2(1) NOT NULL Clustered Asset
    53 LIFE Number(4,0) SMALLINT NOT NULL Useful Life
    54 LAST_REVIEW_DT Date(10) DATE Used for Australian VAT - last date of mandatory review
    55 AM_AST_UD_CHAR1 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field1
    56 AM_AST_UD_CHAR2 Character(10) VARCHAR2(10) NOT NULL User Defined Char Field2
    57 AM_AST_UD_DATE1 Date(10) DATE User Defined Date Field1
    58 AM_AST_UD_NUM1 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field1
    59 AM_AST_UD_NUM2 Number(19,3) DECIMAL(18,3) NOT NULL User Defined Number Field2
    60 LAST_CALC_RPL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Last calculated replacement cost
    61 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset
    62 SS_STATUS Character(1) VARCHAR2(1) NOT NULL Strategic Sourcing Status
    A=Sent to Auction
    N=Not allowed to be Auctioned
    S=Sold in Auction
    Y=Allowed to be Auctioned
    63 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

    64 ALLOW_OVERBOOK_SW Character(1) VARCHAR2(1) NOT NULL Allow Overbooking

    Y/N Table Edit

    Default Value: N

    65 CHARGE_BACK_SW Character(1) VARCHAR2(1) NOT NULL Charge Back Switch
    D=Default
    N=No
    Y=Yes

    Default Value: D

    66 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

    Y/N Table Edit

    Default Value: N

    67 EPL_TMPL_ID Character(15) VARCHAR2(15) NOT NULL Parts List Template

    Prompt Table: EPL_LOOKUP_VW

    68 REPAIRABLE_FLG Character(1) VARCHAR2(1) NOT NULL Repairable Flag

    Y/N Table Edit

    Default Value: N

    69 REPAIR_STATUS Character(1) VARCHAR2(1) NOT NULL Repair Status
    0=None
    1=Needs Repair
    2=In Repair

    Default Value: 0

    70 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

    Prompt Table: SP_BU_WM_NONVW

    71 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

    Prompt Table: AM_WM_SHOP

    72 UNOWNED_FLG Character(1) VARCHAR2(1) NOT NULL Non-Owned Asset

    Y/N Table Edit

    73 WO_LOCATION_FLG Character(1) VARCHAR2(1) NOT NULL Work Order Location
    1=Shop Location
    2=Asset Location
    3=Other Location
    74 OFFLINE_FLG Character(1) VARCHAR2(1) NOT NULL Asset Offline

    Y/N Table Edit

    Default Value: N

    75 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality

    Prompt Table: AM_CRIT_LVL

    76 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

    Prompt Table: AM_CREW_VW

    77 ASSET_ASSIGNED_TO Character(12) VARCHAR2(12) NOT NULL Asset Assigned To
    78 AVAIL_FOR_USE Character(1) VARCHAR2(1) NOT NULL Available For Use
    79 VIN Character(18) VARCHAR2(18) NOT NULL VIN
    80 IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field1
    81 IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL IT User Defined Char Field2
    82 IT_UD_DATE1 Date(10) DATE IT User Defined Date Field
    83 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    84 IN_SERVICE_DT Date(10) DATE In Service Date
    85 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: REGION_CD

    86 SKU Character(50) VARCHAR2(50) NOT NULL Stock Keeping Unit
    87 CRM_IPROD_ID Character(20) VARCHAR2(20) NOT NULL For CRM integration of IT Assets
    88 CRM_IPROD_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
    89 CRM_IPROD_STATUS Character(3) VARCHAR2(3) NOT NULL For CRM integration of IT Assets
    INS=Install
    UNI=Uninstall
    90 CRM_DEPT_SETID Character(5) VARCHAR2(5) NOT NULL For CRM integration of IT Assets
    91 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
    92 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset

    Y/N Table Edit

    93 NBR_OF_CPU Number(3,0) SMALLINT NOT NULL Used by ITAM. Servers and Desktops can have multiple CPUs. A separate Software License is needed for each CPU.
    94 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

    Prompt Table: CAP_THR_DEFN

    95 IN_PHY_USE Character(1) VARCHAR2(1) NOT NULL Describes if entity is in physical use.
    96 ARO_SW Character(1) VARCHAR2(1) NOT NULL Asset Retirement Obligations
    N=No
    Y=Yes

    Y/N Table Edit

    97 ARO_ID Character(12) VARCHAR2(12) NOT NULL ARO Identification
    98 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

    Default Value: %DATETIME