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. |