| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
RC_PNLGRP_VW
|
| 2 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
Default Value: GBL
|
| 3 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
PSPNLGROUP_VW
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
RA_FILTER_PERS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow User Personalization?
Y/N Table Edit
Default Value: Y
|
| 8 |
RA_FILTER_SAVE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Saved Filter Option
N=No
Y=Yes
Default Value: Y
|
| 9 |
RA_FILTER_FLDS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter Field Option
N=No
Y=Yes
Default Value: Y
|
| 10 |
RA_FILTER_FILL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter Options
D=Default
L=Last
N=No
Default Value: L
|
| 11 |
USER_CONFIG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow user to decide
Y/N Table Edit
Default Value: Y
|
| 12 |
FILTER_SECURE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Is this filter secured?
Y/N Table Edit
Default Value: N
|
| 13 |
FILTER_NORULES_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Let user see search results
Y/N Table Edit
Default Value: N
|
| 14 |
DATASETNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Dataset Name
Prompt Table:
EOEC_DATASET
|
| 15 |
FILTER_BUTTON_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Button Position
B=Bottom
T=Top
X=Both Top and Bottom
Default Value: B
|
| 16 |
FILTER_DEBUG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show the Search SQL Statement
Y/N Table Edit
Default Value: N
|
| 17 |
FILTER_CACHE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Caching
Y/N Table Edit
Default Value: Y
|
| 18 |
SEARCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
When No Search Criteria Input
A=Search for everything
E=Show error message, No search
Default Value: A
|
| 19 |
UPDATE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Data using CI
Y/N Table Edit
Default Value: N
|
| 20 |
BCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table:
PSBCDEFN
|
| 21 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
RBC_APPCLASS_VW
|
| 22 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table:
RBC_APPRTPATH_V
|
| 23 |
FILTER_MAX_ROWS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Maximum Number of Rows to Show
|
| 24 |
HIGHER_KEYS_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Record for Cascading Keys
Prompt Table:
HIGH_KEY_REC_VW
|
| 25 |
RB_CI_ERROR_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Errors Handling for CI
A=App Class to Handle Errors
N=No Error Handling
P=Show Errors and Proceed
S=Show Errors and Stop
Default Value: S
|
| 26 |
SHOW_MORE_DATA_TXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show More Rows Found Help Text
Y/N Table Edit
Default Value: N
|
| 27 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Default Value: 17833
|
| 28 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 739
|
| 29 |
MSG_TXT_OR_EXPLAIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Text
E=Explanation
T=Text
Default Value: E
|
| 30 |
HELPTEXT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used by Configurable Search setup to determine if the informational line above the results grid to show search criteria is displayed at runtime.
Y/N Table Edit
Default Value: N
|
| 31 |
RECNAME_HELPTEXT |
Character(15) |
VARCHAR2(15) NOT NULL |
Recname
Prompt Table:
PSRECDEFN
|
| 32 |
FIELDNAME_HELPTEXT |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
Prompt Table:
RB_RECFIELD_VW
|
| 33 |
ADV_BASIC_LOOKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Advanced / Basic Lookup.................
A=Advanced Lookup Only
B=Basic Lookup Only
C=Both Adv and Basic Available
Default Value: C
|
| 34 |
ADV_BASIC_LKP_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Common Object........................................................
A=Advanced Lookup
B=Basic Lookup
Default Value: A
|
| 35 |
COLLAPSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Collapsed
Y/N Table Edit
Default Value: N
|
| 36 |
COLLAPSE_SECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Collapse Section
Y/N Table Edit
Default Value: N
|
| 37 |
MENUNAME_TRN |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name
Prompt Table:
RB_MENUDEFN_VW
|
| 38 |
BARNAME_TRN |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table:
RB_MENUBAR_VW
|
| 39 |
ITEMNAME_TRN |
Character(60) |
VARCHAR2(60) NOT NULL |
Menu/Bar/Item
Prompt Table:
RB_MENUITEM_VW
|
| 40 |
COMPONENT_TRN |
Character(18) |
VARCHAR2(18) NOT NULL |
Trasaction Component
|
| 41 |
PAGE_TRN |
Character(30) |
VARCHAR2(30) NOT NULL |
Transfer Page
Prompt Table:
RB_PNLGROUP_VW
|
| 42 |
TRANSFER_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Mode
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update/Display
Default Value: U
|
| 43 |
MESSAGE_NBR_SRCH |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
RB_MSGCAT_SR_VW
|
| 44 |
MESSAGE_SET_NBR_SR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
RB_MSGSET_SR_VW
|
| 45 |
SORTCODE |
Character(254) |
VARCHAR2(254) NOT NULL |
BOM Sort Code
|
| 46 |
RESULTS_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Results Grid Record Name
Prompt Table:
RB_FLT_GRID_VW
|
| 47 |
RSEC_APP_SCRTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used on configurable search definition to determine if the definition should be used for application security.
Y/N Table Edit
Default Value: N
|
| 48 |
RECNAME_NO_ROWS |
Character(15) |
VARCHAR2(15) NOT NULL |
No Rows Found Record Name
Prompt Table:
PSRECDEFN
|
| 49 |
FIELDNAME_NO_ROWS |
Character(18) |
VARCHAR2(18) NOT NULL |
No Rows Found Field Name
Prompt Table:
RB_NOWROWS_VW
|
| 50 |
RECNAME_RSLT_GB |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Results Record Name
Prompt Table:
PSRECDEFN
|
| 51 |
FIELDNAME_RSLT_GB |
Character(18) |
VARCHAR2(18) NOT NULL |
Search Results Field Name
Prompt Table:
RB_RSLT_GB_VW
|
| 52 |
ADAPTER_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Adapter ID
Prompt Table:
RB_ADPTR_VW
|
| 53 |
PARTNER_INST_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Partner Installation Field
Prompt Table:
RB_FLD_LABEL_VW
|
| 54 |
AUTOSAVE_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Recent Search Feature enablement switch
N=No
Y=Yes
Default Value: N
|
| 55 |
FILTER_NO_CRITERIA |
Number(2,0) |
SMALLINT NOT NULL |
Number of maximum recent searches allowed for a component
Default Value: 5
|
| 56 |
RSE_SIMPLE_OR_VERB |
Character(1) |
VARCHAR2(1) NOT NULL |
Recent Search naming option for Configurable Search
S=Simple
V=Verbose
Default Value: S
|
| 57 |
UID20 |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 58 |
RC_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 59 |
SYSD_APPLICATION01 |
Character(1) |
VARCHAR2(1) NOT NULL |
PS CRM Core
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 60 |
SYSD_APPLICATION02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Services
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 61 |
SYSD_APPLICATION03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Telecommunications
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 62 |
SYSD_APPLICATION04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Government
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 63 |
SYSD_APPLICATION05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Energy
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 64 |
SYSD_APPLICATION06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 65 |
SYSD_APPLICATION07 |
Character(1) |
VARCHAR2(1) NOT NULL |
High Technology
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 66 |
SYSD_APPLICATION08 |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 67 |
SYSD_APPLICATION09 |
Character(1) |
VARCHAR2(1) NOT NULL |
System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 68 |
SYSD_APPLICATION10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Application 10
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 69 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 70 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 71 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 72 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 73 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 74 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 75 |
FILTER_DEBUG_USER |
Long Character |
CLOB |
Only These Users May See SQL
|