StateExtract_LayoutElements, 127 (ver3.6.1)
Data Elements in a Layout record and information for each one, such as format, required by the state.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DataElement_FixedLength_Format | 3.6.1 | Varchar(9) | Format of the data element in the extract record. |
DataElement_FixedLength_Length | 3.6.1 | Number(10,0) | Length of the data element in the extract record. |
DataElement_Name | 3.6.1 | Varchar(79) | Name of data element/field as indicated by the state. |
DataElement_PositionNumber | 3.6.1 | Number(10,0) | Position the data element occurs in the extract record. Records with position number 999 are used as extract generation triggers for N(ew), E(dit) and D(elete) events but are not themselves. |
DataElement_TrackEventFlag | 3.6.1 | Number(10,0) | Indicates whether to restrict to fields in the extract layouts we are actually tracking delete for. |
DataElement_ValueCalculateFlag | 3.6.1 | Number(10,0) | Indicates whether the data element value require a calculation. |
DataElement_ValueConvertFlag | 3.6.1 | Number(10,0) | Indicates whether a value conversion required. |
DataElement_ValueLogicTestFlag | 3.6.1 | Number(10,0) | Indicates whether the data element value determined by a logic test; based on certain rules. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Extract_LayoutRecordID | 3.6.1 | Varchar(9) | Identifies the type of this record: 030=Class Section, 031=Class Section Schedule, 045=Transportation, etc. Indexed. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. |
PowerSchool_FullFieldName | 3.6.1 | Varchar(79) | Table and fieldname of PowerSchool field that contains the required information. Indexed. |
Unused | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |