RE_AMLSMIG_VW(SQL View) |
Index Back |
|---|
| SELECT CASE WHEN (C.BUSINESS_UNIT_RE IS NULL OR C.BUSINESS_UNIT_RE = ' ') THEN ( CASE WHEN (( SELECT COUNT(1) FROM PS_RE_BUS_UNIT D WHERE D.BUSINESS_UNIT_AM = A.BUSINESS_UNIT) = 1) THEN ( SELECT D.BUSINESS_UNIT FROM PS_RE_BUS_UNIT D WHERE D.BUSINESS_UNIT_AM = A.BUSINESS_UNIT) ELSE ' ' END) ELSE C.BUSINESS_UNIT_RE END, A.BUSINESS_UNIT, A.ASSET_ID, A.LEASE_TYPE, F.ASSET_STATUS FROM PS_LEASE A LEFT OUTER JOIN PS_RE_MIG_LABU_MAP C ON (C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.ASSET_ID = A.ASSET_ID) LEFT OUTER JOIN PS_RE_LS_PPTY E ON (E.BUSINESS_UNIT_AM = A.BUSINESS_UNIT AND E.ASSET_ID = A.ASSET_ID) INNER JOIN PS_ASSET F ON (F.BUSINESS_UNIT = A.BUSINESS_UNIT AND F.ASSET_ID = A.ASSET_ID) AND E.LS_KEY IS NULL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 3 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 4 | LEASE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Lease Type
C=Capital O=Operating |
| 5 | 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 |