AP_MEC_OPR1_VW(SQL View) |
Index Back |
|---|---|
AP MECC Operator ViewAP MECC Operator View |
| SELECT AP_MECC_ASSIGNTO , COUNT(1) , 0 , 0 FROM PS_AP_MECC_DTL WHERE AP_MECC_ASSIGNTO <> ' ' GROUP BY AP_MECC_ASSIGNTO UNION ALL SELECT AP_MECC_ASSIGNTO , 0 , COUNT(1) , 0 FROM PS_AP_MECC_ASSIGN WHERE AP_MECC_ASSIGNTO <> ' ' GROUP BY AP_MECC_ASSIGNTO UNION ALL SELECT A.OPRID , 0 , 0 , ( SELECT COUNT(1) FROM PS_AP_MECC_DTL B ) FROM PS_OPR_DEF_TBL_AP A WHERE A.AUTH_MEC_UNASSIGN = 'Y' GROUP BY A.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SUM_1 | Number(9,0) | DECIMAL(9) NOT NULL | Count |
| 3 | SUM_2 | Number(9,0) | DECIMAL(9) NOT NULL | Count |
| 4 | SUM_3 | Number(9,0) | DECIMAL(9) NOT NULL | Count |