AV_MBR_DTL_VW

(SQL View)
 Index Back

Member Dtl View

Contains all Mbr Detail records. ----------------------------------------------------------------------------------------------------------------- Code change 25 July 2000 (for SetId/Business Unit functionality) - old code follows: SELECT INSTITUTION, SESSION_NO, MBR_PMT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, DUES_AMT, CURRENCY_CD, AV_DUES_PERIOD, AV_TTL_AMT, FISCAL_YEAR, DATA_ENTRY_DT, TENDER_TYPE, CHECK_NO, CREDIT_CARD_NO, CREDIT_CARD_HOLDER, CREDIT_CARD_TYPE, CREDIT_CARD_EXP_DT, TENDER_TYPE_NOTE, SEQ_NO, ADJUSTMENT_FLG, CHARITABLE_AMT, MOTIVATION_CD, AV_MBR_ORG_COD, AV_DUES_LVL, EXPIRATION_DT, AV_MBR_STATUS, START_DT, GIFT_NO, AV_TTL_AMT_ENTRY, CURRENCY_CD_ENTRY, CHARITAB_AMT_ENTRY, RATE_MULT, RATE_DIV, AV_COMP_CHK FROM PS_AV_MBR_DTL -----------------------------------------------------------------------------------------------------------------

SELECT BUSINESS_UNIT, SESSION_NO, MBR_PMT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, DUES_AMT, CURRENCY_CD, AV_DUES_PERIOD, AV_TTL_AMT, FISCAL_YEAR, DATA_ENTRY_DT, TENDER_TYPE, CHECK_NO, CREDIT_CARD_NO, CREDIT_CARD_HOLDER, CREDIT_CARD_TYPE, CREDIT_CARD_EXP_DT, TENDER_TYPE_NOTE, SEQ_NO, ADJUSTMENT_FLG, CHARITABLE_AMT, MOTIVATION_CD, AV_MBR_ORG_COD, AV_DUES_LVL, EXPIRATION_DT, AV_MBR_STATUS, START_DT, GIFT_NO, AV_TTL_AMT_ENTRY, CURRENCY_CD_ENTRY, CHARITAB_AMT_ENTRY, RATE_MULT, RATE_DIV, AV_COMP_CHK, INSTITUTION FROM PS_AV_MBR_DTL

  • Parent record: AV_SESSION_TBL

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

    Prompt Table: AV_INST_BU_VW

    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESSION_TBL

    3 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: AV_EXT_ORG_SRCH

    6 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

    7 DUES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Dues Amt
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 AV_DUES_PERIOD Number(2,0) SMALLINT NOT NULL Dues Periods
    10 AV_TTL_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Amt
    11 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    12 DATA_ENTRY_DT Date(10) DATE Data Entry Date

    Default Value: %date

    13 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type

    Prompt Table: AV_TNDR_TYPE_VW

    14 CHECK_NO Character(10) VARCHAR2(10) NOT NULL Check Number
    15 CREDIT_CARD_NO Character(20) VARCHAR2(20) NOT NULL Credit Card Number
    16 CREDIT_CARD_HOLDER Character(30) VARCHAR2(30) NOT NULL Credit Card Holder
    17 CREDIT_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL Credit Card Type
    AE=American Express
    DC=Diners' Club
    DI=Diners Club
    MC=MasterCard
    VI=VISA
    18 CREDIT_CARD_EXP_DT Date(10) DATE Expiration Date
    19 TENDER_TYPE_NOTE Character(50) VARCHAR2(50) NOT NULL Tender Type Notes
    20 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    21 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    N=No
    Y=Yes

    Default Value: N

    22 CHARITABLE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    23 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code

    Prompt Table: AV_MTVTN_MBR_VW

    24 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

    Prompt Table: AV_MBR_DUES_VW

    25 AV_DUES_LVL Character(5) VARCHAR2(5) NOT NULL Dues Level

    Prompt Table: AV_MBR_DUES_TBL

    26 EXPIRATION_DT Date(10) DATE Expiration Date
    27 AV_MBR_STATUS Character(1) VARCHAR2(1) NOT NULL Membership Status
    A=Reactivated
    L=Lapsed
    N=New
    R=Renewed

    Default Value: R

    28 START_DT Date(10) DATE Start Date

    Default Value: %date

    29 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    30 AV_TTL_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Amt
    31 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code
    32 CHARITAB_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    33 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    34 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    35 AV_COMP_CHK Character(1) VARCHAR2(1) NOT NULL Complimentary

    Y/N Table Edit

    36 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution