Changes

SmartConnect - Appendix: Standard Field Names

2,443 bytes added, 20:23, 20 April 2017
Users
* '''sf_Created Date''': date record was created.
* '''sf_Created By''': name of user who created the record.
 
{|
|-
||
''' '''
 
||
'''Standard Field Name'''
 
||
'''Description'''
 
||
'''GET Method'''
 
||
'''UPDATE Method'''
 
|-
||
1
 
||
sf_User ID
 
||
User ID (0 if new user)
 
||
 
||
'''Not Updatable'''
 
 
|-
||
2
 
||
sf_Is External
 
||
Flag (1=external, 0=internal)
 
||
 
||
 
|-
||
3
 
||
sf_Company ID
 
||
ID of user's company. 0 if empty.
 
||
 
||
 
|-
||
4
 
||
sf_Company
 
||
name of user's company
 
||
 
||
 
|-
||
5
 
||
sf_Title
 
||
Title standard field.
 
||
 
||
 
|-
||
6
 
||
sf_Prefix
 
||
Prefix standard field
 
||
 
||
 
|-
||
7
 
||
sf_Suffix
 
||
Suffix standard field
 
||
 
||
 
|-
||
8
 
||
sf_First Name
 
||
First name standard field
 
||
 
||
 
|-
||
9
 
||
sf_Last Name
 
||
Last name standard field
 
||
 
||
 
|-
||
10
 
||
sf_Middle Name
 
||
Middle name standard field
 
||
 
||
 
|-
||
11
 
||
sf_Email
 
||
Email standard field
 
||
 
||
 
|-
||
12
 
||
sf_Address
 
||
Address standard field
 
||
 
||
 
|-
||
13
 
||
sf_Address 2
 
||
Address 2 standard field
 
||
 
||
 
|-
||
14
 
||
sf_City
 
||
City standard field
 
||
 
||
 
|-
||
15
 
||
sf_State / Province
 
||
Province standard field
 
||
 
||
 
|-
||
16
 
||
sf_Country
 
||
Name of country field.
 
||
''Displays country name''
 
||
''Update using country id''
 
|-
||
17
 
||
sf_Zip / Postal Code
 
||
Postal code standard field
 
||
 
||
 
|-
||
18
 
||
sf_Phone
 
||
Phone standard field
 
||
 
||
 
|-
||
19
 
||
sf_Phone Ext
 
||
Phone extension field. (includes period at the end)
 
||
 
||
 
|-
||
20
 
||
sf_User Role
 
||
Comma delimited list of role IDs. (Starts and ends with a comma)
 
||
 
||
 
|-
||
21
 
||
sf_Access Type
 
||
1 ('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')
 
||
''Displays id''
 
||
''Update using id''
 
|-
||
22
 
||
sf_User Type
 
||
10 (‘User’), 30 (‘Local User Administrator’), 50 (‘Global User Administrator’)
 
||
''Displays name''
 
||
''Update using id''
 
|-
||
23
 
||
sf_Status*
 
||
status name of user
 
||
''Displays name''
 
||
''Update using id''
 
|-
||
24
 
||
sf_Status ID*
 
||
status ID of user
 
||
'' ''
 
||
'' ''
 
|-
||
25
 
||
Sf_Status Caption
 
||
Status caption
 
||
'' ''
 
||
'' ''
 
|-
||
26
 
||
sf_Updated By
 
||
name of user who updated the record
 
||
 
||
 
|-
||
27
 
||
sf_Last Updated
 
||
date record was last updated
 
||
 
||
'''Not Updatable'''
 
 
|-
||
28
 
||
sf_Created Date
 
||
date record was created
 
||
 
||
'''Not Updatable'''
 
 
|-
||
29
 
||
sf_Created By
 
||
user who created the user
 
||
 
||
 
|}
==Level 1==
Smartstaff
1,385
edits