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}~
{UDF1}~{UDF2}~{UDF3}~{UDF4}~{UDF5}~{UDF6}~{UDF7}~{UDF8}~{UDF9}~{UDF10}~
{FLAG1}~{FLAG2}~{FLAG3}~{FLAG4}~{FLAG5}~{FLAG6}~{FLAG7}~{FLAG8}~{FLAG9}~{FLAG10}

The tilde (~) symbol separates the input values. The first seven values (percentage, docket, hour type, job, time code, project, and department) must be filled. The remaining 20 values (UDFs and Flags) are optional. An error occurs if you specify fewer than seven values or more than 27 values.

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 required value such as {department}, a dummy value (for example, {null}) still needs to be used. For example:

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

If certain UDF or Flag fields are not going to be modified, leave blank. In this example, UDF1 and UDF2 are not modified and UDF3 has a given value of TAXAREA3:

100~TSDOCKET~REG~COOK~WRK~PROJ123~DEPT123~~~TAXAREA3

To set a UDF or Flag field to null, use a percentage sign (%). In this example, UDF1 has a null value and UDF2 has a given value of TAXAREA2:

100~TSDOCKET~REG~COOK~WRK~PROJ123~DEPT123~%~TAXAREA2

To set a UDF or Flag field to an empty string, use an ampersand (&).

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:

Input Value	Application Field Name	Type	Size	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
{UDF[1..10]}	EDLA_UDF[1..10]	Varchar	40	UDF fields, 1 through 10
{FLAG[1..10]}	EDLA_FLAG[1..10]	Varchar	1	Flag fields, 1 through 10