QS_DE_ACCESS

(SQL Table)
Index Back

Inspection Access ID's

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUQS_NONVW

2 QS_ACCESS_ID Character(8) VARCHAR2(8) NOT NULL ID used to access QS setups
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 QS_MOD_DATE DateTime(26) TIMESTAMP General modification date for record change tracking
5 QS_MOD_BY Character(30) VARCHAR2(30) NOT NULL Modified by "operator"
6 QS_ROW_COUNT Number(7,0) INTEGER NOT NULL Number of managed (child) rows

Default Value: 0

7 QS_AUTO_ACLIST Character(1) VARCHAR2(1) NOT NULL List access items upon panel launch if a %OperatorId

Y/N Table Edit

Default Value: N