BUSINESS_UNITRE_LS_TXNDT_CNT(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , COUNT(A.BUSINESS_UNIT) FROM PS_RE_LS A , PS_RE_LS_TXN B , PS_RE_LS_TXN_DTL C WHERE A.LS_KEY = B.LS_KEY AND B.LS_TXN_ID = C.LS_TXN_ID AND A.SYSTEM_SOURCE = 'BAM' GROUP BY A.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ROWCOUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |