Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 27 Next »

Case

The Case object holds all the information on every case submitted to AggieService. As such it's one of the biggest and most complicated objects on the service. This reference, along with this google document, comprise our documentation of the fields and integrations for the Case object.

Field NameLabelTypeSourceDescriptionUnused
Account__cOver the Cap Account
formAccount field for Over the Cap account tracking
Account_Category__c
Account Category




Account_Department_Code__cDepartment Code



AccountIdAccount Namelookup (Account)systemAccount of case's submitter
Action__cActionpicklistformType of Action for cases (Academic, Student, Staff)
action_copyCase_stipendToPayroll__cSubmit to Payroll for Processingboolean
Triggers creating a child case and setting the Topic to Payroll via Process Flow invoking Apex Trigger.
action_Meets_DD_Entry_Criteria__cMeets Department Delegate Entry Criteriaboolean
Marks whether a case has been identified as routing to the delegate approval process
Action_Number__cAction Number



Add_to_DMV_Separation_Spreadsheet__cAdd to DMV Separation Spreadsheet



Added_to_DMV_Spreadsheet__cAdded to DMV Separation Spreadsheet



Additional_Comments__cAdditional Comments



Administrative_Summer_Comp__cAdministrative Summer Comp



Affected_Employee_Campus_Email__cAffected Employee Campus Email
formEmail address for Affected Employee. Entered in all case forms which deal with affected employees.
Affected_Employee_Name__cAffected Employee Namelookup (Contact)formLookup to Contact for affected employee. Populated by email lookups based on Affected_Employee_Campus_Email__c
Affected_Employee_Phone__cAffected Employee PhonephoneformPhone number for Affected Employee. Entered in all cases which deal with affected employees.
Affected_Employee_PPS_ID__cAffected Employee PPS ID
removeCurrently unpopulatedx
Affected_Employee_Textname__c




AggieJobLink__cAggieJobLink NumbertextformAggieJobLink number for Recruitment cases
Anything_else_you_d_like_us_to_know_del__cAnything else you'd like us to know?longtextform

Text field for additional comments. Found on most every form save Ask a Question.

Note: In order to test cases in PROD, one can put TESTING as the first word in this field and the case will route to the AggieService TEST Queue instead of anywhere else.


Application_Complete__cApplication Complete



Appointment_Date__cAppointment Date
formAppointment start date for Recruitments
Appointment_End_date__cAppointment End date
formAppointment end date for Recruitments
Appointment_Extension_Reason__cAppointment Extension ReasonpicklistformPicklist of reasons for appointment extensions in Appointment Changes form
Appointment_Percentage__cAppointment Percent
formPercentage for appointment in Recruitment cases
Appointment_Requesting_For__cAppointment Requesting For



Appointment_Scheduled_with_HR_Generalist__cAppointment Scheduled with HR Generalist



Appointment_Type__cAppointment Type



Approval_on_file__cApproval on File



Approval_Status__cApproval Status



Approved_By1__cApproved By



Approved_By2__cApproved By



Approved_Signer_1__cApproved Signer 1
form

Approved_Signer_2__cApproved Signer 2
form

Article_Created__cArticle Created



Article_Published__cArticle Published



Article_Reviewed_By__cArticle Reviewed By



Article_Topic__cArticle Topic
form

AssetId
lookup(Asset)systemnot usedx
Background_Check_Complete__cBackground Check Complete



Backup_Timesheet_Supervisor__cBackup Timesheet SupervisortextformEntry for Backup Timesheet Supervisor. Part of integration for Backup_Timesheet_Supervisor_contact__c.
Backup_Timesheet_Supervisor_contact__cBackup Timesheet Supervisor (C)lookup (Contact)integrationLookup populated via Trigger from Backup_Timesheet_Supervisor__c. Note: currently people put in names here instead of Email addresses, thereby invalidating our integration hookup, since we look up via campus email address (the only unique ID we have for people)
BusinessHoursId
lookup (Business Hours)form, systemThe Business Hours which the case is covered under. This required field is set by default and provided explicitly from the forms.
Case_Age__cCase Age



Case_Priority__cCase Priority



Case_Routing_Account_Category__c




Case_Routing_Department_Code__cCase Routing Department Code



CaseNumber
auto numbersystemAuto-incrementing ID for cases.
Category__cCategory
form

Central_Payroll_to_Process_Final_Check__cCentral Payroll to Process Final CheckbooleanremoveWhen checked, invokes a Process Flow to create a Central Payroll - Separation Check Request case, though currently not on any page layouts.x
Chart_Account_Subaccount__cChart -Account-Subaccount
form

Chart_Account_Subaccount_Changed__cChart-Account-Subaccount Changed
form

Check_Distribution_Method__cCheck Distribution Method
form

Check_EPER_Screen__cCheck EPER Screen



ClosedDate
datetimesystemTime the case was closed.
COA_Funding_Chart__c




Code_Number__cCode Number
form

Code_Type__cCode Type
form

College_Schools_Divisions__cCollege Schools Divisions



CommunityId




Comp_Time_Payout__cComp Time Payout



Compensatory_Hours__c




Completeness_Screening__cCompleteness ScreeningpicklistintegrationIdentifies what group is doing the completeness screening for a recruitment. Provided by PeopleAdmin's Applicant Screening XML.
ContactEmail
formulasystemSubmitter's email address derived from ContactId.
ContactFax
formulasystemSubmitter's fax number derived from ContactId.
ContactId
Lookup (Contact)form, system, integrationSubmitter's contact record
ContactID__cContact ID
removeWas used by Central Payroll form, but no reason to use this as ContactId seems to capture the same informationx
ContactMobile
formulasystemSubmitter's mobile phone number derived from ContactId.
ContactPhone
formulasystemSubmitter's preferred phone number derived from ContactId.
Contract_Signed_by_Employee__cContract Signed by Employee



Contract_Signed_by_Hiring_Manager__cContract Signed by Hiring Manager



Course_Quarter__cCourse Quarter
form

Create_Onboarding_Record__cCreate Onboarding RecordcheckboxintegrationWhen this field is checked and Date_of_Hire__c and New_Hire_Name__c are filled in, will update the related Position object with the current case number. Note: The position workflow integration (i.e. relating Recruitments to job records in AggieService) is a mess so, as a consequence, this rarely fires.
Create_Payroll_Case__cCreate Payroll Caseboolean
Triggers creation of a child case and sending to Payroll via a Process Flow. Found on Recruitment & Onboarding layouts.
CreatedById
lookup (User)systemLookup to the user who created the case. Most cases created from the Community come in as a particular integration user; in this case the AggieService Admin user.
CreatedDateDate/Time OpeneddatetimesystemDatetime the case was opened
Current_AggieJobLink__cCurrent AggieJobLink
form

Current_Employee__cCurrent Employee



Damage_Payments__cDamage Payments



Date_Closed__cDate Closed



Date_Employee_Returned_to_Work__cDate Employee Returned to Work



Date_Medical_Release_Received__cDate Medical Release Received



Date_of_Hire__cDate of HireDate
Date of Hire entered by Service Providers for Onboarding & Recruitment cases
Date_Opened__cDate Opened



Date_Payment_Expected__cDate Payment Expected



Date_Reviewed__cDate Reviewed



Date_Signed__cDate Signed



Date_Student_Employment_Approved__cDate Student Employment Approved



Day_Employee_s_Regular_Work_Sched_Begins__cDay Employee's Regular Work Sched Begins



Day_Employee_s_Regular_Work_Sched_Ends__cDay Employee's Regular Work Sched Ends



Days_Opened__cDays Opened



DCP_Number__c




Department_Approver__cDepartment Approver



Department_Code1__cDepartment Code
form

Department_Name__cDepartment Name
form

DescriptionDescriptionlong textsystemDefault field for issue description. Automatically populated from an email's body in email-to-case entries.
Designated_Approver_1__cDesignated Approver 1lookup (User)integrationCases which meet the entry criteria for approvals will have their 1st active delegate ID copied here via Trigger.
Designated_Approver_2__cDesignated Approver 2lookup (User)integrationCases which meet the entry criteria for approvals will have their 2nd active delegate ID copied here via Trigger.
Designated_Approver_3__cDesignated Approver 3lookup (User)integrationCases which meet the entry criteria for approvals will have their 3rd active delegate ID copied here via Trigger.
Designated_Approver_4__cDesignated Approver 4lookup (User)integrationCases which meet the entry criteria for approvals will have their 4th active delegate ID copied here via Trigger.
Designated_Approver_5__cDesignated Approver 5lookup (User)integrationCases which meet the entry criteria for approvals will have their 5th active delegate ID copied here via Trigger.
Desired_Contents__cDesired Contents



Differential__cDifferential
form

Differential_List__cDifferential List
form

DMV_Program_Coord_Email__cDMV Program Coord Email



DMV_Program_Coord_Email2__cDMV Program Coord Email



DMV_Pull_Notice__cDMV Pull Notice



DMV_Pull_Notice_Request__cDMV Pull Notice Request



DMV_Pull_Notice_Request_Deletion__cDMV Pull Notice Request Deletion



Documents_Uploaded_to_EDMS__cDocuments Uploaded to EDMS



Dollar_Amount__cDollar Amount
form

Dollar_Amount_Type__cDollar Amount Type
form

Draft_PD_ORG_Chart_Attached__cDraft PD & ORG Chart Attached



Drivers_License_to_HRC__cDrivers License to HRC



EDFT_Process__cEDFT Process



Effective_Date__cEffective DatedateformDate when operation should be performed. Currently on Longevity / Special Recognition increase but could be used elsewhere.
Email_Address__cEmail Address



Email_to_Fleet__cEmail to Fleet



Emeritus_Separation__cEmeritus SeparationbooleanformTracks whether an Academic separation is an emeritus separation
Employee_Entered_in_TRS__cEmployee Entered in TRS



Employee_Name__cEmployee NameLookup (Contact)formLookup to POC contact as provided by forms.
Employee_Pay__cEmployee Pay



Employee_s_Address_is_Current__cEmployee's Address is Current



Employee_s_Timekeeping_System_or_Method__cEmployee's Timekeeping System or Method



Employee_Separation__cEmployee Separation



Employees_Current_Mailing_Address__cEmployee's Current Mailing Address



End_Date__cEnd Date
form

Entered_into_Aggie_Job_LInk__cEntered into Aggie Job LInk



EntitlementIdEntitlement NameLookup(Entitlement)integration

Lookup to the entitlement supporting the Case. This is populated by the SPA engine based on the SLA record covering the case.

(for more information, bother jboveda@ucdavis.edu until he writes documentation and links to it here)


EPER_Screen_Checked__cEPER Screen Checked



ETL_Hiring_Department_Code__cHiring Department CodetextformHiring Department code as provided from Recruitment forms. Part of integration to populate the Hiring Department Account lookup.
Family_Member__cFamily Member
form

FeedItemId
lookup (Feed Item)systemChatter Feed question which results in a case.x
Field_Type__cField Type



File_Contents__cFile Contents



File_Description__cFile Description



FML_Packet__cFML Packet



FML_Packet_Sent_Date__cFML Packet Sent Date



Full_Month__cFull Month
form

Hiring_Department__cHiring DepartmentLookup (Account)integrationLookup to the Account record of the Hiring Department. Populated via Trigger from ETL_Hiring_Department_Code__c. If changed, will update ETL_Hiring_Department_Code__c.
Hiring_Manager__c




Hours_of_Operation__cHours of Operation



Hours_Worked__cHours Worked



HR_Generalist__cHR Generalist



HR_PPS_Entry_Complete__cHR PPS Entry Complete



Id
primary keysystem18-digit Salesforce record ID
ID_Source__cSource IDtextformUnique ID for cases created via form submissions e.g. FormAssembly
Identifier__cIdentifier
form

In_Residence_Full_Salary__cIn Residence – Full Salary



In_Residence_Partial_Salary__cIn Residence - Partial Salary



Information_Reviewed_By__cInformation Reviewed By



Internal_Comments_ONLY__cInternal Comments ONLY



Is_Employee_a_TRS_Supervisor__cIs Employee a TRS Supervisor?
form

Is_there_a_Different_Point_of_Contact__cIs there a Different Point of Contact?



IsClosed
booleansystemWhether the case is closed
IsClosedOnCreateIsClosedOnCreatebooleansystemSometimes cases are entered simply for tracking, and, for convenience, should be marked closed as soon as they're created. For example, phone calls with questions that are answered on the line would fit this criteria. Salesforce will populate this when one of those cases is marked close on create.
IsDeleted
booleansystemWhether the case is deleted. Cases marked as IsDeleted are still in the system until they're purged and sometimes recoverable from the Recycle Bin
IsEscalatedIsEscalatedbooleansystemWhether the case has been escalated. Currently unused.x
IsStoppedIsStoppedbooleansystemWhether work on the current case is stopped. Currently unused.x
Issue_Description__cIssue Descriptionlongtextform, removeDEPRECATED : Description of issue from Question, Problem, and Knowledge Article formsx
Justification__cJustification
form

KFS_Object__cObject



KFS_Project__cProject



KFS_SubAccount__cSub-Account



KFS_SubObject__cSub-Object



Last_Comment_Channel__cLast Comment ChannelpicklistintegrationWhenever someone posts a comment, the case is updated with the type of communication (Email, Comment, Feed)
Last_Comment_Posted__cLast Comment PosteddatetimeintegrationWhenever someone posts a comment, the case is updated with the datetime of that last communication
Last_Day_on_Pay__cLast Day on Paydate
Currently used in Central Payroll - Separation Check Requests to track last day on payroll.
LastModifiedById
lookup (User)systemLookup to the user who last modified the case
LastModifiedDate
datetimesystemTime the case was last modified. Because of Last_Comment_Posted__c and Last_Comment_Channel__c, this includes the last time anyone commented, posted, or emailed into the case.
Leave_Request_Form_Received__cLeave Request Form Received



Leave_Type__c

form

Location__cDelivery Location
form

Longevity_Increase__cLongevity Increase
form

Longevity_Increase_Amount__cLongevity Increase Amount
remove

Mailing_Address_Verified__cMailing Address Verified



Medical_Certification_Received__cMedical Certification Received



Medical_Release_Documentation_Received__cMedical Release Documentation Received



MilestoneStatusMilestoneStatustextsystemA milestone is a step in an entitlement process. If an entitlement process applies to a case, this field appears.
MQ_Screening__cMinimum Qualifications ScreeningpicklistintegrationIdentifies what group is doing the screening for minimum qualifications for a recruitment. Provided by PeopleAdmin's Applicant Screening XML.
Multiple_appointments__cMultiple appointments?
form

Name__cName



Need_Student_Employment_Approval__cNeed Student Employment Approva



New_Aggie_Job_Link_Needed__cNew Aggie Job Link Needed



New_Appointment_End_Date__cNew Appointment End Date
form

New_Chart_Account_Subaccount_Number__cNew Chart-Account_Subaccount Number
form

New_Contract__cNew Contract



New_Department_Contact__cNew Department Contactlookup (Contact)
Lookup for the new contact for department transfers. No case has any information in this field (as of 20180328)x
New_Department_Contact_Campus_Email__cNew Department Contact Campus Emailemail
Email of the contact in the new department. Found in Transfer and End Appointment cases. As of AG-464 No longer on forms.x
New_Department_Contact_Name__cNew Department Contact Nametext
Name of the contact in the new department for transfers. No longer on forms. As of AG-464 No longer on forms.x
New_Employee__cNew Employee



New_employee_checklist_sent__cNew Employee Checklist Sent



New_Hire_Email__cNew Hire Email
form

New_Hire_Name__cNew Hire NametextformName of new hire, entered from Onboarding and Recruitment cases
New_Hire_Phone__cNew Hire Phone
form

New_Home_Department_Code__cNew Home Department Code
form

New_Position__cNew Position



New_Salary__cNew Salary
form

New_Timesheet_Supervisor__cNew Timesheet Supervisor
form

New_Timesheet_Supervisor_Backup__cNew Timesheet Supervisor Backup



New_Title__cNew Title
form

NIH_Cap__cNIH Cap
form

Notify_HR_if_Retiree_has_10yr_Service__cNotify HR if Retiree has 10yr + Servic



Number_of_Applicants__cNumber of Applicants



Number_of_Months__cNumber of Months
form

Number_of_Positions__cNumber of Positions
form

Number_of_Students_Hiring__cNumber of Students Hiring
form

Number_of_Students_Hiring1__cNumber of Students Hiring
form

Object_Code__cObject Code



Onboarding_Appointment_Date__cOnboarding Appointment Date



Onboarding_Packet_Sent__cOnboarding Packet Sent



