{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Pre-Journal Template","Pre-Journal Examples","Fields Guide","Instructions on Redirects","MSCT Request Reason"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Pre-Journal Template","index":0,"n_rows":1,"n_cols":19,"rows_kept":1}
["Employee ID","ENTITY","FUND","ACTIVITY","ACCOUNT","FUNCTION","PROGRAM","PROJECT ID","FLEX 1","FLEX 2","Debit AMOUNT","Credit AMOUNT","Earnings End Date","Project Expiration Date ","Reason Code for MSCT","Requester Empl ID","Requester ORGID","Requester DEPTID","UR Ticket"]

{"sheet":"Pre-Journal Examples","index":1,"n_rows":32,"n_cols":19,"rows_kept":32}
["Example 1: Salary Cost Transfer - Moving expense from a default project to a C&G project"]
["Employee ID","ENTITY","FUND","ACTIVITY","ACCOUNT","FUNCTION","PROGRAM","PROJECT ID","FLEX 1","FLEX 2","Debit AMOUNT","Credit AMOUNT","Earnings End Date","Project Expiration Date ","Reason Code for MSCT","Requester Empl ID","Requester ORGID","Requester DEPTID","UR Ticket"]
[10012180,"1511","19900","A02191","500010","40","000","0000000000","D02000A001","F0012180",null,9095.68,"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511",18200,"A02192","500010",44,"000","K015005001","0000000000","00000000",9095.68,null,"2024-08-31","2024-09-15",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511","19900","A02191","506600","40","000","0000000000","D02000A001","F0012180",null,{"v":2728.703130986264,"d":"2728.70"},"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511",18200,"A02192","506600",44,"000","K015005001","0000000000","00000000",{"v":2728.703130986264,"d":"2728.70"},null,"2024-08-31","2024-09-15",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511","19900","A02191","506840","40","000","0000000000","D02000A001","F0012180",null,{"v":818.6109392958792,"d":"818.61"},"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511",18200,"A02192","506840",44,"000","K015005001","0000000000","00000000",{"v":818.6109392958792,"d":"818.61"},null,"2024-08-31","2024-09-15",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511","19900","A02191","506610","40","000","0000000000","D02000A001","F0012180",null,{"v":53.722429158462056,"d":"53.72"},"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511","ZZZZZ","A01392",215073,"00","000","0000000000","0000000000","00000000",{"v":53.722429158462056,"d":"53.72"},null,"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511","19900","A02191","755200","40","000","0000000000","D02000A001","F0012180",null,{"v":58.21523017349357,"d":"58.22"},"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511",19900,"A01645","755200",72,"000","0000000000","0000000000","00000000",{"v":58.21523017349357,"d":"58.22"},null,"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511","19900","A02191","755210","40","000","0000000000","D02000A001","F0012180",null,{"v":105.5156478230421,"d":"105.52"},"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[10012180,"1511",19900,"A01645","755210",72,"000","0000000000","0000000000","00000000",{"v":105.5156478230421,"d":"105.52"},null,"2024-08-31","N/A",2,10028999,"ORG11","D01054","UR0017000"]
[]
["Example 2: Salary Cost Transfer - Moving expense from one C&G project to another for multiple earnings period"]
["Employee ID","ENTITY","FUND","ACTIVITY","ACCOUNT","FUNCTION","PROGRAM","PROJECT ID","FLEX 1","FLEX 2","Debit AMOUNT","Credit AMOUNT","Earnings End Date","Project Expiration Date ","Reason Code for MSCT","Requester Empl ID","Requester ORGID","Requester DEPTID","UR Ticket"]
[10013298,1511,21100,"A01094",500480,44,"000","K014026001","0000000000","00000000",null,4494.31,"2024-07-31","2024-09-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,57000,"A01094",500480,44,"000","K014124001","0000000000","00000000",4494.31,null,"2024-07-31","2025-08-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,21100,"A01094",506600,44,"000","K014026001","0000000000","00000000",null,1964.02,"2024-07-31","2024-09-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,57000,"A01094",506600,44,"000","K014124001","0000000000","00000000",1964.02,null,"2024-07-31","2025-08-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,21100,"A01094",500480,44,"000","K014026001","0000000000","00000000",null,4494.31,"2024-08-31","2024-09-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,57000,"A01094",500480,44,"000","K014124001","0000000000","00000000",4494.31,null,"2024-08-31","2025-08-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,21100,"A01094",506600,44,"000","K014026001","0000000000","00000000",null,1964.02,"2024-08-31","2024-09-15",3,10028111,"ORG14","D01040","UR00105689"]
[10013298,1511,57000,"A01094",506600,44,"000","K014124001","0000000000","00000000",1964.02,null,"2024-08-31","2025-08-15",3,10028111,"ORG14","D01040","UR00105689"]
[]
["Example 3: Benefits Cost Transfer Request - Removing unallowable expense from a C&G project to a default project for multiple earnings period"]
["Employee ID","ENTITY","FUND","ACTIVITY","ACCOUNT","FUNCTION","PROGRAM","PROJECT ID","FLEX 1","FLEX 2","Debit AMOUNT","Credit AMOUNT","Earnings End Date","Project Expiration Date ","Reason Code for MSCT","Requester Empl ID","Requester ORGID","Requester DEPTID","UR Ticket"]
[10462957,1511,21100,"A01096",506600,44,"000","K011700001","0000000000","00000000",null,285.11,"2023-09-30","2024-04-15",5,10058975,"ORG12","D01164","UR00101010"]
[10462957,1511,19900,"A01865",506600,40,"000","0000000000","0000000000","F0006809",285.11,null,"2023-09-30","N/A",5,10058975,"ORG12","D01164","UR00101010"]
[10462957,1511,21100,"A01096",506600,44,"000","K011700001","0000000000","00000000",null,950.36,"2023-08-31","2024-04-15",5,10058975,"ORG12","D01164","UR00101010"]
[10462957,1511,19900,"A01865",506600,40,"000","0000000000","0000000000","F0006809",950.36,null,"2023-08-31","N/A",5,10058975,"ORG12","D01164","UR00101010"]

{"sheet":"Fields Guide","index":2,"n_rows":20,"n_cols":3,"rows_kept":20}
["Pre-Journal Element","Source","Notes"]
["Employee ID","Looker Payroll Distribution"]
["ENTITY","Looker Payroll Distribution"]
["FUND","Looker Payroll Distribution"]
["ACTIVITY","Looker Payroll Distribution"]
["ACCOUNT","Looker Payroll Distribution"]
["FUNCTION","Looker Payroll Distribution"]
["PROGRAM","Looker Payroll Distribution"]
["PROJECT ID","Looker Payroll Distribution"]
["FLEX 1","Looker Payroll Distribution"]
["FLEX 2","Looker Payroll Distribution"]
["Debit AMOUNT","Looker Payroll Distribution"]
["Credit AMOUNT","Looker Payroll Distribution"]
["Earnings End Date","Looker Payroll Distribution"]
["Project Expiration Date ","Oracle Financial System"]
["Reason Code for MSCT","MSCT Guidance Document"]
["Requester Empl ID","Analyst Empl ID submitting the MSCT Request"]
["Requester ORG ID","Analyst ORG ID submitting the MSCT Request"]
["Requester DEPT ID","Analyst DEPT ID submitting the MSCT Request"]
["UR Ticket","The ServiceNow Ticket number","Enter before attaching the file"]

{"sheet":"Instructions on Redirects","index":3,"n_rows":13,"n_cols":12,"rows_kept":13}
["UCRP SI:"]
["a.       If UCRP SI benefit charge is blank in the employee’s pay line, then either the employee might have not opted for the UCRP SI program OR the Project is a C&G project, as we do not charge UCRSP SI to C&G Projects. All C&G projects start with a K."]
["b.       Check if the transfer from Project is a K Project and transfer to is also a K Project, the charge will remain on the offset COA. If this is the case, then no UCRP Si line entry is needed."]
["c.       Check if the transfer to project is a K Project, if this is true, then redirect UCRP SI benefit to the redirect offset COA below:"]
[{"$nulls":3},"Entity","Fund","Activity","Account","Function","Program","Project","Flex1","Flex2"]
[{"$nulls":3},1511,"ZZZZZ","A01392",215073,"00","000","0000000000","0000000000","00000000"]
["GAEL:"]
["a.       Check if the transfer to project is a K Project. If this is true, debit the GAEL charges to the offset COA (below)."]
[{"$nulls":3},"Entity","Fund","Activity","Account","Function","Program","Project","Flex1","Flex2"]
[null,null,"EL ",1511,19900,"A01645",755200,72,"000","0000000000","0000000000","00000000"]
[null,null,"GL ",1511,19900,"A01645",755210,72,"000","0000000000","0000000000","00000000"]
["b.       Check if the transfer to and from projects are K Projects. No journal entry is needed since both the debit and credit will remain on the GAEL Redirect COA."]
["c.       If the transfer to and from do not include a K Project, the GAEL charges should be credited and debited to the transfer from and to COAs, respectively."]

{"sheet":"MSCT Request Reason","index":4,"n_rows":6,"n_cols":6,"rows_kept":6}
["Reason Code","Reason","Description","Processed via","PI Approval Required","Required Approvals"]
[1,"Technical Issue UCPath","Due to UCPath system bug that prevented the processing of an SCT transaction in UCPath","OCF - Manual Journal Entry","When impacting C&G Project","FAO, CFAO"]
[2,"Late Award","Payroll expenses were processed on another funding source while the award is being approved  ","OCF - Manual Journal Entry","Required","FAO, CFAO, PI"]
[3,"Late Setup of Chartfields","One or more CoA segment was not setup in time or correctly","OCF - Manual Journal Entry","When impacting C&G Project","FAO, CFAO"]
[4,"Retro Pay","Payroll retro processing was processed on previous position funding and it must be moved","OCF - Manual Journal Entry","When impacting C&G Project","FAO, CFAO"]
[5,"Late Notification from the PI","PI notified finance, after a project expiration, or after 120 days of transaction date, of the need to charge payroll expenses to a project or transfer from a project","OCF - Manual Journal Entry","Required","FAO, CFAO, PI"]