| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW2
|
| 2 |
NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 4 |
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
|
| 5 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 6 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 7 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
|
| 8 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 9 |
LC_CNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
The local country.
Prompt Table:
LC_CNTRY_VW
|
| 10 |
ALT_CHAR_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Character Enabled
Y/N Table Edit
Default Value: N
|
| 11 |
DR_CR_VISIBLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Display separate DR/CR
Y/N Table Edit
Default Value: N
|
| 12 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Used to store an identification code for the requestor of material.
|
| 13 |
RC_CASE_QRY_ROWS |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Number of Rows
Default Value: 0
|
| 14 |
ROLE_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type ID
Prompt Table:
RX_CUST_ROLE_VW
|
| 15 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
Prompt Table:
RD_OPR_CUST_VW
|
| 16 |
REL_TYPE_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Relationship Type ID
Prompt Table:
RD_PTNR_REL_VW
|
| 17 |
FREQ_USED_SOLN_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Total Count of Frequently Used Solutions
Default Value: 10
|
| 18 |
BUSINESS_UNIT_RO |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Capture Business Unit
Prompt Table:
SP_BU_RO_OPRVW
|
| 19 |
BUSINESS_UNIT_RSF |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit for Creating Sales Lead
Prompt Table:
SP_BU_RSF_OPRVW
|
| 20 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
RSF_TREE_VW
|
| 21 |
ASSIGN_GROUP |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used to specify assignment group name for Territory assignment.
Prompt Table:
RSF_ASSIGN_BUVW
Set Control Field: BUSINESS_UNIT_RSF
|
| 22 |
FLDDELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Delimiter
Default Value: ,
|
| 23 |
RC_AUTO_EXEC_QRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto execute saved search ?
Y/N Table Edit
Default Value: Y
|
| 24 |
RC_PIN_SIN_SRCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically search PIN & SIN
Y/N Table Edit
Default Value: N
|
| 25 |
DISP_START_HOUR |
Character(4) |
VARCHAR2(4) NOT NULL |
This field represents the dispatch board start hour for display purposes
0000=12:00am
0100=1:00am
0200=2:00am
0300=3:00am
0400=4:00am
0500=5:00am
0600=6:00am
0700=7:00am
0800=8:00am
0900=9:00am
1000=10:00am
1100=11:00am
1200=12:00pm
1300=1:00pm
1400=2:00pm
1500=3:00pm
1600=4:00pm
1700=5:00pm
1800=6:00pm
1900=7:00pm
2000=8:00pm
2100=9:00pm
2200=10:00pm
2300=11:00pm
|
| 26 |
REGION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the region id value.
|
| 27 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
|
| 28 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
Default Value: GBL
|
| 29 |
MOBILE_DEFAULT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
MOBILE_DEFAULT_ID
Prompt Table:
RDM_MOBILE_DFLT
|
| 30 |
PIM_DEFAULT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Used by PIM Preferences
Prompt Table:
PIM_PREFERENCES
|
| 31 |
START_HOUR |
Time(15) |
TIMESTAMP |
Time Field to select the starting hour at which the Dispatch Board will start displaying information.
|
| 32 |
AUTO_INSERT_CLIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Insert into "My Contacts" flag
N=No
Y=Yes
Default Value: N
|
| 33 |
VIEW_BY_WORKLIST |
Character(30) |
VARCHAR2(30) NOT NULL |
View by worklist name
|
| 34 |
VIEW_BY_TRANSACT |
Character(30) |
VARCHAR2(30) NOT NULL |
View by worklist transaction type
|
| 35 |
DATE_FILTER_WL |
Character(1) |
VARCHAR2(1) NOT NULL |
Date filter for worklist
0=All
1=Last 1 Day
2=Today
3=Last 3 Days
4=Current Week
5=Last 5 Days
6=Current Month
7=Last 7 Days
|
| 36 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 37 |
WLM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether this wealth management
Y/N Table Edit
Default Value: N
|
| 38 |
SHOW_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show All Detail
|
| 39 |
RB_DUP_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
This is the duplicate parameter set field.
Prompt Table:
RB_DUP_PARMS
|
| 40 |
TSK_DFLT_FLT |
Character(60) |
VARCHAR2(60) NOT NULL |
Pre defined Filter drop-down. Used by Task Management.
Default Value: A,ALL
|
| 41 |
FOLDER_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used by the CRM Worklist to store either the type of System folder, unique folder ID, or group worklist name.
|
| 42 |
USR_INTERFACE_MODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used for storing interface mode information
SBYS=Steb-by-step
SWIZ=Super wizard
TAB=Tabular
XPRT=Expert
|
| 43 |
RESPBILITY_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
EBS Responsibility Name
|
| 44 |
RESPBILITY_APP |
Character(60) |
VARCHAR2(60) NOT NULL |
EBS Responsibility Application Name
|
| 45 |
SECURITY_GRP_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
EBS Security Group Name
|
| 46 |
ORGANIZATION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
EBS Organization ID
|
| 47 |
PRODUCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
Prompt Table:
SP_SETID_NONVW
|
| 48 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
RC_PROD1_VW
|
| 49 |
CATEGORY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Category setid value.
Prompt Table:
SP_SETID_NONVW
|
| 50 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
Prompt Table:
RC_CATTEGRY_VW
|
| 51 |
LIBRARY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for solution library setid value.
Prompt Table:
SP_SETID_NONVW
|
| 52 |
LIBRARY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Solution Library ID or Troubleshooting Guide ID
Prompt Table:
RC_LIB_VW
|
| 53 |
DAYS_BEFORE_TODAY |
Number(5,0) |
INTEGER NOT NULL |
new fields for contact management report
|
| 54 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 55 |
BUSINESS_UNIT_SLA |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case SLA operational dashboard chart.
Prompt Table:
SP_RC_VR_SUPVW
|
| 56 |
HD_BU_SLA |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case SLA operational dashboard chart.
Prompt Table:
SP_RC_VR_HDVW
|
| 57 |
HE_BU_SLA |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case SLA operational dashboard chart.
Prompt Table:
SP_RC_VR_HEVW
|
| 58 |
HHD_BU_SLA |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case SLA operational dashboard chart.
Prompt Table:
SP_RC_VR_HHDVW
|
| 59 |
VIEW_BY_CHART |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 60 |
VIEW_BY_CHART_HD |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 61 |
VIEW_BY_CHART_HE |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 62 |
VIEW_BY_CHART_HHD |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 63 |
SLA_DATE_RANGE |
Character(4) |
VARCHAR2(4) NOT NULL |
Feild for selecting the date range to search for SLA chart data.
DAY=Last 1 Day
MONT=Last 30 Days
WEEK=Last 7 Days
Default Value: MONT
|
| 64 |
BUSINESS_UNIT_BKLG |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_SUPVW
|
| 65 |
BUSINESSUNIT_HDBLG |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_HDVW
|
| 66 |
BUSINESSUNIT_HEBLG |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_HEVW
|
| 67 |
BUSINESSUNIT_HHBLG |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_HHDVW
|
| 68 |
VIEW_BY_BACKLOG |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 69 |
VIEW_BY_BACKLOG_HD |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 70 |
VIEW_BY_BACKLOG_HE |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 71 |
VIEW_BY_BACKLOG_HH |
Character(4) |
VARCHAR2(4) NOT NULL |
View by dropdown list box for Services charts.
PRIO=Priority
STAT=Status
Default Value: PRIO
|
| 72 |
RC_MANAGER |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGSUPBK_V
|
| 73 |
RC_HE_MANAGER |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHEBK_V
|
| 74 |
RC_HD_MANAGER |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHDBK_V
|
| 75 |
RC_HHD_MANAGER |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHHDBK_V
|
| 76 |
RC_HHDMANAGER_SLA |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHHDSLA_V
|
| 77 |
RC_HDMANAGER_SLA |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHDSLA_V
|
| 78 |
RC_HEMANAGER_SLA |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHESLA_V
|
| 79 |
RC_MANAGER_SLA |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGSUPSLA_V
|
| 80 |
RC_HHDMANAGER_ARIV |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHHDARR_V
|
| 81 |
RC_HDMANAGER_ARIV |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHDARR_V
|
| 82 |
RC_HEMANAGER_ARIV |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGHEARR_V
|
| 83 |
RC_MANAGER_ARIV |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_PGMGSUPARR_V
|
| 84 |
BUSINESS_UNIT_ARR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_SUPVW
|
| 85 |
BU_ARR_HD |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_HDVW
|
| 86 |
BU_ARR_HE |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_HEVW
|
| 87 |
BU_ARR_HHD |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit field for Case Backlog operational dashboard chart.
Prompt Table:
SP_RC_VR_HHDVW
|
| 88 |
ARR_DATE_RANGE |
Character(4) |
VARCHAR2(4) NOT NULL |
date range selector for populating charts by date.
DAY=1 Day
MONT=30 Days
WEEK=7 Days
Default Value: MONT
|
| 89 |
ARR_DATE_RANGE_HD |
Character(4) |
VARCHAR2(4) NOT NULL |
date range selector for populating charts by date.
DAY=1 Day
MONT=30 Days
WEEK=7 Days
Default Value: MONT
|
| 90 |
ARR_DATE_RANGE_HE |
Character(4) |
VARCHAR2(4) NOT NULL |
date range selector for populating charts by date.
DAY=1 Day
MONT=30 Days
WEEK=7 Days
Default Value: MONT
|
| 91 |
ARR_DATE_RANGE_HHD |
Character(4) |
VARCHAR2(4) NOT NULL |
date range selector for populating charts by date.
DAY=1 Day
MONT=Thirty Days
WEEK=Seven Days
Default Value: MONT
|