GOBEACC PSRECLS PSREMPR PSRORGN PTRUSER

Model Security


Model Label : Banner HR Security Module
Path : Default Folder/B70/payroll/Security

List of Objects

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

Comments

Model View

''

Table GOBEACC

Schema Name GENERAL
Label GOBEACC
Server name S4B70
Creation Date 09/09/2004 23:42:38:000

Table Columns information

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

Foreign Key information

No Foreign Key

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
check_page C/C++ Function [F:\BANNER\C\FORCONV.PC] Use()
ins_gobeacc_new C/C++ Function [F:\BANNER\C\FORCONV.PC] Use(insert )
print_exception_a C/C++ Function [F:\BANNER\C\FORCONV.PC] Use()
print_exception_c C/C++ Function [F:\BANNER\C\FORCONV.PC] Use()
sel_fobprof_new C/C++ Function [F:\BANNER\C\FORCONV.PC] Use(select )
summary_report C/C++ Function [F:\BANNER\C\FORCONV.PC] Use()
validate_proxy_id C/C++ Function [F:\BANNER\C\NOPEAMA.PC] Use(select )
GOBEACC SYNONYM S4B70.PUBLIC Rely on ()
FT_FOBPROF_AR_LDI TRIGGER S4B70.FIMSMGR Use(select )
FT_FOBPROF_AR_LDI TRIGGER S4B70.FIMSMGR Rely on ()
FOBPROF TABLE S4B70.FIMSMGR Join
GOBVUSR TABLE S4B70."GENERAL" Join
NOBTRAN TABLE S4B70.POSNCTL Join
SPRIDEN TABLE S4B70.SATURN Join
PHVTIME VIEW S4B70.BANINST1 Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GORWFDS.KEY_BLOCK.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GORWFDS.KEY_BLOCK.ID Use(select )
CALL_FORM_EVENT Forms Trigger BANNER7_FORMS.FRAPROP Rely on () Use(select )
CALL_FORM_EVENT Forms Trigger BANNER7_FORMS_10G.FRAPROP Rely on () Use(select )
CALL_FORM_EVENT Forms Trigger BANNER7_FORMS_10G.FRAGRNT Rely on () Use(select )
CALL_FORM_EVENT Forms Trigger BANNER7_FORMS.FRAGRNT Rely on () Use(select )
DO_GOBEACC_LOGIC Forms Trigger BANNER7_FORMS.FOMPROF Rely on () Use(insert,update,delete,select )
DO_GOBEACC_LOGIC Forms Trigger BANNER7_FORMS_10G.FOMPROF Rely on () Use(insert,update,delete,select )
GET_GOBEACC_REC Forms Trigger BANNER7_FORMS.FOMPROF Use(select )
GET_GOBEACC_REC Forms Trigger BANNER7_FORMS_10G.FOMPROF Use(select )
POST_FORMS_COMMIT_TRG Forms Trigger BANNER7_FORMS.FOMPROF Use(select )
POST_FORMS_COMMIT_TRG Forms Trigger BANNER7_FORMS_10G.FOMPROF Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG Forms Trigger BANNER7_FORMS.SOAROLE Use(select )
WHEN_NEW_BLOCK_INSTANCE_TRG Forms Trigger BANNER7_FORMS_10G.SOAROLE Use(select )
GOBEACC_RG Forms Record Group BANNER7_FORMS.GORWFDS Use(select )
GOBEACC_RG Forms Record Group BANNER7_FORMS_10G.GORWFDS Use(select )
GOBVUSR_RG Forms Record Group BANNER7_FORMS.GOQOLIB Use(select )
GOBVUSR_RG Forms Record Group BANNER7_FORMS_10G.GOASEGC Use(select )
GOBVUSR_RG Forms Record Group BANNER7_FORMS_10G.GOAEACC Use(select )
GOBVUSR_RG Forms Record Group BANNER7_FORMS_10G.GOQOLIB Use(select )
GOBVUSR_RG Forms Record Group BANNER7_FORMS.GOAEACC Use(select )
GOBVUSR_RG Forms Record Group BANNER7_FORMS.GOASEGC Use(select )
NOBTRAN_RG Forms Record Group BANNER7_FORMS.NOIESUM Use(select )
NOBTRAN_RG Forms Record Group BANNER7_FORMS_10G.NOIESUM Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.FOMPROF.FOBPROF Use(delete )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.FOMPROF.FOBPROF Use(delete )
GET_PIDM Forms Procedure BANNER7_FORMS.PHATIME Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS_10G.PHADSUM Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS_10G.PEATMVF Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS_10G.PHIETIM Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS_10G.PHATIME Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS.PHIETIM Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS.PEATMVF Use(select )
GET_PIDM Forms Procedure BANNER7_FORMS.PHADSUM Use(select )
F_FINANCE_USER_IC FUNCTION S4B70.BANINST1 Use(select )
F_FINANCE_USER_IND FUNCTION S4B70.BANINST1 Use(select )
F_CHECKUSERPIDM Forms Function BANNER7_FORMS.GOAEACC Use(select )
F_CHECKUSERPIDM Forms Function BANNER7_FORMS_10G.GOAEACC Use(select )
F_GET_PIDM_FROM_USERNAME Forms Function BANNER7_FORMS.PHATIME Rely on () Use(select )
F_GET_PIDM_FROM_USERNAME Forms Function BANNER7_FORMS_10G.PHATIME Rely on () Use(select )
GOBEACC_TYPE Package Type S4B70.BANINST1.BWAKLIBS Rely on ()
USERRECORD Package Type S4B70.BANINST1.BWFKRPCU Rely on ()
OVERRIDE_NSF Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_CHECK_SECURITY Package procedure S4B70.BANINST1.BWFKPURR Rely on ()
P_CHECK_SECURITY Package procedure S4B70.BANINST1.BWFKREQN Rely on ()
P_CHECK_SECURITY Package procedure S4B70.BANINST1.BWFKTRAN Rely on ()
P_DISPLAYPROXY Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_DISPLAYPROXY Package procedure S4B70.BANINST1.BWPKTAIS Use(select )
P_DOAPPROVE Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_DODISAPPROVE Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_INSERTCOMMENT Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_NOTIFY_APPROVER Package procedure S4B70.BANINST1.PEKTEAP Rely on ()
P_PERSONALINFO Package procedure S4B70.BANINST1.BWPKEBST Rely on ()
P_SELECTAPPROVERACTION Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_SELECTNJSUPERUSERACTION Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_SELECTSUPERUSERACTION Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
GETAMRPLANBYDATEC Package cursor S4B70.BANINST1.BWDKMOVE Use(select )
GETAMRPLANDATEC Package cursor S4B70.BANINST1.BWDKMOVE Use(select )
GETAMRPLANGEORC Package cursor S4B70.BANINST1.BWDKMOVE Use(select )
GETAMRPLANNAMEC Package cursor S4B70.BANINST1.BWDKMOVE Use(select )
GETAMRPLANPROJC Package cursor S4B70.BANINST1.BWDKMOVE Use(select )
GETPASSEDAMRPLANC Package cursor S4B70.BANINST1.BWDKMOVE Use(select )
GET_PROXY_NAME Package cursor S4B70.BANINST1.BWPKTAIS Use(select )
GOBEACCC Package cursor S4B70.WTAILOR.TWBKAUSR Use(select )
CURRUSERID Package variable S4B70.BANINST1.BWFKUAPP Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSORG Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSALA Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSJOB Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSFDT Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSTOT Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSMEX Rely on ()
GLOBAL_USER Package variable S4B70.BANINST1.BWPKSDST Rely on ()
MAPPED_PIDM Package variable S4B70.WTAILOR.TWBKAUSR Rely on ()
PIDM Package variable S4B70.BANINST1.BWFKUADI Rely on ()
PIDM Package variable S4B70.BANINST1.BWFKUAPP Rely on ()
VAR_GOBEACC_USERNAME Package variable S4B70.BANINST1.BWPKSPOS Rely on ()
F_GETUSERID Package function S4B70.BANINST1.BWFKUAPP Rely on ()
F_GETUSERID Package function S4B70.BANINST1.BWFKUAPP Use(select )
F_GET_GURIDEN_IDEN_CODE Package function S4B70.BANINST1.BWACXCHN Use(select )
F_ISBENADMIN Package function S4B70.BANINST1.BWPKEBST Use(select )
P_ADV_PROSPECT_COUNT Package procedure S4B70.BANINST1.BWACBREF Use(select )
P_ADV_PROSPECT_ROWNUM Package procedure S4B70.BANINST1.BWACBREF Use(select )
P_APPDISAPPDOC Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_APPROVEDOC Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_APPROVERSUMMARY Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_COMMENTS Package procedure S4B70.BANINST1.BWPKTELC Rely on ()
P_COMMENTS Package procedure S4B70.BANINST1.BWPKTALC Rely on ()
P_CREATE_ROUTING_QUEUE Package procedure S4B70.BANINST1.PEKTECM Rely on ()
P_DISAPPROVEDOC Package procedure S4B70.BANINST1.BWFKUADI Rely on ()
P_DISPDATESELECT Package procedure S4B70.BANINST1.BWPKEBST Rely on ()
P_DISPDATESELECT Package procedure S4B70.BANINST1.BWPKEBST Use(select )
P_DISPLAYPROXYSETUP Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_DISPLAYPROXYSETUP Package procedure S4B70.BANINST1.BWPKTAIS Use(select )
P_GETGOBEACCINFO Package procedure S4B70.BANINST1.GOKEACC Rely on ()
P_GETGOBEACCINFO Package procedure S4B70.BANINST1.GOKEACC Use(select )
P_GETGRADECHANGEEDATA Package procedure S4B70.BANINST1.SHKWEVN Rely on ()
P_GETWFUSERNAME Package procedure S4B70.BANINST1.GOKEACC Rely on ()
P_GET_ADV_PROSPECT Package procedure S4B70.BANINST1.BWACBREF Use(select )
P_GET_EPAF Package procedure S4B70.BANINST1.BWNCBREF Rely on ()
P_GET_EPAF Package procedure S4B70.BANINST1.BWPCBREF Rely on ()
P_GET_GIFT_INFO Package procedure S4B70.BANINST1.AOKWEVN Rely on ()
P_GET_PAF_POSN_INFO Package procedure S4B70.BANINST1.POKWLIB Use(select )
P_GET_TIME_APPROVAL Package procedure S4B70.BANINST1.BWPCBREF Rely on ()
P_GET_USER_ID Package procedure S4B70.BANINST1.PEKTECM Rely on ()
P_GET_USER_ID Package procedure S4B70.BANINST1.PEKTECM Use(select )
P_LOGIN Package procedure S4B70.WTAILOR.TWBKLOGN Use(select )
P_NEXT_APPROVER Package procedure S4B70.BANINST1.NOKMISC Use(select )
P_PROCPROXYSETUP Package procedure S4B70.BANINST1.BWPKTAIS Use(select )
P_PROCSELECTLEAVEREPORTROLL Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_PROCSELECTLEAVEREQUESTROLL Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_PROCSELECTSUPERUSERACTION Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_PROCSELECTTIMESHEETROLL Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_SECURELOGIN Package procedure S4B70.WTAILOR.TWBKLOGN Use(select )
P_SELECTLEAVEREPORTROLL Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_SELECTLEAVEREQUESTROLL Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_SELECTTIMESHEETROLL Package procedure S4B70.BANINST1.BWPKTAIS Rely on ()
P_UPDATESTUDENTGRADE Package procedure S4B70.BANINST1.SHKWEVN Rely on ()
P_UPD_LEAVE_BALANCE Package procedure S4B70.BANINST1.PEKLEAV Rely on ()
P_VALIDATE_ROUTING_QUEUE Package procedure S4B70.BANINST1.PEKTEVT Rely on ()
P_VALIDATE_USER Package procedure S4B70.BANINST1.PEKTEVT Rely on ()
P_WFEDEVNT Package procedure S4B70.BANINST1.GOKSEVN Rely on ()
GETGOBEACCC Package cursor S4B70.BANINST1.BWAKLIBS Use(select )
GETPROSPECTSC Package cursor S4B70.BANINST1.BWAKLIBS Use(select )
GETUSERID Package cursor S4B70.BANINST1.BWFKRPCU Use(select )
F_ADV_PROSPECT_COUNT Package function S4B70.BANINST1.BWACXALU Use(select )
F_ADV_PROSPECT_ROWNUM Package function S4B70.BANINST1.BWACXALU Use(select )
F_ALERT_XML Package function S4B70.BANINST1.BWFCXCHN Rely on ()
F_ALERT_XML Package function S4B70.BANINST1.BWFCXCHN Use(select )
F_FINALERT_SUM Package function S4B70.BANINST1.BWFCBREF Rely on ()
F_FINALERT_SUM Package function S4B70.BANINST1.CHNLSKBL Rely on ()
F_FINALERT_TOTAL Package function S4B70.BANINST1.BWFCBREF Rely on ()
F_FIND_PII_DOMAIN Package function S4B70.BANINST1.GOKFGAC Use(select )
F_FIND_PII_DOMAIN Package function S4B70.BANINST1.GOKFGAC Rely on ()
F_FIN_ALERT Package function S4B70.BANINST1.CHNLSKXM Rely on ()
F_FIN_ALERT Package function S4B70.BANINST1.CHNLSKXM Use(select )
F_GETSPRIDENNAME Package function S4B70.BANINST1.GOKEDVD Use(select )
F_GETUSER Package function S4B70.BANINST1.GOKEDVD Rely on ()
F_GETUSER Package function S4B70.BANINST1.GOKEDVD Use(select )
F_GETUSERNAME Package function S4B70.BANINST1.BWLKILIB Use(select )
F_GETUSERNAME Package function S4B70.BANINST1.BWPCBREF Rely on ()
F_GETUSERSPRIDENNAME Package function S4B70.BANINST1.GOKEDVD Rely on ()
F_GETUSERSPRIDENNAME Package function S4B70.BANINST1.GOKEDVD Use(select )
F_GET_EPAF Package function S4B70.BANINST1.BWNCXCHN Rely on ()
F_GET_EPAF_DEFAULT Package function S4B70.BANINST1.BWPCXCHN Rely on ()
F_GET_FINALERT Package function S4B70.BANINST1.CHNLSKBL Rely on ()
F_GET_MOVES Package function S4B70.BANINST1.BWACBREF Use(select )
F_GET_MOVES Package function S4B70.BANINST1.GSTAUB Use(select )
F_GET_PROSPECTS_XML Package function S4B70.BANINST1.XCHAPERS Use(select )
F_GET_TIME_APPROVAL Package function S4B70.BANINST1.BWPCXCHN Rely on ()
F_GOBEACC_MAP Package function S4B70.BANINST1.GOKSSSO Use(select )
F_GOBEACC_MAP Package function S4B70.BANINST1.GOKSSSO Rely on ()
F_GOBEACC_MAP_ID Package function S4B70.BANINST1.GOKSSSO Use(select )
F_GOBEACC_MAP_ID Package function S4B70.BANINST1.GOKSSSO Rely on ()
F_GRANTS_XML Package function S4B70.BANINST1.BWFCXCHN Rely on ()
F_USERNAME Package function S4B70.BANINST1.GOKEACC Use(select )
F_VALIDATECRN Package function S4B70.BANINST1.SSKWEVN Rely on ()
F_VALIDATECRN Package function S4B70.BANINST1.SSKWEVN Use(select )
F_VALIDATESPRIDENID Package function S4B70.BANINST1.GOKEDVD Rely on ()
F_VALIDATESPRIDENID Package function S4B70.BANINST1.GOKEDVD Use(select )
F_VALIDATEUSER Package function S4B70.BANINST1.GOKEDVD Rely on ()
F_VALIDATEUSER Package function S4B70.BANINST1.GOKEDVD Use(select )
F_VALIDUSER Package function S4B70.WTAILOR.TWBKWBIS Use(select )
GOBEACC Forms DataBlock BANNER7_FORMS.GOAEACC Rely on () Use(insert,update,delete,select )
GOBEACC Forms DataBlock BANNER7_FORMS_10G.GOAEACC Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
GOBEACC_KEY_INDEX INDEX S4B70."GENERAL" Rely on ()
PK_GOBEACC INDEX S4B70."GENERAL" Rely on ()

Comments

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

Schema Name PAYROLL
Label PSRECLS
Server name S4B70
Creation Date 10/20/2004 11:52:41:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PSRECLS_USER_CODE PSRECLS_USER_CODE VARCHAR2(30) No * *
PSRECLS_ECLS_CODE PSRECLS_ECLS_CODE VARCHAR2(2) No *
PSRECLS_ACTIVITY_DATE 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
PSRECLS SYNONYM S4B70.PUBLIC Rely on ()
COPY_SECURITY Forms Trigger BANNER7_FORMS.PSAECLS Use(insert,delete,select )
COPY_SECURITY Forms Trigger BANNER7_FORMS_10G.PSAECLS Use(insert,delete,select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS.PHAHOUR Use(select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS_10G.PHAHOUR Use(select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS.PAIPOSN.KEY_BLOCK Use(select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS_10G.PAIPOSN.KEY_BLOCK Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS.PSAECLS.PSRECLS_DUMMY Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.PSAECLS.PSRECLS_DUMMY Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS.PTRUSER.PTRUSER Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PTRUSER.PTRUSER Use(delete )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.PCAPERS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS_10G.PCAPERS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.POQRPLS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS_10G.POQRPLS Use(select )
F_ECLS_SECURITY FUNCTION S4B70.BANINST1 Use(select )
SELECT_PSRECLS_2 Forms Function BANNER7_FORMS.PSAECLS Use(select )
SELECT_PSRECLS_2 Forms Function BANNER7_FORMS_10G.PSAECLS Use(select )
P_CHECK_SECURITY Package procedure S4B70.BANINST1.NOKSECR Use(select )
P_CREATE_EMPL_CLASS_SECURITY Package procedure S4B70.WFBANNER.WFAKBEXM Use(insert )
P_EDIT_ECLS_SECURITY Package procedure S4B70.BANINST1.NOKSECR Use(select )
P_EDIT_ECLS_SECURITY Forms Sub Procedure BANNER7_FORMS.PEAFACL.SPEC Use(select )
P_EDIT_ECLS_SECURITY Forms Sub Procedure BANNER7_FORMS_10G.PEAFACL.SPEC Use(select )
F_TIME_ENTRY_SECURITY Package function S4B70.BANINST1.NOKSECR Use(select )
PHRJOBS Forms DataBlock BANNER7_FORMS.PHAHOUR Use(select )
PHRJOBS Forms DataBlock BANNER7_FORMS_10G.PHAHOUR Use(select )
PSRECLS Forms DataBlock BANNER7_FORMS.PSAECLS Rely on () Use(insert,update,delete,select )
PSRECLS Forms DataBlock BANNER7_FORMS_10G.PSAECLS Rely on () Use(insert,update,delete,select )
PSRECLS_DUMMY Forms DataBlock BANNER7_FORMS.PSAECLS Rely on () Use(insert,update,delete,select )
PSRECLS_DUMMY Forms DataBlock BANNER7_FORMS_10G.PSAECLS Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PSRECLS INDEX S4B70.PAYROLL Rely on ()
PTRUSER TABLE S4B70.PAYROLL Refer( No Action )

Comments

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

Schema Name PAYROLL
Label PSREMPR
Server name S4B70
Creation Date 10/20/2004 11:52:43:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PSREMPR_USER_CODE PSREMPR_USER_CODE VARCHAR2(30) No * *
PSREMPR_EMPR_CODE PSREMPR_EMPR_CODE VARCHAR2(4) No * *
PSREMPR_ACTIVITY_DATE 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
PSREMPR SYNONYM S4B70.PUBLIC Rely on ()
COPY_SECURITY Forms Trigger BANNER7_FORMS.PSAEMPR Use(insert,delete,select )
COPY_SECURITY Forms Trigger BANNER7_FORMS_10G.PSAEMPR Use(insert,delete,select )
POST-DELETE Forms Trigger BANNER7_FORMS.PSAEMPR.PSREMPR_DUMMY Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.PSAEMPR.PSREMPR_DUMMY Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS.PTRUSER.PTRUSER Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PTRUSER.PTRUSER Use(delete )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.PCAPERS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS_10G.PCAPERS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.POQRPLS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS_10G.POQRPLS Use(select )
SELECT_PSREMPR_1 Forms Function BANNER7_FORMS.PSAEMPR Use(select )
SELECT_PSREMPR_1 Forms Function BANNER7_FORMS_10G.PSAEMPR Use(select )
P_CHECK_SECURITY Package procedure S4B70.BANINST1.NOKSECR Use(select )
P_CREATE_EMPLOYER_SECURITY Package procedure S4B70.WFBANNER.WFAKBEXM Use(insert )
P_EDIT_EMPR_SECURITY Package procedure S4B70.BANINST1.NOKSECR Use(select )
P_EDIT_EMPR_SECURITY Forms Sub Procedure BANNER7_FORMS.PEAFACL.SPEC Use(select )
P_EDIT_EMPR_SECURITY Forms Sub Procedure BANNER7_FORMS_10G.PEAFACL.SPEC Use(select )
F_EMPR_SECURITY Package function S4B70.BANINST1.NOKSECR Use(select )
PSREMPR Forms DataBlock BANNER7_FORMS.PSAEMPR Rely on () Use(insert,update,delete,select )
PSREMPR Forms DataBlock BANNER7_FORMS_10G.PSAEMPR Rely on () Use(insert,update,delete,select )
PSREMPR_DUMMY Forms DataBlock BANNER7_FORMS.PSAEMPR Rely on () Use(insert,update,delete,select )
PSREMPR_DUMMY Forms DataBlock BANNER7_FORMS_10G.PSAEMPR Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_PSREMPR INDEX S4B70.PAYROLL Rely on ()
NBRJOBS TABLE S4B70.POSNCTL Join
PTRUSER TABLE S4B70.PAYROLL Refer( No Action )

Comments

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

Schema Name PAYROLL
Label PSRORGN
Server name S4B70
Creation Date 10/20/2004 11:52:40:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
PSRORGN_USER_CODE PSRORGN_USER_CODE VARCHAR2(30) No *
PSRORGN_COAS_CODE PSRORGN_COAS_CODE VARCHAR2(1) Yes
PSRORGN_ORGN_LOW PSRORGN_ORGN_LOW VARCHAR2(6) No
PSRORGN_ORGN_HIGH PSRORGN_ORGN_HIGH VARCHAR2(6) No
PSRORGN_ACTIVITY_DATE 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
PSRORGN SYNONYM S4B70.PUBLIC Rely on ()
COPY_SECURITY Forms Trigger BANNER7_FORMS.PSAORGN Use(insert,delete,select )
COPY_SECURITY Forms Trigger BANNER7_FORMS_10G.PSAORGN Use(insert,delete,select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS.PHAHOUR Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS_10G.PHAHOUR Use(select )
KEY-CREREC Forms Trigger BANNER7_FORMS.PSAORGN.KEY_BLOCK Use(select )
KEY-CREREC Forms Trigger BANNER7_FORMS_10G.PSAORGN.KEY_BLOCK Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.PSAORGN.KEY_BLOCK Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.PSAORGN.KEY_BLOCK Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS.PHIJOBS.KEY_BLOCK Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS_10G.PHIJOBS.KEY_BLOCK Use(select )
POST-DELETE Forms Trigger BANNER7_FORMS.PSAORGN.PSRORGN_DUMMY Use(delete )
POST-DELETE Forms Trigger BANNER7_FORMS_10G.PSAORGN.PSRORGN_DUMMY Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS.PTRUSER.PTRUSER Use(delete )
PRE-DELETE Forms Trigger BANNER7_FORMS_10G.PTRUSER.PTRUSER Use(delete )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.PCAPERS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS_10G.PCAPERS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.POQRPLS Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS_10G.POQRPLS Use(select )
F_ORGN_SECURITY FUNCTION S4B70.BANINST1 Use(select )
P_CHECK_SECURITY Package procedure S4B70.BANINST1.NOKSECR Use(select )
P_CREATE_ORGINIZATION_SECURITY Package procedure S4B70.WFBANNER.WFAKBEXM Use(insert )
P_EDIT_ORGN_SECURITY Package procedure S4B70.BANINST1.NOKSECR Use(select )
P_GET_ACCESSIBLECOASORGS Package procedure S4B70.BANINST1.NOKEPRT Use(select )
P_EDIT_ORGN_SECURITY Forms Sub Procedure BANNER7_FORMS.PEAFACL.SPEC Use(select )
P_EDIT_ORGN_SECURITY Forms Sub Procedure BANNER7_FORMS_10G.PEAFACL.SPEC Use(select )
F_TIME_ENTRY_SECURITY Package function S4B70.BANINST1.NOKSECR Use(select )
PHRJOBS Forms DataBlock BANNER7_FORMS.PHAHOUR Use(select )
PHRJOBS Forms DataBlock BANNER7_FORMS_10G.PHAHOUR Use(select )
PSRORGN Forms DataBlock BANNER7_FORMS.PSAORGN Rely on () Use(insert,update,delete,select )
PSRORGN Forms DataBlock BANNER7_FORMS_10G.PSAORGN Rely on () Use(insert,update,delete,select )
PSRORGN_DUMMY Forms DataBlock BANNER7_FORMS.PSAORGN Rely on () Use(insert,update,delete,select )
PSRORGN_DUMMY Forms DataBlock BANNER7_FORMS_10G.PSAORGN Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PSRORGN_KEY_INDEX INDEX S4B70.PAYROLL Rely on ()
PTRUSER TABLE S4B70.PAYROLL Refer( No Action )

Comments

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

Schema Name PAYROLL
Label PTRUSER
Server name S4B70
Creation Date 10/20/2004 11:52:20:000

Table Columns information

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

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_PTRUSER Unique PTRUSER_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
PTRUSER SYNONYM S4B70.PUBLIC Rely on ()
PSRECLS TABLE S4B70.PAYROLL Refer( No Action )
PSREMPR TABLE S4B70.PAYROLL Refer( No Action )
PSRORGN TABLE S4B70.PAYROLL Refer( No Action )
ECLS_SECURITY Forms Trigger BANNER7_FORMS.PHAHOUR Use(select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS_10G.PHAHOUR Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS.PHAHOUR Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS_10G.PHAHOUR Use(select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS.PAIPOSN.KEY_BLOCK Use(select )
ECLS_SECURITY Forms Trigger BANNER7_FORMS_10G.PAIPOSN.KEY_BLOCK Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS.PHIJOBS.KEY_BLOCK Use(select )
ORGN_SECURITY Forms Trigger BANNER7_FORMS_10G.PHIJOBS.KEY_BLOCK Use(select )
P$_DO_SECURITY Forms Procedure BANNER7_FORMS.PCAPERS