EMPL_PREFERENCE 
Default Table Name  EMPL_PREFERENCE 
Definition 
 Field.     S_DFLT_MOBILE_TS_VIEW_CD
 

EMPL_PREFERENCE Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EMPL_ID(PK)(FK)    VARCHAR2(20)  NO 
Name: Employee ID. Description: Employee ID identifier for the employee preference record.
 
COUNTRY_CD(FK)    VARCHAR2(2)  NO 
Name: Country. Description: The country code preferred for this Employee ID.
 
LANGUAGE_CD(FK)    VARCHAR2(2)  NO 
Name: Language. Description: The language code preferred for this Employee ID.
 
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.
 
SHOW_MENU_FL    VARCHAR2(1)  NO 
Name: Show Menu Flag. Description: Logical as to whether the menu is shown when user logs into system.
 
TIMESHEET_NO    NUMBER(10, 0)  NO 
Name: Number of Desktop Timesheets. Description: Number of timesheets that should be displayed in employees Desktop.
 
LOAD_FAVORITES_FL    VARCHAR2(1)  NO 
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    NUMBER(10, 0)  NO 
Name: Number of Desktop Expense Reports. Description: Number of expense reports that should be displayed in employees Desktop.
 
S_NOTIFY_METHOD_CD    VARCHAR2(1)  NO 
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(FK)    VARCHAR2(35)  YES 
Name: Timezone. Description: The time zone preference for this employee ID.
 
UDT01_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT01 Column Size. Description: The size of the UDT01 column on Timesheet Grid for this employee.
 
UDT02_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT02 Column Size. Description: The size of the UDT02 column on Timesheet Grid for this employee.
 
UDT03_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT03 Column Size. Description: The size of the UDT03column on Timesheet Grid for this employee.
 
UDT04_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT04 Column Size. Description: The size of the UDT04column on Timesheet Grid for this employee.
 
UDT05_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT05 Column Size. Description: The size of the UDT05 olumn on Timesheet Grid for this employee.
 
UDT06_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT06 Column Size. Description: The size of the UDT06 olumn on Timesheet Grid for this employee.
 
UDT07_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT07 Column Size. Description: The size of the UDT07 olumn on Timesheet Grid for this employee.
 
UDT08_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT08 Column Size. Description: The size of the UDT08 olumn on Timesheet Grid for this employee.
 
UDT09_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT09 Column Size. Description: The size of the UDT09 olumn on Timesheet Grid for this employee.
 
UDT10_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT10 Column Size. Description: The size of the UDT10 column on Timesheet Grid for this employee.
 
CHARGE_DESC_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT11 Column Size. Description: The size of the description column on Timesheet Grid for this employee.
 
S_LOOKUP_SORT_CD    VARCHAR2(1)  NO 
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    NUMBER(10, 0)  NO 
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    NUMBER(10, 0)  NO 
Name: Number of Desktop Expense Authorizations. Description: Number of Expense Authorizations that should be displayed in employees Desktop.
 
UDT11_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT11 Column Size. Description: The size of the UDT11 column on Timesheet Grid for this employee.
 
UDT12_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT12 Column Size. Description: The size of the UDT12 column on Timesheet Grid for this employee.
 
UDT13_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT13 Column Size. Description: The size of the UDT13 column on Timesheet Grid for this employee.
 
UDT14_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT14 Column Size. Description: The size of the UDT14 column on Timesheet Grid for this employee.
 
UDT15_SIZE_NO    NUMBER(10, 0)  NO 
Name: UDT15 Column Size. Description: The size of the UDT15 column on Timesheet Grid for this employee.
 
HIDE_VOIDED_ER_FL    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(2)  NO 
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    VARCHAR2(5)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
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    VARCHAR2(1)  NO 
Name: Task Notification
Flag. Description: Logical as to whether timesheet tasks notifications are displayed on the
BlackBerry timesheet
 
S_TEXT_ICON_CD    VARCHAR2(10)  NO 
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    VARCHAR2(10)  NO 
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    VARCHAR2(10)  NO 
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    VARCHAR2(10)  NO 
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    VARCHAR2(10)  NO 
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    VARCHAR2(10)  NO 
 
SHOW_WORKFLOW_STATUS_LEGEND_FL    VARCHAR2(1)  NO 
 

EMPL_PREFERENCE Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0038  PrimaryKey  EMPL_ID 

EMPL_PREFERENCE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
EMPL  Identifying  One To Zero or More  F00036      EMPL_ID  NO  NO 
LANGUAGE  Non-Identifying  One To Zero or More  F00037      COUNTRY_CD, LANGUAGE_CD  NO  NO 
TIME_ZONE  Non-Identifying  Zero or One to Zero or More  F00263      TIME_ZONE_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable