GM_EC_PROP_COMM (SQL View)	Index Back
EDI Proposal Comments

GM_EC_PROP_COMM

(SQL View)

EDI Proposal Comments

SELECT A.BUSINESS_UNIT, A.PROPOSAL_ID, A.VERSION_ID, A.GM_COMMENT_TYPE, A.DESCRLONG FROM PS_GM_PROP_COMMENT A

# 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 GM_COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
APC=Allocation Percentages
COI=Conflict of Interest
CON=Concurrent Submissions
CST=Cost Sharing
EXP=Express Proposal
FLW=Flow Through
IC=Institution Change
IP=Intellectual Property
MJ=Major Goals
OTH=Other
PI=PI Change
PRE=Pre-Award Spending
PRV=Previous Award
REL=Related Proposals
SOL=Solicitation
UOB=Unobligated Balance

5 DESCRLONG Long Character CLOB Long Description

#	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	GM_COMMENT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Comment Type APC=Allocation Percentages COI=Conflict of Interest CON=Concurrent Submissions CST=Cost Sharing EXP=Express Proposal FLW=Flow Through IC=Institution Change IP=Intellectual Property MJ=Major Goals OTH=Other PI=PI Change PRE=Pre-Award Spending PRV=Previous Award REL=Related Proposals SOL=Solicitation UOB=Unobligated Balance
5	DESCRLONG	Long Character	CLOB	Long Description