BUSINESS_UNITBUSINESS_UNIT_AMRE_LS_ASTDS_CNT(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_AM , COUNT(A.BUSINESS_UNIT) FROM PS_RE_LS_AST_DST A , PS_RE_LS B WHERE B.LS_KEY = A.LS_KEY AND A.ASSET_SEQ_NBR = 1 AND B.SYSTEM_SOURCE = 'BAM' GROUP BY A.BUSINESS_UNIT, A.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 |