| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
|
| 2 |
BCSCROLL |
Number(3,0) |
SMALLINT NOT NULL |
Scroll level
|
| 3 |
BCITEMPARENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Parent Collection Name
|
| 4 |
BCITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
BC Item Logical Name
|
| 5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 7 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 8 |
BCSCROLLNUM |
Number(3,0) |
SMALLINT NOT NULL |
BC Scroll Number
|
| 9 |
BCSCROLLNAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Scroll name
|
| 10 |
INCLUDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include flag (Yes or No)
Y/N Table Edit
|
| 11 |
SHOW_IN_HEADER |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in Header
Y/N Table Edit
|
| 12 |
LABEL_ID_HDR |
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
|
| 13 |
LABEL_TYPE_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Type
1=RFT Short
2=RFT Long
|
| 14 |
PROMPTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Prompted?
Y/N Table Edit
Default Value: N
|
| 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.
Default Value: 1
Prompt Table:
RB_DBFLDLABL_VW
|
| 16 |
RB_LABEL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Type
1=RFT Short
2=RFT Long
|
| 17 |
DEFAULT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Current Value
Y/N Table Edit
|
| 18 |
RB_PASSWORD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Password Protected?
Y/N Table Edit
Default Value: N
|
| 19 |
APPEND_CLONE_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Append Clone Number?
A=Yes - Always
M=Yes - Only when more than one
N=No
Default Value: N
|
| 20 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 21 |
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
|
| 22 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
PSRECDEFN
|
| 23 |
DROPDOWN_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Description Field
Prompt Table:
RB_FLT_DROP_VW
|