GOBEACC PSRECLS PSREMPR PSRORGN PTRUSER

Model Security


Model Label : Banner Human Resources Security Module

List of Objects

Object Name Object Type Layer Name
GOBEACC SQL Table Default
PSRECLS SQL Table Default
PSREMPR SQL Table Default
PSRORGN SQL Table Default
PTRUSER SQL Table Main Objects

Model View

Table GOBEACC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBEACC_PIDM   NUMBER(8,0) No *  
GOBEACC_USERNAME   VARCHAR2(30) No   *
GOBEACC_USER_ID   VARCHAR2(30) No    
GOBEACC_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
GOBEACC_USERNAME NTRPROX_PROXY_USER_ID NTRPROX
GOBEACC_USERNAME NTRPROX_USER_ID NTRPROX

Index

Index Name Index Type Column Name
GOBEACC_KEY_INDEX Unique GOBEACC_USERNAME
PK_GOBEACC Unique GOBEACC_PIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBUMAP SQL Table S10B80.GENERAL Join
GURIDEN SQL Table S10B80.GENERAL Join
NTRLVID SQL Table S10B80.POSNCTL Join
NTRTPRX SQL Table S10B80.POSNCTL Join
PTRUSER SQL Table S10B80.PAYROLL Join
SPRIDEN SQL Table S10B80.SATURN Join
PHVTIME SQL View S10B80.BANINST1 Use (select)
F_FINANCE_USER_IC SQL Function S10B80.BANINST1 Use (select)
F_FINANCE_USER_IND SQL Function S10B80.BANINST1 Use (select)
GOBAPID_REC Oracle Package Type S10B80.BANINST1.GB_GOBAPID Rely On
GOBEACC_TYPE Oracle Package Type S10B80.BANINST1.BWAKLIBS Rely On
USERRECORD Oracle Package Type S10B80.BANINST1.BWFKRPCU Rely On
FILTERED_JOBS_C Oracle Package Cursor S10B80.BANINST1.BWPKFSEM Rely On
GETAMRPLANBYDATEC Oracle Package Cursor S10B80.BANINST1.BWDKMOVE Use (select)
GETAMRPLANDATEC Oracle Package Cursor S10B80.BANINST1.BWDKMOVE Use (select)
GETAMRPLANGEORC Oracle Package Cursor S10B80.BANINST1.BWDKMOVE Use (select)
GETAMRPLANNAMEC Oracle Package Cursor S10B80.BANINST1.BWDKMOVE Use (select)
GETAMRPLANPROJC Oracle Package Cursor S10B80.BANINST1.BWDKMOVE Use (select)
GETPASSEDAMRPLANC Oracle Package Cursor S10B80.BANINST1.BWDKMOVE Use (select)
GET_GURIDEN_IDEN_CODE_C Oracle Package Cursor S10B80.BANINST1.BWACBREF Rely On
GET_GURIDEN_IDEN_CODE_C Oracle Package Cursor S10B80.BANINST1.BWACBREF Use (select)
GET_PROXY_NAME Oracle Package Cursor S10B80.BANINST1.BWPKTAIS Use (select)
GET_PROXY_NAME Oracle Package Cursor S10B80.BANINST1.BWPKLRED Use (select)
GOBEACCC Oracle Package Cursor S10B80.WTAILOR.TWBKAUSR Use (select)
ORGN_C Oracle Package Cursor S10B80.BANINST1.BWPKFSEM Rely On
PERFASG_C Oracle Package Cursor S10B80.BANINST1.BWPKFSEM Rely On
PERFJOB_NBTJOBF_CUR Oracle Package Cursor S10B80.BANINST1.BWPKFCFT Rely On
PERFNIS_C Oracle Package Cursor S10B80.BANINST1.BWPKFSEM Rely On
RECS_COUNT_C Oracle Package Cursor S10B80.BANINST1.BWPKFSEM Rely On
OVERRIDE_NSF Oracle Package Procedure S10B80.BANINST1.BWFKUADI Rely On
P_APPR_SUMMARY_LIST Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_BUILD_PROXY_LIST Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_BUILD_PROXY_LIST Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Use (select)
P_BUILD_QUEUE_STATUS_LIST Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_BUILD_TRANS_STATUS_LIST Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.BWFKPURR Rely On
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.BWFKTRAN Rely On
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.BWFKREQN Rely On
P_CHK_WAIVED_DEDUCTION Oracle Package Procedure S10B80.BANINST1.BWPKDOEN Rely On
P_COPYJOBTOPOSN Oracle Package Procedure S10B80.BANINST1.BWPKSDST Rely On
P_COPYPOSNTOJOB Oracle Package Procedure S10B80.BANINST1.BWPKSDST Rely On
P_COPYPOSNTOJOBBYJOB Oracle Package Procedure S10B80.BANINST1.BWPKSDST Rely On
P_DISPLAYPROXY Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_DISPLAYPROXY Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_DISPLAYPROXY Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_DISPLAYPROXY Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
P_GET_PREV_NEXT_TRANS_NO Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_INSERTCOMMENT Oracle Package Procedure S10B80.BANINST1.BWFKUADI Rely On
P_INSERT_NBTEMPF Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_NOTIFY_APPROVER Oracle Package Procedure S10B80.BANINST1.PEKTEAP Rely On
P_PERSONALINFO Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_PREVIEW_BUTTONS Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_PRINT_COAS_ORGS Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_PRINT_EMPLOYEES Oracle Package Procedure S10B80.BANINST1.BWPKFSEM Rely On
P_PRINT_ESUM_HEADER Oracle Package Procedure S10B80.BANINST1.BWPKFSEM Rely On
P_PRINT_PERS_IDNAME Oracle Package Procedure S10B80.BANINST1.BWPKEPCR Rely On
P_PRINT_POSN_ITEMS Oracle Package Procedure S10B80.BANINST1.BWPKEPCR Rely On
P_PRINT_PREVIOUS_COMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKFMSC Rely On
P_SELECTAPPROVERACTION Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_SELECTAPPROVERACTION Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_SELECTNJSUPERUSERACTION Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_SELECTNJSUPERUSERACTION Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_SELECTSUPERUSERACTION Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_SELECTSUPERUSERACTION Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_SUMMARY_LINKS Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
CURRUSERID Oracle Package Variable S10B80.BANINST1.BWFKUAPP Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFACT Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKTEST Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFJDT Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFJLD Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFJOB Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFCAL Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFCFT Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFCMT Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFCPT Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFCRN Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFSEM Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFSOR Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFLAC Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.TEST_SSB_BXS Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFLSM Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFLTR Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKEPAF Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKEPCR Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKEPDT Rely On
GLOBAL_PIDM Oracle Package Variable S10B80.BANINST1.BWPKFMSC Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSORG Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFACT Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKTEST Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSALA Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFJDT Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFJOB Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFCAL Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFCFT Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSJOB Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFCMT Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFCRN Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFSEM Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFLAC Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSDST Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.TEST_SSB_BXS Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFLSM Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFLTR Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKEPAF Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKEPCR Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSTOT Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKEPDT Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKEPID Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSMEX Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKEPLK Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKFMSC Rely On
GLOBAL_USER Oracle Package Variable S10B80.BANINST1.BWPKSFDT Rely On
MAPPED_PIDM Oracle Package Variable S10B80.WTAILOR.TWBKAUSR Rely On
PIDM Oracle Package Variable S10B80.BANINST1.BWFKUADI Rely On
PIDM Oracle Package Variable S10B80.BANINST1.BWFKUAPP Rely On
VAR_GOBEACC_USERNAME Oracle Package Variable S10B80.BANINST1.BWPKSPOS Rely On
F_FORMAT_ROUTUSER_NAME Oracle Package Function S10B80.BANINST1.BWPKEPID Rely On
F_FORMAT_ROUTUSER_NAME Oracle Package Function S10B80.BANINST1.BWPKEPID Use (select)
F_GETUSERID Oracle Package Function S10B80.BANINST1.BWFKTDEL Rely On
F_GETUSERID Oracle Package Function S10B80.BANINST1.BWFKTDEL Use (select)
F_GET_GURIDEN_IDEN_CODE Oracle Package Function S10B80.BANINST1.BWACXCHN Use (select)
F_ISBENADMIN Oracle Package Function S10B80.BANINST1.BWPKEBST Use (select)
F_OPEN_ROUTUSER_RC Oracle Package Function S10B80.BANINST1.BWPKEPID Use (select)
F_ROLE_ACCESS_IND Oracle Package Function S10B80.BANINST1.BWPKEPAF Rely On
GETGOBEACCC Oracle Package Cursor S10B80.BANINST1.BWAKLIBS Use (select)
GETPROSPECTSC Oracle Package Cursor S10B80.BANINST1.BWAKLIBS Use (select)
GETUSERID Oracle Package Cursor S10B80.BANINST1.BWFKRPCU Use (select)
GOBEACCVIEWC Oracle Package Cursor S10B80.BANINST1.BWDKLIBS Use (select)
GET_MIF_CODES_BY_PIDM Oracle Package Procedure S10B80.BANSECR.GSPVPDI Use (select)
GET_REQUESTOR Oracle Package Procedure S10B80.BANINST1.FOKWFLW Use (select)
P_ADMIN_LOGIN Oracle Package Procedure S10B80.WTAILOR.TWBKWBIS Use (select)
P_APPROVERSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_APPROVERSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_CHK_SECURITY Oracle Package Procedure S10B80.BANINST1.BWPKEPDT Rely On
P_COMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKTELC Rely On
P_COMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKTALC Rely On
P_COMMENTS_ADMIN_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFMSC Rely On
P_COMMENTS_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFMSC Rely On
P_CREATE_ROUTING_QUEUE Oracle Package Procedure S10B80.BANINST1.PEKTECM Rely On
P_DISPAPPROVERFILTERSBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_DISPAPPROVERSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_DISPAPPROVERSUMMARYBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_DISPCOMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_DISPDATESELECT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Rely On
P_DISPDATESELECT Oracle Package Procedure S10B80.BANINST1.BWPKEBST Use (select)
P_DISPEMPSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKFLSM Rely On
P_DISPEPAFPREVIEW Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_DISPEPAFPREVIEWBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_DISPFILTER Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_DISPLAYPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_DISPLAYPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_DISPLAYPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_DISPLAYPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
P_DISPORIGINATORFILTERS Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_DISPORIGINATORSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_DISPORIGINATORSUMMARYBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_DISPPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_DISP_COMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKEPUT Rely On
P_DISP_EMP_SUMMARY_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFSEM Rely On
P_DISP_JOB_DETL_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFJDT Rely On
P_DISP_JOB_EARNINGS_BODY Oracle Package Procedure S10B80.BANINST1.BWPKFJDT Rely On
P_DISP_ROUTUSER_LOOKUP Oracle Package Procedure S10B80.BANINST1.BWPKEPID Rely On
P_DISP_SELECTED_FILTERS Oracle Package Procedure S10B80.BANINST1.BWPKFSEM Rely On
P_DOWNLOAD Oracle Package Procedure S10B80.BANINST1.BWPKFSEM Rely On
P_GETACCESSIBLECOLLDEPT Oracle Package Procedure S10B80.BANINST1.SOKEPRT Rely On
P_GETGOBEACCINFO Oracle Package Procedure S10B80.BANINST1.GOKEACC Rely On
P_GETGOBEACCINFO Oracle Package Procedure S10B80.BANINST1.GOKEACC Use (select)
P_GETGRADECHANGEEDATA Oracle Package Procedure S10B80.BANINST1.SHKWEVN Rely On
P_GETWFUSERNAME Oracle Package Procedure S10B80.BANINST1.GOKEACC Rely On
P_GET_EPAF Oracle Package Procedure S10B80.BANINST1.BWPCBREF Rely On
P_GET_GIFT_INFO Oracle Package Procedure S10B80.BANINST1.AOKWEVN Rely On
P_GET_PAF_POSN_INFO Oracle Package Procedure S10B80.BANINST1.POKWLIB Use (select)
P_GET_TIME_APPROVAL Oracle Package Procedure S10B80.BANINST1.BWPCBREF Rely On
P_GET_USER_ID Oracle Package Procedure S10B80.BANINST1.PEKTECM Rely On
P_GET_USER_ID Oracle Package Procedure S10B80.BANINST1.PEKTECM Use (select)
P_INSERT_FILTERED_DATA Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_INSERT_NBTFPRM Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_INSERT_NBTFPRM_MULTIPLE Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_INSERT_NBTORSF Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_INSERT_NBTORSF_EMPSRCH Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_INSERT_SELECTED_ORGNS Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_JSCRIPT_FILL_USRNAME_ARRAY Oracle Package Procedure S10B80.BANINST1.BWPKOJSR Use (select)
P_MODIFY_USER Oracle Package Procedure S10B80.BANINST1.GP_UDC_USER_PROVISIONING Use (delete)
P_NEXT_APPROVER Oracle Package Procedure S10B80.BANINST1.NOKMISC Use (select)
P_OPEN_APPROVAL_RC Oracle Package Procedure S10B80.BANINST1.BWPKEPLK Rely On
P_OPEN_APPROVAL_RC Oracle Package Procedure S10B80.BANINST1.NOKEPAF Rely On
P_OPEN_ORIGINATOR_RC Oracle Package Procedure S10B80.BANINST1.BWPKEPLK Rely On
P_OPEN_ORIGINATOR_RC Oracle Package Procedure S10B80.BANINST1.NOKEPAF Rely On
P_PRINT_APPR_LEVL Oracle Package Procedure S10B80.BANINST1.BWPKEPID Rely On
P_PRINT_CONTRACT_NOTES Oracle Package Procedure S10B80.BANINST1.BWPKFMSC Rely On
P_PRINT_CRSE_CALC_DETL Oracle Package Procedure S10B80.BANINST1.BWPKFCPT Rely On
P_PRINT_EMP_ERRORS Oracle Package Procedure S10B80.BANINST1.BWPKFMSC Rely On
P_PRINT_EMP_SEARCH_RESULTS Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_PRINT_EPAF_DETL Oracle Package Procedure S10B80.BANINST1.BWPKEPDT Rely On
P_PRINT_EPAF_ENTRIES Oracle Package Procedure S10B80.BANINST1.BWPKEPDT Rely On
P_PRINT_FILTERS Oracle Package Procedure S10B80.BANINST1.BWPKFLTR Rely On
P_PRINT_JOBLABORDIST Oracle Package Procedure S10B80.BANINST1.BWPKFJLD Rely On
P_PRINT_ORGANIZATIONS Oracle Package Procedure S10B80.BANINST1.BWPKFSOR Rely On
P_PRINT_PROXY_SETUP Oracle Package Procedure S10B80.BANINST1.BWPKEPID Rely On
P_PRINT_PROXY_SETUP Oracle Package Procedure S10B80.BANINST1.BWPKEPID Use (select)
P_PRINT_TRANS_HIST Oracle Package Procedure S10B80.BANINST1.BWPKEPUT Rely On
P_PROCPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_PROCPROXYSETUP Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
P_PROCSELECTLEAVEREPORTROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_PROCSELECTLEAVEREPORTROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_PROCSELECTLEAVEREQUESTROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_PROCSELECTLEAVEREQUESTROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_PROCSELECTSUPERUSERACTION Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_PROCSELECTSUPERUSERACTION Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_PROCSELECTTIMESHEETROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_PROCSELECTTIMESHEETROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_RESTART Oracle Package Procedure S10B80.BANINST1.BWPKFSEM Rely On
P_SAVE_COMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKFMSC Rely On
P_SECURELOGIN Oracle Package Procedure S10B80.WTAILOR.TWBKWBIS Use (select)
P_SELECTAPPROVERFILTERSBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_SELECTAPPROVERSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_SELECTAPPROVERSUMMARYBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_SELECTLEAVEREPORTROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_SELECTLEAVEREPORTROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_SELECTLEAVEREQUESTROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_SELECTLEAVEREQUESTROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_SELECTORIGINATORFILTERS Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_SELECTORIGINATORFILTERSBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_SELECTORIGINATORSUMMARY Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_SELECTORIGINATORSUMMARYBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_SELECTTIMESHEETROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Rely On
P_SELECTTIMESHEETROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Rely On
P_SUBMIT_TRANSACTION Oracle Package Procedure S10B80.BANINST1.BWPKEPDT Rely On
P_UPDATEEPAFPREVIEW Oracle Package Procedure S10B80.BANINST1.BWPKEPAF Rely On
P_UPDATEEPAFPREVIEWBODY Oracle Package Procedure S10B80.BANINST1.BWPKEPSM Rely On
P_UPDATESTUDENTGRADE Oracle Package Procedure S10B80.BANINST1.SHKWEVN Rely On
P_UPDATE_COMMENTS Oracle Package Procedure S10B80.BANINST1.BWPKEPID Rely On
P_UPDATE_JOBLABORDIST Oracle Package Procedure S10B80.BANINST1.BWPKFJLD Rely On
P_UPDT_CRSE_CALC_DETL Oracle Package Procedure S10B80.BANINST1.BWPKFCPT Rely On
P_UPD_LEAVE_BALANCE Oracle Package Procedure S10B80.BANINST1.PEKLEAV Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_PROXY_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_EFFCERT_ADDL_QUEUE_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_QUEUE_GROUP_RULES Use (select)
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_EA_GROUP_USER_RULES Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_EA_GROUP_USER_RULES Use (select)Rely On
P_VALIDATE Oracle Package Procedure S10B80.BANINST1.NB_REDISTR_ADDL_QUEUE_RULES Use (select)
P_VALIDATE_DUPLICATECHECK Oracle Package Procedure S10B80.BANINST1.BWPKEPCR Rely On
P_VALIDATE_ORIG_ACTION_IND Oracle Package Procedure S10B80.BANINST1.NOKEPAF Rely On
P_VALIDATE_ROUTING_QUEUE Oracle Package Procedure S10B80.BANINST1.PEKTEVT Rely On
P_VALIDATE_USER Oracle Package Procedure S10B80.BANINST1.PEKTEVT Rely On
P_WFEDEVNT Oracle Package Procedure S10B80.BANINST1.GOKSEVN Rely On
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_NB_EA_GROUP_USER Use (select)
F_ADV_PROSPECT_COUNT Oracle Package Function S10B80.BANINST1.BWACXALU Use (select)
F_ADV_PROSPECT_ROWNUM Oracle Package Function S10B80.BANINST1.BWACXALU Use (select)
F_ALERT_XML Oracle Package Function S10B80.BANINST1.BWFCXCHN Rely On
F_ALERT_XML Oracle Package Function S10B80.BANINST1.BWFCXCHN Use (select)
F_CHECK_ASSIGN_CHANGES Oracle Package Function S10B80.BANINST1.BWPKFSEM Rely On
F_CHECK_MORE_ASSGN_EXISTS Oracle Package Function S10B80.BANINST1.BWPKFSEM Rely On
F_CREATE_USER Oracle Package Function S10B80.BANINST1.GP_UDC_USER_PROVISIONING Use (Insert)
F_FINALERT_SUM Oracle Package Function S10B80.BANINST1.BWFCBREF Rely On
F_FINALERT_SUM Oracle Package Function S10B80.BANINST1.CHNLSKBL Rely On
F_FINALERT_TOTAL Oracle Package Function S10B80.BANINST1.BWFCBREF Rely On
F_FIND_PII_DOMAIN Oracle Package Function S10B80.BANINST1.GOKFGAC Rely On
F_FIND_PII_DOMAIN Oracle Package Function S10B80.BANINST1.GOKFGAC Use (select)
F_FIN_ALERT Oracle Package Function S10B80.BANINST1.CHNLSKXM Rely On
F_FIN_ALERT Oracle Package Function S10B80.BANINST1.CHNLSKXM Use (select)
F_GETPIDM Oracle Package Function S10B80.BANINST1.SOKEPRT Use (select)
F_GETSPRIDENNAME Oracle Package Function S10B80.BANINST1.GOKEDVD Use (select)
F_GETUSER Oracle Package Function S10B80.BANINST1.GOKEDVD Rely On
F_GETUSER Oracle Package Function S10B80.BANINST1.GOKEDVD Use (select)
F_GETUSERID Oracle Package Function S10B80.BANINST1.BWFKUAPP Rely On
F_GETUSERID Oracle Package Function S10B80.BANINST1.BWFKUAPP Use (select)
F_GETUSERNAME Oracle Package Function S10B80.BANINST1.BWLKILIB Use (select)
F_GETUSERNAME Oracle Package Function S10B80.BANINST1.BWPCBREF Rely On
F_GETUSERSPRIDENNAME Oracle Package Function S10B80.BANINST1.GOKEDVD Rely On
F_GETUSERSPRIDENNAME Oracle Package Function S10B80.BANINST1.GOKEDVD Use (select)
F_GET_APID_LIST Oracle Package Function S10B80.BANINST1.GB_GOBAPID Use (select)
F_GET_APID_MAP Oracle Package Function S10B80.BANINST1.GB_GOBAPID Use (select)
F_GET_EPAF_DEFAULT Oracle Package Function S10B80.BANINST1.BWPCXCHN Rely On
F_GET_FINALERT Oracle Package Function S10B80.BANINST1.CHNLSKBL Rely On
F_GET_MOVES Oracle Package Function S10B80.BANINST1.BWACBREF Use (select)
F_GET_PROSPECTS_XML Oracle Package Function S10B80.BANINST1.XCHAPERS Use (select)
F_GET_TIME_APPROVAL Oracle Package Function S10B80.BANINST1.BWPCXCHN Rely On
F_GOBEACC_MAP Oracle Package Function S10B80.BANINST1.GOKSSSO Rely On
F_GOBEACC_MAP Oracle Package Function S10B80.BANINST1.GOKSSSO Use (select)
F_GOBEACC_MAP_ID Oracle Package Function S10B80.BANINST1.GOKSSSO Rely On
F_GOBEACC_MAP_ID Oracle Package Function S10B80.BANINST1.GOKSSSO Use (select)
F_GRANTS_XML Oracle Package Function S10B80.BANINST1.BWFCXCHN Rely On
F_OPEN_NTRPROX Oracle Package Function S10B80.BANINST1.NOKEPCR Use (select)
F_ORIG_ACTION_ALLOWED_IND Oracle Package Function S10B80.BANINST1.NOKEPAF Rely On
F_ROUTING_ACTION_IND Oracle Package Function S10B80.BANINST1.NOKEPAF Rely On
F_ROUTING_REC Oracle Package Function S10B80.BANINST1.NOKEPAF Rely On
F_ROUT_ROWID Oracle Package Function S10B80.BANINST1.BWPCBREF Rely On
F_SELECT_NBTFPRM Oracle Package Function S10B80.BANINST1.PEKFLAC Rely On
F_SELECT_NBTFPRM Oracle Package Function S10B80.BANINST1.BWPKFLTR Rely On
F_USERHASSIRDPCLREC Oracle Package Function S10B80.BANINST1.SOKEPRT Rely On
F_USERNAME Oracle Package Function S10B80.BANINST1.GOKEACC Use (select)
F_VALIDATECRN Oracle Package Function S10B80.BANINST1.SSKWEVN Rely On
F_VALIDATECRN Oracle Package Function S10B80.BANINST1.SSKWEVN Use (select)
F_VALIDATESPRIDENID Oracle Package Function S10B80.BANINST1.GOKEDVD Rely On
F_VALIDATESPRIDENID Oracle Package Function S10B80.BANINST1.GOKEDVD Use (select)
F_VALIDATEUSER Oracle Package Function S10B80.BANINST1.GOKEDVD Rely On
F_VALIDATEUSER Oracle Package Function S10B80.BANINST1.GOKEDVD Use (select)
F_VALIDUSER Oracle Package Function S10B80.WTAILOR.TWBKWBIS Rely On
F_VALIDUSER Oracle Package Function S10B80.WTAILOR.TWBKWBIS Use (select)
G$_GET_USERNAME_NAME Oracle Package Function S10B80.BANSECR.G$_SECURITY_PKG Use (select)
GOBEACC Oracle Synonym S10B80.PUBLIC Rely On
FOBPROF SQL Table S10B80.FIMSMGR Join

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBEACC_KEY_INDEX SQL Index S10B80.GENERAL Rely On
PK_GOBEACC SQL Index S10B80.GENERAL Rely On
NTRPROX SQL Table S10B80.POSNCTL Join
GT_GOBEACC_AUDIT_ROW SQL Trigger S10B80.BANSECR Fire (Insert,update,delete,after,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GOBEACC

Object Dates

Creation Date Analysis Date
04/02/2008 20:32:08:000 04/02/2008 21:17:56:000

Source Code Comments

Enterprise Oracle Access Table

Columns Comments for GOBEACC_PIDM (# 1)

Source Code Comments

System generated unique PIDM associated with user.

Columns Comments for GOBEACC_USERNAME (# 2)

Source Code Comments

Oracle user ID.

Columns Comments for GOBEACC_USER_ID (# 3)

Source Code Comments

Current User, system updated.

Columns Comments for GOBEACC_ACTIVITY_DATE (# 4)

Source Code Comments

System date of insert or update.

Table PSRECLS

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PSRECLS_USER_CODE   VARCHAR2(30) No * *
PSRECLS_ECLS_CODE   VARCHAR2(2) No *  
PSRECLS_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PSRECLS_USER_CODE PTRUSER_CODE PTRUSER

Index

Index Name Index Type Column Name
PK_PSRECLS Unique PSRECLS_USER_CODE
PK_PSRECLS Unique PSRECLS_ECLS_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_ECLS_SECURITY SQL Function S10B80.BANINST1 Use (select)
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_ECLS_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_NSKSECR Use (Insert,select)
PSRECLS Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PSRECLS SQL Index S10B80.PAYROLL Rely On
PTRUSER SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PSRECLS

Object Dates

Creation Date Analysis Date
04/02/2008 13:37:40:000 04/02/2008 13:49:12:000

Source Code Comments

Employee Class Code Security Access List Rule Table

Columns Comments for PSRECLS_USER_CODE (# 1)

Source Code Comments

USER CODE: ORACLE assigned User Id for each user accessing BANNER HR.

Columns Comments for PSRECLS_ECLS_CODE (# 2)

Source Code Comments

EMPLOYEE CLASS CODE: Security Employee Class Code.

Columns Comments for PSRECLS_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of Last activity (insert or update) on this record.

Table PSREMPR

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PSREMPR_USER_CODE   VARCHAR2(30) No * *
PSREMPR_EMPR_CODE   VARCHAR2(4) No * *
PSREMPR_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PSREMPR_USER_CODE PTRUSER_CODE PTRUSER
PSREMPR_EMPR_CODE NBRJOBS_EMPR_CODE NBRJOBS

Index

Index Name Index Type Column Name
PK_PSREMPR Unique PSREMPR_USER_CODE
PK_PSREMPR Unique PSREMPR_EMPR_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_CHK_SECURITY Oracle Package Procedure S10B80.BANINST1.BWPKEPDT Use (select)
P_EDIT_EMPR_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
F_EMPR_SECURITY Oracle Package Function S10B80.BANINST1.NOKSECR Use (select)
PSREMPR Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PSREMPR SQL Index S10B80.PAYROLL Rely On
NBRJOBS SQL Table S10B80.POSNCTL Join
PTRUSER SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PSREMPR

Object Dates

Creation Date Analysis Date
04/02/2008 13:40:46:000 04/02/2008 13:49:15:000

Source Code Comments

Employer Code Security Access List Rule Table

Columns Comments for PSREMPR_USER_CODE (# 1)

Source Code Comments

USER CODE: ORACLE assigned User Id for each user accessing BANNER HR.

Columns Comments for PSREMPR_EMPR_CODE (# 2)

Source Code Comments

EMPLOYEE CLASS CODE: Security Employer Code.

Columns Comments for PSREMPR_ACTIVITY_DATE (# 3)

Source Code Comments

ACTIVITY DATE: Date of Last activity (insert or update) on this record.

Table PSRORGN

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PSRORGN_USER_CODE   VARCHAR2(30) No   *
PSRORGN_COAS_CODE   VARCHAR2(1) Yes    
PSRORGN_ORGN_LOW   VARCHAR2(6) No    
PSRORGN_ORGN_HIGH   VARCHAR2(6) No    
PSRORGN_ACTIVITY_DATE   DATE No    

Foreign Key information

Column name is Foreign Key For Column on Table
PSRORGN_USER_CODE PTRUSER_CODE PTRUSER

Index

Index Name Index Type Column Name
PSRORGN_KEY_INDEX Unique PSRORGN_USER_CODE
PSRORGN_KEY_INDEX Unique PSRORGN_COAS_CODE
PSRORGN_KEY_INDEX Unique PSRORGN_ORGN_LOW

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
F_ORGN_SECURITY SQL Function S10B80.BANINST1 Use (select)
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_ORGN_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_GET_ACCESSIBLECOASORGS Oracle Package Procedure S10B80.BANINST1.NOKEPRT Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_NSKSECR Use (Insert,select)
PSRORGN Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PSRORGN_KEY_INDEX SQL Index S10B80.PAYROLL Rely On
PTRUSER SQL Table S10B80.PAYROLL Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PSRORGN

Object Dates

Creation Date Analysis Date
04/02/2008 13:36:15:000 04/02/2008 13:49:10:000

Source Code Comments

Organization Code Security Access List Rule Table

Columns Comments for PSRORGN_USER_CODE (# 1)

Source Code Comments

USER CODE: The user ID whose security is being defined.

Columns Comments for PSRORGN_COAS_CODE (# 2)

Source Code Comments

CHART OF ACCOUNTS CODE: Chart defined in BANNER Finance that is associated with this organization.

Columns Comments for PSRORGN_ORGN_LOW (# 3)

Source Code Comments

SECURITY ORGANIZATION CODE LOW: Low end of permissable range.

Columns Comments for PSRORGN_ORGN_HIGH (# 4)

Source Code Comments

SECURITY ORGANIZATION CODE HIGH: High end of permissable range.

Columns Comments for PSRORGN_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date of last activity (insert or update) on this record.

Table PTRUSER

Server Name S10B80
Database Name PAYROLL
Table Label

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PTRUSER_CODE   VARCHAR2(30) No * *
PTRUSER_NAME   VARCHAR2(35) Yes    
PTRUSER_TITLE   VARCHAR2(35) Yes    
PTRUSER_MASTER_ECLS_IND   VARCHAR2(1) Yes    
PTRUSER_MASTER_ORGN_IND   VARCHAR2(1) Yes    
PTRUSER_SALA_LEVEL   NUMBER(11,2) Yes    
PTRUSER_ACTIVITY_DATE   DATE No    
PTRUSER_MASTER_EMPR_IND   VARCHAR2(1) No    
PTRUSER_TE_APPR_SUPERUSER   VARCHAR2(1) No    
PTRUSER_BEN_ADMIN_IND   VARCHAR2(1) No    
PTRUSER_LEAV_REPT_APPR_SUPER   VARCHAR2(1) No    
PTRUSER_MASTER_SP_ORGN_IND   VARCHAR2(1) No    
PTRUSER_MASTER_FL_ORGN_IND   VARCHAR2(1) No    
PTRUSER_EC_SUPERUSER_IND   VARCHAR2(1) Yes    

Foreign Key information

Column name is Foreign Key For Column on Table
PTRUSER_CODE GOBEACC_USERNAME GOBEACC

Index

Index Name Index Type Column Name
PK_PTRUSER Unique PTRUSER_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PSRECLS SQL Table S10B80.PAYROLL Refer (no action)
PSREMPR SQL Table S10B80.PAYROLL Refer (no action)
PSRORGN SQL Table S10B80.PAYROLL Refer (no action)
F_ECLS_SECURITY SQL Function S10B80.BANINST1 Use (select)
F_ORGN_SECURITY SQL Function S10B80.BANINST1 Use (select)
PTRUSER_RECTYPE Oracle Package Type S10B80.BANINST1.POKRECS Rely On
APPR_EXIST Oracle Package Cursor S10B80.BANINST1.BWPKTAIS Use (select)
APPR_EXIST Oracle Package Cursor S10B80.BANINST1.BWPKLRED Use (select)
PTRUSER_INFO Oracle Package Cursor S10B80.BANINST1.BWPKTAIS Rely On
PTRUSER_INFO Oracle Package Cursor S10B80.BANINST1.BWPKTAIS Use (select)
PTRUSER_INFO Oracle Package Cursor S10B80.BANINST1.BWPKLRED Rely On
PTRUSER_INFO Oracle Package Cursor S10B80.BANINST1.BWPKLRED Use (select)
P_DISPLAYPROXY Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_DISPLAYPROXY Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
UT_PB_SKILLCREATEAPI Oracle Package Procedure S10B80.BANINST1.UT_PB_SKILL Use (update)
UT_PB_SKILLDELETEAPI Oracle Package Procedure S10B80.BANINST1.UT_PB_SKILL Use (update)
UT_PB_SKILLUPDATEAPI Oracle Package Procedure S10B80.BANINST1.UT_PB_SKILL Use (update)
PTRUSER_ROW Oracle Package Variable S10B80.BANINST1.NOKSECR Rely On
F_ISBENADMIN Oracle Package Function S10B80.BANINST1.BWPKEBST Use (select)
F_PTRUSER_TE_APPR_INFO Oracle Package Function S10B80.BANINST1.BWPCXCHN Rely On
P_BUILD_BDLC Oracle Package Procedure S10B80.BANINST1.BWPKSORG Use (select)
P_CHECK_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_ECLS_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_EMPR_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_ORGN_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_EDIT_SALA_SECURITY Oracle Package Procedure S10B80.BANINST1.NOKSECR Use (select)
P_SELECTLEAVEREPORTROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_SELECTLEAVEREPORTROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
P_SELECTLEAVEREQUESTROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_SELECTLEAVEREQUESTROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
P_SELECTTIMESHEETROLL Oracle Package Procedure S10B80.BANINST1.BWPKTAIS Use (select)
P_SELECTTIMESHEETROLL Oracle Package Procedure S10B80.BANINST1.BWPKLRED Use (select)
UT_SETUP Oracle Package Procedure S10B80.BANINST1.UT_NSKSECR Use (Insert,update,select)
F_EMPR_SECURITY Oracle Package Function S10B80.BANINST1.NOKSECR Use (select)
F_GETMASTERECLASSIND Oracle Package Function S10B80.BANINST1.NOKEPRT Use (select)
F_GETMASTEREMPIND Oracle Package Function S10B80.BANINST1.NOKEPRT Use (select)
F_GETMASTERORGIND Oracle Package Function S10B80.BANINST1.NOKEPRT Use (select)
F_GETSALARYLEVEL Oracle Package Function S10B80.BANINST1.NOKEPRT Use (select)
F_PTRUSER_REC Oracle Package Function S10B80.BANINST1.POKRECS Rely On
F_SALA_SECURITY Oracle Package Function S10B80.BANINST1.NOKSECR Use (select)
F_USERHASPTRUSERREC Oracle Package Function S10B80.BANINST1.NOKEPRT Use (select)
PTRUSER Oracle Synonym S10B80.PUBLIC Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PTRUSER SQL Index S10B80.PAYROLL Rely On
GOBEACC SQL Table S10B80.GENERAL Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.PAYROLL.PTRUSER

Object Dates

Creation Date Analysis Date
04/02/2008 13:38:44:000 04/02/2008 13:49:13:000

Source Code Comments

User Code Rule Table

Columns Comments for PTRUSER_CODE (# 1)

Source Code Comments

USER CODE: A code which identifies one or a group of users.

Columns Comments for PTRUSER_NAME (# 2)

Source Code Comments

USER NAME: The name of the user assigned to this password.

Columns Comments for PTRUSER_TITLE (# 3)

Source Code Comments

USER TITLE: The title of the user assigned to this User Code.

Columns Comments for PTRUSER_MASTER_ECLS_IND (# 4)

Source Code Comments

MASTER EMPLOYEE CLASS ACCESS INDICATOR: Indicates if this user will be allowedto view the records of all employees regardless of their Employee Class. This indicator will override the Employee Class Security Form (PSAECLS).

Columns Comments for PTRUSER_MASTER_ORGN_IND (# 5)

Source Code Comments

MASTER ORGANIZATION ACCESS INDICATOR: Indicates if this user will be allowed to look at records for all employees regardless of the organization to which they belong. This indicator overrides the Organization Security Form (PSAO

Columns Comments for PTRUSER_SALA_LEVEL (# 6)

Source Code Comments

SALARY LEVEL ACCESS: Indicates the highest salary level of the employees this user will be able to view.

Columns Comments for PTRUSER_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: Date when the record was inserted or last modified.

Columns Comments for PTRUSER_MASTER_EMPR_IND (# 8)

Source Code Comments

Master Employer Security Ind: Values (Y)es, the user can see all Employers. (N)o the user cannot see all Employers.

Columns Comments for PTRUSER_TE_APPR_SUPERUSER (# 9)

Source Code Comments

Time Entry Approvals Superuser.

Columns Comments for PTRUSER_BEN_ADMIN_IND (# 10)

Source Code Comments

Benefit Administrator Indicator.

Columns Comments for PTRUSER_LEAV_REPT_APPR_SUPER (# 11)

Source Code Comments

LEAVE REPORTING APPROVALS SUPERUSER ROLE: allows a specific user has the ability to monitor the Leave Reporting, override and apply leave.

Columns Comments for PTRUSER_MASTER_SP_ORGN_IND (# 12)

Source Code Comments

MASTER_SP_ORGN_IND:This is the indicator depicting whether the user has Master Orgn security for the Salary Planner. Valid Values are Y or N.

Columns Comments for PTRUSER_MASTER_FL_ORGN_IND (# 13)

Source Code Comments

FACULTY COMPENSATION MASTER ORGANIZATION INDICATOR: Indicator to identify whether the user has Master Organization security for the Faculty Compensation. (N)one, (Q)uery, (U)pdate.

Columns Comments for PTRUSER_EC_SUPERUSER_IND (# 14)

Source Code Comments

EFFORT CERTIFICATION SUPERUSER: Indicates that the user is a superuser for Effort Certification. Valid values are (Y)es, (N)o. Default value is N.

Link between PTRUSER and GOBEACC


Join Information

Objects list
scope-function : S10B80.BANINST1.BWPKEBST.F_ISBENADMIN

Link List

Link Type Link Project
Join Link Between PTRUSER and GOBEACC PAYROLL

List of Real links

Link type Between And
Join PTRUSER GOBEACC

Link between PSRECLS and PTRUSER


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PSRECLS and PTRUSER (FK1_PSRECLS_INV_PTRUSER_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PSRECLS PSRECLS_USER_CODE PTRUSER_CODE PTRUSER (1,1)-(0,n)

Link between PSRORGN and PTRUSER


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PSRORGN and PTRUSER (FK1_PSRORGN_INV_PTRUSER_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PSRORGN PSRORGN_USER_CODE PTRUSER_CODE PTRUSER (1,1)-(0,n)

Link between PSREMPR and PTRUSER


Link List

Link Type Link Project
Refer (no action) Link Informative Foreign Key Between PSREMPR and PTRUSER (FK1_PSREMPR_INV_PTRUSER_KEY) PAYROLL

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PSREMPR PSREMPR_USER_CODE PTRUSER_CODE PTRUSER (1,1)-(0,n)