Child pages
  • CRDC-Civil Rights Report
Skip to end of metadata
Go to start of metadata

overview

The CRDC option is available from the MENU system. This option appears under the USPS/ USPS_ANN sub menu. CRDC produces a report listing different required variables for specific reporting groups. .Specifications of data selection for all schedules include : the USPJOB record must be set to be reportable to EMIS and the position status is not equal U or a position status of U, but has a separation date after CCYY/06/30, where CCYY is the prior year and lastly, the fund source code must = A, B, G, I, L, N, T, or U to be included.  

The information from the CRDC is based off Federal requirements.  The CRDC report  was created to be a major aid in finding the requirements, but may not be inclusive of everything.  Some additions or subtractions may be needed by the districts.

accessing the program

The program may be executed as follows:

In the menu system type:

Menu>RUN PAY:CRDC

or at the $ prompt in the menu system type:
Menu>CRDC


Instructional Staff- SCH-0044  These records will be sorted by building IRN then by staff name. The data for the Instructional Staff will contain building IRN, employee name, EMPID, state assigned ID, position code, contract amount from the  EMIS Contract Info field or contract amount from the JOBSCN, if the EMIS contract field is blank. The contract amount for each building will be totaled and their will be a there will be a group total for the Instructional Staff.

The following Position codes and assignment areas are designated for the Instructional Staff:

Position Code       Assignment Area

108					Any except blank
109					Any except blank
230					999050
230					999140
230					999270
230					999365
230					999370
230					999380
Any					999412
Any					999414
230					999418
230					999570
230					999725
230					999800
230					999895
299					Any 
415				    Any except blank
905				    Any except blank

 

Support Services Student-SCH-0044 These records will be sorted by building IRN then by staff name. The data for the Support Services Student  will contain building IRN,  employee name, EMPID, state assigned ID, position code, contract amount  from the EMIS Contract Info field or contract amount from  the JOBSCN  if  the EMIS contract field is blank. The contract amount for each building will be totaled and their will be a there will be a group total for the Support Services Student.

The following Position codes and assignment areas are designated for the Support Services Student:

Position Code       Assignment Area

202					Any
204					Any
318					Any
320					Any
323                 Any
325					Any
326					Any
327					Any
328					Any
329					Any
330					Any
331					Any
332					Any
333					Any
334					Any
399					Any
406					Any
910                 Any

Support Services Staff- SCH-0044 These records will be sorted by building IRN then by staff name. The data for the Support Services Staff Group will contain building IRN,  employee name, EMPID, state assigned ID, position code, contract amount  from the EMIS Contract Info field or contract amount from  the JOBSCN  if  the EMIS contract field is blank. The contract amount for each building will be totaled and their will be a there will be a group total for the Support Services Staff.

The following Position codes and assignment areas are designated for Support services Staff:

Position Code       Assignment Area

201					Any
203					Any
209					Any
402					Any
407					Any
414					Any
499					Any

Support Services Adminstration-SCH-0044 These records will be sorted by building IRN then by staff name. The data for the Support Services Administration Group will contain building IRN,  employee name, EMPID, state assigned ID, position code, contract amount  from the EMIS Contract Info field or contract amount from  the JOBSCN  if  the EMIS contract field is blank. The contract amount for each building will be totaled and their will be a there will be a group total for the Support Services Administration.

The following Position codes and assignment areas are designated for Support Services Administration:

Position Code       Assignment Area

103					Any
104					Any
108					Blank only
109					Blank only
110					Any
112					Any
113					Any
114					Any
115					Any
116					Any
120					Any
121					Any
199					Any

Instructional Staff- SCH-0045  These records will be sorted by building IRN then by staff name. The data for the Instructional Group will contain building IRN, employee name, EMPID, state assigned ID, position code, contract amount from the  EMIS Contract Info field or contract amount from the JOBSCN, if the EMIS contract field is blank., FTE from  the EMIS Contract Info field or FTE from the POSSCN  if  the EMIS contract field is blank. The contract amount and FTE for each building will be totaled and their will be a there will be a group total for the Instructional Staff.

The following Position codes and assignment areas are designated for the Instructional Staff:

Position Code       Assignment Area

108					Any except blank
109					Any except blank
230					999050
230					999140
230				    999270 
230					999365
230					999370
230					999380
Any					999412
Any					999414
230					999418
230					999570
230					999725
230					999800
230					999895
299					Any 
415                 Any except blank
905                 Any except blank

Support Services-Student- SCH-0045 These records will be sorted by building IRN then by staff name. The data for the Support Services-Student Group will contain building IRN, employee name, EMPID, state assigned ID, position code, contract amount from the EMIS Contract Info field or contract amount from the JOBSCN, if the EMIS contract field is blank., FTE from the EMIS Contract Info field or FTE from the POSSCN if the EMIS contract field is blank. The contract amount and FTE for each building will be totaled and their will be a there will be a group total for the Support Services- Student Staff.

The following Position codes and assignment areas are designated for the Support Services Student:


Position Code       Assignment Area

202					Any
204					Any
318					Any
320					Any
323                 Any
325					Any
326					Any
327					Any
328					Any
329					Any
330					Any
331					Any
332					Any
333					Any
334					Any
399					Any
406					Any
910                 Any



Instructional Staff- SCH-0043  These records will be sorted by building IRN then by staff name. The data for the Instructional Group will contain building IRN, employee name, EMPID, state assigned ID, position code, contract amount from the  EMIS Contract Info field or contract amount from the JOBSCN, if the EMIS contract field is blank., FTE from  the EMIS Contract Info field or FTE from the POSSCN  if  the EMIS contract field is blank. and absences greater than 10 which  include sick, personal leave, dock, jury duty, military and other. The contract amount , FTE and Absences >10  for each building will be totaled and their will be a there will be a group total for the Instructional Staff.

main menu

 

_______________________________________________________________________________
|                           OECN USPS System                                  | 
|  USPS_ANN           Annual / Quarterly Programs                             |
|  ---------------------------------------------------------------------------|
|                                                                             |
|  1. CLRATD     Clear EMIS Long-term Illness Days                            |
|  2. CRDC       Civil Rights Data Collection Reporting                       |
|  3. NEWCNT     New Contract Program           							  |	
|  4. ODJFSRPT   ODJFS Unemployment Wage Reporting							  |
|  5. PAYDEL     Auto Deletion of Pay Accounts							      |
|  6. QRTRPT     Quarterly Earnings Report									  |
|  7. SALNOTICE  Salary Notices Report										  |
|  8. STRSAD     Calculate STRS Advance Payments             				  |
|  9. ANNSTRSSND Submit STRS Annual Reporting file to STRS					  |
| 10. USPAUDIT   USPS Submission File for Auditors							  |
| 11. USPEMS     Export and report program for EMIS data					  |
| 12. W2C        Create W2C Forms											  |
| 13. W2MAINT    W2 Related Reporting Options, Employee Verification Service  |
| 14. W2PROC     Process W-2's, Create Print & Tape Files					  |
| 15. W2UPDT     Update / Modify W-2 Information                   	          |
| 16. YTDRPT     YTD Employee Information     								  |
| 17. CALENDARCD Create Calendar Year End Reports For Payrollcd               |
|                                                                   	      |
|                                                                     		  |
|                                                               	          |
|                                                                      		  |
|                                                              		          |
|                                                                     		  |
|     Menu: USPS_RPT Option>                                           		  |
|                                                                      		  |
|   XX  Accept        XX  Help          XX  Exit          XX  Next     		  |
|_____________________________________________________________________________|

CRDC option

 

_______________________________________________________________________________ 
|                 CDRC Civil Rights Data Collection Reporting 	              |
|                                                                             |
|   This program should be run in your districts directory where			  |
|   the data is saved after the fiscal year end.							  |
|																			  |
|   This program produces a report for SCH-0044 for Instructional Services	  |
|   and Support Services including Student, Staff and Administration.		  |
|   SCH-0045 and SCH-0043 reports are for Instructional Staff only.			  |
|  																			  |
|	There are two output files:												  |				
|    1) Data reports for SCH-0044 (Groups 1-4), SCH-0045 (Group 5) and	      |
|    SCH-0043 (Group 6)   													  |
|    2) Error report														  |
|									 										  |
|  Report File Specifications:		    									  |
|  Fiscal Year                                          2012    			  | 
|  Output file                                          CRDC.TXT           	  |
|  Error file                                           CRDCE.TXT          	  |
|  Print options page? (Y,N)                            Y					  |
|  Optional heading line                                                      |
|                                                                             | 
|  Civil Rights Data Collection Report                           			  |
|  KP-  Execute         F10 Reset                                             |
|  F7  Help             F11 Save/Recall                                       |
|  F8  Exit   						                                          |
|  F9  Cancel 																  |
|_____________________________________________________________________________|                                          

  • Fiscal Year- Enter in the fiscal year that you are processing the report for.
  • Output file- CRDC.TXT is the default name of the report that is produced when the program is ran. The report can be renamed in this field.
  • Output Error file-CRDCE.TXT is the default name of the error report that gets produced if any errors are discovered during the run. The report can be renamed in this field.
  • Print options page  (Y, N)-  The options page shows what selections were made to generate this report.
  • Optional report heading- A  descriptive report heading name can be entered.

Sample CRDC.TXT Report

  Date: 11/20/12                 SUNSHINE LOCAL                                                            Page:     1 
  Time:  9:17 am               District IRN: 0222222                                                                  (CRDC) 
                       Civil Rights Data Collection Reporting 
                   Beginning date = 20110701 Ending date = 20120630 
  
   BLDG                                                STATE      POS        CONTRACT 
   IRN     EMPLOYEE NAME                   EMPID    ASSIGNED ID   CODE       AMOUNT
  ------------------------------------------------------------------------------------   
SCH-0044
Group: INSTRUCTIONAL
 004333  COOPER, BRADLEY                   COO000020  OH1111111   230             0.00
 004333  JOLE, ANGELINA                    JOL000020  BG2222222   230        64,450.00
 004333  PITT, BRAD                        PIT000029  TU3333333   230        66,254.00

			            BLDG IRN TOTALS:                                    1,30704.00

 135863  CRUISE, TOM                       CRU000020  TU2222222   230        66,254.00
 135863  HOLMES, KATIE                     HOL000020  BG3333333   230        66,904.00
 135863  SUTHERLAND, KEIFER                SUT000020  MI4444444   230        64,450.00
                                                                       ---------------- 
                        BLDG IRN TOTALS:                                    1,97608.00
           GROUP TOTALS FOR  INSTRUCTIONAL                                  3,28312.00

  BLDG                                                 STATE      POS        CONTRACT 
  IRN      EMPLOYEE NAME                   EMPID    ASSIGNED ID   CODE       AMOUNT
  ------------------------------------------------------------------------------------
SCH-0044
Group: SUPPORT SERVICES-STUDENT 
 004333  HANKS, TOM                        HAN000020  OH3333333   202        59,270.00
                                                                       ---------------- 
                        BLDG IRN TOTALS:                                     59,270.00
 
 003582  BUTLER, GERARD                    BUT011110  OH5555555   204        42,876.00
 003582  ROBERTS, JULIA                    ROB033232  BG9999999   202        62,661.00
 003582  WITHERSPOOON, REESE               WIT765432  OH8886666   204        47,556.00
                                                                       ---------------- 
                        BLDG IRN TOTALS:                                    209,888.00
           GROUP TOTALS FOR  SUPPORT SERVICES-STUDENT                       917,167.88

  BLDG                                                 STATE      POS        CONTRACT                           
  IRN      EMPLOYEE NAME                   EMPID    ASSIGNED ID   CODE       AMOUNT                     
  --------------------------------------------------------------------------------------
SCH-0044
Group: SUPPORT SERVICES-STAFF 
 003582  CHESNEY, KENNY                    CHE434343  OH6161616   414        22,272.81
                                                                       ---------------- 
                        BLDG IRN TOTALS:                                     22,272.81

 094607  LAMBERT,. MIRANDA                 LAM656565  OH8765432   209         2,486.00
 094607  SHELTON, BLAKE                    SHE677767  OH2345678   414        22,174.32
                                                                       ---------------- 
                        BLDG IRN TOTALS:                                     24,660.32
           GROUP TOTALS FOR  SUPPORT SERVICES-STAFF                         211,409.53


 BLDG                                                  STATE      POS        CONTRACT 
 IRN       EMPLOYEE NAME                   EMPID    ASSIGNED ID   CODE       AMOUNT
  -------------------------------------------------------------------------------------
