AUDIT_CNTRL_VW

(SQL View)
Index Back

Audit Scroll view


SELECT SETID , FIELDNAME , FIELDNAME , FIELDNAME , INCLUDE_FLG , INCLUDE_FLG , INCLUDE_FLG FROM PS_AUDIT_CNTRL_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
3 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2
4 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Field Name
5 SELECT1 Character(1) VARCHAR2(1) NOT NULL select1

Y/N Table Edit

6 SELECT2 Character(1) VARCHAR2(1) NOT NULL select2

Y/N Table Edit

7 SELECT3 Character(1) VARCHAR2(1) NOT NULL select3

Y/N Table Edit