State Of Oklahoma Payroll - 2015
State of Oklahoma
@usgov.state_of_oklahoma_state_of_oklahoma_payroll_2015
State of Oklahoma
@usgov.state_of_oklahoma_state_of_oklahoma_payroll_2015
CREATE TABLE data_state_of_oklahoma_payroll_calendar_year_2015 (
"report_date" VARCHAR,
"agency_number" BIGINT,
"agency_name" VARCHAR,
"last_name" VARCHAR,
"first_name" VARCHAR,
"middle_initial" VARCHAR,
"hours" DOUBLE,
"amount" DOUBLE,
"check_date" VARCHAR,
"account" BIGINT,
"account_description" VARCHAR,
"update_date" VARCHAR
);
CREATE TABLE data_state_of_oklahoma_payroll_q1_2015 (
"report_date" VARCHAR,
"agency_number" BIGINT,
"agency_name" VARCHAR,
"last_name" VARCHAR,
"first_name" VARCHAR,
"middle_initial" VARCHAR,
"hours" DOUBLE,
"amount" DOUBLE,
"check_date" VARCHAR,
"account" BIGINT,
"account_description" VARCHAR,
"update_date" VARCHAR
);
CREATE TABLE data_state_of_oklahoma_payroll_q2_2015 (
"report_date" VARCHAR,
"agency_number" BIGINT,
"agency_name" VARCHAR,
"last_name" VARCHAR,
"first_name" VARCHAR,
"middle_initial" VARCHAR,
"hours" DOUBLE,
"amount" DOUBLE,
"check_date" VARCHAR,
"account" BIGINT,
"account_description" VARCHAR,
"update_date" VARCHAR
);
CREATE TABLE data_state_of_oklahoma_payroll_q3_2015 (
"report_date" VARCHAR,
"agency_number" BIGINT,
"agency_name" VARCHAR,
"last_name" VARCHAR,
"middle_initial" VARCHAR,
"middle_initial_1" VARCHAR,
"hours" DOUBLE,
"amount" DOUBLE,
"check_date" VARCHAR,
"account" BIGINT,
"account_description" VARCHAR,
"update_date" VARCHAR
);
CREATE TABLE data_state_of_oklahoma_payroll_q4_2015 (
"report_date" VARCHAR,
"agency_number" BIGINT,
"agency_name" VARCHAR,
"last_name" VARCHAR,
"first_initial" VARCHAR,
"middle_initial" VARCHAR,
"hours" DOUBLE,
"amount" DOUBLE,
"check_date" VARCHAR,
"account" BIGINT,
"account_description" VARCHAR,
"update_date" VARCHAR
);
Anyone who has the link will be able to view this.