PI_RUNCTL_SID(SQL Table) |
Index Back |
|---|---|
Run Control for Cloning UtilThis Ap Engine process will create a new set of records with new PI System ID using an existing PI System ID. It will also create a new set of Definition records. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | PI_SYSID_FROM | Character(4) | VARCHAR2(4) NOT NULL | Copy from PI System ID |
| 4 | PI_SYSID_TO | Character(4) | VARCHAR2(4) NOT NULL | Copy to PI System ID |
| 5 | PICLONE_FIELD | Character(1) | VARCHAR2(1) NOT NULL |
PI Clone Flag - Field Tbls
Y/N Table Edit |
| 6 | PICLONE_GROUP | Character(1) | VARCHAR2(1) NOT NULL |
PI Clone flag for Group Tbls
Y/N Table Edit |
| 7 | PICLONE_INSTANCE | Character(1) | VARCHAR2(1) NOT NULL |
PI Clone flag for Instance Tbl
Y/N Table Edit |
| 8 | PICLONE_PSTBL | Character(1) | VARCHAR2(1) NOT NULL |
PI clone flag for PS Tables
Y/N Table Edit |
| 9 | PI_FDEFN_FROM | Character(6) | VARCHAR2(6) NOT NULL | Copy from File Defn ID |
| 10 | PI_FDEFN_TO | Character(6) | VARCHAR2(6) NOT NULL | Copy to PI File Defn ID |