Penn Computing

University of Pennsylvania
Penn Computing << go backback

PS_AV_SESSION_TBL
   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_AV_SESSION_TBL Table - Data Element Index

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

  • BUSINESS_UNIT
  • SESSION_NO
  • AV_SESS_TYPE
  • SESS_STATUS
  • OPRID
  • BAL_DT
  • AV_POST_DT
  • ACTL_TTL_AMT
  • ACTL_TTL_CNT
  • ORIG_OPRID
  • LAST_MOD_DT
  • AV_OPEN_DT
  • EXPECT_FLG
  • GL_POST_DT
  • SPSNS_REASON
  • ACKN_FLG
  • GC_FLG
  • CURRENCY_CD
  • ACTL_TTL_AMT_ENTRY
  • CURRENCY_CD_ENTRY
  • INSTITUTION
  • AV_ACCUM_FLG
  • AV_SS_FLG
  • UP_DEP_ID_TYPE
  • UP_BEN_DEPOSIT
  • UP_DEPOSIT_DATE
  • UP_ORIGINAL_MODE
  •  


    Data element Definition
    BUSINESS_UNIT


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    This is the business unit code of the department that entrered the gift -- most often UPENN.
    SESSION_NO


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    Number that identifies gift batch entering session. Uses as part of unique key to identify a specific gift transaction.
    AV_SESS_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Type of gift entry session (for ex. 'PL' = a pledge gift entry session).
    SESS_STATUS


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N
    State of the gift session. All sessions in the warehouse are posted -- status P.
    OPRID


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Id of the user who created the gift or pledge session.
    BAL_DT


    Indexed - No
    Format - DATE
    Nullable - Y
    Date the operator balanced the session.
    AV_POST_DT


    Indexed - Yes
    Format - DATE
    Nullable - Y
    Date the gift/pledge transaction is posted to the General Ledger. Used as selection criteria in daily gifts reports.
    ACTL_TTL_AMT


    Indexed - No
    Format - NUMBER
    Nullable - N
    Actual dollar total for gift or pledge session.
    ACTL_TTL_CNT


    Indexed - No
    Format - NUMBER
    Nullable - N
    Actual count of gifts or pledges in session.
    ORIG_OPRID


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    not used
    LAST_MOD_DT


    Indexed - No
    Format - DATE
    Nullable - Y
    Date session updated
    AV_OPEN_DT


    Indexed - No
    Format - DATE
    Nullable - Y
    Date session created
    EXPECT_FLG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not used
    GL_POST_DT


    Indexed - No
    Format - DATE
    Nullable - Y
    Date the gift/pledge transaction is posted to the General Ledger. Used as selection criteria in daily gifts reports.
    SPSNS_REASON


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Reason session suspended. This is used by gifts processors to clear suspended sessions.
    ACKN_FLG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not used.
    GC_FLG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not used.
    CURRENCY_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Country code for currency (most often USD)
    ACTL_TTL_AMT_ENTRY


    Indexed - No
    Format - NUMBER
    Nullable - N
    Actual dollar total of session.
    CURRENCY_CD_ENTRY


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Country code for currency (most often USD)
    INSTITUTION


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Always UPENN
    AV_ACCUM_FLG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Indicator of whether the session has been included in the giving profile calculations.
    AV_SS_FLG


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Not used.
    UP_DEP_ID_TYPE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    From the session table, this field indicates the method of deposit of funds to Penn's accounts.
    UP_BEN_DEPOSIT


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    this is the deposit number of a particular deposit. Due to the implementation of remote deposit capture at Penn, this field is not of great value.
    UP_DEPOSIT_DATE


    Indexed - No
    Format - DATE
    Nullable - Y
    Date of deposit of funds to Penn's bank.
    UP_ORIGINAL_MODE


    Indexed - No
    Format - VARCHAR2
    Nullable - N
    Equivalent to old "Original Mode Code": Includes coded values for Online Gifts ("O"), Lockbox ("L"), etc.

    PS_AV_SESSION_TBL
       Tables and Data Elements   General Ledger 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