Change #4811

Change #4954: Bulk CR - EB140087, EB140093, EB140104, EB14109 & EB140123

EB140093:Extend Phone Number Field length

Added by Ngoh Chee Ping almost 10 years ago. Updated over 8 years ago.

Status:Closed - End of life cycleStart date:January 16, 2015
Priority:NormalDue date:May 15, 2015
Assignee:-% Done:

100%

Category:-Spent time:9.00 hours
Target version:-

CR# EB140093 - Phone Ext Length.docx (231 KB) Ngoh Chee Ping, November 13, 2014 15:59

CR# EB140093.sql (210 Bytes) Ngoh Chee Ping, December 02, 2014 15:48

NC974_CR_EB140093-ENG.doc (205 KB) Ngoh Chee Ping, January 16, 2015 17:27

CR# EB140093#1.sql (192 Bytes) Ngoh Chee Ping, January 20, 2015 14:16

History

#1 Updated by Ngoh Chee Ping almost 10 years ago

  • Due date set to November 20, 2014
  • Assignee set to Fan Hansen
  • Start date changed from November 13, 2014 to November 19, 2014

#2 Updated by Fan Hansen almost 10 years ago

  • Status changed from New - Begin Life Cycle to Finished Development
  • % Done changed from 0 to 100

Finish development and push to branch CR#EB140093

#3 Updated by Anonymous almost 10 years ago

  • Parent task set to #4954

#4 Updated by Fan Hansen almost 10 years ago

Below is the SQL script needed to modify existing tables (BIB_USER and BIB_COMPANY)

ALTER TABLE BIB_USER ALTER COLUMN OFFICE_EXT_NO VARCHAR

ALTER TABLE BIB_COMPANY ALTER COLUMN OFFICE_PHONE_EXT_NO NVARCHAR

#5 Updated by Ngoh Chee Ping almost 10 years ago

Add in sql script

#6 Updated by Ngoh Chee Ping almost 10 years ago

  • Assignee changed from Fan Hansen to Anonymous

#7 Updated by Ngoh Chee Ping over 9 years ago

  • File NC974_CR_EB140093-ENG.doc added
  • Due date changed from November 20, 2014 to January 19, 2015
  • Status changed from Finished Development to Development / Work In Progress
  • Assignee changed from Anonymous to Fan Hansen
  • Start date changed from November 19, 2014 to January 16, 2015
  • % Done changed from 100 to 0

The correct field need to change is phone no and fax no Need your help to update it The one we have done before for the extension number no need to change back. Just modify the company phone and fax number.

#8 Updated by Fan Hansen over 9 years ago

  • Status changed from Development / Work In Progress to Finished Development
  • Assignee changed from Fan Hansen to Anonymous
  • % Done changed from 0 to 100

Finished development and pushed to branch CR#EB140093

Field changed including company office no, company fax no, and user tel no.

Below is the SQL script needed to modify existing tables (BIB_USER and BIB_COMPANY):

ALTER TABLE BIB_USER ALTER COLUMN TEL_NO NVARCHAR
ALTER TABLE BIB_COMPANY ALTER COLUMN OFFICE_PHONE_NO NVARCHAR
ALTER TABLE BIB_COMPANY ALTER COLUMN OTHER_PHONE_NO NVARCHAR

#9 Updated by Ngoh Chee Ping over 9 years ago

  • File CR# EB140093#1.sql added
  • Status changed from Finished Development to System Integration Test

#10 Updated by Anonymous over 9 years ago

  • Due date changed from January 19, 2015 to May 15, 2015
  • Status changed from System Integration Test to Documentation
  • Assignee changed from Anonymous to Tan Jeng Wei

#11 Updated by Tan Jeng Wei over 9 years ago

  • Assignee changed from Tan Jeng Wei to Anonymous

Finish update document

#12 Updated by Anonymous over 8 years ago

  • Status changed from Documentation to Closed - End of life cycle

Also available in: Atom PDF