SETIDPrompt Table: SP_SETID_NONVW
BILLING_SPECIALISTPrompt Table: BI_SPECIALST_VW
BI_SPLST_SM_VW2(SQL View) |
Index Back |
|---|---|
billing specialist summary |
| SELECT B.SETID , A.BILLING_SPECIALIST , B.NAME1 , A.BUSINESS_UNIT , COUNT(A.INVOICE) FROM PS_BI_SPLST_VW2 A , PS_BI_SPECIALIST B WHERE A.BILLING_SPECIALIST = B.BILLING_SPECIALIST GROUP BY B.SETID, A.BILLING_SPECIALIST, B.NAME1, A.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | BILLING_SPECIALIST |
Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALST_VW |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | COUNT_LINES | Number(15,0) | DECIMAL(15) NOT NULL | Count of Lines |