FIELDNAMEE=Edit
TL=Translate Long
TS=Translate Short
Y=Yes/No
D=Display Only with Y
R=Role Controlled
Y=Yes/No
Default Value: Y
PV_WSRULE_SETUP(SQL Table) |
Index Back |
|---|---|
Weighted Sort Rule Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 3 | PV_WSR_DISP_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Display Format
E=Edit TL=Translate Long TS=Translate Short Y=Yes/No |
| 4 | PV_DISPCONTROL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Control Flag
D=Display Only with Y R=Role Controlled Y=Yes/No Default Value: Y |
| 5 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source Recname |