SETIDCMPNT_FACILITY_IDFACILITY_IDBLDG_CDPrompt Table: BLDG_TBL
ROOMFACIL_CMPNT4_VW(SQL View) |
Index Back |
|---|---|
Facility Component View 4Facility Component View 4 retrieves a sub-facility's associated main facility. |
| select b.setid, b.cmpnt_facility_id, b.facility_id, a.bldg_cd, a.room, a.room_capacity, a.effdt from PS_FACILITY_CMPNT b, ps_facility_tbl a where a.setid = b.setid and a.facility_id = b.facility_id and a.effdt = (select max(c.effdt) from ps_facility_tbl c where a.setid = c.setid and a.facility_id = c.facility_id) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CMPNT_FACILITY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Component Facility ID |
| 3 | FACILITY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Facility ID |
| 4 | BLDG_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Building
Prompt Table: BLDG_TBL |
| 5 | ROOM |
Character(10) | VARCHAR2(10) NOT NULL | Room |
| 6 | ROOM_CAPACITY | Number(4,0) | SMALLINT NOT NULL | Room Capacity |
| 7 | EFFDT | Date(10) | DATE | Effective Date |