QRY_SEC_FL_VW (SQL View)	Index Back
Query Security field defintion

QRY_SEC_FL_VW

(SQL View)

Query Security field defintion

SELECT %subrec(QRY_SEC_FLD_TBL, A) FROM PS_QRY_SEC_FLD_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BASE_RECORD Character(15) VARCHAR2(15) NOT NULL Base Record
Prompt Table: QRY_BASE_REC_VW

2 FIELDNAME0 Character(18) VARCHAR2(18) NOT NULL Name of Field
Prompt Table: QRY_B_SEC_FL_VW

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: SECQRY_USER_VW

4 RECNAME_2 Character(15) VARCHAR2(15) NOT NULL Record 2 Name
Prompt Table: SECREC_QROLE_VW

5 RECNAME_3 Character(15) VARCHAR2(15) NOT NULL Rename
Prompt Table: SECQRY_PERM_VW

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: %EDITTABLE

7 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data
Y/N Table Edit
Default Value: N

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

9 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BASE_RECORD	Character(15)	VARCHAR2(15) NOT NULL	Base Record Prompt Table: QRY_BASE_REC_VW
2	FIELDNAME0	Character(18)	VARCHAR2(18) NOT NULL	Name of Field Prompt Table: QRY_B_SEC_FL_VW
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: SECQRY_USER_VW
4	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name Prompt Table: SECREC_QROLE_VW
5	RECNAME_3	Character(15)	VARCHAR2(15) NOT NULL	Rename Prompt Table: SECQRY_PERM_VW
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: %EDITTABLE
7	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Data Y/N Table Edit Default Value: N
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.