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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- careers in the field of business
- dynamics 365 field mapping
- field test for methamphetamine
- us army unit symbol generator
- field supervisor job description sample
- aicpa audit sampling audit guide
- us field artillery history
- us army field artillery units
- us army field artillery regiments
- field supervisor job description duties
- field artillery us army
- us army field artillery weapons