Contract Workforce Management

Before you configure the CWFM Import Export integration, you must do the following:

1. Configure Access to Integrations

2. Configure the following:

   • Integration List Parameters: Create integration list parameters that identify the actions and contract workforce management files. See the Configure Integration List Parameters topic.

     Examples include:

Name: ContractWorkForceManagement_ActionType

Description: Action types applicable to Contract Workforce Management Import Export.

Parameter values:

Name	Description	Value	Default value
Export	This parameter applies to export functionality.	Export	No
Import	This parameter applies to import functionality.	Import	Yes

Name: ContractWorkForceManagement_Files

Description: Files applicable to Contract Workforce Management Import Export.

Parameter values:

Name	Description	Value	Default value
Contractor Compliance	Enables selection of the Contractor Compliance file.	ContractorCompliance	No
Contractor Master	Enables selection of the Contractor Master file.	ContractorMaster	No
Deductions – Labor Welfare	Enables selection of the LWF Deduction file.	LWFDeduction	No
Deductions – Professional tax	Enables selection of the PT Deduction file.	PTDeduction	No
Deductions – SCC	Enables selection of the Service Charge file.	ServiceCharge	No
Earnings/Deduction – Master	Enables selection of the Earnings Deduction file.	EarningsDeduction	No
Minimum wage master	Enables selection of the Minimum Wage file.	MiniumWage	No
Principal Employer	Enables selection of the Principal Employer file.	PrincipalEmployer	No
Workmen Wage Details	Enables selection of the Wage Detail file.	WageDetails	No
Trade Skill Wages Detail	Enables selection of the Trade Skill Wage Detail file.	TradeSkillWagesDetail	No

• SFTP connection: Configure the SFTP Connection. See the Configure the SFTP Connection topic.

• Extension tables: Configure the CWFM Import Export extension tables. See the Extension Tables topic.

  For each extension table, enter the following in the DDL Command Name and Commands for execution fields:

DDL Command Name: Principal Employer

Commands for execution:

CREATE TABLE principalemployertable

(

address VARCHAR(255),

bocwact VARCHAR(255),

district VARCHAR(255),

esinumber VARCHAR(255),

factorylicensenumber VARCHAR(255),

factorymanageremailaddress VARCHAR(255),

factorymanagername VARCHAR(255),

ismwactapplicability VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

lwfnumber VARCHAR(255),

maxnoofcontractemployees VARCHAR(255),

maxnoofworkmen VARCHAR(255),

occupiername VARCHAR(255),

pfcodepevalidation15 VARCHAR(255),

principalemployerid VARCHAR(255),

professionaltaxnumber VARCHAR(255),

state VARCHAR(255),

talukatehsil VARCHAR(255),

typeofbusiness VARCHAR(255),

unitname VARCHAR(255),

wcnumber VARCHAR(255)

);

DDL Command Name: Contractor Master

Commands for execution:

CREATE TABLE contractormastertable

(

contractoraddress VARCHAR(255),

contractorcode VARCHAR(255),

contractorname VARCHAR(255),

emailaddress VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

managername VARCHAR(255),

mobileno VARCHAR(255)

);

DDL Command Name: Contractor Compliance

Commands for execution:

CREATE TABLE contractorcompliancetable

(

contractenddate VARCHAR(255),

contractorcode VARCHAR(255),

contractorcoverage VARCHAR(255),

contractstartdate VARCHAR(255),

effectivedate VARCHAR(255),

esinumber VARCHAR(255),

esivalidfrom VARCHAR(255),

esivalidto VARCHAR(255),

gstnumber VARCHAR(255),

ismwapplicability VARCHAR(255),

laborwelfarefund VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

licensenumber VARCHAR(255),

lvalidityenddate VARCHAR(255),

lvaliditystartdate VARCHAR(255),

natureofwork VARCHAR(255),

peidvarchar VARCHAR(255),

pfapplydate VARCHAR(255),

pfnumber VARCHAR(255),

professionaltax VARCHAR(255),

totalstrengthcontractor VARCHAR(255),

wcno VARCHAR(255),

wcvalidfrom VARCHAR(255),

wcvalidto VARCHAR(255)

);

DDL Command Name: Service Charge

Commands for execution:

CREATE TABLE servicechargecontractortable

(

effectivedate VARCHAR(255),

"IN(%ORPERHEAD)" VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

principalempid VARCHAR(255),

servicechargeonovertime VARCHAR(255),

servicechargeonsalary VARCHAR(255),

serviceprovidercode VARCHAR(255)

);

DDL Command Name: Earning Deduction

Commands for execution:

CREATE TABLE earningsdeductiontable

(

actualvalue VARCHAR(255),

calminwageorempwage VARCHAR(255),

dateapplicable VARCHAR(255),

earningordeduction VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

monthlyordaily VARCHAR(255),

skill VARCHAR(255),

trade VARCHAR(255),

unitcode VARCHAR(255),

wagehead VARCHAR(255),

wageheadoramount VARCHAR(255),

wageheadpercentagecal VARCHAR(255),

"WORKMAN TYPE" VARCHAR(255)

);

DDL Command Name: Minimum Wage

Commands for execution:

CREATE TABLE minimumwagetable

(

"CATEGORY/SKILL" VARCHAR(255),

effectivedate VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

minimumbasic VARCHAR(255),

minimumda VARCHAR(255),

minimumhra VARCHAR(255),

minimumothers VARCHAR(255),

trade VARCHAR(255),

unitsapid VARCHAR(255)

);

DDL Command Name: Wage Details

Commands for execution:

CREATE TABLE wagedetailstable

(

aadharnumber VARCHAR(255),

basic VARCHAR(255),

contractorcode VARCHAR(255),

conveyanceallowance VARCHAR(255),

da VARCHAR(255),

effectivedate VARCHAR(255),

employeeid VARCHAR(255),

hardshipallowance VARCHAR(255),

hra VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

skillallowance VARCHAR(255),

specialallowance VARCHAR(255),

uniformallowance VARCHAR(255),

unitsapid VARCHAR(255),

washingallowance VARCHAR(255)

);

DDL Command Name: PT Deduction

Commands for execution:

CREATE TABLE ptdeductiontable

(

amount VARCHAR(255),

effectivedate VARCHAR(255),

endmonth VARCHAR(255),

gender VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

maxgrosssalary VARCHAR(255),

mingrosssalary VARCHAR(255),

startmonth VARCHAR(255),

unit VARCHAR(255)

);

DDL Command Name: LWF Deduction

Commands for execution:

CREATE TABLE lwfdeductiontable

(

amount VARCHAR(255),

"AMOUNT/PERCENT" VARCHAR(255),

effectivedate VARCHAR(255),

empcontributionvalue VARCHAR(255),

frequency VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255),

principalemployerid VARCHAR(255),

upperlimit VARCHAR(255)

);

DDL Command Name: Trade Skill Wages Detail

Commands for execution:

CREATE TABLE TradeSkillWagesDetailTable

(

UnitSapID VARCHAR(255),

Trade VARCHAR(255),

Skill VARCHAR(255),

Basic VARCHAR(255),

DA VARCHAR(255),

HRA VARCHAR(255),

ConveyanceAllowance VARCHAR(255),

SpecialAllowance VARCHAR(255),

SkillAllowance VARCHAR(255),

WashingAllowance VARCHAR(255),

UniformAllowance VARCHAR(255),

HardshipAllowance VARCHAR(255),

EffectiveDate VARCHAR(255),

lastmodifiedby VARCHAR(255),

lastmodifieddate VARCHAR(255)

);

3. Get the URL, User, and Password for the APIGatewayServer.

Version history — CWFM Import Export integration

Version	Description
iPack_v1	Initial release. This integration imports and exports Contract Workforce Management data between SFTP and extension tables.
iPack_v1 (enhancement)	The Import Export integration now supports Level 3 admin access.
	The Import Export integration logic now validates that the Basic and DA values in the WageDetails source file are greater than or equal to the Min Wage – Basic and Min Wage DA values in the MinimumWage source file.
	The CWFM Import Export integration generated an error during import of : the principal employer and contractor master files when a comma (,) was embedded in a data value. the workmen wages file when an Effective Date value fell outside of the current period.

1. Deploy the CWFM Import Export integration

   Note: For more information, see the Deploy Integrations topic.

   1. Open the Integration Template Designer: Select Main Menu  > Administration > Application Setup > Integrations Setup > Design Integration Templates.

      Note: If prompted, enter your Username and Password. Click Tap Log in.

   2. Make sure that the Account is correct. If not, select the right account.

   3. Select the Deploy tab > Integration Packs.
   4. From the list in the left column, search for and select the Pro WFM Contract Workforce Management Extension integration.

      Note: If the integration does not display, select Browse Integration Packs to search for and select the iPack.

   5. Click Tap Install.

   6. From Unattached Environments, select the environment in which to deploy the integration process for the selected integration. Click Tap the double-left arrows button .

2. Configure the CWFM Import Export integration settings A sequence of integrations that can be run on-demand or be scheduled.
   1. Select the environment
      1. Select the Manage tab > Atom Management.
      2. Select your environment.
   2. Select environment extensions
      1. In Administration, click tap Environment Extensions.
      2. In Process Filter, click tap the magnifying glass . It can take several seconds before the button becomes active.
      3. Scroll to and select the integration pack: CWFM Import Export > CWFMImportExport_iPack_v1.
3. Configure connection settings

   Caution: If you select Use Default for the connection settings and process properties, ensure that Value is blank. If Value is not blank, that value overrides the default value whether or not Use Default is selected or cleared. Example: If the default value is abc, but Value shows xyz, the integration uses xyz regardless of the setting of Use Default.

   1. Select Connection Settings.

   2. From the Connection dropdown list, select and configure the following:

      Connection Settings

      Setting	Required	Actions
      CWFMImportExport_iPack_v1_APIGatewayServer	Required	To change the default API gateway server: Clear Use Default. Enter the URL to the server. Example: <tenantURL>/api
      CWFMImportExport_iPack_v1_SFTPServer	Required	The SFTP server setting defines the connection to the file that contains the records. Integrations access only the internal SFTP account. To change the default SFTP server parameters: For each field, clear Use Default. Enter the following values: Enter the name of the internal Host. Enter the number of the Port for the internal SFTP account. In User, enter the username for the internal SFTP account. In Password, select <Encrypted>. Enter the new password for the internal SFTP account. Click Tap Apply.
      CWFMImportExport_iPack_v1_ExtensionConnection	Required	Provide the connection details for Extension Table where data is stored: User Password Class Name Connection URL
      CWFMImportExport_iPack_v1_ImportValidation_CRT	Required	Enable Override.
      CWFMImportExport_iPack_v1_SFTPParameter_CRT	Required	Enable Override.
      CWFMImportExport_iPack_v1_Locale_CRT	Required	Enable Override.

4. Configure process properties
   1. Select Process Properties.

      Caution: Do not edit the default values of the AuthenticationProperties. By default, cookies are enabled and set the values for authentication properties.

   2. Select CWFMImportExport_iPack_v1_CRTConfig to set process properties that must be configured before the integration can run. This main process starts the integration process and handles errors.

      Process properties

      Process property name	Column header value
      _CWFMImportExport_iPack_v1__ImportValidation_CRT	Validation Name,Is Applicable,Value
      _CWFMImportExport_iPack_v1_SFTPParameter_CRT	Filename,Import File Name,Import Location,File Sequence,Export File Name,Export File Location,Archive File Location
      _CWFMImportExport_iPack_v1_Locale_CRT	Parameter Name,Locale Policy,Message,Description

