GM_SP_FORMS1_VW

(SQL View)
Index Back

Sponsors with Formsused View


select distinct a.setid ,a.cust_id ,c.name1 from PS_CUSTOMER c ,ps_gm_sp_formsused a where a.setid = c.setid and a.cust_id = c.cust_id and a.form_id <> 'SAS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID
3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1