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 |