Support Center Schema - 8 series

Support Center Schema - 8 series

To populate the WorkOrder/Request information, the tables that need tobe populated are :
  • WorkOrder
  • WorkOrderStates
  • WorkOrder_Threaded
  • WorkOrderToDescription
  • WorkOrder_Fields (If there are any WorkOrder Addl Fields)
To map Account and SubAccount to a WorkOrder/Request :
  • WorkOrder_Account
To map Contract to a WorkOrder/Request :
  • WorkOrder_ServiceCTR

To populate the Contact information, the tables used are :
  • AaaUser
  • SDUser (Check the Status Field. Should be set to ACTIVE)
To populate the SupportRep information, the tables used are :
  • AaaUser
  • SDUser
  • HelpDeskCrew
To populate the Account Manager information, the tables used are :
  • AaaUser
  • SDUser
  • Account_Manager

To populate the Account information
  • AaaOrganization
  • Customer
To populate the SubAccount information
  • AaaOrganization
  • Customer
  • SubAccount

To populate the Contract information
  • ServiceCTR
  • ServiceCTRInfo

To map the contacts to the Account
  • Customer_Requester
To map a Account Manager to the Account
  • Customer_Salesrep

Date conversion :

Date fields are available as long in the database. Pls usethe following conversion rule :

Long_Date = (UNIX_TIMESTAMP(DATE('2006-07-24 00:00:00'))* 1000) 

Also 

longtodate(wo.createdtime)