OPRIDPrompt Table: PSOPRDEFN
Default Value: 90
Default Value: 90
Default Value: 90
APP=Approval Date
END=End Date
LTTL=Line Total
MOD=Modify Date
STRT=Start Date
Default Value: MOD
SP_DB_USER_PREF(SQL Table) |
Index Back |
|---|---|
SP Portal User Preferences11/16/2001 Key field: OPRID; all other fields define the preferences that control what is to be displayed on the portal pagelets. |
| # | 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: PSOPRDEFN |
| 2 | SP_SS_DAY_RANGE | Number(2,0) | SMALLINT NOT NULL |
11/16/2001
Number of days the range should include for Supplier Submittals. Used to define user preferences for Services Procurement portal pages.
Default Value: 90 |
| 3 | SP_SS_STATUS_RANGE | Character(50) | VARCHAR2(50) NOT NULL | 11/16/2001 Status to use for Supplier Submittals (used to narrow down the records). Used to define user preferences for Services Procurement portal pages. |
| 4 | SP_SB_DAY_RANGE | Number(2,0) | SMALLINT NOT NULL |
11/16/2001
Number of days the range should include for Supplier Breakdown. Used to define user preferences for Services Procurement portal pages.
Default Value: 90 |
| 5 | SP_SB_STATUS_RANGE | Character(50) | VARCHAR2(50) NOT NULL | 11/16/2001 Status to use for Supplier Breakdown (used to narrow down the records). Used to define user preferences for Services Procurement portal pages. |
| 6 | SP_RR_DAY_RANGE | Number(2,0) | SMALLINT NOT NULL |
11/16/2001
Number of days the range should include for Recent Requirements. Used to define user preferences for Services Procurement portal pages.
Default Value: 90 |
| 7 | SP_RR_STATUS_RANGE | Character(50) | VARCHAR2(50) NOT NULL | 11/16/2001 Status to use for Recent Requirement (used to narrow down the records). Used to define user preferences for Services Procurement portal pages. |
| 8 | SP_RR_SORT_BY | Character(4) | VARCHAR2(4) NOT NULL |
11/16/2001
Allows the user to define the sort order for service requisitions. Used to define user preferences for Services Procurement portal pages.
APP=Approval Date END=End Date LTTL=Line Total MOD=Modify Date STRT=Start Date Default Value: MOD |