SOP-MES0036 Generic Attribute Maintenance

Administration Generic Attribute Version MES15 Portal 1.0 Work Instruction

This Work Instruction is Sanmina's corporate standard. This document is under revision control. The latest revision is located on SanminaNet. Once printed it is an uncontrolled copy. All alterations to this work instruction require approval. Contact the IT Global Education and Training Department to submit suggested alterations and or updates.

This edition applies to MES15 Portal 1.0 and all subsequent releases and modifications until otherwise indicated in new revisions.

Introduction

This edition applies to MES 15 Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.

Administrative privileges for the Cirrus portal are located in the Administration menu heading. With the portal, Administrators are able to access privileges from one convenient location. Privileges include User Maintenance, Plant Maintenance, Site Maintenance, Profile Maintenance, and Generic Attribute Maintenance. Also located in the Administration menu heading are SFDC Administrator, Document Control, PTS Administrator, and LE Administration.

This work instruction is intended to guide administrators on how to manage and maintain the Cirrus Portal, as well as to provide specific user groups a common sense of portal operation.

To access any of the Administration functionalities, the user must sign into the Cirrus Portal and then select the Administration expandable heading located in the menu on the left of the screen.

Figure 1: User Sign-In

Figure 2: Cirrus Welcome

Generic Attributes Maintenance

The Generic Attributes module allows users to set parameters that will be used at specific MDS modules as described below.

To access the Generic Attribute Maintenance page, navigate to Administration > Generic Attribute Maintenance.

Figure 3: Generic Attribute Maintenance Main Page

The main screen displays all defined generic attributes.

Filter Generic Attributes

The user can filter the results by Table and Attribute Name.

1. Enter the Table or Attribute Name in the appropriate field.

2. Select Filter to filter results or Clear to clear the filter fields.

(NOTE: The user can sort the columns alphabetically by clicking on the Table, Attribute Name or Value fields.)

Figure 4: Filter Results

Add Generic Attribute

1. To add a Generic Attribute, select Add Generic Attribute located above the generic attribute list.

2. The Generic Attribute Form is displayed:

Figure 5: Add Generic Attribute

3. Select a Table and Attribute Name from the drop-down boxes in the form.

4. Enter a value in the Value field.

5. Select Save to confirm, Reset to clear fields, or Cancel to exit the form.

Editing Generic Attribute

1. To edit a Generic Attribute, select Edit Generic Attribute located above the list of Generic Attributes.

2. The Generic Attribute Form is displayed:

Figure 6: Edit Generic Attribute

NOTE: The user is only able to edit the attribute value. The other fields are not available to be edited.

Generic Attributes Descriptions

See below for Generic Attributes descriptions:

A

add_log_incomplete_container

Table: Project

Description: set if is allowed to log some reason/information when an incomplete container is closing.

Default Value: the default value is NO.

Module: this generic attribute is used in the Muli-Level Containerization module.

Functionality: containerization

System Configuration: NO

ato_so_order_number

Table: shop_order

Description: ato_so_order_number

Default Value: FALSE

Module: N/A

Functionality: N/A

System Configuration: N/A

C

ctr_export_ftp_dir

Table: Project

Description: it is the directory where the exported container file will be stored.

Default Value: N/A

Module: this generic attribute is used in the Multi-Level Containerization Browser.

Functionality: this generic attribute is used in the Export Container and Export Filtered Containers.

System Configuration: N/A

ctr_export_ftp_password

Table: Project

Description: it is the password authentication to access the server where the exported container file will be stored. Multi-Level

Default Value: N/A

Module: this generic attribute is used in the Multi-Level Containerization Browser

Functionality: export Container and Export Filtered Containers

System Configuration: N/A

ctr_export_ftp_server

Table: Project

Description: it is the server address where the exported container file will be stored.

Default Value:

Module: this generic attribute is used in the Multi-Level Containerization Browser

Functionality: export container and export filtered Containers

System Configuration: N/A

ctr_export_ftp_user

Table: Project

Description: it is the user authentication to access the server where the exported container file will be stored.

Default Value: N/A

Module: this generic attribute is used in the Multi-Level Containerization Browser

Functionality: export container and export filtered containers

System Configuration: N/A

customer_part_number

