IMPORT_UDT10 
Default Table Name  IMPORT_UDT10 
Definition 
 Name: UDT10 Import .     Description: This staging table contains UDT10 master table data that will be imported to Deltek Time and Expense if validations are passed.
 

IMPORT_UDT10 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR2(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR2(1)  NO 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch 
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 
EXTERNAL_USER    VARCHAR2(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
UDT10_ID    VARCHAR2(20)  NO 
Name: UDT10 ID. Description: Unique user-provided identifier ID for this user-defined table record.
 
UDT10_NAME    VARCHAR2(30)  YES 
Name: UDT10 Name. Description: Description of user-defined ID.
 
OT_FL    VARCHAR2(1)  YES 
Name: Overtime Flag. Description: Logical as to whether this UDT10 ID is for overtime.
 
OT_UDT10_ID    VARCHAR2(20)  YES 
Name: Overtime UDT01 ID. Description: The UDT10 ID to which overtime premiums are charged.
 
COST_FL    VARCHAR2(1)  YES 
Name: Cost Only Flag. Description: Logical as to whether this UDT10 ID is for "cost only" hours.
 
TEXT_FL    VARCHAR2(1)  YES 
Name: Comment Required Flag. Description: Logical as to whether comments are required when this UDT10 ID is used.
 
MISC_LABOR_CD    VARCHAR2(30)  YES 
Name: Miscellaneous Labor Code. Description: Miscellaneous field contains codes used to feed the labor distribution file during export.
 
MISC_PAYROLL_CD    VARCHAR2(30)  YES 
Name: Miscellaneous Payroll Code. Description: Miscellaneous field contains codes used to feed the payroll file during export.
 
PAYROLL_EARNINGS_CD    VARCHAR2(30)  YES 
Name: Payroll Earnings Code. Description: Earnings code for this UDT10 ID.
 
S_PAYROLL_MAP_CD    VARCHAR2(10)  YES 
Name: Earnings Mapping Option. Description: How the Earnings code will be mapped during export. The valid options are as follows: N - None. R - Regular. O - Overtime. 3 - Earnings 3. 4 - Earnings 4. 5 - Earnings 5. H3 - Hours 3. H4 - Hours 4
 
ACTIVE_FL    VARCHAR2(1)  YES 
Name: Active Flag. Description: Logical as to whether this UDT10 ID is active.
 
RATE1_FACTOR_AMT    NUMBER(15, 5)  NO 
Name: User Defined Rate 1 Factor. Description: Multiply factor for user-defined 1 amount.
 
RATE1_FIXED_AMT    NUMBER(15, 5)  NO 
Name: User Defined Rate 1 Fixed Amount. Description: Fixed lump sum amount for user-defined 1 amount.
 
S_RATE1_CALC_CD    VARCHAR2(5)  NO 
Name: User Defined Rate 1 Calculation Method. Description: The method by which user-defined rate 1 amount is calculated. The valid values are as follows: CALC1 - (Hours x Rate x Factor). + Amount. CALC2 - (Hours x Rate x Factor). + (Hours x Amount). CALC3 - (Hours x Rate x Factor). + (Hours x Amount x Factor) 
 
RATE2_FACTOR_AMT    NUMBER(15, 5)  NO 
Name: User Defined Rate 2 Factor. Description: Multiply factor for user-defined 2 amount.
 
RATE2_FIXED_AMT    NUMBER(15, 5)  NO 
Name: User Defined Rate 2 Fixed Amount. Description: Fixed lump sum amount for user-defined 2 amount.
 
S_RATE2_CALC_CD    VARCHAR2(5)  NO 
Name: User Defined Rate 2 Calculation Method. Description: The method by which user-defined rate 2 amount is calculated. The valid values are as follows: CALC1 - (Hours x Rate x Factor). + Amount. CALC2 - (Hours x Rate x Factor). + (Hours x Amount). CALC3 - (Hours x Rate x Factor). + (Hours x Amount x Factor) 
 
RECAST_LABOR_UDT10_ID    VARCHAR2(20)  YES 
Name: Labor Recast UDT10 ID. Description: The UDT10 code used for recasting labor exports.
 
RECAST_PAYROLL_UDT10_ID    VARCHAR2(20)  YES 
Name: Payroll Recast UDT10 ID. Description: The UDT10 code used for recasting payroll exports.
 
PRORATE_FL    VARCHAR2(1)  YES 
Name: Prorate Flag. Description: Logical as to whether timesheet hours assigned to this UDT10 should be included in the hour’s pro-ration logic.
 
FUTURE_FL    VARCHAR2(1)  YES 
Name: Future Flag. Description: Logical as to whether UDT10s assigned to this type can be charged into the future.
 

IMPORT_UDT10 Primary and Unique Keys 
Key Name  Key Type  Keys 

IMPORT_UDT10 Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable