AM_PROP_TX_SRCH

(SQL View)
 Index Back

AM-Property Tax Search record

Search record for ASSET_PROP_TAX component. View of ASSET_PROPERTY selecting only SITEs and BUILDINGs.

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.PROPERTY_ID , A.PROPERTY_DESCR , A.PROPERTY_NM , A.PROPERTY_CLASS , B.DESCR , B.TAG_NUMBER , B.ASSET_STATUS FROM PS_ASSET_PROPERTY A , PS_ASSET B WHERE A.PROPERTY_CLASS IN ('10', '20') AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID

# 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 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
9 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