USER_COMPANY_ID 
ColumnName  USER_COMPANY_ID 
Definition 
Name: Domain. Description: Alias for database schema that will be updated.
 

S_IMPORT_CD 
ColumnName  S_IMPORT_CD 
Definition 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch 
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 

EXTERNAL_USER 
ColumnName  EXTERNAL_USER 
Definition 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 

S_IMPORT_TYPE_CD 
ColumnName  S_IMPORT_TYPE_CD 
Definition 
Name: Import Record Type. Description: Indicates the type of record being imported. The valid values are: C - Charge. CB - Charge Branch. CBC - Charge Branch Charge. CEG - Charge Empl Groups. CBEG - Charge Branch Empl Group. CBCE - Charge Branch Charge Empl
 

CHARGE_TREE_CD 
ColumnName  CHARGE_TREE_CD 
Definition 
Name: Charge Tree. Description: The top-level identifier of the charge tree.
 

CHARGE_TREE_DESC 
ColumnName  CHARGE_TREE_DESC 
Definition 
Name: Charge Tree Description. Description: The name of the charge tree.
 

CHARGE_BRANCH_CD 
ColumnName  CHARGE_BRANCH_CD 
Definition 
Name: Charge Branch. Description: The identifier of the branch in the charge tree.
 

CHARGE_BRANCH_DESC 
ColumnName  CHARGE_BRANCH_DESC 
Definition 
Name: Charge Branch Description. Description: The description of the charge branch.
 

PARENT_CHARGE_BRANCH_CD 
ColumnName  PARENT_CHARGE_BRANCH_CD 
Definition 
Name: Parent Charge Branch. Description: This field identifies the parent branch, if there is one.
 

CHARGE_CD 
ColumnName  CHARGE_CD 
Definition 
Name: Charge Code. Description: The identifier of the charge in the charge tree/branch.
 

EMPL_GROUP_CD 
ColumnName  EMPL_GROUP_CD 
Definition 
Name: Employee Group. Description: Employee Group authorized for charge or branch.
 

EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: Employee ID authorized for charge branch charge.
 

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.
 

RESTRICT_EMPL_GROUP_FL 
ColumnName  RESTRICT_EMPL_GROUP_FL 
Definition 
Name: Restrict Employee Group Flag. Description: Logical as to whether this tree is restricted to certain employee groups.
 

RESTRICT_EMPL_FL 
ColumnName  RESTRICT_EMPL_FL 
Definition 
Name: Restrict Employee Flag. Description: Logical as to whether this charge is restricted to certain employees.
 

ACTIVE_FL 
ColumnName  ACTIVE_FL 
Definition 
Name: Active Flag. Description: Logical as to whether this charge is active.
 

UDT06_CP_COMPANY_CD 
ColumnName  UDT06_CP_COMPANY_CD 
Definition 
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06 field. Value should be null if UDT06_ID is null. If UDT06_ID is not null, value must be “1” if system is not Costpoint Multi-Company. If UDT06_ID is not null and system is Costpoint Multi-Company, then field must have value.
 

UDT07_CP_COMPANY_CD 
ColumnName  UDT07_CP_COMPANY_CD 
Definition 
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07 field. Value should be null if UDT07_ID is null. If UDT07_ID is not null, value must be “1” if system is not Costpoint Multi-Company. If UDT07_ID is not null and system is Costpoint Multi-Company, then field must have value.
 

COMMENT_REQUIRED_FL 
ColumnName  COMMENT_REQUIRED_FL 
Definition 
Name: Comment Required Flag. Description: Logical as to whether comment is required when this charge is used on timesheet.
 

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 UDT15 ID. Description: If present, this value provides overriding default for this UDT.