| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 2 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 3 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
PROPOSAL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Proposal ID
|
| 8 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 9 |
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
|
| 10 |
TITLE56 |
Character(56) |
VARCHAR2(56) NOT NULL |
TITLE56
|
| 11 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 12 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 13 |
END_DT |
Date(10) |
DATE |
End Date
|
| 14 |
DAYS_ELAPSED |
Number(4,0) |
SMALLINT NOT NULL |
Days Elapsed
|
| 15 |
GR_INTELL_PROP_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Intellectual Property Reported
Default Value: N
|
| 16 |
PROPOSAL_RFP_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Solicitation/RFP Number
|
| 17 |
SOLICITATION_TITLE |
Character(56) |
VARCHAR2(56) NOT NULL |
Solicitation Title
|
| 18 |
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.
|
| 19 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 20 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_CNTR_SRCH_VW
|
| 21 |
FOREIGN_APP_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Application/Component
|
| 22 |
PI_CHANGE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
PI Change Indicator
|
| 23 |
FA_COST_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
FA Cost Requested
|
| 24 |
REF_AWD_NUMBER |
Character(25) |
VARCHAR2(25) NOT NULL |
Reference Award Number
|
| 25 |
PROPOSAL_ID_SPNSR |
Character(30) |
VARCHAR2(30) NOT NULL |
Sponsor Proposal ID
|
| 26 |
RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewal in Progress
Y/N Table Edit
|
| 27 |
ACCOMPLISH_RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Accomplishment Based Renewal
N=Doesn't depend on Accomplishme
Y=Depends on Accomplishment
|
| 28 |
PGM_INCOME_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Income
|
| 29 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 30 |
REF_AWD_NUM2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Reference Award
|
| 31 |
VERSION_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID
|
| 32 |
DISCLOSURE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Disclosure Permission Statemen
Y/N Table Edit
|
| 33 |
SBIR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
SBIR Fast Track
Y/N Table Edit
|
| 34 |
STTR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
STTR Fast Track
Y/N Table Edit
|
| 35 |
SUBMIT_DTTM |
DateTime(26) |
TIMESTAMP |
Report Submitted On - DateTime
|
| 36 |
CFDA |
Character(15) |
VARCHAR2(15) NOT NULL |
CFDA
|
| 37 |
OPPORTUNITY_NUM |
Character(100) |
VARCHAR2(100) NOT NULL |
Opportunity Number
|
| 38 |
INST_CHANGE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Change Of Institution
|
| 39 |
PREV_INSTID |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Institution
|
| 40 |
SBIRSTTRT_PHASE |
Character(1) |
VARCHAR2(1) NOT NULL |
SBIR STTR Type
1=Phase 1
2=Phase 2
F=Fast Track
|
| 41 |
PRE_TRACK_NUM |
Character(240) |
VARCHAR2(240) NOT NULL |
Tracking Number
|
| 42 |
TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracking Number
|