EX_EMP_CARD_VW4

(SQL View)
 Index Back

Credit Card Data

Used to populate user credit card values. Keyed by the CC masked number.

SELECT A.EMPLID , C.EXPEND_MTHD , D.CRDMEM_ACCT_MSK , A.CREDIT_CARD_VENDOR , B.DESCR , A.EXPIRATION_DT , A.CRDMEM_ACCT_NBR FROM PS_CC_CARD_DATA_EX A , PS_CC_CARD_TBL_EX B , PS_CC_CARD_MSK D , PS_EX_EXP_MTHD_TBL C WHERE A.CREDIT_CARD_VENDOR = B.CREDIT_CARD_VENDOR AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'CC_CARD_TBL_EX') AND A.CRDMEM_ACCT_NBR = D.CRDMEM_ACCT_NBR AND C.SETID = ( SELECT E.SETID FROM PS_SET_CNTRL_REC E WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME = 'EX_EXP_MTHD_TBL') AND B.VENDOR_SETID = C.VENDOR_SETID AND B.VENDOR_ID = C.VENDOR_ID AND C.EXPEND_MTHD_EDIT = 'VND' AND B.EFF_STATUS = 'A' AND C.EFF_STATUS = 'A'

  • Related Language Record: EX_EMP_CARD_LG4

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
    3 CRDMEM_ACCT_MSK Character(20) VARCHAR2(20) NOT NULL Cardmember Number
    4 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 EXPIRATION_DT Date(10) DATE Expiration Date
    7 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number