OPRIDPrompt Table: RTBL_OPRDEFN_VW
Default Value: 100000
Y/N Table Edit
Default Value: Y
BT=Below Threshold
ET=Threshold Reached
YQ=Quota Reached
RTBL_USER_QUOTA(SQL Table) |
Index Back |
|---|---|
Manage User Quota |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: RTBL_OPRDEFN_VW |
| 2 | RTBL_DEF_ROWSIZE | Number(20,4) | DECIMAL(19,4) NOT NULL |
Allotted Quota (KB)
Default Value: 100000 |
| 3 | RTBL_ENFORCE | Character(1) | VARCHAR2(1) NOT NULL |
Notify User?
Y/N Table Edit Default Value: Y |
| 4 | RTBL_QUOTA | Number(20,4) | DECIMAL(19,4) NOT NULL | RTBL Quota Used (KB) |
| 5 | RTBL_QUOTA_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Quota Status
BT=Below Threshold ET=Threshold Reached YQ=Quota Reached |