Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
CHARGE_TREE_CD |
|
VARCHAR(50) |
NO |
Name: Charge Tree. Description: The top-level identifier of the charge tree. |
CHARGE_BRANCH_CD |
|
VARCHAR(50) |
NO |
Name: Charge Branch. Description: The identifier of the branch in the charge tree. |
CHARGE_CD |
|
VARCHAR(100) |
NO |
Name: Charge. Description: The identifier of the charge in the charge tree/branch. |
DFLT_UDT01_ID |
|
VARCHAR(50) |
YES |
Name: Default UDT01. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT02_ID |
|
VARCHAR(50) |
YES |
Name: Default UDT02. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT03_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT03. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT04_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT04. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT05_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT05. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT06_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT06. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT07_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT07. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT08_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT08. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT09_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT09. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT10_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT10. Description: If present, this value provides overriding default for this UDT. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
ACTIVE_FL |
|
VARCHAR(1) |
NO |
Name: Active Flag. Description: Logical as to whether this charge is active. |
RESTRICT_EMPL_FL |
|
VARCHAR(1) |
NO |
Name: Restrict Employees Flag. Description: Logical as to whether this charge should be restricted to certain employees. |
UDT09_ABBRV_ID |
|
VARCHAR(20) |
YES |
Name: UDT09 Abbreviation. Description: Abbreviation for DFLT_UDT09_ID. |
UDT06_CP_COMPANY_CD |
|
VARCHAR(10) |
YES |
Name: UDT06 Costpoint Company. Description: Costpoint Company Code for DFLT_UDT06_ID field. |
UDT07_CP_COMPANY_CD |
|
VARCHAR(10) |
YES |
Name: UDT07 Costpoint Company. Description: Costpoint Company Code for DFLT_UDT07_ID field. |
OVERRIDE_CHARGE_DESC |
|
VARCHAR(120) |
YES |
Name: Override Charge Description. Description: If a value exists in this column it will replace the charge description from UDT01/UDT02 on the timesheet line for the charge. |
COMMENT_REQUIRED_FL |
|
VARCHAR(1) |
NO |
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. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT12_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT12. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT13_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT13. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT14_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT14. Description: If present, this value provides overriding default for this UDT. |
DFLT_UDT15_ID |
|
VARCHAR(20) |
YES |
Name: Default UDT15. Description: If present, this value provides overriding default for this UDT. |
AUTH_HRS |
|
NUMERIC(8, 2) |
NO |
Name: Authorized Hours. Description: The number of hours authorized for this charge. |
Key Name |
Key Type |
Keys |
SI_0074 |
Inversion Entry |
RESTRICT_EMPL_FL, ACTIVE_FL, CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD, DFLT_UDT02_ID, DFLT_UDT01_ID |
SI_0071 |
Inversion Entry |
DFLT_UDT01_ID, OVERRIDE_CHARGE_DESC, ACTIVE_FL |
SI_0068 |
Inversion Entry |
DFLT_UDT02_ID, OVERRIDE_CHARGE_DESC, ACTIVE_FL |
RI_LF_0025 |
Inversion Entry |
DFLT_UDT09_ID |
SI_0034 |
Inversion Entry |
DFLT_UDT02_ID, ACTIVE_FL |
SI_0033 |
Inversion Entry |
DFLT_UDT01_ID, ACTIVE_FL |
RI_F00006 |
Inversion Entry |
CHARGE_TREE_CD, CHARGE_BRANCH_CD |
PI_0015 |
PrimaryKey |
CHARGE_TREE_CD, CHARGE_BRANCH_CD, CHARGE_CD |