GM_EC_OTH_AGECY (SQL View)	Index Back
EDI Other Federal Agency It is for the mapping of NSF 1207 and 1239. It is to determine the info of agency which the proposal has been or is going to submitted to.

GM_EC_OTH_AGECY

(SQL View)

EDI Other Federal Agency

It is for the mapping of NSF 1207 and 1239. It is to determine the info of agency which the proposal has been or is going to submitted to.

SELECT DISTINCT A.BUSINESS_UNIT, A.PROPOSAL_ID, A.VERSION_ID, A.CUST_ID, D.NAME1 FROM PS_GM_PROPOSAL A, PS_CUSTOMER D WHERE D.CUST_ID = A.CUST_ID AND D.SETID=(SELECT SETID FROM PS_SET_CNTRL_REC G WHERE G.SETCNTRLVALUE=A.BUSINESS_UNIT AND G.RECNAME='CUSTOMER') AND A.CUST_ID<>'10013'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

4 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
3	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
4	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.
5	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1