FT_ASG_WRK_MSR

(SQL Table)
Index Back

Fusion extract Asgn Wrk Msr

Fusion extract of Assignment Work Measure information for HCM to FTM Worker integration

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
6 FT_WR_EMPL_RCD Number(3,0) SMALLINT NOT NULL Work Relationship RCD
7 FT_WR_EFFDT Date(10) DATE Work Relationship Eff Date
8 FT_WR_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Work Relationship Eff Date
9 FT_WR_EFFSEQ Number(3,0) SMALLINT NOT NULL Work Relationship Eff Seq
10 FT_WR_GUIDSEQ Number(4,0) SMALLINT NOT NULL Sequence
11 FT_WT_EFFDT Date(10) DATE Work Term Effective Date
12 FT_WT_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Work Term Eff Date
13 FT_WT_EFFSEQ Number(3,0) SMALLINT NOT NULL Work Term Eff Seq
14 FT_WT_GUIDSEQ Number(4,0) SMALLINT NOT NULL Sequence
15 FT_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Effective Date in PS Format
16 FT_ACTN_OCCUR_GUID Character(36) VARCHAR2(36) NOT NULL Action Occurrence ID
17 FT_ADDS_TO_BUDGET Character(30) VARCHAR2(30) NOT NULL Adds to Budget
18 FT_ASGN_WKMSR_GUID Character(36) VARCHAR2(36) NOT NULL Assignment Work Measure ID
19 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID
20 FT_BUS_GROUP_GUID Character(36) VARCHAR2(36) NOT NULL Business Group ID
21 FT_EFF_END_DATE Date(10) DATE Effective End Date
22 FT_EFF_START_DATE Date(10) DATE Effective Start Date
23 FT_UNIT Character(30) VARCHAR2(30) NOT NULL Unit
24 FT_VALUE_NBR Number(31,5) DECIMAL(30,5) NOT NULL Value
25 FT_LED Character(1) VARCHAR2(1) NOT NULL Used by Fusion Coexistence
26 FT_LSD Character(1) VARCHAR2(1) NOT NULL Used by Fusion Coexistence
27 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
28 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

29 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

Default Value: N

30 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
31 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key