Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR CSP SETTINGS Table


Stores configuration settings for the HR Childcare Scholarship Program (CSP), including setting codes, descriptions, and values used by CSP processing and reporting. Each row represents a single CSP configuration setting.


Field Name

Description

Data Type

Length

SETTING_CODE

Code identifying the CSP setting.

VARCHAR2

20

SETTING_DESC

Description of the CSP setting and its intended purpose.

VARCHAR2

50

SETTING_VALUE

Value of the CSP setting (as defined by source), used to control CSP processing or reporting behavior.

VARCHAR2

200

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE