Variable

Action Taken

SRPAppEmail550

If encountered, acts as a trigger that causes a determination of the approver.  The system setting SLMRequestApproverQuery will be used to determine how the lookup of the approver will be performed.  If the setting is COST CENTER, then the approver will be looked up using the values that are populated (requestor's email, cost center, organization, or department) using the WFdataApprovers table.  If the setting is CONTACT, then the lookup is performed using the requestor's email via the dataContactsApprovers table.  If the setting is COST CENTER and the first query returns no records, then the additional WHERE clause syntax contained in the system setting SLMRequest2ndQuery is added to the requestor's email address to form a new WHERE clause to perform a 2nd query of the WFdataApprovers table.  In all cases the returned records are ordered by spend limit and the first record to have a spend limit over the amount of the order will be selected.  If a matching record is found, the approver's name and email are returned and automatically filled in if those fields are found in the collection of fields on the current SRP Gen II template.

SRPAssetEnt550

An HTML-formatted list of entitlements that are still active and assigned to the asset identified by the portal (having been selected or entered into the portal).  The lookup is performed using the current value of SRPWksDevID550 or Asset1550 (in that order).

SRPAssetGUID550

Returns the GUID for the asset from the ATdataAssets table.  The lookup is performed using the current value of SRPWksDevID550 or Asset1550 (in that order)

SRPAuthAsset550

Returns either the value of SRPWksDevID550 or Asset1550, whichever populated value is found first.  This variable is filled in with the returned value.

SRPAuthDevNameNew550

Returns either the value of SRPNewSvrName1550, SRPNewSvrName2550, or ComputerName550, whichever populated value is found first.  This variable is filled in with the returned value.

SRPAuthDevNameOld550

Returns either the value of SRPOldSvrName550 or ComputerName550, whichever populated value is found first.  This variable is filled in with the returned value.

SRPAuthGroup550

An HTLM-formatted list of MSL titles (publisher, title, version, units) to which the current group, as entered earlier in the Gen II SRP form, is currently authorized.  Each entry is separated by an HTML "<br>" break.  The list is meant for formatted display of titles to which the current asset is authorized.  This lookup is performed using the device name contained in either SRPWksUserGroup550 or ctLNo550 (in that order).

SRPAuthUser550

Returns the first name, followed by a space, followed by the last name of the user.  The lookup is performed using the current value of SRPWksUser550 or ctNo550 (in that order).

SRPCurrentAuthAsset550

An HTLM-formatted list of MSL titles (publisher, title, version, units) to which the current asset, as entered earlier in the Gen II SRP form, is currently authorized.  Each entry is separated by an HTML "<br>" break.  The list is meant for formatted display of titles to which the current asset is authorized.  This lookup is performed using the asset # contained in either SRPWksDevID550 or Asset1550 (in that order).

SRPCurrentAuthDevName550

An HTLM-formatted list of MSL titles (publisher, title, version, units) to which the current asset, as entered earlier in the Gen II SRP form, is currently authorized.  Each entry is separated by an HTML "<br>" break.  The list is meant for formatted display of titles to which the current asset is authorized.  This lookup is performed using the device name contained in either SRPNewSvrName1550, SRPNewSvrName2550, or ComputerName550 (in that order).

SRPCurrentAuthOldDevName550

An HTLM-formatted list of MSL titles (publisher, title, version, units) to which the current asset, as entered earlier in the Gen II SRP form, is currently authorized.  Each entry is separated by an HTML "<br>" break.  The list is meant for formatted display of titles to which the current asset is authorized.  This lookup is performed using the device name contained in either SRPOldSvrName1550 or ComputerName550 (in that order).

SRPCurrentAuthUser550

An HTLM-formatted list of MSL titles (publisher, title, version, units) to which the current user, as entered earlier in the Gen II SRP form, is currently authorized.  Each entry is separated by an HTML "<br>" break.  The list is meant for formatted display of titles to which the current asset is authorized.  This lookup is performed using the device name contained in either SRPWksUser550 or ctNo550 (in that order).

SRPDevNameNewEnt550

An HTML-formatted list of entitlements that are still active and assigned to the user identified by the portal (having been selected or entered into the portal).  The lookup is performed using the current value of SRPNewSvrName1550, SRPNewSvrName2550, or ComputerName550 (in that order).

SRPDevNameOldEnt550

An HTML-formatted list of entitlements that are still active and assigned to the user identified by the portal (having been selected or entered into the portal).  The lookup is performed using the current value of SRPOldSvrName1550 or ComputerName550 (in that order).

SRPGroupEnt550

An HTML-formatted list of entitlements that are still active and assigned to the user identified by the portal (having been selected or entered into the portal).  The lookup is performed using the current value of SRPWksUserGroup550 or ctLNo550 (in that order).

SRPMSL550

An HTML-formatted list of MSL titles that comprise all titles that are available to be requested through the Gen II SRP.  The titles must be marked as available for either workstation or server requests through the portal, and must be authorized either by device or by named user.  Each line item in the list contains the publisher, title, version, cost, and whether the request is a WORKSTATION or SERVER type of request.  In addition, the cost shown depends on the system setting SLMWhatToCharge (market or charge price).

SRPMSLnosCanPush550

If encountered, will populate the variable with a comma delimited list of mslNo values from this order where the software can be electronically pushed to the target asset.  The asset must have a GUID value and the MSL title must be defined as being able to be electronically delivered via the MSL settings.  The mslNo values returned will be only those mslNos on the current order that can be pushed electronically.

SRPMSLnosToApprove550

If encountered, will populate the variable with a comma delimited list of mslNo values from this order that require approval (if any).  The mslNo values are maintained in the current list of ordered items - this variable will cycle through that list looking for mslNos that require approval.

SRPReqEmail550

If encountered, acts as a trigger that causes a lookup of the requestor via the dataContacts table using the ctNo value (primary key value).  Usually a drop-down is presented to select the requestor and that drop-down returns the ctNo value.  This lookup is then used to populate the user's name and email address fields, if they are present on the Gen II SRP template.

SRPTitlesCanPush550

If encountered, will populate the variable with an HTLM-formatted list of titles from this order where the software can be electronically pushed to the target asset.  Each item on the list is separated by an HTML "<br>" break, and each item contains the Publisher, Title, and Version.  The asset must have a GUID value and the MSL title must be defined as being able to be electronically delivered via the MSL settings.  The titles returned will be only those titles on the current order that can be pushed electronically.

SRPTitlesCannotPush550

If encountered, will populate the variable with an HTLM-formatted list of titles from this order where the software cannot be electronically pushed to the target asset.  Each item on the list is separated by an HTML "<br>" break, and each item contains the Publisher, Title, and Version.  The asset either must not have a GUID value or the MSL title must not be defined as being able to be electronically delivered via the MSL settings.  The titles returned will be only those titles on the current order that cannot be pushed electronically.

SRPTitlesToApprove550

If encountered, will populate the variable with an HTML-formatted list of titles from this order that require approval (if any).  Each item on the list is separated by an HTML "<br>" break, and each item contains the Publisher, Title, and Version.  The titles are maintained in the current list of ordered items - this variable will cycle through that list looking for titles that require approval.

SRPUserEnt550

An HTML-formatted list of entitlements that are still active and assigned to the user identified by the portal (having been selected or entered into the portal).  The lookup is performed using the current value of SRPWksUser550 or ctNo550 (in that order).