EX_PYRL_EADV_VW(SQL View) |
Index Back |
|---|---|
Employee Payroll Csh Adv View |
| SELECT A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.EMPLID , A.PAYCHECK_NBR , A.ACCOUNTING_DT , A.BASE_CURRENCY_BNK , A.PYMNT_SELCT_STATUS , A.EX_PYRL_STATUS FROM PS_EX_ADVNCE_PYMNT A WHERE A.EX_PYMNT_TYPE = 'A' AND A.EX_PYMNT_DEST = 'P' AND NOT EXISTS ( SELECT 'X' FROM PS_EX_SHEET_PYMNT B WHERE B.EX_PYMNT_TYPE = 'E' AND B.BANK_SETID = A.BANK_SETID AND B.BANK_CD = A.BANK_CD AND B.BANK_ACCT_KEY = A.BANK_ACCT_KEY AND B.EX_PYMNT_DEST = A.EX_PYMNT_DEST AND B.PAYCHECK_NBR = A.PAYCHECK_NBR AND B.ACCOUNTING_DT = A.ACCOUNTING_DT) GROUP BY A.BANK_SETID, A.BANK_CD, A.BANK_ACCT_KEY, A.EMPLID, A.PAYCHECK_NBR, A.ACCOUNTING_DT, A.BASE_CURRENCY_BNK, A.PYMNT_SELCT_STATUS, A.EX_PYRL_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 3 | 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 |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | PAYCHECK_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Paycheck Number |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 8 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid |
| 9 | EX_PYRL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Expense Payroll Status
F=Confirmed by Payroll N=None P=Published to Payroll R=Rejected by Payroll T=In Process V=Reversal |