CC_SEC_VW(SQL View) |
Index Back |
|---|---|
Procard Security View |
| SELECT A.OPRID , A.EMPLID , B.CREDIT_CARD_VENDOR , B.CRDMEM_ACCT_NBR , C.NAME , B.BUSINESS_UNIT , D.PROCESS_INSTANCE , %subrec(kk_tran_sbr,D) FROM PS_CC_SEC_TBL_EX A , PS_CC_CARD_DATA_EX B , PS_PERSONAL_DATA C , PS_CC_TRANS_LINE D WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND B.EMPLID = D.EMPLID AND B.CREDIT_CARD_VENDOR = D.CREDIT_CARD_VENDOR AND B.CRDMEM_ACCT_NBR = D.CRDMEM_ACCT_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 3 | CREDIT_CARD_VENDOR |
Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
| 4 | CRDMEM_ACCT_NBR |
Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 8 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Default Value: V |
| 9 | KK_AMOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic |
| 10 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 11 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
| 12 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |