Troubleshooting Missing OECTA File Members

Troubleshooting Missing Members on OECTA File

ISSUE: To troubleshoot missing members on the OECTA Text File. 

PAYROLL > REPORTING MENU > MONTHLY REPORTING > OTF MONTHLY REPORT

**Submitted**

PROCESS > COMPLETED > FILE DIRECTORY > PAYROLL > LOGFILE

**659 Record produced vs 684 Records expected**

PAYROLL > BOARD > DEDUCTION CODES MAINTENANCE > AFFILIATE CODE = 3

**Multiple OECTA Deduction Codes are defined and Current**

MISSING EID RECORDS FROM OTF FILE

**25 Missing EID records provided** 

KEY RELATIONSHIP: OTF Monthly Report is related to Pay Register. 

The Pay Register is where Employees pay into OECTA Fees under the Deductions, and therefore will pull into OTF Monthly Report for the appropriate timeline. 

STEP 1: Verify OECTA Deductions are defined

PAYROLL > EMPLOYEE> NON STATUTORY DEDUCTIONS > EID

**OECTA Records are Current**

STEP 2: Verify Active Position + Employee Group

STAFFING > POSITION & ASSIGNMENT

**Active Position and EMP_GROUP verified**

STEP 3: Verify EID is not on Approved Leave

STAFFING > APPROVED LEAVES > EID

**No current Approved Leave anytime recently**

STEP 4: Verifying Pay Model Details Include OECTA Deductions

PAYROLL > GROUP DATA > PAY PERIOD CALENDAR > EMP_GROUP

**Pay Model Name for this PAYNUM = __MODEL2**

PAYROLL > GROUP DATA > PAY PERIOD DETAILS > EMP_GROUP + PAY MODEL

**OECTA-OF/OP are defined under Pay Model**

STEP 5: Ensure Compensation Record is Authorized and Matches against Position Record

COMPENSATION > SALARY & ALLOWANCE > EID

**Authorization = N for Current Compensation Record**

EMPLOYEE SALARY/ALLOWANCE TAB

**Compensation Record matches Position Record (Group, Job, Location & Establishment)**