1. Configure cross-reference tables

   Cross-reference tables (CRT) are the look-up tables that the integrations use to translate parameter values. One or more data values from the source system can be used to assign one or more parameters in the destination system.

   • If more than one row matches a reference value, the first match is the output value.
   • If no match is found, the output value can be null, or the integration can produce errors.

   1. Select Cross Reference.

   2. From the Cross Reference list, select a CWFMImportExport_iPack_v1 table.

   3. Select Override, which allows you to:

      • Download the tables when you run the integration

      • Edit the table cells in Extensions

   4. When you finish, click tap OK.

   5. Repeat the steps for each of the CWFMImportExport tables.
      • CWFMImportExport_iPack_v1__ImportValidation_CRT: Identifies the verification requirements that entity data must meet before it is imported into the system.

        CWFM Import Export — Import Validation CRT structure

        Column name	Description
        Validation Name	Name of the validation applied to imported data. Supported values are limited to: WageTypeValue PFCodeLength FrequencyValue ESICNumberLength EarningDeductionMasterValue DAWage BasicWage AmountPercentMasterValue
        Is Applicable	Boolean value that determines whether validation is required.
        Value	Value for which validation is performed.

        CWFM Import Export — Import Validation CRT sample content

        Validation Name	Is Applicable	Value
        WageTypeValue	Yes	Earned / Employee wage / Minimum wage
        PFCodeLength	Yes	15
        FrequencyValue	Yes	Daily / Monthly / Yearly
        ESICNumberLength	Yes	17
        EarningDeductionMasterValue	Yes	Earning / Deduction
        DAWage	Yes	>min DAWage
        BasicWage	Yes	>min BaseWage
        AmountPercentMasterValue	Yes	Amount / Percent

      • CWFMImportExport_iPack_v1_SFTPParameter_CRT: Controls the SFTP location and data file information.

        CWFM Import Export — SFTP Parameter CRT structure

        Column name	Description
        File Name	Name of the file for which the location must be configured. Supported values are limited to: ContractorCompliance ContractorMaster PrincipalEmployer WageDetails MinimumWage EarningsDeduction LWFDeduction PTDeduction ServiceCharge TradeSkillWagesDetail
        Import File Name	Import file name. Note: You can use an asterisk (*) as a wildcard.
        Import Location	Import file location.
        File Sequence	Priority processing order of the associated file.
        Export File Name	Export file name.
        Export File Location	Export file location.
        Archive File Location	Archive file location.

      • CWFMImportExport_iPack_v1_Locale_CRT: Allows translation of messages and labels into different languages.

        CWFM Import Export — Locale CRT structure

        Column name	Description
        Parameter Name	Key for which localization is defined.
        Locale Policy	Locale Policy. You can use an asterisk (*) as a wildcard, but put the less-restrictive locale policy names at the bottom of the table because the integration scans cross-reference tables from the top.
        Message	Message shown in Additional Details, or value of the label defined in the Run Summary section. Example: Comment was not provided.
        Description	The description that is shown in Additional Details, or value of the label defined in the Run Summary section. Example: The employee is not assigned a shift.

        Note:

        • Localization of integration extensions remains optional, but is supported.

        • The cross-reference table (CRT) holds all messages represented with standard English labels; these apply to all locales when the Locale is set to a wildcard (*).

        • Some or all messages can be translated by adding lines to the table in their preferred translation for specific locales. Messages for the most commonly used Locale Policy should be defined at the top of the CRT.

        • Names of the parameters in the CRT column "Parameter Name" must be used as is. If any parameter value needs to be localized for a different Locale Policy, copy the "Parameter Name" with the * Locale Policy, add a new row to the CRT with the appropriate Locale Policy, and then add the localized values in the Message (or Value) and Description CRT columns.

        • Do not enter values in the CRT column "Description" if it is blank.

        • Do not modify placeholders (<>) or the configurable values that are included in the CRT column "Message" (or "Value").

        CWFM Import Export — Locale CRT sample content

        Parameter Name	Locale Policy	Message	Description
        Error_DeleteFileNotFound	*	Delete File name not found.	When DeleteFileName was not found in SFTP Lookup.
        Error_DuplicateRecords	*	This record already exists in database.
        Error_FileNameNotMatched	*	Selected List File does not match the File parameter name.	When selected List parameter does not match the text parameter.
        Error_FileNotSelected	*	File name is not configured.	When a file was selected during configuration of the List parameter.
        Error_InvalidAppendTimeStamp	*	Invalid AppendTimeStamp configured.	When an incorrect AppendTimeStamp is passed by the integration.
        Error_InvalidDateFormat	*	Invalid DateFormat configured.	When an incorrect DateFormat is passed by the integration.
        Error_PatternNotMatched	*	File pattern does not match the CRT definition.	When the text pattern passed does not match the CRT configuration for the respective file.
        Error_SFTPConnecttionError	*	Unable to connect to SFTP.	Unable to connect to SFTP.
        Label_ContractorComplianceProcessedRecords	*	Contractor Compliance Processed Records
        Label_ContractorMasterProcessedRecords	*	Contractor Master Processed Records
        Label_EarningsDeductionProcessedRecords	*	Earnings Deduction Processed Records
        Label_ExportFiles	*	Export Files
        Label_FailedExportFiles	*	Failed Export Files
        Label_FailedImportFiles	*	Failed Import Files
        Label_Importedfile	*	Imported file
        Label_ImportFiles	*	Import Files
        Label_IntegrationExecutionId	*	Integration Execution ID
        Label_IntegrationTypeName	*	Integration Type
        Label_LWFDeductionProcessedRecords	*	LWF Deduction Processed Records
        Label_MinimumWageProcessedRecords	*	Minimum Wage Processed Records
        Label_PrincipalEmployerProcessedRecords	*	Principal Employer Processed Records
        Label_PTDeductionProcessedRecords	*	PTDeduction Processed Records
        Label_ServiceChargeContractorProcessedRecords	*	Service Charge Contractor Processed Records
        Label_TradeSkillWagesDetailDeletedRecords	*	Trade Skill Wage Detail Deleted Records
        Label_TradeSkillWagesProcessedRecords	*	Trade Skill Wages Processed Records
        Label_WageDetailsProcessedRecords	*	Wage Details Processed Records
        Message_AdditionalDetailsWithErrors	*	Integration completed with errors.
        Message_AdditionalDetailsWithoutErrors	*	Integration completed without errors.
        Message_ContractorCodeNotPresentContractorMaster	*	ContractorCode not present in Contractor Master.
        Message_IncorrectAmountPercent	*	Incorrect Percent/Amount Value Provided.
        Message_IncorrectBasicDAWage	*	Incorrect DA Wage Provided (less than amount in minimum wage table).
        Message_IncorrectBasicWage	*	Incorrect Basic Wage Provided (less than amount in Minimum Wage Table).
        Message_IncorrectDateFormat	*	Incorrect Date Format in file.
        Message_IncorrectEarningDeduction	*	Invalid value in "Earning or Deduction" column.
        Message_IncorrectEffectiveDate	*	Effective Date range for this record cannot be found in Minimum Wage table.
        Message_IncorrectESICNumber	*	Incorrect number of characters defined for the ESIC Number.
        Message_IncorrectFrequencyValue	*	Incorrect Frequency Value defined.
        Message_IncorrectPFCodeLength	*	Incorrect PF Code Length Provided.
        Message_IncorrectWageType	*	Incorrect Value in "Minimum or Employee Wage" column.
        Message_MandatoryFieldRequired	*	Empty mandatory field <FieldName>.
        Message_PEandContractorNotFound	*	Principal Employer and/or Contractor not found in the system.
        Message_PEIDNotPresentMinimumWage	*	This PE ID does not exist in the Minimum Wage table.

After the integrations are deployed and the connection settings and process properties are configured, install the integrations to make them available for running or scheduling.

1. Select Main Menu  > Administration > Application Setup > Integrations Setup > Install Integrations.
2. Click Tap Create .
3. In Integration Name enter a unique name, such as CWFMImportExport_iPack_v1.
4. (Optional) Enter a Description.

   Note: Do not select API Integration.

5. In File Access, select Source/Outbound download.
6. (Optional) If the person who runs the integration does not have full access to integrations, select Execute Integration with System Account. This allows the integration access to all APIs in the FAP, and the relevant permissions and data, regardless of the FAP and GDAP of the person who runs the integration.

7. (Optional) Select Re-Run to allow repeated runs of the integration with the same parameter values as the previous run.

8. Email Notifications

   (Optional)

   1. Select Yes to send email and control center notifications for integration runs.
   2. Enter the email addresses of the recipients for the following types of run status. For multiple recipients, separate the addresses by a comma, but no spaces:

      In Progress — The integration run started and has not finished.

      Completed — The integration ran successfully without errors.

      Failed — The integration ran successfully, but one or more records have errors. The integration run is treated as failed. If Abort on Failure is configured in an integration set, the integration set stops.

      Completed with Errors — The integration run has errors or could not run.

9. In Skip Configuration, select None (default) to allow multiple integrations to run at the same time or with the same data without restrictions.

   Note: Do not select Allow Minute Interval.

10. Integration template and parameters
    1. In Integration Template, select CWFMImportExport_iPack_v1.
    2. Click Tap Assign .
    3. In Integration Parameters, you can override default settings. Click Tap Create.
    4. Complete the configuration for each parameter value.

    5. Click Tap Save.

       Repeat this step for each integration parameter that supports the CWFM Import Export process.

       CWFM Import Export — Integration Parameters

       Parameter name	Description / Default value / User prompt	Template parameter	Parameter type
       ActionType	List that contains the action choices. Parameter value = ContractWorkForceManagement_ActionType User prompt = Yes Mandatory = Yes	ActionType	Dropdown
       File(s)	List that contains import and export files. Parameter value = ContractWorkForceManagement_Files User prompt = Yes Mandatory = Yes	File(s)	List
       DateFormat	Date format to which all dates in the import and export files must adhere. Supported values include: MM/dd/yyyy MM-dd-yyyy dd/MM/yyyy dd-MM-yyyy (default) yyyy/MM/dd yyyy-MM-dd	DateFormat	Text
       AppendDateTimeStamp	Date and time format to which the integration adheres when appending the date and time to archive and error files. Supported values include: dd-MM-yyyy'T'hhmmSSS (default) MM-dd-yyyy'ThhmmSSS User prompt = No Mandatory = Yes	AppendDateTimeStamp	Text
       DeleteFilePrefix	Prefix that identifies import files which will be deleted. Default = DELETE User prompt = No Mandatory = Yes	DeleteFilePrefix	Text
       Principal Employer File Name	Name used to identify the principal employer file. User prompt = Yes Mandatory = No	PrincipleEmployerFileName	Text
       Contractor Compliance File Name	Name used to identify the contractor compliance file. User prompt = Yes Mandatory = No	ContractorComplianceFileName	Text
       Contract Master File Name	Name used to identify the contract master file. User prompt = Yes Mandatory = No	ContractMasterFileName	Text
       Workman Wage Details File Name	Name used to identify the workman wage details file. User prompt = Yes Mandatory = No	WorkmanWageDetailsFileName	Text
       Minimum Wages File Name	Name used to identify the minimum wages file. User prompt = Yes Mandatory = No	MinimumWagesFileName	Text
       Deduction Labour Welfare Fund File Name	Name used to identify the Deduction Labor Welfare Fund file. User prompt = Yes Mandatory = No	DeductionLabourWelfareFundFileName	Text
       Deduction Professional Tax File Name	Name used to identify the deduction professional tax deduction file. User prompt = Yes Mandatory = No	DeductionProfessionalTaxFileName	Text
       Deduction Service Charge Con File Name	Name used to identify the service charge con deduction file. User prompt = Yes Mandatory = No	DeductionServiceChargeFileName	Text
       Earning Deduction Master File Name	Name used to identify the earning deduction master file. User prompt = Yes Mandatory = No	EarningDeductionMasterFileName	Text
       ErrorOutputDirectory	Location where error files are generated. Default = /Outbound/Error User prompt = No Mandatory = Yes	OutputDirectory	Text
       SFTPAction	SFTP Action to perform when files with the same name exist in the remote directory. Supported case-sensitive values include: Create New Name Append Overwrite (default) Error User prompt = No Mandatory = Yes	Action	Text
       IsNewWageDetailsApplicable	Determines whether to import or export the trade skill wages detail table. Default = true User prompt = No Mandatory = Yes	IsNewWageDetailsApplicable	Text
       SupportUsers	Semicolon-separated list of person numbers that identifies individuals who are allowed to export data. User prompt = No Mandatory = No	SupportUsers	Text

