GP_FORMULA

(SQL Table)
Index Back

Formula Definition

Formula Definition

  • Parent Record Of GPSC_ELM_FM_DTL GPSC_RM_FM_DTL GP_FORMULA_DTL GP_PKG_FM2_AD
  • # 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

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 FRML_VALIDATED_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicates whether a formula has been successfully "validated"...which means the ui data in GP FORMULA DTL has been converted into processable data in the GP FORMULA CLUE and GP FORMULA VAR tables

    Y/N Table Edit

    Default Value: N

    5 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.