GM_CUSTOMER_VW (SQL View)	Index Back
Grants Customer Info View of Customer table that only pulls records for Grants Sponsors. Used as prompt table in proposal. Cust_status = 'A'

GM_CUSTOMER_VW

(SQL View)

Grants Customer Info

View of Customer table that only pulls records for Grants Sponsors. Used as prompt table in proposal. Cust_status = 'A'

SELECT SETID , CUST_ID , NAME1 FROM PS_CUSTOMER WHERE CUST_STATUS = 'A' AND GRANTS_SPONSOR_FLG = 'Y'

# 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 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID

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