GP_PKG_FM2_VW

(SQL View)
 Index Back

Formula Detail

Formula Detail

SELECT PIN_NUM + 50000000 , EFFDT , SEQ_NUM5 , FRML_FUNC_OPTN , FRML_LEFT_PAREN , ENTRY_TYPE_FRML1 , PIN_FRML_FLD1_NUM , FRML_FLD1_DAT_TYP , FRML_FLD1_DEC_VAL , FRML_FLD1_DATE_VAL , FRML_FLD1_CHAR_VAL , FRML_FLD1_ATRB_IND , PIN_RND1_NUM , FRML_FLD1_USE_OPTN , FRML_OPER1 , FRML_FLD1_OLDV_IND , ENTRY_TYPE_FRML2 , PIN_FRML_FLD2_NUM , FRML_FLD2_DAT_TYP , FRML_FLD2_DEC_VAL , FRML_FLD2_DATE_VAL , FRML_FLD2_CHAR_VAL , FRML_FLD2_ATRB_IND , PIN_RND2_NUM , FRML_FLD2_USE_OPTN , FRML_FLD2_OLDV_IND , FRML_RIGHT_PAREN , ENTRY_TYPE_FRML3 , PIN_FRML_FLD3_NUM , FRML_FLD3_DAT_TYP , FRML_FLD3_ATRB_IND , PIN_RND3_NUM , FRML_FLD3_USE_OPTN , FM_COMMENT FROM PS_GP_FORMULA_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Default Value: 99999999

2 EFFDT Date(10) DATE NOT NULL Effective Date
3 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
4 FRML_FUNC_OPTN Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
/=Comment
A=And
E=Else
F=Endif
I=If
M=Maximum()
N=Minimum()
O=Or
S=Sum()
T=Then
V=Average()
X=In()
Z=Exit
5 FRML_LEFT_PAREN Character(1) VARCHAR2(1) NOT NULL Delimiter field used to express / define a statement in a formula element.
6 ENTRY_TYPE_FRML1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_FMFLD_VW

7 PIN_FRML_FLD1_NUM Number(8,0) INTEGER NOT NULL Element number field
8 FRML_FLD1_DAT_TYP Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
B=Blank
9 FRML_FLD1_DEC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Field used in user interface for defining a formula element.
10 FRML_FLD1_DATE_VAL Date(10) DATE Field used in user interface for defining a formula element.
11 FRML_FLD1_CHAR_VAL Character(18) VARCHAR2(18) NOT NULL Field used in user interface for defining a formula element.
12 FRML_FLD1_ATRB_IND Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.

Y/N Table Edit

13 PIN_RND1_NUM Number(8,0) INTEGER NOT NULL Element number field
14 FRML_FLD1_USE_OPTN Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
N=Use Element Number
V=Use Element Value
15 FRML_OPER1 Character(2) VARCHAR2(2) NOT NULL Field used in user interface for defining a formula element.
*=Multiplied By
+=Added To
-=Subtracted From
/=Divided By
<=Is Less Than
==Equals
>=Is Greater Than
G=Is Greater Than Or Equal To
L=Is Less Than Or Equal To
^=Is Not Equal To
16 FRML_FLD1_OLDV_IND Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
N=Don't Use Old Calc Value
Y=Use Old Calc Value
17 ENTRY_TYPE_FRML2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_FMFLD_VW

18 PIN_FRML_FLD2_NUM Number(8,0) INTEGER NOT NULL Element number field
19 FRML_FLD2_DAT_TYP Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
B=Blank
20 FRML_FLD2_DEC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Field used in user interface for defining a formula element.
21 FRML_FLD2_DATE_VAL Date(10) DATE Field used in user interface for defining a formula element.
22 FRML_FLD2_CHAR_VAL Character(18) VARCHAR2(18) NOT NULL Field used in user interface for defining a formula element.
23 FRML_FLD2_ATRB_IND Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.

Y/N Table Edit

24 PIN_RND2_NUM Number(8,0) INTEGER NOT NULL Element number field
25 FRML_FLD2_USE_OPTN Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
N=Use Element Number
V=Use Element Value
26 FRML_FLD2_OLDV_IND Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
N=Don't Use Old Value
Y=Use Old Calc Value
27 FRML_RIGHT_PAREN Character(1) VARCHAR2(1) NOT NULL Delimiter field used to express / define a statement in a formula element.
28 ENTRY_TYPE_FRML3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_FMFL3_VW

29 PIN_FRML_FLD3_NUM Number(8,0) INTEGER NOT NULL Element number field
30 FRML_FLD3_DAT_TYP Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
B=Blank
31 FRML_FLD3_ATRB_IND Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.

Y/N Table Edit

32 PIN_RND3_NUM Number(8,0) INTEGER NOT NULL Element number field
33 FRML_FLD3_USE_OPTN Character(1) VARCHAR2(1) NOT NULL Field used in user interface for defining a formula element.
N=Use Element Number
V=Use Element Value
34 FM_COMMENT Character(254) VARCHAR2(254) NOT NULL Formula Comment