IMPORT_CHARGE 
Default Table Name  IMPORT_CHARGE 
Definition 
 Name: Charge Tree/Branch.     Description: This staging table contains Charge Tree/ Branch/Charge master table data that will be imported to Deltek Time and Expense if validations are passed.
 

IMPORT_CHARGE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR(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    VARCHAR(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
S_IMPORT_TYPE_CD    VARCHAR(4)  NO 
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    VARCHAR(50)  NO 
Name: Charge Tree. Description: The top-level identifier of the charge tree.
 
CHARGE_TREE_DESC    VARCHAR(30)  NO 
Name: Charge Tree Description. Description: The name of the charge tree.
 
CHARGE_BRANCH_CD    VARCHAR(50)  YES 
Name: Charge Branch. Description: The identifier of the branch in the charge tree.
 
CHARGE_BRANCH_DESC    VARCHAR(30)  YES 
Name: Charge Branch Description. Description: The description of the charge branch.
 
PARENT_CHARGE_BRANCH_CD    VARCHAR(50)  YES 
Name: Parent Charge Branch. Description: This field identifies the parent branch, if there is one.
 
CHARGE_CD    VARCHAR(100)  YES 
Name: Charge Code. Description: The identifier of the charge in the charge tree/branch.
 
EMPL_GROUP_CD    VARCHAR(25)  YES 
Name: Employee Group. Description: Employee Group authorized for charge or branch.
 
EMPL_ID    VARCHAR(20)  YES 
Name: Employee ID. Description: Employee ID authorized for charge branch charge.
 
DFLT_UDT01_ID    VARCHAR(50)  YES 
Name: Default UDT01 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT02_ID    VARCHAR(50)  YES 
Name: Default UDT02 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT03_ID    VARCHAR(20)  YES 
Name: Default UDT03 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT04_ID    VARCHAR(20)  YES 
Name: Default UDT04 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT05_ID    VARCHAR(20)  YES 
Name: Default UDT05 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT06_ID    VARCHAR(20)  YES 
Name: Default UDT06 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT07_ID    VARCHAR(20)  YES 
Name: Default UDT07 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT08_ID    VARCHAR(20)  YES 
Name: Default UDT08 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT09_ID    VARCHAR(20)  YES 
Name: Default UDT09 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT10_ID    VARCHAR(20)  YES 
Name: Default UDT10 ID. Description: If present, this value provides overriding default for this UDT.
 
RESTRICT_EMPL_GROUP_FL    VARCHAR(1)  YES 
Name: Restrict Employee Group Flag. Description: Logical as to whether this tree is restricted to certain employee groups.
 
RESTRICT_EMPL_FL    VARCHAR(1)  YES 
Name: Restrict Employee Flag. Description: Logical as to whether this charge is restricted to certain employees.
 
ACTIVE_FL    VARCHAR(1)  YES 
Name: Active Flag. Description: Logical as to whether this charge is active.
 
UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
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    VARCHAR(10)  YES 
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    VARCHAR(1)  YES 
Name: Comment Required Flag. Description: Logical as to whether comment is required when this charge is used on timesheet.
 
DFLT_UDT11_ID    VARCHAR(20)  YES 
Name: Default UDT11 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT12_ID    VARCHAR(20)  YES 
Name: Default UDT12 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT13_ID    VARCHAR(20)  YES 
Name: Default UDT13 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT14_ID    VARCHAR(20)  YES 
Name: Default UDT14 ID. Description: If present, this value provides overriding default for this UDT.
 
DFLT_UDT15_ID    VARCHAR(20)  YES 
Name: Default UDT15 ID. Description: If present, this value provides overriding default for this UDT.
 

IMPORT_CHARGE Keys 
Key Name  Key Type  Keys 
SI_0029  Inversion Entry  USER_COMPANY_ID, S_IMPORT_CD, TIME_STAMP, EXTERNAL_USER, S_IMPORT_TYPE_CD, CHARGE_TREE_CD, CHARGE_TREE_DESC, CHARGE_BRANCH_CD, CHARGE_BRANCH_DESC, PARENT_CHARGE_BRANCH_CD, CHARGE_CD, EMPL_GROUP_CD, EMPL_ID 

IMPORT_CHARGE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype