GM_AWD_CERT

(SQL Table)
 Index Back

Award Certifications Parent

Allows the user to centrally maintain all relevant award specific certifications

  • Related Language Record: GM_AWD_CERT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CNTR_SRCH_VW

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: GM_AWARD.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    3 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJ_NONVW

    5 CERT_CODE Character(5) VARCHAR2(5) NOT NULL Certification Code

    Prompt Table: GM_CERT_TBL_VW

    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GM_ELIG_PI2_VW

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

    Default Value: %date

    9 APPROVAL_DATE Date(10) DATE Approval Date

    Default Value: %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

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

    Y/N Table Edit

    14 COMMENTS Long Character CLOB Comment
    15 EXPIRE_DT Date(10) DATE Expiration Dt