Data Validation Overview - Data-X reports

Purpose: This document provides a list of Data-X reports created by DG5 colleges and share out with other colleges for use in data validation.  The CTCLINK catalog (accessed by entering “../CTCLINK” when prompted for the catalog directory in DATAX) is a shared DX procedure catalog that can be accessed by all college accounts, Pnnn and Cnnn.

Audience: Staff participating in validation activities

Data-X reports in /CTCLINK
DX Title Purpose Legacy Data Sources Use (Database.Table) Pillar
PS0003R
Pulls Employee Job Account Data from Legacy PPMS screen PS0003. Used to validate additional pay data against HCM.
EMP.EMP-M
EMP.EMP-JOB-D
EMP.JOB-ACCT-D
HCM
PS0006R
Pulls employee general deduction data from Legacy PPMS screen PS0006. Used to validate general deduction data against HCM.
EMP.EMP-M
EMP.EMP-DED-D
TBL5.DED-TBL-M
HCM
PS0008R
Pulls employee deduction and tax balances from Legacy PPMS screen PS0008. Used to validate deduction balances and tax balances against HCM.
EMP.EMP-M
EMP.EMP-DED-D
EMP.DED-BAL-D
TBL5.DED-TBL-M

HCM
PS0009R
Pulls employee hour balances from Legacy PPMS screen PS0009.
EMP.EMP-M
HCM
PS0010R
Pulls employee earnings balances from Legacy PPMS screen PS0010. Used to validate earnings balances against HCM.
EMP.EMP-M
HCM
PS0014R-F
Pulls employee tax data, such as marital status and exemptions with options to select by employee status, type, deduction code, name, SID, and Employee ID. Used to validate employee tax data against HCM.
EMP.EMP-M
EMP.EMP-ADDR-D
EMP.EMP-BENE-D
TBL2.ZIP-TBL-M
HCM
PS0014R-M
Pulls miscellaneous employee tax values such as other income and deductions. Options to select by employee status, type, and misc num and misc values.
EMP.EMP-M
EMP.EMP-MISC-D
HCM
PS0014R-T
Pulls employee tax data from Legacy PPMS screen PS0014. Used to validate employee tax data against HCM.
EMP.EMP-M
EMP.EMP-ADDR-D
EMP.EMP-BENE-D
EMP.EMP-DED-D
TBL2.ZIP-TBL-M
HCM
BO-A-DUETF
Pulls accounting transactions with Trans Code, GL code and Due To/From from the GA1300S summary file.
Flat file GS1300S
TBL1.GL-TBL-M
FIN
RJ-CSCED
Pulls all classes that contain CE in the MISC-2 for continuing education validation.
SM.CLASS-D
CS
BS-CSCAT
Pulls course catalog data from SM database by Course ID, Fund Source, and InsTitutional Intent.
SM.COURSE-D
SM.COURSE-ASSGN-D
CS
BS-CSCATDS
Pulls course descriptions from course catalog data.
SM.COURSE-DESC-D
CS
BS-CSCITZ
Pulls student citizenship. Selects by Last YRQ Attend field.
SM.STU-D
CS
BS-CSDISAC
Pulls students with disability indicators on record (Health-Lim field with a value greater than 0). Selects by Last YRQ Attend field.
SM.STU-D
CS
BS-CSENR
Pulls students with enrolled classes for given quarters. Selects by Last YRQ Attend field.
SM.STU-D
SM.STU-YRQ-XREF-D
SM.STU-CLASS-D
SM.CLASS-D
CS
BS-CSEPCGR
Pulls students with awarded degrees/certs. Selects by Last YRQ Attend field.
SM.STU-D
TRAN.TRAN-DEGREE-D
CS
BS-CSEPCHS
Student with enrolled program (EPC) data for given quarters. Selects by Last YRQ Attend field.
SM.STU-D
SM.STU-YRQ-XREF-D
SM.STU-YRQ-M
CS
BS-CSETH
Student contact info, date of birth, and sex. Selects by Last YRQ Attend field.
SM.STU-D
SM.ALT-ADDR-M
CS
BS-CSFPSUA
Student Fee Pay Status and Veteran Benefit fields. Selects by enrolled YRQ (STU-YRQ-XREF-D table).
SM.STU-YRQ-XREF-D
SM.STU-YRQ-M
CS
BS-CSGRPUA
Student Unusual Action Codes. Selects by Last YRQ Attend field and Unusual Action code.
SM.STU-D
SM.UNUSUAL-ACTN-D
CS
BS-CSPI2
Student full bio/demo data, including race, ethnicity, residency, citizenship and emergency contact data. Selects by Last YRQ Attend field.
SM.STU-D
SM.ALT-ADDR-M
SM.STU-EMERG-D
CS
BS-CSSCHD
Class schedule data selected by class YRQ.
SM.CLASS-D
TBL3.DAY-D
CS
BS-CSTRFR
Student transfer class and credit data. Selects by Last YRQ Attend field.
SM.STU-D
TRNSFR.TRNSFR-COURSE-D
CS
BS-CSTRNCM
Student transcript comments. Selects by Last YRQ Attend field.
SM.STU-D
TRAN.TRAN-COMMENT-D
CS
BS-CSTRNCR
Student transcript data with classes, credits and grades. Selects by Last YRQ Attend field.
SM.STU-D
TRAN.TRAN-CLASS-D
CS
BS-CSUAPUN
Student unusual action codes that only have attached punitive action codes. Selects by Last YRQ Attend field.
SM.STU-D
SM.UNUSUAL-ACTN-D
SM.UNUSUAL-CD-M
CS
BS-CSWLCAP
Class waitlist data, including capacity, cutoff dates, and active status.
MAGWL.CLASSES
CS
BS-HCMBENE
Employee benefits and insurance data.
EMP.EMP-M
EMP.EMP-BENE-D
HCM
BS-HCMBIO
Employee bio/demo data.
EMP.EMP-M
HCM
BS-HCMBIO2
Employee visa and I-9 data with contact info
EMP.EMP-M
EMP.EMP-ADDR-D
HCM
BS-HCMBIOD
Employee disability data
EMP.EMP-M
HCM
BS-HCMEDU2
Employee highest level of education data
EMP.EMP-M
HCM
BS-HCMEDUC

Employee education data
EMP.EMP-M
EMP.EMP-EDUC-D
HCM
BS-HCMJOB
Employee job data, including start and end dates and supervisor flag.
EMP.EMP-M
EMP.EMP-JOB-D
HCM
BS-HCMLTD
Employee long-term disability data
EMP.EMP-M
EMP.EMP-BENE-D
HCM
BS-HCMMISC
Employee miscellaneous data for all active employees
EMP.EMP-M
EMP.EMP-MISC-D
HCM
BS-HCMTNUR
Employee tenure data, selected by employee status and tenure indicator.
EMP.EMP-M
EMP.EMP-BENE-D
HCM
BS-SFCA
Student financials customer activity with lots of selection options.
CA.CUST-ACTV-D
SF
BS-SFFAEXP
Student financials financial aid data from FAEXP database.
FAEXP.FAEXP-DETAIL-D
SF


0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.