userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
Count
clientCorporationID
name
companyURL
tickersymbol
status
numOffices
departmentID
annualRevenue
numContacts
numEmployees
parentClientCorporationID
parentClientCorporationName
ownership
dateFounded
count
dateLastVisit
feeArrangement
workWeekStart
taxRate
externalID
count
Address1
Address2
city
state
countryID
CountryName
zip
phone
fax
billingFrequency
billingContact
billingAddress1
billingAddress2
billingCity
billingState
billingZip
billingPhone
dateAdded
Year Client Added
Quarter Client Added
Year-Month Client Added
Month Client Added
Day Client Added
Day of Week Client Added
Hour Client Added
Time Client Added
Custom Fields
userID
clientCorporationID
Jobs Added
Openings on Jobs
Contacts Added
Client Visits
Candidates Added
Recruiting Submissions
Sales Submissions
Recruiting Sendouts
Sales Sendouts
Recruiting Interviews Added
Sales Interviews Added
Recruiting Interviews
Sales Interviews
Recruiting Interviews Starts
Sales Interviews Starts
Recruiting Placements Added
Sales Placements Added
Recruiting Placements Starts
Sales Placements Starts
Date
Year
Quarter
Year-Month
Month
Day
Day of Week
Hour
Time
Internal User_Appointment Owner
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
count
subject
type
location
scheduleID (hide)
jobPostingID
jobOwnerName [Last Name, First Name]
candidateName [Last Name, First Name]
clientContactName [Last Name, First Name]
sendingUserName [Last Name, First Name]
clientUserID (hide)
candidateUserID (hide)
sendingUserID (hide)
clientCorporationID (hide)
clientCorporationName
dateLastModified
count
dateAdded
Year Appointment Added
Quarter Appointment Added
Year-Month Appointment Added
Month Appointment Added
Day Appointment Added
Day of Week Appointment Added
Hour Added
Time Added
dateBegin
Year Appointment Begin
Quarter Appointment Begin
Year-Month Appointment Begin
Month Appointment Begin
Day Appointment Begin
Day of Week Appointment Begin
Hour Appointment Begin
Time Appointment Begin
dateEnd
Year Appointment End
Quarter Appointment End
Year-Month Appointment End
Month Appointment End
Day Appointment End
Day of Week Appointment End
Hour Appointment End
Time Appointment End
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
count
candidateID
userID
candidateName
lastName
firstName
middleName
nickname
namePrefix
nameSuffix
dateOfBirth
gender
ethnicity
externalID
disability
type
experience
occupation
companyName
companyURL
description
referredBy [lastName, First Name]
candidateSourceID
candidateSourceName
dateLastComment
massMailOptOut
status
source
count
email2
email3
Phone
phone2
phone3
workPhone
mobile
pager
fax
fax2
fax3
Address1
Address2
City
State
countryID
CountryName
Zip
secondaryAddress1
secondaryAddress2
secondaryCity
secondaryState
secondaryCountryName
secondaryZip
employeeType
employmentPreference
travelLimit
willRelocate
workAuthorized
desiredLocations
dateAvailable
dateAvailableEnd
Salary
SalaryLow
dayRate
dayRateLow
hourlyRate
hourlyRateLow
educationDegree
degreeList
dateAdded
Year Candidate Added
Quarter Candidate Added
Year-Month Candidate Added
Month Candidate Added
Day Candidate Added
Day of Week Candidate Added
Hour Candidate Added
Time Candidate Added
Custom Fields
categoryID
categoryName
count
CategoryID
specialtyName
count
businessSectorID
BusinessSectorName
count
SkillID
Skill Name
count
userEducationID
school
degree
major
gpa
Education City
Education State
Education Certification
count
dateAdded
Year Education Added
Quarter Education Added
Year-Month Education Added
Day Education Added
Day of Week Education Added
Hour Education Added
Time Education Added
startDate
Year Education Started
Quarter Education Started
Year-Month Education Started
Month Education Started
Day Education Started
Day of Week Education Started
Hour Education Started
Time Education Started
endDate
Year Education Ended
Quarter Education Ended
Year-Month Education Ended
Month Education Ended
Day Education Ended
Day of Week Education Ended
Hour Education Ended
Time Education Ended
graduationDate
expirationDate
Year Education Expired
Quarter Education Expired
Year-Month Education Expired
Month Education Expired
Day Education Expired
Day of Week Education Expired
Hour Education Expired
Time Education Expired
Custom Fields
certificationID
certification_licenseNumber
certificationName
certification_issuedBy
certification_location
certification_boardCertification
count
Certification_dateCertified
Year Certified
Quarter Certified
Year-Month Certified
Month Certified
Day Certified
Day of Week Certified
Hour Certified
Time Certified
Certification_dateExpiration
Year Certification Expiration
Quarter Certification Expiration
Year-Month Certification Expiration
Month Certification Expiration
Day Certification Expiration
Day of Week Certification Expiration
Hour Certification Expiration
Time Certification Expiration
userWorkHistoryID
jobPostingID
placementID
clientCorporationIDs
companyName
title
terminationReason
salary1
salary1
salaryType
bonus
commission
count
dateAdded
Year Added
Quarter Added
Year-Month Added
Month Added
Day Added
Day of Week Added
Hour Added
Time Added
startDate
Year Start
Quarter Start
Year-Month Start
Month Start
Day Start
Day of Week Start
Hour Start
Time Start
endDate
Year End
Quarter End
Year-Month End
Month End
Day End
Day of Week End
Hour End
Time End
Custom Fields
candidateTitle
userID
userReferenceID
referenceUserID
clientCorporationIDs
companyName
jobPostingID
referenceTitle
referenceFirstName
referenceLastName
referencePhone
referenceEmail
status
yearsKnown
count
employmentEnd
Year Employment Ended
Quarter Employment Ended
Year-Month Employment Ended
Month Employment Ended
Day Employment Ended
Day of Week Employment Ended
Hour Employment Ended
Time Employment Ended
employmentStart
Year Employment Started
Quarter Employment Started
Year-Month Employment Started
Month Employment Started
Day Employment Started
Day of Week Employment Started
Hour Employment Started
Time Employment Started
dateAdded
Year Added
Quarter Added
Year-Month Added
Month Added
Day Added
Day of Week Added
Hour Added
Time Added
Custom Fields
Custom Fields
Internal User_Client Contact Owner
userID
userTypeID
userTypeName
departmentID
Deparment
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
count
clientCorporationID
name
companyURL
tickersymbol
status
numOffices
departmentID
annualRevenue
numContacts
numEmployees
parentClientCorporationID (hide)
parentClientCorporationName
ownership
dateFounded
count
dateLastVisit
feeArrangement
workWeekStart
taxRate
externalID
count
Address1
Address2
city
state
countryID
CountryName
zip
phone
fax
billingFrequency
billingContact
billingAddress1
billingAddress2
billingCity
billingState
billingZip
billingPhone
dateAdded
Year Client Added
Quarter Client Added
Year-Month Client Added
Month Client Added
Day Client Added
Day of Week Client Added
Hour Client Added
Time Client Added
Custom Fields
clientID
clientCorporationID
userID
fullName
firstName
lastName
middleName
nickname
namePrefix
nameSuffix
dateOfBirth
gender
invoiceFormat
disability
ethnicity
type
status
description
dateAdded
source
dateLastVisit
dateLastComment
massMailOptOut
count
email2
email3
phone
phone2
phone3
workPhone
mobile
pager
fax
fax2
fax3
address1
address2
city
state
countryID
CountryName
Zip
secondaryAddress1
secondaryAddress2
secondaryCity
secondaryState
secondaryCountryID
secondaryCountryName
secondaryZip
occupation
division
employmentPreference
travelLimit
willRelocate
workAuthorized
desiredLocations
dateAvailable
dateAvailableEnd
salary
salaryLow
dayRate
dayRateLow
hourlyRate
hourlyRateLow
ClientCorporationName
ClientCorporationPhone
ClientCorporationStatus
educationDegree
degreeList
recruiterUserID
recruiterName
referredByUserID
referredByName
reportToUserID
reportToName
dateAdded
Year Contact Added
Quarter Contact Added
Year-Month Contact Added
Month Contact Added
Day Contact Added
Day of Week Contact Added
Hour Contact Added
Time Contact Added
Custom Fields
Client Contact Business Sector
businessSectorID
businessSectorName
count
ClientContactCategoryName
count
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
Count
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
Count
jobPostingID
count
title
type
employmentType
source
status
hoursOfOperation
hoursPerWeek
durationWeeks
onsite
isOpen
isPublic
ClosedBy
isInterviewRequired
willRelocate
willSponsor
travelRequirements
externalID
externalCategoryID
ClosedDate
Year Closed
Quarter Closed
Year-Month Closed
Month Closed
Day Closed
Day of Week Closed
Hour Closed
Time Closed
clientCorporationID
isClientEditable
clientUserID
clientContactName
address
city
state
countryID
CountryName
publishedZip
educationDegree
degreeList
yearsRequired
billRateCategoryID
billRateName
clientBillRate
payRate
costCenter
taxRate
taxStatus
feeArrangement
markup
markupPercentage
salary
salaryUnit
workersCompRateID
responseUserID
responseUserName
reportToUserID
reportToUserName
reportTo
numInterviews
numOpenings
numPlacements
numPlacementsApproved
numResponses
numSendOuts
numSubmissions
dateAdded
Year Job Added
Quarter Job Added
Year-Month Job Added
Month Job Added
Day Job Added
Day of Week Job Added
Hour Job Added
Time Job Added
startDate
Year Job Start
Quarter Job Start
Year-Month Job Start
Month Job Start
Day Job Start
Day of Week Job Start
Hour Job Start
Job Start
dateEnd
Year Job End
Quarter Job End
Year-Month Job End
Month Job End
Day Job End
Day of Week Job End
Hour Job End
Time Job End
Custom Fields
jobPostingID
candidateName
status
Candidate Source
Source
Status
jobResponseID
count
dateAdded
Year Submission Added
Quarter Submission Added
Year-Month Submission Added
Month Submission Added
Day Submission Added
Day of Week Submission Added
Hour Submission Added
Time Submission Added
CandidateName
Status
Candidate Source
Source
jobResponseID
count
dateAdded
Year Response Added
Quarter Response Added
Year-Month Response Added
Month Response Added
Day Response Added
Day of Week Response Added
Hour Response Added
Time Response Added
sendoutID
candidate Name
Client Name
Contact Name
count
dateAdded
Year Sendout Added
Quarter Sendout Added
Year-Month Sendout Added
Month Sendout Added
Day Sendout Added
Day of Week Sendout Added
Hour Sendout Added
Time Sendout Added
clientCorporationID
name
companyURL
tickersymbol
status
numOffices
departmentID
annualRevenue
numContacts
numEmployees
parentClientCorporationID (hide)
parentClientCorporationName
ownership
dateFounded
count
dateLastVisit
feeArrangement
workWeekStart
taxRate
externalID
count
Address1
Address2
city
state
countryID
CountryName
zip
phone
fax
billingFrequency
billingContact
billingAddress1
billingAddress2
billingCity
billingState
billingZip
billingPhone
dateAdded
Year Client Added
Quarter Client Added
Year-Month Client Added
Month Client Added
Day Client Added
Day of Week Client Added
Hour Client Added
Time Client Added
Custom Fields
businessSectorID
businessSectorName
count
categoryID
categoryName
count
categoryID
specialtyName
count
certificationID
certificationName
count
jobPostingID
skillID
skillName
skillDescription
count
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
Count
userID
userCommentID
Jobs Referenced
Persons Referenced
Placements Referenced
Person Type
commentingUserID
jobPostingID
action
minutesSpent
userCommentID
count
dateAdded
Year Note Added
Quarter Note Added
Year-Month Note Added
Month Note Added
Day Note Added
Day of Week Note Added
Hour Note Added
Time Note Added
clientCorporationID
name
companyURL
tickersymbol
status
numOffices
departmentID
annualRevenue
numContacts
numEmployees
parentClientCorporationID
parentClientCorporationName
ownership
dateFounded
count
dateLastVisit
feeArrangement
workWeekStart
taxRate
externalID
invoiceFormat
Address1
Address2
city
state
countryID
CountryName
zip
phone
fax
billingFrequency
billingContact
billingAddress1
billingAddress2
billingCity
billingState
billingZip
billingPhone
dateAdded
Year Client Added
Quarter Client Added
Year-Month Client Added
Month Client Added
Day Client Added
Day of Week Client Added
Hour Client Added
Time Client Added
Custom Fields
userID
userTypeID
UserTypeName
departmentID
Department
PrimaryDepartmentFlag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
userID
userTypeID
UserTypeName
departmentID
Department
PrimaryDepartmentFlag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
userID
userTypeID
UserTypeName
departmentID
Department
PrimaryDepartmentFlag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
placementID
employmentType
status
candidateSourceName
dateEffective
dateClientEffective
workWeekStart
durationWeeks
hoursPerDay
hoursOfOperation
daysToFillJob
count
jobClientCorporationID
jobClientUserID
JobUserID
sendingUserID
userID
candidateName
employeeType
terminationReason
salary
salaryUnit
daysProrated
daysGuaranteed
payRate
clientOverTimeRate
customBillRate
customPayRate
otExemption
burden
burdenPercentage
clientBillRate
overtimeRate
costCenter
fee
flatFee
taxRate
taxState
billingUserID
statementUserID
billingFrequency
billingUserName
statementUserName
reportedMargin
grossMargin
recruitingManagerPercentGrossMargin
salesManagerPercentGrossMargin
markUp
markUpPercentage
overtimeMarkUp
overtimeMarkUpPercentage
dateAdded
Year Placement Added
Quarter Placement Added
Year-Month Placement Added
Month Placement Added
Day Placement Added
Day of Week Placement Added
Hour Placement Added
Time Placement Added
dateBegin
Year Placement Begin
Quarter Placement Begin
Year-Month Placement Begin
Month Placement Begin
Day Placement Begin
Day of Week Placement Begin
Hour Placement Begin
Time Placement Begin
dateEnd
Year Placement End
Quarter Placement End
Year-Month Placement End
Month Placement End
Day Placement End
Day of Week Placement End
Hour Placement End
Time Placement End
Custom Fields
jobPostingID
count
title
type
employmentType
source
status
hoursOfOperation
hoursPerWeek
durationWeeks
onsite
isOpen
isPublic
isInterviewRequired
willRelocate
willSponsor
travelRequirements
externalID
externalCategoryID
clientCorporationID
isClientEditable
clientUserID
clientUserName
address
city
state
countryID
CountryName
publishedZip
educationDegree
degreeList
yearsRequired
billRateCategoryID
billRateName
clientBillRate
payRate
costCenter
taxRate
taxStatus
feeArrangement
markup
markupPercentage
salary
salaryUnit
workersCompRateID
responseUserID
responseUserName
reportToUserID
reportToUserName
reportTo
numInterviews
numOpenings
numPlacements
numPlacementsApproved
numResponses
numSendOuts
numSubmissions
dateAdded
Year Job Added
Quarter Job Added
Year-Month Job Added
Month Job Added
Day Job Added
Day of Week Job Added
Hour Job Added
Time Job Added
startDate
Year Job Start
Quarter Job Start
Year-Month Job Start
Month Job Start
Day Job Start
Day of Week Job Start
Hour Job Start
Time Job Start
dateEnd
Year Job End
Quarter Job End
Year-Month Job End
Month Job End
Day Job End
Day of Week Job End
Hour Job End
Time Job End
Custom Fields
jobPostingID
userID
candidateName
status
source
jobResponseID
count
dateAdded
Year Submission Added
Quarter Submission Added
Year-Month Submission Added
Month Submission Added
Day Submission Added
Day of Week Submission Added
Hour Submission Added
Time Submission Added
candidateName
source
status
jobResponseID
count
dateAdded
Year Response Added
Quarter Response Added
Year-Month Response Added
Month Response Added
Day Response Added
Day of Week Response Added
Hour Response Added
Time Response Added
sendoutID
Candidate Name
Client Name
Contact Name
count
dateAdded
Year Sendout Added
Quarter Sendout Added
Year-Month Sendout Added
Month Sendout Added
Day Sendout Added
Day of Week Sendout Added
Hour Sendout Added
Time Sendout Added
candidateID
userID
candidateName
lastName
firstName
middleName
nickname
namePrefix
nameSuffix
dateOfBirth
gender
ethnicity
disability
type
experience
occupation
companyName
description
referredBy
candidateSourceID
candidateSourceName
dateLastComment
massMailOptOut
status
count
email2
email3
Phone
phone2
phone3
workPhone
mobile
pager
fax
fax2
fax3
Address1
Address2
City
State
countryID
CountryName
Zip
secondaryAddress1
secondaryAddress2
secondaryCity
secondaryState
secondaryCountryName
secondaryZip
employeeType
employmentPreference
travelLimit
willRelocate
workAuthorized
desiredLocations
dateAvailable
dateAvailableEnd
Salary
SalaryLow
dayRate
dayRateLow
hourlyRate
hourlyRateLow
educationDegree
degreeList
dateAdded
Year Candidate Added
Quarter Candidate Added
Year-Month Candidate Added
Month Candidate Added
Day Candidate Added
Day of Week Candidate Added
Hour Candidate Added
Time Candidate Added
Custom Fields
clientCorporationID
name
companyURL
tickersymbol
status
numOffices
departmentID
annualRevenue
numContacts
numEmployees
parentClientCorporationID
parentClientCorporationName
ownership
dateFounded
count
dateLastVisit
feeArrangement
workWeekStart
taxRate
externalID
count
Address1
Address2
city
state
countryID
CountryName
zip
phone
fax
billingContact
billingAddress1
billingAddress2
billingCity
billingState
billingZip
billingPhone
dateAdded
Year Client Added
Quarter Client Added
Year-Month Client Added
Month Client Added
Day Client Added
Day of Week Client Added
Hour Client Added
Time Client Added
Custom Fields
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
userID
userTypeID
userTypeName
departmentID
Department
PrimaryDepartmentflag
dateAdded
UserFullName
UserFirstName
UserLastName
UserCity
UserState
UserTitle
EnabledFlag
count
Subject
scheduleID
jobPostingID
candidateUserID
candidateName [Last Name, First Name]
clientUserID
clientContactName [Last Name, First Name]
type
userID
dateLastModified
count
dateAdded
Year Task Added
Quarter Task Added
Year-Month Task Added
Month Task Added
Day Task Added
Day of Week Task Added
Hour Task Added
Time Task Added
dateDue
Year Task Due
Quarter Task Due
Year-Month Task Due
Month Task Due
Day Task Due
Day of Week Task Due
Hour Task Due
Time Task Due
dateCompleted
Year Task Completed
Quarter Task Completed
Year-Month Task Completed
Month Task Completed
Day Task Completed
Day of Week Task Completed
Hour Task Completed
Time Task Completed