OPRIDLS_KEY1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred
Prompt Table: RE_LEASE_TYPE
RE_MY_PRTFL(SQL View) |
Index Back |
|---|---|
My Portfolio ViewMy Portfolio View |
| SELECT PORTFOLIO.OPRID , LEASE.LS_KEY , LEASE.BUSINESS_UNIT ,LEASE.LS_NBR ,LEASE.LEASE_NAME ,LEASE.REGION_CD ,LEASE.LEASE_STATUS ,LEASE.PRIM_PROPERTY_ID ,LEASE.LEASE_END_DT ,LEASE.LS_ADMIN ,LEASE.PRTFL_MGR RE_PORTFL_MGR ,LEASE.LSE_TYPE_CD FROM PS_RE_LS LEASE ,PS_RE_MY_PORTFOLIO PORTFOLIO WHERE LEASE.LS_KEY = PORTFOLIO.LS_KEY AND LEASE.LEASE_STATUS NOT IN ('3','7') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 5 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 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. |
| 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 | PRIM_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Primary Property |
| 9 | LEASE_END_DT | Date(10) | DATE | Lease End Date |
| 10 | LS_ADMIN | Number(10,0) | DECIMAL(10) NOT NULL | Lease Administrator |
| 11 | PRTFL_MGR | Number(10,0) | DECIMAL(10) NOT NULL | Portfolio Manager |
| 12 | LSE_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL |
This field contains the code for the Lease Types
Prompt Table: RE_LEASE_TYPE |