BUSINESS_UNITGROUP_ID_SFSCC_SFP_PSTDISB(SQL View) |
Index Back |
|---|---|
Get posted disbursementView to get the list of posted disbursement |
| SELECT A.BUSINESS_UNIT , A.GROUP_ID_SF , COUNT(B.GROUP_LINE_NBR) SCC_ROW_TOT_COUNT FROM PS_GROUP_CONT_INFO A , PS_GROUP_LINE B , PS_SCC_SFP_GRPSET C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.GROUP_ID_SF = B.GROUP_ID_SF AND A.ENTRY_DT = %CurrentDateIn AND POST_STATUS = 'I' AND POST_ACTION IN ('A','W') AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.ORIGIN_ID = A.ORIGIN_ID AND C.GROUP_TYPE = A.GROUP_TYPE GROUP BY a.business_unit, a.group_id_sf |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | GROUP_ID_SF |
Character(15) | VARCHAR2(15) NOT NULL | Group ID |
| 3 | SCC_TOT_ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Total Row Count |