| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RULE_TYPE_ER |
Character(1) |
VARCHAR2(1) NOT NULL |
ERP Rule Type
A=Award Category
E=Employee Eligibility
H=Hot Job
|
| 2 |
RULE_ID_ER |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule ID
|
| 3 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 4 |
WHERE_BOOLEAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Boolean for rules
AND=AND
OR=OR
Default Value: AND
|
| 5 |
WHERE_LEFT_PAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Left Parentheses for rules
0=
1=(
2=((
3=(((
4=((((
5=(((((
Default Value: 0
|
| 6 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
%EDITTABLE2
|
| 7 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
%EDITTABLE
|
| 8 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
Default Value: 0
|
| 9 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 10 |
WHERE_OPERATOR |
Character(4) |
VARCHAR2(4) NOT NULL |
SQL operator for rules.
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
LIKE=LIKE
Default Value: =
|
| 11 |
WHERE_VALUE |
Character(50) |
VARCHAR2(50) NOT NULL |
Value for rule selection criteria.
Prompt Table:
%ER_VALUE_EDIT
|
| 12 |
WHERE_VALUE_DT |
Date(10) |
DATE |
Value
|
| 13 |
WHERE_VALUE_NBR |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
Value
|
| 14 |
WHERE_RIGHT_PAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Right parentheses for rule selection criteria.
0=
1=)
2=))
3=)))
4=))))
5=)))))
Default Value: 0
|
| 15 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
SAL_PLAN_TBL
|
| 16 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 17 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 18 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 19 |
ROW_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Row Number
|
| 20 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 21 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 22 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 23 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|