RE_MIGRATED_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT_AM , A.BUSINESS_UNIT , A.ASSET_STATUS , A.LEASE_STATUS , A.ROWCOUNT1 , B.ROWCOUNT2 FROM PS_RE_MIGRATED_VW1 A , PS_RE_MIGRATED_VW2 B WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_STATUS = B.ASSET_STATUS AND A.LEASE_STATUS = B.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 | ROWCOUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |
| 6 | ROWCOUNT2 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |