AM_WC_DPCLOS_VW

(SQL View)
 Index Back

AM WC Depr Close

WorkCenter Depr Close staging view.

SELECT DISTINCT A.BUSINESS_UNIT , A.ASSET_ID , C.BOOK , A.ASSET_STATUS , E.SETID , B.CAL_DEPR_PD FROM PS_ASSET A , PS_BOOK C , PS_BU_BOOK_TBL B , PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = C.BUSINESS_UNIT AND E.RECNAME = 'CAL_DETP_TBL' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.BOOK = C.BOOK AND B.DISTRIBUTION_SW = 'Y' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = C.ASSET_ID UNION SELECT DISTINCT A.BUSINESS_UNIT , A.ASSET_ID , D.LEASE_BOOK , A.ASSET_STATUS , E.SETID , B.CAL_DEPR_PD FROM PS_ASSET A , PS_BU_BOOK_TBL B , PS_SET_CNTRL_REC E , PS_BUS_UNIT_TBL_AM D , PS_LEASE L WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'CAL_DETP_TBL' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BOOK = D.LEASE_BOOK AND B.DISTRIBUTION_SW = 'Y' AND L.BUSINESS_UNIT = A.BUSINESS_UNIT AND L.ASSET_ID = A.ASSET_ID AND L.LEASE_TYPE = 'O' AND A.ACQUISITION_CD = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
4 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
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CAL_DEPR_PD Character(2) VARCHAR2(2) NOT NULL Calendar