Read-only and client script modifiable fields in HAM tables

  • Release version: Australia
  • Updated March 12, 2026
  • 6 minutes to read

    • Comprehensive reference of HAM table fields that are restricted from UI editing and those which can be modified using client scripts.

    Strict read-only fields in HAM tables

    Table 1. Strict read-only field details
    Table Fields

    Asset

    [alm_asset]
    • Audit number [audit_number]
    • Audit type [audit_type]
    • Audited by [audited_by]
    • Disposal order number [disposal_order_number]
    • Last audit date [last_audit_date]
    • Last audit state [last_audit_state]
    • Process ID [process_id]
    • Process table [process_table]
    • Refresh request line [refresh_request_line]
    • Attestation number [attestation_number]
    • Attested by [attested_by]
    • Last attestation date [last_attestation_date]
    • Last attestation state [last_attestation_state]
    • Disposal order number [sn_itam_common_disposal_order_number]

    Asset Covered

    [clm_m2m_contract_asset]
    • Flow context [flow_context]
    • Extension contract [lease_extension_contract]
    • Purchase order line [po_line_item]
    • Stage [stage]

    Consumable Model Lifecycle

    [cmdb_consumable_model_lifecycle]

    		 Content active [content_active_status]

    Consumable Model

    [cmdb_consumable_product_model]
    • License opt in [norm_license_opt_in]
    • Normalization combination [normalized_combination]
    • Normalized date [normalized_date]
    • Normalization hash 1 [normalized_hash1]
    • Normalization hash 2 [normalized_hash2]
    • Normalization hash 3 [normalized_hash3]
    • Normalization hash 4 [normalized_hash4]
    • Normalization rule [normalized_rule]
    • Normalized rule table [normalized_rule_table]
    • Normalization status [normalized_status]
    • Normalization status summary [normalized_status_summary]

    Hardware Model Lifecycle

    [cmdb_hardware_model_lifecycle]

    		 Content active [content_active_status]

    Hardware Model

    [cmdb_hardware_product_model]
    • License opt in [norm_license_opt_in]
    • Normalization combination [normalized_combination]
    • Normalized date [normalized_date]
    • Normalization hash 1 [normalized_hash1]
    • Normalization hash 2 [normalized_hash2]
    • Normalization hash 3 [normalized_hash3]
    • Normalization hash 4 [normalized_hash4]
    • Normalization rule [normalized_rule]
    • Normalized rule table [normalized_rule_table]
    • Normalization status [normalized_status]
    • Normalization status summary [normalized_status_summary]

    Product Model

    [cmdb_model]
    • Norm Status Sumry Function [norm_status_sumry_function]
    • TRM product phase [trm_product_phase]

    Model Category

    [cmdb_model_category]

    		 Resource category [resource_category]

    Asset Audits

    [sn_hamp_asset_audit]
    • Audit number [audit_number]
    • Excluded from HAM [excluded]
    • Scanned and expected [expected]
    • New [new]
    • Scanned and not expected [not_expected]
    • Expected and not found [not_found]
    • Scan date [scan_date]
    • Status [status]

    Hardware Asset Reclamation Line

    [sn_hamp_asset_reclaim_line]
    • Asset [asset]
    • Asset reclamation request [asset_reclaim_request]
    • Flow context [flow_context]
    • Number [number]
    • Stage [stage]

    Hardware Asset Reclamation Task

    [sn_hamp_asset_reclaim_task]
    • Hardware asset reclamation line [asset_reclaim_line]
    • Start date [start_date]
    • Task name [task_name]

    Asset RMA Task

    [sn_hamp_asset_rma_task]
    • RMA request line [rma_request_line]
    • Task name [task_name]

    Hardware Disposal Order

    [sn_hamp_hardware_disposal]
    • Number [number]
    • Stage [stage]

    Hardware Disposal Tasks

    [sn_hamp_hw_asset_disposal_task]
    • Departed [departed_assets]
    • Expected [expected_assets]
    • Not departed [not_departed_assets]
    • Not verified [not_verified_assets]
    • Substate [substate]
    • Task name [task_name]
    • Verified [verified_assets]

    Device Type

    [sn_hamp_hw_device_type]
    • Stage active [stage_active]
    • Stage description [stage_description]
    • Stage name [stage_name]
    • Stage UNSPSC commodity ID [stage_unspsc_commodity_id]
    • Class [sys_class_name]

    Hardware Manufacturer

    [sn_hamp_hw_manufacturer]
    • Name [name]
    • Stage active [stage_active]
    • Stage description [stage_description]
    • Stage name [stage_name]
    • Stage webpage [stage_webpage]
    • Class [sys_class_name]
    • Webpage [webpage]

    Hardware Normalization Map

    [sn_hamp_hw_normalization_map]
    • Hash [hash]
    • Product [hw_product]
    • Product model [hw_product_model]
    • Class [sys_class_name]

    Hardware Product

    [sn_hamp_hw_product]
    • Stage active [stage_active]
    • Stage description [stage_description]
    • Stage device type [stage_device_type]
    • Stage manufacturer [stage_hw_manufacturer]
    • Stage name [stage_name]
    • Class [sys_class_name]

    Hardware Model Library

    [sn_hamp_hw_product_model]
    • Stage active [stage_active]
    • Stage description [stage_description]
    • Stage product [stage_hw_product]
    • Stage model number [stage_model_number]
    • Stage name [stage_name]
    • Class [sys_class_name]

    Hardware Asset Refresh Line

    [sn_hamp_hw_refresh_line]
    • Flow context [flow_context]
    • Number [number]
    • Replacement model [replacement_model]
    • Request item [request_item]
    • Stage [stage]

    Refresh Line Tasks

    [sn_hamp_hw_refresh_line_task]

    		 Replacement model [replacement_model]

    HAMP Import File

    [sn_hamp_import_file]
    • Details [details]
    • File name [file_name]
    • Status [status]

    Hardware Lifecycle Definition

    [sn_hamp_lifecycle_definition]
    • Product model [hw_product_model]
    • Lifecycle code [lifecycle_code]
    • Lifecycle phase [lifecycle_phase]
    • Phase start date [start_date]
    • Class [sys_class_name]

    Loaner Asset Order

    [sn_hamp_loaner_asset_order]
    • Asset Prepared [asset_prepared]
    • Flow context [flow_context]
    • Justification [justification]
    • Lead Time [lead_time]
    • Loaner order status [loaner_order_status]
    • Preparation start date [preparation_start_date]
    • Request type [request_type]
    • Return Date [return_date]
    • Stage [stage]
    • Start Date [start_date]

    Audits to Scanned Assets

    [sn_hamp_m2m_audit_asset]
    • Asset [asset]
    • Asset audit [asset_audit]
    • Audit status [audit_status]

    Planned Assets

    [sn_hamp_m2m_hw_asset_disposal]
    • Scanned [depart_scanned]
    • Hardware disposal order [hardware_disposal]
    • Stage [stage]
    • Scanned [verify_scanned]

    Replacement Models

    [sn_hamp_m2m_ztr_replacement_model]

    		 Zero touch refresh model [refresh_model]

    Manage Hardware Library

    [sn_hamp_manage_hw_library]

    		 Status [status]

    HAM Maturity Content

    [sn_hamp_maturity_content]
    • Staging type [stage_type]
    • Type [type]

    HAM Maturity Item

    [sn_hamp_maturity_item]

    		 Type [type]

    Model Category Normalization Summary

    [sn_hamp_model_ctg_norm_summary]

    		 Model category [model_category]
    sn_hamp_provider_task_mapping Status [status]

    HAM Resource Category

    [sn_hamp_resource_category]
    • Opt in [opt_in]
    • Resource Category [resource_category]
    • Schedule item [schedule_item]
    • Subscription unit ratio [su_ratio]

    RMA Request

    [sn_hamp_rma_request]
    • Flow context [flow_context]
    • Number [number]
    • Stage [stage]
    • State [state]

    RMA Request Line

    [sn_hamp_rma_request_line]
    • Asset [asset]
    • Flow context [flow_context]
    • Model [model]
    • Number [number]
    • Quantity [quantity]
    • RMA request [rma_request]
    • Stage [stage]

    Zero touch request task

    [sn_hamp_zero_touch_request_task]
    • Number [number]
    • Task name [task_name]
    • Zero touch request [zero_touch_request]

    Zero Touch Refresh Request

    [sn_hamp_ztr_request]
    • Asset [asset]
    • City [city]
    • Country [country]
    • Email address [email]
    • Zero touch refresh fulfillment request [fulfillment_request]
    • Mobile number [mobile]
    • Name [name]
    • Number [number]
    • Order state [order_state]
    • Provider [provider]
    • Refresh method [refresh_method]
    • Replacement model [replacement_model]
    • Requested for [requested_for]
    • Return stockroom [return_stockroom]
    • RMA request [rma_request]
    • Stage [stage]
    • State [state]
    • State/Province [state_loc]
    • Street [street]
    • Zip/Postal code [zip]

    Zero Touch Refresh Task

    [sn_hamp_ztr_task]
    • Number [number]
    • Substate [substate]
    • task name [task_name]
    • Zero touch refresh request [zero_touch_req]

    Zero Touch Refresh Fulfillment Request

    [sn_itam_ztr_fulfillment_req]

    		 Provider [provider]

    Pallet

    [alm_pallet]

    		 Number [pallet_number]

    Transfer Order Line Task

    [alm_transfer_order_line_task]

    		 Substate [substate]

    Asset Task

    [asset_task]

    		 DaaS account [daas_account]

    Contract

    [ast_contract]
    • Flow context [cmn_flow_context]
    • Process ID [process_id]
    • Process table [process_table]
    • Substate [substate]

    Contract History

    [clm_contract_history]
    • Previous contract ends [previous_contract_ends]
    • Previous contract Id [previous_contract_id]
    • Previous contract starts [previous_contract_starts]
    • Renewal date [renewal_date]

    Model Lifecycle

    [cmdb_model_lifecycle]
    • Lifecycle code [lifecycle_code]
    • Source [source]
    itam_aia_log
    • AI agent feature [aia_feature]
    • Number [number]
    • Source [source]
    • Source table [source_table]
    • Domain [sys_domain]
    • User [user]

    Purchase Order

    [proc_po]
    • Purchase order type [purchase_order_type]
    • Source ID [source_id]
    • Source table [source_table]
    • PO type [po_type]

    Purchase order line items

    [proc_po_item]
    • Source ID [source_id]
    • Source table [source_table]

    Contract Renewal Request

    [sn_contract_renewal_request]
    • Approval [approval]
    • Approval history [approval_history]
    • Contract [contract]
    • Flow context [flow_context]
    • Number [number]
    • Stage [stage]
    • State [state]

    Contract Renewal Request Line

    [sn_contract_renewal_request_line]
    • Contract [contract]
    • Contract administrator [contract_administrator]
    • Applicable taxes [contract_applicable_taxes]
    • Contract approver [contract_approver]
    • End date [contract_ends]
    • Invoice payment terms [contract_invoice_payment_terms]
    • Payment amount [contract_payment_amount]
    • Payment schedule [contract_payment_schedule]
    • Options [contract_renewal_options]
    • Contract renewal request [contract_renewal_request]
    • Name [contract_short_description]
    • Start date [contract_starts]
    • Tax cost [contract_tax_cost]
    • Effective tax rate[contract_tax_rate]
    • Total cost [contract_total_cost]
    • Flow context [flow_context]
    • Number [number]
    • Renewal contract [renewal_contract]
    • Stage [stage]
    • State [state]
    • Contract number [vendor_contract]

    Contract Renewal Task

    [sn_contract_renewal_task]
    • Contract renewal request [contract_renewal_request]
    • Contract renewal request line [contract_renewal_request_line]
    • Renewal approver [renewal_approver]
    • Renewal contract [renewal_contract]
    • Task name [task_name]
    sn_daas_common_rma_response_orderline
    • Flow context [flow_context]
    • Shipment order [shipment_order]
    • Stage [stage]

    Carrier Integration Profile

    [sn_itam_carrier_int_profile]

    		 Job [job]

    Import asset data rows

    [sn_itam_cmn_import_asset_row]
    • Asset [asset_id]
    • Model [model_id]
    • Status [status]

    Asset attestation

    [sn_itam_common_asset_attestation]
    • Attestation number [attestation_number]
    • Requested by [requested_by]
    • Schedule [schedule]
    • Submission date [submission_date]
    • Domain [sys_domain]
    • Table [table]

    Asset Audits

    [sn_itam_common_asset_audit]

    		 Audit number [audit_number]

    Asset remediation task

    [sn_itam_common_asset_rmdt_task]

    		 Task name [task_name]

    Asset Warranty

    [sn_itam_common_asset_warranty]
    • Active [active]
    • Asset [asset]
    • Country [country]
    • Description [description]
    • End date [end_date]
    • External warranty ID [external_warranty_id]
    • Name [name]
    • Start date [start_date]
    • Status [status]
    • Type [type]

    Attestations for asset

    [sn_itam_common_attestation_asset_m2m]
    • Asset [asset]
    • Asset attestation [attestation]
    • Attestation date [attestation_date]
    • Domain [sys_domain]
    • User [user]

    Asset attestation schedule

    [sn_itam_common_attestation_schedule]
    • Requested by [requested_by]
    • Schedule number [schedule_number]
    • Domain [sys_domain]
    • Table [table]

    Calculated Lifecycle formula

    [sn_itam_common_calc_lc_formula]

    		 Name [name]

    Asset Donation Order

    [sn_itam_common_donation_order]
    • Number [number]
    • Stage [stage]

    Asset Donation Task

    [sn_itam_common_donation_task]
    • Departed [departed_assets]
    • Expected [expected_assets]
    • Not departed [not_departed_assets]
    • Substate [substate]
    • Task name [task_name]
    sn_itam_common_inbound_asset_order
    • Source order [source_order]
    • Source order table [source_order_table]
    sn_itam_common_inbound_asset_orderline
    • Flow context [flow_context]
    • Shipment order [shipment_order]
    • Stage [stage]

    Lifecycle Code

    [sn_itam_common_lifecycle_code]
    • Code [code]
    • Long description [long_description]
    • Short description [short_description]

    Planned Assets

    [sn_itam_common_m2m_ast_donation]
    • Asset donation order [asset_donation_order]
    • Stage [stage]

    Shipment line

    [sn_itam_common_m2m_shipment_asset]
    • Alert [alert]
    • Stage [asset_stage]

    Stockroom Distribution Channel

    [sn_itam_common_m2m_stockroom_channel]

    		 Function [function]

    Asset prepare task

    [sn_itam_common_prepare_task]

    		 Task name [task_name]
    Asset put away task [sn_itam_common_put_away_task] Task name [task_name]

    Import asset data

    [sn_itam_common_receive_import]
    • Number of rows with errors [rows_errors]
    • Number of rows processed [rows_processed]
    • Number of rows ready to be received [rows_ready]
    • Number of rows successful [rows_successful]
    • Status [status]

    Schedule task

    [sn_itam_common_schedule_task]

    		 Task name [task_name]

    Asset selection task

    [sn_itam_common_selection_task]

    		 Task name [task_name]

    Asset ship task

    [sn_itam_common_ship_task]
    • Shipment order [shipment_order]
    • Task name [task_name]

    Shipment

    [sn_itam_common_shipment]
    • Shipment number [shipment_number]
    • Stage [stage]
    • Shipment quantity [shipment_quantity]

    Shipping Carrier

    [sn_itam_common_shipping_carrier]

    		 Profile mapped date [profile_mapped_date]

    Renewal contracts

    [sn_m2m_renewal_contract]

    		 Renewal task [renewal_task]

    Client script modifiable fields in HAM tables

    Table 2. Client script modifiable fields
    Table Fields

    Hardware

    alm_hardware

    		 Failure risk score [risk_score]