CERTIFICATE

(SQL Table)
 Index Back

Certificate Definition

CERTIFICATE is a record that defines the format and structure of a Certificate that may be enabled for use in one of several points in Base Benefits.

  • Related Language Record: CERTIFICATE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CERTIFICATE_ID Character(10) VARCHAR2(10) NOT NULL The CERTIFICATE_ID is the unique identifier for a Certificate definition.
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 CERTIF_INSTR_TEXT Character(254) VARCHAR2(254) NOT NULL The CERTIF_INSTR_TEXT string specifies the text value to be presented on the Certificate page that describes the desired actions and results.
    7 CERTIF_CALC_CD Character(1) VARCHAR2(1) NOT NULL The CERTIF_CALC_CD specifies the method for appling a weighting calculation to the Certificate evaluation.
    M=Multiply
    N=None

    Default Value: N

    8 CERTIF_AGRMT_TYPE Character(2) VARCHAR2(2) NOT NULL The CERTIF_AGRMT_TYPE code specifies the presentation format of the agreement section of the Certificate UE.
    AC=Accept / Decline
    AG=Agree / Disagree
    NA=Not Applicable
    9 CERTIF_AGRMT_TEXT Character(100) VARCHAR2(100) NOT NULL The CERTIF_AGRMT_TEXT string specifies the text value to be presented on the Certificate page that requires a User acknowledgement or agreement/disagreement.
    10 CERTIF_VALUE Number(6,0) INTEGER NOT NULL The CERTIF_VALUE specifies the value calculated as the final value of a Certificate completed by the User.
    11 CERTIF_MAX_VALUE Number(6,0) INTEGER NOT NULL Certificate Maximum Value