QRY_SEC_CNF_TBL (SQL Table)	Index Back
Query Security field defintion Query Security child field defintion

QRY_SEC_CNF_TBL

(SQL Table)

Query Security field defintion

Query Security child field defintion

# 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 SELECTED_CB Character(1) VARCHAR2(1) NOT NULL Row Selected Checkbox
N=Not Selected
Y=Selected
Y/N Table Edit
Default Value: N

4 SEC_APPLIED Character(1) VARCHAR2(1) NOT NULL Security Applied
N=No
Y=Yes
Y/N Table Edit
Default Value: N

5 FIELD_EXISTS Character(1) VARCHAR2(1) NOT NULL Field Exists
Default Value: Y

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

7 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	SELECTED_CB	Character(1)	VARCHAR2(1) NOT NULL	Row Selected Checkbox N=Not Selected Y=Selected Y/N Table Edit Default Value: N
4	SEC_APPLIED	Character(1)	VARCHAR2(1) NOT NULL	Security Applied N=No Y=Yes Y/N Table Edit Default Value: N
5	FIELD_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Field Exists Default Value: Y
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	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.