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 |