0 0 TCS BASIC 0 localhosttcs_codingtcs_codingtcs_coding1Windows-125212521 1 tcs_users User_Id User_Password user_role_cd 0 1 A0002 User_Id mysql;localhost;tcs_coding;tcs_coding;;tcs_coding;;1 0 C:\xampp\htdocs\tcs2\output db 1 ` ` http://localhost:80/TCS2/output/index.htm 0 1033 style4.css <Default template> English tcs_coding_staging_add.htm tcs_coding_staging_edit.htm tcs_coding_final_list.htm tcs_grantees_list.htm tcs_grantors_list.htm tcs_legals_list.htm tcs_coding_list.htm tcs_coding_staging_list.htm dbaf3aef 6fcb122c 57e45dab f8b30979 c22aafe7 f6aa9e75 383c1216 e3f04941 508f96dd ea78ca06 809a332d f49d7752 8820bac1 be0f8775 cbb386b5 4c24ebf2 LEVEL2 cod_counties cod_departments Scod_doctypes Scod_recordtypes cod_statuses Scod_subdivisions Scod_survey_nos EStcs_assignments AEDStcs_coding AEStcs_coding_final Stcs_coding_staging AEDStcs_grantees AEDStcs_grantors AEDStcs_legals tcs_users tcs_volumes instrument_tab tcs_assignments_vw vol_ins_tab LEVEL1 cod_counties cod_departments Scod_doctypes cod_recordtypes cod_statuses cod_subdivisions cod_survey_nos EStcs_assignments tcs_coding tcs_coding_final AEDStcs_coding_staging tcs_grantees tcs_grantors tcs_legals tcs_users tcs_volumes instrument_tab tcs_assignments_vw vol_ins_tab DIRECTOR AEDSPcod_counties AEDSPcod_departments AEDSPcod_doctypes AEDSPcod_recordtypes AEDSPcod_statuses AEDSPcod_subdivisions AEDSPcod_survey_nos AEDSPtcs_assignments AEDSPtcs_coding AEDSPtcs_coding_final AEDSPtcs_coding_staging AEDSPtcs_grantees AEDSPtcs_grantors AEDSPtcs_legals AEDSPtcs_users AEDSPtcs_volumes AEDSPinstrument_tab tcs_assignments_vw AEDSPvol_ins_tab ADMIN AEScod_counties AEScod_departments AEScod_doctypes AEScod_recordtypes AEScod_statuses AEScod_subdivisions AEScod_survey_nos AEDStcs_assignments AEDStcs_coding AEDStcs_coding_final AEDStcs_coding_staging AEDStcs_grantees AEDStcs_grantors AEDStcs_legals AEStcs_users AEStcs_volumes AEDSinstrument_tab tcs_assignments_vw AEDSvol_ins_tab MANAGER Scod_counties Scod_departments Scod_doctypes Scod_recordtypes Scod_statuses Scod_subdivisions Scod_survey_nos AEStcs_assignments AEDStcs_coding AEDStcs_coding_final AEDStcs_coding_staging AEDStcs_grantees AEDStcs_grantors AEDStcs_legals Stcs_users Stcs_volumes instrument_tab tcs_assignments_vw AESvol_ins_tab 0 0 0 0 0 1 User_Id User_Password email_address email_address admin localhost 25 cod_countiescod_countiescod_counties cod_counties county_cd county_cd 1 1 1 1 1 1 1 1 3 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_counties county_desc county_desc 1 1 1 1 1 1 1 1 4 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_counties county_abbrev county_abbrev 1 1 1 1 1 1 1 1 5 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_counties active_flag active_flag 1 1 1 1 1 1 1 1 6 0 0 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_counties created_by created_by 1 0 1 1 1 1 1 1 1 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_counties create_time create_time 1 0 1 1 1 1 1 1 2 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_counties update_by update_by 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_counties update_time update_time 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 county_cd 1110100 Counties120select `county_cd`, `county_desc`, `county_abbrev`, `active_flag`, `created_by`, `create_time`, `update_by`, `update_time` From `cod_counties`0200111180100 cod_departmentscod_departmentscod_departments cod_departments department_cd department_cd 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_departments department_desc department_desc 1 1 1 1 1 1 1 1 2 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_departments active_flag active_flag 1 1 1 1 1 1 1 1 3 0 0 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_departments created_by created_by 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_departments create_time create_time 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_departments updated_by updated_by 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_departments update_time update_time 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 department_cd 1110100 Departments130select `department_cd`, `department_desc`, `active_flag`, `created_by`, `create_time`, `updated_by`, `update_time` From `cod_departments`0200111180100 cod_doctypescod_doctypescod_doctypes cod_doctypes doctype_cd doctype_cd 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_doctypes doctype_desc doctype_desc 1 1 1 1 1 1 1 1 2 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_doctypes active_flag active_flag 1 1 1 1 1 1 1 1 3 0 0 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_doctypes created_by created_by 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_doctypes create_time create_time 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_doctypes updated_by updated_by 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_doctypes update_time update_time 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 doctype_cd 1110100 Document Types140select `doctype_cd`, `doctype_desc`, `active_flag`, `created_by`, `create_time`, `updated_by`, `update_time` From `cod_doctypes` 0200111180100 cod_recordtypescod_recordtypescod_recordtypes cod_recordtypes recordtype_cd recordtype_cd 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_recordtypes recordtype_desc recordtype_desc 1 1 1 1 1 1 1 1 2 2 2 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_recordtypes active_flag active_flag 1 1 1 1 1 1 1 1 3 3 3 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_recordtypes created_by created_by 1 0 1 1 1 1 1 1 0 4 4 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_recordtypes create_time create_time 1 0 1 1 1 1 1 1 0 5 5 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_recordtypes updated_by updated_by 1 1 1 1 1 1 1 0 0 6 6 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_recordtypes update_time update_time 1 1 1 1 1 1 1 0 0 7 7 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 recordtype_cd 1110100 Record Types160select `recordtype_cd`, `recordtype_desc`, `active_flag`, `created_by`, `create_time`, `updated_by`, `update_time` From `cod_recordtypes`0200111180100 cod_statusescod_statusescod_statuses cod_statuses status_cd status_cd 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_statuses status_desc status_desc 1 1 1 1 1 1 1 1 2 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 50 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_statuses active_flag active_flag 1 1 1 1 1 1 1 1 3 0 0 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_statuses created_by created_by 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_statuses create_time create_time 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_statuses updated_by updated_by 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_statuses update_time update_time 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 status_cd 1110100 Statuses180select `status_cd`, `status_desc`, `active_flag`, `created_by`, `create_time`, `updated_by`, `update_time` From `cod_statuses` 0200111180100 cod_subdivisionscod_subdivisionscod_subdivisions cod_subdivisions county_cd county_cd 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 Lookup wizard 200 0 0 0 0 0 0 0 0 0 1 2000 10 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] 0 0 0 0 0 0 0 0 0 1 cod_counties county_cd county_desc 0 county_desc 0 cod_subdivisions subdivison_cd subdivison_cd 1 1 1 1 1 1 1 1 2 1 2 0 2 2 2 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_subdivisions subdivison_desc subdivison_desc 1 1 1 1 1 1 1 1 3 2 3 0 3 3 3 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_subdivisions active_flag active_flag 1 1 1 1 1 1 1 1 4 3 4 0 4 4 4 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_subdivisions created_by created_by 1 0 1 1 1 1 1 1 5 4 5 0 5 5 5 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_subdivisions create_time create_time 1 0 1 1 1 1 1 1 6 5 6 0 6 6 6 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_subdivisions updated_by updated_by 1 1 1 1 1 1 1 1 7 6 7 0 7 7 7 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_subdivisions update_time update_time 1 1 1 1 1 1 1 1 8 7 8 0 8 8 8 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 county_cd subdivison_cd 1110100 cod_counties 1 county_cd county_cd Subdivisions190select `county_cd`, `subdivison_cd`, `subdivison_desc`, `active_flag`, `created_by`, `create_time`, `updated_by`, `update_time` From `cod_subdivisions`0200111180100 cod_survey_noscod_survey_noscod_survey_nos cod_survey_nos county_cd county_cd 0 1 1 1 1 1 1 1 1 0 1 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] 0 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos Survey_no Survey_no 1 1 1 1 1 1 1 1 2 0 2 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos Survey_desc Survey_desc 1 1 1 1 1 1 1 1 3 0 3 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos active_flag active_flag 1 1 1 1 1 1 1 1 4 0 4 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 1 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos created_by created_by 1 0 1 1 1 1 1 1 0 0 5 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos create_time create_time 1 0 1 1 1 1 1 1 0 0 6 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos updated_by updated_by 1 1 1 1 1 1 1 1 0 0 7 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 cod_survey_nos update_time update_time 1 1 1 1 1 1 1 1 0 0 8 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 county_cd Survey_no 1110100 cod_counties 1 county_cd county_cd Survey_nos1110select `county_cd`, `Survey_no`, `Survey_desc`, `active_flag`, `created_by`, `create_time`, `updated_by`, `update_time` From `cod_survey_nos` 0200111180100 tcs_assignmentstcs_assignmentstcs_assignments tcs_assignments tcs_assignment_key tcs_assignment_key 0 0 1 1 1 1 1 1 13 13 14 14 13 13 13 Text field 3 1 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments county_cd County 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_counties county_cd county_desc 0 0 tcs_assignments volume_no Volume COUNT 1 1 1 1 1 1 1 1 2 2 3 3 2 2 2 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 tcs_volumes volume_no volume_no 0 1 county_cd county_cd tcs_assignments user_id User 1 1 1 1 1 1 1 1 3 3 4 4 3 3 3 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] 0 0 0 0 0 0 0 0 0 1 tcs_users User_Id User_Name 0 user_role_cd 0 tcs_assignments status_cd Status 1 1 1 1 1 1 1 1 4 4 5 5 4 4 4 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_statuses status_cd status_desc 0 0 tcs_assignments assignment_time Assign Time 1 1 1 1 1 1 1 1 5 5 6 6 5 5 5 Readonly Datetime 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() Time 13 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments start_time Start Time 1 1 1 1 1 1 1 1 6 6 7 7 6 6 6 Date Datetime 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 11 1 0 0 0 0 0 0 0 0 0 0 tcs_assignments estimated_complete_time Est Complete Time 1 1 1 1 1 1 1 1 7 7 8 8 7 7 7 Date Datetime 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 11 1 0 0 0 0 0 0 0 0 0 0 tcs_assignments actual_complete_time Actual Complete Time 1 1 1 1 1 1 1 1 8 8 9 9 8 8 8 Date Datetime 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 11 1 0 0 0 0 0 0 0 0 0 0 tcs_assignments estimated_minutes Est Minutes TOTAL 1 1 1 1 1 1 1 1 9 9 10 10 9 9 9 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments actual_minutes Act Minutes TOTAL 1 1 1 1 1 1 1 1 10 10 11 11 10 10 10 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments comments Comments 1 1 1 1 1 1 1 1 11 11 12 12 11 11 11 Text area 201 0 0 0 0 0 0 0 0 0 0 200 0 250 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments active_flag Active 1 1 1 1 1 1 1 1 12 12 13 13 12 12 12 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments created_by created_by 1 0 1 1 1 1 1 1 13 14 15 15 14 14 14 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments create_time create_time 1 0 1 1 1 1 1 1 14 15 16 16 15 15 15 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments update_by update_by 1 1 1 1 1 1 1 1 15 13 17 17 16 16 16 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments update_time update_time 1 1 1 1 1 1 1 1 16 14 18 18 17 17 17 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_assignments volume_no_county_cd Volume County 1 1 1 1 1 1 1 1 0 0 1 1 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 500 0 250 1 0 0 0 0 0 0 0 0 0 0 0 0 0 county_cd volume_no 1111111user_id tcs_users 1 User_Id user_id Assignments1120select `tcs_assignment_key`, `county_cd`, `volume_no`, `user_id`, `status_cd`, `assignment_time`, `start_time`, `estimated_complete_time`, `actual_complete_time`, `estimated_minutes`, `actual_minutes`, `comments`, `active_flag`, `created_by`, `create_time`, `update_by`, `update_time`, `volume_no_county_cd` From `tcs_assignments`0200111180100 EVENT_BEFOREADD function BeforeAdd(&$values) { // Parameters: // $values - Array object. // Each field on the Add form represented as 'Field name'-'Field value' pair //********** Custom code ************ // put your custom code here $values["volume_no_county_cd"]=$values["volume_no"]."-".$values["county_cd"]; return true; // return true if you like to proceed with adding new record // return false in other case } EVENT_BEFOREEDIT function BeforeEdit(&$values, $where) { // Parameters: // $values - Array object. // Each field on the Edit form represented as 'Field name'-'Field value' pair // $where - string with WHERE clause pointing to record to be edited //********** Custom code ************ // put your custom code here $values["volume_no_county_cd"]=$values["volume_no"]."-".$values["county_cd"]; return true; // return true if you like to proceed with editing this record // return false in other case } tcs_codingtcs_codingtcs_coding tcs_coding tcs_coding_key tcs_coding_key 0 0 1 1 1 1 1 1 8 8 8 8 8 8 8 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding tcs_coding_final_key tcs_coding_final_key 1 1 1 1 1 1 1 1 9 9 9 9 9 9 9 Readonly 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding tcs_grantor_key Grantor 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Lookup wizard 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 1 tcs_grantors tcs_grantor_key grantor_name 0 1 tcs_coding_final_key tcs_coding_final_key tcs_coding tcs_legal_key Legal Info 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 Lookup wizard 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 1 tcs_legals tcs_legals_key concat(`recordtype_cd`,'->', `subdivision_cd`, '->',`subdivision_blockno`, '->',`subdivision_lotno`, '->',`acerage`, '->',`survey_no`) 1 1 tcs_coding_final_key tcs_coding_final_key tcs_coding tcs_grantee_key Grantee 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 Lookup wizard 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 1 tcs_grantees tcs_grantee_key grantee_name 0 1 tcs_coding_final_key tcs_coding_final_key tcs_coding create_time create_time 1 0 1 1 1 1 1 1 10 10 10 10 10 10 10 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_coding update_time update_time 1 1 1 1 1 1 1 1 12 12 12 12 12 12 12 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_coding created_by created_by 1 0 1 1 1 1 1 1 11 11 11 11 11 11 11 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding updated_by updated_by 1 1 1 1 1 1 1 1 13 13 13 13 13 13 13 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding comments comments 1 1 1 1 1 1 1 1 6 6 6 6 6 6 6 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding status_cd status_cd 1 1 1 1 1 1 1 1 5 5 5 5 5 5 5 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 "Pending" 0 0 0 0 0 0 0 0 0 1 cod_statuses status_cd status_desc 0 0 tcs_coding active_flag active_flag 1 1 1 1 1 1 1 1 7 7 7 7 7 7 7 Readonly 129 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 "Y" 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding user_id user_id 1 1 1 1 1 1 1 1 4 4 4 4 4 4 4 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_key 1111102user_id tcs_coding_final 1 tcs_coding_final_key tcs_coding_final_key Coding1130select `tcs_coding_key`, `tcs_coding_final_key`, `tcs_grantor_key`, `tcs_legal_key`, `tcs_grantee_key`, `create_time`, `update_time`, `created_by`, `updated_by`, `comments`, `status_cd`, `active_flag`, `user_id` From `tcs_coding`0200111180100 tcs_coding_finaltcs_coding_finaltcs_coding_final tcs_coding_final tcs_coding_final_key tcs_coding_final_key 0 0 1 1 1 1 1 1 23 23 23 23 23 23 23 Text field 3 1 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final county_cd County 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_counties county_cd county_desc 0 0 tcs_coding_final user_id User 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 @$_SESSION["OwnerID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final doctype_cd Doc Type 1 1 1 1 1 1 1 1 5 5 5 5 5 5 5 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_doctypes doctype_cd doctype_desc 0 0 tcs_coding_final volume_no Volume 1 1 1 1 1 1 1 1 4 4 4 4 4 4 4 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final filing_StartPageNo StartPageNo 1 1 1 1 1 1 1 1 7 7 7 7 7 7 7 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final filing_StartPageNo_suffix StartPageNo_suffix 1 1 1 1 1 1 1 1 18 18 18 18 18 18 18 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final filing_EndPageNo EndPageNo 1 1 1 1 1 1 1 1 8 8 8 8 8 8 8 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final Instrument_no Instrument_no 1 1 1 1 1 1 1 1 9 9 9 9 9 9 9 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final document_dt Document Date 1 1 1 1 1 1 1 1 10 10 10 10 10 10 10 Date Short Date 7 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final filed_dt Filed Date 1 1 1 1 1 1 1 1 11 11 11 11 11 11 11 Date Short Date 7 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final clerk_fileno Clerk FileNo 1 1 1 1 1 1 1 1 12 12 12 12 12 12 12 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 7 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final misc_info Misc Info 1 1 1 1 1 1 1 1 14 14 14 14 14 14 14 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 45 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final comments Comments 1 1 1 1 1 1 1 1 19 19 19 19 19 19 19 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final tcs_assignment_key tcs_assignment_key 0 1 1 1 1 1 1 1 21 21 21 21 21 21 21 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final status_cd Status 1 1 1 1 1 1 1 1 20 20 20 20 20 20 20 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 "Completed" 0 0 0 0 0 0 0 0 0 1 cod_statuses status_cd status_desc 0 0 tcs_coding_final create_time create_time 1 0 1 1 1 1 1 1 22 22 22 22 22 22 22 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final update_time update_time 1 1 1 1 1 1 1 1 25 25 25 25 25 25 25 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final created_by created_by 1 0 1 1 1 1 1 1 24 24 24 24 24 24 24 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final updated_by updated_by 1 1 1 1 1 1 1 1 26 26 26 26 26 26 26 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final instrument_amt Instrument Amt 1 1 1 1 1 1 1 1 13 13 13 13 13 13 13 Text field Number 14 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final misc_info_new Misc Info New 1 1 1 1 1 1 1 1 15 15 15 15 15 15 15 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 45 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final doctype_cd_new Doc Type New 1 1 1 1 1 1 1 1 6 6 6 6 6 6 6 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_doctypes doctype_cd doctype_desc 0 0 tcs_coding_final ref_volumeno ref_volumeno 1 1 1 1 1 1 1 1 16 16 16 16 16 16 16 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final ref_pageno ref_pageno 1 1 1 1 1 1 1 1 17 17 17 17 17 17 17 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final tcs_coding_staging_key tcs_coding_staging_key 1 1 1 1 1 1 1 1 27 27 27 27 27 27 27 Readonly 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final volume_no_county_cd Volume-County 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Readonly 200 0 0 0 0 0 0 0 0 0 0 500 0 250 1 0 @$_SESSION[$strTableName."_masterkey1"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_final_key county_cd volume_no filing_StartPageNo filing_StartPageNo_suffix filing_EndPageNo 1111100 tcs_assignments 1 volume_no_county_cd volume_no_county_cd Coding Final1140select `tcs_coding_final_key`, `county_cd`, `user_id`, `doctype_cd`, `volume_no`, `filing_StartPageNo`, `filing_StartPageNo_suffix`, `filing_EndPageNo`, `Instrument_no`, `document_dt`, `filed_dt`, `clerk_fileno`, `misc_info`, `comments`, `tcs_assignment_key`, `status_cd`, `create_time`, `update_time`, `created_by`, `updated_by`, `instrument_amt`, `misc_info_new`, `doctype_cd_new`, `ref_volumeno`, `ref_pageno`, `tcs_coding_staging_key`, `volume_no_county_cd` From `tcs_coding_final`0200111180100 tcs_coding_stagingtcs_coding_stagingtcs_coding_staging tcs_coding_staging tcs_coding_staging_key tcs_coding_staging_key 0 0 1 1 1 1 1 1 15 15 15 15 15 15 15 Text field 3 1 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging county_cd County 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 @$_SESSION[$strTableName."_masterkey2"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging user_id User 1 1 1 1 1 1 1 1 14 14 14 14 14 14 14 Readonly 200 0 0 0 0 0 0 0 0 0 1 2000 30 3000 1 0 @$_SESSION["OwnerID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging doctype_cd DocType 1 1 1 1 1 1 1 1 6 6 6 6 6 6 6 Lookup wizard 200 0 0 0 0 0 0 0 0 0 1 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_doctypes doctype_cd doctype_cd 0 0 tcs_coding_staging volume_no Volume 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 @$_SESSION[$strTableName."_masterkey3"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging filing_startpageno Start PageNo COUNT 1 1 1 1 1 1 1 1 4 4 4 4 4 4 4 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging filing_startpageno_suffix Instrument Suffix 1 1 1 1 1 1 1 1 11 11 11 11 11 11 11 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 10 3000 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging filing_endpageno End Pageno 1 1 1 1 1 1 1 1 5 5 5 5 5 5 5 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging Instrument_No Instrument_No 0 0 0 0 0 0 0 0 16 16 16 16 16 16 16 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging Document_Dt Document Date 1 1 1 1 1 1 1 1 7 7 7 7 7 7 7 Date Short Date 7 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 11 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging Filed_Dt Filed Date 1 1 1 1 1 1 1 1 8 8 8 8 8 8 8 Date Short Date 7 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 11 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging Clerk_FileNo Clerk FileNo 1 1 1 1 1 1 1 1 9 9 9 9 9 9 9 Text field 200 0 0 0 0 0 0 0 0 0 1 2000 7 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging Misc_Info Misc Info 1 1 1 1 1 1 1 1 10 10 10 10 10 10 10 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 45 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging comments Comments 1 1 1 1 1 1 1 1 12 12 12 12 12 12 12 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging tcs_assignment_key tcs_assignment_key 0 0 0 0 0 0 0 0 14 14 15 14 14 14 14 Readonly 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging status_cd Status 1 1 1 1 1 1 1 1 13 13 13 13 13 13 13 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 "Pending" 0 0 0 0 0 0 0 0 0 1 cod_statuses status_cd status_desc 0 0 tcs_coding_staging create_time create_time 1 0 1 1 1 1 1 1 15 17 17 19 17 17 17 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() Time 13 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging update_time update_time 1 1 1 1 1 1 1 1 16 16 16 17 16 16 16 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 13 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging created_by created_by 1 0 1 1 1 1 1 1 14 16 16 18 16 16 16 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging updated_by updated_by 1 1 1 1 1 1 1 1 15 15 15 16 15 15 15 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging volume_no_county_cd Volume-County 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 Readonly 200 0 0 0 0 0 0 0 0 0 0 500 0 250 1 0 @$_SESSION[$strTableName."_masterkey1"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_coding_staging_key county_cd user_id volume_no filing_startpageno filing_startpageno_suffix filing_endpageno 1111102user_id tcs_assignments 1 volume_no_county_cd volume_no_county_cd Coding Staging1150select `tcs_coding_staging_key`, `county_cd`, `user_id`, `doctype_cd`, `volume_no`, `filing_startpageno`, `filing_startpageno_suffix`, `filing_endpageno`, `Instrument_No`, `Document_Dt`, `Filed_Dt`, `Clerk_FileNo`, `Misc_Info`, `comments`, `tcs_assignment_key`, `status_cd`, `create_time`, `update_time`, `created_by`, `updated_by`, `volume_no_county_cd` From `tcs_coding_staging`020ORDER BY `volume_no` ASC, `county_cd` ASC, `filing_startpageno` DESC, `filing_endpageno` DESC, `user_id` ASC0111180100 tcs_granteestcs_granteestcs_grantees tcs_grantees tcs_grantee_key tcs_grantee_key 0 1 1 1 1 1 1 1 4 4 4 5 4 4 4 Readonly 3 1 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees grantee_name Grantee COUNT 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 50 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees create_time create_time 1 0 1 1 1 1 1 1 5 5 6 5 5 5 5 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees update_time update_time 0 1 1 1 1 1 1 1 6 6 7 8 6 6 6 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees created_by created_by 1 0 1 1 1 1 1 1 4 4 5 4 4 4 4 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees updated_by updated_by 1 1 1 1 1 1 1 1 6 6 8 6 6 6 6 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees comments comments 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees tcs_coding_final_key tcs_coding_final_key 1 0 1 1 1 1 1 1 7 7 9 7 7 7 7 Readonly 3 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantees user_id user_id 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 Readonly 200 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantee_key grantee_name tcs_coding_final_key 1111102user_id tcs_coding_final 1 tcs_coding_final_key tcs_coding_final_key Grantees1160select `tcs_grantee_key`, `grantee_name`, `create_time`, `update_time`, `created_by`, `updated_by`, `comments`, `tcs_coding_final_key`, `user_id` From `tcs_grantees`0200111180100 tcs_grantorstcs_grantorstcs_grantors tcs_grantors tcs_grantor_key tcs_grantor_key 0 0 1 1 1 1 1 1 0 0 3 0 0 0 0 Text field 3 1 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors grantor_name Grantor COUNT 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 50 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors create_time create_time 1 0 1 1 1 1 1 1 5 5 5 5 5 5 5 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors update_time update_time 1 1 1 1 1 1 1 1 7 5 7 7 7 7 7 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors created_by created_by 1 0 1 1 1 1 1 1 4 4 4 4 4 4 4 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors update_by update_by 1 1 1 1 1 1 1 1 6 4 6 6 6 6 6 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors comments comments 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors tcs_coding_final_key tcs_coding_final_key 1 1 1 1 1 1 1 1 8 6 8 8 8 8 8 Readonly 3 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantors user_id user_id 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_grantor_key grantor_name tcs_coding_final_key 1111102user_id tcs_coding_final 1 tcs_coding_final_key tcs_coding_final_key Grantors1170select `tcs_grantor_key`, `grantor_name`, `create_time`, `update_time`, `created_by`, `update_by`, `comments`, `tcs_coding_final_key`, `user_id` From `tcs_grantors`0200111180100 tcs_legalstcs_legalstcs_legals tcs_legals tcs_legals_key tcs_legals_key 0 1 1 1 1 1 1 1 10 9 11 11 10 10 10 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals recordtype_cd Rec Type COUNT 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_recordtypes recordtype_cd recordtype_desc 0 0 tcs_legals subdivision_cd Sub Cd 1 1 1 1 1 1 1 1 2 2 2 3 2 2 2 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_subdivisions subdivison_cd subdivison_desc 0 0 tcs_legals subdivision_blockno Block No 1 1 1 1 1 1 1 1 3 3 3 4 3 3 3 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals subdivision_lotno Lot No 1 1 1 1 1 1 1 1 4 4 4 5 4 4 4 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals acerage Acerage 1 1 1 1 1 1 1 1 5 5 5 6 5 5 5 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals survey_no Survey No 1 1 1 1 1 1 1 1 6 6 6 7 6 6 6 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 1 cod_survey_nos Survey_no Survey_desc 0 0 tcs_legals create_time create_time 1 0 1 1 1 1 1 1 11 10 10 12 10 10 10 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_legals update_time update_time 1 1 1 1 1 1 1 1 13 11 13 14 12 12 12 Readonly Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Now() 11 0 0 0 0 0 0 0 0 0 0 0 tcs_legals created_by created_by 1 0 1 1 1 1 1 1 10 9 9 10 9 9 9 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals updated_by updated_by 1 1 1 1 1 1 1 1 12 10 12 13 11 11 11 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals comments comments 1 1 1 1 1 1 1 1 7 7 7 8 7 7 7 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 255 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals tcs_coding_final_key tcs_coding_final_key 1 1 1 1 1 1 1 1 9 0 14 1 0 0 0 Readonly 3 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals user_id user_id 1 1 1 1 1 1 1 1 8 8 8 9 8 8 8 Readonly 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 $_SESSION["UserID"] 0 0 0 0 0 0 0 0 0 0 0 0 tcs_legals_key recordtype_cd subdivision_cd subdivision_blockno subdivision_lotno acerage survey_no tcs_coding_final_key 1111102user_id tcs_coding_final 1 tcs_coding_final_key tcs_coding_final_key Legals1180select `tcs_legals_key`, `recordtype_cd`, `subdivision_cd`, `subdivision_blockno`, `subdivision_lotno`, `acerage`, `survey_no`, `create_time`, `update_time`, `created_by`, `updated_by`, `comments`, `tcs_coding_final_key`, `user_id` From `tcs_legals`0200111180100 tcs_userstcs_userstcs_users tcs_users User_Id User_Id COUNT 1 1 1 1 1 1 1 1 2 0 1 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users User_Name User_Name 1 1 1 1 1 1 1 1 3 0 2 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 50 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users department_cd department_cd 1 1 1 1 1 1 1 1 4 0 3 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users User_Password User_Password 1 1 1 1 1 1 1 1 5 0 4 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 15 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users user_role_cd user_role_cd 1 1 1 1 1 1 1 1 6 0 5 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users active_flag active_flag 1 1 1 1 1 1 1 1 7 0 6 0 0 0 0 Text field 129 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users created_by created_by 1 0 1 1 1 1 1 1 7 0 7 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users create_time create_time 1 0 1 1 1 1 1 1 8 0 8 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_users update_by update_by 1 1 1 1 1 1 1 1 9 0 9 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_users update_time update_time 1 1 1 1 1 1 1 1 10 0 10 0 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_users email_address email_address 1 1 1 1 1 1 1 1 1 0 11 0 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 0 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 User_Id 1111100 tcs_users1190select `User_Id`, `User_Name`, `department_cd`, `User_Password`, `user_role_cd`, `active_flag`, `created_by`, `create_time`, `update_by`, `update_time`, `email_address` From `tcs_users`0200111180100 tcs_volumestcs_volumestcs_volumes tcs_volumes county_cd county_cd 0 1 1 1 1 1 1 1 0 3 1 1 0 0 0 Lookup wizard 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 @$_SESSION[$strTableName."_masterkey1"] 0 0 0 0 0 0 0 0 0 1 cod_counties county_cd county_desc 0 0 tcs_volumes volume_no volume_no 1 1 1 1 1 1 1 1 1 4 2 2 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 10 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes volume_img_url volume_img_url 1 1 1 1 1 1 1 1 2 5 3 3 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 250 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes volume_startpageno volume_startpageno 1 1 1 1 1 1 1 1 3 6 4 4 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 20 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes volume_endpageno volume_endpageno 1 1 1 1 1 1 1 1 4 7 5 5 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 20 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes number_of_images number_of_images 1 1 1 1 1 1 1 1 5 8 6 6 0 0 0 Text field 3 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 Number 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes created_by created_by 1 0 1 1 1 1 1 1 6 0 7 7 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes create_time create_time 1 0 1 1 1 1 1 1 7 0 8 8 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes updated_by updated_by 1 1 1 1 1 1 1 1 8 1 9 9 0 0 0 Text field 200 0 0 0 0 0 0 0 0 0 0 2000 30 3000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 tcs_volumes update_time update_time 1 1 1 1 1 1 1 1 9 2 10 10 0 0 0 Date Short Date 135 0 0 0 0 0 0 0 0 0 1 2000 0 3000 1 0 13 0 0 0 0 0 0 0 0 0 0 0 county_cd volume_no 1111100 cod_counties 1 county_cd county_cd Volumes1200select `county_cd`, `volume_no`, `volume_img_url`, `volume_startpageno`, `volume_endpageno`, `number_of_images`, `created_by`, `create_time`, `updated_by`, `update_time` From `tcs_volumes`0200111180100