GM_PROPOS_TEO2

#	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	TITLE56	Character(56)	VARCHAR2(56) NOT NULL	TITLE56
31	TMPLT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Flag ; used to identify if a Proposal is a Template Proposal.
32	PROPOSAL_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Description
33	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
34	RANK_PRIO	Character(1)	VARCHAR2(1) NOT NULL	Rank H=High L=Low M=Medium
35	FOREIGN_APP_COMP	Character(1)	VARCHAR2(1) NOT NULL	Foreign Application/Component
36	FROM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Create from Get Opportunity
37	GGOV_FLG	Character(1)	VARCHAR2(1) NOT NULL	GGOV_FLG
38	GM_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certifications Level A=Primary Project P=All Projects
39	GM_COMP_LVL	Character(1)	VARCHAR2(1) NOT NULL	Components Level A=Primary Project P=All Projects
40	GM_DEPT_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Departmentl Credits Level A=Primary Project P=All Projects
41	BILL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
42	BILL_AMT_EXP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
43	BILL_AMT_TIME	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bill Amount
44	COST_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount
45	COST_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Expense
46	COST_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Cost Amount Time
47	ESTIMATED_AMOUNT	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount SCP - Added new label - Estimated Cost
48	ESTIMATED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Expense
49	ESTIMATED_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Estimated Amount Time
50	HOURS_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Hours Option D=Start/End Date I=Hours W=Weeks Default Value: I
51	PM_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
52	MARGIN_PCT_EXP	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
53	MARGIN_PCT_TIME	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Margin Percent
54	NBR_OF_HOURS	Number(5,0)	INTEGER NOT NULL	Number of Hours
55	PROPOSED_AMT_EXP	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Expense
56	PROPOSED_AMT_TIME	Number(27,3)	DECIMAL(26,3) NOT NULL	Proposed Amount Time
57	RESOURCE_TOTAL	Number(3,0)	SMALLINT NOT NULL	Resource Total
58	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
59	STD_HOURS_DAY	Number(5,2)	DECIMAL(4,2) NOT NULL	Standard Hours Day Default Value: 8
60	STD_HOURS_WK	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours Week Default Value: 40
61	THRESHOLD_PCT	Number(3,0)	SMALLINT NOT NULL	Confidence %
62	CONF_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Confidence Level H=01 - High L=O3 - Low M=02 - Medium
63	WEEKLY_WEEKS	Number(3,0)	SMALLINT NOT NULL	Weeks
64	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
65	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
66	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Order Capture ID
67	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
68	PRODUCT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product Description
69	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
70	SALESREP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sales Representative Name
71	CC_PHONE_EXTENSION	Character(33)	VARCHAR2(33) NOT NULL	Salesrep Phone Number
72	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
73	CY_CONVER_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Totla
74	GM_PROF_CR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Professional Credits Level A=Primary Project P=All Projects
75	GM_RSRC_LVL	Character(1)	VARCHAR2(1) NOT NULL	Resources Level A=Primary Project P=All Projects
76	GM_VNDR_LVL	Character(1)	VARCHAR2(1) NOT NULL	Subrecipients Level A=Primary Project P=All Projects
77	GM_WF_AUTO_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Workflow Active
78	PI_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	PI Change Indicator
79	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous 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	SUBMISSION_TITLE	Character(240)	VARCHAR2(240) NOT NULL	Submission Title
108	SUBMISSION_TYPE	Character(35)	VARCHAR2(35) NOT NULL	There will be 3 valid value for this field: Pre-Application, Application, Changed/Corrected Application
109	SUBMIT_DTTM	DateTime(26)	TIMESTAMP	Report Submitted On - DateTime
110	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
111	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
112	PROP_RECEIVED_DATE	Date(10)	DATE	Proposal Received Date
113	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
114	ADMIN_ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	Rolename of Approval Workflow Administrator
115	CREATION_DT	Date(10)	DATE	Creation Date
116	MAILING_INSTRUCT	Long Character	CLOB	Mailing Instructions
117	BUSINESS_UNIT_AWD	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
118	PREV_CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Previous Project/Grant
119	PREV_INSTID	Character(5)	VARCHAR2(5) NOT NULL	Previous Institution
120	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress
121	REV_DEC_AWD	Character(1)	VARCHAR2(1) NOT NULL	Decrease Award
122	REV_DEC_DUR	Character(1)	VARCHAR2(1) NOT NULL	Decrease Duration
123	REV_INC_AWD	Character(1)	VARCHAR2(1) NOT NULL	Increase Award
124	REV_INC_DUR	Character(1)	VARCHAR2(1) NOT NULL	Increase Duration
125	REV_OTHER	Character(1)	VARCHAR2(1) NOT NULL	Other(Specify)
126	REV_OTHER_SPC	Character(45)	VARCHAR2(45) NOT NULL	Other(Specify)
127	ACCOMPLISH_RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Accomplishment Based Renewal N=Doesn't depend on Accomplishme Y=Depends on Accomplishment
128	PRE_PROPOSAL_NBR	Character(25)	VARCHAR2(25) NOT NULL	Pre-Proposal Number
129	STTR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	STTR Fast Track
130	DISCLOSURE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Disclosure Permission Statemen
131	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
132	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.
133	SBIR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	SBIR Fast Track
134	SBIRSTTRT_PHASE	Character(1)	VARCHAR2(1) NOT NULL	SBIR STTR Type 1=Phase 1 2=Phase 2 F=Fast Track
135	SCHEMA_URL	Character(250)	VARCHAR2(250) NOT NULL	Schema URL
136	SOLICITATION_TITLE	Character(56)	VARCHAR2(56) NOT NULL	Solicitation Title
137	ST_APP_IDNT	Character(30)	VARCHAR2(30) NOT NULL	State Application Idetifier
138	ST_REC_DT	Date(10)	DATE	State Received Date
139	STATUS_DTTM	DateTime(26)	TIMESTAMP	05/13/02 EGS (CN#PL900-1): Added
140	LAST_VERSION_ID	Character(4)	VARCHAR2(4) NOT NULL	Last Version ID
141	PPSL_TO_CNTRCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposal To Contract D=Contract Generated N=Not Generated P=Pre-Sales Spending
142	PROPOSAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Proposal Checkbox G=Grants Proposal I=Internal Proposal S=Solicitation Proposal
143	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
144	PMO_TEAM_CD	Character(5)	VARCHAR2(5) NOT NULL	PMO Team Code
145	CURRENT_VERSION	Character(1)	VARCHAR2(1) NOT NULL	Current Version
146	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
147	BILL_COST_RT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Create Rate Options A=Bill and Cost Rows B=Bill Rows C=Cost Rows
148	INST_CHANGE_IND	Character(1)	VARCHAR2(1) NOT NULL	Is Change Of Institution
149	INSTRUCTION_URL	Character(250)	VARCHAR2(250) NOT NULL	Instruction URL
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