FT_WRK_TERMS_VW(SQL View) |
Index Back |
|---|---|
Fusion extract Work TermsFusion extract of Work Terms information for HCM to FTM Worker integration |
| SELECT EMPLID , EMPL_RCD , EFFDT , EFFSEQ , ACTION , HR_STATUS , EMPL_STATUS , PER_ORG , FT_BARG_UNIT , BUSINESS_UNIT , JOBCODE , SETID_JOBCODE , COMPANY , REG_REGION , COUNTRY , ORG_INSTANCE_ERN , HIRE_DT , LAST_HIRE_DT , FT_PER_SEQ , FT_WR_EMPL_RCD , FT_WR_EFFDT , FT_WR_EFFDT_PSFMT , FT_WR_EFFSEQ , FT_WR_GUIDSEQ , FT_WT_EFFDT , FT_WT_EFFDT_PSFMT , FT_WT_EFFSEQ , FT_WT_GUIDSEQ , FT_EFFDT_PSFMT , FT_ACTION_CODE , FT_ACTN_OCCUR_GUID , FT_APPLICANT_RANK , FT_ASSIGNMENT_GUID , FT_ASSIGNMENT_NAME , FT_ASSIGNMENT_NO , FT_ASSIGNMENT_SEQ , FT_ASGN_STAT_TYPE , FT_ASGN_STYPE_GUID , FT_ASSIGNMENT_TYPE , FT_AUTO_END_FLAG , NULL , NULL , FT_BUS_GROUP_GUID , FT_BUS_UNIT_GUID , NULL , NULL , NULL , NULL , %DateNull , NULL , NULL , FT_EFF_END_DATE , FT_EFF_LATEST_CHG2 , FT_EFF_SEQUENCE , FT_EFF_START_DATE , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , FT_LEGALENTY_GUID , FT_LEGISLATION_CD2 , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , FT_PER_OF_SVC_GUID , FT_PERSON_GUID , FT_PERSON_REF_GUID , FT_PERSON_TYP_GUID , NULL , NULL , NULL , FT_POS_OVRD_FLAG , NULL , FT_PRMRY_ASGN_FLAG , FT_PRIMARY_FLAG , FT_LED , FT_LSD , FT_PR_WRK_REL_FLAG , FT_PR_WRK_TRM_FLAG , NULL , NULL , NULL , %DateNull , FT_PROJ_ASG_STR_DT , NULL , FT_REASON_CODE , NULL , FT_RECRUITER_GUID , FT_RCRT_ACTV_GUID , NULL , %DateNull , NULL , NULL , NULL , FT_SOURCE_ORG_GUID , NULL , NULL , %DateNull , FT_SYS_PERSON_TYPE , NULL , NULL , NULL , FT_VACANCY_GUID , NULL , NULL , NULL , NULL , NULL , NULL , FT_FREEZE_START_DT , FT_FREEZE_UNTIL_DT , FT_DONOT_BYPASS , FT_PROC_MARKER , FT_ERROR_FLAG , FT_BYPASS_FLAG , FT_ALTERNATE_REC , FT_ALTERNATE_KEY FROM PS_FT_WORK_TERMS |
| # | 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 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 6 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |
| 7 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 8 | PER_ORG | Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest |
| 9 | FT_BARG_UNIT | Character(4) | VARCHAR2(4) NOT NULL | Bargaining Unit |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 12 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 13 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 14 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 15 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 16 | ORG_INSTANCE_ERN | Number(3,0) | SMALLINT NOT NULL | Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level. |
| 17 | HIRE_DT | Date(10) | DATE | First Start Date |
| 18 | LAST_HIRE_DT | Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
| 19 | FT_PER_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Assignment Seq Within Person |
| 20 | FT_WR_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Work Relationship RCD |
| 21 | FT_WR_EFFDT | Date(10) | DATE | Work Relationship Eff Date |
| 22 | FT_WR_EFFDT_PSFMT | Character(10) | VARCHAR2(10) NOT NULL | Work Relationship Eff Date |
| 23 | FT_WR_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Work Relationship Eff Seq |
| 24 | FT_WR_GUIDSEQ | Number(4,0) | SMALLINT NOT NULL | Sequence |
| 25 | FT_WT_EFFDT | Date(10) | DATE | Work Term Effective Date |
| 26 | FT_WT_EFFDT_PSFMT | Character(10) | VARCHAR2(10) NOT NULL | Work Term Eff Date |
| 27 | FT_WT_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Work Term Eff Seq |
| 28 | FT_WT_GUIDSEQ | Number(4,0) | SMALLINT NOT NULL | Sequence |
| 29 | FT_EFFDT_PSFMT | Character(10) | VARCHAR2(10) NOT NULL | Effective Date in PS Format |
| 30 | FT_ACTION_CODE | Character(30) | VARCHAR2(30) NOT NULL | Action Code |
| 31 | FT_ACTN_OCCUR_GUID | Character(36) | VARCHAR2(36) NOT NULL | Action Occurrence ID |
| 32 | FT_APPLICANT_RANK | Number(18,0) | DECIMAL(18) NOT NULL | Applicant Rank |
| 33 | FT_ASSIGNMENT_GUID | Character(36) | VARCHAR2(36) NOT NULL | Assignment ID |
| 34 | FT_ASSIGNMENT_NAME | Character(80) | VARCHAR2(80) NOT NULL | Assignment Name |
| 35 | FT_ASSIGNMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Assignment Number |
| 36 | FT_ASSIGNMENT_SEQ | Number(18,0) | DECIMAL(18) NOT NULL | Assignment Sequence |
| 37 | FT_ASGN_STAT_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Assignment Status Type |
| 38 | FT_ASGN_STYPE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Assignment Status Type ID |
| 39 | FT_ASSIGNMENT_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Assignment Type |
| 40 | FT_AUTO_END_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Auto End Flag |
| 41 | FT_BARG_UNIT_CODE | Character(30) | VARCHAR2(30) NOT NULL | Bargaining Unit Code |
| 42 | FT_BILLING_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Billing Title |
| 43 | FT_BUS_GROUP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Business Group ID |
| 44 | FT_BUS_UNIT_GUID | Character(36) | VARCHAR2(36) NOT NULL | ORGANIZATION_ID GUID |
| 45 | FT_CAGR_GDEF_GUID | Character(36) | VARCHAR2(36) NOT NULL | Coll Agreed Grade Def ID |
| 46 | FT_CAGR_FLEX_NBR | Character(30) | VARCHAR2(30) NOT NULL | Coll Agreed Grade Flex Number |
| 47 | FT_CLTV_AGREE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Collective Agreement ID |
| 48 | FT_CONTRACT_GUID | Character(36) | VARCHAR2(36) NOT NULL | Contract ID |
| 49 | FT_PROBTN_END_DATE | Date(10) | DATE | Probation End Date |
| 50 | FT_DFLT_CDCMB_GUID | Character(36) | VARCHAR2(36) NOT NULL | Default Code Combination ID |
| 51 | FT_DUTIES_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Duties Type |
| 52 | FT_EFF_END_DATE | Date(10) | DATE | Effective End Date |
| 53 | FT_EFF_LATEST_CHG2 | Character(30) | VARCHAR2(30) NOT NULL | Effective Latest Change (30) |
| 54 | FT_EFF_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Effective Sequence |
| 55 | FT_EFF_START_DATE | Date(10) | DATE | Effective Start Date |
| 56 | FT_EMPLOYEE_CAT | Character(30) | VARCHAR2(30) NOT NULL | Employee Category |
| 57 | FT_EMPLOYMENT_CAT | Character(30) | VARCHAR2(30) NOT NULL | Employment Category |
| 58 | FT_ESTABLISH_GUID | Character(36) | VARCHAR2(36) NOT NULL | EstablishmentGUID |
| 59 | FT_EXP_CHECK_ADDR | Character(30) | VARCHAR2(30) NOT NULL | Expense Check Address |
| 60 | FT_FREQUENCY | Character(30) | VARCHAR2(30) NOT NULL | Frequency |
| 61 | FT_GRADE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Grade GUID |
| 62 | FT_GR_LDR_PGM_GUID | Character(36) | VARCHAR2(36) NOT NULL | Grade Ladder Program ID |
| 63 | FT_HR_SALARY_CODE | Character(30) | VARCHAR2(30) NOT NULL | Hourly Salaried Code |
| 64 | FT_INTERNAL_BLDG | Character(45) | VARCHAR2(45) NOT NULL | Internal Building |
| 65 | FT_INTERNAL_FLOOR | Character(45) | VARCHAR2(45) NOT NULL | Internal Floor |
| 66 | FT_INTERNAL_LOC | Character(80) | VARCHAR2(80) NOT NULL | Internal Location |
| 67 | FT_INTERNAL_MAIL | Character(45) | VARCHAR2(45) NOT NULL | Internal Mail Stop |
| 68 | FT_INTERNAL_OFFNBR | Character(45) | VARCHAR2(45) NOT NULL | Internal Office Number |
| 69 | FT_JOB_GUID | Character(36) | VARCHAR2(36) NOT NULL | Job GUID |
| 70 | FT_JOB_POST_SRC_NM | Character(80) | VARCHAR2(80) NOT NULL | Job Post Source Name |
| 71 | FT_LBR_UN_MBR_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Labor Union Member flag |
| 72 | FT_LEGALENTY_GUID | Character(36) | VARCHAR2(36) NOT NULL | ORGANIZATION_ID GUID |
| 73 | FT_LEGISLATION_CD2 | Character(150) | VARCHAR2(150) NOT NULL | Legislation Code |
| 74 | FT_LINKAGE_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Linkage Type |
| 75 | FT_LOCATION_GUID | Character(36) | VARCHAR2(36) NOT NULL | Location GUID |
| 76 | FT_MANAGER_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Manager flag |
| 77 | FT_NORMAL_HOURS | Character(30) | VARCHAR2(30) NOT NULL | Effective Sequence |
| 78 | FT_NTC_PERIOD_CHAR | Character(10) | VARCHAR2(10) NOT NULL | Effective Sequence |
| 79 | FT_NOTICE_PER_UOM | Character(30) | VARCHAR2(30) NOT NULL | Notice Period UOM |
| 80 | FT_ORG_ID_GUID | Character(36) | VARCHAR2(36) NOT NULL | ORGANIZATION_ID GUID |
| 81 | FT_PARENT_ASGN_ID | Character(36) | VARCHAR2(36) NOT NULL | Parent Assignment ID |
| 82 | FT_PEOPLE_GRP_GUID | Character(36) | VARCHAR2(36) NOT NULL | People Group ID |
| 83 | FT_PER_OF_SVC_GUID | Character(36) | VARCHAR2(36) NOT NULL | Period of Service ID |
| 84 | FT_PERSON_GUID | Character(36) | VARCHAR2(36) NOT NULL | Person GUID |
| 85 | FT_PERSON_REF_GUID | Character(36) | VARCHAR2(36) NOT NULL | Person Referred By ID |
| 86 | FT_PERSON_TYP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Person Type ID |
| 87 | FT_PO_HEADER_GUID | Character(36) | VARCHAR2(36) NOT NULL | Purchase Order Header ID |
| 88 | FT_PO_LINE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Purchase Order Line ID |
| 89 | FT_POSITION_GUID | Character(36) | VARCHAR2(36) NOT NULL | Position GUID |
| 90 | FT_POS_OVRD_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Position Override flag |
| 91 | FT_POST_CONT_GUID | Character(36) | VARCHAR2(36) NOT NULL | Posting Content ID |
| 92 | FT_PRMRY_ASGN_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Primary Assignment Flag |
| 93 | FT_PRIMARY_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Primary Assignment Flag |
| 94 | FT_LED | Character(1) | VARCHAR2(1) NOT NULL | Used by Fusion Coexistence |
| 95 | FT_LSD | Character(1) | VARCHAR2(1) NOT NULL | Used by Fusion Coexistence |
| 96 | FT_PR_WRK_REL_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Primary Work Relation flag |
| 97 | FT_PR_WRK_TRM_FLAG | Character(30) | VARCHAR2(30) NOT NULL | Primary Work Terms flag |
| 98 | FT_PROBTN_PERIOD | Character(30) | VARCHAR2(30) NOT NULL | Effective Sequence |
| 99 | FT_PROBATION_UNIT | Character(30) | VARCHAR2(30) NOT NULL | Probation Unit |
| 100 | FT_PROJECT_TITLE | Character(80) | VARCHAR2(80) NOT NULL | Project Title |
| 101 | FT_PROJ_ASG_END_DT | Date(10) | DATE | Projected Assignment End Date |
| 102 | FT_PROJ_ASG_STR_DT | Date(10) | DATE | Projected Assignment Start Dt |
| 103 | FT_PROP_WRKR_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Proposed Worker Type |
| 104 | FT_REASON_CODE | Character(30) | VARCHAR2(30) NOT NULL | Reason Code |
| 105 | FT_RECORD_CREATOR | Character(30) | VARCHAR2(30) NOT NULL | Record Creator |
| 106 | FT_RECRUITER_GUID | Character(36) | VARCHAR2(36) NOT NULL | Recruiter ID |
| 107 | FT_RCRT_ACTV_GUID | Character(36) | VARCHAR2(36) NOT NULL | Recruitment Activity ID |
| 108 | FT_RTRMNT_AGE_CHAR | Character(18) | VARCHAR2(18) NOT NULL | Effective Sequence |
| 109 | FT_RETIREMENT_DATE | Date(10) | DATE | Retirement Date |
| 110 | FT_SAL_REVW_PERIOD | Character(18) | VARCHAR2(18) NOT NULL | Effective Sequence |
| 111 | FT_SAL_RVW_PER_FRQ | Character(30) | VARCHAR2(30) NOT NULL | Salary Review Period Frequency |
| 112 | FT_SET_OF_BKS_GUID | Character(36) | VARCHAR2(36) NOT NULL | Set of Books ID |
| 113 | FT_SOURCE_ORG_GUID | Character(36) | VARCHAR2(36) NOT NULL | Source Organization ID |
| 114 | FT_SOURCE_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Source Type |
| 115 | FT_SPC_CL_STP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Special Ceiling Step ID |
| 116 | FT_STEP_ENTRY_DATE | Date(10) | DATE | Step Entry Date |
| 117 | FT_SYS_PERSON_TYPE | Character(30) | VARCHAR2(30) NOT NULL | System Person Type |
| 118 | FT_TAX_ADDR_GUID | Character(36) | VARCHAR2(36) NOT NULL | Tax Address ID |
| 119 | FT_NRM_FINISH_TIME | Character(5) | VARCHAR2(5) NOT NULL | Normal Finish Time |
| 120 | FT_NORM_START_TIME | Character(5) | VARCHAR2(5) NOT NULL | Normal Start Time |
| 121 | FT_VACANCY_GUID | Character(36) | VARCHAR2(36) NOT NULL | Vacancy ID |
| 122 | FT_VENDOR_ASGN_NBR | Character(30) | VARCHAR2(30) NOT NULL | System Person Type |
| 123 | FT_VENDOR_EMPL_NBR | Character(30) | VARCHAR2(30) NOT NULL | System Person Type |
| 124 | FT_VENDOR_GUID | Character(36) | VARCHAR2(36) NOT NULL | Vendor ID |
| 125 | FT_VNDR_SITE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Vendor Site ID |
| 126 | FT_WORK_AT_HOME | Character(30) | VARCHAR2(30) NOT NULL | Work At Home |
| 127 | FT_WRKTRM_ASG_GUID | Character(36) | VARCHAR2(36) NOT NULL | Work Terms Assignment ID |
| 128 | FT_FREEZE_START_DT | Date(10) | DATE | Freeze Start Date |
| 129 | FT_FREEZE_UNTIL_DT | Date(10) | DATE | Freeze Until Date |
| 130 | FT_DONOT_BYPASS | Character(1) | VARCHAR2(1) NOT NULL | Do Not Bypass Flag |
| 131 | FT_PROC_MARKER | Character(36) | VARCHAR2(36) NOT NULL | Process marker field |
| 132 | FT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
N=No Y=Yes Default Value: N |
| 133 | FT_BYPASS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Flag
Default Value: N |
| 134 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 135 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |