DARTS : Jobsets (CSPRD) : Type and Sources

These jobs are maintained by DARTS for CSPRD daily extract (Monday- Saturday).

PRCSJOBNAME	PRCSNAME	PRCSTYPE	Source Tables	Tables to be updated	Note
UM_CS4	UM_CS4	PSJob
UM_CS4	UMAPPEXT	SQR Process	Click here to expand... PS_ACAD_GROUP_TBL PS_ACAD_PLAN PS_ACAD_PLAN_TBL PS_ACAD_PROG PS_ACAD_PROG_TBL PS_ACAD_SUBPLAN PS_ACAD_SUBPLN_TBL PS_ADM_APPL_CMP PS_ADM_APPL_DATA PS_ADM_APPL_PLAN PS_ADM_APPL_PROG PS_ADM_APPL_SBPLAN PS_CITIZENSHIP PS_DIVERS_ETHNIC PS_EMAIL_ADDRESSES PS_ETHNIC_GRP_TBL PS_EXT_ACAD_DATA PS_EXT_ACAD_SUM PS_EXT_ORG_PRI_VW PS_EXT_ORG_TBL PS_EXT_ORG_TBL_ADM PS_NAMES PS_PERS_NID PS_PERSONAL_DATA PS_PERSONAL_PHONE PS_PROG_RSN_TBL PS_RESIDENCY_OFF PS_RESP_RSN_TBL PS_STDNT_CAR_TERM PS_STDNT_RESPONSE PS_STDNT_TEST_COMP PS_TERM_TBL PS_TERM_VAL_TBL PS_UM_APPL_EXT_BLD PS_UM_APPL_EXTRACT PS_UM_RUN_UMAPPEXT PSXLATITEM	PS_UM_APPL_EXTRACT
UM_CS4	UMPROEXT	SQR Process	Click here to expand... PS_ADM_PRSPCT_CAR PS_ADM_PRSPCT_PLAN PS_ADM_PRSPCT_PROG PS_ADM_PRSPCT_SBPL PS_CITIZENSHIP PS_DIVERS_ETHNIC PS_EMAIL_ADDRESSES PS_ETHNIC_GRP_TBL PS_EXT_ACAD_DATA PS_EXT_ACAD_SUM PS_EXT_ORG_TBL PS_EXT_ORGSCHL_VW PS_NAMES PS_PERS_NID PS_PERSONAL_DATA PS_PERSONAL_PHONE PS_STDNT_TEST_COMP PS_TERM_VAL_TBL PS_UM_PROS_EXTRACT PS_UM_RUN_UMPROEXT PSXLATITEM	PS_UM_PROS_EXTRACT
UM_CS4	UMSTUEXT	SQR Process	Click here to expand... PS_ACAD_GROUP_TBL PS_ACAD_PLAN PS_ACAD_PLAN_TBL PS_ACAD_PROG PS_ACAD_PROG_TBL PS_ACAD_SUBPLAN PS_ACAD_SUBPLN_TBL PS_ADDRESSES PS_ADM_APPL_DATA PS_CITIZENSHIP PS_CLASS_ATTRIBUTE PS_CLASS_TBL PS_COUNTRY_TBL PS_DEGREE_TBL PS_DIVERS_ETHNIC PS_EMAIL_ADDRESSES PS_ETHNIC_GRP_TBL PS_EXT_ORG_PRI_VW PS_EXT_ORG_TBL_ADM PS_INSTITUTION_TBL PS_ITEM_SF PS_NAMES PS_PERS_NID PS_PERSONAL_DATA PS_PROG_RSN_TBL PS_RESIDENCY_OFF PS_RESP_RSN_TBL PS_STATE_TBL PS_STDNT_ADVR_HIST PS_STDNT_CAR_TERM PS_STDNT_ENRL PS_STDNT_RESPONSE PS_STDNT_TEST_COMP PS_TERM_TBL PS_TERM_VAL_TBL PS_UM_ENRL_PIN PS_UM_RUN_UMSTUEXT PS_UM_STUD_EXT_BLD PS_UM_STUD_EXTRACT PSTREELEAF PSTREENODE PSXLATITEM	PS_UM_STUD_EXTRACT
UM_CS4	UM_STUCRSTAB	Application Engine	Click here to expand... PS_ACAD_ORG_TBL PS_CLASS_ATTRIBUTE PS_CLASS_INSTR PS_CLASS_TBL PS_CRSE_CATALOG PS_LOCATION_TBL PS_PERSONAL_DATA PS_SCTN_CMBND PS_STDNT_ENRL PS_UM_CENTER_TBL PS_UM_LOCATION_DTL PS_UM_RUN PSPRCSRQST PS_UM_D_STD_ENRL PS_UM_D_STD_ENRL_B	PS_UM_D_STD_ENRL
UM_CS4	UMCLSSCH	SQR Process	Click here to expand... PS_ACAD_GROUP_TBL PS_ACAD_ORG_TBL PS_BLDG_TBL PS_CIP_CODE_TBL PS_CLASS_INSTR PS_CLASS_MTG_PAT PS_CLASS_TBL PS_CRSE_CATALOG PS_CRSE_OFFER PS_CRSE_TOPICS PS_FACILITY_TBL PS_LOCATION_TBL PS_NAMES PS_SCTN_CMBND PS_SCTN_CMBND_TBL PS_TERM_VAL_TBL PS_UM_CLSS_SCH_FCL PS_UM_D_CLSS_ATT_V PS_UM_LOCATION_DTL PS_UM_RUN_UMCLSSCH	PS_UM_CLSS_SCH_FCL
UM_CS9	UM_CS9	PSJob
UM_CS9	UM_TABLE_CHK	Application Engine	PS_UM_RUN_TCHK PSPRCSRQST	(sends email)
UM_CS9	UM_APPACAD_P	Application Engine	PS_ACAD_PROG PS_ADM_APPL_PROG	PS_UM_APPACAD_PROG
UM_CS9	UM_BLDITYPND	Application Engine	PS_UM_ITYP_TREENDS	PS_UM_ITYP_TREENDS	Need to ask John if tree can be copied or not

Tables copied nightly from CSPRD to CSRPT

Run this SQL in CSPRD.

SELECT * FROM sysadm.ps_um_datapump
order by tablename;