StateExtract_Layouts, 126 (ver3.6.1)
The layout format dictated by the states, for the records as a whole. See StateExtract_LayoutElements for each data element in the record.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Extract_LayoutName | 3.6.1 | Varchar(79) | Name of the Layout Extract format. |
Extract_LayoutRecordID | 3.6.1 | Varchar(9) | Identifies the type of this record: 030=Class Section, 031=Class Section Schedule, 045=Transportation, etc. |
Extract_LayoutVersion | 3.6.1 | Varchar(9) | Version of the states layout format. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. |
PowerSchool_MasterTableName | 3.6.1 | Varchar(79) | PowerSchool table that controls/contains the info needed. |