FT_VAL_RUN(SQL Table) |
Index Back |
|---|---|
FTM Validation Run Control RecFusion Talent Management Integration Run Control Record |
| # | 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 | FT_VAL_SETUP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Setup
Y/N Table Edit Default Value: N |
| 4 | FT_VAL_PERJOB | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Person/Job Details
Y/N Table Edit Default Value: N |
| 5 | FT_VAL_PRO_DISP | Character(1) | VARCHAR2(1) NOT NULL |
FT_VAL_PRO_DISP
Y/N Table Edit Default Value: N |
| 6 | FT_VAL_BU_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Business unit Option
Y/N Table Edit |
| 7 | FT_VAL_DEP_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management department option
Y/N Table Edit |
| 8 | FT_VAL_JCD_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management job Code Option
Y/N Table Edit |
| 9 | FT_VAL_JG_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Job Grade Option
Y/N Table Edit |
| 10 | FT_VAL_LOC_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Location Option
Y/N Table Edit |
| 11 | FT_VAL_POS_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Position option
Y/N Table Edit |
| 12 | FT_VAL_JGR_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Job Grade Rate Option
Y/N Table Edit |
| 13 | FT_VAL_DTR_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Department Tree Option
Y/N Table Edit |
| 14 | FT_VAL_PERJ_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Person Display
Y/N Table Edit |
| 15 | FT_VAL_JOB_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Job
Y/N Table Edit |
| 16 | FT_VAL_SAL_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Salary option
Y/N Table Edit |
| 17 | FT_VAL_BON_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Bonus option
Y/N Table Edit |
| 18 | FT_FILTER_SET_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Setup Filer
0=All 1=Specify... Default Value: 0 |
| 19 | FT_POINT_IN_TIME | Date(10) | DATE NOT NULL | Fusion Talent Management Point In Time |
| 20 | FT_FILTER_COMP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Company Filter
0=All 1=Specify... Default Value: 0 |
| 21 | FT_FILTER_REG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management RegRegion Filter
0=All 1=Specify... Default Value: 0 |
| 22 | FT_FILTER_PSET_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Set ID Data Filter Option
0=All 1=Specify... Default Value: 0 |
| 23 | FT_FILTER_GRP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Fusion Talent Management Group Data Filter
0=All 1=Specify... Default Value: 0 |
| 24 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |