GM_BU_AWD_SETUP

#	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	PROJ_GRANT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status A=Approved C=Completed I=In Progress P=Proposed Default Value: I
3	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit Default Value: BUS_UNIT_TBL_CA.BUSINESS_UNIT_BI Prompt Table: SP_BUCABI_NONVW
4	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier Default Value: BUS_UNIT_TBL_CA.BILL_TYPE_ID Prompt Table: BI_TYPE_EF_VW Set Control Field: BUSINESS_UNIT_BI
5	INTEGRATION_TMPL	Character(15)	VARCHAR2(15) NOT NULL	Integration Prompt Table: PC_INT_TMPLGLVW Set Control Field: BUSINESS_UNIT_PC
6	BUDGET_CATEGORY_FR	Character(15)	VARCHAR2(15) NOT NULL	Bud Item - Fringe Prompt Table: GM_BUD_CATEGORY Set Control Field: BUSINESS_UNIT
7	BUDGET_CATEGORY_FA	Character(15)	VARCHAR2(15) NOT NULL	Bud Item - FA Prompt Table: GM_BUD_CATEGORY Set Control Field: BUSINESS_UNIT
8	BUDGET_CATEGORY_RE	Character(15)	VARCHAR2(15) NOT NULL	Bud Item - Rev Est Prompt Table: GM_BUD_CATEGORY Set Control Field: BUSINESS_UNIT
9	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_LEDPC_NONVW Set Control Field: BUSINESS_UNIT_GL
10	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_LEDGPC_NONVW
11	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE Set Control Field: BUSINESS_UNIT_PC
12	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: PROJ_CATG_TBL Set Control Field: BUSINESS_UNIT_PC
13	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: PROJ_SUBCAT_TBL Set Control Field: BUSINESS_UNIT_PC
14	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type Prompt Table: CA_TYPE_TBL Set Control Field: BUSINESS_UNIT
15	CONTR_LEGAL_ENTITY	Character(15)	VARCHAR2(15) NOT NULL	Contract Legal Entity Prompt Table: CA_LEGAL_ENTITY Set Control Field: BUSINESS_UNIT
16	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: SP_BU_PC_NONVW
17	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source Prompt Table: BI_SRC_EF_VW Set Control Field: BUSINESS_UNIT_BI
18	CA_STATUS	Character(24)	VARCHAR2(24) NOT NULL	Contract Status Prompt Table: CA_STAT_PND1_VW Set Control Field: BUSINESS_UNIT
19	TOLERANCE_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Tolerance Amount
20	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: GM_PRDCT_AI_VW Set Control Field: BUSINESS_UNIT
21	PRODUCT_ID_ALT	Character(18)	VARCHAR2(18) NOT NULL	Alternate Product ID Prompt Table: GM_PRDCT_FF_VW
22	CONFIDENCE_LOW	Number(3,0)	SMALLINT NOT NULL	Low Confidence
23	CONFIDENCE_MEDIUM	Number(3,0)	SMALLINT NOT NULL	Medium Confidence
24	CONFIDENCE_HIGH	Number(3,0)	SMALLINT NOT NULL	High Confidence
25	GM_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certifications Level A=Primary Project P=All Projects Default Value: P
26	GM_PROF_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Professional Credits Level A=Primary Project P=All Projects Default Value: P
27	GM_DEPT_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Departmentl Credits Level A=Primary Project P=All Projects Default Value: P
28	GM_COMP_LVL	Character(1)	VARCHAR2(1) NOT NULL	Components Level A=Primary Project P=All Projects Default Value: A
29	GM_RSRC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Resources Level A=Primary Project P=All Projects Default Value: P
30	GM_VNDR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Subrecipients Level A=Primary Project P=All Projects Default Value: P
31	PROPOSAL_STATUS_GR	Character(4)	VARCHAR2(4) NOT NULL	PROPOSAL_STATUS_GR ACP=Accepted Award APR=Institution Approved AWD=Awarded AWP=Award Pending DEC=Declined by Sponsor DIS=Discontinued DRF=Draft NOT=Not Funded PEF=Pending Funding PEN=Pending Approval REF=Refused by Institution REJ=Rejected SUBM=Submitted WIT=Withdrawn
32	PROPOSAL_STATUS_AP	Character(4)	VARCHAR2(4) NOT NULL	Proposal Status APR=Institution Approved
33	NEXT_CR_DAYS_ANM	Number(4,0)	SMALLINT NOT NULL	Next CR days Animal
34	NEXT_CR_DAYS_HMN	Number(4,0)	SMALLINT NOT NULL	Next CR Days Human
35	CLOSE_DAYS	Number(5,0)	INTEGER NOT NULL	Days To Close
36	SYSTEM_VERSION_IND	Character(1)	VARCHAR2(1) NOT NULL	System Proposal Versioning Y/N Table Edit Default Value: Y
37	MULTIPLE_CFDA	Character(1)	VARCHAR2(1) NOT NULL	To Enable Multiple CFDA. Y/N Table Edit Default Value: N
38	BURN_LOW	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Burn Rate Low Default Value: -999
39	BURN_MEDIUM	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Medium Burn Rate
40	BURN_HIGH	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	High Burn Rate Default Value: 999
41	MULTI_PI	Character(1)	VARCHAR2(1) NOT NULL	Allow Multiple PI's Y/N Table Edit
42	GM_PT_SECURITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Add to Grants Portal Security? Y/N Table Edit Default Value: N
43	CONS_TPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Contracts Console Template ID Default Value: GRANTS Prompt Table: CA_CONS_GMBU_VW
44	MOD_LN_SYNC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sync. Modification for Period Y/N Table Edit Default Value: N
45	TERMS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enter Terms at Award Y/N Table Edit Default Value: N
46	GM_AWE_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Setup Approval Workflow Engine A=Approval Workflow Engine T=Traditional Workflow Default Value: T
47	GM_PROCESS_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID Prompt Table: GM_PRCSID_AW_VW
48	KK_EFFDT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Effective Dated option - Grants BU Setup A=All Rows C=Current Effective Dated Row F=Current & Future Dated Rows Default Value: C
49	PLUS_DAYS	Number(3,0)	SMALLINT NOT NULL	Days to Add
50	OVERRIDE_KK_DATE	Character(1)	VARCHAR2(1) NOT NULL	Allow User Override Y/N Table Edit Default Value: N