EAM Failure Codes Upload

➜ Back to Library
Description
Categories: Enginatics, Upload
Repository: Github
Create, update, and delete EAM failure codes, cause codes, and resolution codes.

Upload Mode
===========

Create
------
Opens an empty spreadsheet to define new codes.

Create, Update
--------------
Downloads existing codes for review and modification, and allows adding new rows.

Code Type
=========
Determines which of the three code tables is affecte ...  Create, update, and delete EAM failure codes, cause codes, and resolution codes.

Upload Mode
===========

Create
------
Opens an empty spreadsheet to define new codes.

Create, Update
--------------
Downloads existing codes for review and modification, and allows adding new rows.

Code Type
=========
Determines which of the three code tables is affected:
- Failure Code (stored in eam_failure_codes)
- Cause Code (stored in eam_cause_codes)
- Resolution Code (stored in eam_resolution_codes)

Codes are global - not scoped to any operating unit.

Fields
======
- Code Type: Required. Failure Code, Cause Code, or Resolution Code.
- Code: Required. Unique within its code type.
- Description: Optional.
- Effective End Date: Optional. Blank to keep the code active; set to reactivate an end-dated code.
- Delete Record: Optional. Set to Yes to delete an existing code.   more 
select
null action_,
null status_,
null message_,
null modified_columns_,
xxen_util.meaning(x.code_type,'EAM_FAILURE_CODE_TYPE',700) code_type,
x.code,
x.description,
x.effective_end_date,
to_char(null) delete_record,
x.upload_row
from
(
select
'10' code_type,
efc.failure_code code,
efc.description,
efc.effective_end_date,
rownum upload_row
from
eam_failure_codes efc
where
1=1 and
:p_upload_mode like '%' || xxen_upload.action_update and
(:p_code_type is null or :p_code_type='10')
union all
select
'20' code_type,
ecc.cause_code,
ecc.description,
ecc.effective_end_date,
rownum upload_row
from
eam_cause_codes ecc
where
1=1 and
:p_upload_mode like '%' || xxen_upload.action_update and
(:p_code_type is null or :p_code_type='20')
union all
select
'30' code_type,
erc.resolution_code,
erc.description,
erc.effective_end_date,
rownum upload_row
from
eam_resolution_codes erc
where
1=1 and
:p_upload_mode like '%' || xxen_upload.action_update and
(:p_code_type is null or :p_code_type='30')
) x
Parameter NameSQL textValidation
Upload Mode
:p_upload_mode like '%' || xxen_upload.action_update
LOV
Code Type
:p_code_type=:p_code_type
LOV
Download
Related Blitz Reports
EAM Work Orders ECC Enterprise Asset Management, Work Orders (Maintenance), SQL1 EAM Failure Sets Upload ECC Enterprise Asset Management, Work Order Assets (Maintenance) EAM Assets ECC Enterprise Asset Management, Asset Attributes (Maintenance) EAM Weekly Schedule EAM Asset Activity Association Upload EAM Senfor Intl Extrait des Ordres de Travail
Blitz Report™