RUN_CNTL_HR_SEC

(SQL Table)
Index Back

HR Run Control

RUN_CNTL_HR contains fields that are used as input parameters for the various HR Reports. Input data is retrieved from this record when a report 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 UPDATE_ROW_LVL_SEC Character(1) VARCHAR2(1) NOT NULL Refresh All Rows?

Y/N Table Edit

4 ASOFDATE Date(10) DATE As of Date
5 FILL_FAST_1 Character(1) VARCHAR2(1) NOT NULL Re-Fresh Type 1

Y/N Table Edit

6 FILL_FAST_2 Character(1) VARCHAR2(1) NOT NULL Re-Fresh Type 2

Y/N Table Edit

7 FILL_FAST_3 Character(1) VARCHAR2(1) NOT NULL Re-Fresh Type 3

Y/N Table Edit