Optional_Timesheet_Supervisor__cOptional Backup Timesheet SupervisorstringformOptional Backup Timesheet Supervisor found on Timesheet Change forms
Optional_Timesheet_Supervisor_contact__c




OriginOriginpicklistform

The communication channel from whence the case came. Values of note:

  • Community: Cases that come in from the community forms are tagged thus.
  • Email - (source): When cases enter via email-to-case, they're tagged with 'Email' followed by the source integration.

Other_Description__cOther Description
form

Owner_Alias__cOwner Aliasformula
Pulls up the owner's alias in cases. Important for Qualtrics Surveys, where we want to identify the owner (user) by name but cannot have lookups do this work for us from the Qualtrics side.
OwnerIdOwnerIdLookup (User, Queue)systemThe current owner of a case. Could be a particular user or a queue.
PA_Job_Link__cPA Job Link



PA_Position_Number__cPosition Numbertext
Position number for associated case. Part of lookup integration to Positions__c field.
PAN_to_be_Emailed__cPAN to be Emailed (Intercampus Only)



Parent_Case_Owner__cParent Case Owner



Parent_Case_Owner_Email__cParent Case Owner Emai



ParentIdParentIdlookup (Case)systemLookup to the parent of the current case (if any)
Pay_Date__cPay Date
form

Pay_Option__cPay Option
form

Pay_Period__cPay Period
form

Pay_Period_End_Date__cPay Period End Datedate
Currently used in Central Payroll - Separation Check Request to denote the end of the pay period
Payout_Comp__cPayout Comp



Payout_Date__cPayout Date



Payout_Vacation_Balance__cPayout Vacation Balance



Payroll__cPayroll



Payroll_Portion_Complete__cPayroll Portion Complete



Payroll_PPS_Entry_Complete__cPayroll PPS Entry Complete



Payroll_Services__cPayroll Services - Research Park



Percentage__cPercentage
form

Phone__cPhone



Please_Identify__cPlease Identify
form

Please_specify_appointment_affected__cPlease specify appointment affected
form

POC_Name__cPoint of Contact NametextformName of the point-of-contact as provided from forms
POC_Phone__cPoint of Contact PhonephoneformContact phone number of the point-of-contact as provided from forms
POC_Role__cPoint of Contact's RoletextintegrationThe UserRole of the point of contact of a case. Used in sharing rules for DSS/COE cases in place of predefined case teams.
POC_User__cPoint of Contact Userlookup (User)integrationPoint-of-contact user record populated via Trigger from Employee_Name__c
Point_of_Contact_Campus_Email__cPoint of Contact Campus EmailemailformEmail address for point-of-contact entered from case forms. Used in integrations to populate Employee_Name__c
Position_Assigned__cPosition Number Assigned



Position_Description__cPosition Description



Position_Description_Obtained__cPosition Description Obtained



Position_Name__c




Position_number_changes_needed__cPosition description changes needed



Position_Posted__cPosition Posted



Position_Supervises_Others__cPosition Supervises Others
form

Position_Type__cPosition Type
form

Positions__cPositionLookup (Position__c)integrationIntegration looks up value in PA_Position_Number__c and populate this field with the Position__c object which matches that number.
Possibility_of_Extension__cPossibility of Extension



PPS_Entry_Complete__cPPS Entry Complete



PPS_Entry_Complete2__cPPS Entry Complete



Pre_employment_Physical_Complete__cPre-employment Physical Complete



Pre_Employment_Requirements__cPre-Employment Requirements
form

Previous_Case_Number__cPrevious Case Number
form

Previous_position_number__cPrevious Position Number
form

Problem_Type_Topic__cProblem Type/Topic
form

Process_By_Date__cProcess By Datedate
Date transfer should be processed. As of AG-464 No longer on forms.x
ProductIdProductIdlookup (Product)systemnot usedx
Question_Category_Topic__cQuestion Category/Topic
form

ReasonReasonpicklistsystemTBAx
Reason_for_Appointment_Ending__cReason for Appointment Ending

Reason a transfer appointment ended. As of AG-464 No longer on forms.x
Reassigned_to_a_SSC_Payroll_Cordinator__cReassigned to a SSC Payroll Cordinator



Reclassification_Complete__cReclassification Complete



