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
| 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