PAYROLL CO ACCESSIBLE Table
View exposing cost collector master data accessible for payroll reporting including identifiers, type and category attributes, organizational and funding attributes, supervisor and addressee detail, lifecycle dates, adjustments, and hierarchy fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
30 |
ADDRESSEE_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ADDRESSEE_ROOM |
Addressee room associated with the record. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Indicator identifying whether admin (Y/N). |
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 |
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_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_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_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 |
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_KEY |
Surrogate key identifying 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 |
IS_CLOSED_COST_COLLECTOR |
Indicator identifying whether closed cost collector (Y/N). |
VARCHAR2 |
1 |
IS_DOF_INTERNAL_ORDER |
Indicator identifying whether dof internal order (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 |
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_NAME |
Organization name associated with the record. |
VARCHAR2 |
40 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
1 |
POOL_UNITS |
Pool units associated with the record. |
NUMBER |
10,4 |
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 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
3 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
60 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at 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 |
Term code associated with the record. |
VARCHAR2 |
1 |
TREASURER_REPORT |
Treasurer report associated with the record. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |