HRS_RUN_CNTL

(SQL Table)
Index Back

eRecruit Run Control Record

  • Parent Record Of HRS_RUN_ERP
  • # 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 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JO_I

    4 RUN_ERP_RULES Character(1) VARCHAR2(1) NOT NULL Eligibility and Awards Rules

    Y/N Table Edit

    Default Value: N

    5 RUN_NA_INTERFACE Character(1) VARCHAR2(1) NOT NULL Interface to Payroll for NA

    Y/N Table Edit

    Default Value: N

    6 FROMDATE Date(10) DATE From Date
    7 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    8 URL_2 Character(254) VARCHAR2(254) NOT NULL URL #2
    9 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    10 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    11 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    12 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    13 HRS_TODATE Date(10) DATE To Date
    14 HRS_DAYS_PRIOR_FR Number(5,0) INTEGER NOT NULL Days Prior From
    15 HRS_DAYS_PRIOR_TO Number(5,0) INTEGER NOT NULL Days Prior To
    16 HRS_PAGE_LABEL Character(1) VARCHAR2(1) NOT NULL Page field labels
    17 HRS_SEND_EVL_REM Character(1) VARCHAR2(1) NOT NULL Send Evaluation Reminders

    Y/N Table Edit

    Default Value: N