EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: The ID of the employee whose favorite it is.
 

EMPL_GROUP_CD 
ColumnName  EMPL_GROUP_CD 
Definition 
Name: Employee Group Code. Description: The group code where favorites originated. If the favorite did not originate from a group, then ‘NONE’ shall be found in this field.
 

SEQ_NO 
ColumnName  SEQ_NO 
Definition 
Name: Sequence Number. Description: Relative sequence number that provides uniqueness to key. Does not have to be in straight numeric sequences. I.e,. gaps are permitted.
 

CHARGE_DESC 
ColumnName  CHARGE_DESC 
Definition 
Name: Charge Description. Description: The charge description for the favorite.
 

HIDE_FL 
ColumnName  HIDE_FL 
Definition 
Name: Hide Flag. Description: Logical as to whether employee has hidden charge from favorites.
 

AUTO_LOAD_FL 
ColumnName  AUTO_LOAD_FL 
Definition 
Name: Auto Load Flag. Description: Logical as to whether this charge is loaded automatically on new timesheets for this employee when EMPL_PREFERENCE.load_favorites_fl = "Y".  This logical also determines whether this charge is loaded when the Load Favorites function is selected from the timesheet.
 

DFLT_UDT01_ID 
ColumnName  DFLT_UDT01_ID 
Definition 
Name: Default UDT01 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT02_ID 
ColumnName  DFLT_UDT02_ID 
Definition 
Name: Default UDT02 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT03_ID 
ColumnName  DFLT_UDT03_ID 
Definition 
Name: Default UDT03 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT04_ID 
ColumnName  DFLT_UDT04_ID 
Definition 
Name: Default UDT04 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT05_ID 
ColumnName  DFLT_UDT05_ID 
Definition 
Name: Default UDT05 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT06_ID 
ColumnName  DFLT_UDT06_ID 
Definition 
Name: Default UDT06 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT07_ID 
ColumnName  DFLT_UDT07_ID 
Definition 
Name: Default UDT07 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT08_ID 
ColumnName  DFLT_UDT08_ID 
Definition 
Name: Default UDT08 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT09_ID 
ColumnName  DFLT_UDT09_ID 
Definition 
Name: Default UDT09 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT10_ID 
ColumnName  DFLT_UDT10_ID 
Definition 
Name: Default UDT10 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT11_ID 
ColumnName  DFLT_UDT11_ID 
Definition 
Name: Default UDT11 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT12_ID 
ColumnName  DFLT_UDT12_ID 
Definition 
Name: Default UDT12 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT13_ID 
ColumnName  DFLT_UDT13_ID 
Definition 
Name: Default UDT13 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT14_ID 
ColumnName  DFLT_UDT14_ID 
Definition 
Name: Default UDT14 ID. Description: If present, this value provides overriding default for this UDT.
 

DFLT_UDT15_ID 
ColumnName  DFLT_UDT15_ID 
Definition 
Name: Default UDT14 ID. Description: If present, this value provides overriding default for this UDT.
 

UDT06_CP_COMPANY_CD 
ColumnName  UDT06_CP_COMPANY_CD 
Definition 
Name: Default UDT06 CP Company. Description: Costpoint Company Code for DFLT_UDT06_ID field
 

UDT07_CP_COMPANY_CD 
ColumnName  UDT07_CP_COMPANY_CD 
Definition 
Name: Default UDT07 CP Company. Description: Costpoint Company Code for DLFT_UDT07_ID field
 

HOLIDAY_FL 
ColumnName  HOLIDAY_FL 
Definition 
Name: Holiday Flag. Description: A logical indicator if this favorite is the employee’s holiday charge.
 

VACATION_FL 
ColumnName  VACATION_FL 
Definition 
Name: Vacation Flag. Description: A logical indicator if this favorite is the employee’s vacation charge.
 

WORK_DAY_PCT 
ColumnName  WORK_DAY_PCT 
Definition 
Name: Work Percentage. Description: The percentage of standard that this favorite should be charged on workdays for exception based timesheets.
 

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.