GM_AWARD (SQL Table)	Index Back
Award Parent Record This record contains the award specific details required to begin the award receipt process.

GM_AWARD

(SQL Table)

Award Parent Record

This record contains the award specific details required to begin the award receipt process.

Related Language Record: GM_AWARD_LNG

Parent Record Of GM_AWD_CNCT_WRK GM_AWD_CUST_CT GM_AWD_MOD GM_AWD_MOD_LINE GM_AWD_MOD_VW GM_MD_AWDMOD_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number

4 LAST_UPDATE_DT Date(10) DATE Last Updated
Default Value: %Date

5 BEGIN_DT Date(10) DATE Begin Date
Default Value: GM_PROPOSAL.BEGIN_DT

6 END_DT Date(10) DATE End Date
Default Value: GM_PROPOSAL.END_DT

7 AMOUNT_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Total

8 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
Default Value: GR

9 AWARD_DT Date(10) DATE Award Date

10 PURPOSE Character(5) VARCHAR2(5) NOT NULL Purpose
Prompt Table: GM_PURPOSE

11 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
Default Value: ACP

12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GM_ELIG_PI_VW

13 NAME Character(50) VARCHAR2(50) NOT NULL Name

14 POST_ADMIN Character(11) VARCHAR2(11) NOT NULL Post Award Administrator
Prompt Table: GM_ELIG_ADM_VW

15 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
Default Value: GM_PROPOSAL.PROPOSAL_ID
Prompt Table: GM_PROP_ID_VW

16 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
Prompt Table: GM_PROPOSAL

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

18 COST_SHR_SPNSR_REQ Character(1) VARCHAR2(1) NOT NULL Required by Sponsor
Y/N Table Edit
Default Value: GM_PROPOSAL.COST_SHR_SPNSR_REQ

19 APPROVED_BY Character(11) VARCHAR2(11) NOT NULL APPROVED_BY
Default Value: GM_PROPOSAL.APPROVED_BY
Prompt Table: PERS_DATA_EFFDT

20 REVIEW_COMP Character(1) VARCHAR2(1) NOT NULL Review Completed
Y/N Table Edit
Default Value: GM_PROPOSAL.REVIEW_COMP

21 COMPLIANT_POLICY Character(1) VARCHAR2(1) NOT NULL Compliance with Inst. Policy
Y/N Table Edit
Default Value: GM_PROPOSAL.COMPLIANT_POLICY

22 APPROVAL_DATE Date(10) DATE Approval Date

23 APPROVAL_DT Date(10) DATE Date of Approval

24 PRIMARY_SPNSR_ID Character(15) VARCHAR2(15) NOT NULL Primary Sponsor
Default Value: GM_PROPOSAL.PRIMARY_SPNSR_ID
Prompt Table: GM_CUSTOMER_VW

25 REF_AWD_NUM2 Character(25) VARCHAR2(25) NOT NULL Reference Award

26 GM_CFDA_NUM Character(10) VARCHAR2(10) NOT NULL CFDA Number

27 GM_BEGIN_DT Date(10) DATE Begin Date
Default Value: GM_PROPOSAL.BEGIN_DT

28 GM_END_DT Date(10) DATE End Date
Default Value: GM_PROPOSAL.END_DT

29 GM_AMT_FLO_THRU Number(27,3) DECIMAL(26,3) NOT NULL Amount

30 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: GM_DEPT_TBL_VW

31 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
Prompt Table: GM_INSTITUTION

32 INTERDISCPLINE_USE Character(1) VARCHAR2(1) NOT NULL Interdisciplinary Use
N=No Interdiscipline Use
Y=Interdiscipline use

33 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description

34 SOLICITATION_TITLE Character(56) VARCHAR2(56) NOT NULL Solicitation Title

35 GM_SOURCE_INCOME Character(30) VARCHAR2(30) NOT NULL Source

36 SPNSR_AWARD_ID Character(8) VARCHAR2(8) NOT NULL Sponsor Award ID

37 GM_ADMIN_CNTCT Character(11) VARCHAR2(11) NOT NULL Grant Administrator
Prompt Table: GM_DPT_CNTCT_VW

38 PROPOSAL_PRE_ALLOW Character(1) VARCHAR2(1) NOT NULL Pre-award Spending Allowed
Y/N Table Edit
Default Value: GM_PROPOSAL.PROPOSAL_PRE_ALLOW

39 GR_SOURCE_FUNDING Character(32) VARCHAR2(32) NOT NULL Guaranteed Source of Funding
Default Value: GM_PROPOSAL.GR_SOURCE_FUNDING

