EX_EMP_CARD_LG4

(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 , B2.LANGUAGE_CD , B2.DESCR FROM PS_CC_CARD_DATA_EX A , PS_CC_CARD_TBL_EX B , PS_CC_CRD_TBL_LNG B2 , 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 B.SETID = B2.SETID 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 B.VENDOR_ID = B2.CREDIT_CARD_VENDOR AND B.EFFDT = B2.EFFDT AND C.EXPEND_MTHD_EDIT = 'VND' AND B.EFF_STATUS = 'A' AND C.EFF_STATUS = 'A'

  • Related Language Record for EX_EMP_CARD_VW4

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description