HR CHILDCARE CENTER SCHLRSHP Table
View exposing childcare center scholarship application and award data including award dates, funding type, MIT affiliation, status, parent information, and related scholarship attributes used for benefit administration and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR |
Column ACADEMIC_YEAR. |
VARCHAR2 |
4 |
AWARD_STATUS |
Column AWARD_STATUS. |
VARCHAR2 |
12 |
CHANGE_REASON_CODE |
Column CHANGE_REASON_CODE. |
VARCHAR2 |
1 |
CHANGE_REASON_DESC |
Column CHANGE_REASON_DESC. |
VARCHAR2 |
49 |
CHILD_BIRTH_DATE_1 |
Column CHILD_BIRTH_DATE_1. |
DATE |
|
CHILD_BIRTH_DATE_2 |
Column CHILD_BIRTH_DATE_2. |
DATE |
|
CHILD_BIRTH_DATE_3 |
Column CHILD_BIRTH_DATE_3. |
DATE |
|
CHILD_BIRTH_DATE_4 |
Column CHILD_BIRTH_DATE_4. |
DATE |
|
CHILD_CLASSROOM_1 |
Column CHILD_CLASSROOM_1. |
VARCHAR2 |
9 |
CHILD_CLASSROOM_2 |
Column CHILD_CLASSROOM_2. |
VARCHAR2 |
9 |
CHILD_CLASSROOM_3 |
Column CHILD_CLASSROOM_3. |
VARCHAR2 |
9 |
CHILD_CLASSROOM_4 |
Column CHILD_CLASSROOM_4. |
VARCHAR2 |
9 |
CHILD_DAYS_1 |
Column CHILD_DAYS_1. |
VARCHAR2 |
1 |
CHILD_DAYS_2 |
Column CHILD_DAYS_2. |
VARCHAR2 |
1 |
CHILD_DAYS_3 |
Column CHILD_DAYS_3. |
VARCHAR2 |
1 |
CHILD_DAYS_4 |
Column CHILD_DAYS_4. |
VARCHAR2 |
1 |
CHILD_FIRST_NAME_1 |
Column CHILD_FIRST_NAME_1. |
VARCHAR2 |
30 |
CHILD_FIRST_NAME_2 |
Column CHILD_FIRST_NAME_2. |
VARCHAR2 |
30 |
CHILD_FIRST_NAME_3 |
Column CHILD_FIRST_NAME_3. |
VARCHAR2 |
30 |
CHILD_FIRST_NAME_4 |
Column CHILD_FIRST_NAME_4. |
VARCHAR2 |
30 |
CHILD_HOURS_1 |
Column CHILD_HOURS_1. |
VARCHAR2 |
4 |
CHILD_HOURS_2 |
Column CHILD_HOURS_2. |
VARCHAR2 |
4 |
CHILD_HOURS_3 |
Column CHILD_HOURS_3. |
VARCHAR2 |
4 |
CHILD_HOURS_4 |
Column CHILD_HOURS_4. |
VARCHAR2 |
4 |
CHILD_LAST_NAME_1 |
Column CHILD_LAST_NAME_1. |
VARCHAR2 |
40 |
CHILD_LAST_NAME_2 |
Column CHILD_LAST_NAME_2. |
VARCHAR2 |
40 |
CHILD_LAST_NAME_3 |
Column CHILD_LAST_NAME_3. |
VARCHAR2 |
40 |
CHILD_LAST_NAME_4 |
Column CHILD_LAST_NAME_4. |
VARCHAR2 |
40 |
CHILD_MONTHLY_AWARD_AMT_1 |
Column CHILD_MONTHLY_AWARD_AMT_1. |
NUMBER |
7,2 |
CHILD_MONTHLY_AWARD_AMT_2 |
Column CHILD_MONTHLY_AWARD_AMT_2. |
NUMBER |
7,2 |
CHILD_MONTHLY_AWARD_AMT_3 |
Column CHILD_MONTHLY_AWARD_AMT_3. |
NUMBER |
7,2 |
CHILD_MONTHLY_AWARD_AMT_4 |
Column CHILD_MONTHLY_AWARD_AMT_4. |
NUMBER |
7,2 |
CHILD_MONTHLY_CALC_AMT_1 |
Column CHILD_MONTHLY_CALC_AMT_1. |
NUMBER |
7,2 |
CHILD_MONTHLY_CALC_AMT_2 |
Column CHILD_MONTHLY_CALC_AMT_2. |
NUMBER |
7,2 |
CHILD_MONTHLY_CALC_AMT_3 |
Column CHILD_MONTHLY_CALC_AMT_3. |
NUMBER |
7,2 |
CHILD_MONTHLY_CALC_AMT_4 |
Column CHILD_MONTHLY_CALC_AMT_4. |
NUMBER |
7,2 |
CHILD_MONTHLY_CONTRIBUTION_1 |
Column CHILD_MONTHLY_CONTRIBUTION_1. |
NUMBER |
7,2 |
CHILD_MONTHLY_CONTRIBUTION_2 |
Column CHILD_MONTHLY_CONTRIBUTION_2. |
NUMBER |
7,2 |
CHILD_MONTHLY_CONTRIBUTION_3 |
Column CHILD_MONTHLY_CONTRIBUTION_3. |
NUMBER |
7,2 |
CHILD_MONTHLY_CONTRIBUTION_4 |
Column CHILD_MONTHLY_CONTRIBUTION_4. |
NUMBER |
7,2 |
CHILD_MONTHLY_TUITION_1 |
Column CHILD_MONTHLY_TUITION_1. |
NUMBER |
7,2 |
CHILD_MONTHLY_TUITION_2 |
Column CHILD_MONTHLY_TUITION_2. |
NUMBER |
7,2 |
CHILD_MONTHLY_TUITION_3 |
Column CHILD_MONTHLY_TUITION_3. |
NUMBER |
7,2 |
CHILD_MONTHLY_TUITION_4 |
Column CHILD_MONTHLY_TUITION_4. |
NUMBER |
7,2 |
CHILD_TCC_1 |
Column CHILD_TCC_1. |
VARCHAR2 |
8 |
CHILD_TCC_2 |
Column CHILD_TCC_2. |
VARCHAR2 |
8 |
CHILD_TCC_3 |
Column CHILD_TCC_3. |
VARCHAR2 |
8 |
CHILD_TCC_4 |
Column CHILD_TCC_4. |
VARCHAR2 |
8 |
DENIAL_REASON_CODE |
Column DENIAL_REASON_CODE. |
VARCHAR2 |
1 |
DENIAL_REASON_DESC |
Column DENIAL_REASON_DESC. |
VARCHAR2 |
81 |
DISABLE_DOC_ATTACHED |
Column DISABLE_DOC_ATTACHED. |
VARCHAR2 |
1 |
EMPLOYEE_FUND_PERCENT |
Column EMPLOYEE_FUND_PERCENT. |
NUMBER |
6,2 |
EMP_AMOUNT_01 |
Column EMP_AMOUNT_01. |
NUMBER |
7,2 |
EMP_AMOUNT_02 |
Column EMP_AMOUNT_02. |
NUMBER |
7,2 |
EMP_AMOUNT_03 |
Column EMP_AMOUNT_03. |
NUMBER |
7,2 |
EMP_AMOUNT_04 |
Column EMP_AMOUNT_04. |
NUMBER |
7,2 |
EMP_AMOUNT_05 |
Column EMP_AMOUNT_05. |
NUMBER |
7,2 |
EMP_AMOUNT_06 |
Column EMP_AMOUNT_06. |
NUMBER |
7,2 |
EMP_AMOUNT_07 |
Column EMP_AMOUNT_07. |
NUMBER |
7,2 |
EMP_AMOUNT_08 |
Column EMP_AMOUNT_08. |
NUMBER |
7,2 |
EMP_AMOUNT_09 |
Column EMP_AMOUNT_09. |
NUMBER |
7,2 |
EMP_AMOUNT_10 |
Column EMP_AMOUNT_10. |
NUMBER |
7,2 |
EMP_AMOUNT_11 |
Column EMP_AMOUNT_11. |
NUMBER |
7,2 |
EMP_AMOUNT_12 |
Column EMP_AMOUNT_12. |
NUMBER |
7,2 |
END_AWARD_REASON_CODE |
Column END_AWARD_REASON_CODE. |
VARCHAR2 |
1 |
END_AWARD_REASON_DESC |
Column END_AWARD_REASON_DESC. |
VARCHAR2 |
126 |
END_DATE |
Column END_DATE. |
DATE |
|
FELLOWSHIP_FUND_PERCENT |
Column FELLOWSHIP_FUND_PERCENT. |
NUMBER |
6,2 |
FELLOW_AMOUNT_01 |
Column FELLOW_AMOUNT_01. |
NUMBER |
7,2 |
FELLOW_AMOUNT_02 |
Column FELLOW_AMOUNT_02. |
NUMBER |
7,2 |
FELLOW_AMOUNT_03 |
Column FELLOW_AMOUNT_03. |
NUMBER |
7,2 |
FELLOW_AMOUNT_04 |
Column FELLOW_AMOUNT_04. |
NUMBER |
7,2 |
FELLOW_AMOUNT_05 |
Column FELLOW_AMOUNT_05. |
NUMBER |
7,2 |
FELLOW_AMOUNT_06 |
Column FELLOW_AMOUNT_06. |
NUMBER |
7,2 |
FELLOW_AMOUNT_07 |
Column FELLOW_AMOUNT_07. |
NUMBER |
7,2 |
FELLOW_AMOUNT_08 |
Column FELLOW_AMOUNT_08. |
NUMBER |
7,2 |
FELLOW_AMOUNT_09 |
Column FELLOW_AMOUNT_09. |
NUMBER |
7,2 |
FELLOW_AMOUNT_10 |
Column FELLOW_AMOUNT_10. |
NUMBER |
7,2 |
FELLOW_AMOUNT_11 |
Column FELLOW_AMOUNT_11. |
NUMBER |
7,2 |
FELLOW_AMOUNT_12 |
Column FELLOW_AMOUNT_12. |
NUMBER |
7,2 |
FUNDING_TYPE |
Column FUNDING_TYPE. |
VARCHAR2 |
8 |
MARITAL_STATUS_CODE |
Column MARITAL_STATUS_CODE. |
VARCHAR2 |
1 |
MARITAL_STATUS_DESC |
Column MARITAL_STATUS_DESC. |
VARCHAR2 |
25 |
MAX_AWARD_1 |
Column MAX_AWARD_1. |
NUMBER |
7,2 |
MAX_AWARD_2 |
Column MAX_AWARD_2. |
NUMBER |
7,2 |
MAX_AWARD_3 |
Column MAX_AWARD_3. |
NUMBER |
7,2 |
MAX_AWARD_4 |
Column MAX_AWARD_4. |
NUMBER |
7,2 |
MIT_AFFILIATION_CODE |
Column MIT_AFFILIATION_CODE. |
VARCHAR2 |
1 |
MIT_AFFILIATION_DESC |
Column MIT_AFFILIATION_DESC. |
VARCHAR2 |
22 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OTHER_DOC_ATTACHED |
Column OTHER_DOC_ATTACHED. |
VARCHAR2 |
1 |
OTHER_TEXT |
Column OTHER_TEXT. |
VARCHAR2 |
255 |
PARENT1_ADDITIONAL_INCOME |
Column PARENT1_ADDITIONAL_INCOME. |
NUMBER |
15,2 |
PARENT1_EMP_EFT |
Column PARENT1_EMP_EFT. |
VARCHAR2 |
6 |
PARENT1_EMP_GROSS |
Column PARENT1_EMP_GROSS. |
NUMBER |
13,2 |
PARENT1_FELLOWSHIP_EFT |
Column PARENT1_FELLOWSHIP_EFT. |
VARCHAR2 |
6 |
PARENT1_FELLOWSHIP_GROSS |
Column PARENT1_FELLOWSHIP_GROSS. |
NUMBER |
13,2 |
PARENT1_SALARY |
Column PARENT1_SALARY. |
NUMBER |
15,2 |
PARENT2_ADDITIONAL_INCOME |
Column PARENT2_ADDITIONAL_INCOME. |
NUMBER |
15,2 |
PARENT2_AFFILIATION_CODE |
Column PARENT2_AFFILIATION_CODE. |
VARCHAR2 |
1 |
PARENT2_AFFILIATION_DESC |
Column PARENT2_AFFILIATION_DESC. |
VARCHAR2 |
22 |
PARENT2_EMAIL |
Column PARENT2_EMAIL. |
VARCHAR2 |
40 |
PARENT2_EMPLOYER_NAME |
Column PARENT2_EMPLOYER_NAME. |
VARCHAR2 |
35 |
PARENT2_EMP_APPT_END_DATE |
Column PARENT2_EMP_APPT_END_DATE. |
DATE |
|
PARENT2_EMP_HIRE_DATE |
Column PARENT2_EMP_HIRE_DATE. |
DATE |
|
PARENT2_EMP_PAY_FREQ |
Column PARENT2_EMP_PAY_FREQ. |
VARCHAR2 |
1 |
PARENT2_MITID |
Column PARENT2_MITID. |
VARCHAR2 |
9 |
PARENT2_NAME_FIRST |
Column PARENT2_NAME_FIRST. |
VARCHAR2 |
40 |
PARENT2_NAME_LAST |
Column PARENT2_NAME_LAST. |
VARCHAR2 |
40 |
PARENT2_NAME_MIDDLE |
Column PARENT2_NAME_MIDDLE. |
VARCHAR2 |
1 |
PARENT2_PAY_FREQ_TEXT |
Column PARENT2_PAY_FREQ_TEXT. |
VARCHAR2 |
80 |
PARENT2_PHONE |
Column PARENT2_PHONE. |
VARCHAR2 |
20 |
PARENT2_SALARY |
Column PARENT2_SALARY. |
NUMBER |
15,2 |
PARENT2_SCHL_ADMISSION_DATE |
Column PARENT2_SCHL_ADMISSION_DATE. |
DATE |
|
PARENT2_SCHOOL_NAME |
Column PARENT2_SCHOOL_NAME. |
VARCHAR2 |
60 |
PARENT2_SCH_FUNDING_TYPE_CODE |
Column PARENT2_SCH_FUNDING_TYPE_CODE. |
VARCHAR2 |
1 |
PARENT2_SCH_FUNDING_TYPE_DESC |
Column PARENT2_SCH_FUNDING_TYPE_DESC. |
VARCHAR2 |
18 |
PARENT2_SCH_GRADUATION_DATE |
Column PARENT2_SCH_GRADUATION_DATE. |
DATE |
|
PARENT2_STATUS_CODE |
Column PARENT2_STATUS_CODE. |
VARCHAR2 |
1 |
PARENT2_STATUS_DESC |
Column PARENT2_STATUS_DESC. |
VARCHAR2 |
39 |
PARENT2_WITH_MIT |
Column PARENT2_WITH_MIT. |
VARCHAR2 |
1 |
PARTIAL_01 |
Column PARTIAL_01. |
VARCHAR2 |
1 |
PARTIAL_02 |
Column PARTIAL_02. |
VARCHAR2 |
1 |
PARTIAL_03 |
Column PARTIAL_03. |
VARCHAR2 |
1 |
PARTIAL_04 |
Column PARTIAL_04. |
VARCHAR2 |
1 |
PARTIAL_05 |
Column PARTIAL_05. |
VARCHAR2 |
1 |
PARTIAL_06 |
Column PARTIAL_06. |
VARCHAR2 |
1 |
PARTIAL_07 |
Column PARTIAL_07. |
VARCHAR2 |
1 |
PARTIAL_08 |
Column PARTIAL_08. |
VARCHAR2 |
1 |
PARTIAL_09 |
Column PARTIAL_09. |
VARCHAR2 |
1 |
PARTIAL_10 |
Column PARTIAL_10. |
VARCHAR2 |
1 |
PARTIAL_11 |
Column PARTIAL_11. |
VARCHAR2 |
1 |
PARTIAL_12 |
Column PARTIAL_12. |
VARCHAR2 |
1 |
PERSONNEL_KEY |
Column PERSONNEL_KEY. |
VARCHAR2 |
8 |
PREFERRED_EMAIL |
Column PREFERRED_EMAIL. |
VARCHAR2 |
40 |
PREFERRED_PERSON_CODE |
Column PREFERRED_PERSON_CODE. |
VARCHAR2 |
1 |
PREFERRED_PERSON_DESC |
Column PREFERRED_PERSON_DESC. |
VARCHAR2 |
9 |
PREFERRED_PHONE |
Column PREFERRED_PHONE. |
VARCHAR2 |
20 |
START_DATE |
Column START_DATE. |
DATE |
|
SUBMITTED_BY |
Column SUBMITTED_BY. |
VARCHAR2 |
12 |
SUBMITTED_DATE |
Column SUBMITTED_DATE. |
DATE |
|
SUBMITTED_TIME |
Column SUBMITTED_TIME. |
VARCHAR2 |
6 |
TCC_START_DATE |
Column TCC_START_DATE. |
DATE |
|
TOTAL_INCOME |
Column TOTAL_INCOME. |
NUMBER |
15,2 |
UPDATE_DATE |
Column UPDATE_DATE. |
DATE |
|
UPDATE_USER |
Column UPDATE_USER. |
VARCHAR2 |
12 |