11. Make sure that the generic data access profiles (GDAP) allow access by the people who need to run the installed integrations. See Configure Access to Integrations.

Run integrations to test that the configuration is set up correctly.

1. Run the integration
   1. Select the integration:
      1. Select Main Menu  > Maintenance > Integrations. 
      2. Click Tap Run an Integration . 
      3. Select the CWFMImportExport_iPack_v1 integration from the list. Click Tap Select. 
      4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the system assigns a default name, which ends with a date and time stamp.
   2. Set parameters as follows:
      • Action Type: Select the action type to perform.
      • File(s): Chose the file or files for the import or export action.
      • Principal Employer File Name: Select the Principal Employer file.
      • Contractor Compliance File Name: Select the Contractor Compliance file.
      • Contract Master File Name: Select the file.
      • Workman Wage Details File Name: Select the Contract Master file.
      • Minimum Wages File Name: Select the Minimum Wages file.
      • Deduction Labour Welfare Fund File Name: Select the Deduction Labour Welfare Fund file.
      • Deduction Professional Tax File Name: Select the Deduction Professional Tax file.
      • Deduction Service Charge Con File Name: Select the Deduction Service Charge Con file.
      • Earning Deduction Master File Name: Select the Earning Deduction Master file.

   3. Select the following:

      • Run Integration: If this is the first time this integration is being run.
      • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter values again. Click Tap Yes to continue, or No to not run the integration and to return to the parameter settings.

   4. Wait for the confirmation that the integration completed or failed. Close the panel.
   5. Click Tap Refresh . 
   6. To see details, select the integration run. Select Run Summary.
2. Check the results

   Status indicators

   •  In-Progress: The run of this integration has not yet completed.
   •  Completed: The integration ran successfully without errors.
   •  Scheduled: This integration is scheduled to run later or repeatedly.
   • (Grayed out) Scheduled but Deleted: This integration is scheduled to run, but the integration template has been deleted. When it runs, it will generate an error. To prevent this error, delete the scheduled integration run.
   •  Completed with Errors: The integration ran successfully, but one or more records have errors. The integration run is treated as failed. If Abort on Failure is configured in an integration set, the integration set stops.
   •  Failed: The integration run has errors or could not run.
   • To troubleshoot and resolve errors, do the following:

     Check the Run Summary for details.

     • To troubleshoot all types of errors, or if the Run Summary shows a large number of errors, click tap Go to Additional Details (if available), or click tap the Source File to open and examine the input source file.
     • (Only for import integrations) To troubleshoot and resubmit integrations that have transactional or data errors, click tap Go to Transaction Assistant Corrects transaction errors in integrations without the need to resubmit entire projects..

   To check the results in more detail:

   1. Click Tap the tile A container that provides navigation or action from its summary view. for the integration run.
   2. Click Tap Run Summary to see the results of the integration run.

      Example Run Summary details

      Note: The available details vary by integration and configuration.

      • Integration Run Name: Name of this run of the integration.
      • Process Name: Name of any integration set that includes this integration.
      • Integration Name: Name of the installed integration.
      • Integration Reference ID: Unique identifier for this integration run (to help in troubleshooting errors).
      • User: The person or user account that ran the integration.
      • Integration Type: Import, Export, or None
      • Start Date: Date and time when the integration run started.
      • End Date: Date and time when the integration run finished.
      • Status: In-Progress, Completed, Completed with Errors, or Failed.
      • Records Processed: Number of records that were processed.
      • Records Created: Number of records that were created.
      • Errors: Number of records that failed.
      • Source Files, Output File, and Error Files: For file-based import integrations, use Manage SFTP to access the source and output files on the inbound (source) and outbound (destination) SFTP folders. See the Manage SFTP topic.
   3. Log in to the destination system and ensure that the data has been correctly updated.

   Note: You can schedule integrations and integration sets to run once later or at a recurring frequency. See the Schedule Integrations topic.

Contractor Compliance

Contractor Master

Principal Employer

Wage Details

Trade Skill Wage Details

Minimum Wage

Earnings and Deductions

Labor Welfare Fund Deduction

Professional Tax Deduction

Service Charge

Export file — CWFM Import Export integration

Export file structure is similar to the source files, but includes two extra columns:

• Last Modified Date

• Last Modified By

Error files — CWFM Import Export integration

Error files capture invalid or duplicate data that already exists in the database. The file structure is similar to the source file, but includes one extra column:

• Error Message

Archive files — CWFM Import Export integration

Processed source files are moved to the archive folder.

Before you configure the CWFM People Import integration, you must do the following:

1. Configure Access to Integrations

2. Configure the following:

   • SFTP connection: Configure the SFTP Connection. See the Configure the SFTP Connection topic.

   • Extension tables: Configure the People Import extension tables. See the Extension Tables topic.

     Enter the following in the DDL Command Name and Commands for execution fields:

     DDL Command Name: AadharNumberCheckTable

     Commands for execution:

     CREATE TABLE AadharNumberCheckTable

     (

     PersonNumber VARCHAR(255),

     PersonId VARCHAR(255),

     AadharNumber VARCHAR(255));

3. Get the URL, User, and Password for the APIGatewayServer.

Version history — CWFM People Import integration

Version	Description
iPack_v1	Initial release. This integration imports Contract Workforce Management (CWFM) workers into the application.
iPack_v1 (enhancement)	The CWFM People Import integration allows multiple date formats where masking is supported.
	The CWFM People Import integration failed with a license error when the compound key returned with a blank value.

1. Deploy the CWFM People Import integration

   Note: For more information, see the Deploy Integrations topic.

   1. Open the Integration Template Designer: Select Main Menu  > Administration > Application Setup > Integrations Setup > Design Integration Templates.

      Note: If prompted, enter your Username and Password. Click Tap Log in.

   2. Make sure that the Account is correct. If not, select the right account.

   3. Select the Deploy tab > Integration Packs.
   4. From the list in the left column, search for and select the Pro WFM Contract Workforce Management Extension integration.

      Note: If the integration does not display, select Browse Integration Packs to search for and select the iPack.

   5. Click Tap Install.

   6. From Unattached Environments, select the environment in which to deploy the integration process for the selected integration. Click Tap the double-left arrows button .

2. Configure the CWFM People Import integration settings
   1. Select the environment
      1. Select the Manage tab > Atom Management.
      2. Select your environment.
   2. Select environment extensions
      1. In Administration, click tap Environment Extensions.
      2. In Process Filter, click tap the magnifying glass . It can take several seconds before the button becomes active.
      3. Scroll to and select the integration pack: CWFM People Import > CWFMPeopleImport_iPack_v1.
3. Configure connection settings

   Caution: If you select Use Default for the connection settings and process properties, ensure that Value is blank. If Value is not blank, that value overrides the default value whether or not Use Default is selected or cleared. Example: If the default value is abc, but Value shows xyz, the integration uses xyz regardless of the setting of Use Default.

   1. Select Connection Settings.

   2. From the Connection dropdown list, select and configure the following:

      Connection Settings

      Setting	Required	Actions
      CWFMPeopleImport_iPack_v1_APIGatewayServer	Required	To change the default API gateway server: Clear Use Default. Enter the URL to the server. Example: <tenantURL>/api
      CWFMPeopleImport_iPack_v1_SFTPServer	Required	The SFTP server setting defines the connection to the file that contains the records. Integrations access only the internal SFTP account. To change the default SFTP server parameters: For each field, clear Use Default. Enter the following values: Enter the name of the internal Host. Enter the number of the Port for the internal SFTP account. In User, enter the username for the internal SFTP account. In Password, select <Encrypted>. Enter the new password for the internal SFTP account. Click Tap Apply.
      CWFMPeopleImport_iPack_v1_ExtensionConnection	Required	Provide the connection details for Extension Table where data is stored: User Password Class Name Connection URL
      CWFMPeopleImport_iPack_v1_Status_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_CompoundKey_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_PayPolicy_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_License_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_Accrual_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_RoleManager_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_Profile_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_RoleEmployee_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_BusinessStructure_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_Schedule_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_AttendanceLeave_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_EmploymentTerm_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_Work_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_ RoleMgrAttributeExclusions_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_ ExistingEmpDates_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_CustomFields_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_ImportValidation_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_Timezone_CRT	Required	Enable Override.
      CWFMPeopleImport_iPack_v1_Locale_CRT	Required	Enable Override.

4. Configure process properties
   1. Select Process Properties.

      Caution: Do not edit the default values of the AuthenticationProperties. By default, cookies are enabled and set the values for authentication properties.

   2. Select CWFMPeopleImport_iPack_v1_CRTConfig to set process properties that must be configured before the integration can run. This main process starts the integration process and handles errors.

      Process properties

      Process property name	Column header value
      _CWFMPeopleImport_iPack_v1_Status_CRT	Source Status,Dimension Status
      _CWFMPeopleImport_iPack_v1_CompoundKey_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Key 6,Key 7,Key 8,Key 9,Key 10,Compound Key
      _CWFMPeopleImport_iPack_v1_PayPolicy_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Adjustment Rule,Emp Percent Allocation Rule
      _CWFMPeopleImport_iPack_v1_License_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Employee Role,Manager Role,Timekeeping,Attendance & Leave,Scheduling,Analytics,Work
      _CWFMPeopleImport_iPack_v1_Accrual_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Accrual Profile,Cascade Profile
      _CWFMPeopleImport_iPack_v1_RoleManager_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Mgr Pay Code Edit Profile,Mgr Pay Code View Profile,Mgr Work Rule Profile,Mgr Reports Profile,Mgr Hyperfind Schedule Visibility Profile,Mgr Process Profile,Mgr Delegate Profile,GDAP Profile,MMR Symbolic Reviewer
      _CWFMPeopleImport_iPack_v1_Profile_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Function Access Profile,Display Profile,Locale Profile,Notification Profile,User Logon Profile,Authentication Type,Access Method Profile
      _CWFMPeopleImport_iPack_v1_RoleEmployee_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Emp Time Entry Method,Emp Pay Code Edit Profile,Emp Work Rule  Profile,Emp Worker Type,Emp Device Group,Emp Device Profile,Emp Process Profile,Emp Attestation The act of confirming or attesting that something is true. For example, when punching out, users may need to attest that they took their meal breaks. Profile,Emp Pay Code Values Profile,Reviewer Override|Reviewer List,Analytics Labor Type
      _CWFMPeopleImport_iPack_v1_BusinessStructure_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Mgr Labor Category Profile,Mgr Emp Group,Mgr Job Transfer Set,Mgr Forecasting Category Profile,Emp Job Transfer Set,Emp Labor Category Profile,Mgr Hyperfind for Home Employees,Manager Additions Job Transfer Set,Manager Additions Labor Category Profile
      _CWFMPeopleImport_iPack_v1_Schedule_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Mgr Sched Group Profile,Mgr Shift Template A shift that has a name and defined segments and attributes, but no date or assigned employee. Profile,Mgr Pattern Template A repeating pattern of shifts and paycodes that is saved with a name, but without dates or assigned employees. Profile,Emp Shift Template,Emp Schedule Group Assembles employees who share schedules or any other work characteristics.,Emp Schedule Rule Defines restrictions and requirements to ensure that a schedule meets certain criteria. Set,Minor Rule Legally binding scheduling rules and penalties that regulate minor employees, who are typically aged 14 to 18.,Minor School Calendar
      _CWFMPeopleImport_iPack_v1_AttendanceLeave_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Attendance Profile,Attendance Admin,Leave Profile,Leave Admin
      _CWFMPeopleImport_iPack_v1_EmploymentTerm_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Employment Term
      _CWFMPeopleImport_iPack_v1_Work_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Activity Tracking Status,Activity Profile,Default Activity,Idle Time,Meal,Paid Break,Auto Resolve
      _CWFMPeopleImport_iPack_v1_ RoleMgrAttributeExclusions_CRT	Key 1,Key 2,Key 3,Key 4,Key 5,Person Number
      _CWFMPeopleImport_iPack_v1_ ExistingEmpDates_CRT	Dimension Field,SetTo: 'CPPStart OR 'CurrentDate' OR 'File',
      _CWFMPeopleImport_iPack_v1_CustomFields_CRT	Source File Field,Label Value
      _CWFMPeopleImport_iPack_v1_ImportValidation_CRT	Validation Name,Is Applicable,Value
      _CWFMPeopleImport_iPack_v1_Timezone_CRT	Source Time Zone,Dimension Status Time Zone
      _CWFMPeopleImport_iPack_v1_Locale_CRT	Parameter Name,Locale Policy,Message,Description

1. Configure cross-reference tables

   Cross-reference tables (CRT) are the look-up tables that the integrations use to translate parameter values. One or more data values from the source system can be used to assign one or more parameters in the destination system.

   • If more than one row matches a reference value, the first match is the output value.
   • If no match is found, the output value can be null, or the integration can produce errors.

   1. Select Cross Reference.

   2. From the Cross Reference list, select a CWFMPeopleImport_iPack_v1 table.

   3. Select Override, which allows you to:

      • Download the tables when you run the integration

      • Edit the table cells in Extensions

   4. When you finish, click tap OK.

   5. Repeat the steps for each of the CWFMPeopleImport tables.
      • CWFMPeopleImport_iPack_v1_Status_CRT: Identifies status mapping between the source file and the application.

        CWFM People Import — Status CRT structure

        Column name	Description
        Source Status	Status value contained in the source file.
        Dimension Status	Corresponding status value in the application.

        CWFM People Import — Status CRT sample content

        Source Status	Dimension Status
        Active	Active
        Inactive	Inactive
        Terminated	Terminated

      • CWFMPeopleImport_iPack_v1_CompoundKey_CRT: Controls the creation of compound keys.

        CWFM People Import — Compound Key CRT structure

        Column name	Description
        Key 1	Generic key that is set at runtime.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Key 6	Generic key that is set at runtime.
        Key 7	Generic key that is set at runtime.
        Key 8	Generic key that is set at runtime.
        Key 9	Generic key that is set at runtime.
        Key 10	Generic key that is set at runtime.
        Compound Key	The compound key that is determined by the combination of one or more keys (Key 1 — Key 10). Compound keys provide restriction criteria during the import of people data.

        CWFM People Import — Compound Key CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Key 6	Key 7	Key 8	Key 9	Key 10	Compound Key
        Home Business Structure Represents the logical structure of an organization as it concerns staffing. It contains the locations and jobs to which an employee may be assigned. Level 5	Home Business Structure Level 6	Home Business Structure Level 7	Home Business Structure Level 8	Home Business Structure Level 9						Default
        Minda Location	Minda Site A	9900	73733	Minda Unit A						Compound Key1

      • CWFMPeopleImport_iPack_v1_PayPolicy_CRT: Controls the pay policy rules for person assignment.

        CWFM People Import — Pay Policy CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Pay Rule	Pay Rule that is assigned to a person.
        Adjustment Rule	Adjustment Rule that is assigned to a person.
        Emp Percent Allocation Rule	Percent Allocation Rule that is assigned to a person.

        CWFM People Import — Pay Policy CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Pay Rule	Adjustment Rule	Emp Percent Allocation Rule
        *	MANUFACTURING inc.	India	1001	*	Basic + OT Approval
        *	Aarti Industries	2402	404617		Full Time	CLRA Adjustment Rule	Two Forty Rule

      • CWFMPeopleImport_iPack_v1_License_CRT: Controls the entitlements for person assignment.

        CWFM People Import — License CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Employee Role	Employee Role that is assigned to a person.
        Manager Role	Manager Role that is assigned to a person.
        Timekeeping	Timekeeping license that is assigned to a person.
        Attendance & Leave	Attendance & Leave license that is assigned to a person.
        Scheduling	Scheduling license that is assigned to a person.
        Analytics	Analytics license that is assigned to a person.
        Work	Work license that is assigned to a person.

        CWFM People Import — License CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Employee Role	Manager Role	Timekeeping	Attendance & Leave	Scheduling	Analytics	Work
        *	MANUFACTURING inc.	India	1001	*	Employee	Manager	Hourly Timekeeping	Absence	Scheduling	Analytics
        I	CWFM	2402	404617		Employee	Manager	Hourly Timekeeping	Absence	Scheduling	Analytics

      • CWFMPeopleImport_iPack_v1_Accrual_CRT: Controls the Accrual and Cascade Profiles for person assignment.

        CWFM People Import — Accrual CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Accrual Profile	Accrual Profile that is assigned to a person.
        Cascade Profile	Cascade Profile that is assigned to a person.

        CWFM People Import — Accrual CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Accrual Profile	Cascade Profile
        *	MANUFACTURING inc.	India	1001	*	Manager + Accrual Pool A type of accrual code used as an emergency fund that employees can donate time to and can be drawn upon by employees in need.
        I	CWFM	2402	404617		6month	HD Cascade

      • CWFMPeopleImport_iPack_v1_RoleManager_CRT: Controls the manager profile assignments.

        CWFM People Import — Role Manager CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Mgr Pay Code Edit Profile	Pay Code Edit Profile that is assigned to a manager.
        Mgr Pay Code View Profile	Pay Code View Profile that is assigned to a manager.
        Mgr Work Rule Profile	Work Rule Profile that is assigned to a manager.
        Mgr Reports Profile	Reports Profile that is assigned to a manager.
        Mgr Hyperfind Schedule Visibility Profile	Hyperfind Profile that is assigned to a manager.
        Mgr Process Profile	Process Profile that is assigned to a manager.
        Mgr Delegate Profile	Delegate Profile that is assigned to a manager.
        GDAP Profile	GDAP Profile that is assigned to a manager.
        MMR Symbolic Reviewer	Symbolic Reviewer that is assigned to a manager.

        CWFM People Import — Role Manager CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Mgr Pay Code Edit Profile	Mgr Pay Code View Profile	Mgr Work Rule Profile	Mgr Reports Profile	Mgr Hyperfind Schedule Visibility Profile	Mgr Process Profile	Mgr Delegate Profile	GDAP Profile	MMR Symbolic Reviewer
        *	MANUFACTURING inc.	India	1001	Machine Shop	All Pay Codes - Cleaned		All Work Rules	ALL REPORTS			Retail Managers Delegate Profile	All Access - Cleaned

      • CWFMPeopleImport_iPack_v1_Profile_CRT: Controls profile assignments.

        CWFM People Import — Profile CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Function Access Profile	Function Access Profile that is assigned to a person.
        Display Profile	Display Profile that is assigned to a person.
        Locale Policy	Locale Policy that is assigned to a person.
        Notification Profile	Notification Profile that is assigned to a person.
        User Logon Profile	User Logon Profile that is assigned to a person.
        Authentication Type	Authentication Type that is assigned to a person.
        Access Method Profile	Access Method Profile that is assigned to a person.

        CWFM People Import — Profile CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Function Access Profile	Display Profile	Locale Policy	Notification Profile	User Logon Profile	Authentication Type	Access Method Profile
        Compound Key 1	CWFM	3002	Noida	500532	Education Manager	Austria Test Locale Profile	American English	E-mail Only	Default	Basic	CLRA Person Import

      • CWFMPeopleImport_iPack_v1_RoleEmployee_CRT: Controls employee role assignments.

        CWFM People Import — Role Employee CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Emp Time Entry Method	Time Entry Method that is assigned to a person.
        Emp Pay Code Edit Profile	Pay Code Edit Profile that is assigned to a person.
        Emp Work Rule Profile	Work Rule Profile that is assigned to a person.
        Emp Worker Type	Worker Type that is assigned to a person.
        Emp Device Group	Device Group that is assigned to a person.
        Emp Device Profile	Device Profile that is assigned to a person.
        Emp Process Profile	Process Profile that is assigned to a person.
        Emp Attestation Profile	Attestation Profile that is assigned to a person.
        Emp Pay Code Values Profile	Pay Code Values Profile that is assigned to a person.
        Reviewer Override|Reviewer List	Reviewer List that is assigned to a person.
        Analytics Labor Type	Analytics Labor Type that is assigned to a person.
        Approval Method Name	Approval method that is assigned to a person.

        CWFM People Import — Role Employee CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Emp Time Entry Method	Emp Pay Code Edit Profile	Emp Work Rule Profile	Emp Worker Type	Emp Device Group	Emp Device Profile	Emp Process Profile	Emp Attestation Profile	Emp Pay Code Values Profile	Reviewer Override | Reviewer List	Analytics Labor Type	Approval Method Name
        *	MANUFACTURING inc.	India	1001	*	Hourly View	All Pay Codes - Cleaned		Full Time							Full Time

      • CWFMPeopleImport_iPack_v1_BusinessStructure_CRT: Controls manager business structure assignments.

        CWFM People Import — Business Structure CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Mgr Labor Category Profile	Labor Category Profile that is assigned to a manager.
        Mgr Emp Group	Employee Group that is assigned to a manager.
        Mgr Job Transfer Set	Manager Job Transfer Set that is assigned to a manager.
        Mgr Forecasting Category Profile	Forecasting Category Profile that is assigned to a manager.
        Emp Job Transfer Set	Employee Job Transfer Set that is assigned to a manager.
        Emp Labor Category Profile	Employee Labor Category Profile that is assigned to a manager.
        Mgr Hyperfind for Home Employees	Home Employees Hyperfind that is assigned to a manager.
        Manager Additions Job Transfer Set	Additional Job Transfer Set that is assigned to a manager.
        Manager Additions Labor Category Profile	Additional Labor Category Profile that is assigned to a manager.

        CWFM People Import — Business Structure CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Mgr Labor Category Profile	Mgr Emp Group	Mgr Job Transfer Set	Mgr Forecasting Category Profile	Emp Job Transfer Set	Emp Labor Category Profile	Mgr Hyperfind for Home Employees	Manager Additions Job Transfer Set	Manager Additions Labor Category Profile	Reviewer Override | Reviewer List
        *	MANUFACTURING inc.	India	1001	*		All Organizational Groups	All Organizational Groups

      • CWFMPeopleImport_iPack_v1_Schedule_CRT: Controls Scheduling assignments to a person.

        CWFM People Import — Schedule CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Mgr Sched Group Profile	Schedule Group Profile that is assigned to a person.
        Mgr Shift Template Profile	Shift Template Profile that is assigned to a person.
        Mgr Pattern Template Profile	Pattern Template Profile that is assigned to a person.
        Emp Shift Template	Shift Template that is assigned to a person.
        Emp Schedule Group	Schedule Group that is assigned to a person.
        Emp Schedule Rule Set	Schedule Rule Set that is assigned to a person.
        Minor Rule	Minor Rule that is assigned to a person.
        Minor School Calendar	Minor School Calendar that is assigned to a person.

        CWFM People Import — Schedule CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Mgr Schedule Group Profile	Mgr Shift Template Profile	Mgr Pattern Template Profile	Emp Shift Template	Emp Schedule Group	Emp Schedule Rule Set	Minor Rule	Minor School Calendar
        *	UNO Minda	Minda Region A	Minda District A	Minda B_Unit	Metro Hosp Group DAP	Hours And Dollars Allocation	Hours And Dollars Allocation	Hours And Dollars Allocation	CTP01	MRSP	US

      • CWFMPeopleImport_iPack_v1_AttendanceLeave_CRT: Controls Attendance and Leave assignments to a person.

        CWFM People Import — Attendance Leave CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Attendance Profile	Attendance Profile that is assigned to a person.
        Attendance Admin	Attendance Admin that is assigned to a person.
        Leave Profile	Leave Profile that is assigned to a person.
        Leave Admin	Leave Admin that is assigned to a person.

        CWFM People Import — Attendance Leave CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Attendance Profile	Attendance Admin	Leave Profile	Leave Admin
        *	UNO Minda	Minda Region A	Minda District A	Minda B_Unit	Full Time Employee Profile	AHC01	DC Leave	AHC01

      • CWFMPeopleImport_iPack_v1_EmploymentTerm_CRT: Controls Employment Term assignments to a person.

        CWFM People Import — Employment Term CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Employment Term	Employment Term that is assigned to a person.

        CWFM People Import — Employment Term CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Employment Term
        *	UNO Minda	Minda Region A	Minda District A	Minda B_Unit	5 days averaging

      • CWFMPeopleImport_iPack_v1_Work_CRT: Controls Work assignments to a person.

        CWFM People Import — Work CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Activity Tracking Status	Activity Tracking Status that is assigned to a person.
        Activity Profile	Activity Profile that is assigned to a person.
        Default Activity	Default Activity that is assigned to a person.
        Idle Time	Idle Time that is assigned to a person.
        Meal	Meal that is assigned to a person.
        Paid Break	Paid Break that is assigned to a person.
        Auto Resolve	Auto Resolve that is assigned to a person.

        CWFM People Import — Work CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Activity Tracking Status	Activity Profile	Default Activity	Idle Time	Meal	Paid Break	Auto Resolve
        *	UNO Minda	Minda Region A	Minda District A	Minda B_Unit

      • CWFMPeopleImport_iPack_v1_RoleMgrAttributeExclusions_CRT: Controls manager role attribute exclusions from a manager.

        CWFM People Import — Role Manager Attribute Exclusions CRT structure

        Column name	Description
        Key 1	The compound key.
        Key 2	Generic key that is set at runtime.
        Key 3	Generic key that is set at runtime.
        Key 4	Generic key that is set at runtime.
        Key 5	Generic key that is set at runtime.
        Person Number	Person Number that is assigned to a person.

        CWFM People Import — Role Manager Attribute Exclusions CRT sample content

        Key 1	Key 2	Key 3	Key 4	Key 5	Person Number
        *	UNO Minda	Minda Region A	Minda District A	Minda B_Unit	CWM1234500

      • CWFMPeopleImport_iPack_v1_ExistingEmpDates_CRT: Controls entity assignment effective dates for a person.

        CWFM People Import — Existing Employee Dates CRT structure

        Column name	Description
        Dimension Field	Field that requires an effective date.
        SetTo: 'CPPStart OR 'CurrentDate' OR 'File'	The effective date. Supported values include: CPPStart CurrentDate File

        CWFM People Import — Existing Employee Dates CRT sample content

        Column name	Description
        Accrual Profile Eff Date	CPPStart
        Adjustment Rule Eff Date	CPPStart
        Analytics Labor Type Eff Date	CPPStart
        Attendance Profile Eff Date	CPPStart
        Badge Number Eff Date	CPPStart
        Base Wage Eff Date CPPStart	CPPStart
        Emp Attestation Profile Eff Date	CPPStart
        Emp Job Transfer Set/Manager Additions Eff Date	CPPStart
        Emp Percent Allocation Rule Eff Date	CPPStart
        Emp Schedule Group Eff Date	CPPStart
        Emp Schedule Rule Set Eff Date	CPPStart
        Emp Time Entry Method Eff Date	CPPStart
        Employment Term Eff Date	CPPStart
        FTE 1 Eff Date	CPPStart
        FTE 2 Eff Date	CPPStart
        GDAP Eff Date	File
        Mgr Emp Group Eff Date	CPPStart
        Mgr Job Transfer Set Eff Date	CPPStart
        Pay Rule Eff Date	CPPStart
        Personal OT Eff Date	CPPStart
        Primary Job/LC Eff Date	CPPStart

      • CWFMPeopleImport_iPack_v1_CustomFields_CRT: Controls custom field creation.

        CWFM People Import — Custom Fields CRT structure

        Column name	Description
        Source File Field	Source file heading name.
        Label Value	Custom field in the application.

        CWFM People Import — Custom Fields CRT sample content

        Source File Field	Label Value
        Custom Date 1
        Custom Date 2
        Custom Date 3
        Custom Date 4
        Custom Date 5
        Custom Field 1
        Custom Field 2
        Custom Field 3
        Custom Field 4
        Custom Field 5
        Custom Field 6
        Custom Field 7
        Custom Field 8
        Custom Field 9
        Custom Field 10
        Custom Field 11
        Custom Field 12
        Custom Field 13
        Custom Field 14
        Custom Field 15
        Custom Field 16
        Custom Field 17
        Custom Field 18
        Custom Field 19
        Custom Field 20
        Custom Field 21
        Custom Field 22
        Custom Field 23
        Custom Field 24
        Custom Field 25
        Custom Field 26
        Custom Field 27
        Custom Field 28
        Custom Field 29
        Custom Field 30

      • CWFMPeopleImport_iPack_v1_ImportValidation_CRT: Identifies the verification requirements that people data must meet before it is imported into the system.

        CWFM People Import — Import Validation CRT structure

        Column name	Description
        Validation Name	Validation that refines data in the files before import into the database. Supported values are limited to: PersonNumber length PFAccountNumber UAN Number Gender Marital status Blood group Trade/Skill Worker Type AadharNumber length
        Is Applicable	Determines whether validation must be applied to the data. Supported values include Yes and No.
        Value	The value that is evaluated during validation.

        CWFM People Import — Import Validation CRT sample content

        Validation Name	Is Applicable	Value
        PersonNumber length	Yes	10
        PFAccountNumber	Yes	xx/xxx/nn/nnnnnn
        UAN Number	Yes	xx/xxx/nn/nnnnnn
        Gender	Yes	Male,Female,Others
        Marital status	Yes	SINGLE,MARRIED
        Blood group	Yes	A+,B+,O+,AB+,A-,B-,O-,AB-
        Trade/Skill	Yes
        Worker Type	Yes
        AadharNumber length	Yes	12

      • CWFMPeopleImport_iPack_v1_Timezone_CRT: Identifies time zone mapping between the source file and the application.

        CWFM People Import — Time zone CRT structure

        Column name	Description
        Source Time Zone	Time zone value contained in the source file.
        Dimension Status Time Zone	Corresponding time zone value in the application.

        CWFM People Import — Time zone CRT sample content

        Source Time Zone	Dimension Status Time Zone
        Eastern	Eastern
        Central	Central
        Mountain	Mountain
        Pacific	Pacific
        India	India

      • CWFMPeopleImport_iPack_v1_Locale_CRT: Allows translation of messages and labels into different languages.

        CWFM People Import — Locale CRT structure

        Column name	Description
        Parameter Name	Key for which localization is defined.
        Locale Policy	Locale Policy. You can use an asterisk (*) as a wildcard, but put the less-restrictive locale policy names at the bottom of the table because the integration scans cross-reference tables from the top.
        Message	Message shown in Additional Details, or value of the label defined in the Run Summary section. Example: Comment was not provided.
        Description	The description that is shown in Additional Details, or value of the label defined in the Run Summary section. Example: The employee is not assigned a shift.

        Note:

        • Localization of integration extensions remains optional, but is supported.

        • The cross-reference table (CRT) holds all messages represented with standard English labels; these apply to all locales when the Locale is set to a wildcard (*).

        • Some or all messages can be translated by adding lines to the table in their preferred translation for specific locales. Messages for the most commonly used Locale Policy should be defined at the top of the CRT.

        • Names of the parameters in the CRT column "Parameter Name" must be used as is. If any parameter value needs to be localized for a different Locale Policy, copy the "Parameter Name" with the * Locale Policy, add a new row to the CRT with the appropriate Locale Policy, and then add the localized values in the Message (or Value) and Description CRT columns.

        • Do not enter values in the CRT column "Description" if it is blank.

        • Do not modify placeholders (<>) or the configurable values that are included in the CRT column "Message" (or "Value").

        CWFM People Import — Locale CRT sample content

        Parameter Name	Locale Policy	Message	Description
        Error_InvalidAppendTimeStamp	*	Invalid TimeStamp provided.
        Error_InvalidArchiveEnabled	*	Invalid selection for archive enabled.
        Error_InvalidDateFormat	*	Invalid Date Format provided.
        Error_InvalidEmployeeRehire	*	Invalid selection for employee rehires.
        Error_InvalidErrorLogEnabled	*	Invalid selection for enable error log enabled.
        Error_InvalidParallelProcessing	*	Invalid selection for parallel processing.
        Error_InvalidPreviewMode	*	Invalid selection for preview mode.
        Error_InvalidTranslatedStageFile	*	Invalid selection for enable translated stage file.
        Error_InvalidTranslatedStageLogging	*	Invalid selection for enable translated stage logging.
        Error_InvalidUniqueEmployeeID	*	Invalid selection for unique employee ID.
        Error_MissingFileName	*	Blank selection for file name.
        Error_MissingHeaderValue	*	Header value is blank.
        Error_MissingPersonNumberPrefix	*	Blank value for enable person number prefix.
        Label_AdjustmentRules	*	Count of AdjustmentRules
        Label_AttendanceAdmins	*	Count of AttendanceAdmins.
        Label_AttendanceProfiles	*	Count of Attendance Profiles.
        Label_AttestationProfiles	*	Count of Attestation Profiles.
        Label_CascadeProfiles	*	Count of Cascade Profiles.
        Label_CompoundKey	*	Count of Compound Key.
        Label_DisqualifiedRecords	*	Count of Disqualified Records.
        Label_EmploymentTerms	*	Count of Employment Terms Legal contracts between employer and employee. When scheduled to work hours differ from the hours in their contract, the pay rules of the employees determine the impact on pay..
        Label_ImportedTransactions	*	Count of Imported Transactions.
        Label_IntegrationExecutionId	*	Integration Execution ID.
        Label_IntegrationTypeName	*	Integration Type
        Label_IntegrationTypeValue	*	Export
        Label_LeaveAdmins	*	Count of Leave Admins.
        Label_LeaveProfiles	*	Count of Leave Profiles.
        Label_MinorRules	*	Count of Minor Rules.
        Label_PayCodeValuesProfile	*	Count of Pay Code Values Profile.
        Label_PercentAllocationRules	*	Count of Percent Allocation Rules.
        Label_PersonalityData	*	Count of Personality Data..
        Label_ProcessProfiles	*	Count of Process Profiles.
        Label_ProcessedSourceRecords	*	Count of Processed Source Records.
        Label_ReportsTo	*	Count of Reports To.
        Label_ScheduleGroups	*	Count of Schedule Groups.
        Label_ScheduleRuleSets	*	Count of Schedule Rule Sets.
        Label_SecondaryAccrualProfile	*	Count of Secondary Accrual Profile.
        Label_SourceRecords	*	Count of Source Records.
        Label_SymbolicReviewer	*	Count of Symbolic Reviewer.
        Label_TotalErrors	*	Count of Total Errors.
        Message_AadharNumber	*	Invalid Aadhar Number
        Message_AdditionalDetails	*	Integration has completed with errors.
        Message_BadgeNumber	*	Invalid Badge Number
        Message_Bloodgroup	*	Blood Group is incorrect.
        Message_EmployeeRehire	*	Employee Rehire is not allowed.
        Message_Gender	*	Gender is incorrect.
        Message_InvalidDateFormat	*	Invalid date format for: <FieldName>
        Message_LicenseCountExceeded	*	License count exceeded for the contractor.
        Message_Maritalstatus	*	Marital Status is incorrect.
        Message_MissingMandatoryField	*	Missing mandatory field: <FieldName>
        Message_PersonNumberLength	*	Person Number length is invalid.
        Message_PFAccountNumber	*	PFAccount Number is invalid.
        Message_RehireWorkerType	*	For Rehire, status of WorkerType is incorrect.
        Message_Skill_Trade	*	Trade/Skill is incorrect.	Trade/Skill is incorrect.
        Message_UANNumber	*	UAN Number is invalid.
        Message_WithoutErrors	*	Integration has completed without errors.
        Message_WorkerType	*	Invalid Worker Type

