RUN_CNTL_VIDPRG(SQL Table) |
Index Back |
---|---|
Visitor ID Purge Run ControlRUN_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 |