FRC COST COLLECTOR Table
View exposing cost collector reference data used in Financial Review and Control review and monitoring processes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
30 |
ADDRESSEE_MIT_ID |
Addressee mit id associated with the record. |
VARCHAR2 |
9 |
ADDRESSEE_ROOM |
Addressee room associated with the record. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Admin flag associated with the record. |
VARCHAR2 |
2 |
APPLICATION |
Application associated with the record. |
VARCHAR2 |
2 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the record. |
NUMBER |
13,2 |
CALC_CODE |
Code identifying calc. |
VARCHAR2 |
1 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
CONTROLLING_AREA |
Controlling area associated with the record. |
VARCHAR2 |
4 |
COSTING_SHEET_DESCRIPTION |
Description of costing sheet. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure associated with the record. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying cost collector category. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of cost collector category. |
VARCHAR2 |
30 |
COST_COLLECTOR_CONTINUED_FROM |
Cost collector continued from associated with the record. |
VARCHAR2 |
7 |
COST_COLLECTOR_CONTINUED_TO |
Cost collector continued to associated with the record. |
VARCHAR2 |
7 |
COST_COLLECTOR_COUNTER |
Cost collector counter associated with the record. |
NUMBER |
|
COST_COLLECTOR_CREATE_DATE |
Date associated with cost collector create. |
DATE |
|
COST_COLLECTOR_CREATE_MIT_ID |
Business identifier for the cost collector create mit. |
VARCHAR2 |
9 |
COST_COLLECTOR_CREATE_USER_ID |
Business identifier for the cost collector create user. |
VARCHAR2 |
12 |
COST_COLLECTOR_CURRENCY |
Cost collector currency associated with the record. |
VARCHAR2 |
5 |
COST_COLLECTOR_EFFECTIVE_DATE |
Date associated with cost collector effective. |
DATE |
|
COST_COLLECTOR_EXPIRATION_DATE |
Date associated with cost collector expiration. |
DATE |
|
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_ID |
Business identifier for the cost collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_ID_WITH_TYPE |
Cost collector id with type associated with the record. |
VARCHAR2 |
8 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_COLLECTOR_NAME |
Cost collector name associated with the record. |
VARCHAR2 |
60 |
COST_COLLECTOR_NOW_KEY |
Surrogate key identifying the cost collector now. |
VARCHAR2 |
12 |
COST_COLLECTOR_PARENT_ID |
Business identifier for the cost collector parent. |
VARCHAR2 |
7 |
COST_COLLECTOR_TYPE_CODE |
Code identifying cost collector type. |
VARCHAR2 |
2 |
COST_COLLECTOR_TYPE_DESC |
Description of cost collector type. |
VARCHAR2 |
20 |
CURRENT_VERSION_FLAG |
Current version flag associated with the record. |
VARCHAR2 |
1 |
CURRENT_VERSION_NUMBER |
Current version number associated with the record. |
NUMBER |
|
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
15 |
EB_ADJUSTMENT |
Eb adjustment associated with the record. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
Surrogate key identifying the eb adjustment. |
VARCHAR2 |
6 |
FS_CODE |
Code identifying fs. |
VARCHAR2 |
1 |
FUNDING_CLASS |
Funding class associated with the record. |
VARCHAR2 |
3 |
FUNDING_CLASS_DESCRIPTION |
Description of funding class. |
VARCHAR2 |
70 |
FUND_CENTER_ID |
Business identifier for the fund center. |
VARCHAR2 |
6 |
FUND_CENTER_NAME |
Fund center name associated with the record. |
VARCHAR2 |
45 |
FUND_ID |
Business identifier for the fund. |
VARCHAR2 |
7 |
FUND_KEY |
Surrogate key identifying the fund. |
VARCHAR2 |
11 |
FUND_NAME |
Fund name associated with the record. |
VARCHAR2 |
40 |
FUND_UNDERRECOVERY |
Fund underrecovery associated with the record. |
VARCHAR2 |
30 |
INTERNAL_ORDER_CATEGORY |
Internal order category associated with the record. |
VARCHAR2 |
2 |
IS_CLOSED_COST_COLLECTOR |
Indicator identifying whether closed cost collector (Y/N). |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Lab allocation associated with the record. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Surrogate key identifying the lab allocation. |
VARCHAR2 |
6 |
MAIL_CODE |
Code identifying mail. |
VARCHAR2 |
1 |
OBJECT_NUMBER |
Object number associated with the record. |
VARCHAR2 |
22 |
OH_ADJUSTMENT |
Oh adjustment associated with the record. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Surrogate key identifying the oh adjustment. |
VARCHAR2 |
6 |
ON_OFF_CAMPUS_STATUS |
On off campus status associated with the record. |
VARCHAR2 |
10 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
6 |
ORGANIZATION_KEY |
Surrogate key identifying the organization. |
VARCHAR2 |
10 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
40 |
OVERRUN_AMOUNT |
Overrun amount associated with the record. |
NUMBER |
13,2 |
OVERRUN_FLAG |
Overrun flag associated with the record. |
VARCHAR2 |
1 |
OVERRUN_WITH_COMMIT_AMOUNT |
Overrun with commit amount associated with the record. |
NUMBER |
13,2 |
OVERRUN_WITH_COMMIT_FLAG |
Overrun with commit flag associated with the record. |
VARCHAR2 |
1 |
PLANNING |
Planning associated with the record. |
VARCHAR2 |
30 |
PLANNING_KEY |
Surrogate key identifying the planning. |
VARCHAR2 |
6 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
1 |
POOL_UNIT |
Pool unit associated with the record. |
NUMBER |
10,4 |
PROFIT_CENTER_FY_KEY |
Surrogate key identifying the profit center fy. |
VARCHAR2 |
11 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
PROFIT_CENTER_NOW_KEY |
Surrogate key identifying the profit center now. |
VARCHAR2 |
11 |
RECEIVER_SECTION_CODE |
Code identifying receiver section. |
VARCHAR2 |
3 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
3 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
60 |
SETTLEMENT_RECEIVER |
Settlement receiver associated with the record. |
VARCHAR2 |
7 |
SETTLEMENT_RECEIVER_TYPE |
Settlement receiver type associated with the record. |
VARCHAR2 |
1 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
Business identifier for the supervisor mit. |
VARCHAR2 |
9 |
SUPERVISOR_ROOM |
Supervisor room associated with the record. |
VARCHAR2 |
10 |
SURCHARGE_CALC_PATTERN_KEY |
Surrogate key identifying the surcharge calc pattern. |
VARCHAR2 |
50 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
1 |
TERM_CODE_DESCRIPTION |
Description of term code. |
VARCHAR2 |
40 |
TREASURER_REPORT |
Treasurer report associated with the record. |
VARCHAR2 |
3 |
USAGE_OF_CONDITION |
Usage of condition associated with the record. |
VARCHAR2 |
1 |
VERSION_END_DATE |
Date associated with version end. |
DATE |
|
VERSION_START_DATE |
Date associated with version start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |