CR_ANALYST_VW (SQL View)	Index Back
No EFFDT credit analysts 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.

CR_ANALYST_VW

(SQL View)

No EFFDT credit analysts 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.CR_ANALYST , A.NAME1 FROM PS_CR_ANALYST_TBL A WHERE A.EFF_STATUS = 'A' AND %EffdtCheck(CR_ANALYST_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 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table: CR_ANALYST_TBL

3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.