SETIDMIG_ACTION_IDACTV=Active
INAC=Inactive
RB_PUBMIGACT_VW(SQL View) |
Index Back |
|---|---|
Migration Actions ViewView used for getting public Migration Actions |
| SELECT SETID , MIG_ACTION_ID , MIG_ACT_STATUS , DESCR254 FROM PS_RB_MIG_ACT_TBL WHERE public_migr_flag = 'Y' |
| # | 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. |
| 2 | MIG_ACTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for storing migration action id |
| 3 | MIG_ACT_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Field used for storing migration action status
ACTV=Active INAC=Inactive |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |