EMPLIDEFFDTDefault Value: %date
PRIORITY$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
C=Completed
N=Not Submitted
P=Pending
R=Rejected
S=Submitted
A=Amount
B=Balance of Net Pay
P=Percent
PY_ACTIV_DIR_VW(SQL View) |
Index Back |
|---|---|
Active Direct DepositsLsit of active direct deposits |
| SELECT A.EMPLID ,A.EFFDT ,A.PRIORITY ,A.NICK_NAME ,A.ACCOUNT_NUM ,A.ACCOUNT_TYPE ,G.XLATLONGNAME ,A.PRENOTE_STATUS ,G1.XLATLONGNAME ,A.COUNTRY_CD , A.BANK_CD , A.BRANCH_EC_CD , A.AMOUNT_PCT , A.DEPOSIT_TYPE ,G2.XLATLONGNAME ,A.LAST_UPDATE_DATE ,A.DEPOSIT_AMT ,A.PRENOTE_REQD FROM PS_DIR_DEP_DISTRIB A ,PS_DIRECT_DEPOSIT C , PSXLATITEM G , PSXLATITEM G1 , PSXLATITEM G2 WHERE A.EMPLID=C.EMPLID AND A.EFFDT=C.EFFDT AND C.EFF_STATUS='A' AND C.EFFDT=( SELECT MAX(C1.EFFDT) FROM PS_DIRECT_DEPOSIT C1 WHERE C.EMPLID=C1.EMPLID AND A.EMPLID=C1.EMPLID) AND G.FIELDNAME = 'ACCOUNT_TYPE' AND G.FIELDVALUE = A.ACCOUNT_TYPE AND %EffdtCheck(PSXLATITEM, G, %CurrentDateIn) AND G.EFF_STATUS = 'A' AND G1.FIELDNAME = 'PRENOTE_STATUS' AND G1.FIELDVALUE = A.PRENOTE_STATUS AND %EffdtCheck(PSXLATITEM, G1, %CurrentDateIn) AND G1.EFF_STATUS = 'A' AND G2.FIELDNAME = 'DEPOSIT_TYPE' AND G2.FIELDVALUE = A.DEPOSIT_TYPE AND %EffdtCheck(PSXLATITEM, G2, %CurrentDateIn) AND G2.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | PRIORITY |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 4 | NICK_NAME | Character(20) | VARCHAR2(20) NOT NULL | Nick Name for Direct Deposit Accounts |
| 5 | ACCOUNT_NUM | Character(17) | VARCHAR2(17) NOT NULL | Account Number |
| 6 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense |
| 7 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 8 | PRENOTE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Prenotification Status
C=Completed N=Not Submitted P=Pending R=Rejected S=Submitted |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 11 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 12 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 13 | AMOUNT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percent Amount |
| 14 | DEPOSIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount B=Balance of Net Pay P=Percent |
| 15 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 16 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |
| 17 | DEPOSIT_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Amount in Dollars |
| 18 | PRENOTE_REQD | Character(1) | VARCHAR2(1) NOT NULL | Prenotification Reqd |