40 INITIAL_AWD_AMT Number(27,3) DECIMAL(26,3) NOT NULL Initial Award Amt

41 ADJUSTMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Amount

42 ADJUSTED_AWD_AMT Number(27,3) DECIMAL(26,3) NOT NULL Adjusted Award Amt

43 PI_CHANGE_IND Character(1) VARCHAR2(1) NOT NULL PI Change Indicator

44 EMPLID_OLD Character(11) VARCHAR2(11) NOT NULL Previous Employee ID
Prompt Table: GM_ELIG_PI_VW

45 PROPOSAL_RFP_REF Character(30) VARCHAR2(30) NOT NULL Solicitation/RFP Number

46 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

47 GR_INTELL_PROP_RPT Character(1) VARCHAR2(1) NOT NULL Intellectual Property Reported
Y/N Table Edit
Default Value: N

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

49 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

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
Prompt Table: SP_BU_PC_NONVW

52 PREV_CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Previous Project/Grant
Prompt Table: GM_AWD_PREV_VW

53 RENEWAL Character(1) VARCHAR2(1) NOT NULL Renewal in Progress
Y/N Table Edit

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
Default Value: GM_PROPOSAL.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
Default Value: CA_CONTR_HDR.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

63 CFDA Character(15) VARCHAR2(15) NOT NULL CFDA
Prompt Table: GM_CFDA_TBL

64 GM_CERT_LVL Character(1) VARCHAR2(1) NOT NULL Certifications Level
A=Primary Project
P=All Projects
Default Value: GM_BU_AWD_SETUP.GM_CERT_LVL

65 GM_DEPT_CR_LVL Character(1) VARCHAR2(1) NOT NULL Departmentl Credits Level
A=Primary Project
P=All Projects
Default Value: GM_BU_AWD_SETUP.GM_DEPT_CR_LVL

66 GM_PROF_CR_LVL Character(1) VARCHAR2(1) NOT NULL Professional Credits Level
A=Primary Project
P=All Projects
Default Value: GM_BU_AWD_SETUP.GM_PROF_CR_LVL

67 GM_RSRC_LVL Character(1) VARCHAR2(1) NOT NULL Resources Level
A=Primary Project
P=All Projects
Default Value: GM_BU_AWD_SETUP.GM_RSRC_LVL

68 GM_VNDR_LVL Character(1) VARCHAR2(1) NOT NULL Subrecipients Level
A=Primary Project
P=All Projects
Default Value: GM_BU_AWD_SETUP.GM_VNDR_LVL

69 TERMS_FLG Character(1) VARCHAR2(1) NOT NULL Enter Terms at Award
Y/N Table Edit
Default Value: N

