CC_CARD_ROLE(SQL Table) |
Index Back |
|---|---|
ProCard User RolesDate Initials Ref# Description 29/08/2023 SS PSFTPO-13581 We ensured that to show legal name in EMPLID prompt as part of preferred name feature enhancement |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE |
| 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: CC_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 | CC_USE_ON_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Requester Default
Y/N Table Edit Default Value: N |
| 7 | CC_USE_ON_PO | Character(1) | VARCHAR2(1) NOT NULL |
Buyer Default
Y/N Table Edit Default Value: N |