EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: Employee ID identifier for the employee preference record.
 

COUNTRY_CD 
ColumnName  COUNTRY_CD 
Definition 
Name: Country. Description: The country code preferred for this Employee ID.
 

LANGUAGE_CD 
ColumnName  LANGUAGE_CD 
Definition 
Name: Language. Description: The language code preferred for this Employee ID.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

SHOW_MENU_FL 
ColumnName  SHOW_MENU_FL 
Definition 
Name: Show Menu Flag. Description: Logical as to whether the menu is shown when user logs into system.
 

TIMESHEET_NO 
ColumnName  TIMESHEET_NO 
Definition 
Name: Number of Desktop Timesheets. Description: Number of timesheets that should be displayed in employees Desktop.
 

LOAD_FAVORITES_FL 
ColumnName  LOAD_FAVORITES_FL 
Definition 
Name: Load Favorites Flag. Description: Logical as to whether the employee charge favorites that are set up as auto load should load automatically on a new timesheet for this employee.
 

EXPENSE_NO 
ColumnName  EXPENSE_NO 
Definition 
Name: Number of Desktop Expense Reports. Description: Number of expense reports that should be displayed in employees Desktop.
 

S_NOTIFY_METHOD_CD 
ColumnName  S_NOTIFY_METHOD_CD 
Definition 
Name: Expense Notification Method. Description: The method by which the employee wants to be notified with expense tasks. The valid values are:A – Alert. E – Email. 
 

TIME_ZONE_CD 
ColumnName  TIME_ZONE_CD 
Definition 
Name: Timezone. Description: The time zone preference for this employee ID.
 

UDT01_SIZE_NO 
ColumnName  UDT01_SIZE_NO 
Definition 
Name: UDT01 Column Size. Description: The size of the UDT01 column on Timesheet Grid for this employee.
 

UDT02_SIZE_NO 
ColumnName  UDT02_SIZE_NO 
Definition 
Name: UDT02 Column Size. Description: The size of the UDT02 column on Timesheet Grid for this employee.
 

UDT03_SIZE_NO 
ColumnName  UDT03_SIZE_NO 
Definition 
Name: UDT03 Column Size. Description: The size of the UDT03column on Timesheet Grid for this employee.
 

UDT04_SIZE_NO 
ColumnName  UDT04_SIZE_NO 
Definition 
Name: UDT04 Column Size. Description: The size of the UDT04column on Timesheet Grid for this employee.
 

UDT05_SIZE_NO 
ColumnName  UDT05_SIZE_NO 
Definition 
Name: UDT05 Column Size. Description: The size of the UDT05 olumn on Timesheet Grid for this employee.
 

UDT06_SIZE_NO 
ColumnName  UDT06_SIZE_NO 
Definition 
Name: UDT06 Column Size. Description: The size of the UDT06 olumn on Timesheet Grid for this employee.
 

UDT07_SIZE_NO 
ColumnName  UDT07_SIZE_NO 
Definition 
Name: UDT07 Column Size. Description: The size of the UDT07 olumn on Timesheet Grid for this employee.
 

UDT08_SIZE_NO 
ColumnName  UDT08_SIZE_NO 
Definition 
Name: UDT08 Column Size. Description: The size of the UDT08 olumn on Timesheet Grid for this employee.
 

UDT09_SIZE_NO 
ColumnName  UDT09_SIZE_NO 
Definition 
Name: UDT09 Column Size. Description: The size of the UDT09 olumn on Timesheet Grid for this employee.
 

UDT10_SIZE_NO 
ColumnName  UDT10_SIZE_NO 
Definition 
Name: UDT10 Column Size. Description: The size of the UDT10 column on Timesheet Grid for this employee.
 

CHARGE_DESC_SIZE_NO 
ColumnName  CHARGE_DESC_SIZE_NO 
Definition 
Name: UDT11 Column Size. Description: The size of the description column on Timesheet Grid for this employee.
 

S_LOOKUP_SORT_CD 
ColumnName  S_LOOKUP_SORT_CD 
Definition 
Name: Default Charge Lookup Sort. Description: Code to determine the ordering of charges for the employee in the Charge Lookup dialog. The valid values are:C – Code. D - Description. 
 

SPLITTER_BAR_LOCATION_NO 
ColumnName  SPLITTER_BAR_LOCATION_NO 
Definition 
Name: Timesheet Splitter Bar Location. Description: The location number of the splitter bar. For example if the field value is 2, there will be 2 columns to the left of the splitter bar.
 

AUTH_NO 
ColumnName  AUTH_NO 
Definition 
Name: Number of Desktop Expense Authorizations. Description: Number of Expense Authorizations that should be displayed in employees Desktop.
 

UDT11_SIZE_NO 
ColumnName  UDT11_SIZE_NO 
Definition 
Name: UDT11 Column Size. Description: The size of the UDT11 column on Timesheet Grid for this employee.
 

UDT12_SIZE_NO 
ColumnName  UDT12_SIZE_NO 
Definition 
Name: UDT12 Column Size. Description: The size of the UDT12 column on Timesheet Grid for this employee.
 

UDT13_SIZE_NO 
ColumnName  UDT13_SIZE_NO 
Definition 
Name: UDT13 Column Size. Description: The size of the UDT13 column on Timesheet Grid for this employee.
 

UDT14_SIZE_NO 
ColumnName  UDT14_SIZE_NO 
Definition 
Name: UDT14 Column Size. Description: The size of the UDT14 column on Timesheet Grid for this employee.
 

UDT15_SIZE_NO 
ColumnName  UDT15_SIZE_NO 
Definition 
Name: UDT15 Column Size. Description: The size of the UDT15 column on Timesheet Grid for this employee.
 

HIDE_VOIDED_ER_FL 
ColumnName  HIDE_VOIDED_ER_FL 
Definition 
Name: Hide Voided Expense Reports Flag. Description: Logical as to whether voided ER’s should be visible on the application desktop.
 

HIDE_VOIDED_EA_FL 
ColumnName  HIDE_VOIDED_EA_FL 
Definition 
Name: Hide Voided Expense Authorizations Flag. Description: Logical as to whether voided EA’s should be visible on the application desktop.
 

S_DFLT_MOBILE_TS_VIEW_CD 
ColumnName  S_DFLT_MOBILE_TS_VIEW_CD 
Definition 
Name: Default BlackBerry Timesheet View. Description: Default Timesheet View for BlackBerry. Valid Values are: 1 – 1 Column/3 Row 2 – 1 Column/6 Row
 

S_MOBILE_SCROLL_SPEED_CD 
ColumnName  S_MOBILE_SCROLL_SPEED_CD 
Definition 
Name: Status Bar Scroll Speed. Description: Default scroll speed of information that rolls along the bottom of the BlackBerry timesheet. Valid values are: 1 – Slow 5 – Medium 10– Fast 
 

S_MOBILE_TS_LINE_SORT 
ColumnName  S_MOBILE_TS_LINE_SORT 
Definition 
Name: BlackBerry Timesheet Line Sort. Description: BlackBerry Timesheet Line Sort. Valid values are: ID – ID Name – Name LINE– Line Number
 

DISPLAY_MOBILE_NON_WORK_FL 
ColumnName  DISPLAY_MOBILE_NON_WORK_FL 
Definition 
Name: Display Non Work Days. Description: Determines whether Non Work Days will be displayed on the employees BlackBerry timesheet. Logical as to whether Default charges are automatically populated onto the BlackBerry timesheet. Logical as to whether Favorites are automatically added onto the BlackBerry timesheet
 

DFLT_MOBILE_AUTO_POPULATE_FL 
ColumnName  DFLT_MOBILE_AUTO_POPULATE_FL 
Definition 
Name: Auto Populate Flag. Description: Logical as to whether Default charges are automatically populated onto the BlackBerry timesheet. Logical as to whether Favorites are automatically added onto the BlackBerry timesheet. Determines the hours increment that will be displayed in Add Hours options. Valid values are:
 

DFLT_MOBILE_ADD_FAVORITES_FL 
ColumnName  DFLT_MOBILE_ADD_FAVORITES_FL 
Definition 
Name: Add to Favorites Flag. Description: Logical as to whether Favorites are automatically added onto the BlackBerry timesheet. Determines the hours increment that will be displayed in Add Hours options. Valid values are: D – Disabled
 

S_MOBILE_HRS_INCREMENT_CD 
ColumnName  S_MOBILE_HRS_INCREMENT_CD 
Definition 
Name: Enter Hours with
Wheel/Trackball. Description: Determines the hours increment that will be displayed in Add
Hours options. Valid values are: D – Disabled·          W – Whole·          H – Half       
Q – Quarter  T – Tenth
 

DISPLAY_MOBILE_NOTIFICATION_FL 
ColumnName  DISPLAY_MOBILE_NOTIFICATION_FL 
Definition 
Name: Task Notification
Flag. Description: Logical as to whether timesheet tasks notifications are displayed on the
BlackBerry timesheet
 

S_TEXT_ICON_CD 
ColumnName  S_TEXT_ICON_CD 
Definition 
Name: Text Icon Description: Determines whether the user will see text only or text plus an icon when viewing functions. Valid values are: ICON – Icon Only ICONTEXT – Icon and Text.
 

S_DFLT_TIME_SCREEN_CD 
ColumnName  S_DFLT_TIME_SCREEN_CD 
Definition 
Name: Default Time Screen Description: Determines the default screen that will be displayed when the user is in the Time module. Valid values are: TS – Timesheet SPLASH – Splash.
 

S_DFLT_EXPENSE_SCREEN_CD 
ColumnName  S_DFLT_EXPENSE_SCREEN_CD 
Definition 
Name: Default Expense Sceen Description: Determines the default screen that will be displayed when the user is in the Expense module. Valid values are: ER – Expense Report EA – Expense Authorization SPLASH – Splash.
 

S_DFLT_SELF_SERVICE_SCREEN_CD 
ColumnName  S_DFLT_SELF_SERVICE_SCREEN_CD 
Definition 
Name: Default Self Service Screen Description: Determines the default screen that will be displayed when the user is in the Self Service: SPLASH - Splash.
 

S_DFLT_ADMIN_SCREEN_CD 
ColumnName  S_DFLT_ADMIN_SCREEN_CD 
Definition 
Name: Default Admin Screen Description: Determines the default screen that will be displayed when the user is in the Expense module. Valid values are: SPLASH - Splash.
 

SYS_DFLT_SCREEN_CD 
ColumnName  SYS_DFLT_SCREEN_CD 
Definition 
 

SHOW_WORKFLOW_STATUS_LEGEND_FL 
ColumnName  SHOW_WORKFLOW_STATUS_LEGEND_FL 
Definition