S_IL_STU_EarlyChildPrg_C(ver SR_20.8.2.0)
| Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 20.8.2.0 | Number(19,0) | Primary Key |
| SchoolsDCID | 20.8.2.0 | Number(19,0) | Foreign Key that relates the extended table back to the Schools table. |
| IEIN | 20.8.2.0 | Varchar2(12) | |
| Program | 20.8.2.0 | Varchar2(2) | To collect an Early childhood program |
| Program_End_Date | 20.8.2.0 | Date | Program end date |
| Program_Start_Date | 20.8.2.0 | Date | Program start date |
| Provider_Type | 20.8.2.0 | Varchar2(3) | Provider Type |
| Provider_End_Date | 20.8.2.0 | Date | Provider End Date |
| Provider_Start_Date | 20.8.2.0 | Date | Provider Start Date |
| Service_Location | 20.8.2.0 | Varchar2(2) | Service location |
| Service_Type | 20.8.2.0 | Varchar2(2) | Service Type |
| Reason_Ending_Program | 20.8.2.0 | Varchar2(2) | Reason for Ending Program |
| Reason_Ending_Provider | 20.8.2.0 | Varchar2(2) | Reason for Ending Provider |
| GatewaysRegistryMemberId | 20.8.2.0 | Varchar2(10) | Gateways Registry Member Id |
| HasGatewaysCredential | 20.8.2.0 | Boolean | Has Gateways Credential |