QRY_SEC_CHD_TBL

(SQL Table)
Index Back

Query Security 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 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

Prompt Table: QRY_B_SEC_FL_VW

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: %EDITTABLE

5 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data

Y/N Table Edit

Default Value: N

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.