Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

labor_cat

  • Last UpdatedNov 20, 2024
  • 1 minute read

The labor_cat table defines the set of available labor categories (or codes).

Field

Datatype

PK

Nulls?

Description

lab_cd

string40

Y

N

Identify labor category

lab_desc

string80

N

N

labor category description; must be unique

fixedtime

logical

N

N

Is this to be counted as fixed time? Default = No.

vartime

logical

N

N

Is this to be counted as variable time? Default = Yes.

color

int32

N

N

Background color

std_crew

tfloat

N

Y

Default standard number of workers for this labor category

Note: This field is currently not used.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 1

N

N

Unique row identifier, for audit trail

lab_desc is UK.

TitleResults for “How to create a CRG?”Also Available in