AR_BI_SPCLST_VW(SQL View) |
Index Back |
|---|---|
Current Biling SpecialistsCurrent Biling Specialists |
| SELECT S.SETID , S.BILLING_SPECIALIST , S.NAME1 , S.PHONE FROM PS_BI_SPECIALIST S WHERE S.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BI_SPECIALIST WHERE SETID=S.SETID AND BILLING_SPECIALIST = S.BILLING_SPECIALIST AND EFFDT <= %CurrentDateIn) AND S.EFF_STATUS='A' |
| # | 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 |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |