SCRTY_GBPRMT2VW (SQL View)	Index Back
SCRTY GB Prompt for Groups prompts for permissable groups (as per GB security content registration and content of table SCRTY_GBRES_TBL). Used in Security By Permission List as prompt table.

SCRTY_GBPRMT2VW

(SQL View)

SCRTY GB Prompt for Groups

prompts for permissable groups (as per GB security content registration and content of table SCRTY_GBRES_TBL). Used in Security By Permission List as prompt table.

SELECT C.GB_GROUP_ID , C.EFF_STATUS , C.DESCR FROM PS_GB_GROUP_TBL C WHERE C.EFFDT = ( SELECT MAX(SUB.EFFDT) FROM PS_GB_GROUP_TBL SUB WHERE C.GB_GROUP_ID = SUB.GB_GROUP_ID AND SUB.EFFDT <= %CurrentDateIn)

Related Language Record: SCRTY_GBPRMT2LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
2	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description