Data Warehouse

ADDRESSEE

Addressee as provided by the source.

VARCHAR2

30

ADDRESSEE_ROOM

Addressee room as provided by the source.

VARCHAR2

10

ADMIN_FLAG

Admin flag as provided by the source.

VARCHAR2

2

AUTHORIZED_TOTAL_AMOUNT

Authorized total amount as provided by the source.

NUMBER

13,2

CALC_CODE

Code identifying calc.

VARCHAR2

1

COMPANY_CODE

Code identifying company.

VARCHAR2

4

COSTING_SHEET_DESCRIPTION

Description of costing sheet description.

VARCHAR2

30

COSTING_SHEET_PROCEDURE

Costing sheet procedure as provided by the source.

VARCHAR2

6

COST_COLLECTOR_CATEGORY_CODE

Code identifying cost collector category.

VARCHAR2

5

COST_COLLECTOR_CATEGORY_DESC

Description of cost collector category desc.

VARCHAR2

30

COST_COLLECTOR_CONTINUED_FROM

Cost collector continued from as provided by the source.

VARCHAR2

7

COST_COLLECTOR_CONTINUED_TO

Cost collector continued to as provided by the source.

VARCHAR2

7

COST_COLLECTOR_COUNTER

Cost collector counter as provided by the source.

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 as provided by the source.

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 as provided by the source.

VARCHAR2

8

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

COST_COLLECTOR_NAME

Cost collector name as provided by the source.

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 desc.

VARCHAR2

20

DLC_KEY

Surrogate key identifying the dlc.

VARCHAR2

15

DLC_NAME

Dlc name as provided by the source.

VARCHAR2

70

EB_ADJUSTMENT

Eb adjustment as provided by the source.

VARCHAR2

30

EB_ADJUSTMENT_KEY

Surrogate key identifying the eb adjustment.

VARCHAR2

6

FS_CODE

Code identifying fs.

VARCHAR2

1

FUNDING_CLASS

Funding class as provided by the source.

VARCHAR2

3

FUNDING_CLASS_DESCRIPTION

Description of funding class description.

VARCHAR2

70

FUND_CENTER_ID

Business identifier for the fund center.

VARCHAR2

6

FUND_CENTER_NAME

Fund center name as provided by the source.

VARCHAR2

45

FUND_ID

Business identifier for the fund.

VARCHAR2

7

FUND_KEY

Surrogate key identifying the fund.

VARCHAR2

11

FUND_NAME

Fund name as provided by the source.

VARCHAR2

40

FUND_UNDERRECOVERY

Fund underrecovery as provided by the source.

VARCHAR2

30

HAS_CURRENT_FY_BASE_BUDGET

Has current fy base budget as provided by the source.

VARCHAR2

1

IS_CLOSED_COST_COLLECTOR

Indicator identifying whether closed cost collector (Y/N).

VARCHAR2

1

IS_DEPT_CHAIR_SWEB_ACCOUNT

Indicator identifying whether dept chair sweb account (Y/N).

VARCHAR2

1

IS_DOF_INTERNAL_ORDER

Indicator identifying whether dof internal order (Y/N).

VARCHAR2

1

IS_FABRICATED_EQUIPMNT_ACCOUNT

Indicator identifying whether fabricated equipmnt account (Y/N).

VARCHAR2

1

IS_INST_CHAIR_SWEB_ACCOUNT

Indicator identifying whether inst chair sweb account (Y/N).

VARCHAR2

1

IS_INTERNAL_COST_SHARING_CO

Indicator identifying whether internal cost sharing co (Y/N).

VARCHAR2

1

IS_PAYROLL_SUSPENSE_CO

Indicator identifying whether payroll suspense co (Y/N).

VARCHAR2

1

IS_SCHOOL_CHAIR_SWEB_ACCOUNT

Indicator identifying whether school chair sweb account (Y/N).

VARCHAR2

1

LAB_ALLOCATION

Lab allocation as provided by the source.

VARCHAR2

30

LAB_ALLOCATION_KEY

Surrogate key identifying the lab allocation.

VARCHAR2

6

MAIL_CODE

Code identifying mail.

VARCHAR2

1

OH_ADJUSTMENT

Oh adjustment as provided by the source.

VARCHAR2

30

OH_ADJUSTMENT_KEY

Surrogate key identifying the oh adjustment.

VARCHAR2

6

ON_OFF_CAMPUS_STATUS

On off campus status as provided by the source.

VARCHAR2

10

ORGANIZATION_ID

Business identifier for the organization.

VARCHAR2

6

ORGANIZATION_NAME

Organization name as provided by the source.

VARCHAR2

40

OVERRUN_AMOUNT

Overrun amount as provided by the source.

NUMBER

13,2

OVERRUN_FLAG

Overrun flag as provided by the source.

VARCHAR2

1

OVERRUN_WITH_COMMIT_AMOUNT

Overrun with commit amount as provided by the source.

NUMBER

13,2

OVERRUN_WITH_COMMIT_FLAG

Overrun with commit flag as provided by the source.

VARCHAR2

1

POOL_CODE

Code identifying pool.

VARCHAR2

1

POOL_UNITS

Pool units as provided by the source.

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 as provided by the source.

VARCHAR2

40

RELEASE_STRATEGY

Release strategy as provided by the source.

VARCHAR2

100

SCHOOL_AREA

School area as provided by the source.

VARCHAR2

70

SECTION_CODE

Code identifying section.

VARCHAR2

3

SECTION_NAME

Section name as provided by the source.

VARCHAR2

60

SUPERVISOR

Supervisor as provided by the source.

VARCHAR2

30

SUPERVISOR_ROOM

Supervisor room as provided by the source.

VARCHAR2

10

SUPERVISR_MIT_ID

Business identifier for the supervisr mit.

VARCHAR2

9

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 description.

VARCHAR2

40

TREASURER_REPORT

Treasurer report as provided by the source.

VARCHAR2

3

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE