| # |
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 |
SUB_PROP_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
SUB_PROP_NBR
|
| 9 |
ROW_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Row_Number
|
| 10 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 11 |
TITLE56 |
Character(56) |
VARCHAR2(56) NOT NULL |
TITLE56
|
| 12 |
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.
|
| 13 |
BUSINESS_UNIT_PROP |
Character(5) |
VARCHAR2(5) NOT NULL |
Proposal Business Unit
|
| 14 |
PROPOSAL_ID_TO |
Character(25) |
VARCHAR2(25) NOT NULL |
Proposal ID
|
| 15 |
SUB_PROP_NBR_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Sub Proposal ID To
|
| 16 |
TOTAL_BUDGET_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
TOTAL_BUDGET_AMT
|
| 17 |
TOTAL_DIRECT_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
TOTAL_DIRECT_COST
|
| 18 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 19 |
END_DT |
Date(10) |
DATE |
End Date
|
| 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 |
VERSION_ID_TO |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID To
|
| 22 |
VERSION_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Version ID
|
| 23 |
APPT_TYPE_MTH_CAL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Calendar Appointment Months
|
| 24 |
APPT_TYPE_MTH_ACAD |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Academic Appointment Months
|
| 25 |
APPT_TYPE_MTH_SUMR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Summer Appointment Months
|
| 26 |
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
|
| 27 |
ROW_NUMBER_TO |
Number(3,0) |
SMALLINT NOT NULL |
Personnel/Professional Number
|