AUC_FRM_SECURTY

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 AUC_FORUM_NAME Character(50) VARCHAR2(50) NOT NULL Forum Name
3 AUC_USER_TYPE Character(1) VARCHAR2(1) NOT NULL Sourcing User Type
B=Bidder
C=Customer
R=Role
U=User
V=Supplier

Default Value: R

4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
5 AUC_READ_ONLY Character(1) VARCHAR2(1) NOT NULL Read Only Permission

Y/N Table Edit

Default Value: N

6 AUC_DELETE_FLG Character(1) VARCHAR2(1) NOT NULL Delete Permission

Y/N Table Edit

Default Value: N

7 AUC_BLOCK_ACSS_FLG Character(1) VARCHAR2(1) NOT NULL Block Access

Y/N Table Edit

Default Value: N