| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FLDDFN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
BO Search Role ID
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
FLDDFN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field Definition Type
DATE=Date
NUM=Numeric
STR=String
Default Value: STR
|
| 4 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RBQ_FLD_VW
|
| 5 |
FIELDNAME_UPPER |
Character(18) |
VARCHAR2(18) NOT NULL |
Uppercase Field
Prompt Table:
RBQ_FLD_VW
|
| 6 |
FIELDNAME_ALT |
Character(18) |
VARCHAR2(18) NOT NULL |
Alternate Character Field Name
Prompt Table:
RBQ_FLD_VW
|
| 7 |
FIELDNAME_ALTUPPER |
Character(18) |
VARCHAR2(18) NOT NULL |
Alternate Character Uppercase Field Name
Prompt Table:
RBQ_FLD_VW
|
| 8 |
FIELDNAME_DISPLAY |
Character(18) |
VARCHAR2(18) NOT NULL |
Display Field Name
Prompt Table:
RBQ_FLD_VW
|
| 9 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 10 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 11 |
SELECT_XLAT |
Character(1) |
VARCHAR2(1) NOT NULL |
push button used for selecting different translate values.
Y/N Table Edit
|
| 12 |
YES_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator flag -- Yes (Y) or No (N)
N=No
Y=Yes
Y/N Table Edit
|
| 13 |
RECNAME1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name 1
Prompt Table:
PSRECDEFN
|
| 14 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
Prompt Table:
RBQ_RECFLD_VW
|
| 15 |
BO_NAME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
BO Name Flag
Y/N Table Edit
Default Value: N
|
| 16 |
FLDDFN_ID_FIRST |
Character(20) |
VARCHAR2(20) NOT NULL |
BO Search Role ID
|
| 17 |
FLDDFN_ID_LAST |
Character(20) |
VARCHAR2(20) NOT NULL |
BO Search Role ID
|
| 18 |
DEFAULT_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Default Method Name
CNRY=Country
CURR=Currency
LANG=Language Code
SET=SETID
|
| 19 |
PARSER_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Parser Method Name
NFMT=Unformatted
|
| 20 |
MAP_REFERENCE |
Character(24) |
VARCHAR2(24) NOT NULL |
Mapping Reference
|
| 21 |
ALT_CHAR_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Character Enabled
Y/N Table Edit
|
| 22 |
FLDDFN_ID_ALT |
Character(20) |
VARCHAR2(20) NOT NULL |
BO Search Role ID
Prompt Table:
RBQ_FLDDFNAL_VW
|
| 23 |
FIELDNAME_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Name Field Name
Prompt Table:
RBQ_FLD_VW
|
| 24 |
FIELDNAME_ABE |
Character(18) |
VARCHAR2(18) NOT NULL |
ABE Field Name
Prompt Table:
RBQ_FLD_VW
|
| 25 |
DEFAULT_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Default Operator
1=begins with
2=contains
3==
4=not =
5=<
6=<=
7=>
8=>=
|
| 26 |
LANG_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Related Language Enabled
Y/N Table Edit
|
| 27 |
ADDRESS_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Address Field
B=Bill To
S=Ship To
Y/N Table Edit
Default Value: N
|
| 28 |
ALLOW_OP_BEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Begins With
Y/N Table Edit
Default Value: N
|
| 29 |
ALLOW_OP_CONT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Contains
Y/N Table Edit
Default Value: N
|
| 30 |
ALLOW_OP_EQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Equals
Y/N Table Edit
Default Value: N
|
| 31 |
ALLOW_OP_NEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Not Equal
Y/N Table Edit
Default Value: N
|
| 32 |
ALLOW_OP_LT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Less Than
Y/N Table Edit
Default Value: N
|
| 33 |
ALLOW_OP_LTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Less Than or Equal
Y/N Table Edit
Default Value: N
|
| 34 |
ALLOW_OP_GT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Greater Than
Y/N Table Edit
Default Value: N
|
| 35 |
ALLOW_OP_GTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Greater Than or Equal
Y/N Table Edit
Default Value: N
|
| 36 |
RC_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 37 |
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
|
| 38 |
SYSD_APPLICATION02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Services
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 39 |
SYSD_APPLICATION03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Telecommunications
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 40 |
SYSD_APPLICATION04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Government
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 41 |
SYSD_APPLICATION05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Energy
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 42 |
SYSD_APPLICATION06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 43 |
SYSD_APPLICATION07 |
Character(1) |
VARCHAR2(1) NOT NULL |
High Technology
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 44 |
SYSD_APPLICATION08 |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 45 |
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
|
| 46 |
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
|
| 47 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 48 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 49 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 50 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 51 |
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.
|
| 52 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|