SPECIALIST_VW (SQL View)	Index Back
No effective date view This View should be used whenever prompting for the collector from an effective dated table. Example : CUST_OPTION is an effective dated table. Use this view to prompt for COLLECTOR.

SPECIALIST_VW

(SQL View)

No effective date view

This View should be used whenever prompting for the collector from an effective dated table. Example : CUST_OPTION is an effective dated table. Use this view to prompt for COLLECTOR.

SELECT DISTINCT A.SETID , A.AR_SPECIALIST , A.NAME1 FROM PS_AR_SPECIALIST A , PSOPRDEFN B WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(AR_SPECIALIST X, A, %CurrentDateIn) AND A.OPRID = B.OPRID AND A.OPRID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.

3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1