NF_ASSET_SRC_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.TAG_NUMBER , A.PARENT_ID , A.DESCR , A.COMPOSITE_SW , A.COMPOSITE_ID , A.FERC_CD , A.SERIAL_ID FROM PS_ASSET A WHERE CAP_THRSHLD_ID <> ' ' AND FINANCIAL_ASSET_SW = 'N'

# 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
3 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
4 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

Prompt Table: PARENT_ASSET

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 COMPOSITE_SW Character(1) VARCHAR2(1) NOT NULL Composite Asset

Y/N Table Edit

7 COMPOSITE_ID Character(12) VARCHAR2(12) NOT NULL Composite Asset ID
8 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

9 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID