GM_PROPOS_TEO1

#	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	PROPOSAL_ID	Character(25)	VARCHAR2(25) NOT NULL	Proposal ID
4	VERSION_ID	Character(7)	VARCHAR2(7) NOT NULL	Version ID
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	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.
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	OPPORTUNITY_NUM	Character(100)	VARCHAR2(100) NOT NULL	Opportunity Number
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	ACT_TITLE	Character(120)	VARCHAR2(120) NOT NULL	Activity Title
11	APP_IDNT	Character(30)	VARCHAR2(30) NOT NULL	Applicant Identifier
12	APPLICATION_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Grants.gov processing status AGT=Agency Tracking Number Assign PRC=Processing RAG=Received by Agency REC=Received REJ=Rejected with Errors VAL=Validated
13	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
14	DUE_DT_TIME	Time(15)	TIMESTAMP	Due Date Time
15	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
16	US_TIME_ZONES	Character(3)	VARCHAR2(3) NOT NULL	Time Zones for the U.S. ALA=Alaska Time CST=Central Standard Time EST=Eastern Standard Time HAW=Hawaii Time MST=Mountain Standard Time PST=Pacific Standard Time
17	DATE_DUE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Due Date Type POST=Postmark Date RCPT=Receipt Date
18	PROPOSAL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	PROPOSAL_TYPE AMD=Amendment CNT=Continuation CON=Competing Continuation INT=Internal MOD=Modification NEW=New NOC=No-Cost Extension NON=Non-Competing Continuation NRS=NRSA PRE=Pre-Proposal RCA=Research Career Award REN=Renewal RES=Resubmission REV=Revision SB1=SBIR I SB2=SBIR II ST1=STTR I ST2=STTR II SUP=Supplemental
19	PROPOSAL_RFP_REF	Character(30)	VARCHAR2(30) NOT NULL	Solicitation/RFP Number
20	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
21	COMPLIANT_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Compliance with Inst. Policy
22	GR_INTELL_PROP_RPT	Character(1)	VARCHAR2(1) NOT NULL	Intellectual Property Reported
23	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
24	PROPOSAL_PRE_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Pre-award Spending Allowed
25	REVIEW_COMP	Character(1)	VARCHAR2(1) NOT NULL	Review Completed
26	BEGIN_DT	Date(10)	DATE	Begin Date
27	END_DT	Date(10)	DATE	End Date
28	APPROVAL_DATE	Date(10)	DATE	Approval Date
29	GR_SOURCE_FUNDING	Character(32)	VARCHAR2(32) NOT NULL	Guaranteed Source of Funding
30	INST_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	Is Change Of Institution
31	INSTRUCTION_URL	Character(250)	VARCHAR2(250) NOT NULL	Instruction URL
32	TITLE56	Character(56)	VARCHAR2(56) NOT NULL	TITLE56
33	TMPLT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Flag ; used to identify if a Proposal is a Template Proposal.
34	PROPOSAL_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Description
35	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
36	RANK_PRIO	Character(1)	VARCHAR2(1) NOT NULL	Rank H=High L=Low M=Medium
37	FOREIGN_APP_COMP	Character(1)	VARCHAR2(1) NOT NULL	Foreign Application/Component
38	FROM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create from Get Opportunity
39	GGOV_FLG	Character(1)	VARCHAR2(1) NOT NULL	GGOV_FLG
40	GM_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certifications Level A=Primary Project P=All Projects
41	GM_COMP_LVL	Character(1)	VARCHAR2(1) NOT NULL	Components Level A=Primary Project P=All Projects
42	GM_DEPT_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Departmentl Credits Level A=Primary Project P=All Projects
43	BILL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
44	BILL_AMT_EXP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
45	BILL_AMT_TIME	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
46	COST_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount
47	COST_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Expense
48	COST_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Time
49	ESTIMATED_AMOUNT	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount SCP - Added new label - Estimated Cost
50	ESTIMATED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Expense
51	ESTIMATED_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Time
52	HOURS_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Hours Option D=Start/End Date I=Hours W=Weeks Default Value: I
53	PM_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
54	MARGIN_PCT_EXP	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
55	MARGIN_PCT_TIME	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
56	NBR_OF_HOURS	Number(5,0)	INTEGER NOT NULL	Number of Hours
57	PROPOSED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Expense
58	PROPOSED_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Time
59	RESOURCE_TOTAL	Number(3,0)	SMALLINT NOT NULL	Resource Total
60	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer. Prompt Table: GM_SALE_SRCH_VW
61	STD_HOURS_DAY	Number(5,2)	DECIMAL(4,2) NOT NULL	Standard Hours Day Default Value: 8
62	STD_HOURS_WK	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours Week Default Value: 40
63	THRESHOLD_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence %
64	CONF_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Confidence Level H=01 - High L=O3 - Low M=02 - Medium
65	WEEKLY_WEEKS	Number(3,0)	SMALLINT NOT NULL	Weeks
66	SCEN_ADJUST_PCT_EX	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST
67	SCEN_ADJUST_PCT_TM	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST
68	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Order Capture ID
69	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
70	PRODUCT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product Description
71	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
72	SALESREP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales Representative Name
73	CC_PHONE_EXTENSION	Character(33)	VARCHAR2(33) NOT NULL	Salesrep Phone Number
74	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
75	CY_CONVER_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Totla
76	GM_PROF_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Professional Credits Level A=Primary Project P=All Projects
77	GM_RSRC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Resources Level A=Primary Project P=All Projects
78	GM_VNDR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Subrecipients Level A=Primary Project P=All Projects
79	GM_WF_AUTO_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Workflow Active
80	PI_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	PI Change Indicator
81	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID
82	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
83	FA_COST_REQ	Character(1)	VARCHAR2(1) NOT NULL	FA Cost Requested
84	PGM_INCOME_PB	Character(1)	VARCHAR2(1) NOT NULL	Program Income
85	COST_SHR_SPNSR_REQ	Character(1)	VARCHAR2(1) NOT NULL	Required by Sponsor
86	APPROVAL_DT	Date(10)	DATE	Date of Approval
87	GM_SOURCE_INCOME	Character(30)	VARCHAR2(30) NOT NULL	Source
88	APPROVED_BY	Character(11)	VARCHAR2(11) NOT NULL	APPROVED_BY
89	PRIMARY_SPNSR_ID	Character(15)	VARCHAR2(15) NOT NULL	Primary Sponsor
90	DIRECT_PERS_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Direct - Personnel Cost
91	DIRECT_NONPER_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Direct - Non Personnel Cost
92	TOTAL_FA_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	TOTAL_FA_COST
93	TRACKING_NBR	Character(30)	VARCHAR2(30) NOT NULL	Tracking Number
94	TRACKING_NBR1	Character(30)	VARCHAR2(30) NOT NULL	Tracking Number
95	TOTAL_BUDGET_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	TOTAL_BUDGET_AMT
96	EFFORT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Effort Percentage
97	DAYS_ELAPSED	Number(4,0)	SMALLINT NOT NULL	Days Elapsed
98	PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Purpose
99	DESCR20A	Character(20)	VARCHAR2(20) NOT NULL	Short Description
100	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
101	CONTINUATION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Continuation Flag
102	MODULAR_FLG	Character(1)	VARCHAR2(1) NOT NULL	MODULAR_FLG
103	MULTI_PI	Character(1)	VARCHAR2(1) NOT NULL	Allow Multiple PI's
104	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
105	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
106	DATE_FROM	Date(10)	DATE	Date From
107	DATE_TO	Date(10)	DATE	Date To
108	TRANSMISSION_CODE	Character(3)	VARCHAR2(3) NOT NULL	Transmission Code BE=By Mail and Electronically BM=By Mail CF=Courier DA=Data EL=Electronically Only FX=By Fax IA=Electronic Image IT=International Telephone TE=Telephone
109	PROPOSAL_ID_SPNSR	Character(30)	VARCHAR2(30) NOT NULL	Sponsor Proposal ID
110	SUBMIT_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Proposal Submission Status CMTD=03 - Committed CNCL=05 - Canceled DENY=04 - Denied DRAF=01 - Draft NSUB=Not Submitted RDY=02 - Ready SUBM=Submitted SUBR=Submitted With Error
111	PROP_RECEIVED_DATE	Date(10)	DATE	Proposal Received Date
112	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
113	ADMIN_ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	Rolename of Approval Workflow Administrator
114	CREATION_DT	Date(10)	DATE	Creation Date
115	MAILING_INSTRUCT	Long Character	CLOB	Mailing Instructions
116	BUSINESS_UNIT_AWD	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
117	PREV_CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Previous Project/Grant
118	PREV_INSTID	Character(5)	VARCHAR2(5) NOT NULL	Previous Institution
119	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress
120	REV_DEC_AWD	Character(1)	VARCHAR2(1) NOT NULL	Decrease Award
121	REV_DEC_DUR	Character(1)	VARCHAR2(1) NOT NULL	Decrease Duration
122	REV_INC_AWD	Character(1)	VARCHAR2(1) NOT NULL	Increase Award
123	REV_INC_DUR	Character(1)	VARCHAR2(1) NOT NULL	Increase Duration
124	REV_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Other(Specify)
125	REV_OTHER_SPC	Character(45)	VARCHAR2(45) NOT NULL	Other(Specify)
126	ACCOMPLISH_RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Accomplishment Based Renewal N=Doesn't depend on Accomplishme Y=Depends on Accomplishment
127	PRE_PROPOSAL_NBR	Character(25)	VARCHAR2(25) NOT NULL	Pre-Proposal Number
128	STTR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	STTR Fast Track
129	SUBMISSION_TITLE	Character(240)	VARCHAR2(240) NOT NULL	Submission Title
130	SUBMISSION_TYPE	Character(35)	VARCHAR2(35) NOT NULL	There will be 3 valid value for this field: Pre-Application, Application, Changed/Corrected Application
131	SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Report Submitted On - DateTime
132	DISCLOSURE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Disclosure Permission Statemen
133	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
134	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
135	SBIR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	SBIR Fast Track
136	SBIRSTTRT_PHASE	Character(1)	VARCHAR2(1) NOT NULL	SBIR STTR Type 1=Phase 1 2=Phase 2 F=Fast Track
137	SCHEMA_URL	Character(250)	VARCHAR2(250) NOT NULL	Schema URL
138	SOLICITATION_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Solicitation Title
139	ST_APP_IDNT	Character(30)	VARCHAR2(30) NOT NULL	State Application Idetifier
140	ST_REC_DT	Date(10)	DATE	State Received Date
141	STATUS_DTTM	DateTime(26)	TIMESTAMP	05/13/02 EGS (CN#PL900-1): Added
142	LAST_VERSION_ID	Character(4)	VARCHAR2(4) NOT NULL	Last Version ID
143	PPSL_TO_CNTRCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposal To Contract D=Contract Generated N=Not Generated P=Pre-Sales Spending
144	PROPOSAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposal Checkbox G=Grants Proposal I=Internal Proposal S=Solicitation Proposal
145	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
146	PMO_TEAM_CD	Character(5)	VARCHAR2(5) NOT NULL	PMO Team Code
147	CURRENT_VERSION	Character(1)	VARCHAR2(1) NOT NULL	Current Version
148	BILL_COST_BUD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Budget Options A=Bill and Cost Rows B=Bill Rows C=Cost Rows N=None
149	BILL_COST_RT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Rate Options A=Bill and Cost Rows B=Bill Rows C=Cost Rows
150	WORKFLOW_BYPASS	Character(1)	VARCHAR2(1) NOT NULL	Work Flow By Pass
151	CFDA	Character(15)	VARCHAR2(15) NOT NULL	CFDA
152	COMPETITION_ID	Character(100)	VARCHAR2(100) NOT NULL	Competition ID
153	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code