COST CENTER HISTORY Table
View exposing historical cost center master data by fiscal period and fiscal year including organizational, profit center, supervisor, addressee, fund, section, costing sheet, adjustment, and status attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee as provided by the source. |
VARCHAR2 |
120 |
ADDRESSEE_ROOM |
Addressee room as provided by the source. |
VARCHAR2 |
40 |
ADMIN_FLAG |
Admin flag as provided by the source. |
VARCHAR2 |
8 |
AREA_OF_RESP_CODE |
Code identifying area of resp. |
VARCHAR2 |
8 |
CALC_CODE |
Code identifying calc. |
VARCHAR2 |
4 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
16 |
COSTING_SHEET_DESCRIPTION |
Description of costing sheet description. |
VARCHAR2 |
120 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure as provided by the source. |
VARCHAR2 |
24 |
COST_CENTER_COUNTER |
Cost center counter as provided by the source. |
NUMBER |
|
COST_CENTER_EFFECTIVE_DATE |
Date associated with cost center effective. |
DATE |
|
COST_CENTER_EXPIRATION_DATE |
Date associated with cost center expiration. |
DATE |
|
COST_CENTER_ID |
Business identifier for the cost center. |
VARCHAR2 |
28 |
COST_CENTER_NAME |
Cost center name as provided by the source. |
VARCHAR2 |
160 |
COST_CENTER_PARENT_ID |
Business identifier for the cost center parent. |
VARCHAR2 |
28 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying cost collector category. |
VARCHAR2 |
20 |
COST_COLLECTOR_CATEGORY_NAME |
Cost collector category name as provided by the source. |
VARCHAR2 |
120 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
48 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
48 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
48 |
EB_ADJUSTMENT |
Eb adjustment as provided by the source. |
VARCHAR2 |
120 |
EB_ADJUSTMENT_KEY |
Surrogate key identifying the eb adjustment. |
VARCHAR2 |
24 |
FISCAL_PERIOD |
Fiscal period as provided by the source. |
VARCHAR2 |
24 |
FISCAL_YEAR |
Fiscal year as provided by the source. |
VARCHAR2 |
16 |
FUND_CENTER_ID |
Business identifier for the fund center. |
VARCHAR2 |
24 |
FUND_ID |
Business identifier for the fund. |
VARCHAR2 |
28 |
IS_CLOSED_COST_CENTER |
Indicator identifying whether closed cost center (Y/N). |
VARCHAR2 |
4 |
LAB_ALLOCATION |
Lab allocation as provided by the source. |
VARCHAR2 |
120 |
LAB_ALLOCATION_KEY |
Surrogate key identifying the lab allocation. |
VARCHAR2 |
24 |
MAIL_CODE |
Code identifying mail. |
VARCHAR2 |
4 |
OH_ADJUSTMENT |
Oh adjustment as provided by the source. |
VARCHAR2 |
120 |
OH_ADJUSTMENT_KEY |
Surrogate key identifying the oh adjustment. |
VARCHAR2 |
24 |
ON_OFF_CAMPUS_STATUS |
On off campus status as provided by the source. |
VARCHAR2 |
40 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
24 |
ORGANIZATION_NAME |
Organization name as provided by the source. |
VARCHAR2 |
160 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
4 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
28 |
PROFIT_CENTER_NAME |
Profit center name as provided by the source. |
VARCHAR2 |
160 |
RECORD_TYPE |
Record type as provided by the source. |
VARCHAR2 |
4 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
12 |
SECTION_NAME |
Section name as provided by the source. |
VARCHAR2 |
240 |
SUPERVISOR |
Supervisor as provided by the source. |
VARCHAR2 |
120 |
SUPERVISOR_ROOM |
Supervisor room as provided by the source. |
VARCHAR2 |
40 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
4 |
TERM_CODE_DESCRIPTION |
Description of term code description. |
VARCHAR2 |
160 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |