EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQFT_ASSIGNMENT_NOA=Active
I=Inactive
FT_ASGNMT_CLON(SQL Table) |
Index Back |
|---|---|
Fusion extract AssignmentFusion extract of Assignment 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 | FT_ASSIGNMENT_GUID | Character(36) | VARCHAR2(36) NOT NULL | Assignment ID |
| 6 | FT_ASSIGNMENT_NO |
Character(30) | VARCHAR2(30) NOT NULL | Assignment Number |
| 7 | FT_EFF_END_DATE | Date(10) | DATE | Effective End Date |
| 8 | FT_EFF_START_DATE | Date(10) | DATE | Effective Start Date |
| 9 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |
| 10 | FT_PER_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Assignment Seq Within Person |
| 11 | FT_PERSON_GUID | Character(36) | VARCHAR2(36) NOT NULL | Person GUID |
| 12 | FT_PRIMARY_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Primary Assignment Flag |
| 13 | FT_PER_OF_SVC_GUID | Character(36) | VARCHAR2(36) NOT NULL | Period of Service ID |
| 14 | FT_WRKTRM_ASG_GUID | Character(36) | VARCHAR2(36) NOT NULL | Work Terms Assignment ID |