Penn Computing

University of Pennsylvania
Penn Computing << go backback
PS_UP_PLG_SCHD_DTL Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_UP_PLG_SCHD_DTL Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

  • PLEDGE_NO
  • SEQ_NUMBER
  • EXPECT_DT
  • FISCAL_YEAR
  • EXPECT_AMT
  • CURRENCY_CD

  • Data element Definition
    PLEDGE_NO


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Atlas gift_no for the pledge.
    SEQ_NUMBER


    Indexed - Yes
    Format - NUMBER
    Nullable - N
    Sequence number of the schedule data. Highest sequence is the most recent and valid data.
    EXPECT_DT


    Indexed - Yes
    Format - DATE
    Nullable - N
    Data of expected payment
    FISCAL_YEAR


    Indexed - No
    Format - NUMBER
    Nullable - N
    Fiscal year during which payment is due
    EXPECT_AMT


    Indexed - No
    Format - NUMBER
    Nullable - N
    Amount of expected payment
    CURRENCY_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    US Dollars
    PS_UP_PLG_SCHD_DTL Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

    Questions about this page? Email us at da-staff@isc.upenn.edu

    Information Systems and Computing
    University of Pennsylvania
    Information Systems and Computing, University of Pennsylvania