tbl1_ImportedDataReformatted_ff¶
- Description
temp table used by used by form fit program for reformatted data in the summer salary function
- Footnote
nobody is using this program now, so debatable whether to maintain this
Columns¶
id int(11) NOT NULL AUTO_INCREMENT
- Options
display="true", null="true", search="false", type=""
faculty_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
source tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
code tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
salary tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
salary_june tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
salary_july_and_august tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
supp tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
days tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
sal tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
comments tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
employee_number tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
total tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
notes tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
source1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
source2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
source3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
source4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
source5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
amount1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
amount2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
amount3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
amount4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
amount5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
comments1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
comments2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
comments3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
comments4 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
comments5 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""