Functional
Share best business practices, document issues, plan for improvements.
No Personally Identifiable Information
No logins, usernames, and passwords
Page Navigation is split up according to Board Policies and Administrative Procedure groupings rather than Banner modules.
Space Index
|
|||||||||||||||||||||||||||||||
0-92021-2022 320 Report2022-2023 320 Report 2023-2024 320 Report |
AAAC Student Contact ListData Source Snowflake Job/Process Source (Refresh Interval) Daily Ingest Report Domain Contact information for students involved in the AAC program Functional User(s) Melony Henson, Lyndsi Litten, Maria Hamid Constituent(s) First Last (Title) Report Owner
AB 540 Relief Eligibility Search
Data Source PROD_DB Job/Process Source (Refresh Interval) Application Job, Baseline Banner Tables (Live Data) Functional User(s) Elise Garcia (Director Student Success) Report Owner Elise Garcia (Director Student Success) Contains PII Yes What It’s Used F
Absence Query Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to calcu
Active Employees
Data Source Oracle [PROD] Job/Process Source (Refresh Interval) REPORTSNET.COS_SV_ACTIVE_EMPLOYEES [LIVE] Report Domain BANINST1.COS_SSO_EMPLOYEE Functional User(s) Norma Chavez (Human Resource Assistant) Constituent(s) Janet Leija (Facilities Technician)
Adjunct Faculty Evaluation
Brought this over from OneNote Data Source ORACLE [PROD] Job/Process Source (Refresh Interval) Live Data Report Domain Data is fed from SIRASGN, STVTERM, NBRJOBS, PERREVW (PEAREVW), SSBSECT, SOBPTRM and Functional User(s) Linda Reis (Human Resource Specia
Administration Manual
Service Area Outcomes 0337bef7-1179-4886-ab1d-64747fce21c5b2b61852-1ca3-4605-952b-318812829d51DECIDEDNew SAO (Service Area Outcomes) Units require VP Approval New SAO (Service Area Outcomes) Units require VP Approval Division Dashboards 9c04c4a1-4025-4f39
Administrative Services
Annual Salary Descending Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez, Vick Para Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this repo
AP Check Process
Athletic Eligibility Data Source Banner (Oracle) Job/Process Source (Refresh Interval) Live Report Domain Academic standings for athletes Functional User(s) Constituent(s) Report Owner Arianna Kennedy Data Domain(s) Academic Contains PII Yes What It’s Used For Report on the a
Attendance Accounting
California Community Colleges Memo October 6, 2021 (cccco.edu) https://www.cccco.edu/-/media/CCCCO-Website/College-Finance-and-Facilities/Fiscal-Memos/Fiscal-Memos/2021/fs2109attendanceaccountingguidancefortransitiontoinpersoninsta11y.pdf?la=en&hash=179DF
Attendance Accounting Terminology
Weekly Student Contact Hours (WSCH) Weekly Contact Hours multiplied by the number of students in the section. Student Attendance Accounting Manual (SAAM) https://www.cccco.edu/About-Us/Chancellors-Office/Divisions/College-Finance-and-Facilities-Planning/F
|
||||||||||||||||||||||||||||||
BBanner 320 Calculation of Contact HoursThis page documents how Banner calculates Contact Hours, Total Student Contact Hours, and FTES. CALB Student Handbook 8.8 was used as the primary source of truth for this documentation. note SAAM https://www.cccco.edu/About-Us/Chancellors-Office/Divisions
Banner 9 Self-Service Flex Advisory Consulting
This page and pages below house information related to the Flex Advisory service COS purchased from Ellucian spanning May 2024 - April 2025.
Banner Baseline Quick Guides for AR
Banner Naming Convention Position 1 identifies the primary system owning the form, report, job, or table. A Alumni/Development L Occupational Tax/License U Utilities B Property Tax N Position Control V Voice Response C Courts O Customer Contact X Records Indexing D Cash Drawer P
Basic Needs
Basic Needs Banner Tracking Overview Owner Miriam Sallam Contributors Jordan Lamb, Carolyn Franco Goals Launch and Utilize Banner Baseline Screens for Local Tracking and Reporting Jira tickets On this page note Changes to the program in Spring 2024 (MIS Term 243) removed the need to
|
CCCCApply Program/Major Remove or CreateCCCApply Term Setup Spring and Summer/Fall terms are created the first Tuesday of September. Log into CCCApply Portal through mygiant.cos.edu Click on “CCCApply Administrator.” image-20240826-174901.png Click on “Terms.” image-20240826-175026.png Add Term. image-20240826-175
CCFS - 320
AP 5070 https://www.cos.edu/en-us/Governance/Board/BoardPolicies/Documents/AP%205070%20-%20Attendance%20Accounting.pdf details the administrative procedure related to the 320 reporting requirement. The filed 320 reports are archived on Fiscal’s website ht
Certificate Eligibility
This does not work with certificates that have optional courses unless you run the options separately as a person will only show up with completion/current enrollment in all courses selected. This report calls a procedure called CALL PROD_DB.ACADEMIC.P_GE
Common Definitions
Database Definitions TERM CODE https://sequoias.atlassian.net/browse/GOVPUB-10 Common alias for %TERM_CODE. The first 4 digits are determined by the Academic Calendar end year. The last 2 digits refer to the semester/intersession where "10" represents Fal
Confidential Flag
Y - Confidential N - Not confidential (Previously Y) Null - Not confidential (never been Y or N) SPAIDEN>Biographical>Biographical Information>Confidential (SPBPERS_CONFID_IND)
Course Fill Pattern - End User
End of Term Counts were not stored correctly until Fall 2013. Data for terms Spring 2020, Summer 2020, Fall 2020 only exists for Census 1, Census 2 and End of Term up. Other date data for those terms does not exist until 11/05/2020. Data Source Data Wareh
Course Repeat Banner Setup
Recommended setup CALB (California Community Colleges) SOATERM Future Terms for Repeats If you want future term registrations included in the repeat evaluation, the field on the form must be checked. It defaults to unchecked. 2023-06-15_13-33-57.jpg Repea
Curated Views
|
||||||||||||||||||||||||||||||
DData GovernanceThe information herein has been put together in order to fulfill the requirements of District Objective 4.1 which is to increase the effective use of data and transparency in decision-making at all institutional levels from 2021 - 2025. Action item 4.1.1
Data Governance Working Draft
Executive Summary This document outlines the Data Governance framework for Sequoias CCD, emphasizing the structure, guiding principles, and roles and responsibilities essential for effective data management and decision-making across the district. This wo
Degree Audit Percentage Report
Data Source Snowflake Job/Process Source (Refresh Interval) Nightly Report Domain DW_PROD_DWSCHEMA_RAD_GOALDATA_DTL, DW_PROD_DWSCHEMA_DAP_AUDIT_DTL, DW_PROD_DWSCHEMA_RAD_PRIMARY_MST, COSBANNERPROD_SATURN_SGBSTDN, COSBANNERPROD_SATURN_SFRSTCR, COSBANNERPRO
Degree Work Audit In-progress Check
Data Source Snowflake Job/Process Source (Refresh Interval) Nightly Report Domain DW_PROD_DWSCHEMA_RAD_CLASS_DTL, COSBANNERPROD_SATURN_SPRIDEN, COSBANNERPROD_SATURN_SHRTCKN, COSBANNERPROD_SATURN_SHRTCKG Functional User(s) Justine Kincade (Resource Special
Dismissed Students W/ Override
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Velia Rodriguez Report Owner Velia Rodriguez Data Domain(s) Admissions and Records Contains PII Yes What It’s Used For Velia uses this report to see if students that we
Disposition
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Vicky Parra, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to check t
Dream Act AB540 Affidavit
Data Source Banner (Oracle) Job/Process Source (Refresh Interval) Live Report Domain Dream Act Students/Financial Aid. Functional User(s) Rosa Romo Sanchez, Elvia Rengel-Lemus, Rebecca Puga Constituent(s) David Loverin, Arianna Kennedy Report Owner Rebecc
|
EEllucian Customer Center Accounts and CasesCreating a Customer Center Account with Ellucian In your browser, open https://login.ellucian.com https://login.ellucian.com to get to the Ellucian sign in page image-20220211-192141.png To create a Customer Center Account, click on the “Sign up for an ac
Ellucian Finance Advisory Engagement
This is a year-long engagement with Ellucian to assist our Finance employees in understanding the Banner Finance Module, how it should be set up, how to do daily processes, and learning what is available that COS is not using. This space is for storing do
Employee Changes Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to pull
Employee Count - CCAF 351 Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to assis
Employee Review Status
Data Source Snowflake Job/Process Source (Refresh Interval) Day-old data ingestion into Snowflake. Functional User(s) Keila Reynoso, Linda Reis, Lori Jones, Nancy Yanes, Norma Chavez Constituent(s) Keila Reynoso Report Owner John Bratsch Data Domain(s) Em
Employee Without Primary Job
Data Source PROD Job/Process Source (Refresh Interval) HR does data entry on PEAEMPL and/or NBAJOBS (Pulls from Live Data but Interval is Daily) Functional User(s) Keila Reynoso, Nancy Yanes, Elvia Rangel Constituent(s) Linda Reis Report Owner Keila Reyno
Employee's name (Legal or Preferred) change
Employee Name Change Info Department Legal Legal name change, Certificates, Tax documents, etc. Human Resources Preferred Name the individual wishes to go by. Class roster, Canvas, etc. Human Resources
EOPS Application Screening
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Report Owner Adrian Beltran Data Domain(s) Financial Aid Contains PII Yes What It’s Used For Assist with the EOPS application screening process. Options Options Descript
EPAF - Required Pages
49 incomplete NTRALVL Electronic Approval Level Rules 50 incomplete NTVACAT Define Approval Category 51 incomplete NTVAPTY Define approval type code, to be linked to approval category 52 incomplete NTRACAT Define rules for approval type codes, (go to opti
Excluded Gross Earnings from WC Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to assis
|
||||||||||||||||||||||||||||||
FFaculty Flex HoursFaculty Flex Hours is a custom web application that contains the read and write functionality for COS Faculty flex hours.
Faculty Flex Hours (Full Access)
Data Source Oracle (Data Entry) & Snowflake (Parameters) Job/Process Source (Refresh Interval) Live Data Report Domain Flex hours banked by COS Faculty Functional User(s) Constituent(s) Report Owner Data Domain(s) Employee Contains PII No What It’s Used F
Faculty Flex Hours (Short)
Data Source What database(s) the report primarily pulls from. Job/Process Source (Refresh Interval) The job or process that populates the data domain. Important jumping off point for issues that may arise. Report Domain Where the aggregate data, or combin
Financial Aid
Fiscal Services Flex Advisory Meeting Recordings May 7 SSB9 Advisory Kickoff Meeting https://giantcosedu.sharepoint.com/:v:/s/Banner9Self-ServiceAdvisory/EbCNzRaf9wtAr4D0j7imERkBxkrb6YliSxgfVabfc8GkuQ?e=n5kDOf
FTES OLAP Cube (Special Classes - AAC 70% Funds Transfer)
Instructions on how to run the Special Classes saved setting for the FTES OLAP Cube. Select the FTES OLAP Cube link from the EIS report menu. Log in to Argos. image-20230807-185008.png When the FTES OLAP Cube screen appears, select the desired Reporting Y
Functional
note Share best business practices, document issues, plan for improvements. Share best business practices, document issues, plan for improvements. No Personally Identifiable Information No logins, usernames, and passwords Page Navigation is split up accor
Functional Views
74013e4d-08e3-41b1-93c8-2ef34e8fa2690b49455b-a0b0-4ff5-b9a6-930ded85cc70DECIDEDFor functional views that return only 1 affirmative value. Return the Data Element name (Summary field) in a column of the same name.5b43d2aa-7bc3-4d16-b5ed-802d48e824aaDECIDED
|
GGrade DistributionData Source Snowflake (Invoke) Job/Process Source (Refresh Interval) Day-old Data ingestion into Snowflake. Functional User(s) Velia Rodriguez Constituent(s) Richard Lubben Report Owner Arianna Kennedy Data Domain(s) Academic Contains PII No What It’s Use
Gross and Net by Pay Type
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez, Vick Para Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this repo
|
||||||||||||||||||||||||||||||
HHealth EligibilityData Source ORACLE [PROD] Job/Process Source (Refresh Interval) Daily Ingest Report Domain MEDIATOR.COS_PYRAMED_VW_STUDENTS Functional User(s) Tammi Hitchcock, Araselia Gonzalez, Cecilia Ruiz Constituent(s) First Last (Title) Report Owner Tammi Hichcock D
HR - Terminated Employees
Data Source Snowflake Prod_DB Job/Process Source (Refresh Interval) HR does data entry on PEAEMPL and/or NBAJOBS (Pulls from day old data in Snowflake) Functional User(s) Norma Chavez Constituent(s) Linda Reis Report Owner Norma Chavez Data Domain(s) Empl
Human Resources
|
II50 ReportData Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Vicky Parra, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to calcula
Incomplete Status by Campus
Data Source Oracle Job/Process Source (Refresh Interval) Live Report Domain Student financial aid completion status. Functional User(s) Rebecca Puga Report Owner Rebecca Puga Data Domain(s) Financial Aid Contains PII Yes What It’s Used For Find students t
|
||||||||||||||||||||||||||||||
J |
K |
||||||||||||||||||||||||||||||
LLarge Lecture CompensationData Source Oracle Job/Process Source (Refresh Interval) Live Report Domain Census Enrollment and Pay Compensation Functional User(s) Khantee See, Daniel Alvarado Constituent(s) First Last (Title) Report Owner Khantee See Data Domain(s) Academic Contains
|
MManually update Popsel with a fileIf a popsel hasn’t been created in Banner, IT will need to create one for you. Run the following PL/SQL: DECLARE v_application GENERAL.GLBSLCT.GLBSLCT_APPLICATION%TYPE := 'GENERAL'; v_selection GENERAL.GLBSLCT.GLBSLCT_SELECTION%TYPE := '<use
Material Fees
Data Source Oracle Job/Process Source (Refresh Interval) Live Report Domain Course Material Fees Functional User(s) Constituent(s) Report Owner Data Domain(s) Finance Contains PII No What It’s Used For Course Material Fees by Term, Campus, Division, and/o
MIS
This is the report documentation location for MIS Reports.
|
||||||||||||||||||||||||||||||
NNuventive Improve (formerly TracDat)This space will be used to explain how to use Nuventive tool and it will document decisions Sequoias CCD made for its use. note Please leave comments for questions, errors, ideas for improvement. Please leave comments for questions, errors, ideas for impr
|
OOpen Entry Part of Term Code SetupSTVPTRM setup image-20240206-211710.png note Consider having the Description be “Open Entry, Open Exit” Consider having the Description be “Open Entry, Open Exit” SOATERM setup image-20240207-002128.png If Alternative Attendance Accounting Procedure – Non
|
||||||||||||||||||||||||||||||
PPayroll Monthly by AccountData Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Valiree Yzavel Gonzalez, Vick Para Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to reconcile
Payroll Prelist Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to assis
Placement Scores
Math Placement Grid Grid Effective Term: 202530 High School Coursework (Min) GPA ≥ 2.6 Test Code Test Score MIS SL Report GPA<2.6 Test Code Test Score MIS SL Report Enrolled in Calculus OR Passed with a minimum grade of C: Trigonometry Pre-Calculus Math A
|
QQuarterly Gross ReportData Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to assis
|
||||||||||||||||||||||||||||||
RRecording of AP Check Run ProcessAP Check Run Process 20231009 https://giantcosedu.sharepoint.com/:v:/s/FinanceAdvisoryGroup/Ef7iRWob0G9Lm58bfBoS9fYBbciSiN05FQsk1kF7f6ct_Q?e=D2TPdG
Recordings of Finance Advisory Meetings
Links to video recordings of the Advisory meetings (files stored in Microsoft Teams) Audio Transcripts can be found in the Finance Advisory Group Teams site https://giantcosedu.sharepoint.com/:f:/s/FinanceAdvisoryGroup/EheoftQS8y9MktTTsqj9trUBZA_4Hf-wNjPh
Registration Statistics
Registration statistics - Argos Web Viewer https://argos.cos.edu/Argos/AWV/#explorer/Student%20Services/Registration%20statistics This report is pulled from SFRSTCR, most of SFRSTCR is shown on the front page SFAREGS. note SFRSTCR has the current registra
Regroup Documentation
Regroup Message Guidelines and Information If a student wishes to opt-out of any general regroup messages. They can reply “Stop” to the text message. This will block regroup from sending messages to them. When sending Text Messages, start the text with so
Report Access by Group
Dean Level EIS Reports Access Accounting and Finance Budget Summary Detail Budget Student Services Census Enrollment Early Alert Student Search Students by Faculty Course Academic Services – Access to all reports Academic Calendar Canceled Courses Course
Report Documentation
@self
Reporting Year Data Quality
Data Source Snowflake Job/Process Source (Refresh Interval) Snowflake is populated nightly from Banner tables. Report Domain The report focuses on term and section-related information, specifically targeting reporting years and fiscal years. It gathers an
Room Schedule
Data Source Banner (Oracle) Job/Process Source (Refresh Interval) Production (Live) Report Domain Room Availability and Scheduling Functional User(s) Division Chairs, Deans Constituent(s) Report Owner Vanessa Escobar (Scheduling Coordinator) Data Domain(s
|
SSchedule ExceptionsTAB: Schedule Exceptions Not Yet Complete TAB: Room Capacity - Section Capacity Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Vanessa Escobar Report Owner Vanessa Escobar Data Domain(s) Academic Services Contains
Section Fill Rate
Data Source PROD_DB Job/Process Source (Refresh Interval) Baseline Banner Tables (Live Data) Functional User(s) First1 Last1 (Title1), First2 Last2 (Title2) Report Owner Vanessa Escobar (Scheduling Coordinator) Contains PII No What It’s Used For To analyz
Section Seating
note The report has two different tabs but the intent is just to return additional columns in the Seating (All Columns) tab and not to modify the results. The report has two different tabs but the intent is just to return additional columns in the Seating
Settings to control the automated HOLD process
The nightly process that evaluates which student records should have a financial hold placed on them is controlled by a GTVSDAX setting. During the time the college wishes not to place financial holds on student accounts due to the pandemic, the value con
SG
This is the location for MIS reports relating to the SG MIS files.
SG21 Data Quality Report
Data Source This report pulls data from PROD_DB on Snowflake Job/Process Source (Refresh Interval) This report is built off of two views. The refresh interval would be daily as that is how often Snowflake is updated. The Two views are: PROD_DB.ACADEMIC.V_
Snowflake STUDENT_TERM View
Proposed Architecture/Reference: COS_DATALAKEHOUSE.COS_CURATED.STUDENT_TERM Domain: note Tables Used (Document these in each element instead): GOREMAL, GORPRAC, SFBETRM, SFRTHST, SGBSTDN, SHRLGPA, SHRTGPA, SMRPRLE, SPBPERS, SPRADDR, SPRHOLD, SPRIDEN, SPRT
SOACALD/SSAACRL/SSAEXCL Data Entry
note Page necessary for Term Setup. Page necessary for Term Setup. Mandatory for 320 Faculty Contact Hours (Flex Calendar) reporting. Set up SVRCALS flex calendar reporting (elluciancloud.com) https://resources.elluciancloud.com/bundle/banner_cal_calbstu_
Social Security Match Up
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Vicky Parra, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to search
Student Holds
Data Source Oracle & Data Warehouse Job/Process Source (Refresh Interval) Live production data and Day old data from Data Warehouse Functional User(s) Christy Ortega Constituent(s) Arianna Kennedy Report Owner Michele Brock Data Domain(s) Academic Contain
Student Services
Student Success Program by Term, Coordinator Data Source Oracle, PROD_DB.ReportsNet Job/Process Source (Refresh Interval) V_ACAD_STUDENT_SUCCESS (Live Data) Report Domain SFRSTCR, SERDTSR, SERDTGL Functional User(s) Michelle Gilbert (Director Student Success), Charlene Briggs-Woods (Senior Clerical
Student Success Program Data
In 2024 we moved to using Banner to store Student Success Program data. It’s the hope of this project that inputting the Student Success Program data will support Research analysis, long term program improvements or clarity, and an improvement of the busi
Student Surveys
CCCApply Supplemental Questions image-20231002-182139.pngimage-20231002-182153.png You can view or download the supplemental questions from the following page: image-20231002-182257.png Supplemental Questions Consider including help text that can be shown
Student's name (Legal or Preferred) change
The Student Demographic Change Form https://www.cos.edu/en-us/Admissions-Aid/Documents/Student%20Demographic%20Change%20Form.pdf is used to modify a student's name (Legal or Preferred). Have the student follow the directions at https://www.cos.edu/en-us/a
SUI Count Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to calcu
SUI Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Vicky Parra, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to calcula
|
||||||||||||||||||||||||||||||
TTax Deposit Data Monthly/Quarterly ReportData Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to assis
Technology Services
Term Setup Termination Employee Listing Report Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez, Vicky Para Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this rep
|
UUnit Naming ConventionReporting Units District Goals District Objectives: YYYY-YYYY General Education Learning Objectives Institutional Learning Outcomes Assessment Units Governance - Committee Name / Council Name / Senate Name PLO (DIV-DEP/SUBJ) - Program - Type note The last
|
||||||||||||||||||||||||||||||
VVacation Amounts for End of Year Closing ReportData Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll runs this report to budge
Vet Client
Data Source PROD_DB Job/Process Source (Refresh Interval) Live Functional User(s) Ashley Martinez Report Owner Jenny Sae Chao Contains PII Yes What It’s Used For This report is used for meeting Veterans compliance (Need more info on this) Options Options
Voluntary Deduction Roster/Totals
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this report to assis
|
WWC2 QueryData Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez, Vick Para Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this repo
Workers Comp OT Report
Data Source Oracle Job/Process Source (Refresh Interval) Live Data Functional User(s) Mary Schaefer, Valiree Yzavel Gonzalez, Vick Para Report Owner Valiree Yzavel Gonzalez Data Domain(s) Payroll Contains PII Yes What It’s Used For Payroll uses this repo
Workspace 2021-2022 Recal
Deadline of Reason for Recalculation Submission Carry Forward (CF) for Hanford, Tulare and the District is understated. Three CRNs were miscalculated only on the CF and only partially backed out of the total FTES filed. Specifically, I messed up on a flat
Workspace 2021-22, Annual
Run 1 SELECT SSBSECT_TERM_CODE ,SSBSECT_CRN ,SSBSECT_SUBJ_CODE ,SSBSECT_CRSE_NUMB ,SSBSECT_ACCT_CODE ,SFRSTCR_GRDE_CODE ,SSBSECT_PTRM_END_DATE ,F_GETSPRIDENID(SIRASGN_PIDM) AS "BANNER ID" ,F_FORMAT_NAME(SIRASGN_PIDM, 'FL') FROM SSBSECT LEFT JOIN SFRSTCR O
Workspace 2021-22, P2
Run 1 Baseline 1 complete SVAAPIZ Populate Academic Year District: Do it for 561, 562, 563 Reporting Period: P1 - 2 P2 - 1 Annual - 1 618 complete SVRCALX 634 complete Sort through the list and resolve errors prior to next step Runtime ~5 minutes 04 – Inc
Workspace 2022-23, Annual
Runs Preliminary: Run 1: Certified: Baseline Reports 1 complete SVAAPIZ (Academic Year Annualizer) - Irrelevant for Annual Populate Academic Year District: Do it for 561 Reporting Period: P1 - 2 P2 - 1 618 complete SVRCALX Runtime ~5 minutes 04 – Include
Workspace 2022-23, P1
Run 1 Baseline 1 complete SVAAPIZ Populate Academic Year District: Do it for 561, 562, 563 Reporting Period: P1 - 2 P2 - 1 Annual - 1 618 complete SVRCALX 634 complete Sort through the list and resolve errors prior to next step Runtime ~5 minutes 04 – Inc
Workspace 2022-23, P2
Run 1 Baseline 1 complete SVAAPIZ Populate Academic Year District: Do it for 561 Reporting Period: P1 - 2 P2 - 1 Annual - 1 618 complete SVRCALX 634 complete Sort through the list and resolve errors prior to next step Exception CRNs not reported: Actual C
Workspace 2023-24, Annual
Runs Preliminary: Run 1: Certified: Setup 788 complete Evaluate Banner Setup for Known Defects 789 complete GUAABOT vs. Customer Center image-20240322-214503.png No known defects after our Banner update went to 8.19 for California Student. note Expect thi
Workspace 2023-24, P1
Setup 672 incomplete Evaluate Banner Setup for Known Defects Runs Run 1: Run 2: 667 complete Certified: 668 incomplete Uploaded to Auditor Site (Suralink): note Auditor Portal not open for 2023-24 as of Auditor Portal not open for 2023-24 as of 16 Jan 202
Workspace 2023-24, P2
Setup 672 complete Evaluate Banner Setup for Known Defects 783 complete GUAABOT vs. Customer Center image-20240322-214503.png No known defects after our Banner update went to 8.19 for California Student. 784 complete Run SSASECT Incorrect Reporting Year -
Workspace 2024-25, P1
Runs Preliminary: Run 1: Certified: Setup 788 788 complete Evaluate Banner Setup for Known Defects 794 794 complete PD0016062 https://elluciansupport.service-now.com/customer_center?id=standard_ticket_customer_center&table=ellucian_product_defect&sys_id=3
|
||||||||||||||||||||||||||||||
X |
Y |
||||||||||||||||||||||||||||||
Z |
!@#$ |
👀 Most viewed articles
https://sequoias.atlassian.net/wiki/spaces/MIS/pages/695402645
🕑 Recently updated
You'll see the 5 most recently updated pages that you and your team create.
Â
Â
Â