FT_XTRCT_PRCS

(SQL Table)
Index Back

  • Parent record: FT_XTRCT_RUNCTL
  • # 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 FT_XTRCT_PROCESS Character(2) VARCHAR2(2) NOT NULL Process
    01=Location
    02=HR Business Unit
    03=Department
    04=Job Grade
    05=Job Code
    06=Position
    07=Person/Job
    08=Department Tree
    09=Related Language
    10=Job Grade Rate
    11=Salary
    12=Bonus
    5 FT_DEPENDENCY Character(254) VARCHAR2(254) NOT NULL Process Dependency
    6 SELECTED Character(1) VARCHAR2(1) NOT NULL Selected

    Y/N Table Edit

    Default Value: N

    7 FT_FTM_FLAG Character(1) VARCHAR2(1) NOT NULL Fusion Talent Management

    Y/N Table Edit

    8 FT_CWB_FLAG Character(1) VARCHAR2(1) NOT NULL Workforce Compensation

    Y/N Table Edit