Description: Department code information for configuration for charge master needs (revenue center)
| Column Name |
Ordinal Position |
|
| Column Name |
Ordinal Position |
Referenced Table |
|
| ORGANIZATIONID |
2 |
ORGANIZATION
|
|
|
Name |
Type |
|
| 1 |
CHARGEITEMDEFINITIONDEPARTMENTCODEID |
INT |
|
|
Description: The unique Id for the ChargeItemDefinitionDepartmentCode table
|
|
Name |
Type |
|
| 2 |
ORGANIZATIONID |
INT |
|
|
Description: OrganizationId is a foreign key to the Organization table
|
|
Name |
Type |
|
| 3 |
DEPARTMENTCODE |
NVARCHAR |
|
|
Description: The department code
|
|
Name |
Type |
|
| 4 |
DESCRIPTION |
NVARCHAR |
|
|
Description: The description for the department code
|
|
Name |
Type |
|
| 5 |
EFFECTIVEPERIODSTARTDATETIME |
DATETIME2 |
|
|
Description: The date the department code starts to be effective
|
|
Name |
Type |
|
| 6 |
EFFECTIVEPERIODSTOPDATETIME |
DATETIME2 |
|
|
Description: The date the department code ceases to be effective
|
|
Name |
Type |
|
| 8 |
CREATED |
DATETIME2 |
|
|
Description: Record created time
|
|
Name |
Type |
|
| 9 |
LASTMODIFIED |
DATETIME2 |
|
|
Description: Record Last Modified time
|