VC_GSECOPT_TBL

(SQL Table)
Index Back

Group Tree Default flag

Variable Comp: this record stores the default flag for each group according to the tree.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
2 TREE_EFFDT Date(10) DATE Effective date of the Tree
3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
4 GB_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

Prompt Table: PSOPRDEFN

5 VC_DFLT_SECU_FLG Character(1) VARCHAR2(1) NOT NULL Default Security