GOBEACC PSRECLS PSREMPR PSRORGN PTRUSER

Model Security


Model Label : Banner HR Security Module
Path : BANNER DEV/HR/Security

List of Objects

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

Comments

Model View

''

Table GOBEACC

Schema Name GENERAL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:58:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:58:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 04/15/2002 18:19:58:000

Table Columns informations

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

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
Server name MALDEV8_B60
Creation Date 09/23/2002 16:08:11:000

Table Columns informations

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

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

Comments

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.

Link between PTRUSER and GOBEACC

Caller : PTRUSER
Called : GOBEACC

Join Information

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

Link List

Link Type Link Project
Join Link Between PTRUSER and GOBEACC GENERAL

Link Between PTRUSER and GOBEACC

Caller : PTRUSER
Called : GOBEACC
Link Type : Join
Link : Link Between PTRUSER and GOBEACC

Foreign Key information

Table name Table Column Name Foreign Key Column Name On Table Cardinalities
PTRUSER PTRUSER_CODE GOBEACC_USERNAME GOBEACC (0,1)-(0,1)

Comments

Link between PSRECLS and PTRUSER

Caller : PSRECLS
Called : PTRUSER

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between PSRECLS and PTRUSER PAYROLL

Link Foreign Key Between PSRECLS and PTRUSER

Caller : PSRECLS
Called : PTRUSER
Link Type : Refer(No Action )
Link : Link Foreign Key Between PSRECLS and PTRUSER

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)

Comments

Link between PSRORGN and PTRUSER

Caller : PSRORGN
Called : PTRUSER

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between PSRORGN and PTRUSER PAYROLL

Link Foreign Key Between PSRORGN and PTRUSER

Caller : PSRORGN
Called : PTRUSER
Link Type : Refer(No Action )
Link : Link Foreign Key Between PSRORGN and PTRUSER

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)

Comments

Link between PSREMPR and PTRUSER

Caller : PSREMPR
Called : PTRUSER

Link List

Link Type Link Project
Refer(No Action ) Link Foreign Key Between PSREMPR and PTRUSER PAYROLL

Link Foreign Key Between PSREMPR and PTRUSER

Caller : PSREMPR
Called : PTRUSER
Link Type : Refer(No Action )
Link : Link Foreign Key Between PSREMPR and PTRUSER

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)

Comments