FT_XTRCT_RUNCTL

(SQL Table)
Index Back

  • Parent Record Of FT_XTRCT_PRCS FT_XTRT_I_PRCS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: N

    6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    7 FT_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Configuration ID

    Prompt Table: FT_CONFIG_O_VW

    8 FT_FILE_NAME Character(254) VARCHAR2(254) NOT NULL Output Zip File Override
    9 FT_COUNT_TOTAL Number(2,0) SMALLINT NOT NULL FT_COUNT_TOTAL

    Default Value: 1

    10 FT_OB_MODE Character(1) VARCHAR2(1) NOT NULL Stores the execution mode- Bulk or Incremental
    B=Full Data Publish
    I=Incremental Data Publish
    11 LASTEXECDTTM DateTime(26) TIMESTAMP DateTime of Last Execution.