RUN_CNTLSCRTYG2

(SQL Table)
Index Back

GB based security runcontrol

refresh sercurity related groups (group build based)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

Prompt Table: SCRTY_GBRUN_VW

4 GB_REFRESH_FLG Character(1) VARCHAR2(1) NOT NULL Refresh Flag

Y/N Table Edit

Default Value: Y

5 GB_EFFDT Date(10) DATE Group As Of Date
6 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number