EMPLIDPrompt Table: EX_EE_AUTH_VW
SHEET_IDNAMEPYMNT_ID_REFSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
BANK_CDPrompt Table: EX_PYFRM_BNK_VW
BANK_ACCT_KEYPrompt Table: EX_PYFRM_ACC_VW
PYMNT_IDEX_RVPMT_SES_VW(SQL View) |
Index Back |
|---|---|
SE Payments/SheetLinePayments by Expense Sheet Line. Used by EX PTSF Search Review Payments Related Action. |
| SELECT DISTINCT A.EMPLID , C.SHEET_ID , B.NAME , A.PYMNT_ID_REF , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_ID FROM PS_PAYMENT_TBL A , PS_PERSONAL_DATA B , PS_EX_SHEET_PYMNT C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND B.EMPLID = C.EMPLID AND A.BANK_SETID = C.BANK_SETID AND A.BANK_CD = C.BANK_CD AND A.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND A.PYMNT_ID = C.PYMNT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EX_EE_AUTH_VW |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | NAME |
Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | PYMNT_ID_REF |
Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 5 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 6 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: EX_PYFRM_BNK_VW |
| 7 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: EX_PYFRM_ACC_VW |
| 8 | PYMNT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |