2,299
edits
Changes
no edit summary
* See: [[Classic Report Builder - Column Settings]]
:: [[File:Recordsets tab.png|750px|-border]] |Applicant AssignmentsWhen you click on this tab, numerous recordsets from different parts of the system will appear.
==Types of Recordsets=={|
|-
|Applicant Resume|{{RecordsetCandA.PNG}}||==Company and Account Recordsets==* <!--31-->'''Companies/Accounts''' - Fields that pertain to [[organization]] records in your SmartSimple system. The exact terminology for this section will be based on the External Unit value configured in the Organization Terminology section of the Global Settings.* <!--11-->'''UTA Record Lock''' - [[Record Lock]] history of records.* <!--30-->'''Branches/Offices''' - Information entered into the system including all [[custom fields]] for [[internal]] branches or offices. The exact terminology for this section will be based on the Internal Unit value configured in the Organization Terminology section of the Global Settings.* <!--38-->'''Categories''' - Company/Account [[Client Categories|categories]].
||-|Incoming Email Resumes}
{|
|-
|Skills|{{RecordsetUandC.PNG}}||
==User and Contact Recordsets==
* <!--41-->'''Contacts''' - All contacts outside of your organization. This recordset includes all contact-specific and [[roles|role-based]] [[custom fields]]. Note that applicant information is also contained within this recordset if the [[Applicant Tracking]] application is being used. The exact terminology for this section will be based on the External User value configured in the Organization Terminology section of the Global Settings.
* <!--40-->'''Users''' - All contacts that are [[internal]] to your organization. This recordset includes all user-specific and [[roles|role-based]] [[custom fields]]. The exact terminology for this section will be based on the Internal User value configured in the Organization Terminology section of the Global Settings.
* <!--45-->'''People''' - Any internal or external people. This recordset includes all user-specific and role-based custom fields.
* <!--9-->'''[[Roles]]''' - Use the roles recordset in conjunction with the contact or user recordsets to run reports on contacts or users within a specific role.
* <!--47-->'''Right Relationships''' - This recordset is used where the relationship was established from user "b" to user "a".
* <!--46-->'''Left Relationships''' - This recordset is used where the relationship was established from user "a" to user "b".
* <!--50-->'''Associations''' - See [[Associations]].
|||-===See Also===|Email Link Tracker - Contacts* [[Reporting on User Type and Access Type]]
||-|Email Link Tracker - Leads}
{|
|-
|Web Forms|{{RecordsetAandN.PNG}}||
||===See Also===* [[:Category:Calendars|-Calendars]]* [[:Category:Notes|Web Form PaymentsNotes]]
||-|Tracking Application}
{|
|-
|Tracking Application Activities|{{RecordsetUserAccess.PNG}}||
||-|Tracking Transactions}
{|
|-
|UTA Timesheet Items|{{RecordsetFandOLog.PNG}}||
||-|UTA Invoice Items}
{|
|-
|UTA Person|{{RecordsetSalesTracking.PNG}}||
||-|UTA Contact role (joins to Tracking Application Activities)}
{|
|-
|UTA Company role (links to primary)|{{RecordsetApplicantTracking.PNG}}||
||-|UTA Company role (joins to Tracking Application Activities)}
{|
|-
|UTA Provider without contacts|{{RecordsetEmailBroadcast.PNG}}||
|}
{|
|-
|Project Metrics|{{RecordsetWebform.PNG}}||
==Web Form Recordsets==* <!--369-->'''Web Forms''' - See [[:Category:Web Forms|Web Forms]]|* <!--370-->'''Web Form Results''' -See [[Completing a Web Form Internally and Viewing the Results]]* <!--380-->'''Web Form Payments''' - See [[:Category:Web Forms|Projects and JobsWeb Forms]]
||-|Project and Job Tasks}
{|
|-
|Project Task Invoices|{{TrackingAppTables2.png}}||
==Tracking Application Recordsets==* <!--23-->'''Tracking Application''' - The Tracking Application report group contains all of the information regarding a Tracking Application including any custom fields and/or tabs added. By making Tracking Applications a Main group you can then also select Tracking Application Activities (and or other report groups) and include any related information from that group as well. A list of all Activities taking place for a Tracking Application would be an example of a report generated from this report group.* <!--10000-->'''Tracking Application Activities''' - The Tracking Activities report group contains all of the information related to an activity regarding type, location and time. Other report groups can be attached to this group to gather more information regarding details such as who is the main contact for a particular activity. A list of all the start times and locations for an activity would be an example of a report generated using this report group.* <!--10010-->'''Tracking Application Sub-Activities''' - The Tracking Sub-Activities report group contains all of the information related to an activity regarding type, location and time. Other report groups can be attached to this group to gather more information regarding details such as who is the main contact for a particular activity. A list of all the start times and locations for an activity would be an example of a report generated using this report group.* <!--10020-->'''Tracking Transactions''' - Personal Transactions* <!--10080-->'''UTA Timesheet Items''' - See [[Using Timesheets to update a Project]]* <!--10122-->'''UTA Invoices''' - See [[Invoice UTA]]* <!--10222-->'''UTA Invoice Items''' - See [[Invoice UTA]]* '''UTA Payment Attribution''' - Payment Attributions* <!--12-->'''UTA Person''' - ''Person'' [[standard field]]* <!--5501-->'''UTA Contact role (joins to Tracking Application)''' - See [[Role_Based_Custom_Fields#Role_Based_Custom_Fields_-_UTA_Level_One|Role Based Custom Fields - UTA Level One]]* <!--6501-->'''UTA Contact role (joins to Tracking Application Activities)''' - [[Role_Based_Custom_Fields#Role_Based_Custom_Fields_-_UTA_Level_Two|Role Based Custom Fields - UTA Level Two]]* <!--5000-->'''UTA Company role (links to primary)''' - See [[Company Role]]* <!--5500-->'''UTA Company role (joins to Tracking Application)''' - See [[Company Role]]* <!--6500-->'''UTA Company role (joins to Tracking Application Activities)''' - See [[Company Role]]* <!--5004-->'''UTA Consumer / Provider (L1 - L1)''' - Table containing information related to L1 to L1 Consumer/Provider relationships. Using this table you will be able to access information in the Consumer record that is joined to the Provider record.* <!--5004-->'''UTA Provider / Consumer (L1 - L1)''' - Table containing information related to L1 to L1 Provider/Consumer relationships. Using this table you will be able to access information in the Provider record that is joined to the Consumer record.* <!--5004-->'''UTA Provider / Consumer (L1 - L2)''' -Table containing information related to L1 to L2 Consumer/Provider relationships. Using this table you will be able to access information in the Provider record that is joined to the Consumer record.* <!--5001-->'''UTA Contact role (links to primary)''' - See [[Role_Based_Custom_Fields#Role_Based_Custom_Fields_-_Base|Resource AssignmentRole Based Custom Fields - Base]]
|||-===See Also===|Timesheets* [[UTA Provider Reports Table]]
||-|Timesheet Items}
{|
|-
|Project Timesheet|{{RecordsetPandJCosting.PNG}}||
==Project and Job Costing Recordsets==* <!--94-->'''Project Metrics''' - Project Matrix* <!--95-->'''Projects and Jobs''' - Use the project and job recordset to run reports on project/job-specific information within the [[:Category:Project and Job Costing|Job Costing]] application.* <!--96-->'''Project and Job Tasks''' - Use the project and job tasks recordset to run reports on task-specific information within the [[:Category:Project and Job Costing|Job Costing]] application.* <!--98-->'''Project Task Invoices''' - Project Task Invoices* <!--97-->'''Resource Assignment''' - Resources including people, equipment, facilities and materials allocated to specific tasks in a project.* <!--200-->'''Timesheets''' - Timesheets.* <!--210-->'''Timesheet Items''' -Timesheet Items.|* <!--220-->'''Project Timesheet''' - Project Timesheets.* <!--100-->'''Expenses''' - Expenses.* <!--110-->'''ExpensesItems''' - Expense Items.
||-|Expenses Items||-===See Also===* [[:Category:Project and Job Costing|Project and Job Costing]]
|}
{|
|-
|Discussion Posts|{{RecordsetDiscussion.PNG}}||
==Discussion Recordsets==
* <!--25-->'''Discussion Posts''' - Use the [[Using Discussion Groups|discussion]] posts recordset to run reports on discussion-specific information including content, posted date and posted by.
||-|Custom Fields}
{|
|-
|Custom Field Language}- |{{Template:RecordsetUandCRecordsetCustomFields.PNG}}||==Custom Field Recordsets==* <!--9000-->'''Custom Fields''' - The properties of [[custom fields]] configured on your system.{{Template:RecordsetAandN* <!--9050-->'''Custom Field Language''' - See [[Custom Field Language Settings]].PNG}}
||===See Also===* [[Image:Recordset2.PNGReporting on Custom Fields]]
==See Also==* [[Image:RecordsetTrackingApplication.PNGAdding a Table to a Report]]
[[Category:Reports]]