CC_CARD_ROLE_E1(SQL View) |
Index Back |
|---|---|
ProCard Copy/Move Exceptions |
| SELECT A.EMPLID , A.CREDIT_CARD_VENDOR , A.CRDMEM_ACCT_NBR , A.OPRID , A.ROLENAME , ' ' , ' ' FROM PS_CC_CARD_ROLE A WHERE 1 <> 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: CC_EMPL_ID_VW |
| 2 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL |
Corporate Card Vendor
Prompt Table:
CC_EMPL_CCV_VW
|
| 3 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL |
Cardmember Number
Prompt Table:
CC_CARD_DATA_EX
|
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 5 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: CC_ROLE_DESC_VW |
| 6 | ROLENAME_TO | Character(30) | VARCHAR2(30) NOT NULL | Target Role |
| 7 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |