Is there a full list of tables accessed by the Autosys Peoplesoft adapter release 2.10?

Document ID : KB000022351
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

Is there a full list of tables accessed by the Autosys Peoplesoft adapter release 2.10?

Answer: 

Complete List of all tables accessed

PS_AE_APPL_TBL  

PS_CDM_AUTH  

PS_CDM_DIST_NODE  

PS_CDM_LIST  

PS_PRCSDEFN  

PS_PRCSDEFNCNTDIST  

PS_PRCSJOBCNTDIST  

PS_PRCSJOBDEFN  

PS_PRCSJOBITEM  

PS_PRCSOUTPUTLIST  

PS_PRCSRQSTDIST  

PS_PRCSSEQUENCE   

PS_PRCSSYSTEM  

PS_PRCSTYPEDEFN  

PS_QUERY_RUN_CNTRL  

PS_RUN_CNTL_LTRGEN  

PS_SCC_STN_LTR_TBL  

PS_SCHDLDEFN  

PS_SCHDLITEM  

PS_SERVERDEFN  

PS_SQLSTMT_TBL  

PS_STANDRD_LTR_TBL  

PRCSINSTANCE  

PSLOCK  

PSNVSBOOKREQUST  

PSOPRDEFN  

PSOPTIONS  

PSPRCSLOCK  

PSPRCSPARMS  

PSPRCSQUE  

PSPRCSRQST  

PSPRCSRQSTTEXT  

PSPRCSRUNCNTL  

PSQRYBIND  

PSQRYDEFN  

PSRF_FLIST_TBL  

PSROLEDEFN  

PSROLEUSER  

PSSERVERSTAT  

PSSTATUS

Insert performed on the following tables

PS_CDM_AUTH  

PS_CDM_LIST  

PS_PRCSRQSTDIST  

PS_QUERY_RUN_CNTRL  

PSPRCSLOCK  

PSPRCSPARMS  

PSPRCSQUE  

PSPRCSRQST  

PSPRCSRQSTTEXT 

Select performed on the following tables

PS_AE_APPL_TBL  

PS_CDM_AUTH  

PS_CDM_DIST_NODE  

PS_CDM_LIST  

PS_PRCSDEFN  

PS_PRCSDEFNCNTDIST  

PS_PRCSJOBCNTDIST  

PS_PRCSJOBDEFN  

PS_PRCSJOBITEM  

PS_PRCSOUTPUTLIST  

PS_PRCSRQSTDIST  

PS_PRCSSEQUENCE  

PS_PRCSSYSTEM  

PS_PRCSTYPEDEFN  

PS_QUERY_RUN_CNTRL  

PS_RUN_CNTL_LTRGEN  

PS_SCC_STN_LTR_TBL  

PS_SCHDLDEFN  

PS_SCHDLITEM  

PS_SERVERDEFN  

PS_SQLSTMT_TBL  

PS_STANDRD_LTR_TBL  

PRCSINSTANCE  

PSLOCK  

PSNVSBOOKREQUST  

PSOPRDEFN  

PSOPTIONS  

PSPRCSPARMS  

PSPRCSQUE  

PSPRCSRQST  

PSPRCSRQSTTEXT  

PSPRCSRUNCNTL  

PSQRYBIND  

PSQRYDEFN  

PSRF_FLIST_TBL  

PSROLEDEFN  

PSROLEUSER  

PSSERVERSTAT  

PSSTATUS

Delete performed on the following tables

PS_CDM_AUTH  

PS_CDM_LIST  

PS_PRCSRQSTDIST  

PSPRCSPARMS  

PSPRCSQUE  

PSPRCSRQST  

PSPRCSRQSTTEXT

Update performed on the following tables

PS_CDM_LIST  

PS_PRCSSEQUENCE  

PS_PRCSSYSTEM  

PSPRCSLOCK  

PSPRCSQUE  

PSPRCSRQST