RE_OCCPNT_PPTY(SQL View) |
Index Back |
|---|---|
Property Occupants Details V2 |
| SELECT A.BUSINESS_UNIT ,A.PROPERTY_ID , PROPERTY_NM , A.PROPERTY_CLASS , A.SITE_PROPERTY_ID , BLDG_PROPERTY_ID , FLOOR_PROPERTY_ID , AREA_PROPERTY_ID , SPACE_PROPERTY_ID , B.OCCPNT_TYPE , C.NAME , B.EMPLID , B.FROM_DT , B.TO_DT FROM PS_ASSET_PROPERTY A , PS_RE_OCCPNT_DET B , PS_RE_OCCPNT_VW C WHERE A.PROPERTY_ID = B.PROPERTY_ID AND B.EMPLID = C.EMPLID UNION SELECT A.BUSINESS_UNIT ,A.PROPERTY_ID , PROPERTY_NM , A.PROPERTY_CLASS , A.SITE_PROPERTY_ID , BLDG_PROPERTY_ID , FLOOR_PROPERTY_ID , AREA_PROPERTY_ID , SPACE_PROPERTY_ID , B.OCCPNT_TYPE , C.OPRDEFNDESC , B.EMPLID , B.FROM_DT , B.TO_DT FROM PS_ASSET_PROPERTY A , PS_RE_OCCPNT_DET B , PS_RE_USER_VW C WHERE A.PROPERTY_ID = B.PROPERTY_ID AND B.EMPLID = C.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Property ID |
| 3 | PROPERTY_NM | Character(50) | VARCHAR2(50) NOT NULL | Used to store an Asset Property Name |
| 4 | PROPERTY_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Property Class
10=Site 20=Building 30=Floor 40=Area 50=Space |
| 5 | SITE_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Site ID |
| 6 | BLDG_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Building ID |
| 7 | FLOOR_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Floor ID |
| 8 | AREA_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Area ID |
| 9 | SPACE_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Space ID |
| 10 | OCCPNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Occupant Type
1=Employee 2=User |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | FROM_DT | Date(10) | DATE | From Date |
| 14 | TO_DT | Date(10) | DATE | To Date |