PeopleSoft Enterprise Financial Management Source System Tables

These PeopleSoft Enterprise Financial Management source system tables are used by Oracle Hyperion Financial Data Quality Management, Enterprise Edition. All tables require read privileges, unless noted otherwise.

Table B-2 PeopleSoft Enterprise Financial Management Source System Tables

Table/View Name	Table/View Name	Table/View Name	Table/View Name
PS_AFFILIATE_LANG	PS_CHARTFIELD1_TBL	PS_LEDGER	PSDBFLDLABL
PS_AFFILIATE_VW	PS_CHARTFIELD2_TBL	PS_LEDGER_BUDG	PSDBFLDLABLLANG
PS_AFFINTRA1_LANG	PS_CHARTFIELD3_TBL	PS_LOCATION_TBL	PSKEYDEFN
PS_AFFINTRA1_VW	PS_CLASS_CF_LANG	PS_NAMES	PSOPTIONS
PS_AFFINTRA2_LANG	PS_CLASS_CF_TBL	PS_OPER_UNIT_LANG	PSRECDEFN
PS_AFFINTRA2_VW	PS_DEPT_TBL	PS_OPER_UNIT_TBL	PSRECFIELD
PS_ALTACCT_LANG	PS_DEPT_TBL_LANG	PS_PAYGROUP_TBL	PS_TREE_NODE_TBL
PS_ALTACCT_TBL	PS_EARNINGS_TBL	PS_PC_BU_GL_VW	PS_TREE_NODE_LANG
PS_BD_SCENARIO_TBL	PS_FS_CF_TEMPLATE	PS_PC_INT_TMPL_GL	PSTREEDEFN
PS_BOOK_CODE_TBL	PS_FS_FLD_PROMPT	PS_POSITION_DATA	PSTREEDEFNLANG
PS_BU_BOOK_TBL	PS_FUND_LANG	PS_PROD_TBL_LANG	PSTREELEAF
PS_BU_LED_GRP_TBL	PS_FUND_TBL	PS_PRODUCT_TBL	PSTREENODE
PS_BUD_REF_LANG	PS_GL_ACCOUNT_LANG	PS_PROGRAM_LANG	PSTREESTRCT
PS_BUD_REF_TBL	PS_GL_ACCOUNT_TBL	PS_PROGRAM_TBL	PSXLATITEM
PS_BUL_CNTL_BUD	PS_HPYPB_ACCT_LN (Read and write privileges are required.)	PS_PROJECT	PSXLATITEMLANG
PS_BUS_UNIT_LANG	PS_HYP_KK_BD_HDR (Write privileges are required. Used for PeopleSoft Commitment Control)	PS_PROJECT_TBL
PS_BUS_UNIT_TBL_FS	PS_HYP_KK_BD_LN (Write privileges are required. Used for PeopleSoft Commitment Control)	PS_REC_GROUP_REC
PS_BUS_UNIT_TBL_GL	PS_JOB	PS_REC_GROUP_TBL
	PS_JOBCODE_TBL	PS_RT_DFLT_VW
PS_BUS_UNIT_TBL_HR		PS_RT_INDEX_TBL
PS_CAL_ADJP_TBL	PS_LED_DEFN_LANG	PS_RT_TYPE_TBL
PS_CAL_DEFN_TBL	PS_LED_DEFN_TBL	PS_SET_CNTRL_REC
PS_CAL_DETP_TBL	PS_LED_GRP_LANG	PS_SET_CNTRL_TBL
PS_CAL_SUMP_TBL	PS_LED_GRP_LED_TBL	PS_SET_CNTRL_TREE
PS_CF1_LANG	PS_LED_GRP_TBL	PS_SETID_TBL
PS_CF2_LANG	PS_LED_TMPLT_TBL
PS_CF3_LANG