Field Set: State ID Virtual ID_ProgramContacts
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_ProgramContacts | foreignKey | S_ID_USR_ProgramContacts_C | foreignKey |
| ID_ProgramContacts | unique_id | S_ID_USR_ProgramContacts_C | unique_id |
| ID_ProgramContacts | foreignKey_alpha | S_ID_USR_ProgramContacts_C | foreignKey_alpha |
| ID_ProgramContacts | schoolID | S_ID_USR_ProgramContacts_C | schoolID |
| ID_ProgramContacts | user_defined_integer | S_ID_USR_ProgramContacts_C | Location |
| ID_ProgramContacts | user_defined_text | S_ID_USR_ProgramContacts_C | JobTitle |
| ID_ProgramContacts | user_defined_text2 | S_ID_USR_ProgramContacts_C | RoleTitle |
| ID_ProgramContacts | user_defined_date | S_ID_USR_ProgramContacts_C | StartDate |
| ID_ProgramContacts | user_defined_date2 | S_ID_USR_ProgramContacts_C | EndDate |
| ID_ProgramContacts | ID_RoleCode | S_ID_USR_ProgramContacts_C | RoleCode |
| ID_ProgramContacts | teacherID | S_ID_USR_ProgramContacts_C | teacherID |