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