API Data Provider - Online Help
Factorial Profile
Connecting to Factorial
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Agreements
Allowances
Applications
BankAccount
BreakConfiguration
Candidates
Categories
Compensations
Concepts
ContractTemplates
ContractVersions
CostCenters
DayConfiguration
Documents
Employees
Expenses
Field
FinancialDocuments
Folders
HiringStages
JobLevels
JobPostings
JobRoles
Leaves
LeaveTypes
LegalEntities
Locations
Memberships
Mileage
OpenShifts
OvertimeRequests
PayrollFamilySituations
PayrollSupplements
PerDiem
Policies
Projects
ProjectTasks
ReferenceContracts
RejectionReasons
ReviewEvaluations
ReviewEvaluationScores
ReviewProcesses
Schedule
Shifts
Tasks
Teams
TimeRecord
Trainings
TrainingSessions
Transaction
Value
WorkedTime
ProjectTasks
Project task assignments linking projects, subprojects and tasks
Columns
Name
Type
References
Id [KEY]
Integer
ProjectId
Integer
Projects
.Id
TaskId
Integer
Tasks
.Id
IsFollowUp
Boolean
SubprojectId
Integer