| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
RECDEFN_VW
|
| 2 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFLD_LABEL_VW
|
| 3 |
ORDERNO |
Number(5,0) |
INTEGER NOT NULL |
Sort Order
|
| 4 |
SELECTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selected Flag
N=Not Selected
Y=Seleted
Y/N Table Edit
Default Value: N
|
| 5 |
FO_SC_CRIT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines the name of the field criteria that will show up in the search criteria.
|
| 6 |
FO_SC_EDIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines editing validation method.
Used in Search Criteria.
N=No Table Edit
P=Prompt Table Edit
T=Translate Table Edit
Y=Yes/No
Default Value: N
|
| 7 |
FO_SC_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Mass Change Comparison Operator. Can assume the following values:
=, >, >=, <, <=, Between, In, Is Blank, Is not Blank, Not =, Not in, Begins With, Contains.
BL=Is Blank
BT=Between
BW=Begins With
CN=Contains
EQ=Equal To
GE=Greater Than or Equal To
GT=Greater Than
IN=In
LE=Less Than or Equal To
LT=Less Than
NB=Is not Blank
NE=Not Equal To
NI=Not In
Default Value: EQ
|
| 8 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
RECDEFN_VW
|
| 9 |
FO_SC_BLD_IN_LIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Build In List Flag.
Used in Search Criteria.
Y/N Table Edit
Default Value: N
|
| 10 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 11 |
DECIMAL_POS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Position
|
| 12 |
PARENTFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| 13 |
BASE_RECORD |
Character(15) |
VARCHAR2(15) NOT NULL |
Base Record
Prompt Table:
FO_SC_SRC_RCDS
|
| 14 |
FO_SC_STR_VALUE |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for String Values.
|
| 15 |
FO_SC_STR_VALUE_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for string values in range.
|
| 16 |
FO_SC_STR_NPVAL |
Character(60) |
VARCHAR2(60) NOT NULL |
Prompted (No Edit) String Value.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 17 |
FO_SC_STR_NPVAL_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Prompted (No Edit) String Value.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 18 |
FO_SC_STR_PVALUE |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for String Values.
Prompt Table:
%EDITTABLE
|
| 19 |
FO_SC_STR_PVAL_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for string values in range.
Prompt Table:
%EDITTABLE
|
| 20 |
FO_SC_STR_MIXED |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for String Values.
|
| 21 |
FO_SC_STR_MIX_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for string values in range.
|
| 22 |
FO_SC_STR_NPMIX |
Character(60) |
VARCHAR2(60) NOT NULL |
Prompted (No Edit) String Value.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 23 |
FO_SC_STR_NPMIX_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Prompted (No Edit) String Value.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 24 |
FO_SC_STR_PMIXED |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for String Values.
Prompt Table:
%EDITTABLE
|
| 25 |
FO_SC_STR_PMIX_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for string values in range.
Prompt Table:
%EDITTABLE
|
| 26 |
FO_SC_STR_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for Names.
|
| 27 |
FO_SC_STR_NAME_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for Names in range.
|
| 28 |
FO_SC_STR_NPNAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Prompted (No Edit) Name.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 29 |
FO_SC_STR_NPNAM_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Prompted (No Edit) Name.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 30 |
FO_SC_STR_PNAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for Names.
Prompt Table:
%EDITTABLE
|
| 31 |
FO_SC_STR_PNAME_TO |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for Names in range.
Prompt Table:
%EDITTABLE
|
| 32 |
FO_SC_XLAT_VALUE |
Character(4) |
VARCHAR2(4) NOT NULL |
Used in Search Criteria for string values presented as ComboBox/DropDown list fields.
D=Dummy
|
| 33 |
FO_SC_IN_LIST |
Character(60) |
VARCHAR2(60) NOT NULL |
Used in Search Criteria for a List of String Values.
|
| 34 |
FO_SC_NUM_VALUE |
Signed Number(32,10) |
DECIMAL(30,10) NOT NULL |
Used in Search Criteria for numeric values.
|
| 35 |
FO_SC_NUM_VALUE_TO |
Signed Number(32,10) |
DECIMAL(30,10) NOT NULL |
Used in Search Criteria for Numeric values in range.
|
| 36 |
FO_SC_NUM_NPVAL |
Signed Number(32,10) |
DECIMAL(30,10) NOT NULL |
Prompted (No Edit) Numeric Value.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 37 |
FO_SC_NUM_NPVAL_TO |
Signed Number(32,10) |
DECIMAL(30,10) NOT NULL |
Prompted (No Edit) Numeric Value.
Used in Staffing Search Criteria.
Prompt Table:
%EDITTABLE
|
| 38 |
FO_SC_NUM_PVALUE |
Signed Number(32,10) |
DECIMAL(30,10) NOT NULL |
Used in Search Criteria for numeric values.
Prompt Table:
%EDITTABLE
|
| 39 |
FO_SC_NUM_PVAL_TO |
Signed Number(32,10) |
DECIMAL(30,10) NOT NULL |
Used in Search Criteria for numeric values in range.
Prompt Table:
%EDITTABLE
|
| 40 |
FO_SC_DTTM_VALUE |
DateTime(26) |
TIMESTAMP |
Used in Search Criteria for DateTime values.
|
| 41 |
FO_SC_DTTM_VAL_TO |
DateTime(26) |
TIMESTAMP |
Used in Search Criteria for DateTime values.
|
| 42 |
FO_SC_DATE_VALUE |
Date(10) |
DATE |
Used in Search Criteria for Date values.
|
| 43 |
FO_SC_DATE_VAL_TO |
Date(10) |
DATE |
Used in Search Criteria for Date values.
|
| 44 |
FO_SC_TIME_VALUE |
Time(15) |
TIMESTAMP |
Used in Search Criteria for Time values.
|
| 45 |
FO_SC_TIME_VAL_TO |
Time(15) |
TIMESTAMP |
Used in Search Criteria for Time values.
|