| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SQL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
TL
Prompt Table:
TL_SQL_OBJECT
|
| 2 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 3 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
TL_RECFIELD_TBL
|
| 4 |
UPDATE_VALUE_SRC_L |
Character(1) |
VARCHAR2(1) NOT NULL |
Source for Operand in Expression
0=Constant
1=State Variable
2=MetaSQL
4=Another Field
5=Template
9=Subquery
Default Value: 0
|
| 5 |
LEFT_CONSTANT |
Character(35) |
VARCHAR2(35) NOT NULL |
Left Constant
|
| 6 |
LEFT_STATEVAR |
Character(35) |
VARCHAR2(35) NOT NULL |
State Variable
Prompt Table:
TL_STATE_VARS
|
| 7 |
META_SQL |
Character(30) |
VARCHAR2(30) NOT NULL |
MetaSQL
Prompt Table:
TL_META_INS_VW
|
| 8 |
META_SQL_PARM1 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 1
|
| 9 |
META_SQL_PARM2 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 2
|
| 10 |
META_SQL_PARM3 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 3
|
| 11 |
META_SQL_PARM4 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 4
|
| 12 |
META_SQL_PARM5 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 5
|
| 13 |
META_SQL_PARM6 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 6
|
| 14 |
META_SQL_PARM7 |
Character(20) |
VARCHAR2(20) NOT NULL |
MetaSQL Parameter 7
|
| 15 |
TL_MATH_OPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Math. operator
*=Multiplied By
+=Added To
-=Subtracted By
/=Divided By
0=None
Default Value: 0
|
| 16 |
LEFT_SQL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Left SQL Object ID
Prompt Table:
TL_SQL_SUBQ_VW
|
| 17 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
Prompt Table:
TL_RECFIELD_TBL
|
| 18 |
UPDATE_VALUE_SRC_R |
Character(1) |
VARCHAR2(1) NOT NULL |
Source for Operand in Expression
0=Constant
1=State Variable
4=Another Field
5=Template
9=Subquery
|
| 19 |
RIGHT_CONSTANT |
Character(35) |
VARCHAR2(35) NOT NULL |
Constant 2
|
| 20 |
RIGHT_STATEVAR |
Character(35) |
VARCHAR2(35) NOT NULL |
State Variable 2
Prompt Table:
TL_STATE_VARS
|
| 21 |
RIGHT_SQL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Right SQL Object ID
Prompt Table:
TL_SQL_SUBQ_VW
|
| 22 |
FIELDNAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname 2
Prompt Table:
TL_RECFIELD_TBL
|