GM_PROP_CERT

(SQL Table)
 Index Back

Proposal Certifications

This record allows the user to certify proposal-specific certifications, and store the date certified, comments, and the professional who is making the certification. Multiple certifications can be made per a proposal on this panel. This record is stored in GR_01_03_0100.

  • Related Language Record: GM_PROP_CRT_LNG

  • Parent record: GM_PROPOSAL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID

    Prompt Table: GM_PROP_ID_VW

    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID

    Prompt Table: GM_PROPOSAL

    4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    5 CERT_CODE Character(5) VARCHAR2(5) NOT NULL Certification Code

    Prompt Table: GM_CERT_TBL_VW2

    6 CERT_DT Date(10) DATE Certification Date
    7 COMPLNC_INDICATOR Character(3) VARCHAR2(3) NOT NULL Indicator
    NA=Not Applicable
    NO=No
    PD=Pending Approval
    YS=Yes
    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_DATA_EFFDT

    9 APPROVAL_DATE Date(10) DATE Approval Date
    10 ASSURANCE_NBR Character(20) VARCHAR2(20) NOT NULL Assurance Number
    11 EXEMPTION_NBR Character(20) VARCHAR2(20) NOT NULL Exemption Number
    12 FULL_REVIEW Character(1) VARCHAR2(1) NOT NULL Full Review

    Y/N Table Edit

    Default Value: N

    13 EXPEDITED_REVIEW Character(1) VARCHAR2(1) NOT NULL Expedited Review

    Y/N Table Edit

    Default Value: N

    14 CHG_SINCE_PREV_SUB Character(1) VARCHAR2(1) NOT NULL Chg Since Prev Sub

    Y/N Table Edit

    Default Value: N

    15 PREVIOUS_REPORTED Character(1) VARCHAR2(1) NOT NULL Previously Reported

    Y/N Table Edit

    Default Value: N

    16 COMMENTS Long Character CLOB Comment
    17 EXPIRE_DT Date(10) DATE Expiration Dt