SCH-0044
Group: SUPPORT SERVICES-ADMINISTRATIVE
 003582  BRYAN, LUKE                       BRY100274  MM7676767   113         3,000.00
 003582  HILL, FAITH                       HIL032422  OH1222222   113           624.00
 003582  MCGRAW, TIM                       MCG045143  OH5644444   108        57,675.00
                                                                       ---------------- 
                      BLDG IRN TOTALS:                                       61,299.00

 005397  MCBRIDE, MARTINA                  MCB056789  OH6555555   113           312.00

                        BLDG IRN TOTALS:                                        312.00
           GROUP TOTALS FOR  SUPPORT SERVICES-ADMINISTRATIVE              1,167,648.18


BLDG                                                   STATE      POS        CONTRACT           FTE 
IRN        EMPLOYEE NAME                   EMPID    ASSIGNED ID   CODE       AMOUNT
  ----------------------------------------------------------------------------------------------------- 
SCH-0045
Group: INSTRUCTIONAL
 003582  ALDEAN, JASON                     ALD081001  OH4888888   230        50,677.00           1.000
 003582  BROOKS, GARTH                     BRO455555  BG3444444   230        62,661.00           1.000
 003582  YEARWOOD, TRISHA                  YEA644444  MM2333333   108        89,901.00            .950

                      BLDG IRN TOTALS:                                    1,115,048.20           2.950

 094607  STRAIT, GEORGE                    STR876543  BG5666666   230        59,728.00           1.000
                                                                       ----------------     ----------- 
                      BLDG IRN TOTALS:                                    1,148,104.80           3.950
           GROUP TOTALS FOR  INSTRUCTIONAL                                5,727,366.02         106.450


BLDG                                                   STATE      POS       CONTRACT                          ABSENCES
IRN        EMPLOYEE NAME                   EMPID     ASSIGNED ID  CODE      AMOUNT             FTE            > 10
  ------------------------------------------------------------------------------------------------------------------------- 
SCH-0043
Group: INSTRUCTIONAL
 003582  CORBIN, EASTON                    COR001001  OH5446777   230        50,677.00           1.000           36.0000   
 003582  EVANS, SARAH                      EVA001008  BG6577777   230        62,661.00           1.000           11.5000 
 003582  MOORE, KIP                        MOO544444  BG7566666   230        56,795.00           1.000           24.0000 

                      BLDG IRN TOTALS:                                      725,585.00          12.500          274.0000 

 094607  CHURCH, ERIC                      CHU010577  OH2333333   230        36,073.00           1.000           14.5000 
 094607  DUNN, RONNIE                      DUN062373  OH3999999   230        59,065.40           1.000           11.5000 
                                                                       ----------------     -----------   ----------------- 
                      BLDG IRN TOTALS:                                      664,854.07           2.000          189.4285 
           GROUP TOTALS FOR  INSTRUCTIONAL                                 3,116,720.22         14.500        1,068.2850 


           

     

             Sample CRDCE.TXT Report

 Date: 11/20/12                 SUNSHINE LOCAL                                                            Page:     1
  Time:  9:17 am               District IRN: 022222                                                                  (CRDCE)
                     Civil Rights Data Collection Error Report
  
  BLDG IRN    EMPID    JOB NBR  ERROR MESSAGE 
  --------------------------------------------------------------------------------------------------------------------------
   147587    ABC000020    1     Excluded - All source codes for job must be A, B, G, I, L, N, T, or U.  May want to review. 
   008425    DEF000040    1     Excluded - All source codes for job must be A, B, G, I, L, N, T, or U.  May want to review. 
   047597    GHI000020    1     Excluded - All source codes for job must be A, B, G, I, L, N, T, or U.  May want to review. 
   022319    JKL000020    1     Excluded - All source codes for job must be A, B, G, I, L, N, T, or U.  May want to review. 
[End of file]

 

Error Message definition:


The  Excluded - All source codes for job must be A, B, G, I, L, N, T, or U. May want to review. error  means--The fund source codes for  the employee job(s) do not  = A, B, G, I, L, N, T or U.  If any other source codes are listed this employee is listed on the error report.

 

 

 

 

 

 

        

 

  • No labels