70 FED_AWD_ID_NUMBER Character(50) VARCHAR2(50) NOT NULL Federal Award Identification Number for Grants use. Added in enhancement bug number 18492701.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
3	REF_AWD_NUMBER	Character(25)	VARCHAR2(25) NOT NULL	Reference Award Number
4	LAST_UPDATE_DT	Date(10)	DATE	Last Updated Default Value: %Date
5	BEGIN_DT	Date(10)	DATE	Begin Date Default Value: GM_PROPOSAL.BEGIN_DT
6	END_DT	Date(10)	DATE	End Date Default Value: GM_PROPOSAL.END_DT
7	AMOUNT_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Total
8	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 Default Value: GR
9	AWARD_DT	Date(10)	DATE	Award Date
10	PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Purpose Prompt Table: GM_PURPOSE
11	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 Default Value: ACP
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GM_ELIG_PI_VW
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
14	POST_ADMIN	Character(11)	VARCHAR2(11) NOT NULL	Post Award Administrator Prompt Table: GM_ELIG_ADM_VW
15	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID Default Value: GM_PROPOSAL.PROPOSAL_ID Prompt Table: GM_PROP_ID_VW
16	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID Prompt Table: GM_PROPOSAL
17	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.
18	COST_SHR_SPNSR_REQ	Character(1)	VARCHAR2(1) NOT NULL	Required by Sponsor Y/N Table Edit Default Value: GM_PROPOSAL.COST_SHR_SPNSR_REQ
19	APPROVED_BY	Character(11)	VARCHAR2(11) NOT NULL	APPROVED_BY Default Value: GM_PROPOSAL.APPROVED_BY Prompt Table: PERS_DATA_EFFDT
20	REVIEW_COMP	Character(1)	VARCHAR2(1) NOT NULL	Review Completed Y/N Table Edit Default Value: GM_PROPOSAL.REVIEW_COMP
21	COMPLIANT_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Compliance with Inst. Policy Y/N Table Edit Default Value: GM_PROPOSAL.COMPLIANT_POLICY
22	APPROVAL_DATE	Date(10)	DATE	Approval Date
23	APPROVAL_DT	Date(10)	DATE	Date of Approval
24	PRIMARY_SPNSR_ID	Character(15)	VARCHAR2(15) NOT NULL	Primary Sponsor Default Value: GM_PROPOSAL.PRIMARY_SPNSR_ID Prompt Table: GM_CUSTOMER_VW
25	REF_AWD_NUM2	Character(25)	VARCHAR2(25) NOT NULL	Reference Award
26	GM_CFDA_NUM	Character(10)	VARCHAR2(10) NOT NULL	CFDA Number
27	GM_BEGIN_DT	Date(10)	DATE	Begin Date Default Value: GM_PROPOSAL.BEGIN_DT
28	GM_END_DT	Date(10)	DATE	End Date Default Value: GM_PROPOSAL.END_DT
29	GM_AMT_FLO_THRU	Number(27,3)	DECIMAL(26,3) NOT NULL	Amount
30	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: GM_DEPT_TBL_VW
31	INSTID	Character(5)	VARCHAR2(5) NOT NULL	Institution ID Prompt Table: GM_INSTITUTION
32	INTERDISCPLINE_USE	Character(1)	VARCHAR2(1) NOT NULL	Interdisciplinary Use N=No Interdiscipline Use Y=Interdiscipline use
33	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description
34	SOLICITATION_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Solicitation Title
35	GM_SOURCE_INCOME	Character(30)	VARCHAR2(30) NOT NULL	Source
36	SPNSR_AWARD_ID	Character(8)	VARCHAR2(8) NOT NULL	Sponsor Award ID
37	GM_ADMIN_CNTCT	Character(11)	VARCHAR2(11) NOT NULL	Grant Administrator Prompt Table: GM_DPT_CNTCT_VW
38	PROPOSAL_PRE_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Pre-award Spending Allowed Y/N Table Edit Default Value: GM_PROPOSAL.PROPOSAL_PRE_ALLOW
39	GR_SOURCE_FUNDING	Character(32)	VARCHAR2(32) NOT NULL	Guaranteed Source of Funding Default Value: GM_PROPOSAL.GR_SOURCE_FUNDING
40	INITIAL_AWD_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Initial Award Amt
41	ADJUSTMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjustment Amount
42	ADJUSTED_AWD_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Adjusted Award Amt
43	PI_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	PI Change Indicator
44	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID Prompt Table: GM_ELIG_PI_VW
45	PROPOSAL_RFP_REF	Character(30)	VARCHAR2(30) NOT NULL	Solicitation/RFP Number
46	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
47	GR_INTELL_PROP_RPT	Character(1)	VARCHAR2(1) NOT NULL	Intellectual Property Reported Y/N Table Edit Default Value: N
48	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.
49	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
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 Prompt Table: SP_BU_PC_NONVW
52	PREV_CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Previous Project/Grant Prompt Table: GM_AWD_PREV_VW
53	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress Y/N Table Edit
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 Default Value: GM_PROPOSAL.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 Default Value: CA_CONTR_HDR.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
63	CFDA	Character(15)	VARCHAR2(15) NOT NULL	CFDA Prompt Table: GM_CFDA_TBL
64	GM_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certifications Level A=Primary Project P=All Projects Default Value: GM_BU_AWD_SETUP.GM_CERT_LVL
65	GM_DEPT_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Departmentl Credits Level A=Primary Project P=All Projects Default Value: GM_BU_AWD_SETUP.GM_DEPT_CR_LVL
66	GM_PROF_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Professional Credits Level A=Primary Project P=All Projects Default Value: GM_BU_AWD_SETUP.GM_PROF_CR_LVL
67	GM_RSRC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Resources Level A=Primary Project P=All Projects Default Value: GM_BU_AWD_SETUP.GM_RSRC_LVL
68	GM_VNDR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Subrecipients Level A=Primary Project P=All Projects Default Value: GM_BU_AWD_SETUP.GM_VNDR_LVL
69	TERMS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enter Terms at Award Y/N Table Edit Default Value: N
70	FED_AWD_ID_NUMBER	Character(50)	VARCHAR2(50) NOT NULL	Federal Award Identification Number for Grants use. Added in enhancement bug number 18492701.