| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRRFW_DSO_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Data Object ID
|
| 2 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 5 |
HRRFW_LOGICAL_OPR |
Character(3) |
VARCHAR2(3) NOT NULL |
Logical Operator
0=OR
A=AND
|
| 6 |
HRRFW_ENTRY_TYPE1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type
REC=Record/Field
VAR=Variable
|
| 7 |
HRRFW_LPAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Left Parenthesis
Y/N Table Edit
Default Value: N
|
| 8 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 1 Name
Prompt Table:
HR_RFW_RNAME_VW
|
| 9 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
Prompt Table:
HR_RFW_RFD1_VW
|
| 10 |
HRRFW_VARNAME1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Variable Name
Prompt Table:
HR_RFW_VARAL_VW
|
| 11 |
HRRFW_SYSVAR1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Variable Name
Prompt Table:
HR_RFW_SYS_VW
|
| 12 |
HRRFW_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Operator
EQ=Equal
GE=Greater or Equal
GT=Greater Then
IN=In
LQ=Less or Equal
LT=Less Then
NE=Not Equal
|
| 13 |
HRRFW_ENTRY_TYPE2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Entry Type
REC=Record/Field
VAR=Variable
|
| 14 |
RECNAME_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 2 Name
Prompt Table:
HR_RFW_RNAME_VW
|
| 15 |
FIELDNAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 2
Prompt Table:
HR_RFW_RFD2_VW
|
| 16 |
HRRFW_VARNAME2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Variable Name
Prompt Table:
HR_RFW_VARAL_VW
|
| 17 |
HRRFW_SYSVAR2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Variable Name
Prompt Table:
HR_RFW_SYS_VW
|
| 18 |
HRRFW_RPAREN |
Character(1) |
VARCHAR2(1) NOT NULL |
Right Parenthesis
Y/N Table Edit
Default Value: N
|