| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RC_NONVW
|
| 4 |
FORECAST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Forecast Name
Prompt Table:
RSF_FCAST_ID
|
| 5 |
FORECAST_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Category
R=Revenue Forecast
S=Shadow Forecast
|
| 6 |
TIMEFRAME_PERIOD |
Character(32) |
VARCHAR2(32) NOT NULL |
Time Frame
Prompt Table:
RSF_FCAST
|
| 7 |
FORECAST_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Type of forecast, eg 'Open' or 'closed'
Prompt Table:
RSF_FCAST_TYPE
|
| 8 |
NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
Prompt Table:
RC_CUST_TYPE_VW
|
| 9 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
|
| 10 |
FROM_DATE |
Date(10) |
DATE NOT NULL |
From Date
|
| 11 |
THRU_DATE |
Date(10) |
DATE NOT NULL |
Through Date
|
| 12 |
RC_PRIORITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Priority
Prompt Table:
RC_PRIORITY_TBL
|
| 13 |
RC_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Status
Prompt Table:
RC_STATUS_TBL
|
| 14 |
CASE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Type
Prompt Table:
RC_CASETYPE_TBL
|
| 15 |
RC_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
CallCenter Category. Used in HD.
|
| 16 |
RC_DETAIL |
Character(5) |
VARCHAR2(5) NOT NULL |
Detail field on HD Case. Used in Quick Code.
|
| 17 |
RC_FREQ_USED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frequently used flag.
|
| 18 |
RC_BUS_PROCESS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Business Process ID used in Business Process tracking.
|
| 19 |
REGION |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used to identify the Sales Region.
|
| 20 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
|
| 21 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 22 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|
| 23 |
RC_SOLVED_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Solved Count Field in Solution
Default Value: 10
|
| 24 |
SOLUTION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Solution ID
|
| 25 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 26 |
TERRITORY_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Territory ID
|
| 27 |
CASE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
|
| 28 |
AGREEMENT_TYPE |
Number(9,0) |
DECIMAL(9) NOT NULL |
This field represents the type of the agreement.
|
| 29 |
ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
Prompt Table:
RC_ASSIGN_VW
|
| 30 |
CASE_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
RC_CNT_PHD_VW2
|
| 31 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 32 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Flag for Consumer or Company
|
| 33 |
CUSTOMER_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.
|
| 34 |
CUSTOMER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Type
1=User 1
2=User 2
3=User 3
4=User 4
|
| 35 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 36 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 37 |
OPPORTUNITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Opportunity ID
Prompt Table:
RSF_OPPORTUNITY
|
| 38 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
Prompt Table:
RC_CUST_VW
|
| 39 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RC_ASSIGN_VW
|
| 40 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
Prompt Table:
RC_WORKER_VW
|