OPRIDEMPLIDPrompt Table: EX_EE_AUTH_VW
NAMEPYMNT_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_PMT_ESRC_VW2(SQL View) |
Index Back |
|---|---|
Employee Pymnt Search - Admin |
| SELECT C.AUTHORIZED_OPRID , A.EMPLID , B.NAME , A.PYMNT_ID_REF , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_ID , A.CREATION_DT FROM PS_PAYMENT_TBL A , PS_PERSONAL_DATA B , PS_EX_EE_AUTH_TBL C WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND A.REMIT_VENDOR = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EX_EE_AUTH_VW |
| 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 |
| 9 | CREATION_DT | Date(10) | DATE | Creation Date |