RB_CLONE_DUMMY3(SQL Table) |
Index Back |
|---|---|
Dummy Record for CloningDummy Record for Cloning. This record is used for a placeholder for a scroll area/grid on the clone transaction page for the user to enter the values of any fields to be populated at the run time. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DUMMY_FLD | Character(1) | VARCHAR2(1) NOT NULL | dummy field |
| 2 | BCITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | BC Item Logical Name |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | 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 |
| 6 | RB_LABEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Label Type
1=RFT Short 2=RFT Long |
| 7 | DEFAULT_IND | Character(1) | VARCHAR2(1) NOT NULL | Default Election |
| 8 | RB_PASSWORD_IND | Character(1) | VARCHAR2(1) NOT NULL | Password Protected? |
| 9 | APPEND_CLONE_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Append Clone Number?
A=Yes - Always M=Yes - Only when more than one N=No |
| 10 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Required Flag |
| 11 | 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 |
| 12 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| 13 | DROPDOWN_DESCR | Character(18) | VARCHAR2(18) NOT NULL | Description Field |