Default Labor Allocation (Columns 61-64)

The fields EMP_DEF_LAB1 to EMP_DEF_LAB4 (columns 61-64) are for importing employee default labor allocation data. Standard HR Refresh can assign up to four default labor allocations to an employee.

An employee's defaultlabor allocation (that is, EMP_DEF_LAB{1..4} field values) values are assigned with this format:

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

where

• 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.

For example:

100~NULL~REG~COOK~WRK~PROJ123~DEPT123

Where a customer does not intend to use a particular field (for example, {department} codes), a dummy record (for example, NULL department) still needs to be created and referenced by the input value.

• The fields’ effective dates are based on the OVR_START_DATE and OVR_END_DATE of the record.

• The specifications for the required EMP_DEF_LAB fields are:

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}	D EPT_NAME	Varchar2	40	Default department