Audit Description field symbol .us



CT_CORE_FN_AM_DESCR_SYMBL_AUDT

Purpose of Query

Audit Description field symbol '' - Locate Description field symbol '' - Query provides an audit tool for in-service asset descriptions containing the symbols ' or ''. These descriptions require updating to either remove the symbols or replace them with words.

Folder

AM

Tables

A.CTW_ASSET_COST - Asset Cost Rpt

Join D.CTW_ASSET_LOCTN - Asset Location

Join E.CTW_LOCATION_FN - Financial Location

SubQuery:

C.CTW_ASSET_COST - Asset Cost Rpt

MAX(DTTM_STAMP - Date/Time Stamp)

SubQuery:

B CTW_ASSET_RPR - Asset Repair Rpt

B.ASSET_ID exists

B.ASSET_STATUS - Asset Status in list ('I','M','A') – (In Service, Suspended, Received (Not in Service))

Note: A subquery is a query whose results are used by another query. The main query uses the subquery’s result set as a comparison value for a selection criterion.

Prompts

BUSINESS_UNIT - Business Unit= - (Equal To)

[pic]

Criteria

A.TRANS_TYPE - Action in list ('ADD','ADJ','REI','RET','TRF','RCT') – (Asset Addition, Asset Cost Adjustment, Asset Reinstatement, Asset Retirement, Asset Transfer, Asset Recategorization)

SUBQUERY – (Exists)

B.ASSET_STATUS - Asset Status in list ('I','M','A') – (In Service, Suspended, Received (Not in Service))

A.CT_ASSET_DESCR - Asset Description like %’%

OR

A.CT_ASSET_DESCR - Asset Description like %”%

Note: Runtime prompts are included as criteria.

Fields

|Col |Record.Fieldname |Format |Ord |XLAT |Agg |Heading Text |

|1 |A.BUSINESS_UNIT - Business Unit |Char5 | | | |Unit |

|2 |A.ASSET_ID - Asset Identification |Char12 | | | |Asset ID |

|3 |A.TAG_NUMBER - Tag Number |Char12 | | | |Tag Number |

|4 |A.CT_ASSET_DESCR - Asset Description |Char30 | | | |Asset Descr |

|5 |A.COST - Total Cost |SNm25.3 | | |Sum |Sum TotalCost |

|6 |D.LOCATION - Location Code |Char10 | | | |Location |

|7 |E.DESCR -Description |Char30 | | | |Location Descr |

|8 |A.PROFILE_ID - Asset Profile ID |Char10 | | | |Profile ID |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download