After the integrations are deployed and the connection settings and process properties are configured, install the integrations to make them available for running or scheduling.

1. Select Main Menu  > Administration > Application Setup > Integrations Setup > Install Integrations.
2. Click Tap Create .
3. In Integration Name enter a unique name, such as CWFMPeopleImport_iPack_v1.
4. (Optional) Enter a Description.

   Note: Do not select API Integration.

5. In File Access, select Source/Outbound download.
6. (Optional) If the person who runs the integration does not have full access to integrations, select Execute Integration with System Account. This allows the integration access to all APIs in the FAP, and the relevant permissions and data, regardless of the FAP and GDAP of the person who runs the integration.

7. (Optional) Select Re-Run to allow repeated runs of the integration with the same parameter values as the previous run.

8. Email Notifications

   (Optional)

   1. Select Yes to send email and control center notifications for integration runs.
   2. Enter the email addresses of the recipients for the following types of run status. For multiple recipients, separate the addresses by a comma, but no spaces:

      In Progress — The integration run started and has not finished.

      Completed — The integration ran successfully without errors.

      Failed — The integration ran successfully, but one or more records have errors. The integration run is treated as failed. If Abort on Failure is configured in an integration set, the integration set stops.

      Completed with Errors — The integration run has errors or could not run.

9. In Skip Configuration, select None (default) to allow multiple integrations to run at the same time or with the same data without restrictions.

   Note: Do not select Allow Minute Interval.

10. Integration template and parameters
    1. In Integration Template, select CWFMPeopleImport_iPack_v1.
    2. Click Tap Assign .
    3. In Integration Parameters, you can override default settings. Click Tap Create.
    4. Complete the configuration for each parameter value.

    5. Click Tap Save.

       Repeat this step for each integration parameter that supports the CWFM People Import process.

       Note: Template parameter names that begin with an underscore (_) are not extended to UKG Pro Workforce Management and can be configured at the Boomi Atom level.

       CWFM People Import — Integration Parameters

       Parameter name	Description / Default value / User prompt	Template parameter	Parameter type
       UsingUKGclock	Identifies whether clocks are in use. Supported value = true false (default) User prompt = No Mandatory = Yes	UsingUKGclock	Text
       Termination Payrule	An 'empty' pay rule that is assigned to an employee after termination. User prompt = No Mandatory = Yes	TerminationPayrule	Text
       Termination Accrual Profile	An 'empty' accrual profile that is assigned to an employee after termination. User prompt = No Mandatory = Yes	TerminationAccrualProfile	Text
       SourceDirectory	Contract worker source file location. Default = /Inbound User prompt = No Mandatory = Yes	SourceDirectory	Text
       Source Date Format	Date format to which all dates in the contract worker files must adhere. Supported values include: MM/dd/yyyy MM-dd-yyyy dd/MM/yyyy dd-MM-yyyy (default) yyyy/MM/dd yyyy-MM-dd	SourceDateFormat	Text
       SFTPAction	SFTP Action to perform when files with the same name exist in the remote directory. Supported case-sensitive values include: Create (default) Append Overwrite Error User prompt = No Mandatory = Yes	SFTPAction	Text
       Set Header Value	Identifies the key header lookup. User prompt = No Mandatory = Yes	SetHeaderValue	Text
       Person Number Prefix	Prefix that is added to the unique person number. User prompt = No Mandatory = Yes	PersonNumberPrefix	Text
       Filename	Contract worker file name. User prompt = Yes Mandatory = Yes	Filename	Text
       ErrorDirectory	Contract worker export error file location. Default = /Outbound User prompt = No Mandatory = Yes	ErrorDirectory	Text
       Default New Account Password	Default password assigned to all new employees. Default = Welcome@12301906 User prompt = No Mandatory = Yes	Default New Account Password	Text
       CreateUniqueEmployeeID	Determines whether the process assigns the employee ID from the file or creates a new ID. User prompt = No Mandatory = Yes	CreateUniqueEmployeeID	Text
       Contractor Code Level	Identifies the business structure level that stores the contractor code. For example, 4. User prompt = No Mandatory = Yes	ContractorCodeLevel	Text
       ArchiveDirectory	Contract worker export archive file location. Default = /Outbound User prompt = No Mandatory = Yes	ArchiveDirectory	Text
       AppendTimestampToFile	Identifies the timestamp to appended to error and archive file names. Default = dd-MM-yyyy'T'hhmmSSS User prompt = No Mandatory = Yes	AppendTimestampToFile	Text
       Preview Mode	Allows viewing of the staged profile post-translation data without making API calls. Default = false User prompt = No Mandatory = Yes Note: This option is recommended before processing a large file.	_PreviewMode	Text
       Is Manadatory HomeLaborCategoryLevel6	Determines whether HomeLaborCategoryLevel6 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeLaborCategoryLevel6	Text
       Is Manadatory HomeLaborCategoryLevel5	Determines whether HomeLaborCategoryLevel5 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeLaborCategoryLevel5	Text
       Is Manadatory HomeLaborCategoryLevel4	Determines whether HomeLaborCategoryLevel4 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeLaborCategoryLevel4	Text
       Is Manadatory HomeLaborCategoryLevel3	Determines whether HomeLaborCategoryLevel3 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeLaborCategoryLevel3	Text
       Is Manadatory HomeLaborCategoryLevel2	Determines whether HomeLaborCategoryLevel2 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeLaborCategoryLevel2	Text
       Is Manadatory HomeLaborCategoryLevel1	Determines whether HomeLaborCategoryLevel1 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeLaborCategoryLevel1	Text
       Is Manadatory HomeBusinessStructureLevel9	Determines whether HomeBusinessStructureLevel9 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel9	Text
       Is Manadatory HomeBusinessStructureLevel8	Determines whether HomeBusinessStructureLevel8 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel8	Text
       Is Manadatory HomeBusinessStructureLevel7	Determines whether HomeBusinessStructureLevel7 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel7	Text
       Is Manadatory HomeBusinessStructureLevel6	Determines whether HomeBusinessStructureLevel6 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel6	Text
       Is Manadatory HomeBusinessStructureLevel5	Determines whether HomeBusinessStructureLevel5 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel5	Text
       Is Manadatory HomeBusinessStructureLevel4	Determines whether HomeBusinessStructureLevel4 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel4	Text
       Is Manadatory HomeBusinessStructureLevel3	Determines whether HomeBusinessStructureLevel3 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel3	Text
       Is Manadatory HomeBusinessStructureLevel2	Determines whether HomeBusinessStructureLevel2 is mandatory. Default = no User prompt = No Mandatory = Yes	_IsManadatoryHomeBusinessStructureLevel2	Text
       ErrorLogEnabled	Enables error logging. Default = true User prompt = No Mandatory = Yes	_ErrorLogEnabled	Text
       Enable Translated Stage Logging	Logs the translated staging data. Default = false User prompt = No Mandatory = Yes Note: As a best practice, set this parameter to true during user acceptance testing.	_EnableTranslatedStageLogging	Text
       Enable Translated Stage File	Creates a file on SFTP that contains translated staging data. Default = false User prompt = No Mandatory = Yes Note: As a best practice, set this parameter to true during user acceptance testing.	_EnableTranslatedStageFile	Text
       EnabledParallelProcessing	Enables parallel processing. Default = true User prompt = No Mandatory = Yes	_EnabledParallelProcessing	Text
       EmployeeRehire	Determines whether an employee with the same Aadhaar number can be rehired. Default = yes User prompt = No Mandatory = Yes Note: An employee must be assigned a termination date before rehire is allowed.	_EmployeeRehire	Text
       ArchiveEnabled	Enables file archiving. Default = true User prompt = No Mandatory = Yes	_ArchiveEnabled	Text
       PEIDLevel	Identifies the business structure level associated with the Principal Employer ID. User prompt = No Mandatory = Yes	PEIDLevel	Text

11. Make sure that the generic data access profiles (GDAP) allow access by the people who need to run the installed integrations. See Configure Access to Integrations.

Run integrations to test that the configuration is set up correctly.

Run the integration

1. Select the integration:
   1. Select Main Menu  > Maintenance > Integrations. 
   2. Click Tap Run an Integration . 
   3. Select the CWFMPeopleImport_iPack_v1 integration from the list. Click Tap Select. 
   4. (Optional) Enter a unique Integration Run Name to make it easier to identify the run of the integration. Otherwise, the system assigns a default name, which ends with a date and time stamp.

1. Select the following:

   • Run Integration: If this is the first time this integration is being run.
   • Re-Run: If this integration has been run before, and the status is not In-Progress, you can run the integration again without entering the parameter values again. Click Tap Yes to continue, or No to not run the integration and to return to the parameter settings.

1. Wait for the confirmation that the integration completed or failed. Close the panel.

1. Click Tap Refresh . 

1. To see details, select the integration run. Select Run Summary.

Check the results

Status indicators

•  In-Progress: The run of this integration has not yet completed.
•  Completed: The integration ran successfully without errors.
•  Scheduled: This integration is scheduled to run later or repeatedly.
• (Grayed out) Scheduled but Deleted: This integration is scheduled to run, but the integration template has been deleted. When it runs, it will generate an error. To prevent this error, delete the scheduled integration run.
•  Completed with Errors: The integration ran successfully, but one or more records have errors. The integration run is treated as failed. If Abort on Failure is configured in an integration set, the integration set stops.
•  Failed: The integration run has errors or could not run.
• To troubleshoot and resolve errors, do the following:

  Check the Run Summary for details.

  • To troubleshoot all types of errors, or if the Run Summary shows a large number of errors, click tap Go to Additional Details (if available), or click tap the Source File to open and examine the input source file.
  • (Only for import integrations) To troubleshoot and resubmit integrations that have transactional or data errors, click tap Go to Transaction Assistant.

To check the results in more detail:

1. Click Tap the tile for the integration run.
2. Click Tap Run Summary to see the results of the integration run.

   Example Run Summary details

   Note: The available details vary by integration and configuration.

   • Integration Run Name: Name of this run of the integration.
   • Process Name: Name of any integration set that includes this integration.
   • Integration Name: Name of the installed integration.
   • Integration Reference ID: Unique identifier for this integration run (to help in troubleshooting errors).
   • User: The person or user account that ran the integration.
   • Integration Type: Import, Export, or None
   • Start Date: Date and time when the integration run started.
   • End Date: Date and time when the integration run finished.
   • Status: In-Progress, Completed, Completed with Errors, or Failed.
   • Records Processed: Number of records that were processed.
   • Records Created: Number of records that were created.
   • Errors: Number of records that failed.
   • Source Files, Output File, and Error Files: For file-based import integrations, use Manage SFTP to access the source and output files on the inbound (source) and outbound (destination) SFTP folders. See the Manage SFTP topic.
3. Log in to the destination system and ensure that the data has been correctly updated.

Note: You can schedule integrations and integration sets to run once later or at a recurring frequency. See the Schedule Integrations topic.

Error files — CWFM People Import integration

Error files capture invalid or duplicate data that already exists in the database. The file structure is similar to the source file, but includes one extra column:

• Error Message

Archive files — CWFM People Import integration

Processed source files are moved to the archive folder.

Before you configure the CWFM Reports integration, you must do the following:

1. Configure Access to Integrations

2. Configure the following:

   • Integration List Parameters: Create integration list parameters that identify the reporting periods and contract workforce management reports. See the Configure Integration List Parameters topic.

     Examples include:

   Name: CWFM Reporting Period

   Description: Reporting Periods applicable to Contract Workforce Management Report.

   Parameter values:

   Name	Description	Value	Default value
   Current Month	Timeframe for which the calculation must be completed.	Current Month	No
   Previous Month	Timeframe for which the calculation must be completed.	Previous Month	Yes
   Current Year	Timeframe for which the calculation must be completed.	Current Year	No
   Previous Year	Timeframe for which the calculation must be completed.	Previous Year	No

   Name: CWFM Report List

   Description: Contract Workforce Management Reports.

   Parameter values:

   Name	Description	Value	Default value
   Annual Return Report	Enables selection of the Annual Return Report.	CWFM-AnnualReturnReport	No
   Muster Roll Report	Enables selection of the Muster Roll Report.	CWFM-MusterRollReport	No
   Register of Contract Workmen employed by ContractorReport	Enables selection of the Register of Contract Workmen employed by ContractorReport.	CWFM-RegisterofContractWorkmenemployedbyContractorReport	No
   Register of Contractors Report	Enables selection of the Register of Contractors Report.	CWFM-RegisterOfContractorsReport	No
   Register of Overtime Report	Enables selection of the Register of Overtime Report.	CWFM-RegisterofOvertimeReport	No
   Register of Wages Cum Muster Roll Report	Enables selection of the Register of Wage-Cum-Muster Roll Report.	CWFM-RegisterofWagesCumMusterRollReport	No
   Register of Wages Report	Enables selection of the Register of Wages Report.	CWFM-RegisterOfWagesReport	No
   Wage Slip Report	Enables selection of the Wage Slip Report.	CWFM-WageSlipReport	No

• Extension tables: Configure the CWFM Reports extension tables. See the Extension Tables topic.

  For each extension table, enter the following in the DDL Command Name and Commands for execution fields:

DDL Command Name: Annual Return Report

Commands for execution:

CREATE TABLE annualreturnreport

(

arrchangeinmanagementofestabilshment Varchar(255),

arrcontractorid Varchar(255),

arrcontractornameandaddress Varchar(255),

arrcontractperiodfrom Varchar(255),

arrcontractperiodto Varchar(255),

arremployeeexecuteddate Varchar(255),

arremployeerunby Varchar(255),

arrestablishmentdistict Varchar(255),

arrestablishmentpostaladdress Varchar(255),

arrexecutionid Varchar(255),

arrmanagerfullname Varchar(255),

arrmaxworkeremployedbycontractor Varchar(255),

arrmaxworkmenemployed Varchar(255),

arrnameofestablishment Varchar(255),

arrnatureofoperation Varchar(255),

arrnatureofwork Varchar(255),

arrnatureofworkcontractlabour Varchar(255),

arrnoofdaysworked Varchar(255),

arrnoofmandaysworked Varchar(255),

arrpersonnumber Varchar(255),

arrprincipalemployernameandaddress Varchar(255),

arrreportid Varchar(255),

arrserialno Varchar(255),

arrtotalcontractorduringyear Varchar(255),

arrtotaldaysbycontractorlabour Varchar(255),

arrtotaldaysdirectlabour Varchar(255),

arrtotalmandaysbycontractlabour Varchar(255),

arrtotalmandaysdirectworkmenemployed Varchar(255),

arryearending Varchar(255)

);

DDL Command Name: MusterRollReport

Commands for execution:

CREATE TABLE MusterRollReport

(

mrcontractornameandaddress VARCHAR(255),

mrdaterange VARCHAR(255),

mremployeeexecuteddate VARCHAR(255),

mremployeefathernameorhusbandname VARCHAR(255),

mremployeefullname VARCHAR(255),

mremployeemonthdate1 VARCHAR(255),

mremployeemonthdate10 VARCHAR(255),

mremployeemonthdate11 VARCHAR(255),

mremployeemonthdate12 VARCHAR(255),

mremployeemonthdate13 VARCHAR(255),

mremployeemonthdate14 VARCHAR(255),

mremployeemonthdate15 VARCHAR(255),

mremployeemonthdate16 VARCHAR(255),

mremployeemonthdate17 VARCHAR(255),

mremployeemonthdate18 VARCHAR(255),

mremployeemonthdate19 VARCHAR(255),

mremployeemonthdate2 VARCHAR(255),

mremployeemonthdate20 VARCHAR(255),

mremployeemonthdate21 VARCHAR(255),

mremployeemonthdate22 VARCHAR(255),

mremployeemonthdate23 VARCHAR(255),

mremployeemonthdate24 VARCHAR(255),

mremployeemonthdate25 VARCHAR(255),

mremployeemonthdate26 VARCHAR(255),

mremployeemonthdate27 VARCHAR(255),

mremployeemonthdate28 VARCHAR(255),

mremployeemonthdate29 VARCHAR(255),

mremployeemonthdate3 VARCHAR(255),

mremployeemonthdate30 VARCHAR(255),

mremployeemonthdate31 VARCHAR(255),

mremployeemonthdate4 VARCHAR(255),

mremployeemonthdate5 VARCHAR(255),

mremployeemonthdate6 VARCHAR(255),

mremployeemonthdate7 VARCHAR(255),

mremployeemonthdate8 VARCHAR(255),

mremployeemonthdate9 VARCHAR(255),

mremployeemonthwisedate1 VARCHAR(255),

mremployeemonthwisedate10 VARCHAR(255),

mremployeemonthwisedate11 VARCHAR(255),

mremployeemonthwisedate12 VARCHAR(255),

mremployeemonthwisedate13 VARCHAR(255),

mremployeemonthwisedate14 VARCHAR(255),

mremployeemonthwisedate15 VARCHAR(255),

mremployeemonthwisedate16 VARCHAR(255),

mremployeemonthwisedate17 VARCHAR(255),

mremployeemonthwisedate18 VARCHAR(255),

mremployeemonthwisedate19 VARCHAR(255),

mremployeemonthwisedate2 VARCHAR(255),

mremployeemonthwisedate20 VARCHAR(255),

mremployeemonthwisedate21 VARCHAR(255),

mremployeemonthwisedate22 VARCHAR(255),

mremployeemonthwisedate23 VARCHAR(255),

mremployeemonthwisedate24 VARCHAR(255),

mremployeemonthwisedate25 VARCHAR(255),

mremployeemonthwisedate26 VARCHAR(255),

mremployeemonthwisedate27 VARCHAR(255),

mremployeemonthwisedate28 VARCHAR(255),

mremployeemonthwisedate29 VARCHAR(255),

mremployeemonthwisedate3 VARCHAR(255),

mremployeemonthwisedate30 VARCHAR(255),

mremployeemonthwisedate31 VARCHAR(255),

mremployeemonthwisedate4 VARCHAR(255),

mremployeemonthwisedate5 VARCHAR(255),

mremployeemonthwisedate6 VARCHAR(255),

mremployeemonthwisedate7 VARCHAR(255),

mremployeemonthwisedate8 VARCHAR(255),

mremployeemonthwisedate9 VARCHAR(255),

mremployeepersonnumber VARCHAR(255),

mremployeeremarks VARCHAR(255),

mremployeerunby VARCHAR(255),

mremployeesex VARCHAR(255),

mremployeetotalpaiddays VARCHAR(255),

mrexecutionid VARCHAR(255),

mrforthemonthof VARCHAR(255),

mrhyperfindorlocation VARCHAR(255),

mrnameandaddressofestablishment VARCHAR(255),

mrnatureandlocationofwork VARCHAR(255),

mrprincipalemployernameandaddress VARCHAR(255),

mrreportid VARCHAR(255)

);

DDL Command Name: WorkmenEmployedByContractorReport

Commands for execution:

CREATE TABLE WorkmenEmployedByContractorReport

(

WECNameandaddressofContractor VARCHAR(255),

WECNatureandlocationofwork VARCHAR(255),

WECNameandaddressofPrincipalEmployer VARCHAR(255),

WECNameandaddressofestablishment VARCHAR(255),

WECSerialNo VARCHAR(255),

WECEmployeeNumber VARCHAR(255),

WECEmployeeFullName VARCHAR(255),

WECEmployeeAgeandSex VARCHAR(255),

WECEmployeeFatherNameandHusbandName VARCHAR(255),

WECEmployeeNatureofEmploymentandDesignation VARCHAR(255),

WECEmployeePermanentAddress VARCHAR(255),

WECEmployeeLocalAddress VARCHAR(255),

WECEmployeeDateofCommencement VARCHAR(255),

WECEmployeeSignature VARCHAR(255),

WECEmployeeDateofTermination VARCHAR(255),

WECEmployeeReasonofTermination VARCHAR(255),

WECEmployeeRemarks VARCHAR(255),

WECEmployeeRunBy VARCHAR(255),

WECEmployeeExecutedDate VARCHAR(255),

WECReportID VARCHAR(255),

WECExecutionID VARCHAR(255)

);

DDL Command Name: Register of Contractor

Commands for execution:

CREATE TABLE registerofcontractorreport

(

rccontractmaxemployee Varchar(255),

rccontractornameandaddress Varchar(255),

rccontractperiodfrom Varchar(255),

rccontractperiodto Varchar(255),

rcdaterange Varchar(255),

rcemployeeexecuteddate Varchar(255),

rcemployeerunby Varchar(255),

rcexecutionid Varchar(255),

rchyperfindorlocation Varchar(255),

rcnameandaddressoftheestablishment Varchar(255),

rcnatureoflocation Varchar(255),

rcnatureofwork Varchar(255),

rcpersonnumber Varchar(255),

rcprincipalemployernameandaddress Varchar(255),

rcreportid Varchar(255)

);

DDL Command Name: RegisterofOvertimeReport

Commands for execution:

CREATE TABLE RegisterofOvertimeReport

(

RORNameandadressofContractor VARCHAR(255),

RORNatureandlocationofwork VARCHAR(255),

RORNameandaddressofestablishment VARCHAR(255),

RORNameandaddressofPrincipalEmployer VARCHAR(255),

RORSerialNo VARCHAR(255),

ROREmployeePersonNumber VARCHAR(255),

ROREmployeeFullName VARCHAR(255),

ROREmployeeFatherNameandHusbandName VARCHAR(255),

ROREmployeeSex VARCHAR(255),

ROREmployeeNatureofEmploymentandDesignation VARCHAR(255),

ROREmployeeMonthDate1 VARCHAR(255),

ROREmployeeMonthDate2 VARCHAR(255),

ROREmployeeMonthDate3 VARCHAR(255),

ROREmployeeMonthDate4 VARCHAR(255),

ROREmployeeMonthDate5 VARCHAR(255),

ROREmployeeMonthDate6 VARCHAR(255),

ROREmployeeMonthDate7 VARCHAR(255),

ROREmployeeMonthDate8 VARCHAR(255),

ROREmployeeMonthDate9 VARCHAR(255),

ROREmployeeMonthDate10 VARCHAR(255),

ROREmployeeMonthDate11 VARCHAR(255),

ROREmployeeMonthDate12 VARCHAR(255),

ROREmployeeMonthDate13 VARCHAR(255),

ROREmployeeMonthDate14 VARCHAR(255),

ROREmployeeMonthDate15 VARCHAR(255),

ROREmployeeMonthDate16 VARCHAR(255),

ROREmployeeMonthDate17 VARCHAR(255),

ROREmployeeMonthDate18 VARCHAR(255),

ROREmployeeMonthDate19 VARCHAR(255),

ROREmployeeMonthDate20 VARCHAR(255),

ROREmployeeMonthDate21 VARCHAR(255),

ROREmployeeMonthDate22 VARCHAR(255),

ROREmployeeMonthDate23 VARCHAR(255),

ROREmployeeMonthDate24 VARCHAR(255),

ROREmployeeMonthDate25 VARCHAR(255),

ROREmployeeMonthDate26 VARCHAR(255),

ROREmployeeMonthDate27 VARCHAR(255),

ROREmployeeMonthDate28 VARCHAR(255),

ROREmployeeMonthDate29 VARCHAR(255),

ROREmployeeMonthDate30 VARCHAR(255),

ROREmployeeMonthDate31 VARCHAR(255),

ROREmployeeMonthwiseDate1 VARCHAR(255),

ROREmployeeMonthwiseDate2 VARCHAR(255),

ROREmployeeMonthwiseDate3 VARCHAR(255),

ROREmployeeMonthwiseDate4 VARCHAR(255),

ROREmployeeMonthwiseDate5 VARCHAR(255),

ROREmployeeMonthwiseDate6 VARCHAR(255),

ROREmployeeMonthwiseDate7 VARCHAR(255),

ROREmployeeMonthwiseDate8 VARCHAR(255),

ROREmployeeMonthwiseDate9 VARCHAR(255),

ROREmployeeMonthwiseDate10 VARCHAR(255),

ROREmployeeMonthwiseDate11 VARCHAR(255),

ROREmployeeMonthwiseDate12 VARCHAR(255),

ROREmployeeMonthwiseDate13 VARCHAR(255),

ROREmployeeMonthwiseDate14 VARCHAR(255),

ROREmployeeMonthwiseDate15 VARCHAR(255),

ROREmployeeMonthwiseDate16 VARCHAR(255),

ROREmployeeMonthwiseDate17 VARCHAR(255),

ROREmployeeMonthwiseDate18 VARCHAR(255),

ROREmployeeMonthwiseDate19 VARCHAR(255),

ROREmployeeMonthwiseDate20 VARCHAR(255),

ROREmployeeMonthwiseDate21 VARCHAR(255),

ROREmployeeMonthwiseDate22 VARCHAR(255),

ROREmployeeMonthwiseDate23 VARCHAR(255),

ROREmployeeMonthwiseDate24 VARCHAR(255),

ROREmployeeMonthwiseDate25 VARCHAR(255),

ROREmployeeMonthwiseDate26 VARCHAR(255),

ROREmployeeMonthwiseDate27 VARCHAR(255),

ROREmployeeMonthwiseDate28 VARCHAR(255),

ROREmployeeMonthwiseDate29 VARCHAR(255),

ROREmployeeMonthwiseDate30 VARCHAR(255),

ROREmployeeMonthwiseDate31 VARCHAR(255),

ROREmployeeTotalOvertimeworked VARCHAR(255),

ROREmployeeNormalrateofWages VARCHAR(255),

ROREmployeeOvertimerateofwages VARCHAR(255),

ROREmployeeOvertimeEarnings VARCHAR(255),

ROREmployeeDateOvertimePaid VARCHAR(255),

ROREmployeeRemarks VARCHAR(255),

ROREmployeeRunBy VARCHAR(255),

ROREmployeeExecutedDate VARCHAR(255),

RORReportID VARCHAR(255),

RORExecutionID VARCHAR(255)

);

DDL Command Name: WageCumMusterRollReports

Commands for execution:

CREATE TABLE WageCumMusterRollReports

(

wmremployeebasicwage VARCHAR(255),

wmremployeeda VARCHAR(255),

wmremployeedailyrateofwage VARCHAR(255),

wmremployeedaysworked1 VARCHAR(255),

wmremployeedaysworked2 VARCHAR(255),

wmremployeedaysworked3 VARCHAR(255),

wmremployeedaysworked4 VARCHAR(255),

wmremployeedaysworked5 VARCHAR(255),

wmremployeedaysworked6 VARCHAR(255),

wmremployeedaysworked7 VARCHAR(255),

wmremployeedaysworked8 VARCHAR(255),

wmremployeedaysworked9 VARCHAR(255),

wmremployeedaysworked10 VARCHAR(255),

wmremployeedaysworked11 VARCHAR(255),

wmremployeedaysworked12 VARCHAR(255),

wmremployeedaysworked13 VARCHAR(255),

wmremployeedaysworked14 VARCHAR(255),

wmremployeedaysworked15 VARCHAR(255),

wmremployeedaysworked16 VARCHAR(255),

wmremployeedaysworked17 VARCHAR(255),

wmremployeedaysworked18 VARCHAR(255),

wmremployeedaysworked19 VARCHAR(255),

wmremployeedaysworked20 VARCHAR(255),

wmremployeedaysworked21 VARCHAR(255),

wmremployeedaysworked22 VARCHAR(255),

wmremployeedaysworked23 VARCHAR(255),

wmremployeedaysworked24 VARCHAR(255),

wmremployeedaysworked25 VARCHAR(255),

wmremployeedaysworked26 VARCHAR(255),

wmremployeedaysworked27 VARCHAR(255),

wmremployeedaysworked28 VARCHAR(255),

wmremployeedaysworked29 VARCHAR(255),

wmremployeedaysworked30 VARCHAR(255),

wmremployeedaysworked31 VARCHAR(255),

wmremployeededuction VARCHAR(255),

wmremployeeexecuteddate VARCHAR(255),

wmremployeefullname VARCHAR(255),

wmremployeeinitialcontractor VARCHAR(255),

wmremployeemonthdate1 VARCHAR(255),

wmremployeemonthdate2 VARCHAR(255),

wmremployeemonthdate3 VARCHAR(255),

wmremployeemonthdate4 VARCHAR(255),

wmremployeemonthdate5 VARCHAR(255),

wmremployeemonthdate6 VARCHAR(255),

wmremployeemonthdate7 VARCHAR(255),

wmremployeemonthdate8 VARCHAR(255),

wmremployeemonthdate9 VARCHAR(255),

wmremployeemonthdate10 VARCHAR(255),

wmremployeemonthdate11 VARCHAR(255),

wmremployeemonthdate12 VARCHAR(255),

wmremployeemonthdate13 VARCHAR(255),

wmremployeemonthdate14 VARCHAR(255),

wmremployeemonthdate15 VARCHAR(255),

wmremployeemonthdate16 VARCHAR(255),

wmremployeemonthdate17 VARCHAR(255),

wmremployeemonthdate18 VARCHAR(255),

wmremployeemonthdate19 VARCHAR(255),

wmremployeemonthdate20 VARCHAR(255),

wmremployeemonthdate21 VARCHAR(255),

wmremployeemonthdate22 VARCHAR(255),

wmremployeemonthdate23 VARCHAR(255),

wmremployeemonthdate24 VARCHAR(255),

wmremployeemonthdate25 VARCHAR(255),

wmremployeemonthdate26 VARCHAR(255),

wmremployeemonthdate27 VARCHAR(255),

wmremployeemonthdate28 VARCHAR(255),

wmremployeemonthdate29 VARCHAR(255),

wmremployeemonthdate30 VARCHAR(255),

wmremployeemonthdate31 VARCHAR(255),

wmremployeenatureofemploymentanddesignation VARCHAR(255),

wmremployeenatureofpayment VARCHAR(255),

wmremployeenetamountpaid VARCHAR(255),

wmremployeeovertime VARCHAR(255),

wmremployeepersonnumber VARCHAR(255),

wmremployeerunby VARCHAR(255),

wmremployeesignature VARCHAR(255),

wmremployeetotal VARCHAR(255),

wmrexecutionid VARCHAR(255),

wmrnameandaddressofestablishment VARCHAR(255),

wmrnameandaddressofprincipalemployer VARCHAR(255),

wmrnameandadressofcontractor VARCHAR(255),

wmrnatureandlocationofwork VARCHAR(255),

wmrreportid VARCHAR(255),

wmrserialno VARCHAR(255),

wmrtotalattendance VARCHAR(255),

wmrwageperiodmonthandyear VARCHAR(255)

);

DDL Command Name: Registerofwagesreport

Commands for execution:

CREATE TABLE registerofwagesreport

(

rwcontractornameandaddress VARCHAR(255),

rwdaterange VARCHAR(255),

rwemployeebasicwage VARCHAR(255),

rwemployeeda VARCHAR(255),

rwemployeedailyrateofwage VARCHAR(255),

rwemployeedaysworked VARCHAR(255),

rwemployeededuction VARCHAR(255),

rwemployeeexecuteddate VARCHAR(255),

rwemployeefullname VARCHAR(255),

rwemployeeinitialcontractor VARCHAR(255),

rwemployeenatureofemployment VARCHAR(255),

rwemployeenatureofpayment VARCHAR(255),

rwemployeenetamountpaid VARCHAR(255),

rwemployeeovertime VARCHAR(255),

rwemployeepersonnumber VARCHAR(255),

rwemployeerunby VARCHAR(255),

rwemployeesignature VARCHAR(255),

rwemployeetotal VARCHAR(255),

rwemployeeunitofwork VARCHAR(255),

rwexecutionid VARCHAR(255),

rwhyperfindorlocation VARCHAR(255),

rwnameandaddressofestablishment VARCHAR(255),

rwnatureandlocationofwork VARCHAR(255),

rwprincipalemployernameandaddress VARCHAR(255),

rwreportid VARCHAR(255),

rwwageperiodmonthandyear VARCHAR(255)

);

DDL Command Name: WageSlipReport

Commands for execution:

CREATE TABLE WageSlipReport

(

wscontractornameandaddress VARCHAR(255),

wsdaterange VARCHAR(255),

wsemployeedailyrateofwage VARCHAR(255),

wsemployeedaysworked VARCHAR(255),

wsemployeededuction VARCHAR(255),

wsemployeeexecuteddate VARCHAR(255),

wsemployeefatherorhusbandname VARCHAR(255),

wsemployeefullname VARCHAR(255),

wsemployeegrosswage VARCHAR(255),

wsemployeenetamountpaid VARCHAR(255),

wsemployeeovertimewage VARCHAR(255),

wsemployeereportrundate VARCHAR(255),

wsemployeerunby VARCHAR(255),

wsemployeeunitofwork VARCHAR(255),

wsexecutionid VARCHAR(255),

“WSFORTHEWEEK/FORTNIGHT/MONTHENDING” VARCHAR(255),

wshyperfindorlocation VARCHAR(255),

wsnameandaddressofestablishment VARCHAR(255),

wsnatureofworkandlocation VARCHAR(255),

wspersonnumber VARCHAR(255),

wsreportid VARCHAR(255)

);

3. Get the URL, User, and Password for the APIGatewayServer.