Mandatory_Delta_Oracle_ExtractTemplate_Try_Assignment_DetailFULLPRF2000-01-01AMandatory_Delta_Oracle_ExtractYNORA_REPORTPER_EXT_PAY_EMPLOYEES_V2_UEPER_EXT_PAY_EMPLOYEES_V2_UEPER_EXT_PAY_EMPLOYEES_V2_UEYOPER_EXT_PAY_V2_PERSON_IDPER_EXT_PAY_EMPLOYEES_V2_UE2000-01-01(paaf.assignment_status_type='ACTIVE')C{EDITADV}PersonDetailsPersonDetailsDFFPersonDetails1NNPersonDetails3000000743025402000-01-012000-01-014712-12-31Person_NumberPerson_NumberPERSON_NUMBERFTPERSON_NUMBER1Person_NumberPerson NumberPerson Person NumberN2000-01-014712-12-31Person Last NamePerson Last NamePerson_Last_NameFTPerson_Last_Name2Person_Last_NamePerson Last NamePerson Last Name2000-01-014712-12-31Person Middle NamePerson Middle NamePerson_Middle_NameFTPerson_Middle_Name3Person_Middle_NamePerson Middle NamePerson Middle Name2000-01-014712-12-31Person Display NamePerson Display NamePerson_Display_NameFTPerson_Display_Name4Person_Display_NamePerson Display NamePerson Display Name2000-01-014712-12-31Person Known AsPerson Known AsPerson_Known_AsFTPerson_Known_As5Person_Known_AsPerson Known AsPerson Known As2000-01-014712-12-31Person_First_NamePerson_First_NamePerson_First_NameFTPerson_First_Name6Person_First_NamePerson First NamePerson First Name2000-01-014712-12-31Assignment Action CodeAssignment Action CodeASSIGNMENT_ACTION_CODEFTASSIGNMENT_ACTION_CODE7Assignment_Action_CodeAssignment Action CodeAssignment Action Code2000-01-014712-12-31Assignment Business Unit IdAssignment Business Unit IdAssignment_Business_Unit_IdFTAssignment_Business_Unit_Id8Assignment_Business_Unit_IdAssignment Business Unit IdAssignment Business Unit Id2000-01-014712-12-31Assignment Business Unit NameAssignment Business Unit NameAssignment_Business_Unit_NameFTAssignment_Business_Unit_Name9Assignment_Business_Unit_NameAssignment Business Unit NameAssignment Business Unit Name2000-01-014712-12-31Assignment Department IDAssignment Department IDAssignment_Department_IDFNAssignment_Department_ID10Assignment_Department_IDAssignment Department IDAssignment Department ID2000-01-014712-12-31Assignment Effective End DateAssignment Effective End DateASSIGNMENT_EFFECTIVE_END_DATEFDASSIGNMENT_EFFECTIVE_END_DATE11Assignment_Effective_End_DateAssignment Effective End DateAssignment Effective End Date2000-01-014712-12-31Assignment Effective Start DateAssignment Effective Start DateAESD12FDASSIGNMENT_EFFECTIVE_START_DATE12Assignment_Effective_Start_DateAssignment Effective Start DateAssignment Effective Start Date2000-01-014712-12-31Assignment Job IDAssignment Job IDAssignment_Job_IDFNAssignment_Job_ID13Assignment_Job_IDAssignment Job IDAssignment Job ID2000-01-014712-12-31Assignment Location IDAssignment Location IDAssignment_Location_IDFNAssignment_Location_ID14Assignment_Location_IDAssignment Location IDAssignment Location ID2000-01-014712-12-31Assignment Manager Assignment IDAssignment Manager Assignment IDAMAI15FNAssignment_Manager_Assignment_ID15Assignment_Manager_Assignment_IDAssignment Manager Assignment IDAssignment Manager Assignment ID2000-01-014712-12-31Assignment Manager TypeAssignment Manager TypeAssignment_Manager_TypeFTAssignment_Manager_Type16Assignment_Manager_TypeAssignment Manager TypeAssignment Manager Type2000-01-014712-12-31Assignment NameAssignment NameAssignment_NameFTAssignment_Name17Assignment_NameAssignment NameAssignment Name2000-01-014712-12-31Assignment Position IDAssignment Position IDAssignment_Position_IDFNAssignment_Position_ID18Assignment_Position_IDAssignment Position IDAssignment Position ID2000-01-014712-12-31Assignment Status TypeAssignment Status TypeASSIGNMENT_STATUSFTASSIGNMENT_STATUS19Assignment_Status_TypeAssignment Status TypeAssignment Status Type2000-01-014712-12-31Assignment Status Type CodeAssignment Status Type CodeAssignment_Status_Type_CodeFTAssignment_Status_Type_Code20Assignment_Status_Type_CodeAssignment Status Type CodeAssignment Status Type Code2000-01-014712-12-31Assignment Status Type IDAssignment Status Type IDAssignment_Status_Type_IDFNAssignment_Status_Type_ID21Assignment_Status_Type_IDAssignment Status Type IDAssignment Status Type ID2000-01-014712-12-31Worker categoryWorker categoryWorker_categoryFTWorker_category22Worker_categoryWorker categoryHWP_EMP_EMP_CATEGORY_G2000-01-014712-12-31Assignment Category CodeAssignment Category CodeAssignment_Category_CodeFTAssignment_Category_Code24Assignment_Category_CodeAssignment Category CodeAssignment Category Code2000-01-014712-12-31Extract Employee V2 Relationship Date StartExtract Employee V2 Relationship Date StartHIRE_DATEFDHIRE_DATE25Extract_Employee_V2_Relationship_Date_StartExtract Employee V2 Relationship Date StartPER_EXT_PAY_V2_HR_REL_DATE_START2000-01-014712-12-31Person Latest Hire DatePerson Latest Hire DatePerson_Latest_Hire_DateFDPerson_Latest_Hire_Date26Person_Latest_Hire_DatePerson Latest Hire DatePerson Latest Rehire Date2000-01-014712-12-31Person Future Rehire DatePerson Future Rehire DatePerson_Future_Rehire_DateFDPerson_Future_Rehire_Date27Person_Future_Rehire_DatePerson Future Rehire DatePerson Future Rehire Date2000-01-014712-12-31Assignment Job CodeAssignment Job CodeAssignment_Job_CodeFTAssignment_Job_Code28Assignment_Job_CodeAssignment Job CodeAssignment Job Code2000-01-014712-12-31Assignment Legal Employer IDAssignment Legal Employer IDAssignment_Legal_Employer_IDFNAssignment_Legal_Employer_ID29Assignment_Legal_Employer_IDAssignment Legal Employer IDAssignment Legal Employer ID2000-01-014712-12-31Extract Employee V2 Legal Employer IDExtract Employee V2 Legal Employer IDEEVLEI30FNExtract_Employee_V2_Legal_Employer_ID30Extract_Employee_V2_Legal_Employer_IDExtract Employee V2 Legal Employer IDPER_EXT_PAY_V2_LEGAL_EMPLOYER_ID2000-01-014712-12-31Assignment Location CodeAssignment Location CodeAssignment_Location_CodeFTAssignment_Location_Code31Assignment_Location_CodeAssignment Location CodeAssignment Location Code2000-01-014712-12-31Assignment Manager Assignment NameAssignment Manager Assignment NameAMAN32FTAssignment_Manager_Assignment_Name32Assignment_Manager_Assignment_NameAssignment Manager Assignment NameAssignment Manager Assignment Name2000-01-014712-12-31Assignment Manager Primary IndicatorAssignment Manager Primary IndicatorAMPI33FTAssignment_Manager_Primary_Indicator33Assignment_Manager_Primary_IndicatorAssignment Manager Primary IndicatorAssignment Manager Primary Indicator2000-01-014712-12-31Assignment Primary Assignment IndicatorAssignment Primary Assignment IndicatorASSIGNMENT_PRIMARY_FLAGFTASSIGNMENT_PRIMARY_FLAG34Assignment_Primary_Assignment_IndicatorAssignment Primary Assignment IndicatorAssignment Primary Assignment Indicator2000-01-014712-12-31Assignment Primary Work Relationship IndicatorAssignment Primary Work Relationship IndicatorWORKRELATIONSHIP_PRIMARY_FLAGFTWORKRELATIONSHIP_PRIMARY_FLAG35Assignment_Primary_Work_Relationship_IndicatorAssignment Primary Work Relationship IndicatorAssignment Primary Work Relationship Indicator2000-01-014712-12-31Extract Employee V2 Assignment Primary Assignment IndicatorExtract Employee V2 Assignment Primary Assignment IndicatorEEVAPAI36FTExtract_Employee_V2_Assignment_Primary_Assignment_Indicator36Extract_Employee_V2_Assignment_Primary_Assignment_IndicatorExtract Employee V2 Assignment Primary Assignment IndicatorPER_EXT_PAY_V2_HR_ASG_PRIMARY_ASG_FLAG2000-01-014712-12-31Extract Employee V2 Assignment Primary IndicatorExtract Employee V2 Assignment Primary IndicatorEEVAPI37FTExtract_Employee_V2_Assignment_Primary_Indicator37Extract_Employee_V2_Assignment_Primary_IndicatorExtract Employee V2 Assignment Primary IndicatorPER_EXT_PAY_V2_HR_ASG_PRIMARY_FLAG2000-01-014712-12-31Extract Employee V2 Assignment Primary Term IndicatorExtract Employee V2 Assignment Primary Term IndicatorEEVAPTI38FTExtract_Employee_V2_Assignment_Primary_Term_Indicator38Extract_Employee_V2_Assignment_Primary_Term_IndicatorExtract Employee V2 Assignment Primary Term IndicatorPER_EXT_PAY_V2_HR_ASG_PRIMARY_TERM_FLAG2000-01-014712-12-31Assignment Status Type Primary IndicatorAssignment Status Type Primary IndicatorASTPI39FTAssignment_Status_Type_Primary_Indicator39Assignment_Status_Type_Primary_IndicatorAssignment Status Type Primary IndicatorAssignment Status Type Primary Indicator2000-01-014712-12-31Person Home Town or CityPerson Home Town or CityPerson_Home_Town_or_CityFTPerson_Home_Town_or_City42Person_Home_Town_or_CityPerson Home Town or CityPerson Home Town or City2000-01-014712-12-31Person Address Region1Person Address Region1Person_Address_Region1FTPerson_Address_Region143Person_Address_Region1Person Address Region1Person Address Region12000-01-014712-12-31Home countryHome countryHome_countryFTHome_country44Home_countryHome countryHWP_PER_HOME_COUNTRY_G2000-01-014712-12-31Person E-Mail TypePerson E-Mail TypePerson_EMail_TypeFTPerson_EMail_Type47Person_EMail_TypePerson E-Mail TypePerson E-Mail Type2000-01-014712-12-31Person E-Mail AddressPerson E-Mail AddressWORK_EMAILFTWORK_EMAIL48WORK_EMAILPerson E-Mail AddressPerson E-Mail Address2000-01-014712-12-31Person E-Mail Date FromPerson E-Mail Date FromPerson_EMail_Date_FromFDPerson_EMail_Date_From49Person_EMail_Date_FromPerson E-Mail Date FromPerson E-Mail Date From2000-01-014712-12-31Person E-Mail Date ToPerson E-Mail Date ToPerson_EMail_Date_ToFDPerson_EMail_Date_To50Person_EMail_Date_ToPerson E-Mail Date ToPerson E-Mail Date To2000-01-014712-12-31Person IDPerson IDPerson IDFNPerson_ID51Person IDExtract Employee V2 Person IDPER_EXT_PAY_V2_PERSON_IDYY2000-01-014712-12-31Assignment Relationship Start DateAssignment Relationship Start DateARSD53FDAssignment_Relationship_Start_Date53Assignment_Relationship_Start_DateAssignment Relationship Start DateAssignment Relationship Start Date2000-01-014712-12-31Employee Termination DateEmployee Termination DateTERMINATION_DATEFDTERMINATION_DATE54Employee_Termination_DateEmployee Termination DateEmployee Termination Date2000-01-014712-12-31Assignment Relationship Period TypeAssignment Relationship Period TypeWORKER_TYPEFTWORKER_TYPE55Assignment_Relationship_Period_TypeAssignment Relationship Period TypeAssignment Relationship Period Type2000-01-014712-12-31Assignment Relationship Period of Service IDAssignment Relationship Period of Service IDPERIOD_OF_SERVICE_IDFNPERIOD_OF_SERVICE_ID56Assignment Relationship Period of Service IDAssignment Relationship Period of Service IDAssignment Relationship Period of Service ID2000-01-014712-12-31Assignment Period Of Service IDAssignment Period Of Service IDAPOSI57FNAssignment_Period_Of_Service_ID57Assignment_Period_Of_Service_IDAssignment Period Of Service IDAssignment Period Of Service ID2000-01-014712-12-31Extract Employee V2 Assignment IDExtract Employee V2 Assignment IDASSIGNMENT_IDFNASSIGNMENT_ID58Extract_Employee_V2_Assignment_IDExtract Employee V2 Assignment IDPER_EXT_PAY_V2_HR_ASSIGNMENT_ID2000-01-014712-12-31Assignment Manager Person IDAssignment Manager Person IDAssignment_Manager_Person_IDFNAssignment_Manager_Person_ID59Assignment_Manager_Person_IDAssignment Manager Person IDAssignment Manager Person ID2000-01-014712-12-31Assignment Manager Person NumberAssignment Manager Person NumberAMPN60FTAssignment_Manager_Person_Number60Assignment_Manager_Person_NumberAssignment Manager Person NumberAssignment Manager Person Number2000-01-014712-12-31Extract Employee V2 Assignment Attribute6Extract Employee V2 Assignment Attribute6EEVAA61FTExtract_Employee_V2_Assignment_Attribute661Extract_Employee_V2_Assignment_Attribute6Extract Employee V2 Assignment Attribute6PER_EXT_PAY_V2_HR_ASG_ASS_ATTRIBUTE62000-01-014712-12-31Person User NamePerson User NamePerson_User_NameFTPerson_User_Name62Person_User_NamePerson User NamePerson User Name1 ASC2000-01-014712-12-31encryptedHCMCONNECTGREGORIANDetails_Active_Encrypted.csvCSVY2023-11-21 12:44:49.528YDELIMITER,ENCMODENONEENC_KEY_NAMEFILE_NAME_DEINTGNAMEtempKEYLOCALEPRINT_HDRNPRINT_INFONTIMEZONEZIPMandatory_Delta_Oracle_ExtractEXT300000074302428Y300000074302439encryptedBaseline OnlyBASELINE_ONLYbaseline_onlyTBaseline OnlyYYYLKYES_NO70INPUTChanges OnlyCHANGES_ONLYchanges_onlyTChanges OnlyYYYLKPER_EXT_CHANGES_ONLY80INPUTEffective DateEFFECTIVE_DATEeffective_dateDEffective DateYYY10INPUTLegislative Data GroupLEGISLATIVE_DATA_GROUP_IDlegislative_data_group_idNLegislative Data GroupYYN20INPUTParameter GroupPARAMETER_GROUP_IDparameter_group_idNParameter GroupNYN30INPUTReport CategoryREPORT_CATEGORY_IDreport_category_idNReport CategoryNYN40INPUTRequest IDREQUEST_IDrequest_idNRequest IDNYN50INPUTStart DateSTART_DATEstart_dateDStart DateYYN60INPUT