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

COLLECTOR2_VW

(SQL View)

No EFFDT collector table view

This View should be used when ever 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.COLLECTOR , A.NAME1 FROM PS_COLLECTOR_TBL A , PSOPRDEFN B WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(COLLECTOR_TBL X, A, %CurrentDateIn) AND A.OPRID = B.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 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table: COLLECTOR_TBL

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