GM_PROPOS_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	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	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.
11	DUE_DT_TIME	Time(15)	TIMESTAMP	Due Date Time
12	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
13	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
14	DATE_DUE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Due Date Type POST=Postmark Date RCPT=Receipt Date
15	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
16	PROPOSAL_RFP_REF	Character(30)	VARCHAR2(30) NOT NULL	Solicitation/RFP Number
17	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
18	COMPLIANT_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Compliance with Inst. Policy
19	GR_INTELL_PROP_RPT	Character(1)	VARCHAR2(1) NOT NULL	Intellectual Property Reported
20	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
21	PROPOSAL_PRE_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Pre-award Spending Allowed
22	REVIEW_COMP	Character(1)	VARCHAR2(1) NOT NULL	Review Completed
23	BEGIN_DT	Date(10)	DATE	Begin Date
24	END_DT	Date(10)	DATE	End Date
25	APPROVAL_DATE	Date(10)	DATE	Approval Date
26	GR_SOURCE_FUNDING	Character(32)	VARCHAR2(32) NOT NULL	Guaranteed Source of Funding
27	INST_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	Is Change Of Institution
28	INSTRUCTION_URL	Character(250)	VARCHAR2(250) NOT NULL	Instruction URL
29	TITLE56	Character(56)	VARCHAR2(56) NOT NULL	TITLE56
30	TMPLT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Flag ; used to identify if a Proposal is a Template Proposal.
31	PROPOSAL_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Description
32	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
33	RANK_PRIO	Character(1)	VARCHAR2(1) NOT NULL	Rank H=High L=Low M=Medium
34	FOREIGN_APP_COMP	Character(1)	VARCHAR2(1) NOT NULL	Foreign Application/Component
35	FROM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create from Get Opportunity
36	GGOV_FLG	Character(1)	VARCHAR2(1) NOT NULL	GGOV_FLG
37	GM_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certifications Level A=Primary Project P=All Projects
38	GM_COMP_LVL	Character(1)	VARCHAR2(1) NOT NULL	Components Level A=Primary Project P=All Projects
39	GM_DEPT_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Departmentl Credits Level A=Primary Project P=All Projects
40	BILL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
41	BILL_AMT_EXP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
42	BILL_AMT_TIME	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
43	COST_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount
44	COST_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Expense
45	COST_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Time
46	ESTIMATED_AMOUNT	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount SCP - Added new label - Estimated Cost
47	ESTIMATED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Expense
48	ESTIMATED_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Time
49	HOURS_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Hours Option D=Start/End Date I=Hours W=Weeks Default Value: I
50	PM_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
51	MARGIN_PCT_EXP	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
52	MARGIN_PCT_TIME	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
53	NBR_OF_HOURS	Number(5,0)	INTEGER NOT NULL	Number of Hours
54	PROPOSED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Expense
55	PROPOSED_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Time
56	RESOURCE_TOTAL	Number(3,0)	SMALLINT NOT NULL	Resource Total
57	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
58	STD_HOURS_DAY	Number(5,2)	DECIMAL(4,2) NOT NULL	Standard Hours Day Default Value: 8
59	STD_HOURS_WK	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours Week Default Value: 40
60	THRESHOLD_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence %
61	CONF_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Confidence Level H=01 - High L=O3 - Low M=02 - Medium
62	WEEKLY_WEEKS	Number(3,0)	SMALLINT NOT NULL	Weeks
63	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
64	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
65	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Order Capture ID
66	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
67	PRODUCT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product Description
68	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
69	SALESREP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales Representative Name
70	CC_PHONE_EXTENSION	Character(33)	VARCHAR2(33) NOT NULL	Salesrep Phone Number
71	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
72	CY_CONVER_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Totla
73	GM_PROF_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Professional Credits Level A=Primary Project P=All Projects
74	GM_RSRC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Resources Level A=Primary Project P=All Projects
75	GM_VNDR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Subrecipients Level A=Primary Project P=All Projects
76	GM_WF_AUTO_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Workflow Active
77	PI_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	PI Change Indicator
78	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID
79	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
80	FA_COST_REQ	Character(1)	VARCHAR2(1) NOT NULL	FA Cost Requested
81	PGM_INCOME_PB	Character(1)	VARCHAR2(1) NOT NULL	Program Income
82	COST_SHR_SPNSR_REQ	Character(1)	VARCHAR2(1) NOT NULL	Required by Sponsor
83	APPROVAL_DT	Date(10)	DATE	Date of Approval
84	GM_SOURCE_INCOME	Character(30)	VARCHAR2(30) NOT NULL	Source
85	APPROVED_BY	Character(11)	VARCHAR2(11) NOT NULL	APPROVED_BY
86	PRIMARY_SPNSR_ID	Character(15)	VARCHAR2(15) NOT NULL	Primary Sponsor
87	DIRECT_PERS_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Direct - Personnel Cost
88	DIRECT_NONPER_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Direct - Non Personnel Cost
89	TOTAL_FA_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	TOTAL_FA_COST
90	TRACKING_NBR	Character(30)	VARCHAR2(30) NOT NULL	Tracking Number
91	TRACKING_NBR1	Character(30)	VARCHAR2(30) NOT NULL	Tracking Number
92	TOTAL_BUDGET_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	TOTAL_BUDGET_AMT
93	EFFORT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Effort Percentage
94	DAYS_ELAPSED	Number(4,0)	SMALLINT NOT NULL	Days Elapsed
95	PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Purpose
96	DESCR20A	Character(20)	VARCHAR2(20) NOT NULL	Short Description
97	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
98	CONTINUATION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Continuation Flag
99	MODULAR_FLG	Character(1)	VARCHAR2(1) NOT NULL	MODULAR_FLG
100	MULTI_PI	Character(1)	VARCHAR2(1) NOT NULL	Allow Multiple PI's
101	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
102	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.
103	DATE_FROM	Date(10)	DATE	Date From
104	DATE_TO	Date(10)	DATE	Date To
105	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
106	PROPOSAL_ID_SPNSR	Character(30)	VARCHAR2(30) NOT NULL	Sponsor Proposal ID
107	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
108	PROP_RECEIVED_DATE	Date(10)	DATE	Proposal Received Date
109	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
110	ACT_TITLE	Character(120)	VARCHAR2(120) NOT NULL	Activity Title
111	APP_IDNT	Character(30)	VARCHAR2(30) NOT NULL	Applicant Identifier
112	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
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	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress
119	REV_DEC_AWD	Character(1)	VARCHAR2(1) NOT NULL	Decrease Award
120	REV_DEC_DUR	Character(1)	VARCHAR2(1) NOT NULL	Decrease Duration
121	REV_INC_AWD	Character(1)	VARCHAR2(1) NOT NULL	Increase Award
122	REV_INC_DUR	Character(1)	VARCHAR2(1) NOT NULL	Increase Duration
123	REV_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Other(Specify)
124	REV_OTHER_SPC	Character(45)	VARCHAR2(45) NOT NULL	Other(Specify)
125	ACCOMPLISH_RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Accomplishment Based Renewal N=Doesn't depend on Accomplishme Y=Depends on Accomplishment
126	PRE_PROPOSAL_NBR	Character(25)	VARCHAR2(25) NOT NULL	Pre-Proposal Number
127	STTR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	STTR Fast Track
128	SUBMISSION_TITLE	Character(240)	VARCHAR2(240) NOT NULL	Submission Title
129	SUBMISSION_TYPE	Character(35)	VARCHAR2(35) NOT NULL	There will be 3 valid value for this field: Pre-Application, Application, Changed/Corrected Application
130	SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Report Submitted On - DateTime
131	DISCLOSURE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Disclosure Permission Statemen
132	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
133	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.
134	SBIR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	SBIR Fast Track
135	SBIRSTTRT_PHASE	Character(1)	VARCHAR2(1) NOT NULL	SBIR STTR Type 1=Phase 1 2=Phase 2 F=Fast Track
136	SCHEMA_URL	Character(250)	VARCHAR2(250) NOT NULL	Schema URL
137	SOLICITATION_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Solicitation Title
138	ST_APP_IDNT	Character(30)	VARCHAR2(30) NOT NULL	State Application Idetifier
139	ST_REC_DT	Date(10)	DATE	State Received Date
140	STATUS_DTTM	DateTime(26)	TIMESTAMP	05/13/02 EGS (CN#PL900-1): Added
141	LAST_VERSION_ID	Character(4)	VARCHAR2(4) NOT NULL	Last Version ID
142	PPSL_TO_CNTRCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposal To Contract D=Contract Generated N=Not Generated P=Pre-Sales Spending
143	PROPOSAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposal Checkbox G=Grants Proposal I=Internal Proposal S=Solicitation Proposal
144	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
145	PMO_TEAM_CD	Character(5)	VARCHAR2(5) NOT NULL	PMO Team Code
146	CURRENT_VERSION	Character(1)	VARCHAR2(1) NOT NULL	Current Version
147	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
148	BILL_COST_RT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Rate Options A=Bill and Cost Rows B=Bill Rows C=Cost Rows
149	PREV_INSTID	Character(5)	VARCHAR2(5) NOT NULL	Previous Institution
150	CFDA	Character(15)	VARCHAR2(15) NOT NULL	CFDA
151	WORKFLOW_BYPASS	Character(1)	VARCHAR2(1) NOT NULL	Work Flow By Pass
152	COMPETITION_ID	Character(100)	VARCHAR2(100) NOT NULL	Competition ID
153	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code