GM_CNTCT_BI_VW

(SQL View)
 Index Back

Grants Crrnt EffDt Contacts

This is a copy of CUST_CNCT_BI_VW.

select a.setid, a.cust_id, a.cntct_seq_num, a.name1, a.title from PS_CUST_CONTACT a where a.effdt = (select max(effdt) from PS_CUST_CONTACT where setid=a.setid and cust_id=a.cust_id and cntct_seq_num=a.cntct_seq_num and effdt <= %currentdatein) and a.eff_status='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GM_SETID_CUST Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID
3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 TITLE Character(35) VARCHAR2(35) NOT NULL Title