GPSC_ELM_FM_DTL

(SQL View)
 Index Back

Formula Detail

Formula Detail

SELECT PIN_NUM ,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 WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM ,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_GPSC_RM_FM_DTL WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

  • Parent record: GP_FORMULA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    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

    Prompt Table: %GP_EDIT_FLD1

    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

    Prompt Table: GP_PIN_RR0_VW

    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

    Prompt Table: %GP_EDIT_FLD2

    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

    Prompt Table: GP_PIN_RR0_VW

    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

    Prompt Table: %GP_EDIT_FLD3

    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

    Prompt Table: GP_PIN_RR0_VW

    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