RUN_CNTL_VIDPRG

(SQL Table)
Index Back

Visitor ID Purge Run Control

RUN_CNTL_VIDPRG contains fields that are used as input parameters for the Transition Visitor ID Purge Process. Input data is retrieved from this record when the Transition Visitor ID Purge Process is requested from the Process Scheduler.

# 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 USE_DATE_RANGE Character(1) VARCHAR2(1) NOT NULL Use Date Range

Y/N Table Edit

Default Value: N

4 FROM_DT Date(10) DATE From Date
5 TO_DT Date(10) DATE To Date
6 USE_OK_TO_PURGE Character(1) VARCHAR2(1) NOT NULL Use OK To Purge

Y/N Table Edit

Default Value: N

7 INCL_CREATED_USERS Character(1) VARCHAR2(1) NOT NULL Include Created New Users

Y/N Table Edit

Default Value: N