SETIDBILLING_SPECIALISTPrompt Table: BI_SPECIALIST
CA_BP_SPCLST_VW(SQL View) |
Index Back |
|---|---|
Billing specilist vwThis View is used for configuring filter for Exception named LOC doc id not in sponsor file. |
| SELECT A.SETID , A.BILLING_SPECIALIST , A.NAME1 FROM PS_BI_SPECIALIST A WHERE A.EFF_STATUS ='A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_BI_SPECIALIST B WHERE A.setid = B.setid AND A.billing_specialist = B.billing_specialist AND A.EFFDT = B.EFFDT AND B.EFFDT < %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BILLING_SPECIALIST |
Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALIST |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |