EMPLIDPrompt Table: PEOPLE_SRCH
$=Issue Check
C=Checking
L=Liability
N=Non Applicable
S=Savings
X=Expense
REFUND_DISTR_VW(SQL View) |
Index Back |
|---|---|
Dir Dep Distribution VWStudent Records view joing the SRVC_IND_DATA and SERVICE_IMPACT tables. |
| SELECT a.emplid ,a.account_type FROM PS_DIR_DEP_DISTRIB a , ps_direct_deposit b WHERE a.emplid = b.emplid AND a.effdt = b.effdt AND b.eff_status = 'A' AND a.effdt=( SELECT MAX(b1.effdt) FROM PS_DIR_DEP_DISTRIB b1 WHERE b1.emplid = a.emplid AND b1.account_type = a.account_type AND b1.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Account Type
$=Issue Check C=Checking L=Liability N=Non Applicable S=Savings X=Expense |