RULE_IDDefault Value: NEXT
FIELDNAMEPrompt Table: PV_WS_FIELDS_VW
VALUEPrompt Table: %EDITTABLE
Y/N Table Edit
Default Value: N
PV_WSRULE_LINE(SQL Table) |
Index Back |
|---|---|
Weighted Sort Rule Line |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Weighted Sort Rule ID
Default Value: NEXT |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PV_WS_FIELDS_VW |
| 3 | VALUE |
Character(254) | VARCHAR2(254) NOT NULL |
Value
Prompt Table: %EDITTABLE |
| 4 | PV_WS_VISIBLE_SR | Character(1) | VARCHAR2(1) NOT NULL |
Show on results row
Y/N Table Edit Default Value: N |
| 5 | PV_WSR_WEIGHT | Number(2,0) | SMALLINT NOT NULL | Weight (0-10) |