Table: shop_order

Description: 150512

Default Value: FALSE

Module: N/A

Functionality: N/A

System Configuration: N/A

D

define_usl_on_release

Table: Project

Description: set if is allowed to define the Unit Started Location to the serials when release Shop Order.

Default Value: N/A

Module: this generic attribute is used in the "Shop Order Release"

Functionality: N/A

System Configuration: N/A

F

frus_child_ctr_export

Table: Project

Description: N/A

Default Value: YES

Module: N/A

Functionality: N/A

System Configuration: N/A

K

kit_complete

Table: Project

Description: it forces the user to do the kit with all Top Level Assemblies at the same time.

Default Value: NO

Module: this generic attribute is used in the Kit Verify

Functionality: kit consolidation

System Configuration: NO

kit_genband_enabled

Table: Project

Description: set if is possible work in Kit verify modules with GenBand project.

Default Value: NO

Module: this generic attribute is used in the Kit Verify

Functionality: kit verify functionalities (Kit Consolidation/Work)

System Configuration: NO

kit_genband_files_path

Table: Project

Description: it is the path of the folder where is stored the genband files.

Default Value: N/A

Module: this generic attribute is used in the Kit Verify

Functionality: kit verify functionalities (Kit Consolidation/Work)

System Configuration: N/A

L

label_engine_context

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_MDS_active

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_port

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_server

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_token_JMDS

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

label_engine_token_SFDC

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the SO / Container

Functionality: print label

System Configuration: TRUE

labor_tracking_database_name

Table: Project

Description: Labor Tracking modules access a PostgresSQL database, and then jMDS needs to know which database access.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: to have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_password

Table: Project

Description: It is the password to access Labor Tracking database.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: To have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_port

Table: Project

Description: it is the number of the Labor Tracking server port.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: to have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_server

Table: Project

Description: it is the Labor Tracking database server address.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: To have access to all Labor Tracking functionalities

System Configuration: N/A

labor_tracking_user

Table: Project

Description: it is the user to access Labor Tracking database.

Default Value: N/A

Module: this generic attribute is used in the Labor Tracking Maintenance

Functionality: To have access to all Labor Tracking functionalities

System Configuration: N/A

N

next_sokey

Table: shop_order

Description: 695770

Default Value: FALSE

Module: this generic attribute is used in the Shop Order

Functionality: N/A

System Configuration: N/A

O

order_line_qty_chk_warning

Table: Project

Description: set if the Sales Order Line quantity of units assigned can exceed or not.

Default Value: N/A

Module: N/A

Functionality: N/A

System Configuration: N/A

original_part_number

Table: shop_order

Description: 150512

Default Value: FALSE

Module: N/A

Functionality: N/A

System Configuration: N/A

P

part_bom_description_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Part Number Description information (this position starts in 1), and in the mask field (attr_data) should be informed the name header of this column.

Default Value: 3, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number.

System Configuration: N/A

part_bom_part_number_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Part Number Description information (the position starts in 1), and in the mask field (attr_data) should be informed the name header of this column.

Default Value: 2, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_bom_quantity_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the item quantity information (the position starts in 1), and in the mask field (attr_data) should be informed the name header of this column.

Default Value: 6, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_bom_reference_designator_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Reference Designator information to the item (this position starts in 1), and in the mask field(attr_data) should be informed the name header of this column.

Default Value: 7. FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_bom_revision_column

Table: Project

Description: it’s the position of the column into the file used to load a BOM for a Part Number, which have the Revision information of the item (this position starts in 1), and in the mask field attr_data) should be informed the name header of this column.

Default Value: 4, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: To load a BOM structure for the Part Number

System Configuration: N/A

part_opportunities_joint_errors_column

Table: Project

Description: it’s the position of the column into the file used to load Defect Opportunities for a Part Number, which have the Joint Errors information of the Reference Designator for the item (this position starts in 1), and in the mask field(attr_data) should be informed the name header of this column.

Default Value: 7, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: to load Defect Opportunities for the Part Number.

System Configuration: N/A

part_opportunities_process_column

Description: it’s the position of the column into the file used to load Defect Opportunities for a Part Number, which have the Process information of the Reference Designator for the item (this position starts in 1), and in the mask field(attr_data) should be informed the name header of this column.

Default Value: 9, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: to load Defect Opportunities for the Part Number.

System Configuration: N/A

part_opportunities_reference_designator_column

Table: Project

Description: it’s the position of the column into the file used to load Defect Opportunities for a Part Number, which have Reference Designator for the item (this position starts in 1), and in the mask field (attr_data) should be informed the name header of this column

Default Value: 4, FALSE

Module: this generic attribute is used in the Part Number Maintenance

Functionality: to load Defect Opportunities for the Part Number.

System Configuration: N/A

print_current_released

Table: Project

Description: set if is allowed to print the currently released Serial Number or all released

Default Value: YES

Module: this generic attribute is used in the Shop Order

Functionality: release – export serials to a file

System Configuration: N/A

print_label_log_on

Table: Project

Description: N/A

Default Value: NO

Module: N/A

Functionality: print label (labelfmt_v3_buffer)

System Configuration: FALSE

print_label_log_verbose

Table: Project

Description: N/A

Default Value: NO

Module: N/A

Functionality: print label (labelfmt_v3_buffer)

System Configuration: FALSE

Q

quantity

Table: Project

Description: N/A

Default Value: FALSE

Module: this generic attribute is used in the SFDC GUI

Functionality: configure Record and repair defects

System Configuration: N/A

R

recursive_ctr_export

Table: Project

Description: Set if will be exported only units inside the first level of the Container or all the units inside the Containers child will be exported too.

Default Value: NO

Module: this generic attribute is used in the Containerization Browse

Functionality: export container and export filtered containers

System Configuration: FALSE

reference_designator

Table: Project

Description: N/A

Default Value: TRUE

Module: this generic attribute is used in the SFDC GUI

Functionality: configure Record and repair defects

System Configuration: N/A

release_sn_block_delay

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the

Functionality: N/A

System Configuration: TRUE

release_sn_block_size

Table: Project

Description: N/A

Default Value: N/A

Module: this generic attribute is used in the

Functionality: N/A

System Configuration: FALSE

remove_on_hold_log

Table: Project

Description: set if when a rule is removed from the Hold is forced to log it.

Default Value: NO

Module: this generic attribute is used in the Mfg Hold

Functionality: Release a hold

System Configuration: FALSE

repair_code

Table: Project

Description: N/A

Default Value: FALSE

Module: this generic attribute is used in the SFDC GUI

Functionality: configure Record and repair defects

System Configuration: N/A

revision_controlled

Table: Project

Description: N/A

Default Value: 1

Module: this generic attribute is used in the Shop Order

Functionality: info

System Configuration: TRUE

S

so_control_help_link

Table: Project

Description: it is the link to Shop Order Control Usage page

Default Value: N/A

Module: this generic attribute is used in the Shop Order Release/Browser

Functionality: help area inside Shop Order Browse main screen and also inside Shop Order View screen

System Configuration: TRUE

so_linkage_active

Table: Project

Description: set if is allowed to link Shop Orders

Default Value: YES

Module: this generic attribute is used in the Shop Order Release/Browser

Functionality: release moment and Shop Order View screen

System Configuration: TRUE

soms_mes_web_address

Table: Project

Description: N/A

Default Value: NO

Module: this generic attribute is used in the Shop Oder

Functionality: SO Linkage

System Configuration: SO Linkage

spcparam_putonhold_available

Table: Project

Description: set if skeleton units must be created or not

Default Value: N/A

Module: N/A

Functionality: N/A

System Configuration: N/A

T

traceability_warning

Table: Project

Description: N/A

Default Value: YES

Module: this generic attribute is used in the Shop Order

Functionality: traceability check;

System Configuration: N/A

U

update_pts_data

Table: Project

Description: N/A

Default Value: NO

Module: this generic attribute is used in the SIT

Functionality: SIT Range maintenance

System Configuration: N/A

Document Revision History

Date	Author	Title	Version	Change Reference
02/14/14	Elaine Fonaro	Technical Writer	v 1.0	This is the first revision of Generic Attribute User Guide.
02/14/14	Ashley Martin	Technical Writer	v 1.0	General Review and New Images
02/24/14	Elaine Fonaro	Technical Writer	v 1.0	Formatting for WIKI