RB_DUP_SETDefault Value: RB_DUP_PARMS.RB_DUP_SET
RB_DUP_CATEGORYCOM=Company
PER=Person
DESCRY/N Table Edit
Default Value: N
Prompt Table: RB_DUP_REC_VW
Prompt Table: RB_DUP_FLD_VW
Default Value: 1
Default Value: 1
RB_DUP_RECORDS(SQL Table) |
Index Back |
|---|---|
Duplicate ParamtersThis is the table for the Duplicate Paramters record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RB_DUP_SET |
Character(10) | VARCHAR2(10) NOT NULL |
This is the duplicate parameter set field.
Default Value: RB_DUP_PARMS.RB_DUP_SET |
| 2 | RB_DUP_CATEGORY |
Character(3) | VARCHAR2(3) NOT NULL |
This is the duplicate category field.
COM=Company PER=Person |
| 3 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | RB_SELECTED | Character(1) | VARCHAR2(1) NOT NULL |
Field indicates that it is selected .
Y/N Table Edit Default Value: N |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RB_DUP_REC_VW |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RB_DUP_FLD_VW |
| 7 | RB_START_POS | Number(4,0) | SMALLINT NOT NULL |
Start Position
Default Value: 1 |
| 8 | RB_DUP_PARM_SEQ_NO | Number(3,0) | SMALLINT NOT NULL | This field is used for sequence number. |
| 9 | RB_END_POS | Number(4,0) | SMALLINT NOT NULL |
This field is for end position .
Default Value: 1 |