RE_LS_PM_DESC (SQL View)	Index Back
Lease Update Search - PM This view selects data from the main lease record and does a left outer join on the Internal Party to get the Portfolio Manager user identifier.

RE_LS_PM_DESC

(SQL View)

Lease Update Search - PM

This view selects data from the main lease record and does a left outer join on the Internal Party to get the Portfolio Manager user identifier.

SELECT L.LEASE_OBLG , L.LS_NBR , L.LS_KEY , L.LEASE_NAME , L.BUSINESS_UNIT , L.REGION_CD , L.LEASE_STATUS , %Substring(L.PRINCIPAL_ID, 1, 10) , L.PRINCIPAL_ID , L.PRINCIPAL_ID , L.LEASE_END_DT , L.LS_ADMIN , L.PRTFL_MGR , L.PRTFL_MGR_OPRID , P.OPRDEFNDESC FROM %Sql(RE_LS_SRCH_PMDESC_OUTER_JOIN_F)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables

2 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number

3 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key

4 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

6 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: RE_REGION

7 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

8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR
Set Control Field: BUSINESS_UNIT

9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_BI_VW
Set Control Field: BUSINESS_UNIT

10 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant

11 LEASE_END_DT Date(10) DATE Lease Termination Date

12 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator

13 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager

14 PRTFL_MGR_OPRID Character(30) VARCHAR2(30) NOT NULL Portfolio Manager

15 PRTFL_MGR_DESC Character(30) VARCHAR2(30) NOT NULL Portfolio Manager Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LEASE_OBLG	Character(1)	VARCHAR2(1) NOT NULL	Lease Obligation either Payables or Receivables Lease 1=Payables 2=Receivables
2	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
3	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
4	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	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: RE_REGION
7	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
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR Set Control Field: BUSINESS_UNIT
9	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_BI_VW Set Control Field: BUSINESS_UNIT
10	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
11	LEASE_END_DT	Date(10)	DATE	Lease Termination Date
12	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator
13	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager
14	PRTFL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager
15	PRTFL_MGR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Description