Read-only and client script modifiable fields in HAM tables
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 | 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 | Fields |
|---|---|
| Hardware alm\_hardware | Failure risk score \[risk\_score\] |
Parent Topic:Hardware Asset Management reference