| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
|
| 2 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 3 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Panel Name (see PSPNLDEFN).
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RB_RECFIELD_ALT
|
| 7 |
DEEP_QUERY_OPERAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by Configurable Search setup to assign IN or EXISTS operand to a given deep query.
E=EXISTS
I=IN
Default Value: E
|
| 8 |
RB_FIELD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
It holds field type definition. See translate values for details.
P=Profile Field
R=Record Field
Default Value: R
|
| 9 |
FIELDNUM |
Number(4,0) |
SMALLINT NOT NULL |
Field Number
Default Value: 1
|
| 10 |
RECNAME_ALT |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name
Prompt Table:
PSRECDEFN
|
| 11 |
RA_PROFILE_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Profile - profile ID
Prompt Table:
RA_PROF_ACT_VW
|
| 12 |
RA_ATTRIBUTE_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Profile / Attribute ID
Prompt Table:
RB_PRFL_FLD_VW
|
| 13 |
PRFL_BO_ID_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Profile BO ID Field
Prompt Table:
PRFL_BO_ID_VW
|
| 14 |
RA_ATTRIB_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Profile - attribute type
C1=Choose One
C1R=Choose One (with Rating)
CM=Choose Many
DATE=Date
DEC=Decimal
FA=File
INT=Integer
LT=Text Block
PRMT=Map Field Choice to Prompt
TEXT=Text
TIME=Time
YN=Yes/No
|
| 15 |
LABEL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table:
RB_DBFLDLABL_VW
|
| 16 |
LBLTYPE_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Type
0=None
1=Text
2=RFT Short
3=RFT Long
4=Xlat Short
5=Xlat Long
6=Image
7=Message Catalog (Not Impl.)
Default Value: 2
|
| 17 |
PROMPT_EDITTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit
2=Prompt With No Edit
3=Translate Table
4=Yes/No
5=BO Search
6=Constant Value
7=Prompt With Edit
8=Dropdown List
Default Value: 1
|
| 18 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
PSRECDEFN
|
| 19 |
DROPDOWN_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Description Field
Prompt Table:
RB_FLT_DROP_VW
|
| 20 |
FILTER_CONSTANT |
Character(100) |
VARCHAR2(100) NOT NULL |
Constant Value
|
| 21 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 22 |
CB_DISPLAY_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Only
Y/N Table Edit
Default Value: N
|
| 23 |
CB_HIDDEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Hidden
Y/N Table Edit
Default Value: N
|
| 24 |
CB_USE_SEARCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Use as Search Field
Y/N Table Edit
Default Value: Y
|
| 25 |
CB_USE_RESULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in Search Results
Y/N Table Edit
Default Value: Y
|
| 26 |
FILTER_FLD_DSP_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Type
A=Always Show in Results
H=Hide When Exact Match
Default Value: A
|
| 27 |
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
|
| 28 |
ADV_BASIC_LKP_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Common Object........................................................
A=Advanced Lookup
B=Basic Lookup
|
| 29 |
DISPLAY_CNTRL_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
BO_ID Search Field
Prompt Table:
RB_RECFIELD_ALT
|
| 30 |
DISPLAY_CNTRL_FLD2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Role Type Search Field
Prompt Table:
RB_RECFIELD_ALT
|
| 31 |
SETCNTRLFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table:
PSRECFIELDDB
|
| 32 |
BU_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit Field Name
Prompt Table:
PSRECFIELDDB
|
| 33 |
EFFDT_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Effective Date Field Name
Prompt Table:
PSRECFIELDDB
|
| 34 |
KEY1_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 1 Field Name
Prompt Table:
PSRECFIELDDB
|
| 35 |
KEY2_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 2 Field Name
Prompt Table:
PSRECFIELDDB
|
| 36 |
KEY3_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 3 Field Name
Prompt Table:
PSRECFIELDDB
|
| 37 |
MESSAGE_SET_NBR |
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_VW
|
| 38 |
COMPONENT_DRILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Transfer Button
Y/N Table Edit
|
| 39 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
RB_MSGCAT_VW
|
| 40 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
RB_CLASS_VW
|
| 41 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Default Value: BO_SEARCH
|
| 42 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
RB_CLASSPATH_VW
|
| 43 |
RELATED_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Related Directory Search Field
Prompt Table:
RB_FLT_FIELD_VW
|
| 44 |
CUST_CONTACT_RB |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer or Contact?
C=Customer
N=Neither
R=Contact
S=Site
Default Value: C
|
| 45 |
CUST_CONTACT_RB2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer or Contact?
C=Customer
N=Neither
R=Contact
S=Site
|
| 46 |
RA_OPERATORS |
Character(40) |
VARCHAR2(40) NOT NULL |
Filter Search Definition Operator value field
|
| 47 |
RA_DEFAULT_OPER |
Character(2) |
VARCHAR2(2) NOT NULL |
Filter Search Definition Default Operator value field
|
| 48 |
RELATED_DISP_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| 49 |
MESSAGE_SET_NBR_TX |
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_TX_VW
|
| 50 |
MESSAGE_NBR_TX |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
RB_MSGCAT_TX_VW
|
| 51 |
RB_UNHIDE |
Character(254) |
VARCHAR2(254) NOT NULL |
Unhide Related Fields
Prompt Table:
RB_FLT_RELF_VW
|
| 52 |
UPPER_SEARCH_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Uppercase Search Field
Prompt Table:
RB_UPPR_SRCH_VW
|
| 53 |
RETURN_BO_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Identifying Information
Y/N Table Edit
Default Value: Y
|
| 54 |
RSEC_OBJECT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Security Object ID used for defining application security objects.
Prompt Table:
RSEC_MEM_OBJ_VW
|
| 55 |
ALT_CHAR_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Character Enabled
Y/N Table Edit
Default Value: N
|
| 56 |
RECNAME_SECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Section Record Name
Prompt Table:
RBQ_ADPT_SEC_VW
|
| 57 |
FIELD_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Field Sequence Number
Prompt Table:
RBQ_ADPT_FLD_VW
|
| 58 |
PARTNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Partner
Y/N Table Edit
Default Value: N
|
| 59 |
PARTNER_USER |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide when User is a Partner
Y/N Table Edit
Default Value: N
|
| 60 |
UID20 |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 61 |
RC_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 62 |
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
|
| 63 |
SYSD_APPLICATION02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Services
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 64 |
SYSD_APPLICATION03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Telecommunications
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 65 |
SYSD_APPLICATION04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Government
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 66 |
SYSD_APPLICATION05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Energy
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 67 |
SYSD_APPLICATION06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 68 |
SYSD_APPLICATION07 |
Character(1) |
VARCHAR2(1) NOT NULL |
High Technology
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 69 |
SYSD_APPLICATION08 |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 70 |
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
|
| 71 |
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
|
| 72 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 73 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 74 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 75 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 76 |
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.
|
| 77 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|