These PeopleSoft Enterprise Financial Management source system tables are used by ERP Integrator. All tables require read privileges, unless noted otherwise.
| Table / View Name | Table / View Name | Table / View Name | Table / View Name |
|---|---|---|---|
| PS_AFFILIATE_LANG | PS_CAL_SUMP_TBL | PS_LED_DEFN_LANG | PS_RT_DFLT_VW |
| PS_AFFILIATE_VW | PS_CF1_LANG | PS_LED_DEFN_TBL | PS_RT_TYPE_TBL |
| PS_AFFINTRA1_LANG | PS_CF2_LANG | PS_LED_GRP_LANG | PS_SET_CNTRL_REC |
| PS_AFFINTRA1_VW | PS_CF3_LANG | PS_LED_GRP_LED_TBL | PS_SET_CNTRL_TBL |
| PS_AFFINTRA2_LANG | PS_CHARTFIELD1_TBL | PS_LED_GRP_TBL | PS_SET_CNTRL_TREE |
| PS_AFFINTRA2_VW | PS_CHARTFIELD2_TBL | PS_LED_TMPLT_TBL | PS_SETID_TBL |
| PS_ALTACCT_LANG | PS_CHARTFIELD3_TBL | PS_LEDGER | PSDBFLDLABL |
| PS_ALTACCT_TBL | PS_CLASS_CF_LANG | PS_LEDGER_BUDG | PSDBFLDLABLLANG |
| PS_BD_SCENARIO_TBL | PS_CLASS_CF_TBL | PS_LOCATION_TBL | PSKEYDEFN |
| PS_BOOK_CODE_TBL | PS_DEPT_TBL | PS_NAMES | PSOPTIONS |
| PS_BU_BOOK_TBL | PS_DEPT_TBL_LANG | PS_OPER_UNIT_LANG | PSRECDEFN |
| PS_BU_LED_GRP_TBL | PS_EARNINGS_TBL | PS_OPER_UNIT_TBL | PSRECFIELD |
| PS_BUD_REF_LANG | PS_FS_CF_TEMPLATE | PS_PAYGROUP_TBL | PSTREEDEFN |
| PS_BUD_REF_TBL | PS_FS_FLD_PROMPT | PS_POSITION_DATA | PSTREEDEFNLANG |
| PS_BUS_UNIT_LANG | PS_FUND_LANG | PS_PROD_TBL_LANG | PSTREELEAF |
| PS_BUS_UNIT_TBL_FS | PS_FUND_TBL | PS_PRODUCT_TBL | PSTREENODE |
| PS_BUS_UNIT_TBL_GL | PS_GL_ACCOUNT_LANG | PS_PROGRAM_LANG | PSTREESTRCT |
| PS_BUS_UNIT_TBL_HR | PS_GL_ACCOUNT_TBL | PS_PROGRAM_TBL | PSXLATITEM |
| PS_CAL_ADJP_TBL | PS_HPYPB_ACCT_LN (Read and write privileges are required.) | PS_PROJECT_TBL | PSXLATITEMLANG |
| PS_CAL_DEFN_TBL | PS_JOB | PS_REC_GROUP_REC | |
| PS_CAL_DETP_TBL | PS_JOBCODE_TBL | PS_REC_GROUP_TBL |