{ "System_Config": { "sheetName": "System_Config", "d1Table": "agw_system_config", "category": "metadata", "primaryCandidate": "key_value", "columnCount": 4, "columns": [ { "sheetColumn": "Key", "d1Column": "key_value", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Value", "d1Column": "value_value", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Users": { "sheetName": "Users", "d1Table": "agw_users", "category": "security_access", "primaryCandidate": "user_id", "columnCount": 26, "columns": [ { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Email", "d1Column": "email", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Password_Hash", "d1Column": "password_hash", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Salt", "d1Column": "salt", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Role", "d1Column": "role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Must_Change_Password", "d1Column": "must_change_password", "type": "INTEGER", "sensitive": true }, { "sheetColumn": "Failed_Attempts", "d1Column": "failed_attempts", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Locked_Until", "d1Column": "locked_until", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Last_Login", "d1Column": "last_login", "type": "TEXT", "sensitive": false }, { "sheetColumn": "MFA_Enabled", "d1Column": "mfa_enabled", "type": "INTEGER", "sensitive": true }, { "sheetColumn": "MFA_Secret", "d1Column": "mfa_secret", "type": "TEXT", "sensitive": true }, { "sheetColumn": "MFA_Verified_At", "d1Column": "mfa_verified_at", "type": "TEXT", "sensitive": true }, { "sheetColumn": "MFA_Recovery_Codes", "d1Column": "mfa_recovery_codes", "type": "TEXT", "sensitive": true }, { "sheetColumn": "MFA_Enrollment_Required", "d1Column": "mfa_enrollment_required", "type": "INTEGER", "sensitive": true }, { "sheetColumn": "MFA_Enrollment_Deadline", "d1Column": "mfa_enrollment_deadline", "type": "TEXT", "sensitive": true }, { "sheetColumn": "MFA_Last_QR_Sent_At", "d1Column": "mfa_last_qr_sent_at", "type": "TEXT", "sensitive": true }, { "sheetColumn": "MFA_Recovery_Codes_Viewed_At", "d1Column": "mfa_recovery_codes_viewed_at", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Identity_Status", "d1Column": "agen_core_identity_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Identity_ID", "d1Column": "agen_core_identity_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Last_Sync_At", "d1Column": "agen_core_last_sync_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Last_Sync_Run_ID", "d1Column": "agen_core_last_sync_run_id", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Employees": { "sheetName": "Employees", "d1Table": "agw_employees", "category": "hr_master", "primaryCandidate": "employee_id", "columnCount": 75, "columns": [ { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "First_Name", "d1Column": "first_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Middle_Name", "d1Column": "middle_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Last_Name", "d1Column": "last_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Suffix", "d1Column": "suffix", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Preferred_Name", "d1Column": "preferred_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Profile_Image_URL", "d1Column": "profile_image_url", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sex", "d1Column": "sex", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Birthdate", "d1Column": "birthdate", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Civil_Status", "d1Column": "civil_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Personal_Email", "d1Column": "personal_email", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Company_Email", "d1Column": "company_email", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Mobile_Number", "d1Column": "mobile_number", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Address", "d1Column": "address", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Emergency_Contact_Name", "d1Column": "emergency_contact_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Emergency_Contact_Number", "d1Column": "emergency_contact_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sub_Department_ID", "d1Column": "sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Team_ID", "d1Column": "team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cluster_ID", "d1Column": "cluster_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Position_ID", "d1Column": "position_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Has_Multiple_Positions", "d1Column": "has_multiple_positions", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Secondary_Department_ID", "d1Column": "secondary_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Secondary_Sub_Department_ID", "d1Column": "secondary_sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Secondary_Team_ID", "d1Column": "secondary_team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Secondary_Cluster_ID", "d1Column": "secondary_cluster_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Secondary_Position_ID", "d1Column": "secondary_position_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Supervisor_Employee_ID", "d1Column": "supervisor_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employment_Status", "d1Column": "employment_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employment_Type", "d1Column": "employment_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Hire_Date", "d1Column": "hire_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Probationary_Date", "d1Column": "probationary_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Regularization_Date", "d1Column": "regularization_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Separation_Date", "d1Column": "separation_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "SSS_Number", "d1Column": "sss_number", "type": "TEXT", "sensitive": true }, { "sheetColumn": "PhilHealth_Number", "d1Column": "phil_health_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "PagIBIG_Number", "d1Column": "pag_ibig_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "TIN", "d1Column": "tin", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Bank_Name", "d1Column": "bank_name", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Bank_Account_Number", "d1Column": "bank_account_number", "type": "INTEGER", "sensitive": true }, { "sheetColumn": "Base_Salary", "d1Column": "base_salary", "type": "REAL", "sensitive": true }, { "sheetColumn": "Pay_Frequency", "d1Column": "pay_frequency", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Taxable_Meal_Allowance", "d1Column": "taxable_meal_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Taxable_Transport_Allowance", "d1Column": "taxable_transport_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Taxable_Client_Specific_Allowance", "d1Column": "taxable_client_specific_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Taxable_Company_Specific_Allowance", "d1Column": "taxable_company_specific_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Taxable_Communication_Allowance", "d1Column": "taxable_communication_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Meal_Allowance", "d1Column": "non_taxable_meal_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Transport_Allowance", "d1Column": "non_taxable_transport_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Client_Specific_Allowance", "d1Column": "non_taxable_client_specific_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Company_Specific_Allowance", "d1Column": "non_taxable_company_specific_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Internet_Allowance", "d1Column": "non_taxable_internet_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "SSS_Deduction", "d1Column": "sss_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "PhilHealth_Deduction", "d1Column": "phil_health_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "PagIBIG_Deduction", "d1Column": "pag_ibig_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "Withholding_Tax_Deduction", "d1Column": "withholding_tax_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "Cash_Advance_Deduction", "d1Column": "cash_advance_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "HMO_Deduction", "d1Column": "hmo_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "Company_Loan_Deduction", "d1Column": "company_loan_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "Equipment_Deduction", "d1Column": "equipment_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "Other_Deduction", "d1Column": "other_deduction", "type": "REAL", "sensitive": true }, { "sheetColumn": "Work_Location", "d1Column": "work_location", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Code", "d1Column": "client_code", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Name", "d1Column": "client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_LOB", "d1Column": "client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Sub_LOB", "d1Column": "client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Work_Type", "d1Column": "work_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Profile_Status", "d1Column": "profile_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Notes", "d1Column": "notes", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Identity_Status", "d1Column": "agen_core_identity_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Identity_ID", "d1Column": "agen_core_identity_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Last_Sync_At", "d1Column": "agen_core_last_sync_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Last_Sync_Run_ID", "d1Column": "agen_core_last_sync_run_id", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Departments": { "sheetName": "Departments", "d1Table": "agw_departments", "category": "hr_master", "primaryCandidate": "department_id", "columnCount": 7, "columns": [ { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_Name", "d1Column": "department_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_Head_Employee_ID", "d1Column": "department_head_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Sub_Departments": { "sheetName": "Sub_Departments", "d1Table": "agw_sub_departments", "category": "hr_master", "primaryCandidate": "sub_department_id", "columnCount": 8, "columns": [ { "sheetColumn": "Sub_Department_ID", "d1Column": "sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sub_Department_Name", "d1Column": "sub_department_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sub_Department_Head_Employee_ID", "d1Column": "sub_department_head_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Teams": { "sheetName": "Teams", "d1Table": "agw_teams", "category": "hr_master", "primaryCandidate": "team_id", "columnCount": 9, "columns": [ { "sheetColumn": "Team_ID", "d1Column": "team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sub_Department_ID", "d1Column": "sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Team_Name", "d1Column": "team_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Team_Lead_Employee_ID", "d1Column": "team_lead_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Clusters": { "sheetName": "Clusters", "d1Table": "agw_clusters", "category": "hr_master", "primaryCandidate": "cluster_id", "columnCount": 10, "columns": [ { "sheetColumn": "Cluster_ID", "d1Column": "cluster_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sub_Department_ID", "d1Column": "sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Team_ID", "d1Column": "team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cluster_Name", "d1Column": "cluster_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cluster_Lead_Employee_ID", "d1Column": "cluster_lead_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Positions": { "sheetName": "Positions", "d1Table": "agw_positions", "category": "hr_master", "primaryCandidate": "position_id", "columnCount": 8, "columns": [ { "sheetColumn": "Position_ID", "d1Column": "position_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Position_Title", "d1Column": "position_title", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Job_Level", "d1Column": "job_level", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Client_Catalog": { "sheetName": "Client_Catalog", "d1Table": "agw_client_catalog", "category": "hr_master", "primaryCandidate": "client_id", "columnCount": 11, "columns": [ { "sheetColumn": "Client_ID", "d1Column": "client_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Code", "d1Column": "client_code", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Name", "d1Column": "client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_LOB", "d1Column": "client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Sub_LOB", "d1Column": "client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Types", "d1Column": "client_types", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_By", "d1Column": "updated_by", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Employment_Status": { "sheetName": "Employment_Status", "d1Table": "agw_employment_status", "category": "hr_master", "primaryCandidate": "status_id", "columnCount": 6, "columns": [ { "sheetColumn": "Status_ID", "d1Column": "status_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status_Name", "d1Column": "status_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Is_Active", "d1Column": "is_active", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Employee_Documents": { "sheetName": "Employee_Documents", "d1Table": "agw_employee_documents", "category": "hr_master", "primaryCandidate": "document_id", "columnCount": 20, "columns": [ { "sheetColumn": "Document_ID", "d1Column": "document_id", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Document_Type", "d1Column": "document_type", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Document_Category", "d1Column": "document_category", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Document_Name", "d1Column": "document_name", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Drive_URL", "d1Column": "drive_url", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Issue_Date", "d1Column": "issue_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Expiry_Date", "d1Column": "expiry_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Confidentiality", "d1Column": "confidentiality", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Submitted_By", "d1Column": "submitted_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Submitted_At", "d1Column": "submitted_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reviewed_By", "d1Column": "reviewed_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reviewed_At", "d1Column": "reviewed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Review_Action", "d1Column": "review_action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Review_Remarks", "d1Column": "review_remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Uploaded_By", "d1Column": "uploaded_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Uploaded_At", "d1Column": "uploaded_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Employee_Movements": { "sheetName": "Employee_Movements", "d1Table": "agw_employee_movements", "category": "hr_master", "primaryCandidate": "movement_id", "columnCount": 42, "columns": [ { "sheetColumn": "Movement_ID", "d1Column": "movement_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Movement_Type", "d1Column": "movement_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Movement_Status", "d1Column": "movement_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role_Status", "d1Column": "role_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Effective_Date", "d1Column": "effective_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Probation_End_Date", "d1Column": "probation_end_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Review_Date", "d1Column": "review_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Contract_Reference", "d1Column": "contract_reference", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Department_ID", "d1Column": "previous_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Department_ID", "d1Column": "new_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Sub_Department_ID", "d1Column": "previous_sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Sub_Department_ID", "d1Column": "new_sub_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Team_ID", "d1Column": "previous_team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Team_ID", "d1Column": "new_team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Cluster_ID", "d1Column": "previous_cluster_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Cluster_ID", "d1Column": "new_cluster_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Position_ID", "d1Column": "previous_position_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Position_ID", "d1Column": "new_position_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Client_Name", "d1Column": "previous_client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Client_Name", "d1Column": "new_client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Client_LOB", "d1Column": "previous_client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Client_LOB", "d1Column": "new_client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Client_Sub_LOB", "d1Column": "previous_client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Client_Sub_LOB", "d1Column": "new_client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Previous_Salary", "d1Column": "previous_salary", "type": "REAL", "sensitive": true }, { "sheetColumn": "New_Salary", "d1Column": "new_salary", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Allowance", "d1Column": "non_taxable_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Taxable_Allowance", "d1Column": "taxable_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Requested_By", "d1Column": "requested_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Requested_At", "d1Column": "requested_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Status", "d1Column": "approval_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Department_ID", "d1Column": "approval_department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Level_Required", "d1Column": "approval_level_required", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approved_By", "d1Column": "approved_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approved_At", "d1Column": "approved_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Rejected_By", "d1Column": "rejected_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Rejected_At", "d1Column": "rejected_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Review_Remarks", "d1Column": "review_remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Leave_Balances": { "sheetName": "Leave_Balances", "d1Table": "agw_leave_balances", "category": "leave", "primaryCandidate": "leave_balance_id", "columnCount": 19, "columns": [ { "sheetColumn": "Leave_Balance_ID", "d1Column": "leave_balance_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Leave_Type", "d1Column": "leave_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Year", "d1Column": "year", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Opening_Balance_Hours", "d1Column": "opening_balance_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Accrued_Hours", "d1Column": "accrued_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Used_Hours", "d1Column": "used_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Remaining_Hours", "d1Column": "remaining_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "SIL_Hours", "d1Column": "sil_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "PTO_Excess_Hours", "d1Column": "pto_excess_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payable_Hours", "d1Column": "payable_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Forfeitable_Hours", "d1Column": "forfeitable_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Expired_PTO_Hours", "d1Column": "expired_pto_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Carryover_Hours", "d1Column": "carryover_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Paid_Out_Hours", "d1Column": "paid_out_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Year_End_Status", "d1Column": "year_end_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Year_End_Processed_At", "d1Column": "year_end_processed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Leave_Eligibility", "d1Column": "leave_eligibility", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Leave_Requests": { "sheetName": "Leave_Requests", "d1Table": "agw_leave_requests", "category": "leave", "primaryCandidate": "leave_request_id", "columnCount": 22, "columns": [ { "sheetColumn": "Leave_Request_ID", "d1Column": "leave_request_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Leave_Type", "d1Column": "leave_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Leave_Category", "d1Column": "leave_category", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Start_Date", "d1Column": "start_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "End_Date", "d1Column": "end_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Hours_Per_Day", "d1Column": "hours_per_day", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Hours", "d1Column": "total_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Comment", "d1Column": "comment", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Chain", "d1Column": "approval_chain", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Current_Step", "d1Column": "current_step", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Next_Approver", "d1Column": "next_approver", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_History", "d1Column": "approval_history", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Final_Approved_At", "d1Column": "final_approved_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Rejected_At", "d1Column": "rejected_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Rejected_By", "d1Column": "rejected_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reject_Reason", "d1Column": "reject_reason", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cancelled_At", "d1Column": "cancelled_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cancel_Reason", "d1Column": "cancel_reason", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Time_Schedules": { "sheetName": "Time_Schedules", "d1Table": "agw_time_schedules", "category": "timekeeping", "primaryCandidate": "schedule_id", "columnCount": 14, "columns": [ { "sheetColumn": "Schedule_ID", "d1Column": "schedule_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Date", "d1Column": "date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Shift_Start", "d1Column": "shift_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Shift_End", "d1Column": "shift_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Break_Start", "d1Column": "break_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Break_End", "d1Column": "break_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Lunch_Start", "d1Column": "lunch_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Lunch_End", "d1Column": "lunch_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Time_Attendance": { "sheetName": "Time_Attendance", "d1Table": "agw_time_attendance", "category": "timekeeping", "primaryCandidate": "entry_id", "columnCount": 11, "columns": [ { "sheetColumn": "Entry_ID", "d1Column": "entry_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Date", "d1Column": "date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Time_In", "d1Column": "time_in", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Time_Out", "d1Column": "time_out", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source", "d1Column": "source", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Time_Aux": { "sheetName": "Time_Aux", "d1Table": "agw_time_aux", "category": "timekeeping", "primaryCandidate": "aux_id", "columnCount": 16, "columns": [ { "sheetColumn": "Aux_ID", "d1Column": "aux_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Date", "d1Column": "date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Start_Time", "d1Column": "start_time", "type": "TEXT", "sensitive": false }, { "sheetColumn": "End_Time", "d1Column": "end_time", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Type", "d1Column": "type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Module", "d1Column": "source_module", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Record_ID", "d1Column": "source_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Import_Run_ID", "d1Column": "import_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Paid_Flag", "d1Column": "paid_flag", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Productive_Flag", "d1Column": "productive_flag", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Imported_At", "d1Column": "imported_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Scheduled_Off": { "sheetName": "Scheduled_Off", "d1Table": "agw_scheduled_off", "category": "timekeeping", "primaryCandidate": "off_id", "columnCount": 8, "columns": [ { "sheetColumn": "Off_ID", "d1Column": "off_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Date", "d1Column": "date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Type", "d1Column": "type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Assigned_By", "d1Column": "assigned_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Time_Summary": { "sheetName": "Time_Summary", "d1Table": "agw_time_summary", "category": "timekeeping", "primaryCandidate": "summary_id", "columnCount": 36, "columns": [ { "sheetColumn": "Summary_ID", "d1Column": "summary_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Time_Source", "d1Column": "time_source", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Time_Source_Label", "d1Column": "time_source_label", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Scheduled_Hours", "d1Column": "scheduled_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Actual_Work_Hours", "d1Column": "actual_work_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "AGenWork_Time_Hours", "d1Column": "agen_work_time_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "AGenTel_Aux_Hours", "d1Column": "agen_tel_aux_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Regular_Work_Hours", "d1Column": "regular_work_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Paid_Leave_Hours", "d1Column": "paid_leave_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Unpaid_Leave_Hours", "d1Column": "unpaid_leave_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Absence_Hours", "d1Column": "absence_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Scheduled_Off_Days", "d1Column": "scheduled_off_days", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Aux_Hours", "d1Column": "aux_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Paid_Hours", "d1Column": "payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Unpaid_Hours", "d1Column": "payroll_unpaid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Pending_Leave_Hours", "d1Column": "pending_leave_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Time_Summary_Status", "d1Column": "time_summary_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Generated_At", "d1Column": "generated_at", "type": "REAL", "sensitive": false }, { "sheetColumn": "Submitted_By", "d1Column": "submitted_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Submitted_At", "d1Column": "submitted_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reviewed_By", "d1Column": "reviewed_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reviewed_At", "d1Column": "reviewed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Status", "d1Column": "approval_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Action", "d1Column": "approval_action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Remarks", "d1Column": "approval_remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Next_Approver", "d1Column": "next_approver", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Required", "d1Column": "approval_required", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Workweek_Hours", "d1Column": "workweek_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Export_Batch_ID", "d1Column": "export_batch_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Export_Batch_Number", "d1Column": "export_batch_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Export_Locked", "d1Column": "export_locked", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Exported_At", "d1Column": "exported_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Exported_By", "d1Column": "exported_by", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Time_Edit_Audit": { "sheetName": "Time_Edit_Audit", "d1Table": "agw_time_edit_audit", "category": "timekeeping", "primaryCandidate": "audit_id", "columnCount": 17, "columns": [ { "sheetColumn": "Audit_ID", "d1Column": "audit_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Entry_ID", "d1Column": "entry_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Date", "d1Column": "date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_User_ID", "d1Column": "actor_user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Employee_ID", "d1Column": "actor_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Role", "d1Column": "actor_role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Before_Time_In", "d1Column": "before_time_in", "type": "TEXT", "sensitive": false }, { "sheetColumn": "After_Time_In", "d1Column": "after_time_in", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Before_Time_Out", "d1Column": "before_time_out", "type": "TEXT", "sensitive": false }, { "sheetColumn": "After_Time_Out", "d1Column": "after_time_out", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Before_Remarks", "d1Column": "before_remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "After_Remarks", "d1Column": "after_remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approval_Status_At_Edit", "d1Column": "approval_status_at_edit", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Edit_Action", "d1Column": "edit_action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Payroll_Export_Batches": { "sheetName": "Payroll_Export_Batches", "d1Table": "agw_payroll_export_batches", "category": "payroll", "primaryCandidate": "batch_id", "columnCount": 39, "columns": [ { "sheetColumn": "Batch_ID", "d1Column": "batch_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_Number", "d1Column": "batch_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cutoff_Month", "d1Column": "cutoff_month", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Cutoff_Period", "d1Column": "cutoff_period", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Report_Key", "d1Column": "report_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Row_Count", "d1Column": "row_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Total_Workweek_Hours", "d1Column": "total_workweek_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Regular_Hours", "d1Column": "total_regular_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Overtime_Hours", "d1Column": "total_overtime_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Payroll_Paid_Hours", "d1Column": "total_payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Payroll_Unpaid_Hours", "d1Column": "total_payroll_unpaid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Generated_By", "d1Column": "generated_by", "type": "REAL", "sensitive": false }, { "sheetColumn": "Generated_At", "d1Column": "generated_at", "type": "REAL", "sensitive": false }, { "sheetColumn": "Locked_By", "d1Column": "locked_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Locked_At", "d1Column": "locked_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Voided_By", "d1Column": "voided_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Voided_At", "d1Column": "voided_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Void_Reason", "d1Column": "void_reason", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Remarks", "d1Column": "remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Handoff_Status", "d1Column": "agen_pay_handoff_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Handoff_Run_ID", "d1Column": "agen_pay_handoff_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Handoff_At", "d1Column": "agen_pay_handoff_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Target_Record_ID", "d1Column": "agen_pay_target_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Return_Status", "d1Column": "agen_pay_return_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Return_Run_ID", "d1Column": "agen_pay_return_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Return_At", "d1Column": "agen_pay_return_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Result_Status", "d1Column": "agen_pay_result_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Payroll_Run_ID", "d1Column": "agen_pay_payroll_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Payslip_Status", "d1Column": "agen_pay_payslip_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Payment_Status", "d1Column": "agen_pay_payment_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Disbursement_Status", "d1Column": "agen_pay_disbursement_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Exception_Count", "d1Column": "agen_pay_exception_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "AGenPay_Exception_Message", "d1Column": "agen_pay_exception_message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Processed_At", "d1Column": "agen_pay_processed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Released_At", "d1Column": "agen_pay_released_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Payroll_Export_Batch_Items": { "sheetName": "Payroll_Export_Batch_Items", "d1Table": "agw_payroll_export_batch_items", "category": "payroll", "primaryCandidate": "batch_item_id", "columnCount": 16, "columns": [ { "sheetColumn": "Batch_Item_ID", "d1Column": "batch_item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_ID", "d1Column": "batch_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_Number", "d1Column": "batch_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Summary_ID", "d1Column": "summary_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Name", "d1Column": "employee_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Workweek_Hours", "d1Column": "workweek_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Regular_Hours", "d1Column": "regular_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Overtime_Hours", "d1Column": "overtime_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Paid_Hours", "d1Column": "payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Unpaid_Hours", "d1Column": "payroll_unpaid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Approval_Status", "d1Column": "approval_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Export_Locked", "d1Column": "export_locked", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Payroll_Export_Audit": { "sheetName": "Payroll_Export_Audit", "d1Table": "agw_payroll_export_audit", "category": "payroll", "primaryCandidate": "audit_id", "columnCount": 11, "columns": [ { "sheetColumn": "Audit_ID", "d1Column": "audit_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_ID", "d1Column": "batch_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_Number", "d1Column": "batch_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_User_ID", "d1Column": "actor_user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Employee_ID", "d1Column": "actor_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Role", "d1Column": "actor_role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Action", "d1Column": "action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Old_Status", "d1Column": "old_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Status", "d1Column": "new_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Audit_Log": { "sheetName": "Audit_Log", "d1Table": "agw_audit_log", "category": "audit", "primaryCandidate": "log_id", "columnCount": 9, "columns": [ { "sheetColumn": "Log_ID", "d1Column": "log_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_User_ID", "d1Column": "actor_user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Employee_ID", "d1Column": "actor_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Action", "d1Column": "action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Entity_Type", "d1Column": "entity_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Entity_ID", "d1Column": "entity_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false }, { "sheetColumn": "IPAddress", "d1Column": "ipaddress", "type": "TEXT", "sensitive": true } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Security_Sessions": { "sheetName": "Security_Sessions", "d1Table": "agw_security_sessions", "category": "security_access", "primaryCandidate": "session_id", "columnCount": 13, "columns": [ { "sheetColumn": "Session_ID", "d1Column": "session_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role", "d1Column": "role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Expires_At", "d1Column": "expires_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Last_Heartbeat_At", "d1Column": "last_heartbeat_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Ended_At", "d1Column": "ended_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "End_Reason", "d1Column": "end_reason", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Device_ID", "d1Column": "device_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_Agent", "d1Column": "user_agent", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Security_Events": { "sheetName": "Security_Events", "d1Table": "agw_security_events", "category": "security_access", "primaryCandidate": "event_id", "columnCount": 10, "columns": [ { "sheetColumn": "Event_ID", "d1Column": "event_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Event_Type", "d1Column": "event_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Result", "d1Column": "result", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Device_ID", "d1Column": "device_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_Agent", "d1Column": "user_agent", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Identity_Roles": { "sheetName": "Identity_Roles", "d1Table": "agw_identity_roles", "category": "security_access", "primaryCandidate": "role_id", "columnCount": 9, "columns": [ { "sheetColumn": "Role_ID", "d1Column": "role_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role_Name", "d1Column": "role_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role_Level", "d1Column": "role_level", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role_Category", "d1Column": "role_category", "type": "TEXT", "sensitive": false }, { "sheetColumn": "MFA_Required", "d1Column": "mfa_required", "type": "TEXT", "sensitive": true }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Permission_Catalog": { "sheetName": "Permission_Catalog", "d1Table": "agw_permission_catalog", "category": "security_access", "primaryCandidate": "permission_key", "columnCount": 8, "columns": [ { "sheetColumn": "Permission_Key", "d1Column": "permission_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Module", "d1Column": "module", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Action", "d1Column": "action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Risk_Level", "d1Column": "risk_level", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Role_Permissions": { "sheetName": "Role_Permissions", "d1Table": "agw_role_permissions", "category": "security_access", "primaryCandidate": "role_name", "columnCount": 6, "columns": [ { "sheetColumn": "Role_Name", "d1Column": "role_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Permission_Key", "d1Column": "permission_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Allowed", "d1Column": "allowed", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Scope_Type", "d1Column": "scope_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "User_Access_Overrides": { "sheetName": "User_Access_Overrides", "d1Table": "agw_user_access_overrides", "category": "security_access", "primaryCandidate": "override_id", "columnCount": 13, "columns": [ { "sheetColumn": "Override_ID", "d1Column": "override_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Permission_Key", "d1Column": "permission_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Allowed", "d1Column": "allowed", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Scope_Type", "d1Column": "scope_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reason", "d1Column": "reason", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Effective_From", "d1Column": "effective_from", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Effective_To", "d1Column": "effective_to", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "MFA_Enrollment_Audit": { "sheetName": "MFA_Enrollment_Audit", "d1Table": "agw_mfa_enrollment_audit", "category": "security_access", "primaryCandidate": "event_id", "columnCount": 9, "columns": [ { "sheetColumn": "Event_ID", "d1Column": "event_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Email", "d1Column": "email", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Event_Type", "d1Column": "event_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Result", "d1Column": "result", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Access_Policies": { "sheetName": "Access_Policies", "d1Table": "agw_access_policies", "category": "security_access", "primaryCandidate": null, "columnCount": 7, "columns": [ { "sheetColumn": "Role", "d1Column": "role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Module", "d1Column": "module", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Can_View", "d1Column": "can_view", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Can_Edit", "d1Column": "can_edit", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Can_Delete", "d1Column": "can_delete", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Metadata_Config": { "sheetName": "Metadata_Config", "d1Table": "agw_metadata_config", "category": "metadata", "primaryCandidate": "config_key", "columnCount": 6, "columns": [ { "sheetColumn": "Config_Key", "d1Column": "config_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Config_Value", "d1Column": "config_value", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Data_Type", "d1Column": "data_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Active", "d1Column": "active", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Metadata_Modules": { "sheetName": "Metadata_Modules", "d1Table": "agw_metadata_modules", "category": "metadata", "primaryCandidate": null, "columnCount": 11, "columns": [ { "sheetColumn": "Module_Key", "d1Column": "module_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Module_Name", "d1Column": "module_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Parent_Key", "d1Column": "parent_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Category", "d1Column": "category", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sort_Order", "d1Column": "sort_order", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Default_Visibility", "d1Column": "default_visibility", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Default_Access_Scope", "d1Column": "default_access_scope", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Active", "d1Column": "active", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Metadata_Dropdowns": { "sheetName": "Metadata_Dropdowns", "d1Table": "agw_metadata_dropdowns", "category": "metadata", "primaryCandidate": null, "columnCount": 8, "columns": [ { "sheetColumn": "Dropdown_Key", "d1Column": "dropdown_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Value", "d1Column": "value_value", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Label", "d1Column": "label", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Active", "d1Column": "active", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Sort_Order", "d1Column": "sort_order", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Metadata_Access_Scopes": { "sheetName": "Metadata_Access_Scopes", "d1Table": "agw_metadata_access_scopes", "category": "metadata", "primaryCandidate": null, "columnCount": 8, "columns": [ { "sheetColumn": "Scope_Key", "d1Column": "scope_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Scope_Name", "d1Column": "scope_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Includes_Hierarchy", "d1Column": "includes_hierarchy", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Active", "d1Column": "active", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Sort_Order", "d1Column": "sort_order", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Metadata_Audit_Log": { "sheetName": "Metadata_Audit_Log", "d1Table": "agw_metadata_audit_log", "category": "metadata", "primaryCandidate": "audit_id", "columnCount": 15, "columns": [ { "sheetColumn": "Audit_ID", "d1Column": "audit_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_User_ID", "d1Column": "actor_user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Employee_ID", "d1Column": "actor_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Name", "d1Column": "actor_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Role", "d1Column": "actor_role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Action", "d1Column": "action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Metadata_Table", "d1Column": "metadata_table", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Metadata_Key", "d1Column": "metadata_key", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Old_Value", "d1Column": "old_value", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Value", "d1Column": "new_value", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Before_Summary", "d1Column": "before_summary", "type": "TEXT", "sensitive": false }, { "sheetColumn": "After_Summary", "d1Column": "after_summary", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Changed_Fields", "d1Column": "changed_fields", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Employee_Requests": { "sheetName": "Employee_Requests", "d1Table": "agw_employee_requests", "category": "hr_master", "primaryCandidate": "request_id", "columnCount": 28, "columns": [ { "sheetColumn": "Request_ID", "d1Column": "request_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Number", "d1Column": "request_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Type_ID", "d1Column": "request_type_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Type", "d1Column": "request_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Title", "d1Column": "request_title", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Details", "d1Column": "request_details", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Purpose", "d1Column": "request_purpose", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Needed_By_Date", "d1Column": "needed_by_date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Delivery_Method", "d1Column": "delivery_method", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Requested_Changes", "d1Column": "requested_changes", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Requested_Before", "d1Column": "requested_before", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Applied_At", "d1Column": "applied_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Correction_Notes", "d1Column": "correction_notes", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Status", "d1Column": "request_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Priority", "d1Column": "priority", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Submitted_At", "d1Column": "submitted_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Submitted_By", "d1Column": "submitted_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Assigned_To", "d1Column": "assigned_to", "type": "TEXT", "sensitive": false }, { "sheetColumn": "HR_Remarks", "d1Column": "hr_remarks", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Completion_Notes", "d1Column": "completion_notes", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approved_By", "d1Column": "approved_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Approved_At", "d1Column": "approved_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Completed_At", "d1Column": "completed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Closed_At", "d1Column": "closed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Last_Updated_By", "d1Column": "last_updated_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Request_Types": { "sheetName": "Request_Types", "d1Table": "agw_request_types", "category": "request_center", "primaryCandidate": "request_type_id", "columnCount": 11, "columns": [ { "sheetColumn": "Request_Type_ID", "d1Column": "request_type_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Type_Name", "d1Column": "request_type_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Category", "d1Column": "category", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Description", "d1Column": "description", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Default_Priority", "d1Column": "default_priority", "type": "TEXT", "sensitive": false }, { "sheetColumn": "SLA_Days", "d1Column": "sla_days", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Requires_HR_Approval", "d1Column": "requires_hr_approval", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Active", "d1Column": "active", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Sort_Order", "d1Column": "sort_order", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "Request_Audit_Log": { "sheetName": "Request_Audit_Log", "d1Table": "agw_request_audit_log", "category": "request_center", "primaryCandidate": "request_audit_id", "columnCount": 12, "columns": [ { "sheetColumn": "Request_Audit_ID", "d1Column": "request_audit_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Timestamp", "d1Column": "timestamp", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_ID", "d1Column": "request_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Request_Number", "d1Column": "request_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_User_ID", "d1Column": "actor_user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Employee_ID", "d1Column": "actor_employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Name", "d1Column": "actor_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Actor_Role", "d1Column": "actor_role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Action", "d1Column": "action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Old_Status", "d1Column": "old_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "New_Status", "d1Column": "new_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Details", "d1Column": "details", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenTel_Paid_Time_Import_Runs": { "sheetName": "AGW_AGenTel_Paid_Time_Import_Runs", "d1Table": "agw_agw_agen_tel_paid_time_import_runs", "category": "agentel_integration", "primaryCandidate": "run_id", "columnCount": 19, "columns": [ { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_Type", "d1Column": "run_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Mode", "d1Column": "source_mode", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Spreadsheet_ID", "d1Column": "source_spreadsheet_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Sheet_Name", "d1Column": "source_sheet_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Filter", "d1Column": "employee_filter", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Total_Source_Rows", "d1Column": "total_source_rows", "type": "REAL", "sensitive": false }, { "sheetColumn": "Eligible_Rows", "d1Column": "eligible_rows", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Imported_Rows", "d1Column": "imported_rows", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Duplicate_Rows", "d1Column": "duplicate_rows", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Skipped_Rows", "d1Column": "skipped_rows", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Paid_Hours", "d1Column": "paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Message", "d1Column": "message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenTel_Paid_Time_Import_Items": { "sheetName": "AGW_AGenTel_Paid_Time_Import_Items", "d1Table": "agw_agw_agen_tel_paid_time_import_items", "category": "agentel_integration", "primaryCandidate": "item_id", "columnCount": 17, "columns": [ { "sheetColumn": "Item_ID", "d1Column": "item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Record_ID", "d1Column": "source_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Date", "d1Column": "date", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Start_Time", "d1Column": "start_time", "type": "TEXT", "sensitive": false }, { "sheetColumn": "End_Time", "d1Column": "end_time", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Type", "d1Column": "type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Duration_Hours", "d1Column": "duration_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Paid_Flag", "d1Column": "paid_flag", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Productive_Flag", "d1Column": "productive_flag", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Import_Status", "d1Column": "import_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Reason", "d1Column": "reason", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Aux_ID", "d1Column": "aux_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Raw_JSON", "d1Column": "raw_json", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_Time_Payroll_Reconciliation_Runs": { "sheetName": "AGW_Time_Payroll_Reconciliation_Runs", "d1Table": "agw_agw_time_payroll_reconciliation_runs", "category": "payroll", "primaryCandidate": "run_id", "columnCount": 22, "columns": [ { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_Type", "d1Column": "run_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Filter", "d1Column": "employee_filter", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Count", "d1Column": "employee_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Row_Count", "d1Column": "row_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Ok_Count", "d1Column": "ok_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Warning_Count", "d1Column": "warning_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Critical_Count", "d1Column": "critical_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Total_Scheduled_Hours", "d1Column": "total_scheduled_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Attendance_Hours", "d1Column": "total_attendance_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_AGenTel_Paid_Hours", "d1Column": "total_agen_tel_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Leave_Hours", "d1Column": "total_leave_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Raw_Paid_Hours", "d1Column": "total_raw_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Payroll_Paid_Hours", "d1Column": "total_payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Variance_Hours", "d1Column": "total_variance_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Message", "d1Column": "message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_Time_Payroll_Reconciliation_Items": { "sheetName": "AGW_Time_Payroll_Reconciliation_Items", "d1Table": "agw_agw_time_payroll_reconciliation_items", "category": "payroll", "primaryCandidate": "item_id", "columnCount": 26, "columns": [ { "sheetColumn": "Item_ID", "d1Column": "item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Name", "d1Column": "employee_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Name", "d1Column": "client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_LOB", "d1Column": "client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Sub_LOB", "d1Column": "client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Scheduled_Hours", "d1Column": "scheduled_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Attendance_Hours", "d1Column": "attendance_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "AGenTel_Paid_Hours", "d1Column": "agen_tel_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Leave_Hours", "d1Column": "leave_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Raw_Paid_Hours", "d1Column": "raw_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Time_Summary_Paid_Hours", "d1Column": "time_summary_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Time_Summary_Unpaid_Hours", "d1Column": "time_summary_unpaid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Export_Paid_Hours", "d1Column": "payroll_export_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Paid_Hours", "d1Column": "payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Variance_Hours", "d1Column": "variance_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Open_Clock_Count", "d1Column": "open_clock_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Missing_Time_Summary", "d1Column": "missing_time_summary", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Missing_Payroll_Batch", "d1Column": "missing_payroll_batch", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Status", "d1Column": "status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Recommendation", "d1Column": "recommendation", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenPay_Batch_Handoff_Runs": { "sheetName": "AGW_AGenPay_Batch_Handoff_Runs", "d1Table": "agw_agw_agen_pay_batch_handoff_runs", "category": "payroll", "primaryCandidate": "run_id", "columnCount": 17, "columns": [ { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_Type", "d1Column": "run_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_Count", "d1Column": "batch_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Item_Count", "d1Column": "item_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Total_Payroll_Paid_Hours", "d1Column": "total_payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Payroll_Unpaid_Hours", "d1Column": "total_payroll_unpaid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Total_Taxable_Allowance", "d1Column": "total_taxable_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Total_Non_Taxable_Allowance", "d1Column": "total_non_taxable_allowance", "type": "REAL", "sensitive": true }, { "sheetColumn": "Total_Deductions", "d1Column": "total_deductions", "type": "REAL", "sensitive": true }, { "sheetColumn": "Target_Mode", "d1Column": "target_mode", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Spreadsheet_ID", "d1Column": "target_spreadsheet_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Sheet_Name", "d1Column": "target_sheet_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Handoff_Status", "d1Column": "handoff_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Message", "d1Column": "message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenPay_Batch_Handoff_Items": { "sheetName": "AGW_AGenPay_Batch_Handoff_Items", "d1Table": "agw_agw_agen_pay_batch_handoff_items", "category": "payroll", "primaryCandidate": "item_id", "columnCount": 36, "columns": [ { "sheetColumn": "Item_ID", "d1Column": "item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_ID", "d1Column": "batch_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_Number", "d1Column": "batch_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Summary_ID", "d1Column": "summary_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Name", "d1Column": "employee_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_Start", "d1Column": "period_start", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Period_End", "d1Column": "period_end", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Workweek_Hours", "d1Column": "workweek_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Regular_Hours", "d1Column": "regular_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Overtime_Hours", "d1Column": "overtime_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Paid_Hours", "d1Column": "payroll_paid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Payroll_Unpaid_Hours", "d1Column": "payroll_unpaid_hours", "type": "REAL", "sensitive": false }, { "sheetColumn": "Base_Salary", "d1Column": "base_salary", "type": "REAL", "sensitive": true }, { "sheetColumn": "Pay_Frequency", "d1Column": "pay_frequency", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Name", "d1Column": "client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_LOB", "d1Column": "client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Sub_LOB", "d1Column": "client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Taxable_Allowance_Total", "d1Column": "taxable_allowance_total", "type": "REAL", "sensitive": true }, { "sheetColumn": "Non_Taxable_Allowance_Total", "d1Column": "non_taxable_allowance_total", "type": "REAL", "sensitive": true }, { "sheetColumn": "Deduction_Total", "d1Column": "deduction_total", "type": "REAL", "sensitive": true }, { "sheetColumn": "Handoff_Status", "d1Column": "handoff_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_System", "d1Column": "target_system", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Record_ID", "d1Column": "target_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Raw_JSON", "d1Column": "raw_json", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Return_Status", "d1Column": "return_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Return_Run_ID", "d1Column": "return_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Return_At", "d1Column": "return_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Result_Status", "d1Column": "agen_pay_result_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Payroll_Run_ID", "d1Column": "agen_pay_payroll_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Payslip_Status", "d1Column": "agen_pay_payslip_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Payment_Status", "d1Column": "agen_pay_payment_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Disbursement_Status", "d1Column": "agen_pay_disbursement_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Exception_Message", "d1Column": "agen_pay_exception_message", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenPay_Status_Return_Runs": { "sheetName": "AGW_AGenPay_Status_Return_Runs", "d1Table": "agw_agw_agen_pay_status_return_runs", "category": "payroll", "primaryCandidate": "run_id", "columnCount": 16, "columns": [ { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_Type", "d1Column": "run_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Mode", "d1Column": "source_mode", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Spreadsheet_ID", "d1Column": "source_spreadsheet_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Sheet_Name", "d1Column": "source_sheet_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Row_Count", "d1Column": "source_row_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Matched_Count", "d1Column": "matched_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Unmatched_Count", "d1Column": "unmatched_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Updated_Batch_Count", "d1Column": "updated_batch_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Completed_Count", "d1Column": "completed_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Exception_Count", "d1Column": "exception_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Return_Status", "d1Column": "return_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Message", "d1Column": "message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenPay_Status_Return_Items": { "sheetName": "AGW_AGenPay_Status_Return_Items", "d1Table": "agw_agw_agen_pay_status_return_items", "category": "payroll", "primaryCandidate": "item_id", "columnCount": 20, "columns": [ { "sheetColumn": "Item_ID", "d1Column": "item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Row_Number", "d1Column": "source_row_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_ID", "d1Column": "batch_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Batch_Number", "d1Column": "batch_number", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Handoff_Run_ID", "d1Column": "agen_pay_handoff_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenPay_Target_Record_ID", "d1Column": "agen_pay_target_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Payroll_Run_ID", "d1Column": "payroll_run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Result_Status", "d1Column": "result_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Payslip_Status", "d1Column": "payslip_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Payment_Status", "d1Column": "payment_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Disbursement_Status", "d1Column": "disbursement_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Exception_Count", "d1Column": "exception_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Exception_Message", "d1Column": "exception_message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Processed_At", "d1Column": "processed_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Released_At", "d1Column": "released_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Match_Status", "d1Column": "match_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Update_Action", "d1Column": "update_action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Raw_JSON", "d1Column": "raw_json", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenCore_Identity_Sync_Runs": { "sheetName": "AGW_AGenCore_Identity_Sync_Runs", "d1Table": "agw_agw_agen_core_identity_sync_runs", "category": "agencore_integration", "primaryCandidate": "run_id", "columnCount": 16, "columns": [ { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_Type", "d1Column": "run_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Mode", "d1Column": "target_mode", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Spreadsheet_ID", "d1Column": "target_spreadsheet_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Sheet_Name", "d1Column": "target_sheet_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Candidate_Count", "d1Column": "candidate_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Ready_Count", "d1Column": "ready_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Warning_Count", "d1Column": "warning_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Blocked_Count", "d1Column": "blocked_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Queued_Count", "d1Column": "queued_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Pushed_Count", "d1Column": "pushed_count", "type": "INTEGER", "sensitive": false }, { "sheetColumn": "Sync_Status", "d1Column": "sync_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Message", "d1Column": "message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_By", "d1Column": "created_by", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenCore_Identity_Sync_Items": { "sheetName": "AGW_AGenCore_Identity_Sync_Items", "d1Table": "agw_agw_agen_core_identity_sync_items", "category": "agencore_integration", "primaryCandidate": "item_id", "columnCount": 24, "columns": [ { "sheetColumn": "Item_ID", "d1Column": "item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Email", "d1Column": "email", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role", "d1Column": "role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_Name", "d1Column": "employee_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employment_Status", "d1Column": "employment_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Profile_Status", "d1Column": "profile_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Department_ID", "d1Column": "department_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Team_ID", "d1Column": "team_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Name", "d1Column": "client_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_LOB", "d1Column": "client_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Client_Sub_LOB", "d1Column": "client_sub_lob", "type": "TEXT", "sensitive": false }, { "sheetColumn": "AGenCore_Identity_ID", "d1Column": "agen_core_identity_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Readiness_Status", "d1Column": "readiness_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Readiness_Issues", "d1Column": "readiness_issues", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Sync_Action", "d1Column": "sync_action", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Status", "d1Column": "target_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Record_ID", "d1Column": "target_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Payload_JSON", "d1Column": "payload_json", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" }, "AGW_AGenCore_Identity_Outbox": { "sheetName": "AGW_AGenCore_Identity_Outbox", "d1Table": "agw_agw_agen_core_identity_outbox", "category": "agencore_integration", "primaryCandidate": "outbox_id", "columnCount": 19, "columns": [ { "sheetColumn": "Outbox_ID", "d1Column": "outbox_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Run_ID", "d1Column": "run_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Item_ID", "d1Column": "item_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Event_Type", "d1Column": "event_type", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Source_Module", "d1Column": "source_module", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Employee_ID", "d1Column": "employee_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "User_ID", "d1Column": "user_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Username", "d1Column": "username", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Email", "d1Column": "email", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Role", "d1Column": "role", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Payload_JSON", "d1Column": "payload_json", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Queue_Status", "d1Column": "queue_status", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Spreadsheet_ID", "d1Column": "target_spreadsheet_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Sheet_Name", "d1Column": "target_sheet_name", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Target_Record_ID", "d1Column": "target_record_id", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Error_Message", "d1Column": "error_message", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Created_At", "d1Column": "created_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Updated_At", "d1Column": "updated_at", "type": "TEXT", "sensitive": false }, { "sheetColumn": "Pushed_At", "d1Column": "pushed_at", "type": "TEXT", "sensitive": false } ], "migrationMode": "append/import-first; constraints deferred until parity validation" } }