Database Schema - Electronic Research Administration

ERA Database Table Index

This is a listing of all the known tables involved in ERA. For more information, click on the table or view of interest, or see the Database Analysis

From the perspective of ERA, the tables in the tablespace FIS_ER are read only tables. They are populated using a script that keeps them up to date periodically throughout the day.

In general, entries ending in "T" are tables while those ending in "V" are views. However, exceptions to this rule are noted with (V) or (T).

ER.CG_PRPSL_ORG_T (V)	ER.ER_CA_ORG_T (V)	ER.ER_RF_CRDT_PCT_T
ER.CG_PRPSL_PRJDR_T (V)	ER.ER_CG_PRPSL_T	ER.ER_RF_DDT_TYP_T
ER.CG_PRPSL_PURPOSE_T (V)	ER.ER_DISCIPLINE_T	ER.ER_RF_DIARY_T
ER.CG_PRPSL_STAT_T (V)	ER.ER_DLGT_AD_HOC_PRMSN_V	ER.ER_RF_DLGT_PRMSN_V
ER.CG_PRPSL_SUBCN_T (V)	ER.ER_DLGT_CNTCT_V	ER.ER_RF_INIT_V
ER.CG_PRPSL_T (V)	ER.ER_DLGT_CO_PRJDR_HIER_V	ER.ER_RF_IU_CST_SHR_HIER_V
ER.CG_PRPSL_V	ER.ER_DLGT_CO_PRJDR_V	ER.ER_RF_KEYWRD_T
ER.ER_ACC_STSTC_T	ER.ER_DLGT_INIT_PRMSN_V	ER.ER_RF_ORG_T
ER.ER_AGNCY_EXTNS_T	ER.ER_DLGT_IU_CST_SHR_HIER_V	ER.ER_RF_OTHR_ORG_HIER_V
ER.ER_AGNCY_T	ER.ER_DLGT_OTHR_ORG_HIER_V	ER.ER_RF_PRJDR_T
ER.ER_AGNCY_TYP_T	ER.ER_DLGT_PRM_PRJDR_HIER_V	ER.ER_RF_PRMSN_1_V
ER.ER_APPL_CNST_T	ER.ER_DLGT_PRM_PRJDR_V	ER.ER_RF_PRMSN_V
ER.ER_APPT_TYP_T	ER.ER_GRAD_ASST_RT_T	ER.ER_RF_PRM_PRJDR_HIER_V
ER.ER_APRVL_DLGT_T	ER.ER_GRAD_ASST_TSK_PRD_T	ER.ER_RF_PRM_PRJDR_V
ER.ER_APRVL_TYP_T	ER.ER_GROUP_T	ER.ER_RF_PRPS_T
ER.ER_APRV_ACTN_CD_T	ER.ER_IDC_LU_T	ER.ER_RF_PRTCL_T
ER.ER_BDGT_3RD_PRTY_CST_SHR_T	ER.ER_IU_CST_SHR_PSNL_T	ER.ER_RF_RL_TYP_T
ER.ER_BDGT_ADHOC_PRMSN_T	ER.ER_IU_CST_SHR_T	ER.ER_RF_STAT_T
ER.ER_BDGT_ADHOC_PRMSN_V	ER.ER_KEYWRD_T	ER.ER_RF_SUBCNR_T
ER.ER_BDGT_ALL_PRMSN_V	ER.ER_MAIL_T	ER.ER_RF_T
ER.ER_BDGT_BASE_CD_T	ER.ER_MSTR_T	ER.ER_RF_UPDT_TYP_CD_T
ER.ER_BDGT_CNST_T	ER.ER_NPRS_CTGRY_CD_T	ER.ER_RF_USR_PRMSN_T
ER.ER_BDGT_CSTSHR_PRMSN_V	ER.ER_NPRS_OBJ_CD_T	ER.ER_ST_CD_T
ER.ER_BDGT_DLGT_PRMSN_V	ER.ER_NPRS_SUB_CTGRY_CD_T	ER.ER_SUBCNR_CD_T
ER.ER_BDGT_FRNG_RT_T	ER.ER_ORG_APRVL_PRSN_T	ER.ER_SUBCNR_T
ER.ER_BDGT_GRAD_ASST_RT_T	ER.ER_OTHR_CST_SHR_T	ER.ER_UNIV_CST_SHR_TYP_T
ER.ER_BDGT_IDC_T	ER.ER_OUT_URL_T	ER.ER_UNVL_USR_T
ER.ER_BDGT_INITR_PRMSN_V	ER.ER_PRJDR_T	ER.ER_URL_T
ER.ER_BDGT_IU_CST_SHR_T	ER.ER_PRM_PRJDR_T	ER.ER_USER_V
ER.ER_BDGT_MOD_DESC_T	ER.ER_PRPSL_CMP_TYP_T	ER.ER_USR_APPT_T
ER.ER_BDGT_MOD_PRD_T	ER.ER_PRPSL_DIS_T	ER.ER_USR_APPT_TSK_PRD_T
ER.ER_BDGT_MOD_T	ER.ER_PRPSL_INC_T	ER.ER_USR_APPT_TSK_T
ER.ER_BDGT_NPRS_T	ER.ER_PRPSL_RQ_APRV_T	ER.ER_USR_CHRT_ORG_MT
ER.ER_BDGT_ORG_HIER_PRMSN_V	ER.ER_PRPSL_RVSNTYP_T	ER.ER_USR_GROUP_T
ER.ER_BDGT_ORG_V	ER.ER_PRPSL_TYP_T	FIS_ER.CA_ACCOUNT_T
ER.ER_BDGT_PRD_3RD_CST_SHR_T	ER.ER_PRTCL_TYP_T	FIS_ER.CA_CHART_T
ER.ER_BDGT_PRD_IU_CST_SHR_T	ER.ER_RF1_V	FIS_ER.CA_ORG_T
ER.ER_BDGT_PRD_T	ER.ER_RF2_V	FIS_ER.CG_AGENCY_T
ER.ER_BDGT_PRJDR_PRMSN_V	ER.ER_RF3_V	FIS_ER.CG_AGENCY_TYP_T
ER.ER_BDGT_PRMSN_V	ER.ER_RF4_V	FIS_ER.CG_PRJDR_T
ER.ER_BDGT_PRPS_CD_T	ER.ER_RF_AD_HOC_PRMSN_V	FIS_ER.CG_PRPSL_ORG_T
ER.ER_BDGT_STAT_T	ER.ER_RF_AGNCY_T	FIS_ER.CG_PRPSL_PRJDR_T
ER.ER_BDGT_SUBCNR_T	ER.ER_RF_AGNCY_V	FIS_ER.CG_PRPSL_PURPOSE_T
ER.ER_BDGT_T	ER.ER_RF_ALL_PRMSN_V	FIS_ER.CG_PRPSL_STAT_T
ER.ER_BDGT_TSK_PRD_IDC_T	ER.ER_RF_APRVL_T	FIS_ER.CG_PRPSL_SUBCN_T
ER.ER_BDGT_TSK_T	ER.ER_RF_APR_LVL_T	FIS_ER.CG_PRPSL_T
ER.ER_BDGT_USR_T	ER.ER_RF_ATT_T	FIS_ER.CG_SUBCNR_T
ER.ER_BDGT_V	ER.ER_RF_BDGT_T	FIS_ER.FIS_ER_REPLICATE
ER.ER_CA_ACCOUNT_T (V)	ER.ER_RF_CI_T	FIS_ER.SH_STATE_T
ER.ER_CA_CHART_T (V)	ER.ER_RF_CO_PRJDR_HIER_V
ER.ER_CA_OBJECT_CODE_T	ER.ER_RF_CO_PRJDR_V

[testTable]