ATTACHMENT8BusinessRules.docx

ATTACHMENT 8

Business Rules image1.emf

New Business Rules R8 15 Mar 2011.docx

Business Rules

Who:

Action:

Response

Status:

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

PCMS Business Rule

a) We need the following attributes from Haystack for each record to run business rules to auto tag blank SMR codes.

· Is the part stock listed (is it in Haystack)

· RC attribute (Repair Code)

· AAC attribute (Acquisition Advise Code)

· SLC attribute (Shelf Life Code)

b) Attributes that would be helpful to the ES/Heavy clean-up team are:

· Price

· Procurement History

· Source of Supply

Closed with Possible re-opening (HQ AFMC/A4NE Will re-open Will re-open via FY10 Data Profiling Task) to help drive down costs)

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

PCMS SMR Code Business Rule for Inserted Records

Were new lines are created; PCMS should recommend SMR code from parent line when part numbers are the same.

· When part numbers are not the same

· See if it is a cataloged item (has an AAC) if yes set first two digits to (PA)

· If (PA) third position should be set to third position of parent item

· ERRC code, if same as parent, 4th and 5th position should follow same (Z).

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

PCMS SMR Code Business Rule for Stock Listed Parts

· If Stock listed 1st position is (P)

· If

· Acq Advice Code = (Z) then Second position is (B)

· If Shelf life code >0 = Second position is C.

· For all other cases2nd position defaults to (A)

· If RC in Haystack = N then (ZZ) for 4th and 5th positions

· If RC in Haystack = T then (DD) for 4th and 5th positions

If position 1&2 are determined to be PA and if RC code equals P then set third position to O.

If NHA has the third position as D then make the third position D as well.

PCMS should establish “?” in 3rd position in SMR code if unable to determine position from above business rules. This is a sign that heavy clean up team has to investigate.

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

PCMS Business Rule (Non-Stock Listed Item)

1) If non-stock listed part has children which are stock listed then set 1st position of SMR code to A. Also set position 2 ,3,4,& 5 to match 2 - 5 positions of children.

2) If non stock listed and no stock listed children or no children, then 1st position of SMR code is (X) and 2nd position is (?).

Note: When checking 2-5 positions of Children BR should check to see if all children SMR codes match. If certain positions do not match across all children insert a “?” in that position for the parent. Example constructed parent SMR Code AO??T

Wallin, Jimmie R Civ USAF AFMC OC-ALC/ENSN

Business Rule

ECP/MOD impacting PLM IPB cleansing activities and sustainment. What actions need to be implemented at Tinker to ensure data is delivered in support of PCMS/IPB sustainment.

OO-ALC, WR-ALC and OC-ALC PLM POC’s

ECP/MOD impacting PLM IPB cleansing activities and sustainment. HQ AFMC/A4NE request new IPB’s developed in support of ECP’s/MOD’s be run thru PCMS tools at 70%/80% IPR.

oo-alc, wr-alc, and oc-alc plm poc’s

Business Rule

During heavy clean up team processing, requirement is to update IPB E.S. code (to include name, phone number, email address and organization)

Pickl, William G Civ USAF AFMC HQ AFMC/A4NE

Business Process Impact

PDM-Gateway access for heavy clean up teams at the centers. HQ PLM focal point to work with HQ STINFO focal point to resolve the issue of heavy clean up contractor teams not being able to gain access to PDM-Gateway. Impacts IPB cleansing activities.

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

Business Process

HQ AFMC/A4NE request PCMS program office run a report to capture all commercial level IPB’s.

15,500 C.M. report ran across JCALS

520 C.M. at Tinker Identified

OO-ALC, WR-ALC and OC-ALC PLM POC’s

Business Rule Commercial Manuals.

Commercial manual which have organic workload (current or planned) require cleansing. Commercial manuals with no organic workload do not cleansing or loading manual.

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

Business Process Impact

Add and populate AAC attribute to IPB metadata for the top level indenture part.

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

Business Rule AAC

Tag all parts that have AAC codes of P, T, V or Y. Parts should have either FMS (code P), Condemned (code T) or Terminal (code V or Y) inserted as a recommended add to the annotation field.

oo-alc, wr-alc and oc-alc plm poc’s

Heavy Cleanup Rule

Teams should review all parts with AAC of P, T, V, or Y and recommend either deleting part from IPB or retaining with corresponding TAG in annotation field in order to load these records into PLM as FMS parts or obsolete parts.

oo-alc, wr-alc and oc-alc plm poc’s

Business Rule

