Member
Member
97 columns Fetched February 27, 2026
Columns
Member_RecID Numeric
Member_ID Text
First_Name Text nullable
Middle_Initial Text nullable
Last_Name Text nullable
Title Text nullable
Notes Text nullable
Image_Link Text nullable
Vendor_Nbr Text nullable
Member_Type_RecID Numeric nullable
Member_Type_Desc Text nullable
License_Type Text nullable
time_zone_recid Numeric nullable
Time_Zone_name Text nullable
Country Text nullable
Date_Hire DateTime nullable
PhoneNbr Text nullable
PhoneNbr_Ext Text nullable
PhoneNbr2 Text nullable
PhoneNbr2_Mobile Text nullable
PhoneNbr3 Text nullable
PhoneNbr3_Ext Text nullable
Email_Address Text nullable
Email_Address2 Text nullable
Email_Address3 Text nullable
Default_Phone Numeric nullable
Default_Email Numeric nullable
Inactive_Flag Boolean
Date_Inactive DateTime nullable
Disable_Login_Flag Boolean nullable
Mobile_Flag Boolean nullable
Owner_ID Numeric
Owner_Level_RecID Numeric nullable
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location
Role_ID Text nullable
Default_Loc_RecID Numeric nullable
Restrict_Loc_Flag Boolean nullable
Billing_Unit_RecID Numeric nullable
Also in 29 reports
Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Portal Agr Type Project Header Purchase Order Purchase Order Template Service Code Service Item Service Status Service Sub Type Service Team Service Type Time User Defined Field Billing Units Warehouse Warehouse Bin
Restrict_BU_Flag Boolean nullable
MAPI_Name Text nullable
Reports_To Text nullable
Approved_By Text nullable
Default_Sales_Owner_Level Numeric nullable
Default_Sales_Billing_Unit Numeric nullable
Exp_Approver Text nullable
Activity_Class_RecID Numeric nullable
Work_Role Text nullable
Activity_Type_RecID Numeric nullable
Also in 5 reports
Work_Type Text nullable
Billable_Forecast Numeric nullable
Daily_Capacity Numeric nullable
Require_Exp_Flag Boolean nullable
Require_Time_Flag Boolean nullable
Restrict_Ter_Flag Boolean nullable
Default_Ter_RecID Numeric nullable
Hourly_Cost Text nullable
Hourly_Rate Numeric nullable
Utilization_Flag Boolean
SR_Owner_Level_RecID Numeric nullable
Restrict_SB_Loc_Flag Boolean nullable
SR_Billing_Unit_RecID Numeric nullable
SR_Board_RecID Numeric nullable
Also in 21 reports
Kb Resolution Audit Trail Portal Config Service Boards Portal Project Portal Service Portal Ticket Type Description Project Project Header Service Service Board Service Board Members Service Code Service Item Service KPICount By Hour Service Status Service Sub Type Service Team Service Template Service Type Service Open Service Summary Service Summary Open
Board_Name Text nullable
System_Flag Boolean nullable
Sch_OL_RecID Numeric nullable
Sch_BU_RecID Numeric nullable
Sch_Restrict_Flag Boolean nullable
Sch_NoDisplay_Flag Boolean nullable
Sched_Capacity Numeric nullable
SR_Location_RecID Numeric nullable
Also in 2 reports
PM_Owner_Level_RecID Numeric nullable
Restrict_PM_Loc_Flag Boolean
PM_Billing_Unit_Recid Numeric nullable
Restrict_PM_BU_Flag Boolean
Default_Sales_Basis Text nullable
Default_Sales_Display Text nullable
Warehouse_RecID Numeric nullable
Also in 3 reports
Warehouse_Flag Boolean nullable
Warehouse_Bin_RecID Numeric nullable
Also in 1 report
Warehouse_Bin_Flag Boolean
Remote_Package_ID Text nullable
Remote_Package_Login Text nullable
Remote_Package_Account_ID Text nullable
Remote_Package_Platform Text nullable
Updated_By Text nullable
Last_Update DateTime
Time_Zone Text nullable
Office_Calendar_RecID Numeric nullable
Also in 5 reports
PR_Emp_ID Text nullable
EX_Company_Flag Boolean
Enter_Company_Flag Boolean
Last_Update_UTC DateTime
Last_Login_UTC DateTime nullable
Member_Full_Name Text
Time_StartEnd_Flag Boolean
Scheduling_Auto_Stopwatch Boolean
Scheduling_Auto_Popup_Quick_Notes Boolean
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Member_RecID | Numeric | No | |
| Member_ID | Text | No | unique |
| First_Name | Text | Yes | unique |
| Middle_Initial | Text | Yes | unique |
| Last_Name | Text | Yes | unique |
| Title | Text | Yes | unique |
| Notes | Text | Yes | unique |
| Image_Link | Text | Yes | unique |
| Vendor_Nbr | Text | Yes | unique |
| Member_Type_RecID | Numeric | Yes | unique |
| Member_Type_Desc | Text | Yes | unique |
| License_Type | Text | Yes | unique |
| time_zone_recid | Numeric | Yes | unique |
| Time_Zone_name | Text | Yes | unique |
| Country_RecID | Numeric | Yes | |
| Country | Text | Yes | unique |
| Date_Hire | DateTime | Yes | unique |
| PhoneNbr | Text | Yes | unique |
| PhoneNbr_Ext | Text | Yes | unique |
| PhoneNbr2 | Text | Yes | unique |
| PhoneNbr2_Mobile | Text | Yes | unique |
| PhoneNbr3 | Text | Yes | unique |
| PhoneNbr3_Ext | Text | Yes | unique |
| Email_Address | Text | Yes | unique |
| Email_Address2 | Text | Yes | unique |
| Email_Address3 | Text | Yes | unique |
| Default_Phone | Numeric | Yes | unique |
| Default_Email | Numeric | Yes | unique |
| Inactive_Flag | Boolean | No | unique |
| Date_Inactive | DateTime | Yes | unique |
| Disable_Login_Flag | Boolean | Yes | unique |
| Mobile_Flag | Boolean | Yes | unique |
| Owner_ID | Numeric | No | unique |
| Owner_Level_RecID | Numeric | Yes | 48 reports Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location |
| Role_ID | Text | Yes | unique |
| Default_Loc_RecID | Numeric | Yes | unique |
| Restrict_Loc_Flag | Boolean | Yes | unique |
| Billing_Unit_RecID | Numeric | Yes | 29 reports Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Portal Agr Type Project Header Purchase Order Purchase Order Template Service Code Service Item Service Status Service Sub Type Service Team Service Type Time User Defined Field Billing Units Warehouse Warehouse Bin |
| Restrict_BU_Flag | Boolean | Yes | unique |
| MAPI_Name | Text | Yes | unique |
| Reports_To | Text | Yes | unique |
| Approved_By | Text | Yes | unique |
| Default_Sales_Owner_Level | Numeric | Yes | unique |
| Default_Sales_Billing_Unit | Numeric | Yes | unique |
| Exp_Approver | Text | Yes | unique |
| Activity_Class_RecID | Numeric | Yes | |
| Work_Role | Text | Yes | unique |
| Activity_Type_RecID | Numeric | Yes | |
| Work_Type | Text | Yes | unique |
| Billable_Forecast | Numeric | Yes | unique |
| Daily_Capacity | Numeric | Yes | unique |
| Require_Exp_Flag | Boolean | Yes | unique |
| Require_Time_Flag | Boolean | Yes | unique |
| Restrict_Ter_Flag | Boolean | Yes | unique |
| Default_Ter_RecID | Numeric | Yes | unique |
| Hourly_Cost | Text | Yes | unique |
| Hourly_Rate | Numeric | Yes | unique |
| Utilization_Flag | Boolean | No | unique |
| SR_Owner_Level_RecID | Numeric | Yes | unique |
| Restrict_SB_Loc_Flag | Boolean | Yes | unique |
| SR_Billing_Unit_RecID | Numeric | Yes | unique |
| SR_Board_RecID | Numeric | Yes | 21 reports Kb Resolution Audit Trail Portal Config Service Boards Portal Project Portal Service Portal Ticket Type Description Project Project Header Service Service Board Service Board Members Service Code Service Item Service KPICount By Hour Service Status Service Sub Type Service Team Service Template Service Type Service Open Service Summary Service Summary Open |
| Board_Name | Text | Yes | unique |
| System_Flag | Boolean | Yes | unique |
| Sch_OL_RecID | Numeric | Yes | unique |
| Sch_BU_RecID | Numeric | Yes | unique |
| Sch_Restrict_Flag | Boolean | Yes | unique |
| Sch_NoDisplay_Flag | Boolean | Yes | unique |
| Sched_Capacity | Numeric | Yes | unique |
| SR_Location_RecID | Numeric | Yes | 2 reports |
| PM_Owner_Level_RecID | Numeric | Yes | unique |
| Restrict_PM_Loc_Flag | Boolean | No | unique |
| PM_Billing_Unit_Recid | Numeric | Yes | unique |
| Restrict_PM_BU_Flag | Boolean | No | unique |
| Default_Sales_Basis | Text | Yes | unique |
| Default_Sales_Display | Text | Yes | unique |
| Warehouse_RecID | Numeric | Yes | 3 reports |
| Warehouse_Flag | Boolean | Yes | unique |
| Warehouse_Bin_RecID | Numeric | Yes | 1 report |
| Warehouse_Bin_Flag | Boolean | No | unique |
| Remote_Package_ID | Text | Yes | unique |
| Remote_Package_Login | Text | Yes | unique |
| Remote_Package_Account_ID | Text | Yes | unique |
| Remote_Package_Platform | Text | Yes | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |
| Office_Calendar_RecID | Numeric | Yes | 5 reports |
| PR_Emp_ID | Text | Yes | unique |
| EX_Company_Flag | Boolean | No | unique |
| Enter_Company_Flag | Boolean | No | unique |
| Last_Update_UTC | DateTime | No | unique |
| Last_Login_UTC | DateTime | Yes | unique |
| Member_Full_Name | Text | No | unique |
| Time_StartEnd_Flag | Boolean | No | unique |
| Scheduling_Auto_Stopwatch | Boolean | No | unique |
| Scheduling_Auto_Popup_Quick_Notes | Boolean | No | unique |