RE_MIGRATED_VW2(SQL View) |
Index Back |
|---|
| SELECT P.BUSINESS_UNIT_AM , L.BUSINESS_UNIT , A.ASSET_STATUS , L.LEASE_STATUS , COUNT(TRM.TERM_SCHED_ID) FROM PS_RE_LS L LEFT OUTER JOIN PS_RE_LS_TRM_SCHED TRM ON L.LS_KEY = TRM.LS_KEY , PS_RE_LS_PPTY P , PS_ASSET A WHERE L.LS_KEY = P.LS_KEY AND P.ASSET_SEQ_NBR = 1 AND P.ASSET_ID = A.ASSET_ID AND P.BUSINESS_UNIT_AM = A.BUSINESS_UNIT AND L.SYSTEM_SOURCE = 'BAM' GROUP BY P.BUSINESS_UNIT_AM, L.BUSINESS_UNIT, A.ASSET_STATUS, L.LEASE_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | 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 |
| 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 | ROWCOUNT2 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |