AE_GBSCRTY_AET

(SQL Table)
Index Back

Group Member List AET (SCRTY)

AET record used to create group build and matrix team related group definitions for security.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
5 GB_EFFDT Date(10) DATE Group As Of Date
6 MXGB_REFINE_DATE Date(10) DATE Row Level Security by Matrix Refinement Date
7 GB_REFRESH_FLG Character(1) VARCHAR2(1) NOT NULL Refresh Flag

Default Value: Y

8 UPDATE_SEC_GB Character(1) VARCHAR2(1) NOT NULL Refresh All
9 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
10 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive