RE_RUN_AMLS_VW(SQL View) |
Index Back |
|---|
| SELECT A.OPRID , A.RUN_CNTL_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.BUSINESS_UNIT , A.SELECT_FLAG , CASE WHEN B.VENDOR_ID = ' ' THEN %Coalesce(D.VENDOR_ID, ' ') ELSE B.VENDOR_ID END , B.LEASE_COMMENCE_DT , B.EXPIRATION_DT , C.ASSET_TYPE , C.ASSET_SUBTYPE FROM PS_RE_RUN_AMLEASE A , PS_LEASE B , PS_ASSET C LEFT OUTER JOIN PS_RE_AM_LSDEF_TBL D ON (D.BUSINESS_UNIT_AM = C.BUSINESS_UNIT AND D.ASSET_ID = C.ASSET_ID) WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.ASSET_ID = C.ASSET_ID |
| # | 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 4 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | LEASE_COMMENCE_DT | Date(10) | DATE | Commencement Date |
| 9 | LEASE_END_DT | Date(10) | DATE | Lease End Date |
| 10 | ASSET_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other |
| 11 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL | Asset Subtype |