ECN

Process, DB details, issues.

Process
Write the first section of your page here.

Database Details
Tables:


 * EC : Holds ECN header info
 * EC_Line holds the line info (bottom half of window, used primarily for revs)
 * ECN holds approval information
 * EC_GROUP_USER lists all users involved w/group, role, leader/signoff status
 * TASK holds task records  Task ID != EC_ID


 * EC_REQUEST holds Subject


 * EC_RESPONSE holds Notes



Statuses:


 * C: Completed


 * X: Cancelled


 * I: In Process


 * P: Pending


 * H: On Hold


 * O: Open





Groups:


 * AT: Assigned To


 * A: Authorization


 * AP: Approval


 * D: Distribution


 * I: Implementation



Scripts
Status changes:


 * Select * from EC where ID = 'xxxxx'


 * Update EC set status = 'I' where ID = 'xxxxx'

Tasks:


 * Select * from TASK where TYPE = 'ECN' and EC_ID = 'xxxxx'


 * Update TASK set STATUS = ' ' where TYPE = 'ECN' and EC_ID = 'xxxxx' and SEQ_NO = '#'

Rev changes- backend override


 * Select * from EC_LINE where EC_ID = 'xxxxx'


 * Update EC_LINE set OLD_REVISION_ID = ' ' where EC_ID = 'xxxxx' and LINE_NO = ' '

*** If there are multiple revs, multiples may require change, see rev history below

Revision history- NOTE- 'xxxxx' references PART_ID, not EC_ID


 * Select * from REVISION_HISTORY where HISTORY_ID = 'xxxxx'


 * Update REVISION_HISTORY set REVISION_ID = 'zzz' where HISTORY_ID = 'xxxxx'



