RE_ADDPORTFOLIO(SQL View) |
Index Back |
|---|---|
Add Portfolio Dynamic ViewAdd to My Portfolio Dynamic View |
| SELECT 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 ,LEASE.LSE_TYPE_CD FROM PS_RE_LS LEASE WHERE LEASE.LEASE_STATUS NOT IN ('3' ,'7') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 4 | LEASE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Lease Name |
| 5 | 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. |
| 6 | 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 |
| 7 | PRIM_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Primary Property |
| 8 | LEASE_END_DT | Date(10) | DATE | Lease End Date |
| 9 | LS_ADMIN | Number(10,0) | DECIMAL(10) NOT NULL | Lease Administrator |
| 10 | PRTFL_MGR | Number(10,0) | DECIMAL(10) NOT NULL | Portfolio Manager |
| 11 | LSE_TYPE_CD | Character(10) | VARCHAR2(10) NOT NULL | This field contains the code for the Lease Types |