Tables

Below are the tables that drive the application. Most of the tables utilized are from the EDW and refreshed weekly. EDW tables are linked to the Decision Support metadata entry.

Finance (EDW)

Joins are made to T_ORG_CD_HIST in order to apply criteria that COLL_LEVEL_3_CD = KN. This will be changing to a finder-file setup to capture misapplied transactions.

Table (links to edw metadata)	edw query to populate
T_OL_DETL	SELECT EDW.T_OL_DETL.* FROM EDW.T_OL_DETL, EDW.T_ORG_CD_HIST WHERE EDW.T_OL_DETL.COA_CD = EDW.T_ORG_CD_HIST.COA_CD AND EDW.T_OL_DETL.ORG_CD = EDW.T_ORG_CD_HIST.ORG_CD AND (EDW.T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND (EDW.T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y')
T_OL_SUM	SELECT EDW.T_OL_SUM.* FROM EDW.T_ORG_CD_HIST, EDW.T_OL_SUM WHERE EDW.T_ORG_CD_HIST.ORG_CD = EDW.T_OL_SUM.ORG_CD AND EDW.T_ORG_CD_HIST.COA_CD = EDW.T_OL_SUM.COA_CD AND (EDW.T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND (EDW.T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y') and EDW.T_ORG_CD_HIST.COA_CD = 1
T_PCARD_VEND	SELECT distinct T_PCARD_VEND.* FROM T_ORG_CD_HIST INNER JOIN T_PCARD_TRAN_DETL ON T_ORG_CD_HIST.COA_CD = T_PCARD_TRAN_DETL.COA_CD AND T_ORG_CD_HIST.ORG_CD = T_PCARD_TRAN_DETL.ORG_CD INNER JOIN T_PCARD_VEND ON T_PCARD_TRAN_DETL.PCARD_VEND_ID = T_PCARD_VEND.PCARD_VEND_ID WHERE (T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND (T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y') AND (T_ORG_CD_HIST.COA_CD = '1')
T_PCARD_TRAN_COMMENT	SELECT distinct T_PCARD_TRAN_COMMENT.* FROM T_ORG_CD_HIST INNER JOIN T_PCARD_TRAN_DETL ON T_ORG_CD_HIST.COA_CD = T_PCARD_TRAN_DETL.COA_CD AND T_ORG_CD_HIST.ORG_CD = T_PCARD_TRAN_DETL.ORG_CD INNER JOIN T_PCARD_TRAN_COMMENT ON T_PCARD_TRAN_DETL.PCARD_TRAN_SEQ_NBR = T_PCARD_TRAN_COMMENT.PCARD_TRAN_SEQ_NBR WHERE (T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND (T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y') AND (T_ORG_CD_HIST.COA_CD = '1')
T_PCARD_TRAN_DETL	SELECT T_PCARD_TRAN_DETL.* FROM T_ORG_CD_HIST INNER JOIN T_PCARD_TRAN_DETL ON T_ORG_CD_HIST.COA_CD = T_PCARD_TRAN_DETL.COA_CD AND T_ORG_CD_HIST.ORG_CD = T_PCARD_TRAN_DETL.ORG_CD WHERE (T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND (T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y') AND (T_ORG_CD_HIST.COA_CD = '1')
T_POST_DOC	SELECT DISTINCT EDW.T_POST_DOC.* FROM EDW.T_POST_DOC, EDW.T_OL_DETL, EDW.T_ORG_CD_HIST WHERE EDW.T_POST_DOC.EDW_FIN_DOC_ID = EDW.T_OL_DETL.EDW_FIN_DOC_ID AND EDW.T_OL_DETL.COA_CD = EDW.T_ORG_CD_HIST.COA_CD AND EDW.T_OL_DETL.ORG_CD = EDW.T_ORG_CD_HIST.ORG_CD AND (EDW.T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND EDW.T_ORG_CD_HIST.COA_CD = 1 AND (EDW.T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y')

Decode (EDW)

Criteria is COA_CD = 1 and cur_info_ind = Y

Table (links to edw metadata)	edw query to populate
T_FIN_ACCT_CD_HIST	SELECT * FROM EDW.T_FIN_ACCT_CD_HIST WHERE (COA_CD = '1') AND (FIN_ACCT_CD_CUR_INFO_IND = 'Y')
T_FIN_ACCT_TYPE_CD_HIST	SELECT * FROM EDW.T_FIN_ACCT_TYPE_CD_HIST WHERE (COA_CD = '1') AND (FIN_ACCT_TYPE_CD_CUR_INFO_IND = 'Y')
T_FIN_FUND_CD_HIST	SELECT * FROM EDW.T_FIN_FUND_CD_HIST WHERE (COA_CD = '1') AND (FIN_FUND_CD_CUR_INFO_IND = 'Y')
T_FIN_FUND_TYPE_CD_HIST	SELECT * FROM EDW.T_FIN_FUND_TYPE_CD_HIST WHERE (COA_CD = '1') AND (FIN_FUND_TYPE_CD_CUR_INFO_IND = 'Y')
T_FIN_PGM_CD_HIST	SELECT * FROM EDW.T_FIN_PGM_CD_HIST WHERE (COA_CD = '1') AND (FIN_PGM_CD_CUR_INFO_IND = 'Y')
T_FISC_PERD_CD	SELECT * FROM EDW.T_FISC_PERD_CD WHERE (COA_CD = '1')
T_ORG_CD_HIST	SELECT * FROM EDW.T_ORG_CD_HIST WHERE (COA_CD = '1') AND (ORG_CD_CUR_INFO_IND = 'Y')

HR (EDW)

A finder file is populated with EDW_PERS_IDs of our students, employees paid from a College account, and employees of the College. See the Refresh page for more information.

Table (links to edw metadata)	edw query to populate
V_EMPEE_CAMPUS_EMAIL_ADDR	SELECT V_EMPEE_CAMPUS_EMAIL_ADDR.EDW_PERS_ID, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_ADDR, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_TYPE_CD, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_TYPE_DESC, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_PREFERRED_IND, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_STATUS_IND, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_STATUS_DESC, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_ADDR_EFF_DT, V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_RPT_IND FROM V_EMPEE_CAMPUS_EMAIL_ADDR, EDU_FINDERFILE WHERE V_EMPEE_CAMPUS_EMAIL_ADDR.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (V_EMPEE_CAMPUS_EMAIL_ADDR.EMAIL_STATUS_IND = 'A')
V_EMPEE_CAMPUS_TELE_HIST	SELECT V_EMPEE_CAMPUS_TELE_HIST.* FROM V_EMPEE_CAMPUS_TELE_HIST, EDU_FINDERFILE WHERE V_EMPEE_CAMPUS_TELE_HIST.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (V_EMPEE_CAMPUS_TELE_HIST.TELE_CUR_INFO_IND = 'Y')
V_EMPEE_PERS_HIST_1	SELECT V_EMPEE_PERS_HIST_1.* FROM V_EMPEE_PERS_HIST_1, EDU_FINDERFILE WHERE V_EMPEE_PERS_HIST_1.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (V_EMPEE_PERS_HIST_1.PERS_CUR_INFO_IND = 'Y')
T_EMPEE_VISA_3	SELECT EDW.T_EMPEE_VISA_3.EDW_PERS_ID, EDW.T_EMPEE_VISA_3.VISA_SEQ_NBR, EDW.T_EMPEE_VISA_3.CUR_VISA_TYPE_CD, EDW.T_EMPEE_VISA_3.VISA_NBR, DECODE(EDW.T_EMPEE_VISA_3.VISA_EFF_DT, GREATEST(EDW.T_EMPEE_VISA_3.VISA_EFF_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_EMPEE_VISA_3.VISA_EFF_DT, NULL) AS VISA_EFF_DT, DECODE(EDW.T_EMPEE_VISA_3.VISA_EDW_EXP_DT, GREATEST(EDW.T_EMPEE_VISA_3.VISA_EDW_EXP_DT, TO_DATE('1/1/1753', 'MM/DD/YYYY')), EDW.T_EMPEE_VISA_3.VISA_EDW_EXP_DT, NULL) AS VISA_EDW_EXP_DT, EDW.T_EMPEE_VISA_3.VISA_CUR_INFO_IND, EDW.T_EMPEE_VISA_3.CUR_VISA_TYPE_DESC, DECODE(EDW.T_EMPEE_VISA_3.VISA_START_DT, GREATEST(EDW.T_EMPEE_VISA_3.VISA_START_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_EMPEE_VISA_3.VISA_START_DT, NULL) AS VISA_START_DT, DECODE(EDW.T_EMPEE_VISA_3.VISA_END_DT, GREATEST(EDW.T_EMPEE_VISA_3.VISA_END_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_EMPEE_VISA_3.VISA_END_DT, NULL) AS VISA_END_DT, EDW.T_EMPEE_VISA_3.ENTRY_VISA_TYPE_CD, EDW.T_EMPEE_VISA_3.ENTRY_VISA_TYPE_DESC, DECODE(EDW.T_EMPEE_VISA_3.ENTRY_VISA_ENTRY_DT, GREATEST(EDW.T_EMPEE_VISA_3.ENTRY_VISA_ENTRY_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_EMPEE_VISA_3.ENTRY_VISA_ENTRY_DT, NULL) AS ENTRY_VISA_ENTRY_DT, EDW.T_EMPEE_VISA_3.ENTRY_VISA_EXP_DT, EDW.T_EMPEE_VISA_3.COA_CD, EDW.T_EMPEE_VISA_3.CAMPUS_LEVEL_1_CD, EDW.T_EMPEE_VISA_3.ADMIN_LEVEL_2_CD, EDW.T_EMPEE_VISA_3.COLL_LEVEL_3_CD, EDW.T_EMPEE_VISA_3.SCHOOL_SUB_COLL_LEVEL_4_CD, EDW.T_EMPEE_VISA_3.DEPT_LEVEL_5_CD, EDW.T_EMPEE_VISA_3.DEPT_SUB_ORG_LEVEL_6_CD, EDW.T_EMPEE_VISA_3.DEPT_SUB_ORG_LEVEL_7_CD, EDW.T_EMPEE_VISA_3.DEPT_SUB_ORG_LEVEL_8_CD, EDW.T_EMPEE_VISA_3.EMPEE_VISA_3_POST_DT, EDW.T_EMPEE_VISA_3.VISA_DSD, EDW.T_EMPEE_VISA_3.ROWID FROM EDW.T_EMPEE_VISA_3, EDU_FINDERFILE WHERE EDW.T_EMPEE_VISA_3.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (EDW.T_EMPEE_VISA_3.COLL_LEVEL_3_CD = 'KN') AND (EDW.T_EMPEE_VISA_3.VISA_CUR_INFO_IND = 'Y')
V_EMPEE_HIST_1	SELECT V_EMPEE_HIST_1.EDW_PERS_ID, V_EMPEE_HIST_1.EMPEE_EFF_DT, V_EMPEE_HIST_1.EMPEE_EXP_DT, V_EMPEE_HIST_1.EMPEE_CUR_INFO_IND, V_EMPEE_HIST_1.ACTIVE_EMPEE_IND, DECODE(V_EMPEE_HIST_1.FIRST_HIRE_DT, GREATEST(V_EMPEE_HIST_1.FIRST_HIRE_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.FIRST_HIRE_DT, NULL) AS FIRST_HIRE_DT, DECODE(V_EMPEE_HIST_1.CUR_HIRE_DT, GREATEST(V_EMPEE_HIST_1.CUR_HIRE_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.CUR_HIRE_DT, NULL) AS CUR_HIRE_DT, DECODE(V_EMPEE_HIST_1.ADJ_SVC_DT, GREATEST(V_EMPEE_HIST_1.ADJ_SVC_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.ADJ_SVC_DT, NULL) AS ADJ_SVC_DT, DECODE(V_EMPEE_HIST_1.FIRST_WORK_DT, GREATEST(V_EMPEE_HIST_1.FIRST_WORK_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.FIRST_WORK_DT, NULL) AS FIRST_WORK_DT, DECODE(V_EMPEE_HIST_1.LAST_WORK_DT, GREATEST(V_EMPEE_HIST_1.LAST_WORK_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.LAST_WORK_DT, NULL) AS LAST_WORK_DT, DECODE(V_EMPEE_HIST_1.ORIG_STATUS_HIRE_DT, GREATEST(V_EMPEE_HIST_1.ORIG_STATUS_HIRE_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.ORIG_STATUS_HIRE_DT, NULL) AS ORIG_STATUS_HIRE_DT, V_EMPEE_HIST_1.EMPEE_STATUS_CD, V_EMPEE_HIST_1.EMPEE_STATUS_DESC, V_EMPEE_HIST_1.EMPEE_CLS_CD, V_EMPEE_HIST_1.EMPEE_CLS_LONG_DESC, V_EMPEE_HIST_1.EMPEE_GROUP_CD, V_EMPEE_HIST_1.EMPEE_GROUP_DESC, V_EMPEE_HIST_1.EMPEE_LEAVE_CATGRY_CD, V_EMPEE_HIST_1.EMPEE_LEAVE_CATGRY_DESC, V_EMPEE_HIST_1.BNFT_CATGRY_CD, V_EMPEE_HIST_1.BNFT_CATGRY_DESC, V_EMPEE_HIST_1.BNFT_ELIG_IND, V_EMPEE_HIST_1.HR_CAMPUS_CD, V_EMPEE_HIST_1.HR_CAMPUS_NAME, V_EMPEE_HIST_1.FLSA_IND, V_EMPEE_HIST_1.COA_CD, V_EMPEE_HIST_1.ORG_CD, V_EMPEE_HIST_1.EMPEE_CAMPUS_CD, V_EMPEE_HIST_1.EMPEE_CAMPUS_NAME, V_EMPEE_HIST_1.EMPEE_COLL_CD, V_EMPEE_HIST_1.EMPEE_COLL_NAME, V_EMPEE_HIST_1.EMPEE_DEPT_CD, V_EMPEE_HIST_1.EMPEE_DEPT_NAME, V_EMPEE_HIST_1.WORK_PERD_CD, V_EMPEE_HIST_1.WORK_PERD_DESC, V_EMPEE_HIST_1.EMPEE_DATA_STATUS_DESC, DECODE(V_EMPEE_HIST_1.EMPEE_DATA_EXP_DT, GREATEST(V_EMPEE_HIST_1.EMPEE_DATA_EXP_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.EMPEE_DATA_EXP_DT, NULL) AS EMPEE_DATA_EXP_DT, V_EMPEE_HIST_1.EMPEE_RET_IND, DECODE(V_EMPEE_HIST_1.EMPEE_TERMN_DT, GREATEST(V_EMPEE_HIST_1.EMPEE_TERMN_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.EMPEE_TERMN_DT, NULL) AS EMPEE_TERMN_DT, V_EMPEE_HIST_1.EMPEE_ORG_TITLE, DECODE(V_EMPEE_HIST_1.UNIV_SNRTY_DT, GREATEST(V_EMPEE_HIST_1.UNIV_SNRTY_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), V_EMPEE_HIST_1.UNIV_SNRTY_DT, NULL) AS UNIV_SNRTY_DT, V_EMPEE_HIST_1.EMPEE_SUB_DEPT_LEVEL_6_CD, V_EMPEE_HIST_1.EMPEE_SUB_DEPT_LEVEL_6_NAME, V_EMPEE_HIST_1.EMPEE_SUB_DEPT_LEVEL_7_CD, V_EMPEE_HIST_1.EMPEE_SUB_DEPT_LEVEL_7_NAME, V_EMPEE_HIST_1.FT_PT_STATUS_CD, V_EMPEE_HIST_1.FT_PT_STATUS_DESC, V_EMPEE_HIST_1.ROWID FROM V_EMPEE_HIST_1, EDU_FINDERFILE WHERE V_EMPEE_HIST_1.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (V_EMPEE_HIST_1.EMPEE_CUR_INFO_IND = 'Y')
T_JOB_HIST	SELECT T_JOB_HIST.* FROM T_JOB_HIST, EDU_FINDERFILE WHERE T_JOB_HIST.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (T_JOB_HIST.JOB_CUR_INFO_IND = 'Y')
T_JOB_LBR_DISTR	SELECT T_JOB_LBR_DISTR.* FROM T_JOB_LBR_DISTR, EDU_FINDERFILE WHERE T_JOB_LBR_DISTR.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND T_JOB_LBR_DISTR.COA_CD = '1' and T_JOB_LBR_DISTR.JOB_LBR_DISTR_DATA_STATUS_DESC = 'Current'
V_JOB_DETL_HIST_1	SELECT V_JOB_DETL_HIST_1.* FROM V_JOB_DETL_HIST_1, EDU_FINDERFILE WHERE V_JOB_DETL_HIST_1.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND V_JOB_DETL_HIST_1.JOB_DETL_CUR_INFO_IND = 'Y' AND V_JOB_DETL_HIST_1.JOB_DETL_DATA_STATUS_DESC = 'Current'
T_LOA_HIST	SELECT EDW.T_LOA_HIST.* FROM EDW.T_LOA_HIST, EDU_FINDERFILE WHERE EDW.T_LOA_HIST.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (EDW.T_LOA_HIST.LOA_CUR_INFO_IND = 'Y')
V_PAYR_EVENT_1	SELECT DISTINCT EDW.V_PAYR_EVENT_1.* FROM EDW.V_PAYR_EVENT_1, EDU_FINDERFILE WHERE EDW.V_PAYR_EVENT_1.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND (EDW.V_PAYR_EVENT_1.PAYR_YR > '2004')
V_PAYR_ACCTG_DETL	SELECT EDW.V_PAYR_ACCTG_DETL.* FROM EDW.V_PAYR_ACCTG_DETL, EDW.T_ORG_CD_HIST WHERE EDW.V_PAYR_ACCTG_DETL.ORG_CD = EDW.T_ORG_CD_HIST.ORG_CD AND (EDW.V_PAYR_ACCTG_DETL.PAYR_YR >= '2004') AND (EDW.T_ORG_CD_HIST.COLL_LEVEL_3_CD = 'KN') AND (EDW.T_ORG_CD_HIST.ORG_CD_CUR_INFO_IND = 'Y')
T_POSN_HIST	SELECT DISTINCT EDW.T_POSN_HIST.POSN_NBR, DECODE(EDW.T_POSN_HIST.POSN_HIST_EFF_DT, GREATEST(EDW.T_POSN_HIST.POSN_HIST_EFF_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_POSN_HIST.POSN_HIST_EFF_DT, NULL) AS POSN_HIST_EFF_DT, DECODE(EDW.T_POSN_HIST.POSN_HIST_EXP_DT, GREATEST(EDW.T_POSN_HIST.POSN_HIST_EXP_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_POSN_HIST.POSN_HIST_EXP_DT, NULL) AS POSN_HIST_EXP_DT, EDW.T_POSN_HIST.POSN_HIST_CUR_INFO_IND, EDW.T_POSN_HIST.POSN_CLS_CD, EDW.T_POSN_HIST.POSN_STATUS_DESC, EDW.T_POSN_HIST.POSN_TITLE, DECODE(EDW.T_POSN_HIST.POSN_BGN_DT, GREATEST(EDW.T_POSN_HIST.POSN_BGN_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_POSN_HIST.POSN_BGN_DT, NULL) AS POSN_BGN_DT, DECODE(EDW.T_POSN_HIST.POSN_END_DT, GREATEST(EDW.T_POSN_HIST.POSN_END_DT, TO_DATE('01/01/1753', 'MM-DD-YYYY')), EDW.T_POSN_HIST.POSN_END_DT, NULL) AS POSN_END_DT, EDW.T_POSN_HIST.POSN_TYPE_DESC, EDW.T_POSN_HIST.POSN_EMPEE_CLS_CD, EDW.T_POSN_HIST.POSN_EMPEE_CLS_LONG_DESC, EDW.T_POSN_HIST.POSN_SAL_TBL_CD, EDW.T_POSN_HIST.POSN_SAL_GRADE_CD, EDW.T_POSN_HIST.POSN_SAL_STEP_NBR, EDW.T_POSN_HIST.CIPC_CD, EDW.T_POSN_HIST.CIPC_DESC, EDW.T_POSN_HIST.COA_CD, EDW.T_POSN_HIST.POSN_SAL_GROUP_CD, EDW.T_POSN_HIST.POSN_SAL_GROUP_DESC, EDW.T_POSN_HIST.POSN_GROUP_CD, EDW.T_POSN_HIST.POSN_GROUP_DESC, EDW.T_POSN_HIST.WORK_SCHED_CD, EDW.T_POSN_HIST.WORK_SCHED_DESC, EDW.T_POSN_HIST.FED_OCCUP_CD, EDW.T_POSN_HIST.FED_OCCUP_DESC, EDW.T_POSN_HIST.PAPE_CIV_SVC_ID, EDW.T_POSN_HIST.PAPE_CIV_SVC_ID_DESC, EDW.T_POSN_HIST.OCCUP_TITLE_CD, EDW.T_POSN_HIST.OCCUP_TITLE_DESC, EDW.T_POSN_HIST.POSN_EXEMPT_IND, EDW.T_POSN_HIST.POSN_BRGN_UNIT_CD, EDW.T_POSN_HIST.POSN_BRGN_UNIT_DESC, EDW.T_POSN_HIST.POSN_ACCRUE_SNRTY_IND, EDW.T_POSN_HIST.POSN_JOB_PRGS_CD, EDW.T_POSN_HIST.POSN_JOB_PRGS_DESC, EDW.T_POSN_HIST.OPEN_POSN_IND, EDW.T_POSN_HIST.POSN_ONE_TIME_PMT_IND, EDW.T_POSN_HIST.POSN_HIST_POST_DT, EDW.T_POSN_HIST.POSN_MIN_SAL, EDW.T_POSN_HIST.POSN_MIDPT_SAL, EDW.T_POSN_HIST.POSN_MAX_SAL, EDW.T_POSN_HIST.POSN_SAL_RANGE_TYPE_DESC, EDW.T_POSN_HIST.POSN_DATA_STATUS_DESC, EDW.T_POSN_HIST.POSN_DATA_EXP_DT, EDW.T_POSN_HIST.POSN_SAL_RT_TYPE_DESC, EDW.T_POSN_HIST.POSN_BUDG_PRFL_CD, EDW.T_POSN_HIST.POSN_BUDG_PRFL_DESC, EDW.T_POSN_HIST.POSN_ROLL_CD, EDW.T_POSN_HIST.POSN_ROLL_DESC, EDW.T_POSN_HIST.POSN_STATUS_CD, EDW.T_POSN_HIST.ROWID FROM EDW.T_JOB_HIST, EDU_FINDERFILE, EDW.T_POSN_HIST WHERE EDW.T_JOB_HIST.EDW_PERS_ID = EDU_FINDERFILE.EDW_PERS_ID AND EDW.T_JOB_HIST.POSN_NBR = EDW.T_POSN_HIST.POSN_NBR AND (EDW.T_POSN_HIST.POSN_HIST_CUR_INFO_IND = 'Y') AND (EDW.T_JOB_HIST.JOB_CUR_INFO_IND = 'Y')

HR Transactions (local)

Entity Diagram

HR_Group_x_Org
HR_Transaction_Types
HR_Transaction_x_Approver
HR_Transaction_x_FOAPAL
HR_Transactions
ED_People

Phone/Communications Billing (CITES Pinnacle)