PI_RUNCTL_SID

(SQL Table)
Index Back

Run Control for Cloning Util

This 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID 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