ColumnName |
Domain |
Datatype |
NULL |
Definition |
UDT01_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: UDT01 Type. Description: Unique user-provided UDT01 type code. |
DFLT_UTIL_CD |
|
VARCHAR2(10) |
NO |
Name: Default Utilization Code. Description: Utilization code for UDT01s assigned to this type. |
DFLT_BILLABLE_FL |
|
VARCHAR2(1) |
NO |
Name: Default Billable Flag. Description: Logical as to whether UDT01s assigned to this type are billable. |
FUTURE_FL |
|
VARCHAR2(1) |
NO |
Name: Future Flag. Description: Logical as to whether UDT01s assigned to this type can be charged into the future. |
EXPORT_FL |
|
VARCHAR2(1) |
NO |
Name: Export Flag. Description: Logical as to whether UDT01s assigned to this type are exported to payroll, A/P, WIP, etc. |
DAILY_MIN_HRS |
|
NUMBER(8, 2) |
NO |
Name: Minimum Daily Hours. Description: Minimum hours that can be charged to UDT01s assigned to this type. |
DAILY_MAX_HRS |
|
NUMBER(8, 2) |
NO |
Name: Maximum Daily Hours. Description: Maximum hours that can be charged to UDT01s assigned to this type. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
UDT01_TYPE_DESC |
|
VARCHAR2(30) |
NO |
Name: UDT01 Type Description. Description: Unique description of UDT01 type. |
TIME_IN_OUT_FL |
|
VARCHAR2(1) |
NO |
Name: Time In/Out Flag. Description: Logical whether UDT01s assigned to this type count as hours worked for time in/out purposes. |
OT_FL |
|
VARCHAR2(1) |
NO |
Name: Overtime Flag. Description: Logical whether UDT01s Assigned to this type count towards hours worked for overtime purposes |
PRORATE_FL |
|
VARCHAR2(1) |
NO |
Name: Prorate Flag. Description: Logical as to whether UDT01s assigned this type are included in hours proration logic. |
S_TYPE_CD |
|
VARCHAR2(1) |
NO |
Name: Use Option. Description: Indicates which system can use the UDT01s assigned to this type. The valid options are T – Time. E – Expense. B - Both |
START_STOP_TIMES_FL |
|
VARCHAR2(1) |
NO |
Name: Start/Stop Times Flag. Description: Logical as to whether charges to UDT01s of this type should count towards start/stop times. |