Smartstaff
171
edits
Changes
→No summary
The following lists the database field names associated with [[Standard Fields]].
These are required if updating the database directly (clients with dedicated servers only)<br/>
or for [[Pandora]].
==Users==
* '''ustatusid''': Status ID
* '''isexternal''': Flag (1=external, 0=internal)
* '''companyid''': ID of user's company. 0 if empty.
* '''name''': name of user's company.
* '''title''': Title standard field.
* '''uprefix''': Prefix standard field.
* '''uphoneext''': Phone extension field.
* '''rolelist''': Comma delimited list of role IDs. (Starts and ends with a comma)
* '''isactive''': 1 ('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')
==Job Costing fields for users==
* '''isresource''':
* '''costunit''': ID number of cost unit combo-box option.
* '''rmargin''': Margin field of user/resource.
==Level 1==
* '''companyid''': Company ID of level 1 company/client field, . 0 if empty.
* '''branchid''': Company ID of level 1 branch field. 0 if empty.
* '''oppeopleid''': User ID of level 1 people field. 0 if empty.
* '''eventtype''': ID of level 2/3 type.
* '''typename''': Level 2 type name.
* '''objecttype''': Parent [[object type]] (23=parent object is level 1. 8=parent object is level 2.) <span style="font -size="1: xx-small;">''*Note: although 18 is the Level 2 Type object type, 8 should be used here.''</fontspan>
* '''objectid''': Parent object ID.
* '''assigned''': Comma delimited list of user IDs in assigned standard field.
* cevconoppid: Level 1 id (regardless of whether the Level 1 is the consumer or the provider)
* cevprovevtid: Level 2 id (regardless of whether the Level 2 is the consumer or the provider)
* [[Entity IDs]] (Object Types)
[[Category:System Management]][[Category:Pandora]][[Category:Standard Fields]]