RecordTypeIdCase Record TyperecordtypesystemType of case. Record Types control picklist values, page layouts, and other display information.
Recruitment__cRecruitment



Recruitment_Type__cRecruitment Type



Reference__cReference
form

Regular_Full_Salary__cRegular – Full Salary



Regular_Partial_Salary__cRegular – Partial Salary



Relationship__cRelationship
form

Relative_Name_1__cRelative Name
form

Relatives_Employed_at_UCD__cRelatives Employed at UCD?
form

Relatives_Primary_Department_Name__cRelative's Primary Department Name
form

Remove_from_DMV_Add_Spreadsheet__cRemove from DMV Add Spreadsheet



Remove_Time_From_Roster__cRemove Time From Roster



Requested_By__cRequested By:



Requisition_Number__c




Research_Summer_Comp__cResearch Summer Comp



Resignation_Letter_Emailed_to_Central_HR__cResignation Letter Emailed to Central HR



Resolution__c




Retired__cRehired Retiree



Return_Date__cEstimated Return DatedateformDate employee expects to return from leave
Reviewer_Campus_Email__cReviewer Campus Email



Routing_Account_Category__cRouting Account CategorytextintegrationIf set, cases which route based on Account Category pay attention to this value. More information can be found in our /wiki/spaces/ATD/pages/341737976.
Routing_Department_Code__cRouting Department Codetextform, integrationIf set, cases which route based on Department Code pay attention to this value. More information can be found in our /wiki/spaces/ATD/pages/341737976. Set in Recruitment and Appointment Changes cases
rrpu__Alert_Message__cAlert Messagetext
Managed package where users can set up an automatic alert to pop up for anyone viewing the case.
Sabbatical_Leave__cSabbatical Leave



Salary__cSalary
formPlace to hold salary / pay rate information primarily found in the Recruitment forms.
Salary_Action__cSalary Action



Salary_Cap_Rate__cSalary Cap RatecurrencyformSalary cap rate information from Funding Change forms
Salary_Changes__cSalary Changes



Salary_Option__cSalary Option
form

Salary_Type__cSalary Type
form

Salesforce_Object__cSalesforce Object



Same_Unit__cSame Unit



Scan_Email_to_Fleet__cScan/Email to Fleet



Schedule_an_Appointment__cSchedule an Appointment



Select_Scale__cSelect Scale



Select_Step__cSelect Step
form

Send_Current_Employee_Onboarding_Email__cSend Current Employee Onboarding Email



Send_Invite_to_Apply__cSend Invite to Apply



Send_New_Employee_Onboarding_Email__cSend New Employee Onboarding Email



Sent_Contract_to_Central_HR__cSent Contract to Central HR



Separation_Check_Requested__cSeparation Check Requested



Separation_Date__cSeparation Date
form

Separation_Reason__cSeparation Reason
form

Short_Term_Extension__cShort Term Extension



Similar_Position_s__cSimilar Position(s)
form

SLA__cService-level AgreementLookup (SLA__c)integration

Service-level Agreement covering this particular case as part of the SPA engine. Populated by the case_AssignSLA trigger.

(for more information, bother jboveda@ucdavis.edu until he writes documentation and links to it here)


SlaExitDateSlaExitDate
system

SlaStartDateSlaStartDate
system

SourceIdSourceIdlookup(Social Post,Email Message)systemnot usedx
Special_Recognition_Increase__cSpecial Recognition Increase
form

Special_Recognition_Increase_Amount__cSpecial Recognition Increase Amoun
remove

Start_Date__cStart Date
form

StatusStatuspicklistsystemIdentifies where in the typical case workflow a case is. Possible values include New, In Process, and Closed
Step_Number__cStep Number
form

Steps_to_Reproduce__cSteps to Reproduce



StopStartDateStopStartDate
system

Student_Accounting__cStudent Accounting



Student_Eligibility_or_Work_Study__cStudent Eligibility or Work Study



SubjectSubjecttextsystemA 'short description' of a case, useful for searching & sorting cases. This is not filled in by case forms, but often used by Service Providers to summarize a case for easy organizing on their list views.
Subject__cSubject



Subject_Summary__cSubject/Summary
form

Submit_to_Recruiter__cSubmit to Recruiter



Submitted_on_my_Behalf__cSubmitted on my Behalf



Submitted_to_Aggie_Job_Link_for_Approval__cSubmitted to Aggie Job Link for Approval



Submitter_Attached_Resignation_Notice__cSubmitter Attached Resignation Notice



Submitter_Email__cSubmitter EmailemailformSubmitter's email address as captured from case forms
Submitter_Name__cSubmitter NametextformSubmitter's contact name as captured from case forms
Submitter_Phone__cSubmitter PhonephoneformSubmitter's phone number as captured from the public-facing case forms
Submitter_Role__cSubmitter's RoletextintegrationThe UserRole of the submitter of a case. Used in sharing rules for DSS/COE cases in place of predefined case teams.
Submitters_UserID__cSubmitter's User IDlookup (User)form, integrationLookup to the submitter's user record. Populated both by case forms and via Trigger
Submitting_on_behalf_of__cSubmitting on behalf of:picklistformField which marks whether a case is being submitted on behalf of the submitter or another employee
Subtype__cSubtypepicklistformSubcategorization for cases. Depends on the Type field
Summer_Compensation__cSummer Compensation
form

Supervisor__cSupervisor (C)lookup (Contact)integrationLookup to Contact based on email lookup from Supervisor_s_Campus_Email__c
Supervisor_s_Campus_Email__cSupervisor's Campus EmailemailformEmail address for supervisor as required to be identified in various case forms.
Supervisor_s_Name__cSupervisor's Name



Supervisory_Position__cSupervisory Position



SuppliedEmailWeb Email / Email AddressemailsystemEmail address provided in email-to-case cases
TB_Test_Complete__cTB Test Complete



Tier_Support_Level__cTier Support Level



Timesheet__cTimesheet



Timesheet_Pushed_to_Completion__cTimesheet Pushed to Completion



Timesheet_Supervisor__cTimesheet SupervisortextformEntry for Timesheet Supervisor. Part of integration for Timesheet_Supervisor_contact__c.
Timesheet_Supervisor_Changing__cTimesheet Supervisor Changing
form

Timesheet_Supervisor_contact__cTimesheet Supervisor (C)lookup (Contact)integrationLookup populated via Trigger from Timesheet_Supervisor__c. Note: currently people put in names here instead of Email addresses, thereby invalidating our integration hookup, since we look up via campus email address (the only unique ID we have for people)
Title_Code__cTitle Code
form

Topic__cTopic
form

Total_Number_Hired__cTotal Number Hired



TRM_Calculation__cTRM Calculation



TRS_Timesheet_Follow_up_Needed__cTRS Timesheet Follow-up Needed



TTB__cTime to Breachformula

Refers to the case's SLA Time-to-breach value. Used to denote whether a case is in violation of the SLA duration.

Note: this is a coarse handling of SLAs. We're currently working on a better way to track milestones & deliverables.


TypeRequest TypepicklistformUsed to organize cases into various types. These choices are limited by the RecordType. Further subdivisions are handled by the Subtype__c controlled picklist.
UCDHS_Payroll_Office__cUCDHS Payroll Office



Update_HDC__cUpdate HDC



Updated_in_PA__cUpdated in PA



Vacate_Position_in_PA__cVacate Position in PA



Vacation_Hours__c




Vacation_or_Sick_Leave__cVacation or Sick Leave



Verified_Student_Eligibility__cVerified Student Eligibility



What_is_Your_Question__cWhat is Your Question?long textform, integrationField populated from Ask a Question question. This field is also integrated from Email-to-case data; copying over the Description field into this field.
Which_Appointment_to_End__cWhich Appointment to End
form

Work_Related__cWork Related
form

Work_Schedule__cWork Schedule
form

Work_Study_Forms_Processed__cWork Study Forms Processed



Workstudy__cWorkstudy
form

X1_Student_ID__c1. Student ID
form

X1_Student_Name__c1. Student Name
form

X2_Student_ID__c2. Student ID
form

X2_Student_Name__c2. Student Name
form

X3_Student_ID__c3. Student ID
form

X3_Student_Name__c3. Student Name
form

X4_Student_ID__c4. Student ID
form

X4_Student_Name__c4. Student Name
form

X5_Student_ID__c5. Student ID
form

X5_Student_Name__c5. Student Name
form

  • No labels