GM_SPNSR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUSTOMER
3	REPORTS_TO_SPONSOR	Character(15)	VARCHAR2(15) NOT NULL	Reports To Sponsor Prompt Table: GM_CUSTOMER_VW
4	SPNSR_LEVEL	Character(4)	VARCHAR2(4) NOT NULL	Level Prompt Table: GM_SPNSR_LEVEL
5	SPNSR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Sponsor Type Prompt Table: GM_SPNSR_TYPE
6	SPNSR_PROGRAM	Character(4)	VARCHAR2(4) NOT NULL	Program Type Prompt Table: GM_SP_PROG_TYPE
7	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
8	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
9	COST_LIV_INCR_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Cost of Living Increase Pct
10	CFDA_NBR	Number(6,3)	DECIMAL(5,3) NOT NULL	CFDA Number
11	FOREIGN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Foreign Y/N Table Edit Default Value: N
12	GM_FEDERAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Federal Y/N Table Edit Default Value: N
13	US_FLAG_CARRIER	Character(1)	VARCHAR2(1) NOT NULL	US Flag Carrier Required Y/N Table Edit Default Value: N
14	LOC_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Letter of Credit Y/N Table Edit Default Value: N
15	GM_LOC_SPONSOR_ID	Character(15)	VARCHAR2(15) NOT NULL	Letter of Credit Sponsor Prompt Table: GM_LOC_SP_VW
16	FA_SPNSR_BASE_ID	Character(5)	VARCHAR2(5) NOT NULL	Sponsor Base Prompt Table: GM_FA_BASE_DTL
17	GM_DEL_LOC_REFS_SW	Character(1)	VARCHAR2(1) NOT NULL	Use this to "mark" parent records that need to have children records deleted.
18	GRANTS_SPONSOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Grants Management Sponsor N=No Y=Yes