RB_MIG_ACT_TBL(SQL Table) |
Index Back |
|---|---|
Migration Action DefinitionTable record Stored Migration Action Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID |
| 2 | MIG_ACTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Field used for storing migration action id
Default Value: NEXT |
| 3 | SOURCE_PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
field used for storing Source Product ID value
Prompt Table: RB_CPRD_MLPB_VW |
| 4 | RB_HLEV_ID | Character(20) | VARCHAR2(20) NOT NULL |
Field used for storing multilevel structure level id information
Prompt Table: RB_HLEV_DFN_VW |
| 5 | TARGET_PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Field used to store Porduct ID of a target
Prompt Table: RB_CPRD_ML_DVW |
| 6 | MIG_ACT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Field used for storing migration action status
ACTV=Active INAC=Inactive |
| 7 | START_DT | Date(10) | DATE NOT NULL | Start date field to store start date value. |
| 8 | END_DT | Date(10) | DATE NOT NULL | This field stores the end date values. |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 10 | PUBLIC_MIGR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Field used for storing Public Migration Flag Value
Y/N Table Edit Default Value: Y |
| 11 | CONFIG_DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Field used for storing Default in Configurator flag value
Y/N Table Edit Default Value: Y |
| 12 | SOURCE_CTX_FLG | Character(3) | VARCHAR2(3) NOT NULL |
Source Context radio-button field
ALL=All SEL=Selected Default Value: SEL |
| 13 | TARGET_CTX_FLG | Character(3) | VARCHAR2(3) NOT NULL |
Target context radio-button field
ALL=All SEL=Selected Default Value: SEL |
| 14 | MIG_ACTION_ID_REL | Character(10) | VARCHAR2(10) NOT NULL |
Field used for storing ID of Migration Relation
Prompt Table: RB_MIG_ACT_DVW |
| 15 | RB_SCOPE_MIG | Character(4) | VARCHAR2(4) NOT NULL |
Field used for storing migration action Scope value
ALLC=All Customers DIFF=Different Customers Only SAME=Same Customer Only Default Value: SAME |
| 16 | DESCRLONG | Long Character | CLOB | Long Description |
| 17 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 18 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 19 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 20 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 21 | 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. |
| 22 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |