/* Check to make sure we are connected to the database before allowing access to the home page. If not connected, go connect and initialize; otherwise, welcome the user.\ */ if(!database.connected()) redirect("init.htm"); project.lock(); employee_cursor = database.cursor("select * from employee where ssn = " + request.ssn + "", true); employee_cursor.next(); project.unlock(); project.lock(); dependent_cursor = database.cursor("select * from dependent where employee_ssn = " + request.ssn + "", true); project.unlock(); project.lock(); primary_coverage_cursor = database.cursor("select * from primary_coverage where employee_ssn = " + request.ssn + "", true); primary_coverage_cursor.next(); project.unlock(); project.lock(); secondary_coverage_cursor = database.cursor("select * from secondary_coverage where employee_ssn = " + request.ssn + "", true); secondary_coverage_cursor.next(); project.unlock(); project.lock(); previous_coverage_cursor = database.cursor("select * from previous_coverage where employee_ssn = " + request.ssn + "", true); previous_coverage_cursor.next(); project.unlock(); project.lock(); beneficiary_cursor = database.cursor("select * from beneficiary where employee_ssn = " + request.ssn + "", true); beneficiary_cursor.next(); project.unlock(); Employee Information

General Information
Name:write(employee_cursor.name);
SSN:write(employee_cursor.ssn);
Address:write(employee_cursor.address);
City:write(employee_cursor.city);
State:write(employee_cursor.state);
Zip Code:write(employee_cursor.zip);
Home Phone:write(employee_cursor.hphone);
Work Phone:write(employee_cursor.wphone);
Marital Status:write(employee_cursor.marital);
Gender:write(employee_cursor.gender);
Birthdate:write(employee_cursor.birthdate);
Occupation:write(employee_cursor.occupation);



while (dependent_cursor.next()) { }
Dependent Information
SSN:write(dependent_cursor.ssn);
Name:write(dependent_cursor.name);
Action:write(dependent_cursor.action);
Birthdate:write(dependent_cursor.birthdate);
Relationship:write(dependent_cursor.relationship);
PCP Name:write(dependent_cursor.pcp_name);
PCP Number:write(dependent_cursor.pcp_no);
Previously Seen:write(dependent_cursor.prev_seen);
OB/GYN Name:write(dependent_cursor.obgyn_name);
OB/GYN Number:write(dependent_cursor.obgyn_no);
OB/GYN Previously Seen:write(dependent_cursor.obgyn_prev_seen);
Medicare:write(dependent_cursor.medicare);
Medicare Number:write(dependent_cursor.medicare_no);
Medicaid Number:write(dependent_cursor.medicaid_no);
Handicapped:write(dependent_cursor.handicapped);
Full-Time Student:write(dependent_cursor.full_time_student);
School:write(dependent_cursor.school);
Graduation Date:write(dependent_cursor.grad_date);



Primary Coverage Information
Plan Code:write(primary_coverage_cursor.plan_code);



Secondary Coverage Information
Plan Name:write(secondary_coverage_cursor.plan_name);
Effective Date:write(secondary_coverage_cursor.effective_date);
Participant Name(s):write(secondary_coverage_cursor.participant_name);
Policy Number:write(secondary_coverage_cursor.policy_no);
Group Number:write(secondary_coverage_cursor.group_no);



Previous Coverage Information
Previous Coverage on Current Plan Choice:write(previous_coverage_cursor.prev_cov_thisplan);
Name(s):write(previous_coverage_cursor.names);
Effective Date:write(previous_coverage_cursor.effective_date1);
Employment Status:write(previous_coverage_cursor.employment_status);
Previous Coverage with Company:write(previous_coverage_cursor.prev_cov_withco);
Prior Carrier:write(previous_coverage_cursor.prior_carrier);
Effective Date for Prior Carrier:write(previous_coverage_cursor.effective_date2);



beneficiary_cursor.relationship1 = parseInt(beneficiary_cursor.relationship1,10); rel1cursor = database.cursor("select rel_descp from dep_rel where rel_id = " + beneficiary_cursor.relationship1 + "", true);
Beneficiary Information
Name:write(beneficiary_cursor.name1);
Relationship:write(beneficiary_cursor.relationship1);
Name:write(beneficiary_cursor.name2);
Relationship:write(beneficiary_cursor.relationship2);

Return to Main Menu