BUSINESS_UNITBUSINESS_UNIT_AMRE_LS_COUNT(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , B.BUSINESS_UNIT_AM , COUNT(A.BUSINESS_UNIT) FROM PS_RE_LS A , PS_RE_LS_PPTY B WHERE A.LS_KEY = B.LS_KEY AND B.ASSET_SEQ_NBR = 1 AND A.SYSTEM_SOURCE = 'BAM' GROUP BY A.BUSINESS_UNIT, B.BUSINESS_UNIT_AM |
| # | 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 | ROWCOUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |