GM_AWD_CERT_VW

(SQL View)
 Index Back

Award Certification view

Grants Award Certifications Pivot grid view

SELECT PREF.OPRID , CERT.BUSINESS_UNIT , CERT.CONTRACT_NUM , PREF.TITLE56 , PREF.NAME1 , PREF.NAME , CERT.BUSINESS_UNIT_PC , CERT.PROJECT_ID , CERT.CERT_CODE , CERT.CERT_DT , CERT.EXPIRE_DT , CASE WHEN (CERT.EXPIRE_DT < %CurrentDateIn) THEN '0' WHEN (%DateDiff(%CurrentDateIn,CERT.EXPIRE_DT)<=30 AND %DateDiff(%CurrentDateIn,CERT.EXPIRE_DT) >=0) THEN '1' WHEN (%DateDiff(%CurrentDateIn,CERT.EXPIRE_DT)<=60 AND %DateDiff(%CurrentDateIn,CERT.EXPIRE_DT) >=31) THEN '2' WHEN (%DateDiff(%CurrentDateIn,CERT.EXPIRE_DT)<=90 AND %DateDiff(%CurrentDateIn,CERT.EXPIRE_DT) >=61) THEN '3' END FROM PS_GM_AWD_CERT CERT , PS_GM_PREF_AWD_VW PREF WHERE CERT.CONTRACT_NUM= PREF.CONTRACT_NUM AND EXPIRE_DT <= (%DateAdd(%CurrentDateIn,90))

  • Related Language Record: GM_PREF_AWD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID
    4 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    8 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    9 CERT_CODE Character(5) VARCHAR2(5) NOT NULL Certification Code
    10 CERT_DT Date(10) DATE Certification Date
    11 EXPIRE_DT Date(10) DATE Expiration Date
    12 GM_DUE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Due Indicator
    0=Overdue
    1=0-30
    2=31-60
    3=61-90