GM_AWARD_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
4	REF_AWD_NUMBER	Character(25)	VARCHAR2(25) NOT NULL	Reference Award Number
5	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
6	BEGIN_DT	Date(10)	DATE	Begin Date
7	END_DT	Date(10)	DATE	End Date
8	AMOUNT_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Total
9	AWARD_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Award Type BOA=Basic Ordering Agreement CLI=Clinical Trial CON=Contract CP=Cooperative Agreement FDP=FDP FIX=Fixed GR=Grant IPA=IPA LIC=License LN=Loan MOU=MOU MTA=MTA NDA=NDA OTH=Other PA=Patent Agreement PO=Purchase Order SB=SubContract TO=Task Order
10	AWARD_DT	Date(10)	DATE	Award Date
11	PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Purpose Prompt Table: GM_PURPOSE
12	AWARD_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Award Status ACP=Accepted CLS=Closed HOL=Holding NEG=Under Negotiation PEN=Pending PRE=Pre-Award REF=Refused TER=Terminated TRA=Transfer WTH=Withdrawn
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
15	POST_ADMIN	Character(11)	VARCHAR2(11) NOT NULL	Post Award Administrator
16	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
17	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID Prompt Table: GM_PROPOSAL
18	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.
19	COST_SHR_SPNSR_REQ	Character(1)	VARCHAR2(1) NOT NULL	Required by Sponsor
20	APPROVED_BY	Character(11)	VARCHAR2(11) NOT NULL	APPROVED_BY
21	REVIEW_COMP	Character(1)	VARCHAR2(1) NOT NULL	Review Completed
22	COMPLIANT_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Compliance with Inst. Policy
23	APPROVAL_DATE	Date(10)	DATE	Approval Date
24	APPROVAL_DT	Date(10)	DATE	Date of Approval
25	PRIMARY_SPNSR_ID	Character(15)	VARCHAR2(15) NOT NULL	Primary Sponsor
26	REF_AWD_NUM2	Character(25)	VARCHAR2(25) NOT NULL	Reference Award
27	GM_CFDA_NUM	Character(10)	VARCHAR2(10) NOT NULL	CFDA Number
28	GM_BEGIN_DT	Date(10)	DATE	Begin Date
29	GM_END_DT	Date(10)	DATE	End Date
30	GM_AMT_FLO_THRU	Number(27,3)	DECIMAL(26,3) NOT NULL	Amount
31	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
32	INSTID	Character(5)	VARCHAR2(5) NOT NULL	Institution ID
33	INTERDISCPLINE_USE	Character(1)	VARCHAR2(1) NOT NULL	Interdisciplinary Use N=No Interdiscipline Use Y=Interdiscipline use
34	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description
35	SOLICITATION_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Solicitation Title
36	GM_SOURCE_INCOME	Character(30)	VARCHAR2(30) NOT NULL	Source
37	SPNSR_AWARD_ID	Character(8)	VARCHAR2(8) NOT NULL	Sponsor Award ID
38	GM_ADMIN_CNTCT	Character(11)	VARCHAR2(11) NOT NULL	Grant Administrator
39	PROPOSAL_PRE_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Pre-award Spending Allowed
40	GR_SOURCE_FUNDING	Character(32)	VARCHAR2(32) NOT NULL	Guaranteed Source of Funding
41	INITIAL_AWD_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Initial Award Amt
42	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
43	ADJUSTED_AWD_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Adjusted Award Amt
44	PI_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	PI Change Indicator
45	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID
46	PROPOSAL_RFP_REF	Character(30)	VARCHAR2(30) NOT NULL	Solicitation/RFP Number
47	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
48	GR_INTELL_PROP_RPT	Character(1)	VARCHAR2(1) NOT NULL	Intellectual Property Reported
49	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
50	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
51	BUSINESS_UNIT_AWD	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
52	PREV_CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Previous Project/Grant
53	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress
54	ACCOMPLISH_RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Accomplishment Based Renewal N=Doesn't depend on Accomplishme Y=Depends on Accomplishment
55	MODULAR_FLG	Character(1)	VARCHAR2(1) NOT NULL	MODULAR_FLG
56	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
57	DESCR150_TEXT	Character(150)	VARCHAR2(150) NOT NULL	Description
58	TITLE56	Character(56)	VARCHAR2(56) NOT NULL	TITLE56
59	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
60	DESCR200	Character(254)	VARCHAR2(254) NOT NULL	Long Description
61	DESCRLONG	Long Character	CLOB	Long Description
62	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
63	CFDA	Character(15)	VARCHAR2(15) NOT NULL	CFDA
64	GM_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certifications Level A=Primary Project P=All Projects
65	GM_DEPT_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Departmentl Credits Level A=Primary Project P=All Projects
66	GM_PROF_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Professional Credits Level A=Primary Project P=All Projects
67	GM_RSRC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Resources Level A=Primary Project P=All Projects
68	GM_VNDR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Subrecipients Level A=Primary Project P=All Projects
69	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code