Field Set: State NM Virtual ProgramFact
This field set was included with State Reporting Installer 17.6.0 released on June 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
ProgramFact | unique_ID | S_NM_STU_ProgramFact_C | unique_ID |
ProgramFact | schoolID | S_NM_STU_ProgramFact_C | schoolID |
ProgramFact | foreignKey | S_NM_STU_ProgramFact_C | foreignKey |
ProgramFact | foreignKey_alpha | S_NM_STU_ProgramFact_C | foreignKey_alpha |
ProgramFact | user_defined_date | S_NM_STU_ProgramFact_C | PgmStartDate |
ProgramFact | user_defined_date2 | S_NM_STU_ProgramFact_C | BeginningDate |
ProgramFact | user_defined_text2 | S_NM_STU_ProgramFact_C | EndingDate |
ProgramFact | user_defined_text | S_NM_STU_ProgramFact_C | ParticipationInfoCode |
ProgramFact | NM_ProgramCode | S_NM_STU_ProgramFact_C | ProgramCode |
ProgramFact | NM_ProgramComment | S_NM_STU_ProgramFact_C | ProgramComment |