Labor Processing Tables

=======================

------------------------------------------------------------------------

initlp Labor Process Control Table

Description - one row for control information established at setup

Column Description

init_key_lp char(1) Always "1"

trn_hst_flag_lp char(1) Transaction History activated - Y=yes, N=no

labor_rate_type_lp char(1) Labor Rate Type - for actual labor costing

W = Use labor routing step Work Center (see workctrwhse)

J = Use labor routing step Job Class (see jobclass)

E = Use employee pay rate (see styemplr)

auto_lunch_sup_lp char(1) Not in use

act_cost_type_lp char(1) Not in Use

wip_labor_lp char(13) Not in use

wip_ovh_lp char(13) Not in use

wip_outs_lp char(13) Not in use

wip_labor_ctl_lp char(13) Not in use

wip_ovh_ctl_lp char(13) Not in use

wip_outs_ctl_lp char(13) Not in use

py_interface_lp char(1) Interface to Payroll - Y=yes, N=no

gl_interface_lp char(1) Interface to General Ledger - Y=yes, N=no

setup_done_lp char(1) Setup done - Y=yes, N=no

eff_good_pct_lp decimal(5,2) Labor Efficiency Inquiry - Threshold for good rating

eff_warn_pct_lp decimal(5,2) Labor Efficiency Inquiry - Threshold for warning rating

eff_poor_pct_lp decimal(5,2) Labor Efficiency Inquiry - Threshold for poor rating

lbrtrnhd Labor Transaction Entry - Summary

Description - one row for each batch of labor transaction entries

Column Description

session_lh integer Session Number

employee_lh char(6) Employee Code (see styemplr)

shift_lh char(3) Shift Number

user_lh char(10) Data Entry User

trn_date_lh date Transaction Date

status_lh char(1) Status

start_time_lh char(5) Transaction Start Time

stop_time_lh char(5) Transaction End Time

interval_lh interval hour to minute Hours for the date - Hours and Minutes

elapsed_hours_lh decimal(7) Elapsed time - hours and fraction of an hour

entry_time_lh datetime Time row added

entry_date_lh date Date row added

update_time_lh datetime Not in use

update_date_lh date Not in use

post_time_lh datetime Time Posted

post_date_lh date Date Posted

lbrtrndt Labor Transaction Entry - Order Details

Description - one row for each employee/order/labor step, in a batch

of labor transaction entries. When labor transactions are posted,

if initlp.trn_hst_flag_lp = "Y", rows are moved to lbrtrnprod and

removed from lbrtrndt.

Column Description

session_ld integer Session Number

employee_ld char(6) Employee Code (see styemplr)

update_date_ld date Date Added

update_time_ld datetime Time Added

trn_date_ld date Labor Transaction Date

start_time_ld char(5) Start Time - hour and minute

stop_time_ld char(5) Stop Time - hour and minute

trn_type_ld char(1) Not in use

order_ld char(7) Production Order Number

order_lot_ld char(3) Production Order Release

routing_seq_ld char(4) Labor Routing Step

workctr_ld char(4) Work Center

compl_qty_ld smallfloat Completed Quantity

expense_acct_ld char(12) Not in use

act_lbr_hrs_ld smallfloat Actual Labor Hours reported

act_mach_hrs_ld smallfloat Actual Machine hours reported

act_lbr_cost_ld money(11,2) Actual Labor Cost

act_ovh_cost_ld money(11,2) Actual Overhead Cost

std_hours_ld smallfloat Standard Hours Reported

(compl_qty_ld * worout.std_runhr_unit_wr)

std_lbr_cost_ld money(11,2) Standard Labor Cost

std_ovh_cost_ld money(11,2) Standard Overhead Cost

home_department_ld char(3) Employee Home Department

work_department_ld char(3) Employee worked department

machine_ld char(4) Machine worked on

shift_ld char(3) Shift

wage_account_ld char(12) Not in use

status_ld char(1) Not in use

lbr_or_mach_hr_ld char(1) Labor or Machine hours reported

scrap_qty_ld smallfloat Quantity Scrapped

completion_ld char(1) Labor Step CompletionR - C=complete, blank=open

emp_team_ld char(5) Employee's Team

job_class_ld char(3) Job Class

mult_machine_ld smallint Number of Machines worked on during transaction

mult_person_ld smallint Number of people on a machine during a transaction

pct_compl_ld smallfloat User-defined percent complete

lbr_type_ld char(3) RUN=Run Labor, SET=Setup, RWK=rework

interval_ld interval hour to minute Worked time in hours/minutes

posting_date_ld date Date Posted

posting_time_ld datetime Time Posted

trans_seq_ld smallint Transaction Sequence #

whse_ld char(10) Warehouse worked in

emp_group_ld char(5) Employee Group

lbrtrnprod Labor Transaction Entry - Order Detail History

Description - one row for each employee/order/labor step, in a batch

of posted labor transaction entries. When labor transactions are posted,

if initlp.trn_hst_flag_lp = "Y", rows are moved to lbrtrnprod and

removed from lbrtrndt.

Column Description

session_to integer Session Number

employee_to char(6) Employee Code (see styemplr)

update_date_to date Date Added

update_time_to datetime Time Added

trn_date_to date Labor Transaction Date

start_time_to char(5) Start Time - hour and minute

stop_time_to char(5) Stop Time - hour and minute

trn_type_to char(1) Not in use

order_to char(7) Production Order Number

order_lot_to char(3) Production Order Release

routing_seq_to char(4) Labor Routing Step

workctr_to char(4) Work Center

compl_qty_to smallfloat Completed Quantity

expense_acct_to char(12) Not in use

act_lbr_hrs_to smallfloat Actual Labor Hours reported

act_mach_hrs_to smallfloat Actual Machine hours reported

act_lbr_cost_to money(11,2) Actual Labor Cost

act_ovh_cost_to money(11,2) Actual Overhead Cost

std_hours_to smallfloat Standard Hours Reported

(compl_qty_ld * worout.std_runhr_unit_wr)

std_lbr_cost_to money(11,2) Standard Labor Cost

std_ovh_cost_to money(11,2) Standard Overhead Cost

home_department_to char(3) Employee Home Department

work_department_to char(3) Employee worked department

machine_to char(4) Machine worked on

shift_to char(3) Shift

status_to char(1) Not in use

lbr_or_mach_hr_to char(1) Labor or Machine hours reported

scrap_qty_to smallfloat Quantity Scrapped

completion_to char(1) Labor Step CompletionR - C=complete, blank=open

emp_team_to char(5) Employee's Team

job_class_to char(3) Job Class

mult_machine_to smallint Number of Machines worked on during transaction

mult_person_to smallint Number of people on a machine during a transaction

pct_compl_to smallfloat User-defined percent complete

lbr_type_to char(3) RUN=Run Labor, SET=Setup, RWK=rework

interval_to interval hour to minute Worked time in hours/minutes

posting_date_to date Date Posted

posting_time_to datetime Time Posted

gl_doc_no_to integer GL Transaction Sequence number

whse_to char(10) Warehouse worked in

emp_group_to char(5) Employee Group