GM_AWD_COMMENT (SQL Table)	Index Back
Award Comment Used to store all the comments for Awards. Use AWD_COMMENT_TYPE as a key so that we will only have one DESCRLONG for the record.

GM_AWD_COMMENT

(SQL Table)

Award Comment

Used to store all the comments for Awards. Use AWD_COMMENT_TYPE as a key so that we will only have one DESCRLONG for the record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_CNTR_SRCH_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: GM_AWARD.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW

3 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
Prompt Table: GM_ADD_INFO

4 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: GM_AWARD.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW
3	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 Prompt Table: GM_ADD_INFO
4	DESCRLONG	Long Character	CLOB	Long Description