GLRN_USR_WKBNCH

(SQL Table)
Index Back

Security - Workbench

Security - Access Configuration by User Functions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: PSOPRDEFN_VW

2 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
A=Active
I=Inactive

Default Value: A

3 SELECT_CHKBOX1 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes

Y/N Table Edit

4 SELECT_CHKBOX2 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes

Y/N Table Edit

5 SELECT_CHKBOX3 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes

Y/N Table Edit

6 SELECT_CHKBOX4 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes

Y/N Table Edit

7 SELECT_CHKBOX5 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes

Y/N Table Edit

8 SELECT_CHKBOX6 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page
N=No
Y=Yes

Y/N Table Edit

9 SELECT_CHKBOX7 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page

Y/N Table Edit

10 SELECT_CHKBOX8 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page

Y/N Table Edit

11 SELECT_CHKBOX9 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page

Y/N Table Edit

12 SELECT_CHKBOX10 Character(1) VARCHAR2(1) NOT NULL Check Box for Site Selected on comparison Matrix Page

Y/N Table Edit