RE_OLEASE_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.LS_NBR , A.LEASE_NAME , A.LEASE_STATUS , A.PRINCIPAL_ID , A.LEASE_START_DT , A.LEASE_END_DT , A.LS_ADMIN , A.PRTFL_MGR , A.LSE_TYPE_CD FROM PS_RE_LS A LEFT OUTER JOIN PS_RE_LS_PPTY B ON A.LS_KEY = B.LS_KEY LEFT OUTER JOIN PS_RE_LS_PRFCTG A1 ON A.LS_KEY = A1.LS_KEY AND A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND B.ASSET_ID = A1.ASSET_ID , PS_ASSET AT WHERE B.BUSINESS_UNIT_AM = AT.BUSINESS_UNIT AND B.ASSET_ID = AT.ASSET_ID AND A.LS_CLASSIFICATION = 'O' AND A.LEASE_OBLG = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
3 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name
4 LEASE_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Status
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred
5 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant
6 LEASE_START_DT Date(10) DATE Lease Start Date
7 LEASE_END_DT Date(10) DATE Lease End Date
8 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator
9 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager
10 LSE_TYPE_CD Character(10) VARCHAR2(10) NOT NULL This field contains the code for the Lease Types