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