SSF_RFND_DD_VW

(SQL View)
 Index Back

Direct Deposit View

Current, active direct deposit distributions

SELECT A.COMMON_ID , A.SA_ID_TYPE , A.PRIORITY , A.SSF_BANK_ACCT_ID , A.DEPOSIT_TYPE , A.DEPOSIT_AMT , A.AMOUNT_PCT FROM PS_SSF_BNKACCT_REF A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SSF_BNKACCT_REF A1 WHERE A.COMMON_ID = A1.COMMON_ID AND A.SA_ID_TYPE = A1.SA_ID_TYPE) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_SSF_BNKACCT_REF A2 WHERE A2.COMMON_ID = A.COMMON_ID AND A2.SA_ID_TYPE = A.SA_ID_TYPE AND A2.EFFDT = A.EFFDT) AND A.ACCT_STATUS ='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
2 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
3 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
4 SSF_BANK_ACCT_ID Number(3,0) SMALLINT NOT NULL Unique Bank Account Identifier. It is a sequence number field, unique by COMMON_ID, SA_ID_TYPE.
5 DEPOSIT_TYPE Character(1) VARCHAR2(1) NOT NULL Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
6 DEPOSIT_AMT Number(11,2) DECIMAL(10,2) NOT NULL Amount in Dollars
7 AMOUNT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Amount