S_ON_STU_EarlyYears_C ver 17.10.1
This table is Standalone table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.10.1 | NUMBER(11,0) | Primary key |
StudentsDCID | 17.10.1 | NUMBER(10,0) | Primary key that relates the extended table to the [Students] table |
| AgeOfChildCode | 17.10.1 | VarChar2(3 Char) | Code for Child Age Range 010 - 0 up to 12 Months (>0 to <12 months) 020 - 12 Months to 18 Months (>=12 months to < 18 months) 030 - 18 Months to 24 Months (>= 18 months to <24 months) 040 - 24 Months to 2.5 Years (>=24 months to <2.5 years) 050 - 2.5 Years up to Present (>=2.5 years to present) |
| CCC_HCCA_Name | 17.10.1 | VarChar2(120 Char) | Licensed Child Care Facility Name |
| City | 17.10.1 | VarChar2(50 Char) | City where Child Care Center resides |
| DoNotAnswerCare | 17.10.1 | NUMBER(1,0) | Refusal to answer Care Center info Valid values (1,0) |
| EarlyChildCareFrequency | 17.10.1 | VarChar2(3 Char) | How often the Child obtained care - Question 5 001 - Once or More Per Week 002 - One to Three Times a Month 003 - Several Times a Year 004 - Once Per Year 005 - Did Not Participate 099 - Prefer not to answer |
| EarlyOtherActivitiesFreq | 17.10.1 | VarChar2(3 Char) | How often the child participate in other activities - Question 6 Same codes as above |
| LicensedCareID | 17.10.1 | NUMBER(11,0) | Licensed Care Identification [S_ON_EYE_CareCenter_S]ID Obsolete starting 18.6.0 |
| LicensedCareNA | 17.10.1 | NUMBER(1,0) | Licensed Care Not Applicable Valid Values (1,0) |
| LicensedChildCareCode | 17.10.1 | VarChar2(3 Char) | Licensed Child Care Code - 005 |
| LicensedChildCareFT | 17.10.1 | NUMBER(1,0) | Licensed Child Care Full Time Valid Values (1,0) |
| LicensedChildCarePT | 17.10.1 | NUMBER(1,0) | Licensed Child Care Part Time Valid Values (1,0) |
| LicensedHomeCareCode | 17.10.1 | VarChar2(3 Char) | Licensed Home Care Code - 004 |
| LicensedHomeCareFT | 17.10.1 | NUMBER(1,0) | Licensed Home Care Full Time Valid Values (1,0) |
| LicensedHomeCarePT | 17.10.1 | NUMBER(1,0) | Licensed Home Care Part Time Valid Values (1,0) |
| PaidCareCode | 17.10.1 | VarChar2(3 Char) | Paid Care Code - 003 |
| PaidCareFT | 17.10.1 | NUMBER(1,0) | Paid Care Full Time Valid Values (1,0) |
| PaidCarePT | 17.10.1 | NUMBER(1,0) | Paid Care Part Time Valid Values (1,0) |
| ParentGuardianCareCode | 17.10.1 | VARCHAR2(3 Char) | Parent Guardian Care Code - 001 |
| ParentGuardianCareFT | 17.10.1 | NUMBER(1,0) | Parent Guardian Care Full Time Valid Values (1,0) |
| ParentGuardianCarePT | 17.10.1 | NUMBER(1,0) | Parent Guardian Care Part Time Valid Values (1,0) |
| StreetName | 17.10.1 | VarChar2(75 Char) | Street Name of Care Location |
| UnpaidCareCode | 17.10.1 | VarChar2(3 Char) | Unpaid Care Code - 002 |
| UnpaidCareFT | 17.10.1 | NUMBER(1,0) | Unpaid Care Full Time Valid Values (1,0) |
| UnpaidCarePT | 17.10.1 | NUMBER(1,0) | Unpaid Care Part Time Valid Values (1,0) |
| WhoCreated | 17.10.1 | VarChar2(100 Char) | Who created the record |
| WhenCreated | 17.10.1 | TIMESTAMP(6) | When record was created |
| WhoModified | 17.10.1 | VarChar2(100 Char) | Who modified the record |
| WhenModified | 17.10.1 | TIMESTAMP(6) | When was the record modified |
| LicenseNumber | 18.6.0 | VarChar2(10 Char) | Licensed Care Identification [S_ON_EYE_CareCenter_S]licenseNumber |