Default labor allocation

The EMP_DEF_LAB fields are used for importing employee default labor allocation data. The Employee Import process can assign multiple default labor allocations to an employee.

An employee's default labor allocation values are assigned with this format:

{percentage}~{docket}~{hour type}~{job}~{time code}~{project}~{department}

The tilde (~) symbol separates the different input values and all seven (7) input values. All seven values must be filled.

Records for {docket}, {hour type}, {job}, {time code}, {project}, and {department} must all exist in their respective tables. Otherwise, the system rejects the entire record and generates an error message.

If you do not intend to use a particular value such as {department}, a dummy value (for example, {null}) still needs to be created used. For example:

{percentage}~{docket}~{hour type}~{job}~{time code}~{project}~{null}

The effective dates of the EMP_DEF_LAB fields are assigned according to the OVR_START_DATE and OVR_END_DATE of the record.

This table lists the specifications for the required EMP_DEF_LAB fields:

EMP_DEF_LAB Input Value	Application Field Name	Type	Size/ Format	Description
{percentage}	EDLA_PERCENTAGE	Number	22	Percentage value. The percentage of total hours in a shift that is allocated for the job code.
{docket}	DOCK_NAME	Varchar2	40	Default docket
{hour type}	HTYPE_NAME	Varchar2	40	Default hour type
{job}	JOB_NAME	Varchar2	40	Default job
{time code}	TCODE_NAME	Varchar2	40	Default time code
{project}	PROJ_NAME	Varchar2	40	Default project
{department}	DEPT_NAME	Varchar2	40	Default department