GM_AWD_NEGOTIAT (SQL Table)	Index Back
Negotiation Parent This is where the users can maintain negotiation details, and is typically completed once the institution has some confidence that a proposal will be awarded, but certain aspects of it must be agreed upon before the award is official.

GM_AWD_NEGOTIAT

(SQL Table)

Negotiation Parent

This is where the users can maintain negotiation details, and is typically completed once the institution has some confidence that a proposal will be awarded, but certain aspects of it must be agreed upon before the award is official.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_GL

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

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

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 NEGOTIATE_TYPE Character(3) VARCHAR2(3) NOT NULL Negotiation Type
AP=Approvals
CF=Confidentiality
CI=Costing Issues
CP=Copyright
GL=Governing Law
IN=Indemnification
IP=Intellectual Property
LI=Liability
O=Other
PA=Patents
PB=Publications
WA=Warranty

6 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
Default Value: %date

7 NEGOTIATE_STATUS Character(3) VARCHAR2(3) NOT NULL Negotiate Status
A=Approved
N=Negotiating
P=Pending Negotiation
R=Declined

8 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 Prompt Table: BUS_UNIT_TBL_GL
2	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
3	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	NEGOTIATE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Negotiation Type AP=Approvals CF=Confidentiality CI=Costing Issues CP=Copyright GL=Governing Law IN=Indemnification IP=Intellectual Property LI=Liability O=Other PA=Patents PB=Publications WA=Warranty
6	EVENT_DT	Date(10)	DATE	The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting Default Value: %date
7	NEGOTIATE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Negotiate Status A=Approved N=Negotiating P=Pending Negotiation R=Declined
8	DESCRLONG	Long Character	CLOB	Long Description