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

Version 1 Next »

Overview

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.

Field NameLabelTypeSourceDescription
Account__cAccount
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 copying the case and submitting it to Payroll via 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 unpopulated
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?longtextformText field for additional comments. Found on most every form save Ask a Question.
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



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

form
Case_Age__cCase Age


Case_Priority__cCase Priority


Case_Routing_Account_Category__c



Case_Routing_Department_Code__cCase Routing Department Code


CaseNumber



Category__cCategory
form
Central_Payroll_to_Process_Final_Check__cCentral Payroll to Process Final Check


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



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



ContactEmail



ContactFax



ContactId



ContactID__cContact ID
form
ContactMobile



ContactPhone



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 Record


Create_Payroll_Case__cCreate Payroll Caseboolean
Triggers creation of a case to send to Payroll via the action_copyCase_onboardingHRtoPayroll invocable Apex method
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
CreatorFullPhotoUrl



CreatorName



CreatorSmallPhotoUrl



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 Hire


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
Description



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


Do_you_know_your_return_date__cDo you know your return date?
form
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


Email_Address__cEmail Address


Email_to_Fleet__cEmail to Fleet


Emeritus_Separation__cEmeritus Separation
form
Employee_Entered_in_TRS__cEmployee Entered in TRS


Employee_Name__cEmployee NameLookup (User)formLookup to POC user 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



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



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



IsClosedOnCreateIsClosedOnCreate


IsDeleted



IsEscalatedIsEscalated


IsStoppedIsStopped


Issue_Description__cIssue Description
form
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 Pay


LastModifiedById



LastModifiedDate



LastReferencedDate



LastViewedDate



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


Mailing_Address_Verified__cMailing Address Verified


Medical_Certification_Received__cMedical Certification Received


Medical_Release_Documentation_Received__cMedical Release Documentation Received


MilestoneStatusMilestoneStatus


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 Contact


New_Department_Contact_Campus_Email__cNew Department Contact Campus Email
form
New_Department_Contact_Name__cNew Department Contact Name
form
New_Employee__cNew Employee


New_employee_checklist_sent__cNew Employee Checklist Sent


New_Hire_Email__cNew Hire Email
form
New_Hire_Name__cNew Hire Name
form
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__cOptional
form
Optional_Timesheet_Supervisor__c



Optional_Timesheet_Supervisor_contact__c



OriginOrigin
form
Other_Description__cOther Description
form
OwnerIdOwnerId


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


ParentIdParentId


Pay_Date__cPay Date
form
Pay_Option__cPay Option
form
Pay_Period__cPay Period
form
Pay_Period_End_Date__c



Pay_Rate__cPay Rate
form
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 Email
form
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 Date
form
ProductIdProductId


Question_Category_Topic__cQuestion Category/Topic
form
ReasonReason


Reason_for_Appointment_Ending__cReason for Appointment Ending
form
Reassigned_to_a_SSC_Payroll_Cordinator__cReassigned to a SSC Payroll Cordinator


Reclassification_Complete__cReclassification Complete


RecordTypeId

form
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


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 Message


Sabbatical_Leave__cSabbatical Leave


Salary__cSalary
form
Salary_Action__cSalary Action


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


SlaStartDateSlaStartDate


SourceIdSourceId


Special_Recognition_Increase__cSpecial Recognition Increase
form
Special_Recognition_Increase_Amount__cSpecial Recognition Increase Amoun


Start_Date__cStart Date
form
StatusStatus


Step_Number__cStep Number
form
Steps_to_Reproduce__cSteps to Reproduce


StopStartDateStopStartDate


Student_Accounting__cStudent Accounting


Student_Eligibility_or_Work_Study__cStudent Eligibility or Work Study


SubjectSubject


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 Email
form
Submitter_Name__cSubmitter Name
form
Submitter_Phone__cSubmitter Phone
form
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 ID
form
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__cSubtype
form
Summer_Compensation__cSummer Compensation
form
Supervisor__cSupervisor (C)


Supervisor_s_Campus_Email__cSupervisor's Campus Email
form
Supervisor_s_Name__cSupervisor's Name


Supervisory_Position__cSupervisory Position


SuppliedEmail



SystemModstamp



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 Supervisor
form
Timesheet_Supervisor_Changing__cTimesheet Supervisor Changing
form
Timesheet_Supervisor_contact__cTimesheet Supervisor (C)


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 Breach


TypeRequest Type
form
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?
form
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



Affected_Employee_PPS_ID__c

  • No labels