PROFIT CENTER Table
View exposing profit center master data including identifiers, organizational rollups, effective dates, activity status, and DLC and school attributes used for financial reporting and hierarchy alignment.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Identifier for the DLC (department, lab, or center) associated with the profit center. |
VARCHAR2 |
180 |
DLC_NAME |
Name of the DLC associated with the profit center. |
VARCHAR2 |
840 |
IS_INACTIVE_PROFIT_CENTER |
Indicator identifying whether the profit center is inactive. |
VARCHAR2 |
1 |
ORGANIZATION_ID |
Identifier for the organization associated with the profit center. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Name of the organization associated with the profit center. |
VARCHAR2 |
40 |
PROFIT_CENTER_COUNTER |
System-generated counter used to track record versions. |
NUMBER |
|
PROFIT_CENTER_EFFECTIVE_DATE |
Date the profit center becomes effective. |
DATE |
|
PROFIT_CENTER_EXPIRATION_DATE |
Date the profit center expires. |
DATE |
|
PROFIT_CENTER_ID |
Business identifier for the profit center defined in the source financial system. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate identifier for the profit center record. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Descriptive name of the profit center. |
VARCHAR2 |
40 |
SCHOOL_AREA |
School or area associated with the profit center for reporting purposes. |
VARCHAR2 |
840 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |