FT_VAL_SDATA

(SQL Table)
Index Back

FTM SourceData Validation

Fusion Talent Management Integration Source Data Validations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_BUS_OBJ Character(3) VARCHAR2(3) NOT NULL Fusion Talent Management Business Object
2 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
3 FT_STR_KEY1_VAL Character(80) VARCHAR2(80) NOT NULL Fusion Talent Management Key String Value1
4 FT_STR_KEY2_VAL Character(80) VARCHAR2(80) NOT NULL Fusion Talent Management Key String Value 2
5 FT_STR_KEY3_VAL Character(80) VARCHAR2(80) NOT NULL Fusion Talent Management Key String Value3
6 FT_STR_KEY4_VAL Character(80) VARCHAR2(80) NOT NULL Fusion Talent Management Key string Value 4
7 FT_NUM_KEY1_VAL Number(6,0) INTEGER NOT NULL Fusion Talent Management Key Number Value1
8 FT_NUM_KEY2_VAL Number(6,0) INTEGER NOT NULL Fusion Talent Management Key Number Value2
9 FT_DT_KEY1_VAL Date(10) DATE Fusion Talent Management Key Date Value1
10 FT_STR_KEY1_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key String Name1
11 FT_STR_KEY2_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key String Name2
12 FT_STR_KEY3_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key String Name3
13 FT_STR_KEY4_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key string Name 4
14 FT_NUM_KEY1_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key Number Name 1
15 FT_NUM_KEY2_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key Number Name1
16 FT_DT_KEY1_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Talent Management Key Date Name1
17 FT_VALIDATION Character(254) VARCHAR2(254) NOT NULL Fusion Talent Management Validation