FT_ASGMNT_IN_VW

(SQL View)
 Index Back

Fusion extract Assignment

Fusion extract of Assignment information for HCM to FTM Worker integration

SELECT S.FT_RUN_ID , S.FT_ASSIGNMENT_GUID , S.FT_EFF_START_DATE , S.FT_EFF_END_DATE , S.FT_EFF_SEQUENCE , S.FT_EFF_LATEST_CHG2 , S.FT_JOB_GUID , S.FT_POSITION_GUID , S.FT_GRADE_GUID , S.FT_PERSON_GUID , S.FT_ASGN_STYPE_GUID , S.FT_EMPLOYMENT_CAT , S.FT_FREQUENCY , S.FT_LOCATION_GUID , S.FT_ORG_ID_GUID , S.FT_PRIMARY_FLAG , S.EMPLID , S.EMPL_RCD , S.FT_WT_EFFDT , S.FT_WT_EFFDT_PSFMT , S.FT_WT_EFFSEQ , S.ACTION , S.ACTION_REASON , S.FT_SETID_JOBCODE , S.FT_JOBCODE , S.FT_POSITION_NBR , S.FT_SETID_SALARY , S.FT_SAL_ADMIN_PLAN , S.FT_GRADE , S.EFFDT , S.EFFSEQ , S.SETID_JOBCODE , S.JOBCODE , S.POSITION_NBR , S.SETID_SALARY , S.SAL_ADMIN_PLAN , S.GRADE , S.FT_VALUE_CHANGED , S.FT_PROC_SEQ , S.FT_PROCESS_FLAG , S.FT_PROC_STATUS , S.FT_PROC_MARKER , S.FT_ERROR_FLAG , S.FT_BYPASS_FLAG , S.FT_ALTERNATE_REC , S.FT_ALTERNATE_KEY , S.LASTUPDDTTM , S.LASTUPDOPRID , 1 FROM PS_FT_ASSIGNMNT_IN S

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
2 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID
3 FT_EFF_START_DATE Date(10) DATE Effective Start Date
4 FT_EFF_END_DATE Date(10) DATE Effective End Date
5 FT_EFF_SEQUENCE Number(4,0) SMALLINT NOT NULL Effective Sequence
6 FT_EFF_LATEST_CHG2 Character(30) VARCHAR2(30) NOT NULL Effective Latest Change (30)
7 FT_JOB_GUID Character(36) VARCHAR2(36) NOT NULL Job GUID
8 FT_POSITION_GUID Character(36) VARCHAR2(36) NOT NULL Position GUID
9 FT_GRADE_GUID Character(36) VARCHAR2(36) NOT NULL Grade GUID
10 FT_PERSON_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
11 FT_ASGN_STYPE_GUID Character(36) VARCHAR2(36) NOT NULL Assignment Status Type ID
12 FT_EMPLOYMENT_CAT Character(30) VARCHAR2(30) NOT NULL Employment Category
13 FT_FREQUENCY Character(30) VARCHAR2(30) NOT NULL Frequency
14 FT_LOCATION_GUID Character(36) VARCHAR2(36) NOT NULL Location GUID
15 FT_ORG_ID_GUID Character(36) VARCHAR2(36) NOT NULL ORGANIZATION_ID GUID
16 FT_PRIMARY_FLAG Character(30) VARCHAR2(30) NOT NULL Primary Assignment Flag
17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
18 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
19 FT_WT_EFFDT Date(10) DATE Work Term Effective Date
20 FT_WT_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Work Term Eff Date
21 FT_WT_EFFSEQ Number(3,0) SMALLINT NOT NULL Work Term Eff Seq
22 ACTION Character(3) VARCHAR2(3) NOT NULL Action
23 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
24 FT_SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
25 FT_JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
26 FT_POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
27 FT_SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
28 FT_SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
29 FT_GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
30 EFFDT Date(10) DATE Effective Date
31 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
32 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
33 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
34 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
35 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
36 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
37 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
38 FT_VALUE_CHANGED Character(1) VARCHAR2(1) NOT NULL Value Changed
N=No
Y=Yes
39 FT_PROC_SEQ Number(10,0) DECIMAL(10) NOT NULL Process Sequence
40 FT_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL In Process
41 FT_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
00=Not Processed
10=Loaded from File
20=Transformed
30=Previewed
40=Manually Posted
50=Posted
42 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
43 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

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

Default Value: N

45 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
46 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key
47 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
48 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
49 FT_ASSIGNMENT_CNT Number(10,0) DECIMAL(10) NOT NULL Assignments w/ Any Change