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