Previous Topic: Boolean_Table TableNext Topic: BU_TRANS Table


Bop_Workshift Table

Workshift definition.

Field

Data Type

Reference

Remarks

del

INTEGER

Active_Boolean_
Table::enum

This is the Deleted flag:
0—Active
1—Inactive/marked as deleted

description

nvarchar(80)

 

Specifies the textual description of this workshift.

id

INTEGER

 

Unique (to the table) Numeric ID.

last_mod_by

Byte(16)

ca_contact:: uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).
Note: This is a primary key.

sched

nvarchar
(1000)

 

Describes the schedule of this workshift.

sym

nvarchar(30)

 

Represents the symbolic value for this workshift.