COLLECTOR_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.

COLLECTOR_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 A.SETID , A.COLLECTOR , A.NAME1 FROM PS_COLLECTOR_TBL A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(COLLECTOR_TBL X, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
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(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.