CC_EMPL_CARD_VW

(SQL View)
Index Back

ProCard Employee with Cards


SELECT A.EMPLID , A.CREDIT_CARD_VENDOR , A.CRDMEM_ACCT_NBR , B.NAME , A.BUSINESS_UNIT , C.SETID , 'N' FROM PS_CC_CARD_DATA_EX A , PS_PERSONAL_DATA B , PS_SET_CNTRL_TBL C WHERE %Join(COMMON_KEYS, CC_CARD_DATA_EX A, PERSONAL_DATA B) AND A.BUSINESS_UNIT = C.SETCNTRLVALUE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

2 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
3 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDIT_BU_PO

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
N=Not Selected
Y=Seleted

Y/N Table Edit