UD_METHOD_SQ_VW(SQL View) |
Index Back |
|---|---|
Depr Method Formula Seq View |
| select setid, ud_method_id, ud_method_seq, ud_if_then_else_sw, descr, ud_variable_type_1, ud_constant_1, ud_variable_1, ud_relational_oper, ud_calculate_oper, ud_variable_type_2, ud_constant_2, ud_variable_2, ud_result, ud_endif_sw from PS_UD_METHOD_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | UD_METHOD_ID |
Character(5) | VARCHAR2(5) NOT NULL | Method ID |
| 3 | UD_METHOD_SEQ |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | UD_IF_THEN_ELSE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Condition Indicator
A=And E=Else I=If N=None O=Or T=Then Default Value: N |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | UD_VARIABLE_TYPE_1 | Character(1) | VARCHAR2(1) NOT NULL |
Variable Or Constant 1
C=Constant V=Variable Default Value: V |
| 7 | UD_CONSTANT_1 | Number(13,4) | DECIMAL(12,4) NOT NULL | Constant 1 |
| 8 | UD_VARIABLE_1 | Character(45) | VARCHAR2(45) NOT NULL |
Variable 1
Prompt Table: UD_VARIABLE_TBL |
| 9 | UD_RELATIONAL_OPER | Character(3) | VARCHAR2(3) NOT NULL |
Relational Operator
<=Less Than <==Less Than Or Equal <>=Not Equal ==Equal >=Greater Than >==Greater Or Equal |
| 10 | UD_CALCULATE_OPER | Character(3) | VARCHAR2(3) NOT NULL |
Calculation Operator
*=Multiply +=Add -=Subtract /=Divide |
| 11 | UD_VARIABLE_TYPE_2 | Character(1) | VARCHAR2(1) NOT NULL |
Variable Or Constant 2
C=Constant V=Variable Default Value: V |
| 12 | UD_CONSTANT_2 | Number(13,4) | DECIMAL(12,4) NOT NULL | Constant 2 |
| 13 | UD_VARIABLE_2 | Character(45) | VARCHAR2(45) NOT NULL |
Variable 2
Prompt Table: UD_VARIABLE_TBL |
| 14 | UD_RESULT | Character(15) | VARCHAR2(15) NOT NULL |
Result
Prompt Table: UD_VARIABLE_VW2 |
| 15 | UD_ENDIF_SW | Character(1) | VARCHAR2(1) NOT NULL |
End IF Indicator
Y/N Table Edit Default Value: N |