This field set was included with State Reporting Installer 17.8.0 released on September 1, 2017.
|
Source Table (Virtual Table) |
Source Field |
Destination Table (Extended Schema) |
Destination Field |
|---|---|---|---|
|
ID_StaffAssignments |
foreignKey |
S_ID_USR_StaffAssignments_C |
foreignKey |
|
ID_StaffAssignments |
unique_id |
S_ID_USR_StaffAssignments_C |
unique_id |
|
ID_StaffAssignments |
foreignKey_alpha |
S_ID_USR_StaffAssignments_C |
foreignKey_alpha |
|
ID_StaffAssignments |
schoolID |
S_ID_USR_StaffAssignments_C |
schoolID |
|
ID_StaffAssignments |
user_defined_text |
S_ID_USR_StaffAssignments_C |
AssignmentCode |
|
ID_StaffAssignments |
user_defined_integer |
S_ID_USR_StaffAssignments_C |
PeriodNumber |
|
ID_StaffAssignments |
user_defined_date |
S_ID_USR_StaffAssignments_C |
EffectiveDate |
|
ID_StaffAssignments |
user_defined_date2 |
S_ID_USR_StaffAssignments_C |
EndDate |
|
ID_StaffAssignments |
FTE |
S_ID_USR_StaffAssignments_C |
FTE |
|
ID_StaffAssignments |
ID_ClassLevel |
S_ID_USR_StaffAssignments_C |
ClassLevel |
|
ID_StaffAssignments |
ID_ContractNo |
S_ID_USR_StaffAssignments_C |
ContractNo |
|
ID_StaffAssignments |
ID_CourseStandards |
S_ID_USR_StaffAssignments_C |
CourseStandards |
|
ID_StaffAssignments |
ID_CRDCFteFactor |
S_ID_USR_StaffAssignments_C |
CRDCFteFactor |
|
ID_StaffAssignments |
ID_GradeLevel |
S_ID_USR_StaffAssignments_C |
GradeLevel |
|
ID_StaffAssignments |
ID_HQDate |
S_ID_USR_StaffAssignments_C |
HQDate |
|
ID_StaffAssignments |
ID_HQT |
S_ID_USR_StaffAssignments_C |
HQT |
|
ID_StaffAssignments |
ID_InstructionalSetting |
S_ID_USR_StaffAssignments_C |
InstructionalSetting |
|
ID_StaffAssignments |
ID_NoncertRate |
S_ID_USR_StaffAssignments_C |
NoncertRate |
|
ID_StaffAssignments |
ID_NoncertHours |
S_ID_USR_StaffAssignments_C |
NoncertHours |
|
ID_StaffAssignments |
ID_NoncertWeeks |
S_ID_USR_StaffAssignments_C |
NoncertWeeks |
|
ID_StaffAssignments |
ID_QualOverride |
S_ID_USR_StaffAssignments_C |
QualOverride |
|
ID_StaffAssignments |
ID_TeachingRole |
S_ID_USR_StaffAssignments_C |
TeachingRole |