StateExtract_CodeConversion, 128 (ver3.6.1)
Designed to keep the conversion codes between PowerSchool and State required. Not currently being used.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DataElement_Name | 3.6.1 | Varchar(79) | Name of data element that needs to be converted - see StateExtract_LayoutElement. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Extract_LayoutName_ID | 3.6.1 | Varchar(79) | Identifies the type of this record: 030=Class Section, 031=Class Section Schedule, 045=Transportation, etc. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
PowerSchool_Code | 3.6.1 | Varchar(9) | Code used by district in PowerSchool to be converted. |
StateApproved_Code | 3.6.1 | Varchar(9) | Code the state requires instead of the PowerSchool_Code. |