LH, RH, LH Only, RH Only, (LH), (RH), (LH Only) or (RH Only) in the description block. Reference: PLM Data Vault Planning and Migration Support Business Rules and Procedures V 2.0 document.

Heavy Clean up team is to normalize during manual clean up. Area of interest is indentured parts (is this an issue).

Howard, Erika L Civ USAF AFMC WR-ALC/ENGLDA

Heavy clean-up report should tag varieties of left hand and right hand notation with a standard recommendation for LH RH notation.

oo-alc, wr-alc and oc-alc plm poc’s

Heavy clean-up teams will review with ES all IPBs whose top level has an AAC of either P, T, V, or Y to make sure the book should be cleaned and captured by ECSS

OC-ALC ADDED TO BUSINESS RULES 15 dEC 2010. lTR TO CONTRACTOR 15 dEC 2010 ABOUT afto 252 Deliverables.

oo-alc, wr-alc and oc-alc plm poc’s

IPB Heavy Clean Up tool Utilization.

https://org.eis.afmc.af.mil/sites/FOWRALC/en/ENG/ENGL/pcms/Deliverables/Forms/AllItems.aspx

OC-ALC ADDED TO BUSINESS RULES 22 dEC 2010. lTR TO CONTRACTOR 22 dEC 2010.

oc-alc plm poc’s

Check IPB being cleansed DART report to ensure IPB is current and DART report is current

OC-ALC ADDED TO BUSINESS RULES 22 dEC 2010. lTR TO CONTRACTOR 22 dEC 2010.

oc-alc & OO-ALC& WR-ALC plm poc’s

OC-ALC added AFTO 22 business rule tracking 6 Jan 2011 oc-alc & OO-ALC& WR-ALC plm poc’s

1. AFTO 252 in support of PLM IPB cleansing activities processed in accordance with the following business rule. Reference Technical Order 00-5-3 (attached).

Reference T.O. 00-5-3, section 12.2.7.4. When discrepancies are detected during the ECSS data vault construction effort (mining existing IPBs to build the Bill of Materials [BOM] for weapon systems, components and equipment), they will be documented on AFTO Forms 252 with LCNs beginning with four (4). This will allow tracking these discrepancies apart from other TO issues.

OC-ALC added AFTO 22 business rule tracking 15 Dec 2010 oc-alc & OO-ALC& WR-ALC plm poc’s

AF Form 3925 (Engineering Order), & AF Form 3927 (Engineering Order – Parts List Changes) shall be utilized to identify engieering drawing issues for PLM IPB Cleansing process. Cleansing contractor shall submit documents as part of cleansing package.

OC-ALC added AF Forms 3925 & 3927 to cuurent contract and IDIQ contract requirements and buisness rule

Ltr to contracting on current contract 14 Jan 2011 & IDIQ contract draft documents updated 14 Jan 2011 oc-alc & OO-ALC& WR-ALC plm poc’s

1. Identify commodity/weapon system IPB’s that will still be in service Feb 2016.

2. HQ AFMC/A4NE identified capture everything in the short term in PCMS, do not cleanse IPB’s going out of inventory on/or before Feb 2016.

HQ AFMC/A4ne Identified Feb 2011

OC-ALC, OO-ALC and WR-ALC

Business rule to add to the PCMS data profiling will be to identify any part# that has more than one NIIN associated to it. HQ AFMC/A4N has identified it is okay for a NIIN to have multiple parts, but the reverse will not load into ECSS

HQ AFMC/A4NE Identfied March 2011 image1.emf

Microsoft_Office_Word_Document1.docx

a) USAF has made a business rule to utilize the same logic/process for AFTO 22 PLM tracking.

b) Request all AFTO 22 submitted in support of PLM IPB cleansing begin with four (4) for tracking requirements.

c) Example of O&M funded PLM IPB cleaning requirements AFTO 22 tracking number : 41MOCENSN10001

d) Example of SMAG funded PLM IPB cleansing requirement AFTO 22 tracking number:

41M848SCM12001

e) Position Description is as follows;

· Position 1 – “4” for DCC

· Positions 2-3 – “1M” for AFMC

· Positions 4-9 – Office Symbol

· Positions 10-11 – Last 2 digits of calendar year

· Positions 12-14 – Sequential numbers

f) In case we run across IPB in work that belongs to OO-ALC (Hill AFB) or WR-ALC (Robins AFB) the following information is provided;

O&M SMAG

Hill AFB 41MOOENSD12001 41M78SCM12001

Robins AFB 41MWRENGL12001 41M638SCM12001